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

    Upgrade from Trunk to 1.4.2 Failed

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    3
    23
    6.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.
    • AvaryanA
      Avaryan @Tom Elliott
      last edited by Avaryan

      @Tom-Elliott said in Upgrade from Trunk to 1.4.2 Failed:

      @Avaryan ANd what’s the output of mysql -v?

      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 575
      Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu)
      
      Copyright (c) 2000, 2017, 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.
      
      Reading history-file /home/user/.mysql_history
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      

      If I sudo that or log in with root I get access denied message.

      Tom ElliottT 1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott @Avaryan
        last edited by

        @Avaryan Do you have a root password defined for Mysql access?

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        AvaryanA 1 Reply Last reply Reply Quote 0
        • AvaryanA
          Avaryan @Tom Elliott
          last edited by

          @Tom-Elliott Good question. No clue! I didn’t set the server up.

          How would I go about checking? And how would I go about changing it and/or removing if that’s what I need to do.

          Tom ElliottT 1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott @Avaryan
            last edited by

            @Avaryan this is where things get tricky I suppose as I have no idea of knowing.

            Can you check in /opt/fog/.fogsettings and look for snmysqlpass?

            The password should be there, though I suspect that’s where things might be also breaking.

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            AvaryanA 2 Replies Last reply Reply Quote 0
            • AvaryanA
              Avaryan @Tom Elliott
              last edited by Avaryan

              @Tom-Elliott I don’t see a .fogettings in /opt/fog

              Only thing in there is log, service, snapins, utils directories.

              Edit: Nevermind. It showed up when I manually typed it in.

              george1421G 1 Reply Last reply Reply Quote 0
              • george1421G
                george1421 Moderator @Avaryan
                last edited by

                @Avaryan ls -la /opt/fog please try

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

                1 Reply Last reply Reply Quote 0
                • AvaryanA
                  Avaryan @Tom Elliott
                  last edited by george1421

                  @Tom-Elliott said in Upgrade from Trunk to 1.4.2 Failed:

                  @Avaryan this is where things get tricky I suppose as I have no idea of knowing.

                  Can you check in /opt/fog/.fogsettings and look for snmysqlpass?

                  The password should be there, though I suspect that’s where things might be also breaking.

                  snmysqlpass='XXXXXXXX'

                  Moderator note: I removed the password to your mysql database. The important part is that YOU know what it is

                  george1421G 1 Reply Last reply Reply Quote 0
                  • george1421G
                    george1421 Moderator @Avaryan
                    last edited by

                    @Avaryan Now that you know your password attempt to log into your database from the linux command line mysql -u root -p fog then provide your database password.

                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

                    AvaryanA 2 Replies Last reply Reply Quote 0
                    • AvaryanA
                      Avaryan @george1421
                      last edited by

                      @george1421 said in Upgrade from Trunk to 1.4.2 Failed:

                      @Avaryan Now that you know your password attempt to log into your database from the linux command line mysql -u root -p fog then provide your database password.

                      This was the output when I tried the password listed in .fogsettings

                      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
                      

                      However, I tried another password and got this:

                      Reading table information for completion of table and column names
                      You can turn off this feature to get a quicker startup with -A
                      
                      Welcome to the MySQL monitor.  Commands end with ; or \g.
                      Your MySQL connection id is 28556
                      Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu)
                      
                      Copyright (c) 2000, 2017, 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.
                      

                      Assuming that is what I should see on a correct login, I at least know what the password is.

                      1 Reply Last reply Reply Quote 0
                      • Tom ElliottT
                        Tom Elliott
                        last edited by

                        That /opt/fog/.fogsettings file, pelase edit the snmysqlpass line to make it match what you “know” what it is. THen rerun the installer. Apparently it got changed at some point in time.

                        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                        1 Reply Last reply Reply Quote 1
                        • AvaryanA
                          Avaryan @george1421
                          last edited by Avaryan

                          @george1421 said in Upgrade from Trunk to 1.4.2 Failed:

                          @Avaryan Now that you know your password attempt to log into your database from the linux command line mysql -u root -p fog then provide your database password.

                          Our live FOG server is now on 1.4.2, revision 6072. Thanks! Now to figure out how that password got changed…

                          edit: You can mark this as solved.

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

                          140

                          Online

                          12.1k

                          Users

                          17.3k

                          Topics

                          155.3k

                          Posts
                          Copyright © 2012-2024 FOG Project