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

    Transferring all images & all host info from (1.2.0) to (1.2.0)

    Scheduled Pinned Locked Moved Unsolved
    FOG Problems
    migrate upgrade move
    3
    27
    5.4k
    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.
    • Wayne WorkmanW
      Wayne Workman @dcorpening
      last edited by Wayne Workman

      @dcorpening the web interface doesn’t use local accounts, it’s entirely based on what’s in the DB. Select the entire table and take a look through it. These two queries should help:

      SELECT * FROM users;
      DESCRIBE users;
      

      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/

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

        @Wayne-Workman 0_1484072718468_Screenshot from 2017-01-10 13_23_26.png What do you glean from this pic?

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

          @dcorpening That there are two fog accounts. I’d truncate the table and then insert a single fresh one using the previously mentioned command in the wiki. The password for it as the wiki states is password. And this is for the web interface - just to clairify.

          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/

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

            @Wayne-Workman 0_1484088280551_Screenshot from 2017-01-10 17_43_02.png Notice here that I truncate the table, verify with SELECT, and try to create the fog user with INSERT. Same results with 1 warning and not being able to log in. I hope this issue is not becoming a pain to you; however, it is certainly painful on my end after several reinstalls and many hours researching this. Any other suggestions would be greatly appreciated. Hopefully this fiasco will be a big help to others in the end once we find a fix.

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

              @dcorpening I see what’s happening.

              Please run in mysql:

              UPDATE `users` SET `uPass`=MD5('password') where `uName`='fog';
              

              The blowfish store was only added in 1.3.x series. As you’re running on 1.2.0 to 1.2.0, the password field is stored in md5.

              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

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

                And for reference:

                https://wiki.fogproject.org/wiki/index.php?title=Password_Central#1.2.0_and_lower

                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 1
                • D
                  dcorpening @Tom Elliott
                  last edited by

                  @Tom-Elliott It worked! I can now log in. Thank you SO MUCH! I notice that no hosts, tftp/storage passwords, etc. are listed; Even though I’ve manually imported the fogdb.sql from the old server using “…mysql < fogdb.sql” : (Which is why I could log into the WebUI). Whether the import is done manually or via the WebUI, it seems that nothing is getting imported. The images are transferring now. So I think getting the fogdb.sql properly imported should be the last hurdle in setting up this new server. Please advise.

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

                    @dcorpening Try importing the sql file from the GUI? (FOG Configuration Page->FOG Settings->Configuration Save->Import) You will have to download the db file you need to the system so you can import it.

                    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

                    D 1 Reply Last reply Reply Quote 0
                    • D
                      dcorpening @Tom Elliott
                      last edited by

                      @Tom-Elliott Correct. I’ve copied the fogdb.sql from the old server to the new one. Then I import via (FOG Configuration Page->FOG Settings->Configuration Save->Import). It says successfully completed, but nothing gets imported. The fogdb.sql is not empty; it seems full of the correct info. So I followed the instructions to manually import it and got the same results: Nothing gets imported even though no errors are returned.

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

                        Trying to hit you on chat.

                        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

                        D 1 Reply Last reply Reply Quote 0
                        • D
                          dcorpening @Tom Elliott
                          last edited by

                          @Tom-Elliott Thanks for all of your help! Can you reply to this thread with how we (you) fixed this issue? I think it may be very helpful to anyone having this or a similar issue. Again, thanks much!!

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

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

                              The older export system (1.2.0 and earlier back to 1.0.0 when it was introduced) didn’t take into account the tables existing. The way this would typically work, though, would be to simply clear out all of the tables in the fog database and apply what was being passed in.

                              For whatever reason, the exported backup file was not dropping the fog database when the import was being kicked off.

                              The fix, as we already had the original exported db, was to drop the fog database, recreate it, and let the sql file import the rest back in.

                              We did this via command line just to ensure all was well.

                              mysql -u root fog < fogdb.sql

                              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

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

                                @Tom-Elliott said in Transferring all images & all host info from (1.2.0) to (1.2.0):

                                The older export system (1.2.0 and earlier back to 1.0.0 when it was introduced) didn’t take into account the tables existing.

                                @Moderators important tid-bit of info there.

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

                                148

                                Online

                                12.1k

                                Users

                                17.3k

                                Topics

                                155.3k

                                Posts
                                Copyright © 2012-2024 FOG Project