I started over again by rebuilding OS. The web interface is quite nice so it was easy selecting ubuntu 7.10 to start over. Now I'm back to LAMP instead of LEMP.
After rebuilding the OS logging in was a problem, something new learnt. The RS key fingerprint of the server wasn't retained hence I couldn't login. More reading from here which tells me how SSH host key protection works. I have to clear fingerprint left over at
/.ssh/known_hosts in order to get in.
After that installing LAMP wasn't difficult as I have successful steps written down in this entry.
Not really I found. Installation of
mysql-server wasn't OK and I got
failed on starting. The error was
E: Sub-process /usr/bin/dpkg returned an error code (1). From the VPSLink forum I found the solution, i.e. it is a InnoDb memory related issue which requires more memory of server to run. Workaround is to disable InnoDb by uncommenting
/etc/mysql/my.cnf. Reading what Innodb is from here I don't think it's needed at my sites.
Now I have
phpmyadmin working and a test WP site running latest svn revision at blog.example.com.
- install Habari at another subdomain
- Install firewall
- import database WP & Habari to see if they run OK
- optimize LAMP for this small VPS Plan