Database issue on latest trunk
-
@Bob-Henderson Is this a storage node, or main server?
-
Main server, stand alone. Was working fine until I did the update.
Adding in the host and username resolved the issue instantly.
-
@Bob-Henderson and what displays in the /opt/fog/.fogsettings file for the snmysqlhost and snmysqluser information?
-
Yep, nothing is over 35% used.
-
Well, that’s odd, those are all blank. No user, pass, host.
It has all my other settings still, like IP and password and such.
-
@Bob-Henderson I’m asking to help you.
Please enter your information. ON Main server, the snmysqlhost should be
'127.0.0.1'
snmysqluser should be'root'
snmysqlpass (unless you set a password) should be'' -
@Bob-Henderson I dont know if tom agree with that but i find out these fields :
snmysqluser=‘root’
snmysqlhost=‘127.0.0.1’
-
I’ve put those in now, and had verified that if I put them into config.class.php manually, I got database connection back as well.
So we’ve figured out what broke, but I’m sorta confused as to why it happened in the first place? I appreciate the help, just wouldn’t want someone else to update and get the same issue.
-
I just went and updated another node via git as well, and it did the same thing. It appears it wipes out the SQl settings in the fogsettings file. Adding them back in fixes it, but obviously isn’t what we’d want.
-
@Bob-Henderson I don’t think it’s wiping them out. It simply has no idea how to handle it from the prior config. I’ll see if I can make some better guesses though.
-
Should be fixed in latest…hopefully.
-
no dice. Just updated the testing node to 8138, same issue. Putting the info back in config.class.php gets connection back, but it didn’t have them originally.
-
@Bob-Henderson and now after another update?
-
-
CentOS 7?
sudo su -
setsebool -P httpd_can_network_connect 1 -
@cnewman402 This thread is two months old and has been solved. Do you have a similar problem?
Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
Daily Clean Installation Results:
https://fogtesting.fogproject.us/
FOG Reporting:
https://fog-external-reporting-results.fogproject.us/ -
@Wayne-Workman I did have a similar problem in CentOS7. I used a standard security deployment which lead me to the exact issue in this thread. I resolved this by running the command I posted. Sorry for replying to an old thread. I landed here via google, and thought I should contribute.
-
@cnewman402 The OP had an issue because the fog installer at the time was clearing his db settings in .fogsettings. I appreciate you contributing, but this thread isn’t related to SELinux. Maybe make a blurb in the tutorials area?
