• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

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

    Scheduled Pinned Locked Moved
    FOG Problems
    6
    48
    43.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      chad-bisd Moderator
      last edited by

      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?


      If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

      1 Reply Last reply Reply Quote 0
      • D
        darthanubis
        last edited by

        [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.

        1 Reply Last reply Reply Quote 0
        • C
          chad-bisd Moderator
          last edited by

          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.


          If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

          1 Reply Last reply Reply Quote 0
          • D
            darthanubis
            last edited by

            [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)

            Copyright © 2000, 2011, Oracle and/or its affiliates. All rights reserved.

            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.

            1 Reply Last reply Reply Quote 0
            • C
              chad-bisd Moderator
              last edited by

              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)


              If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

              1 Reply Last reply Reply Quote 0
              • C
                chad-bisd Moderator
                last edited by

                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.


                If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                1 Reply Last reply Reply Quote 0
                • D
                  darthanubis
                  last edited by

                  [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.

                  1 Reply Last reply Reply Quote 0
                  • D
                    darthanubis
                    last edited by

                    [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?

                    1 Reply Last reply Reply Quote 0
                    • C
                      chad-bisd Moderator
                      last edited by

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


                      If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                      1 Reply Last reply Reply Quote 0
                      • D
                        darthanubis
                        last edited by

                        [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]

                        1 Reply Last reply Reply Quote 0
                        • C
                          chad-bisd Moderator
                          last edited by

                          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?


                          If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                          1 Reply Last reply Reply Quote 0
                          • C
                            chad-bisd Moderator
                            last edited by

                            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?


                            If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                            1 Reply Last reply Reply Quote 0
                            • D
                              darthanubis
                              last edited by

                              [quote=“chad-bisd, post: 5302, member: 18”]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?[/quote]

                              It is not blank.

                              [CODE]mysql -u root
                              ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)[/CODE]

                              1 Reply Last reply Reply Quote 0
                              • C
                                chad-bisd Moderator
                                last edited by

                                ok. now make sure the mysql password is set properly in the /var/www/fog/commons/config.php file.


                                If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                                1 Reply Last reply Reply Quote 0
                                • D
                                  darthanubis
                                  last edited by

                                  [quote=“chad-bisd, post: 5303, member: 18”]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?[/quote]

                                  I added a link to that post in reference to my log file errors. I thought the two were relevant.

                                  1 Reply Last reply Reply Quote 0
                                  • D
                                    darthanubis
                                    last edited by

                                    [quote=“chad-bisd, post: 5305, member: 18”]ok. now make sure the mysql password is set properly in the /var/www/fog/commons/config.php file.[/quote]

                                    It is in there.

                                    [CODE]define( “MYSQL_DATABASE”, “fog” );
                                    define( “MYSQL_USERNAME”, “fogadmin” );
                                    define( “MYSQL_PASSWORD”, “password” );[/CODE]

                                    1 Reply Last reply Reply Quote 0
                                    • C
                                      chad-bisd Moderator
                                      last edited by

                                      That doesn’t look right. The MYSQL_USERNAME shout be root on the master fog server. the MYSQL_PASSWORD should be whatever you use when connecting using “mysql -u root -p” from the command line.


                                      If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                                      1 Reply Last reply Reply Quote 0
                                      • D
                                        darthanubis
                                        last edited by

                                        [quote=“chad-bisd, post: 5308, member: 18”]That doesn’t look right. The MYSQL_USERNAME shout be root on the master fog server. the MYSQL_PASSWORD should be whatever you use when connecting using “mysql -u root -p” from the command line.[/quote]

                                        I changed the user back to root, the password is correct, and no change.

                                        1 Reply Last reply Reply Quote 0
                                        • C
                                          chad-bisd Moderator
                                          last edited by

                                          ok. query the users table in the fog database in mysql and post the contents.
                                          [CODE]
                                          mysql -u root -ppassword fog
                                          mysql>select uName from users;
                                          [/CODE]

                                          That should list all logins available to the web interfaces.


                                          If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                                          1 Reply Last reply Reply Quote 0
                                          • D
                                            darthanubis
                                            last edited by

                                            [quote=“chad-bisd, post: 5310, member: 18”]ok. query the users table in the fog database in mysql and post the contents.
                                            [CODE]
                                            mysql -u root -ppassword fog
                                            mysql>select uName from users;
                                            [/CODE]

                                            That should list all logins available to the web interfaces.[/quote]

                                            [CODE]mysql> mysql>select uName from users;
                                            ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mysql>select uName from users’ at line 1[/CODE]

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 1 / 3
                                            • First post
                                              Last post

                                            193

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project