MySQL errors after installing FOG

Recently, I converted a decently spec’d terminal server into an ESXi server after doing a P2V on the TS. After that, it was time to play. I installed a fresh copy of Ubuntu 9.04 server and then installed FOG. If you don’t know what FOG is, you may want to read FOG’s overview here. Once I got it all installed I kept getting an error when connecting to the web-based management interface. I have pasted in the error and resolution below, including credit on the source of the resolution.

–Himuraken

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘root’@’localhost’ (using password: NO) in /var/www/fog/management/index.php on line 34
Unable to connect to Database

I am not sure what else to tell you from here, I am at a standstill. Thanks for any help you can offer up.

RE: Problem with mySQL database after install
By: microleaks (microleaksProject AdminAccepting Donations) – 2008-02-06 15:52
All you need to do is go to /var/www/html/fog/commons/config.php and change the mysql password in that file you match whatever you set it as.

Linux Administration Tool – webmin

For anyone that is not a Linux command-line expert (myself included!) webmin is an invaluable tool. A very quick install of this allows advanced administration from any web browser that can access the IP address of the server. Version 1.480 is the current release. Check it out and you will be pleasently surprised…

Instructions provided here are specifically for Ubuntu but can be adapted for any distro. (thanks to Himuraken for the proper syntax)

1.sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl libmd5-perl
2.wget http://prdownloads.sourceforge.net/webadmin/webmin_1.480_all.deb
3.sudo dpkg -i webmin_1.480_all.deb
4: open web browser, point to IP address of server on port 10000

For more info: Webmin

GDesklets won’t run in Ubuntu 7.10 Gutsy Gibbon

After a clean install/upgrade of Ubuntu 7.10 (Gutsy Gibbon) you may be unable to get gdesklets to run. I have noticed several threads out there with no resolution so I thought I would post a fix. Most users will get the app installed successfully but when they run the gdesklets shell, the app begins to load, goes gray, and then has to be closed using force quit. Also, running gdesklets start from a console shows that the daemon is starting but it never does. By default Gutsy Gibbon uses Python 2.5 while gdesklets is looking for 2.4. This is pretty straight forward to resolve using these steps. Install python2.4 by running sudo apt-get install python2.4 from a console. After that is complete we need to tell gdesklets to use Python2.4. From the console we need to add a few entries to the gdesklets config files. Locate the line that says “#! /usr/bin/env python” and append it with a 2.4. So each line should now look like “#! /usr/bin/env python2.4”. This line needs to be updated at the top of each of the files listed below.

/usr/lib/gdesklets/gdesklets
/usr/lib/gdesklets/gdesklets-shell
/usr/lib/gdesklets/gdesklets-daemon
/usr/lib/gdesklets/gdesklets-migration-tool

After updating the files with your favorite text editor, start the app by running gdesklets start from a console. This should have you up and running in no time.

–himuraken