PHP Issue with FOG installer using most recent SVN (as of 4:43) on CentOS 7

[saistrop]

Hey again guys,
I got a second staging machine set up just to test more recent SVN channels, and when I installed the newest one, I keep running into an issue where once I run the install script and go to the Database Updater page, it just navigates to a blank page. Did some digging in the error_log file in httpd, came across an issue with the MySQL database not being able to be access by root using no password. I did run the secure install and removed root access and such, do I need to re-enable that or is there a way to work around it? Thanks.

[Tom Elliott]

Did you create another user for mysql and control of mysql?

[saistrop]

I created a user ‘fog’ for the DB, do I need to give it full access? If so I’ll try that and report back once it finishes.

[saistrop]

Well I tried giving full access to the fog user, but no dice. What would I need to remove in order to attempt another fresh install? And should I upgrade to the newest SVN if one has been released since then?

[Wayne Workman]

@saistrop said:

Well I tried giving full access to the fog user, but no dice. What would I need to remove in order to attempt another fresh install? And should I upgrade to the newest SVN if one has been released since then?

can you log into MySQL from CLI? What user / password do you use? Can you guess at that until you figure it out?

and about updating, if you’re using FOG in production, I’d recommend updating out of need, only. Unless FOG is virtualized. If it’s virtualized, then snapshot and update whenever you feel like it - you can always roll back to the snapshot.

[saistrop]

I can log in as root with password, should I create a fog user and set it to the same password as the fog user and give that user full access to the DB? My current svn version is 4256 if that gives you any further help.

[Wayne Workman]

@saistrop said:

I can log in as root with password, should I create a fog user and set it to the same password as the fog user and give that user full access to the DB? My current svn version is 4256 if that gives you any further help.

Or you can just tell fog to use the root user and root password.

[saistrop]

Where in the setup process would I tell it to use that? I didn’t see it earlier, may have overlooked it.

[Wayne Workman]

@saistrop look in this file:

/opt/fog/.fogsettings

There is a spot there where you’d put it, then just reinstall using the installer you already have.

[saistrop]

Will try that and report back. Thanks guys, you’re always incredibly helpful with issues like this (even if it is likely user error)

[sudburr]

@saistrop said:

 once I run the install script and go to the Database Updater page, it just navigates to a blank page.

This is what I’m hitting too in my thread.

[saistrop]

Well I ended up doing a fresh install of FOG (wiped existing FOG files and set it up again) and during setup I provided the password for MySQL this time. I have a GUI, so I’m going to continue testing and see if I hit any other issues.