• 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.4k
    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

      I have updated this morning to Running Version 1.3.0-RC-10
      SVN Revision: 5955 via GIT method
      I have tried to update the SQL Database but it is failing.
      Keeps coming back to the same screen
      0_1473860631670_upload-96a600ec-ba48-49bc-aec4-092f0777707f

      Any help would be appreciated
      Thanks,
      Rob

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

        What OS & version is the fog server running?

        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

          debian 8.5

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

            @maveriick Try to run the installer like this:
            snmysqlhost='127.0.0.1' ./installfog.sh -y

            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

              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

                                          231

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project