Failed to connect to database server, will try again in next iteration.

mpmackenna · Jan 30, 2012, 7:23 PM

[LEFT][COLOR=#333333]I have the below error over and over again in my FOG log viewer. I checked to see if my /var/www/fog/commons/config.php file had the correct settings and it does. I also was able to log in to the mysql db on the fog box without trouble. The db is on the same local machine as the FOG installation. Can someone please tell me how I can further troubleshoot this error?[/COLOR][/LEFT]
[LEFT][COLOR=#333333]I am running FOG 0.32 on Debian 5.[/COLOR][/LEFT]
[LEFT][COLOR=#333333]Thanks,[/COLOR][/LEFT]
[LEFT][COLOR=#333333]Mike[/COLOR][/LEFT]
[LEFT][COLOR=#333333][01-30-12 1:12:13 pm] Failed to connect to database server, will try again in next iteration.[/COLOR][/LEFT]
[LEFT][COLOR=#333333][01-30-12 1:12:23 pm] Failed to connect to database server, will try again in next iteration.[/COLOR][/LEFT]

adepo331 · Feb 3, 2012, 7:52 PM

Definitely, you are trying to Multicast. To fix the problem ,ensure that you do not enter password for mysql root during FOG installation. after the installation, do the below:

enter a Mysql username and password u desired ( e.g u=fogadmin, pwd= testing) in the /var/www/fogcommons/config.php and /opt/fog/service/etc/config.php

Before trying to open the FOG management webpage
Install PHPMYADMIN (this makes database management easy)
Open http: //localhost/phpmyadmin (in your web browser)
Create a new user $ pwd (the one you entered above) and give them ALL permissions for ALL HOSTS (basically they should be the same as ROOT
Check the user is there and the permissions are set correctly.
Go into the PERMISSIONS tab and remove the password for ROOT under localhost & 127.0.0.1 (if any)
Open the FOG webmanagement page
Set up the users in FOG
Go back to PHPMyAdmin and make sure FOG has been added as a database. You will need to log on as the ‘new user’ above
Reset the root password to something secure (as per pre install???)
Open the FOG database
Go to Permissions and BLANK the root password for localhost & 127.0.0.1

Then your problem is solved…

mpmackenna · Feb 3, 2012, 8:10 PM

I did not specify my DB information in the /opt/fog/service/etc/config.php config file. Somehow I overlooked that step. Thank you for your help.

darthanubis · Jul 30, 2012, 11:45 PM

[quote=“adepo331, post: 1042, member: 431”]Definitely, you are trying to Multicast. To fix the problem ,ensure that you do not enter password for mysql root during FOG installation. after the installation, do the below:

enter a Mysql username and password u desired ( e.g u=fogadmin, pwd= testing) in the /var/www/fogcommons/config.php and /opt/fog/service/etc/config.php

Before trying to open the FOG management webpage
Install PHPMYADMIN (this makes database management easy)
Open http: //localhost/phpmyadmin (in your web browser)
Create a new user $ pwd (the one you entered above) and give them ALL permissions for ALL HOSTS (basically they should be the same as ROOT
Check the user is there and the permissions are set correctly.
Go into the PERMISSIONS tab and remove the password for ROOT under localhost & 127.0.0.1 (if any)
Open the FOG webmanagement page
Set up the users in FOG
Go back to PHPMyAdmin and make sure FOG has been added as a database. You will need to log on as the ‘new user’ above
Reset the root password to something secure (as per pre install???)
Open the FOG database
Go to Permissions and BLANK the root password for localhost & 127.0.0.1

Then your problem is solved…[/quote]

Can’t log into the FOG UI now.

chad-bisd · Jul 31, 2012, 4:09 AM

holy thread resurrection Batman! You’re post is ambiguous. Post more details if this problem is the exact same as the OP, or better yet start your own thread including information about your FOG server OS, FOG version, etc.

darthanubis · Jul 31, 2012, 10:13 PM

[quote=“chad-bisd, post: 5223, member: 18”]holy thread resurrection Batman! You’re post is ambiguous. Post more details if this problem is the exact same as the OP, or better yet start your own thread including information about your FOG server OS, FOG version, etc.[/quote]

I have FOG running on two machines, one as server and one as storage node. With password as root I was able to login to FOG webadmin page and set up a host and connect the storage node. Everything seemed to work except I could not upload an image from Windows 7, which gave the error multi-partition disk, then I noticed in the log that this error about the database not being connected was still flooding. I found the thread about the storage node, and as I was about to follow your directions there, I found that I can no longer login to FOGs admin page. The main machine is Kubuntu x64, and the storage node is turnkey linux core running in a container withing Proxmox. I had to use ufs3 instead of nfs-kernel-server as my nfs server, as per the FOG wiki. I was so close, but don’t want to have to start from scratch. I came into the IRC channel, but it was dead.

Hope I have provided enough info.

chad-bisd · Aug 1, 2012, 2:12 AM

Make sure you are trying to bring up the webUI on the main/normal FOG server. I don’t think the webUI will bring up anything on the storage node.

darthanubis · Aug 1, 2012, 2:14 AM

[quote=“chad-bisd, post: 5267, member: 18”]Make sure you are trying to bring up the webUI on the main/normal FOG server. I don’t think the webUI will bring up anything on the storage node.[/quote]

I assumed that as a given.

chad-bisd · Aug 1, 2012, 2:18 AM

What is the error on your main fog server’s webUI? Do you get a login screen or just a blank? Does it not let you log in as fog or any other users you have created in FOG?

darthanubis · Aug 1, 2012, 2:19 AM

[quote=“chad-bisd, post: 5270, member: 18”]What is the error on your main fog server’s webUI? Do you get a login screen or just a blank? Does it not let you log in as fog or any other users you have created in FOG?[/quote]

No errors, just the login screen. No default or user I create allows entry.

chad-bisd · Aug 1, 2012, 2:39 AM

If it’s a password issue. Try: [url]http://www.fogproject.org/wiki/index.php/Reset_WebUI_FOG_password[/url]

If that doesn’t help, check your syslog or apache log for errors that might help us track down why you can’t logon to the webUI.

darthanubis · Aug 1, 2012, 3:12 PM

[quote=“chad-bisd, post: 5273, member: 18”]If it’s a password issue. Try: [url]http://www.fogproject.org/wiki/index.php/Reset_WebUI_FOG_password[/url]

If that doesn’t help, check your syslog or apache log for errors that might help us track down why you can’t logon to the webUI.[/quote]

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20206
Server version: 5.5.24-0ubuntu0.12.04.1 (Ubuntu)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;
Query OK, 0 rows affected (0.02 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql> exit;exit
Bye
Those instructions did not even create a user fog in the database. I created the user and password manually via phpmyadmin, and not matter the privileges I grant, I still can’t access the damn UI. It makes no sense. I’m sorry, I’m certain it is user error, I just can’t seem to find it.

chad-bisd · Aug 1, 2012, 3:44 PM

The instructions were not for creating a user named fog, but for resetting the password.

Did you check your apache logs for related errors. (/var/log/apache2/errors.log)

chad-bisd · Aug 1, 2012, 3:45 PM

When posting terminal output or log files, always put them inside CODE tags so they stand out and are not interpreted into smilies by the bb software.

darthanubis · Aug 1, 2012, 4:08 PM

[quote=“chad-bisd, post: 5289, member: 18”]The instructions were not for creating a user named fog, but for resetting the password.

Did you check your apache logs for related errors. (/var/log/apache2/errors.log)[/quote]

[CODE]tail -40 /var/log/apache2/error.log
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: confirm in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: tab in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: fog_user in /var/www/fog/management/index.php on line 44, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: groupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: id in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: imageid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sub in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: snapinid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagegroupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagenodeid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: crit in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sort in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: confirm in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: tab in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: fog_user in /var/www/fog/management/index.php on line 44, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] File does not exist: /var/www/favicon.ico
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: groupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: id in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: imageid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sub in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: snapinid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagegroupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagenodeid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: crit in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sort in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: confirm in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: tab in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: fog_user in /var/www/fog/management/index.php on line 44, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] File does not exist: /var/www/favicon.ico
[Wed Aug 01 11:09:42 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login[/CODE]

A mess I can not decifer. The only reason I don’t reinstall is because I want to understand how to fix the problem. I’d learn nothing of how to maintain my FOG server with a reinstall at every issue.

I appreciate your help.

As to the reset of the PW. I did not have a fog user for the fog user’s pw to be reset. I created the user “fogadmin”, which I edited the config.php files to reflect per the instruction in this thread. The only users I have are root and fogadmin, both with the same passwords.

darthanubis · Aug 1, 2012, 4:09 PM

[quote=“chad-bisd, post: 5290, member: 18”]When posting terminal output or log files, always put them inside CODE tags so they stand out and are not interpreted into smilies by the bb software.[/quote]

Would it be easier to get support in the IRC channel for real-time feed back?

chad-bisd · Aug 1, 2012, 4:11 PM

I don’t IRC, but I do actively monitor the forums all day long (Central time, US).

darthanubis · Aug 1, 2012, 4:18 PM

[quote=“darthanubis, post: 5298, member: 1659”][CODE]tail -40 /var/log/apache2/error.log
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: confirm in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: tab in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: fog_user in /var/www/fog/management/index.php on line 44, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:03:22 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: groupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: id in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: imageid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sub in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: snapinid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagegroupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagenodeid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: crit in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sort in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: confirm in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: tab in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: fog_user in /var/www/fog/management/index.php on line 44, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] File does not exist: /var/www/favicon.ico
[Wed Aug 01 11:09:38 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: groupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: id in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: imageid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sub in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: snapinid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagegroupid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: storagenodeid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: crit in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: sort in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: userid in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: confirm in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: tab in /var/www/fog/commons/init.php on line 5, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined index: fog_user in /var/www/fog/management/index.php on line 44, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login
[Wed Aug 01 11:09:41 2012] [error] [client 192.168.0.113] File does not exist: /var/www/favicon.ico
[Wed Aug 01 11:09:42 2012] [error] [client 192.168.0.113] PHP Notice: Undefined variable: Proxy in /var/www/fog/commons/functions.include.php on line 3506, referer: http://192.168.0.132/fog/management/index.php?node=login[/CODE]

A mess I can not decifer. The only reason I don’t reinstall is because I want to understand how to fix the problem. I’d learn nothing of how to maintain my FOG server with a reinstall at every issue.

I appreciate your help.

As to the reset of the PW. I did not have a fog user for the fog user’s pw to be reset. I created the user “fogadmin”, which I edited the config.php files to reflect per the instruction in this thread. The only users I have are root and fogadmin, both with the same passwords.[/quote]

[url]http://sourceforge.net/tracker/?func=detail&atid=976199&aid=3398951&group_id=201099[/url]

chad-bisd · Aug 1, 2012, 4:23 PM

I don’t see any errors that would indicate a php failure during the authentication check.

Don’t get confused between a system user and a FOG user and a MySQL user.

Is your MySQL root password blank?

Try to login to mysql as root without a password:

[CODE]mysql -u root[/CODE]

Do you get in or do you get an error?

chad-bisd · Aug 1, 2012, 4:26 PM

I get the “undefined index” errors in my apache log also. They do not keep FOG from working.

Also, why did you quite your own post with the entire log file over again?

Failed to connect to database server, will try again in next iteration.

193

12.0k

17.3k

155.2k