Posts made by Josh Scoville

When I try to run this script, it says that it will use my old IP address, not the current and correct one. How do I modify the script to put in the right IP? When I hit N for no, it exits.

Sure. At this point, I will try anything.

No sir, it is Windows 7. Sorry for not putting that in.

I am having a similar issue here in that I upload an image, but I can’t download/deploy it. Last Friday when I tried, I attempted download, but teh old image deployed, even after deleting the files (I thought_ in the web portal. Today, I deleted the image and checked the box to delete files, so I could reupload. When I console into the server, I still see the files in /images/LatitudeE5510 which is where it says the image should be. This time I deleted through the web portal, then went in via SSH and removed the files and the directory inside /images. I double checked using ls command and the directory was gone. So I reuploaded my syspreped image after creating it again. Now when I go to deploy the image, it says it can’t find the image store. The LatitudeE5510 directory has not been created inside /images.

I did not previously know about the /images/dev directory and when I look inside there, I see several MAC addresses, one being my upload machine.

Is something not moving these files where they should be or something? I had previously looked at the permissions and /images had group and owner and everyone having read/write acccess.

Just wondering where my images are and why I can’t deploy? I am running version 1.2 on Ubuntu server.

Hi,

I have tried all I know to try, but still can not get these machines to boot. Running Fog 1.2 on ubuntu server. I keep getting error:

could not boot: input/output error [url]http://ipxe.org[/url]
Exiting Broadcom PXE Rom

I disabled spanning tree on my edge switch, I changed the dhcp boot file to unioinly.kkpxe from kpxe. I don’t know where to go from here.

Thanks!

[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,

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!

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]

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

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!