Version 1.2.0 released!
-
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.
-
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.
-
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?
-
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?
-
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 occuredUpdate 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
),
KEYnew_index
(gmHostID
),
KEYnew_index1
(gmGroupID
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMICUpdate 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
),
KEYnew_index
(groupName
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1Update 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=latin1Update 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
),
KEYnew_index
(hostName
),
KEYnew_index1
(hostIP
),
KEYnew_index2
(hostMAC
),
KEYnew_index3
(hostOS
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1Update 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
),
KEYnew_index
(imageName
),
KEYnew_index1
(imageBuilding
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1Update 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=DYNAMICUpdate 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
),
KEYnew_index
(osValue
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1Update 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
),
KEYnew_index
(taskHostID
),
KEYnew_index1
(taskCheckIn
),
KEYnew_index2
(taskState
),
KEYnew_index3
(taskForce
),
KEYnew_index4
(taskType
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1Update 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
),
KEYnew_index
(uName
),
KEYnew_index1
(uPass
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1Update 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] -
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.
-
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.
-
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” -
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.
-
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!
-
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=“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))
-
[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,
-
[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 ‘’
-
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 ‘’ -
Can you try:
sudo service mysql restart, or simply a system reboot? Maybe firewall is blocking access to mysql from your systems? -
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
-
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] -
[quote=“BigDawg986, post: 34017, member: 75”]Thanks, I should have figured as much but whenever I set up multiboots I always put each OS in a separate partition so that’s why I asked.[/quote]
which option should I choose to get an image (from win/lin disc) resizable?
my settings:
Operating System: Other (99)
Image Type: Single Disk (Resizable) -(1)What i have to do, to clone from 250GB to 160GB (hd size) ?
Thanks and sorry about my inexperience
-
Choose either Linux or Windows OS type, not other.