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

      Ok, So I tried that and the installer went all the way through.
      But when I try to log in i get the same thing.
      You guys are awesome and I look forward to getting this back up and running!

      Wayne WorkmanW 1 Reply Last reply Reply Quote 0
      • 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

                                  186

                                  Online

                                  12.1k

                                  Users

                                  17.3k

                                  Topics

                                  155.3k

                                  Posts
                                  Copyright © 2012-2024 FOG Project