• 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.
  • 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
                          14/15
                          Last post

                        157

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project