You are currently browsing the archives for December 2011.
Displaying 1 - 2 of 2 entries.

PostgreSQL, Perl and Ubuntu

  • Posted on December 25, 2011 at 22:59

Make it work

# apt-get install postgresql postgresql-contrib
# apt-get install libpq-dev
cpan> install DBD::Pg
$ sudo su postgres -c psql template1 template1=# ALTER USER postgres WITH PASSWORD 'password'; template1=# \q
$ sudo passwd -d postgres
$ sudo su postgres -c passwd
$ sudo su postgres -c psql < /usr/share/postgresql/8.4/contrib/adminpack.sql

From iPhone to Galaxy: MP3

  • Posted on December 25, 2011 at 19:39

Since I am pretty damn disappointed in my iPhone (thanks to Apple, who took my freedom), I decided, although it hurt, to put aside this infernal machine and switch to a Samsung Galaxy ACE. Imagine how desperate I was!

But first I had to copy over my stuff! Let’s start with the music…
It’s really easy, just follow this the next thousand steps!


  • Install Apple Developer Tools
  • Install MacPorts (
  • Install sshfs
    ($ sudo port -v install sshfs)
  • Jailbrake your iPhone (
  • mount your iPhone using sshfs, asuming your iPhone has IP:
    ($ mkdir /Volumes/iPhone; sudo sshfs root@ /Volumes/iPhone)
  • Create a temporary directory for your Music
    (mkdir ~/Desktop/mp3s)
  • Copy your precious music
    (cp -v `find /Volumes/iPhone/private/var/mobile/Media/iTunes_Control/Music -iname \*\.mp3` ~/Desktop/mp3s/.
  • Install WinAmp for OS X (download here)
  • Connect your Galaxy ACE to your Mac using USB
  • Make the MicroSD-card available for writing on your ACE
    (if everything goes well, your WinAmp will see the SD-card as a storage-medium)
  • Import your Music (from ~/Desktop/mps3s) in WinAmp
  • Select all the Music, right click and select “Send selection to Devices:ACE”
    (or whatever you called your microSD-card)

And that’s all! 🙂