FOG WebGUI logviewer server error 500
-
I actually intended to make a thread about an apache error in relation to mysql (something about /nMySQL in line 40 and 52 of node.php if I remember accurately) I noticed popping up several times, but now I can’t access the logs on the WebGUI because of a server 500 error.
Upgraded to latest version a few minutes ago hoping it might fix it, rebooted server but still nothing.
I’ve used the search function on the forums to try and find out a bit more, ownership is set to www-data properly.
Any ideas on where I should start to look?
As for the error I mentioned earlier, I located the file manually, here it is:
7] PHP Warning: mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Jan 20 13:50:44.021697 2016] [:error] [pid 1358] [client 192.168.1.29:51277] PHP Warning: mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52EDIT: Clients are now also unable to update the database when I upload an image.
-
try to restart apache and mysql.
On Debian and Ubuntu, the error log is located at
/var/log/apache2/error.logyou can monitor this file from CLI by issuing
tail -f /var/log/apache2/error.logand while that’s going, try to access the web interface. You should see some error output in the terminal.How do you go from a few minor errors to a server 500 error? what happened?
-
@Wayne-Workman There seems to be a new apache error:
[Wed Jan 20 14:41:04.711486 2016] [:error] [pid 2227] [client 192.168.1.29:52272] PHP Fatal error: Uncaught exception 'Exception' with message 'FOGFTP: Login failed. Host: 192.168.1.156, Username: fog, Password: password, Error: ftp_login(): Login incorrect.' in /var/www/html/fog/lib/fog/fogftp.class.php:29\nStack trace:\n#0 /var/www/html/fog/lib/pages/fogconfigurationpage.class.php(637): FOGFTP->connect()\n#1 [internal function]: FOGConfigurationPage->log()\n#2 /var/www/html/fog/lib/fog/fogpagemanager.class.php(67): call_user_func(Array)\n#3 /var/www/html/fog/management/index.php(24): FOGPageManager->render()\n#4 {main}\n thrown in /var/www/html/fog/lib/fog/fogftp.class.php on line 29, referer: http://192.168.1.156/fog/management/?node=aboutRestarting the services doesn’t help.
I have been adding a few new hosts and capturing a few images, it was working fine yesterday.
Mysql service status complains about error logs after starting:
Jan 20 16:28:56 fogserver mysqld_safe[10167]: 160120 16:28:56 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error...e effect.``` -
@Quazz Have you tried to re-run the installer?
-
@Wayne-Workman There were no errors in the installer, but I see there’s a new version so I’ll try updating, fingers crossed.
-
@Quazz If you just go to your servers IP address, do you see the apache test page?
-
@Wayne-Workman Yes, the WebGUI works fine for the most part, only discovered this with the log viewer specifically.
-
@Quazz said:
@Wayne-Workman Yes, the WebGUI works fine for the most part, only discovered this with the log viewer specifically.
I was under the impression that your FOG server’s web interface was not functioning.
-
@Quazz When you’re getting the error 500, it’s referring to mysql error in the apache error log?
The mysql errors, often times, are from an upgrade action, thought they could be done by anything really.
The ftp_login error you’re seeing is most likely the culprit, though I’m pretty sure I have some rigid checks. That’s not to say I didn’t miss something, but at least we have something to look forward to.
My guess, the password is not really “password”? The ftp user and password are the local fog server’s user and password.
FOG Creates a user fog, on it’s own and generates a password for the user. This password should never be ‘password’. Of course you’re likely blocking the actual password for security reasons?
-
@Tom-Elliott I copied the info as is. That’s webgui login information, I haven’t altered anything to do with FTP passwords, they’re all stil set to what they were weeks ago in .fogsettings as well, so I’m not even sure how that would have happened.
At any rate, I’ll recheck all the ftp passwords and report back below.
I reentered the password for the fog storage node and now the error log viewer is back, good call Tom!
I’m guessing this is also why the clients were unable to update the database.
That just leaves the minor errors about mysql outlined in the original post.
Thank you already for you help
-
@Quazz said:
I reentered the password for the fog storage node and now the error log viewer is back, good call Tom!
@Tom-Elliott can we get some checks for that, so this doesn’t break the log viewer?
