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

Upgrade from 0.32 to 1.2

Scheduled Pinned Locked Moved Solved
Bug Reports
3
9
3.9k
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.
  • G
    Gilou
    last edited by Nov 10, 2014, 2:26 PM

    Hi,
    Upgrading from 0.32 to 1.2, it is well known usually that the fact that the OS is stored in the image info rather than the host will be an issue, but there is a function handling that in the schema updater. Problem is, I got all my images set with OSID 0… I’ll debug more about that, but I wonder why this wasn’t done in SQL rather than having to call some PHP like this (we’re talking schema upgrade 29).

    Here’s an example that tries to link the images with the OS of the host that was the last to finish a imaging task.

    UPDATE images
    SET imageOSID = (
    [INDENT=1]SELECT DISTINCT hostOS[/INDENT]
    [INDENT=1]FROM hosts LEFT JOIN imagingLog ON (imagingLog.ilHostID = hosts.hostID)[/INDENT]
    [INDENT=1]WHERE hosts.hostImage = images.imageID[/INDENT]
    [INDENT=1]ORDER BY ilFinishTime DESC[/INDENT]
    [INDENT=1])[/INDENT]
    WHERE imageOSID = 0

    And that works, if you apply it before deleting the hostOS, whereas the PHP code leaves the images set to 0 for imageOSID…

    1 Reply Last reply Reply Quote 0
    • G
      Gilou
      last edited by Nov 10, 2014, 2:44 PM

      This post is deleted!
      1 Reply Last reply Reply Quote 0
      • G
        Gilou
        last edited by Nov 10, 2014, 2:59 PM

        I can’t really figure why the ->save() doesn’t work, so here’s the patch to make it work using pure SQL.

        [url=“/_imported_xf_attachments/1/1496_schemav29.patch.txt?:”]schemav29.patch.txt[/url]

        1 Reply Last reply Reply Quote 0
        • G
          Gilou
          last edited by Nov 10, 2014, 3:37 PM

          And another bug (we need a mailing list, or a bug tracker):
          all my upgrades were configured as: “DHCP will NOT be setup but you must setup your…”

          And the process overwrote the config (backing them up before doing so, but still, annoying.)

          1 Reply Last reply Reply Quote 0
          • G
            Gilou
            last edited by Nov 10, 2014, 3:59 PM

            And new things, now my hosts don’t appear in the list, great… They do in the report, but because of the MACs, it seems they won’t get displayed…

            1 Reply Last reply Reply Quote 0
            • G
              Gilou
              last edited by Nov 10, 2014, 4:07 PM

              OK, that’s my fault, I used the schema updater from SVN in the end… not clever.

              1 Reply Last reply Reply Quote 0
              • T
                Tom Elliott
                last edited by Jan 1, 2015, 3:15 PM

                So this problem really isn’t/wasn’t a problem?

                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
                • G
                  Gilou
                  last edited by Jan 3, 2015, 12:09 AM

                  the “And new things, now my hosts don’t appear in the list, great… They do in the report, but because of the MACs, it seems they won’t get displayed…” one was due to me using a schema from SVN when I tried to pinpoint the problem. But the schema updater thing I reported first was consistent… But I’d need to try again on an old .32 file to see it happening… I haven’t kept all those 🙂

                  1 Reply Last reply Reply Quote 0
                  • W
                    Wayne Workman
                    last edited by Jan 13, 2017, 3:51 AM

                    For future readers: https://wiki.fogproject.org/wiki/index.php?title=Migrate_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/

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

                    164

                    Online

                    12.0k

                    Users

                    17.3k

                    Topics

                    155.2k

                    Posts
                    Copyright © 2012-2024 FOG Project