Version 1.2.0 released!

[Josh Scoville]

Hello all,

What database is the new version of FOG using? I just set up a new server as I need to migrate off some old hardware. I did a fresh install and exported/imported my hosts. I copied over my image files and want to be able to export/import the image database info, but there is no option for this. So I thought I’d mysqldump the images table and import it into the 1.2 database on the new server.

I may be totally going about this the wrong way and if so, please let me know, but my question is: how do I find the database name that 1.2 is using? When I go to mysql and do a “show databases”, I see no “fog” database like on the old server.

Please advise as my old server was having problems saying it could not find the entire image file, so I thought I’d go ahead and migrate to the new one. We use FOG heavily for our school system.

Thanks!

[Tom Elliott]

[quote=“Josh Scoville, post: 34427, member: 25343”]Hello all,

What database is the new version of FOG using? I just set up a new server as I need to migrate off some old hardware. I did a fresh install and exported/imported my hosts. I copied over my image files and want to be able to export/import the image database info, but there is no option for this. So I thought I’d mysqldump the images table and import it into the 1.2 database on the new server.

I may be totally going about this the wrong way and if so, please let me know, but my question is: how do I find the database name that 1.2 is using? When I go to mysql and do a “show databases”, I see no “fog” database like on the old server.

Please advise as my old server was having problems saying it could not find the entire image file, so I thought I’d go ahead and migrate to the new one. We use FOG heavily for our school system.

Thanks![/quote]

It sounds to me like the FOG database never got created on your system. Did you not run through the Schema installer/updater?

[Josh Scoville]

I did run the schema update and I can log into the new server web gui and was even able to import hosts from a csv file, which did import and show up.

[Tom Elliott]

In /var/www/fog/lib/fog/Config.class.php under the db_settings method, there should be a line like:
[code]define(‘DATABASE_NAME’, ‘fog’);[/code]

This should be the name of the database per default. If you edited the file or this isn’t set correctly, it should, at the least tell what the new database name is being referenced.

[Josh Scoville]

That’s weird. It says fog in the name setting in the php file, but when I gype mysql > show databases; fog is not listed. I try a “use database” command, but it says access denied. Could it be hidden or something? It has to be there, obviously since the web interface is running?

Am I even on the right track trying to import this image table? Or should I just recreate the names?

[Tom Elliott]

I’d recommend recreate the names. I don’t know why the db is reporting that it’s access is denied, but maybe the user you’re logged into mysql with isn’t allowed?

[Josh Scoville]

OK, this is weird. I thought I’d try creating a new image and see if I can get it to work. This time when I click the button to add the image, I get a schema update message, so I click the button to update.

I get a tone of errors back inclucing the following:

[CODE]Update/Install Failed!
The following errors occured

Update ID: 1 - 0

Database Error:

Database SQL:

CREATE DATABASE fog

Update ID: 1 - 1

Database Error:

Database SQL:

CREATE TABLE fog.groupMembers (
gmID int(11) NOT NULL auto_increment,
gmHostID int(11) NOT NULL,
gmGroupID int(11) NOT NULL,
PRIMARY KEY (gmID),
KEY new_index (gmHostID),
KEY new_index1 (gmGroupID)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

Update ID: 1 - 2

Database Error:

Database SQL:

CREATE TABLE fog.groups (
groupID int(11) NOT NULL auto_increment,
groupName varchar(50) NOT NULL,
groupDesc longtext NOT NULL,
groupDateTime datetime NOT NULL,
groupCreateBy varchar(50) NOT NULL,
groupBuilding int(11) NOT NULL,
PRIMARY KEY (groupID),
KEY new_index (groupName)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Update ID: 1 - 3

Database Error:

Database SQL:

CREATE TABLE fog.history (
hID int(11) NOT NULL auto_increment,
hText longtext NOT NULL,
hUser varchar(200) NOT NULL,
hTime datetime NOT NULL,
hIP varchar(50) NOT NULL,
PRIMARY KEY (hID)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Update ID: 1 - 4

Database Error:

Database SQL:

CREATE TABLE fog.hosts (
hostID int(11) NOT NULL auto_increment,
hostName varchar(16) NOT NULL,
hostDesc longtext NOT NULL,
hostIP varchar(25) NOT NULL,
hostImage int(11) NOT NULL,
hostBuilding int(11) NOT NULL,
hostCreateDate datetime NOT NULL,
hostCreateBy varchar(50) NOT NULL,
hostMAC varchar(20) NOT NULL,
hostOS int(10) unsigned NOT NULL,
PRIMARY KEY (hostID),
KEY new_index (hostName),
KEY new_index1 (hostIP),
KEY new_index2 (hostMAC),
KEY new_index3 (hostOS)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Update ID: 1 - 5

Database Error:

Database SQL:

CREATE TABLE fog.images (
imageID int(11) NOT NULL auto_increment,
imageName varchar(40) NOT NULL,
imageDesc longtext NOT NULL,
imagePath longtext NOT NULL,
imageDateTime datetime NOT NULL,
imageCreateBy varchar(50) NOT NULL,
imageBuilding int(11) NOT NULL,
imageSize varchar(200) NOT NULL,
PRIMARY KEY (imageID),
KEY new_index (imageName),
KEY new_index1 (imageBuilding)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Update ID: 1 - 6

Database Error:

Database SQL:

CREATE TABLE fog.schemaVersion (
vID int(11) NOT NULL auto_increment,
vValue int(11) NOT NULL,
PRIMARY KEY (vID)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC

Update ID: 1 - 7

Database Error:

Database SQL:

CREATE TABLE fog.supportedOS (
osID int(10) unsigned NOT NULL auto_increment,
osName varchar(150) NOT NULL,
osValue int(10) unsigned NOT NULL,
PRIMARY KEY (osID),
KEY new_index (osValue)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Update ID: 1 - 8

Database Error:

Database SQL:

CREATE TABLE fog.tasks (
taskID int(11) NOT NULL auto_increment,
taskName varchar(250) NOT NULL,
taskCreateTime datetime NOT NULL,
taskCheckIn datetime NOT NULL,
taskHostID int(11) NOT NULL,
taskState int(11) NOT NULL,
taskCreateBy varchar(200) NOT NULL,
taskForce varchar(1) NOT NULL,
taskScheduledStartTime datetime NOT NULL,
taskType varchar(1) NOT NULL,
taskPCT int(10) unsigned zerofill NOT NULL,
PRIMARY KEY (taskID),
KEY new_index (taskHostID),
KEY new_index1 (taskCheckIn),
KEY new_index2 (taskState),
KEY new_index3 (taskForce),
KEY new_index4 (taskType)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Update ID: 1 - 9

Database Error:

Database SQL:

CREATE TABLE fog.users (
uId int(11) NOT NULL auto_increment,
uName varchar(40) NOT NULL,
uPass varchar(50) NOT NULL,
uCreateDate datetime NOT NULL,
uCreateBy varchar(40) NOT NULL,
PRIMARY KEY (uId),
KEY new_index (uName),
KEY new_index1 (uPass)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

Update ID: 1 - 10

Database Error:

Database SQL:

INSERT INTO fog.users VALUES (‘’,‘fog’, MD5(‘password’),‘0000-00-00 00:00:00’,‘’)

Update ID: 1 - 11

Database Error:

Database SQL:

INSERT INTO fog.supportedOS VALUES (‘’,‘Windows XP’, ‘1’)

Update ID: 1 - 12

Database Error:

Database SQL:

INSERT INTO fog.schemaVersion VALUES (‘’,‘1’)

Update ID: 2 - 0

Database Error:

Database SQL:

INSERT INTO fog.supportedOS VALUES (‘’,‘Windows Vista’, ‘2’)[/CODE]

[Jose Antonio Sanchez]

I keep getting the “Database Schema Installer / Updater” message this all the time now with clean installs of FOG 1.2.0 (three different FOG Servers).

The server works, then I can create images at first, deploy them, then after a while, boom! nothing. All I get is the “Database Schema Installer / Updater” page.

Is there a fix for this? I left the MySQL password blank and tried the fixes other’s used as indicated on this thread. How can I avoid this? I can’t deploy images now…

Any help appreciated.

Thank you.

[Tom Elliott]

Grrr, Read the forums.

Anyway,

Check the /opt/fog/.fogsettings specifically the snmysqlpass variable setting and make it B"" in the case of blank, or set it to that of the mysql root password you need.

[Jose Antonio Sanchez]

Tom,

I already tried that. Still no luck… Something seems to be triggering an “update” for the schema.

.fogsettings file (bottom part only):

password=“”;
osid=“2”;
osname=“Debian”;
dodhcp=“n”;
bldhcp=“0”;
installtype=“N”;
snmysqluser=“”
snmysqlpass=“”;
snmysqlhost=“”;
installlang=“0”;
donate=“0”;
fogupdateloaded=“1”

[Tom Elliott]

Does your database have a password?

You can test with:
[code]mysql -u root fog[/code]

If it gives you “USING PASSWORD: NO” but fails to connect, it’s likely you have a mysql root password set.

[Josh Scoville]

Can anyone give any help on how to get existing image files to work with a new install (or at least point me to the right forum)? These are from a 0.32 server and it is going to be a lot of work to reimage/reupload them.

I have tried a new image, definition, but it does not see the size of the existing image file, even though they are named teh same. Also when I download it, it says “this is not a partclone image”

Thanks!

[Junkhacker]

enable the image format flag in gui, set the image format to partimage, make sure the permissions and ownership of the files is right, and stop asking questions in an announcement thread

[Jose Antonio Sanchez]

[quote=“Tom Elliott, post: 34447, member: 7271”]Does your database have a password?

You can test with:
[code]mysql -u root fog[/code]

If it gives you “USING PASSWORD: NO” but fails to connect, it’s likely you have a mysql root password set.[/quote]

Tom,

It went right in… no password set, and it took me to the “mysql>” prompt (it also displays MySQL version info before that - 5.5.38-0ubuntu.14.04.1 (Ubuntu))

[Josh Scoville]

[quote=“Junkhacker, post: 34451, member: 21583”]enable the image format flag in gui, set the image format to partimage, make sure the permissions and ownership of the files is right, and stop asking questions in an announcement thread[/quote]

Thanks for the info. That was invaluable and worked! Sorry for asking in an announcement thread, didn’t realize I was in one.

Thanks,

[Tom Elliott]

[quote=“Jose Antonio Sanchez, post: 34455, member: 25349”]Tom,

It went right in… no password set, and it took me to the “mysql>” prompt (it also displays MySQL version info before that - 5.5.38-0ubuntu.14.04.1 (Ubuntu))[/quote]

Then can you check the /var/www/fog/lib/fog/Config.class.php file specifically under the db_settings() method and make sure the DATABASE_HOST is localhost, DATABASE_NAME is fog, DATABASE_USERNAME is root, and DATABASE_PASSWORD is ‘’

[Jose Antonio Sanchez]

Tom,

Yes, confirmed, the settings are as follows on /var/www/fog/lib/fog/Config.class.php

DATABASE_HOST ‘localhost’
DATABASE_NAME ‘fog’
DATABASE_USERNAME ‘root’
DATABASE_PASSWORD ‘’

[Tom Elliott]

Can you try:
sudo service mysql restart, or simply a system reboot? Maybe firewall is blocking access to mysql from your systems?

[Jose Antonio Sanchez]

Tom,

I restarted the server several times, and it seemed to load the web interface but then a minute after it was displaying the “Database Schema Installer / Updater” accompanied by the client PCs not able to load anything from TFTP… This is the same for the other two FOG Servers I installed from scratch on Ubuntu 14.04.

Here are the steps I followed, in case they are of help:
[LIST]
[]Installed Ubuntu 14.04 from flash drive with options:
[LIST]
[]Download Updates during Install
[]Erased Hard drive (it was brand new but nothing else installed)
[]Restarted
[]Installed all Ubuntu updates (nothing else added or installed)
[]Restarted
[/LIST]
[]Installed FOG 1.2.0 from TAR:
[LIST]
[]Downloaded FOG 1.2.0
[]tar xvzf fog_1.2.0.tar.gz
[]sudo ./installfog.sh
[LIST]
[]Followed prompts for Debian (Ubuntu install)
[]Normal Install
[]No DHCP
[]Selected appropriate Router Address
[]Entered DNS IP
[]Left MySQL password blank
[]Logged in to web interface to install Schema
[]Hit Enter to proceed
[/LIST]
[/LIST]
[/LIST]
After that I did:
[LIST]
[]Quick registered host with Master Image
[]Capture image from first host (Image ID # 1)
[]Full hosts registration for 29 computers
[LIST]
[]Selected Image ID 1 for all hosts
[/LIST]
[]Created group for the 29 computers (computer lab)
[]Multicasted image to 29 clients
[]Shut down server (yesterday)
[]Turned on server today
[*]Tried to multicast image again on the next day (we were testing imaging) and started to get the page for the schema update
[/LIST]
EDIT:

• Created user to allow login via PXE Menu
• Edited the PXE Menu to Timeout 5 seconds and Hide menu - Press F9 to login

[Tom Elliott]

Okay, so the issue, I believe, is because if ibdata.log.

Try the steps at the top of this issue in my github?
[url]https://github.com/mastacontrola/fogproject/issues/1[/url]