mysql

[fredlwal]

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.

[Wayne Workman]

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

[fredlwal]

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

[Wayne Workman]

@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

[Wayne Workman]

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.

[Wayne Workman]

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.

[fredlwal]

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

[george1421]

@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.

[fredlwal]

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

[george1421]

@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.

[fredlwal]

@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?

[george1421]

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

[fredlwal]

@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.

[george1421]

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

Also what version of FOG is on the new server?

[fredlwal]

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

[george1421]

@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.

[fredlwal]

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

[fredlwal]

@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?

[george1421]

@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.

[fredlwal]

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