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

    Database update Fails

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    19
    5.2k
    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.
    • T
      the_duke
      last edited by

      I just upgraded my fog version from .32 to 1.2.0 and I got to the point where I needed to update my database schema so when I went to the link in the terminal and pressed the link to update I received the error that the install/update failed with lots of errors. What can I do from here? I did not back up my database…yes I know stupid on me. Am I just going to have to do a full reinstall of fog and start over on everything?

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

        The errors are non-impacting.

        Go ahead and try it out. It’s most likely fine.

        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
        • T
          the_duke
          last edited by

          Ok I did press enter and finished in the terminal and went to try logging back into fog and still get the “Database schema installer/updater” page

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

            @the_duke said:

            installer/updater” page

            Try restarting the mysql service.

            On RHEL/Fedora/CentOS it’s something like
            [CODE]systemctl restart mysqld.service[/CODE]

            Don’t remember what it is for Ubuntu…

            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
            • Wayne WorkmanW
              Wayne Workman
              last edited by

              Oh and what distro are you 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/

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

                Ran “sudo service mysql stop” then ran “sudo service mysql start” and still the same page

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

                  @Wayne-Workman said:

                  Oh and what distro are you 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
                  • T
                    the_duke
                    last edited by

                    ubuntu 12.04

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

                      Can you update your OS to the latest patches and then try to re-install 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!
                      Daily Clean Installation Results:
                      https://fogtesting.fogproject.us/
                      FOG Reporting:
                      https://fog-external-reporting-results.fogproject.us/

                      T 1 Reply Last reply Reply Quote 0
                      • T
                        the_duke @Wayne Workman
                        last edited by

                        @Wayne-Workman I uninstalled mysql and reinstalled it like you originally said. Now when i try to reinstall fog it gets to the checking package php5-mysql…failed

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

                          @the_duke then just uninstall that and re-install…

                          Should be something like this:
                          [CODE]apt-get remove php5-mysql
                          apt-get install php5-mysql[/CODE]

                          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/

                          T 2 Replies Last reply Reply Quote 0
                          • T
                            the_duke @Wayne Workman
                            last edited by

                            @Wayne-Workman Ok it is now back to working just like it should. Thanks Wayne

                            1 Reply Last reply Reply Quote 1
                            • T
                              the_duke @Wayne Workman
                              last edited by

                              @Wayne-Workman One other thing, I know in version .32 when you had to chose the operating system for the image we had to chose xp for any windows 7 system. Has this issue been corrected in the latest version?

                              ch3iC 1 Reply Last reply Reply Quote 0
                              • ch3iC
                                ch3i Moderator @the_duke
                                last edited by

                                @the_duke For Windows 7, choose Windows 7 😉

                                T 1 Reply Last reply Reply Quote 0
                                • T
                                  the_duke @ch3i
                                  last edited by

                                  @ch3i Ok thanks

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

                                    Glad to see you got it working. Glad reinstalling that worked!

                                    I love it when the “first-instincts” work…

                                    Because when they don’t, then the troubleshooting fiasco starts and who knows where that will go and if I have the expertise to keep up lol.

                                    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/

                                    T 1 Reply Last reply Reply Quote 0
                                    • T
                                      the_duke @Wayne Workman
                                      last edited by

                                      @Wayne-Workman Ok when I try to upload a new image, I go to preform full registration and it goes to a black screen with a blinking cursor. Also when I am on the host management page, I can only access the delete link from the host menu. I can’t search for a specific host, it just comes up with a “searching error, please try again”, so I have to list all host and find it there. I tried to upload another image to a currently registered host and I had to hit the upload arrow in the host search screen. After booting to network it would boot to ipxe and acted like it was connecting then loop back to the computers boot menu. Any ideas.

                                      1 Reply Last reply Reply Quote 0
                                      • C
                                        Clifford Raymond
                                        last edited by

                                        Hey Duke, I am in a school district like you and came across the same problem. I tried all your steps and was not able to get FOG to work. At the moment every time I try to log on to FOG it asks to install the database, then I get 113 errors. If you could shed some light on anything else you may have done it would be greatly appreciated.

                                        ch3iC 1 Reply Last reply Reply Quote 0
                                        • ch3iC
                                          ch3i Moderator @Clifford Raymond
                                          last edited by

                                          @Clifford-Raymond Hi, please create a new topic (The “Database update Fails” is solved) with your problem and your FOG configuration (OS, FOG version, …)

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

                                          209

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project