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

    Database Schema Installer / Updater

    Scheduled Pinned Locked Moved
    FOG Problems
    6
    14
    5.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.
    • T
      Tom
      last edited by

      Hello,

      Completed in place upgrade fog on Ubuntu.
      Fog version 0.31 on Ubuntu 10.11 to fog 1.2.0 on Ubuntu 12.04
      All seems to run ok with no issues.
      When trying to update the database schema it fails.0_1453211200571_Errors.pdf

      Attached the log as pdf.

      I tried suggestions that I found here, but the issue was not resolved for me.

      Thank you in advance,

      Tom

      1 Reply Last reply Reply Quote 0
      • ThiagoT
        Thiago
        last edited by Thiago

        login to your mysql and set root password.

        mysql -u root -p
        use mysql;
        UPDATE user SET password=PASSWORD(‘Your-pass-for-mysql-here’) WHERE User=‘root’;
        exit;

        the password must be the same as configured during installation by foginstall script

        and then try update your schema again.

        works for me.

        T 1 Reply Last reply Reply Quote 0
        • T
          Tom @Thiago
          last edited by

          @Thiago Thank for the advice, Unfortunately, it did not help. I’m a bit frustrated.
          Since it’s VM, I’m ready to revert back and try this upgrade again.

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

            @Tom look at this article, thiere is a section on db issues that is specific to Ubuntu. https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL

            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
              Tom @Wayne Workman
              last edited by

              @Wayne-Workman Thank you, I went through the troubleshooting steps and could not figure out what’s wrong.
              I’m going to revert back and start over.
              Does anyone have instructions on how to do it and what to look for?
              Is there anything I should do pre and post upgrade?

              Thanks,

              Tom

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

                @Tom said:

                anything I should do pre and post upgrade?

                I’d recommend going through 0.32 first, and then to 1.2.0.

                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
                • george1421G
                  george1421 Moderator
                  last edited by george1421

                  I guess I have to be captain obvious here (well may be not so much).

                  What would you loose if you spun up a new instance of the FOG server using the current trunk image?

                  Would it be just the registrations, the images, what would be the real impact of starting over?

                  The reason why I asked is: Will it take more time to upgrade from 0.30 to 1.20 and work out all of the kinks or just recreate the new environment?

                  Unless I’m off here, you can not deploy images created with 0.30 with the trunk build of fog 1.2.0. The image format has changed. Your best bet would be to deploy an image with fog 0.30 and then right away recapture it with the trunk build of 1.2.0. That way you get the image in the correct format. If its the registrations there may be a way to export the hosts and then re-import them into fog. But again will it take less time to just reenter them into the latest release of 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!

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

                    @george1421 said:

                    Unless I’m off here, you can not deploy images created with 0.30 with the trunk build of fog 1.2.0.

                    You can, you’d just change settings from partclone to partimage.

                    But I agree, if there is not much to loose, just rebuild everything using fog trunk. The new client auto-registers computers anyways.

                    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
                      Tom @george1421
                      last edited by

                      @george1421 Thank you for the advice. My knowledge about Ubuntu and FOG is very basic. Can you provide more info (step by step would be great) how to accomplish this?

                      Thank you very much,

                      Tom

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

                        @Tom https://wiki.fogproject.org/wiki/index.php?title=Upgrade_to_trunk

                        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
                          Tom @Wayne Workman
                          last edited by

                          @Wayne-Workman So, I have decided to start fresh, I installed Ubuntu 14.04.3 and fog 1.2.0 ( It was my understanding that the trunk is beta version).
                          My issue now is that the host is not booting to PXE.
                          Set correctly opt 66 and 67 (undionly.kpxe) and tried to work with dnsmasq, but I cannot figure this out.
                          I can get to the management console via IE over the network.
                          Should I start a new thread?

                          Thanks,

                          Tom

                          JJ FullmerJ Wayne WorkmanW 2 Replies Last reply Reply Quote 0
                          • JJ FullmerJ
                            JJ Fullmer Testers @Tom
                            last edited by

                            @Tom
                            Trunk isn’t beta in the traditional sense. I would strongly recommend upgrading to it. If there are problems you post it on the forum and often the issue is fixed in a manner of hours.

                            Have you tried the FogApi powershell module? It's pretty cool IMHO
                            https://github.com/darksidemilk/FogApi
                            https://fogapi.readthedocs.io/en/latest/
                            https://www.powershellgallery.com/packages/FogApi
                            https://forums.fogproject.org/topic/12026/powershell-api-module

                            Tom ElliottT 1 Reply Last reply Reply Quote 1
                            • Tom ElliottT
                              Tom Elliott @JJ Fullmer
                              last edited by

                              @Arrowhead-IT Sometimes even minutes.

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

                                @Tom said:

                                My issue now is that the host is not booting to PXE.

                                Make sure UFW is off. Check this out: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_TFTP

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

                                219

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project