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

    Fog 1.1.2 corrupts SQL database

    Scheduled Pinned Locked Moved
    FOG Problems
    7
    28
    10.3k
    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.
    • Oscar HillikerO
      Oscar Hilliker
      last edited by

      Ubuntu 10.04 LTS

      Decided to update FOG to 1.1.2 and it corrupts the SQL database.

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

        What?

        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
        • Tom ElliottT
          Tom Elliott
          last edited by

          How does it “corrupt” the database?

          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
          • Oscar HillikerO
            Oscar Hilliker
            last edited by

            Please go here to see the report I saved as pdf

            [url]http://www.moelleraerospace.com/Fog 112 Corrupt DB.pdf[/url]

            1 Reply Last reply Reply Quote 0
            • Jaymes DriverJ
              Jaymes Driver Developer
              last edited by

              What version of Fog did you upgrade from?

              WARNING TO USERS: My comments are written completely devoid of emotion, do not mistake my concise to the point manner as a personal insult or attack.

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

                Your report is NOT a corruption of the database.

                Your report indicates to me that the mysql service is not running or not setup correctly.

                [code]service mysql restart[/code] Try again.

                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
                • Oscar HillikerO
                  Oscar Hilliker
                  last edited by

                  I upgraded from 1.1.1 I will try the restart command you suggest Tom. It looked corrupt in that report, didn’t realize it simply was not running.

                  1 Reply Last reply Reply Quote 0
                  • Oscar HillikerO
                    Oscar Hilliker
                    last edited by

                    [quote=“Oscar Hilliker, post: 32542, member: 24172”]I upgraded from 1.1.1 I will try the restart command you suggest Tom. It looked corrupt in that report, didn’t realize it simply was not running.[/quote]

                    Tried [FONT=Consolas]service mysql restart and no luck starting it[/FONT]

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

                      Can you, possibly, provide more information.

                      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
                      • Oscar HillikerO
                        Oscar Hilliker
                        last edited by

                        Here is the installation log, I don’t know how else to explain it. Regardless of starting or retrying the upgrade the fog UI continues to report the
                        [SIZE=6][B][FONT=Ubuntu][CENTER][SIZE=32px][COLOR=#666666]Database Schema Installer / Updater[/COLOR][/SIZE][/CENTER][/FONT][/B][/SIZE]

                        [FONT=Ubuntu][COLOR=#555555]Update/Install Failed![/COLOR][/FONT]

                        [url=“/_imported_xf_attachments/1/1123_foginstall.txt?:”]foginstall.txt[/url]

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

                          When you initially install FOG, did you set a password for the root mysql user?

                          If so, can you edit:
                          /var/www/fog/lib/fog/Config.class.php under db_settings make sure the right information is entered.

                          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
                          • Oscar HillikerO
                            Oscar Hilliker
                            last edited by

                            no password is set. The odd thing is when I go and reinstall the 1.1.1 the SQL database is fine. Then I try and upgrade to 1.1.2 and it says the SQL schema installer/updater fails .

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

                              Did you check the Config.class.php file?

                              I’ll be willing to bet that, then, there is a password set on for the root user when there shouldn’t be. Have you read throughout the forums specifically with this issue?

                              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
                              • Tom ElliottT
                                Tom Elliott
                                last edited by

                                I fixed the installer which during your upgrade looks like it broke it’s only because it’s now functioning properly that you were seeing the issues

                                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
                                • Oscar HillikerO
                                  Oscar Hilliker
                                  last edited by

                                  I checked the Config.class.php file and nothing was in it. Anyways I will stop bothering you with this and use 1.1.1 for now.

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

                                    [quote=“Oscar Hilliker, post: 32627, member: 24172”]I checked the Config.class.php file and nothing was in it. Anyways I will stop bothering you with this and use 1.1.1 for now.[/quote]

                                    I don’t mind being bothered with it.

                                    What do you mean nothing was in it? The file didn’t exist?

                                    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
                                    • Oscar HillikerO
                                      Oscar Hilliker
                                      last edited by

                                      What I mean is the actual Config.class.php file had nothing in it. However after digging around I found a fog prev folder and it had the Config.class.php file and there is code in it. The odd thing is…there is a password not set by us, it has always been blank. I am not sure how it got there or changed. I will make another attempt at the install and report what happens.

                                      1 Reply Last reply Reply Quote 0
                                      • R
                                        rhythmtone
                                        last edited by

                                        Hi,
                                        I believe that the SQL service crashing or timing out causes this (database schema update loop) - we’ve seen it too and it is painful.

                                        This link from Tom seems to fix it, especially the bottom section:

                                        [url]https://github.com/mastacontrola/fogproject/issues/1[/url]

                                        Cheers,
                                        D.L.

                                        1 Reply Last reply Reply Quote 0
                                        • Oscar HillikerO
                                          Oscar Hilliker
                                          last edited by

                                          Tried Rhythmtone’s website and did all the suggestions then did a Re-try of 1.1.2 and it (SQL) failed, I saw some things about Fog 1.2.0 so I will try that as soon as I can get access to Ubuntu again.

                                          1 Reply Last reply Reply Quote 0
                                          • F
                                            fre2709
                                            last edited by

                                            Hi Guys,

                                            I had this issue too when I upgraded. The /var/www/fog/lib/fog/Config.class.php had a password in the root user for SQL.

                                            On Ubuntu boxes type sudo gedit /var/www/fog/lib/fog/Config.class.php from a terminal will open the correct file. Check if there is a password set for root, if so remove it leaving just the single quote marks (i.e. empty string). Re-link to Fog via browser and the schema updater should work. Did for me anyway…

                                            This issue only seems to have occurred since 1.1.2 was released. Didn’t have any problems upgrading to 1.1.1.

                                            FOG 1.2.0
                                            Ubuntu 12.04LTS
                                            HP ML350 G5

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

                                            181

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project