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

Manual Migration to FOG 1.1.2

Scheduled Pinned Locked Moved
FOG Problems
3
9
3.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.
  • K
    kelly.bettendorf
    last edited by Jun 30, 2014, 1:56 AM

    Hi all,

    Been having a few issues with FOG client after i upgraded but i’m quite certain its something i’ve messed up and i can’t find my mistake so i figured its best to reinstall. so im trying a fresh clean install of both ubuntu 12.04 LTS and FOG 1.1.2

    What is the best (cleanest) way to copy over the registered Hosts list and image database information?

    Im not concerned with moving uploaded images i have FOG mount to a different hard drive for that but i would like to keep the list of image ID’s connected to the images.

    I can’t begin to express how amazing FOG is, thank you to all who have made this possible.
    Thanks.

    1 Reply Last reply Reply Quote 0
    • A
      axel12
      last edited by Jun 30, 2014, 2:33 AM

      One of the things I used is phpmyadmin
      [url]http://www.phpmyadmin.net/home_page/index.php[/url]

      It lets you visually see what is running behind the scenes. I was able to simply copy the fog databse (via web) and delete/rename/alter/add things to fog via the web interface

      One of the things you can do with it - is export a table (structure or structure + data or data only) in a variety of formats - CSV, SQL, text, etc … so I was able to export ONLY my hosts as SQL format (data only) and re-import them into the new “fog” table.

      Careful though, this is nice BUT sometimes may not work if you have a really really old version of fog that you want to insert into a new version of the database. (for example - the new SVN updates in the upcoming releases do rename some columns, so exporting in ‘structure’ mode is not possible - must export the data only - and hope the column numbers match … i had to manually ‘fudge’ a few columns in csv to make it work). Generally, you should not have any issues like that because the updated versions of fog ‘should’ carry your data over to the next version.

      1 Reply Last reply Reply Quote 0
      • J
        Junkhacker Developer
        last edited by Jun 30, 2014, 6:15 PM

        i realize that you’re not migrating from 0.32, but the directions here still mostly apply [url]http://www.fogproject.org/wiki/index.php/Manual_Migration_Upgrade_from_0.32_to1.0[/url]

        signature:
        Junkhacker
        We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

        1 Reply Last reply Reply Quote 0
        • K
          kelly.bettendorf
          last edited by Jun 30, 2014, 9:27 PM

          When importing hosts.csv file from FOG .32 to FOG 1.0.0 I get an error message:

          Row#1-Row#1404 Invalid number of cells.

          On FOG.32 i went to reports tab, hosts, and downloaded the report.

          any idea why it wont upload to FOG 1.0.0?

          thanks

          1 Reply Last reply Reply Quote 0
          • J
            Junkhacker Developer
            last edited by Jun 30, 2014, 10:20 PM

            you have to edit the report and format it like the example import file that’s available on the hosts page

            signature:
            Junkhacker
            We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

            1 Reply Last reply Reply Quote 0
            • K
              kelly.bettendorf
              last edited by Jun 30, 2014, 11:23 PM

              When you say the hosts page are you talking about the GUI “manage hosts” pages on fog 1.0.0? because i don’t see it.

              Sorry i feel like i’m missing something superbasic on were this example is located.

              Thanks for the help.

              1 Reply Last reply Reply Quote 0
              • K
                kelly.bettendorf
                last edited by Jul 1, 2014, 12:34 AM

                All right so i found the example format by downloading a blank .csv of the hosts.

                Now i get an error message for [SIZE=13px][FONT=Ubuntu][COLOR=#555555]Row #1: Invalid number of cells[/COLOR][/FONT][/SIZE]

                I have column A as “[SIZE=2]Host ID” followed by a value of 1 counting up by one for all [/SIZE]registered[SIZE=2] computers[/SIZE]

                1 Reply Last reply Reply Quote 0
                • K
                  kelly.bettendorf
                  last edited by Jul 1, 2014, 1:06 AM

                  Whoo i figured it out, i didn’t have the columns in the right order.

                  1 Reply Last reply Reply Quote 0
                  • A
                    axel12
                    last edited by Jul 10, 2014, 2:24 AM

                    I understand that using PHPmyadmin is more of a ‘brute force’ solution … and although I advocate it -> but only in extreme circumstances where you botched up your migration in the first place.

                    Migrating manually with PHPmyadmin and manipulating the database is a very slow and painful task … believe me, I know. Column orders, commas, quotation marks - all super important when you are combing your database for import.

                    again - last-ditch solution.

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

                    241

                    Online

                    12.1k

                    Users

                    17.3k

                    Topics

                    155.3k

                    Posts
                    Copyright © 2012-2024 FOG Project