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

    SQL not working after update to 1.3.0 RC10

    Scheduled Pinned Locked Moved Unsolved
    FOG Problems
    4
    19
    4.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.
    • Wayne WorkmanW
      Wayne Workman @maveriick
      last edited by

      @maveriick so, inside of /opt/fog/.fogsettings change snmysqlhost= to 127.0.0.1, save, and re-run the installer, you should be good.

      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!
      Daily Clean Installation Results:
      https://fogtesting.fogproject.us/
      FOG Reporting:
      https://fog-external-reporting-results.fogproject.us/

      1 Reply Last reply Reply Quote 0
      • maveriickM
        maveriick
        last edited by

        Getting the same thing.
        Gonna sleep on it tonight… C-ya in the AM.
        Rob

        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
        • Wayne WorkmanW
          Wayne Workman @maveriick
          last edited by

          @maveriick that’s weird. So, same thing as in the installer fails, or same thing with the web interface?

          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!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          1 Reply Last reply Reply Quote 0
          • maveriickM
            maveriick
            last edited by

            The installer comes to the update database Schema. Then when I go to the Fog Management page as directed I attempt to install/upgrade now and it just is stuck in that loop. If I add in the switch and arguments below it also comes to that page. It does seem very weird.
            Not sure where to go next.

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

              @maveriick can you manually create the fog database then try the schema update? I think it’s failing due to the debug method call. So it never returns to allow the queries to run

              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 0
              • maveriickM
                maveriick
                last edited by

                Ok, Being not overly informed on SQL and databases. How do I manually create the database?
                Thanks,
                Rob

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

                  @maveriick run on cli mysql -u root

                  Then just run create database fog

                  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 0
                  • maveriickM
                    maveriick
                    last edited by

                    Tom,
                    Not sure how long this should take…
                    0_1473946401082_upload-5b1ed8d3-fca5-476d-95a0-7c7bd6382eff
                    I ran this about 20 minutes ago.
                    Thanks,
                    Rob

                    ThiagoT 1 Reply Last reply Reply Quote 0
                    • ThiagoT
                      Thiago @maveriick
                      last edited by

                      @maveriick enter the ; and press enter to terminate the command…
                      all command must have ended with ;

                      1 Reply Last reply Reply Quote 0
                      • maveriickM
                        maveriick
                        last edited by

                        Thanks,
                        That at least gets me a bit more…
                        I received an error 1007 (hy000): Can’t create database ‘fog’; database exists.
                        I am assuming I need to move or delete the DB? If so how do I do that?

                        ThiagoT 1 Reply Last reply Reply Quote 0
                        • ThiagoT
                          Thiago @maveriick
                          last edited by

                          @maveriick
                          Always make a backup first. Using fog suggestion should work (cd; mysqldump --allow-keywords -x -v fog > fogbackup.sql)
                          To drop a database : drop database fog;

                          maveriickM 1 Reply Last reply Reply Quote 0
                          • maveriickM
                            maveriick @Thiago
                            last edited by

                            @Thiago I have done the recommendation without issue. But am still looping on the Fog Management… What could I be doing wrong?
                            Thanks,
                            Rob

                            ThiagoT 1 Reply Last reply Reply Quote 0
                            • ThiagoT
                              Thiago @maveriick
                              last edited by

                              @maveriick After dropped the database, did you created another one? (just like @Tom-Elliott said)

                              maveriickM 1 Reply Last reply Reply Quote 0
                              • maveriickM
                                maveriick @Thiago
                                last edited by

                                @Thiago Yes I did. I also rebooted and ran this again.
                                Still with the same issues.
                                Thanks,
                                Rob

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

                                126

                                Online

                                12.1k

                                Users

                                17.3k

                                Topics

                                155.3k

                                Posts
                                Copyright © 2012-2024 FOG Project