Posts made by SaxxAppeal

I had this same issue on my last reinstall, and corrected it.

First, as WolfBane said, you must make sure if you set a MySQL password, you update your config.php file.

Other than that, the fix that worked for me for this issue was to stop and start the MySQL service. After that it works fine. Try running the following in Terminal:
[CODE]sudo service mysql stop
sudo service mysql start[/CODE]

If you go to the web interface after this, click next on the database schema update page, does it let you go on? If yes, then see my permanent fix for this solution [URL=‘http://fogproject.org/forum/threads/mysql-problem-what-am-i-doing-wrong.10515/#post-27515’]here[/URL].

Hope this works for you, let us know!

Using DNSMasq with FOG can be a little tricky, since FOG 1.0.1 switched to iPXE. Any documentation you find about setting it up that isn’t from the last month or so won’t help you… I was able to get a custom chainloaded menu set up, it works really great for my purposes (besides FOG, I PXE Boot live CD LINUX distros, WinPE, and some recovery tools). I followed some of the steps [URL=‘http://fogproject.org/forum/threads/dnsmasq-help-for-ipxe-stuff.10222/’]here[/URL], check it out… IF you have any questions, I’m happy to help. Good luck!

Okay, here’s my crude but functional workaround…

Since I figured the problem is that the mysql service was being locked out of a file it needed, and restarting the service completely fixes the issue, I changed my Ubuntu server to stop and start the mysql service after boot up. Fairly simple procedure, just do the following:

[CODE]sudo nano /etc/rc.local
[/CODE]

In this file, above “exit 0”, type “service mysql restart” (no quotes).

Ctrl X to exit, Y to save, Enter to save to same file.

From that point forward, every time your server reboots, it will automatically bring down and up the SQL service, solving the “Unable to connect to database” error.

Hope this helps someone out there, let me know if anything is unclear!

I’m currently working on different workarounds to resolve this issue. It might be one of those infamous MySQL bugs that sneaks into their releases… Or it might have something to do with the way FOG or the Ubuntu server is loading up services. As far as I can see, a file is being locked from access, and as soon as FOG can’t see it, the “Unable to connect to database” message pops up.

Reuben (and anyone else reading), if you need any help with any of your setup, let me know, I’m glad to help. I’ve set FOG up in a number of different networking environments, and on a few different operating systems…

Update on my own post:
For whatever reason, if I run ‘sudo service mysql stop’, then ‘sudo service mysql start’, everything works perfectly until next reboot. I can add the stop and start to a startup script for my server if need be. Is anyone else experiencing this bug?

Hello all, I’m trying to figure out a very frustrating issue with my FOG setup. I set up Ubuntu 14 Server from scratch (VirtualBox), and generally followed the instructions [URL=‘http://community.spiceworks.com/how_to/show/78110-fog-1-0-0-on-ubuntu-server-14-04’]here[/URL]. Once FOG 1.0.1 finishes installing, I am able to access it via a web browser, and I everything seems to work fine. After 4-7 minutes, I get the “Cannot connect to database.” message. I’ve been using FOG 0.32 for quite some time, and I’ve triple checked all of the locations where the MySQL password should be, all is well… Is there another location I am missing that also needs to be updated, or can this be another issue entirely?

I re-tried the installation about 20 times in the past 2 days, all with the same result. I’ve tried different versions of Ubuntu as well, same problem. I have FOG 0.32 running successfully on another VirtualBox, so I know it works for me virtually.

Can anyone shed some light, PLEASE???

Thanks everyone!!