• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.
  • M
    maveriick
    last edited by Sep 14, 2016, 1:44 PM

    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
    • W
      Wayne Workman
      last edited by Sep 14, 2016, 3:08 PM

      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
      • M
        maveriick
        last edited by Sep 14, 2016, 5:11 PM

        debian 8.5

        W 1 Reply Last reply Sep 14, 2016, 5:49 PM Reply Quote 0
        • W
          Wayne Workman @maveriick
          last edited by Sep 14, 2016, 5:49 PM

          @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
          • M
            maveriick
            last edited by Sep 14, 2016, 6:09 PM

            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!

            W 1 Reply Last reply Sep 14, 2016, 7:19 PM Reply Quote 0
            • W
              Wayne Workman @maveriick
              last edited by Sep 14, 2016, 7:19 PM

              @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
              • M
                maveriick
                last edited by Sep 14, 2016, 7:59 PM

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

                W 1 Reply Last reply Sep 14, 2016, 8:04 PM Reply Quote 0
                • W
                  Wayne Workman @maveriick
                  last edited by Sep 14, 2016, 8:04 PM

                  @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
                  • M
                    maveriick
                    last edited by Sep 15, 2016, 11:41 AM

                    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.

                    T 1 Reply Last reply Sep 15, 2016, 12:17 PM Reply Quote 0
                    • T
                      Tom Elliott @maveriick
                      last edited by Sep 15, 2016, 12:17 PM

                      @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
                      • M
                        maveriick
                        last edited by Sep 15, 2016, 12:58 PM

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

                        T 1 Reply Last reply Sep 15, 2016, 1:03 PM Reply Quote 0
                        • T
                          Tom Elliott @maveriick
                          last edited by Sep 15, 2016, 1:03 PM

                          @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
                          • M
                            maveriick
                            last edited by Sep 15, 2016, 1:34 PM

                            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

                            T 1 Reply Last reply Sep 15, 2016, 1:37 PM Reply Quote 0
                            • T
                              Thiago @maveriick
                              last edited by Sep 15, 2016, 1:37 PM

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

                              1 Reply Last reply Reply Quote 0
                              • M
                                maveriick
                                last edited by Sep 15, 2016, 1:46 PM

                                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?

                                T 1 Reply Last reply Sep 15, 2016, 2:15 PM Reply Quote 0
                                • T
                                  Thiago @maveriick
                                  last edited by Sep 15, 2016, 2:15 PM

                                  @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;

                                  M 1 Reply Last reply Sep 15, 2016, 3:06 PM Reply Quote 0
                                  • M
                                    maveriick @Thiago
                                    last edited by Sep 15, 2016, 3:06 PM

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

                                    T 1 Reply Last reply Sep 15, 2016, 5:18 PM Reply Quote 0
                                    • T
                                      Thiago @maveriick
                                      last edited by Sep 15, 2016, 5:18 PM

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

                                      M 1 Reply Last reply Sep 15, 2016, 5:36 PM Reply Quote 0
                                      • M
                                        maveriick @Thiago
                                        last edited by Sep 15, 2016, 5:36 PM

                                        @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
                                        1 / 1
                                        • First post
                                          2/19
                                          Last post

                                        159

                                        Online

                                        12.0k

                                        Users

                                        17.3k

                                        Topics

                                        155.2k

                                        Posts
                                        Copyright © 2012-2024 FOG Project