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

Problems after upgrading Ubuntu!!

Scheduled Pinned Locked Moved
FOG Problems
3
15
6.6k
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.
  • K
    Ken Helleson
    last edited by Jul 13, 2012, 8:46 PM

    Hi all,

    I have been using FOG for about two years to do all of our imaging. It is installed on a Ubuntu PC. Earlier in the week, I got tired of Ubuntu’s upgrade offer popping up on the screen and since I had a couple of hours that the server would not be needed, I went ahead and upgraded Ubuntu to v. 12.04. The upgrade itself went fantastic; however upon restarting the server FOG could no longer connect to the database. It reports back with an error message along the lines of…user@localhost/fog…could not connect to the database; PASSWORD=NO.

    The person that installed the entire system two years ago is no longer with us and, other than my machine login, I have never had to enter a password to use FOG. I don’t want to do anything rash at this point, since I’ve got around 170PCs and 60+ images in my database and I would really, really hate to screw that up.

    The only experience I have with a Linux variant was 25 years ago when I worked with Xenix (XEROX’s offshoot of UNIX) for about 3 months so I’m a little rusty. Anyway, whatever help I can get is greatly appreciated.

    Ken

    1 Reply Last reply Reply Quote 0
    • C
      chad-bisd Moderator
      last edited by Jul 16, 2012, 2:50 PM

      Is this error in 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
      • K
        Ken Helleson
        last edited by Jul 16, 2012, 5:29 PM

        Yeah, I think. I open firefox just fine but when I go to “localhost/fog/management/index.php” to launch FOG, a message comes up in the browser that says:

        “unable to connect to database
        Msg: Failed to connect to server:localhost server returned:access denied for user ‘root’@‘localhost’ (using password: NO)”

        It would seem to me that in the process of upgrading Ubuntu the path to the Mysql database got changed. I looked thru the wiki but it was of no help. if I type “localhost/phpmyadmin/” into the address bar I get a 404 error on the screen. Not sure how to proceed given my nearly total noobieness with all three compenents, Ubuntu, MySql & FOG.

        1 Reply Last reply Reply Quote 0
        • B
          BryceZ
          last edited by Jul 16, 2012, 6:20 PM

          Try pulling up a terminal and running…
          [CODE]service mysql status[/CODE]
          To make sure the mysql server is actually on.

          If it spits back “mysql stop/waiting” then it’s currently off, so run…
          [CODE]sudo service mysql start[/CODE]

          1 Reply Last reply Reply Quote 0
          • C
            chad-bisd Moderator
            last edited by Jul 16, 2012, 7:03 PM

            Did you upgrade mysql as part of the Ubuntu upgrade? If so, you may have given it a root password, which means you need to update your fog config files.


            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
            • K
              Ken Helleson
              last edited by Jul 16, 2012, 9:27 PM

              [quote=“BryceZ, post: 4811, member: 2”]Try pulling up a terminal and running…
              [CODE]service mysql status[/CODE]
              To make sure the mysql server is actually on.

              If it spits back “mysql stop/waiting” then it’s currently off, so run…
              [CODE]sudo service mysql start[/CODE][/quote]

              responds: mysql start/running, process 1068

              1 Reply Last reply Reply Quote 0
              • C
                chad-bisd Moderator
                last edited by Jul 16, 2012, 9:39 PM

                try this from a terminal:
                [CODE]user@fog:~$ mysql -u root[/CODE]

                If you get a prompt like: “mysql>” then your root user has no password.

                If you get an error saying “ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)” then your MySQL root user now has a password. Remember what you set it to, or figure it out. Then update /var/www/fog/commons/config.php and /opt/fog/service/etc/config.php with the MySQL root user password.


                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
                • K
                  Ken Helleson
                  last edited by Jul 16, 2012, 10:30 PM

                  [quote=“chad-bisd, post: 4818, member: 18”]try this from a terminal:
                  [CODE]user@fog:~$ mysql -u root[/CODE]

                  If you get a prompt like: “mysql>” then your root user has no password.

                  If you get an error saying “ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)” then your MySQL root user now has a password. Remember what you set it to, or figure it out. Then update /var/www/fog/commons/config.php and /opt/fog/service/etc/config.php with the MySQL root user password.[/quote]

                  Followed your suggestion and I did get ERROR 1045 (28000): …

                  The server, Mysql, and the FOG app were all three installed and configured over two years ago by someone who is no longer with our organization and no longer in the area, as far as I know. This person left no documentation as far as anyone knows. Is there a way to edit the password out of the database altogether?

                  1 Reply Last reply Reply Quote 0
                  • B
                    BryceZ
                    last edited by Jul 17, 2012, 1:14 PM

                    If there was a password before then it would be listed in /var/www/fog/commons/config.php as MYSQL_PASSWORD. If there is no password listed there then I would guess that during the upgrade process you were prompted to provide a new password for mysql.

                    1 Reply Last reply Reply Quote 0
                    • K
                      Ken Helleson
                      last edited by Jul 17, 2012, 5:26 PM

                      /var/www/fog/commons/config.php has this entry: define (“MYSQL_PASSWORD”, “”);

                      the exact msg that comes up in Firefox whenever I attempt to start fog is:

                      “unable to connect to database
                      Msg: Failed to connect to server:localhost server returned:access denied for user ‘root’@‘localhost’ (using password: NO)”

                      After looking over the threads and thinking about the whole Ubuntu upgrade process (I was never asked to supply any “keyboard” input, just accept or reject defaults) it would seem to me that during the Upgrade Ubuntu changed the “permissions” or path for the database. Does that sound right? if so how can I change the permissions and where to change them?

                      1 Reply Last reply Reply Quote 0
                      • K
                        Ken Helleson
                        last edited by Jul 18, 2012, 5:29 PM

                        [quote=“chad-bisd, post: 4818, member: 18”]try this from a terminal:
                        [CODE]user@fog:~$ mysql -u root[/CODE]

                        If you get a prompt like: “mysql>” then your root user has no password.

                        If you get an error saying “ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)” then your MySQL root user now has a password. Remember what you set it to, or figure it out. Then update /var/www/fog/commons/config.php and /opt/fog/service/etc/config.php with the MySQL root user password.[/quote]

                        [FONT=Ubuntu][COLOR=#000000]MYSQL -U ROOT -P RETURNS:[/COLOR][/FONT]

                        [I][FONT=Ubuntu][COLOR=#000000]enter password:[/COLOR][/FONT][/I]
                        [FONT=Ubuntu][COLOR=#000000]If I enter a password that I think might be correct, RETURNS:[/COLOR][/FONT]

                        [FONT=Ubuntu][COLOR=#000000]error 1045 (28000): access denied for user ‘root’@‘localhost’(using password:[/COLOR][/FONT][U][FONT=Ubuntu][COLOR=#000000]YES[/COLOR][/FONT][/U][FONT=Ubuntu][COLOR=#000000])[/COLOR][/FONT]

                        [FONT=Ubuntu][COLOR=#000000]If I do not enter a password, RETURNS:[/COLOR][/FONT]

                        [FONT=Ubuntu][COLOR=#000000]error 1045 (28000): access denied for user ‘root’@‘localhost’(using password:[/COLOR][/FONT][U][FONT=Ubuntu][COLOR=#000000]NO[/COLOR][/FONT][/U][FONT=Ubuntu][COLOR=#000000])[/COLOR][/FONT]

                        If type in “NULL” as a password, RETURNS:

                        [FONT=Ubuntu][COLOR=#000000]error 1045 (28000): access denied for user ‘root’@‘localhost’(using password:[/COLOR][/FONT][U][FONT=Ubuntu][COLOR=#000000]YES[/COLOR][/FONT][/U][FONT=Ubuntu][COLOR=#000000])[/COLOR][/FONT]

                        [FONT=Ubuntu][COLOR=#000000]In both /var/www/fog/commons/config.php and /opt/fog/service/etc/config.php define[/COLOR][/FONT] (“MYSQL_PASSWORD”, “”); Since I’ve noticed a couple of differences between the 2 versions of Ubuntu, I thought that maybe the new version might only recognize “NULL” and not “”, but sincetrying to use that as a password returned (using password:YES) then “” is still “” and not “NULL”.

                        1 Reply Last reply Reply Quote 0
                        • C
                          chad-bisd Moderator
                          last edited by Jul 18, 2012, 9:27 PM

                          play around with the trying to guess the root password.

                          Try things like “password”, “fog”, and if you just can’t guess the root password. there is a way you can take the MySQL database offline and reset the root password.


                          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 Jul 18, 2012, 9:28 PM

                            If you have a filesystem backup of the /var/www/fog or /opt/fog/service directories from before the upgrade, restore them to a temp location and check the config.php files for the password.


                            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
                            • K
                              Ken Helleson
                              last edited by Jul 18, 2012, 10:35 PM

                              [quote=“chad-bisd, post: 4941, member: 18”]play around with the trying to guess the root password.

                              Try things like “password”, “fog”, and if you just can’t guess the root password. there is a way you can take the MySQL database offline and reset the root password.[/quote]

                              I have tried every [U]known[/U] password that the person who set this system up has used for other things that required passwords as well as all the common generic passwords such as ‘password’ ‘pw’ ‘abc123’ etc… nothing seems to work. How do I take the Mysql database offline and reset the root password?

                              Also there is no preupgrade backup of the file system.

                              1 Reply Last reply Reply Quote 0
                              • C
                                chad-bisd Moderator
                                last edited by Jul 19, 2012, 1:25 PM

                                [url]http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix[/url]


                                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
                                • 1 / 1
                                1 / 1
                                • First post
                                  1/15
                                  Last post

                                197

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project