mysql
-
@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.
-
@george1421 @Wayne-Workman Where else would the mysql files be located?
-
@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.sqlYou can select where the fogdb.sql file is created. In the example above I’m sending it to the /tmp directory.
-
@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?
-
@fredlwal Files are files, if you move them with the gui or with the command line. They are the same.
-
@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.
-
@fredlwal Is there a button on that screen to do just that?
Also what version of FOG is on the new server?
-
@george1421 there is no white botton and its ver:1.3.4 but it was the .gz file install.
-
@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 -yThat 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.
-
@george1421 I just installed it from a file that I downloaded but now I’m using the upgrade to trunk method.
-
@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?
-
@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.
-
@george1421 so do I have to recreate the image again? Or do I just change settings on the new fog server?
-
@fredlwal You copy the files from your portable hard drive back to the /images directory on new server.
Then you have to manually recreate the image definitions via the web gui. This will then link the the physical files with the web gui
-
@george1421 How do I change my fogserver to hand out DHCP but on a standalone network , how would I make changes to become a standalone server?
-
@fredlwal You would make that choice when you ran the fog installer to enable the dhcp server in the FOG server.
Do you have an isolated deployment network or does your FOG server span two networks?
-
@george1421 I can isolate it by unplugging the cable that’s to the main network .
-
@george1421 my co-worker was thinking we should keep it on the network to deploy it within the building. He wanted to know what needs to go in Windows DHCP option 67? Where is that file located?
-
@fredlwal that would be the boot file you choose to use.
In most cases it will be undionly.kpxe but you are welcome to use some of the other boot files located on the fog server at /tftpboot
-
@fredlwal I can say that its easier for you to keep it on the business network, or at least can reach the business network. Many systems require access to a Windows DC as part of their setup (to connect to the domain, and such).
To answer your question (and anticipate the next one).
On your dhcp server you need to enter:
DHCP Option 66 {boot-server}: <ip address of fog server>
DHCP Option 67 {boot-file}: undionly.kpxe (for bios/legacy clients) ipxe.efi (for uefi clients)If you have a windows 2012 dhcp server you can configure it to dynamically send out the right file name during dhcp setup.
