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

mysql

Scheduled Pinned Locked Moved
FOG Problems
4
31
6.8k
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.
  • F
    fredlwal
    last edited by Feb 13, 2017, 1:18 PM

    How do you edit the Mysql settings where you would put in that static IP address of the fog server? This is an existing server that I was trying to upgrade to the newest ver, but I ran into issues and now I need to get it back up and running to image a few laptops but I noticed the MySQL settings are different and I just have to change it back.

    1 Reply Last reply Reply Quote 0
    • W
      Wayne Workman
      last edited by Wayne Workman Feb 13, 2017, 8:26 AM Feb 13, 2017, 2:24 PM

      The 1.3.x installer automatically makes backups of the database, they are in /home/fogDBbackups
      Import one of those files like this:
      mysql < file
      You will have to have matching web files for the version you choose, you need to restore the correct web files inside of /home to /var/www/html/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/

      F 2 Replies Last reply Feb 13, 2017, 3:42 PM Reply Quote 1
      • F
        fredlwal @Wayne Workman
        last edited by fredlwal Feb 13, 2017, 9:54 AM Feb 13, 2017, 3:42 PM

        @Wayne-Workman I have 1.2x still is there a location for that backup with that version?

        W 1 Reply Last reply Feb 14, 2017, 12:43 AM Reply Quote 0
        • W
          Wayne Workman @fredlwal
          last edited by Feb 14, 2017, 12:43 AM

          @fredlwal No, not in 1.2.0 and below. Sorry. You might actually want to look at this, and get away from 1.2.0: 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
          • W
            Wayne Workman
            last edited by Wayne Workman Feb 15, 2017, 8:10 AM Feb 15, 2017, 2:09 PM

            If you tried to install the latest FOG onto your server, the new installer before changing anything about the DB would have made a backup here: /home/fogDBbackups and would have made a backup of the web directory here probably: /home/fog_web_1.3.x.BACKUP

            Please check these places.

            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
            • W
              Wayne Workman
              last edited by Wayne Workman Feb 15, 2017, 8:15 AM Feb 15, 2017, 2:13 PM

              Also would still urge you to migrate.

              In your head - you’re thinking the most easy path is getting your existing box back the way it was.

              That’s not the easiest way - lots of unknowns that way. How to get the DB back the way it was without backups, what settings & things did the new installer put on the box that may not work with the old version, and whatever other problems your old server might have too. I don’t know.

              But what I do know is how to migrate fog servers, and I know this really well. I wrote that article I linked to below, and if you follow it, it will work.

              The most easy and shortest and most sure path is to build a new box and move stuff over.

              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
              • F
                fredlwal @Wayne Workman
                last edited by Feb 17, 2017, 1:50 PM

                @Wayne-Workman Can I Migrate files and images over to an external drive and then import it onto the new server?

                G 1 Reply Last reply Feb 17, 2017, 1:52 PM Reply Quote 0
                • G
                  george1421 Moderator @fredlwal
                  last edited by Feb 17, 2017, 1:52 PM

                  @fredlwal Its much easier to do this via the network. But sure you can mount an external drive, copy the files and then reverse the process on the new server.

                  As I said above its easier to do via the network as long as there is connectivity between the two servers.

                  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!

                  F 2 Replies Last reply Feb 17, 2017, 2:06 PM Reply Quote 1
                  • F
                    fredlwal @george1421
                    last edited by Feb 17, 2017, 2:06 PM

                    @george1421 @Wayne-Workman Where else would the mysql files be located?

                    G 1 Reply Last reply Feb 17, 2017, 2:22 PM Reply Quote 0
                    • G
                      george1421 Moderator @fredlwal
                      last edited by Feb 17, 2017, 2:22 PM

                      @fredlwal Do you want to know where the actual db files are located or what you exported?

                      If you follow Wayne’s guide: https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG

                      In the section: Export DB

                      This is the command to export the database: mysqldump -B fog > /tmp/fogdb.sql

                      You can select where the fogdb.sql file is created. In the example above I’m sending it to the /tmp directory.

                      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!

                      F 1 Reply Last reply Feb 17, 2017, 3:18 PM Reply Quote 1
                      • F
                        fredlwal @george1421
                        last edited by Feb 17, 2017, 2:23 PM

                        @george1421 Also if I have in the past just copied over the images using the gui interface to the external drive will that cause a problem with those images onto the new server?

                        G 1 Reply Last reply Feb 17, 2017, 2:23 PM Reply Quote 0
                        • G
                          george1421 Moderator @fredlwal
                          last edited by Feb 17, 2017, 2:23 PM

                          @fredlwal Files are files, if you move them with the gui or with the command line. They are the same.

                          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!

                          1 Reply Last reply Reply Quote 1
                          • F
                            fredlwal @george1421
                            last edited by Feb 17, 2017, 3:18 PM

                            @george1421 I have the new server up but I’m getting a white screen when I type in my IP address. This is the error message that I am getting " You still need to install/upgrade your database schema"

                            Just bare with me guys I’m a rookie when it comes to this Linux OS.

                            G 1 Reply Last reply Feb 17, 2017, 3:22 PM Reply Quote 0
                            • G
                              george1421 Moderator @fredlwal
                              last edited by george1421 Feb 17, 2017, 9:22 AM Feb 17, 2017, 3:22 PM

                              @fredlwal Is there a button on that screen to do just that?

                              Also what version of FOG is on the new server?

                              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!

                              F 1 Reply Last reply Feb 17, 2017, 3:38 PM Reply Quote 1
                              • F
                                fredlwal @george1421
                                last edited by Feb 17, 2017, 3:38 PM

                                @george1421 there is no white botton and its ver:1.3.4 but it was the .gz file install.

                                G 1 Reply Last reply Feb 17, 2017, 3:45 PM Reply Quote 0
                                • G
                                  george1421 Moderator @fredlwal
                                  last edited by Feb 17, 2017, 3:45 PM

                                  @fredlwal Ok this post confuses me a bit. Where did the .gz file come from?

                                  The typical process for installing FOG on a new system is this.

                                  cd <path_where_you_want_the_install_files_install_files>
                                  git clone https://github.com/fogproject/fogproject.git
                                  cd <path_to_your_install_files>/fogproject
                                  cd bin
                                  ./installfog.sh -y
                                  

                                  That process requires internet access of the fog server. But it will build your fog server for you. There is a step during the build process where it will ask you to go to the management page and create the database. The installer will wait until you go to the web site to create the database. Once the database has been created then go back to the installer and press enter to continue the setup. That is the process.

                                  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!

                                  F 2 Replies Last reply Feb 17, 2017, 3:58 PM Reply Quote 1
                                  • F
                                    fredlwal @george1421
                                    last edited by Feb 17, 2017, 3:58 PM

                                    @george1421 I just installed it from a file that I downloaded but now I’m using the upgrade to trunk method.

                                    1 Reply Last reply Reply Quote 0
                                    • F
                                      fredlwal @george1421
                                      last edited by Feb 17, 2017, 4:05 PM

                                      @george1421 I’m able to get to the web interface, now will I be able to just copy the images off the external hard drive onto the new fog server and how do I get the new images to show up in the list?

                                      G 1 Reply Last reply Feb 17, 2017, 4:08 PM Reply Quote 0
                                      • G
                                        george1421 Moderator @fredlwal
                                        last edited by Feb 17, 2017, 4:08 PM

                                        @fredlwal The quickest is to manually recreate the image definitions.

                                        If you have 1.2.0 still functional. Just copy and paste between the management interfaces. If you have more than a handful of images (<10) the copy/paste process is the quickest and best.

                                        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!

                                        F 1 Reply Last reply Feb 17, 2017, 4:11 PM Reply Quote 1
                                        • F
                                          fredlwal @george1421
                                          last edited by Feb 17, 2017, 4:11 PM

                                          @george1421 so do I have to recreate the image again? Or do I just change settings on the new fog server?

                                          G 1 Reply Last reply Feb 17, 2017, 4:26 PM Reply Quote 0
                                          • 1
                                          • 2
                                          • 1 / 2
                                          1 / 2
                                          • First post
                                            1/31
                                            Last post

                                          155

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project