Wednesday, December 29, 2010

Cydia 'unable to parse package file'

Cydia error:

Unable to parse package file /var/lib/apt/lists/cydia.xsellize.com_. _Pacakges.IndexDiff (1)

SSHing into phone and deleting the file fixes it.

Monday, December 27, 2010

Amarok PHP and mYSQL

 <?php  
 //charset=utf-8 makes it so unicode output doesn't get gobbled up by browser  
 header("Content-type: text/html; charset=utf-8");  
 echo '<p>Youri\'s id3v2 script</p>';  
   
   
 //connect to mysql and select amarokdb  
 $link=mysql_connect("localhost", "username", "password") or die(mysql_error());  
 echo "Connected to MySQL<br />";  
 mysql_select_db("amarokdb") or die(mysql_error());  
   
 echo "Connected to Database<br />";  
   
 //this makes the mysql db play well with utf8  
 mysql_set_charset('utf8',$link);  
   
   
 //globally retrieve all variables in the url string  
 $variable = $_GET['what'];  
 $bitratevariable = $_GET['bitrate'];  
 $coversaction = $_GET['coversaction'];  
 $idofartist= $_GET['idofartist'];  
 $artistName= $_GET['artistName'];  
   
   
 //navigation  
 echo "<a href=?what=bg1cd>Look for albums that have a CD num set</a> <br />";  
 echo "<a href=?what=blt128>Look for tracks with bitrate lower than 128kbps</a> <br />";  
 echo "<a href=?what=covers&coversaction=lookup>Look up covers</a> <br />";  
 echo "<a href=?what=nulltracknum>Look for tracks with no tracknumber set</a>";  
 echo '<br/><br/>';  
 echo "Look up bitrates<br />";  
   
 echo "[<a href=?what=bitrate&bitrate=128>128</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=160>160</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=192>192</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=256>256</a>] ";  
 echo "[<a href=?what=bitrate&bitrate=320>320</a>] ";  
 echo '<br/><br/>';  
   
   
   
 //return the artist's name when an artist iD is passed  
 function getArtist($artistnum)  
 {  
      $artist = mysql_query("SELECT * FROM `artists` where `id` = $artistnum");  
      while ($row = mysql_fetch_array($artist))   
      {  
           return $row{'name'};  
      }  
 }  
   
 //returns the album's name when an album id is passed  
 function getAlbum($albumnum)  
 {  
      $album = mysql_query("SELECT * FROM `albums` where `id` = $albumnum");  
      while ($row = mysql_fetch_array($album))   
      {  
           return $row{'name'};  
      }  
        
   
 }  
   
 //this lists all the artists in the database except for various artists  
 function listArtists()  
      {  
   
 //select UNIQUE artist ID's from a join table of artists and album (join by referencing artists id column with albums artist column  
 /*  
 artists      albums      
 ID NAME     NAME      ARTIST  
 88 ARTIST     ALBUM     88  
 */  
   
        $result = mysql_query("select distinct artist from artists join albums on albums.artist=artists.id ORDER BY `artists`.`name`");  
   
   
 //walk through the result and pull artist id and artistname  
      while ($row = mysql_fetch_array($result))   
      {  
 //urlencode for spaces in artists and utf8 artists  
           $artistID = $row{'artist'};  
           $artistNameSQL=getArtist($artistID);  
           echo "<a href=?what=covers&coversaction=getArtistAlbums&idofartist=$artistID&artistName=",  
           urlencode($artistNameSQL),  
           ">$artistNameSQL</a><br />";       
              
   
      }  
      }  
        
        
   
   
 //listallalbums belonging to artist ID when given an artist ID       
 //artistname is passed only for html output  
 function listAlbumsById($idofartist,$artistName)  
      {  
        
        
      $albums = mysql_query("SELECT * FROM `albums` where `artist` = $idofartist" );  
        
           echo "<strong>$artistName</strong><br />";  
           while ($row = mysql_fetch_array($albums))   
           {  
           $album = $row{'name'};  
        
 //amarok stores album covers by getting and md5sum hash of lowercased artist and album  
 //mb_strtolower works on unicode white strtolower doesn't  
           echo "<div style=\"display: inline-block\">";  
           echo "$album<br />";  
           echo "/home/youri/.kde4/share/apps/amarok/albumcovers/large/",md5(mb_strtolower("$artistName$album",'UTF-8')),"<br/>";  
           echo "<img width=500px src=./albumcovers/",md5(mb_strtolower("$artistName$album",'UTF-8')),"><br/>";  
           echo "</div>";  
           }  
        
      }  
   
   
 if ($variable=="bg1cd")  
 {  
      $result = mysql_query("SELECT * FROM `tracks` WHERE `discnumber` IS NOT NULL");  
      while ($row = mysql_fetch_array($result))   
      {  
           $artist = getArtist($row{'artist'});  
           $album = getAlbum($row{'album'});  
           echo "$artist - $album <br />";  
      }  
   
 }  
   
 elseif ($variable=="blt128")  
 {  
        
      $result = mysql_query("SELECT * FROM `tracks` WHERE `bitrate` < 128 ORDER BY `tracks`.`artist` ASC");  
      $num_rows = mysql_num_rows($result);  
   
      echo "$num_rows Tracks<br /><br />";   
        
           while ($row = mysql_fetch_array($result))   
      {  
           $artist = getArtist($row{'artist'});  
           $album = getAlbum($row{'album'});  
           $tracknumber = $row{'tracknumber'};  
           $title = $row{'title'};  
           $bitrate = $row{'bitrate'};  
           echo "$artist - $album - $tracknumber - $title [$bitrate]<br />";  
      }  
 }  
   
 elseif ($variable=="bitrate")  
 {  
   
      $result = mysql_query("SELECT * FROM `tracks` WHERE `bitrate` = $bitratevariable");  
      $num_rows = mysql_num_rows($result);  
        
      $totaltrax = mysql_query("SELECT * FROM `tracks`");  
      $num_rows_total = mysql_num_rows($totaltrax);  
        
      echo "$num_rows Tracks are $bitratevariable kbps ";   
      echo "out of a $num_rows_total total tracks<br />";  
        
      $percentage=($num_rows/$num_rows_total *100);  
        
      echo "Which equals: ";  
      echo number_format($percentage, 1)."%<br/>";  
   
   
 }  
   
 //if covers is called with lookup, list artists  
 //if covers is called with get artistalbums, then get artist's albums  
 elseif ($variable=="covers")  
 {  
   
   
      if ($coversaction == "lookup" )  
      {  
           listArtists();  
      }  
        
      elseif ($coversaction == "getArtistAlbums" )  
       {  
         
        
       listAlbumsById($idofartist,$artistName);  
         
       }  
   
 }  
   
   
   
 elseif ($variable=="nulltracknum")  
 {  
      $result = mysql_query("SELECT * FROM `tracks` where `tracknumber` is null");  
      while ($row = mysql_fetch_array($result))   
      {  
      $artist = getArtist($row{'artist'});  
      $album = getAlbum($row{'album'});  
      $title = $row{'title'};  
      }  
   
 }  
 ?>  

Sunday, December 26, 2010

iPhone 3GS log.

Jailbreak:

3GS 16GB jailbroken with spirit.

Spirit2pwn (old bootroom) -> sn0wbreeze -> 4.1

(Change hosts file/must have shsh for 4.1 saved)


Unlock:

Cydia -> Search -> ultrasn0w -> install


Installous:

Cydia -> Manage -> Edit -> Add -> cydia.hackulo.us
Cydia -> Search -> Installous -> Install


SSH

Change default passwords:

ssh mobile@192.168.1.6 (default passwd: alpine)
passwd
su root
passwd


TomTom

Mount iPhone under gnome, copy and paste tomtom 1.6 ipa onto filesystem.

ssh to phone as root

mv /var/mobile/Media/tomtom1.6.ipa /var/mobile/Documents/Installous/Downloads/

Go to installous and downloads and install ipa.

Favorites/settings restore:

iPhone:/private/var/mobile/Applications/D59505E5-17DF-4B2D-AD2A-73729133B4FC/Documents/USA, Canada, & Mexico mobile$ mv /User/Media/mapsettings.cfg ./


Apps: 

  • Camera Plus Pro
  • Skype
  • Google Voice
  • Calling Card
  • TomTom
  • iWebcamera
  • OPlayer
  • Ustream Broadcaster
  • iSSH
  • iFile
  • Atomic Web

Tweaks:

  • Winterboard
  • Silent Camera Theme
  • Glasklart Classic 4.0
  • SBSettings
  • SBSettings Glasklart theme
  • Glasklart Battery theme 
  • User Wallpaper
  • User Lock Wallpaper
  • Five Icon Dock
  • Volume Boost
  • Make it Mine
  • ISHShit 
  • Typophone 4
  • Metadata removr

Change Calling Card Icon:

Find /var/stash/Themes.ZAZeaY/Glasklart%20Icons.theme/Bundles/com.apple.mobilephone/icon.png

Copy it to /var/stash/Themes.ZAZeaY/Youri's Icons/Icons/Calling Card.png

Settings->Winterboard-> Summer Board mode [ON] and enable "Youri's Icons" theme.

Respring.


Rename Applications

Add cydia source http://cydia.myrepospace.com/Tw1zTiD-Chris2
Install rename II
Respring


LockInfo

Add cydia repo http://www.sinfuliphonerepo.com
Lockinfo

HTC plugin

iAdKiller

Add cydia repo http://cydia.xsellize.com/
Install iAdKiller


Screenshot

Saturday, December 18, 2010

phpMyAdmin collated db in utf8_bin shows hex data instead of UTF8 text

Expanding options and setting 'show binary contents' then pressing 'Go' fixes it.

and $cfg['DisplayBinaryAsHex'] = false;

 in /usr/share/webapps/phpMyAdmin/config.inc.php

Friday, December 17, 2010

CLRF characters in my PKGBUILD!

makepkg
==> ERROR: PKGBUILD contains CRLF characters and cannot be sourced.


Solution:

sed -i 's/^M//' PKGBUILD

[ctrl+v][ctrl+m] for the ^M symbol.

Thursday, December 16, 2010

Control amarok through dbus with SSH.

 The session needs to know $DBUS_SESSION_BUS_ADDRESS, so get that first and then run qdbus.

export DBUS_SESSION_BUS_ADDRESS=`cat /proc/$(pidof kded4)/environ | tr '\0' '\n' | grep DBUS | cut -d '=' -f2-` ; qdbus org.kde.amarok /Player org.freedesktop.MediaPlayer.PlayPause

Friday, December 10, 2010

Xorg wouldn't start with latest updates.

One of these in my Xorg.0.log after upgrading to latest mesa ati-dri and libgl

[    27.289] 0: /usr/bin/X (xorg_backtrace+0x28) [0x49f1a8]
[    27.289] 1: /usr/bin/X (0x400000+0x60239) [0x460239]
[    27.289] 2: /lib/libpthread.so.0 (0x7f42d79da000+0xf1c0) [0x7f42d79e91c0]
[    27.289] Segmentation fault at address (nil)



Removing 'nomodeset' from /boot/grub/menu.lst fixes it.

Thursday, November 25, 2010

updating phpbb from 3.0.7-pl1 to 3.0.8

navigate to forum dir
#wget http://www.phpbb.com/files/release/phpBB-3.0.7-PL1_to_3.0.8.tar.bz2

#bunzip2  phpBB-3.0.7-PL1_to_3.0.8.tar.bz2

#tar xvf phpBB-3.0.7-PL1_to_3.0.8.tar

go to forum/install & click update tab

'proceed to next step' -> 'update database' -> 'update my database now' -> 'continue the update process now'

'download modified archive'

tar xvf update_3.0.7-PL1_to_3.0.8.tar

rm -r install/

All files are up to date with the latest phpBB version. You should now login to your board and check if everything is working fine. Do not forget to delete, rename or move your install directory! Please send us updated information about your server and board configurations from the Send statistics module in your ACP.

phpmyadmin with arch + lighttpd

install phpmyadmin

#yaourt -S phpmyadmin php-mcrypt

edit lighttpd.conf

add alias.url = ( "/phpmyadmin/" => "/usr/share/webapps/phpMyAdmin/") to  /etc/lighttpd/lighttpd.conf

edit .htaccess

#deny from all to /etc/webapps/phpmyadmin/.htaccess

edit php.ini
open_basedir = /srv/http/:/home/:/tmp/:/usr/share/pear/:/usr/share/webapps/:/etc/webapps
in
/etc/php/php.ini

extension=mcrypt.so
extension=mysql.so

works.

Monday, November 22, 2010

mp3 backup script with rsync

#!/bin/sh


dir="/media/mp3"
ext="mp3"
backupdir="/media/6e6fad14-604b-499f-ac0f-6667aadb478f/MP3S"




find $dir -type f | grep -v \.$ext\$


if [ $? -eq 0 ]
then
echo
echo "Not continuing with backup"
echo "Found non mp3 files"
else


echo "Continuing with backup"
rsync -avur "$dir/" "$backupdir/"
echo "Backup complete"
fi

Saturday, November 20, 2010

Kernel patch that does wonders bash.

Here is how I am doing my bash script.
 (As explained here: www.webupd8.org/2010/11/alternative-to-200-lines-kernel-patch.html)


in ~/.bashrc


if [ "$PS1" ] ; then                                                                                                                               
    mkdir -m 0700 /cgroup/$$
    echo $$ > /cgroup/$$/tasks
    echo 1 > /cgroup/$$/notify_on_release
fi


in /etc/rc.local

mount -t cgroup cgroup /cgroup -o cpu
chmod 0777 /cgroup
echo "/sbin/rm_cgroup" > /cgroup/release_agent
in /sbin/rm_cgroup
#!/bin/sh
rmdir /cgroup/$1
then chmod +x /sbin/rm_cgroup and sudo mkdir /cgroup

Source.

Friday, November 12, 2010

Temporary smplayer/mplayer "subcc" fix.

Came across this with latest mplayer and smplayer

The subcc option must be an integer: -subpos
Error parsing option on the command line: -subcc



Bug report.

Here's my simple work around for now:

changed the 'mplayer executable' setting to /usr/bin/mplayer.rmsubcc in smplayer and put this into mplayer.rmsubcc (and chmod +x /usr/bin/mplayer.rmsubcc).


#!/bin/sh
command=$(echo $* | sed 's/-subcc//g')
/usr/bin/mplayer $command


EDIT:

command=$(echo $* | sed 's/-subcc//g' | sed 's/-aid\ 1/-aid\ 0/g')


will also fix the "MPlayer interrupted by signal 8 in module: demux_open" problem. 


Bug report.

Edit: Fixed in latest SVN

Monday, November 8, 2010

Opening a .psd with gimp

Gimp (2.6.11) wouldn't open a psd file. Had issues with CMYK.


Error loading PSD file: Unsupported color mode: CMYK

This works to convert it to a png:

convert banner.psd -channel rgba -alpha on -colorspace rgb rgb-image.png

convert is part of imagemagick.

Wednesday, November 3, 2010

Yaourt on archlinux changed AUR behavior.

yaourt -Syu --aur used to show aur packages, recently it stopped.

The fix is to replace the line

DETAILUPGRADE=0 classify_pkg $(pacman -Qqm | wc -l)< <(eval $cmd)
to
classify_pkg < <(eval $cmd)
 
in /usr/lib/yaourt/abs.sh
EDIT:

This is now accomplished with
DETAILUPGRADE=2 in /etc/yaourtrc

Thursday, October 28, 2010

Browse blackberry tour sd card from linux.

Plugged my blackberry tour in and I got this in dmesg

usb 1-5: new high speed USB device using ehci_hcd and address 25
scsi8 : usb-storage 1-5:1.1

Nothing in /dev/sd* to mount though.

Fixed it by doing this on the blackberry:

Setup -> Options -> Memory -> Auto Enable Mass Storage Mode When Connected [YES]

And now it's accessible.

Tuesday, October 26, 2010

Chromium hanging on google maps

Chromium (9.0.564.0 (63860) Archlinux) kept hanging on google maps and a few other websites.

Not sure what the deal is but this fixes it until the devs do an overhaul.

chromium --disable-accelerated-compositing


"We're looking into possibly doing an overhaul of the gpu process architecture to resolve this and other related issues. Since accelerated compositing is only going to be a labs feature for M8 and the non-accelerated path isn't affected, I don't think this issue should be marked ReleaseBlock-Beta." 

http://code.google.com/p/chromium/issues/detail?id=58862

Sunday, October 17, 2010

White screen on boot on ubuntu

Ubuntu upgrade to maverick on a dell C640 has a white screen on boot.

1.) Plugged in ethernet cable (wireless doesn't work)
2.) grub recovery mode (netroot: root shell with networking)
3.) Running startx show abi mismatch errors + unable to load drivers
4.) Ran aptitude, it updated some xserver packages
5.) X now starts but it's all trippy colors + low resolution (not using radeon driver)
6.) X also won't let me use keyboard or mouse
7.) Remove and install xserver-xorg-video-radeon
8.) apt-get remove --purge xserver-xorg-core
9.) apt-get install xserver-xorg-core
10.) X starts fine now.

Whatever, ubuntu.

Sunday, October 10, 2010

Iphone as webcam in linux (arch) with webcamstudio and iWebcamera.

First install webcamstudio: http://aur.archlinux.org/packages.php?ID=22708

I use yaourt not pacman so it was:

[youri@nemesis ~]$ yaourt -S webcamstudio

Also need vloopback2 (Not vloopback package but vloopback-svn) http://aur.archlinux.org/packages.php?ID=31446



[youri@nemesis ~]$ yaourt -S vloopback

Now insert the module:

[youri@nemesis ~]$ modprobe vloopback

Install iWebcamera on the iphone and run it.

Make a file iWebcamera.wspl and put this in it:

pipeline=souphttpsrc location=http://192.168.1.6:8080/strm ! jpegec ! ffmpegcolorspace name=tosink

Change the ip (red) to the ip of the iphone.

Run webcamstudio and click on 'sources' then add a folder to scan and select the folder that holds the previously created iWebcamera.wspl file.

Double click the iphone in the Devices list and press "play" on it.

Now it's accessible to the system.





Thursday, October 7, 2010

archlinux dbus causing problems on boot

Kept getting

Starting D-BUS system messagebus Failed to start message bus:

Putting "dbus" in front of "hal" so that it starts first in /etc/rc.conf fixed it.

DAEMONS=( syslog-ng network netfs crond dbus hal fam @sshd @alsa @openntpd @lighttpd)

Saturday, October 2, 2010

Installed phpbb gallery on phpbb3.0.7+lighttpd+archlinux

Step 1: Used automod to upload "phpbb_gallery_1_0_5.zip"

Step 2: Went to http://[mysite]/forum/install

  • Install script didn't work!
  • tail -f /var/log/lighttpd/error_log
  • 2010-10-02 12:00:17: (mod_fastcgi.c.2701) FastCGI-stderr: PHP Fatal error:  Call to undefined function gd_info() in /home/youri/public_html/cfljc/forum.old/install/install_install.php on line 156
  • edit /etc/php.ini and uncomment "extension=gd.so"
  • install php-gd: yaourt -S php-gd
  • sudo /etc/rc.d/lighttpd restart
Step 3: Install script worked

Step 4: rm -r public_html/forum/install

And the gallery works.