Could not image, Input/output error http://ipxe.org/Id0c6539

[george1421]

@Bob-Henderson sql server going away might cause your issue too. If you key in sudo ps aux|grep sql does it show the mysql server running?

[Bob Henderson]

@george1421

yep, and I can connect to it via the root login as well.

[george1421]

@Bob-Henderson I’m going to have to defer to the @Developers then so they can take a look at this error.

[Quazz]

Can you post default.ipxe here?

Just going to start over here.

Looks like a problem with the location plugin!

[Bob Henderson]

@Quazz
Content is:

#!ipxe
cpuid --ext 29 && set arch x86_64 || set arch i386
params
param mac0 ${net0/mac}
param arch ${arch}
param platform ${platform}
param product ${product}
param manufacturer ${product}
param ipxever ${version}
param filename ${filename}
isset ${net1/mac} && param mac1 ${net1/mac} || goto bootme
isset ${net2/mac} && param mac2 ${net2/mac} || goto bootme
:bootme
chain http://10.1.0.24/fog/service/ipxe/boot.php##params

[Bob Henderson]

@Quazz

Appears you’re right. I disabled the location plugin (we only have one location at the time anyways, so why bother) and it booted right up.

Now, I’m hoping to add a second location within the week here as a pure storage node, now that we finally got our high speed WAN in place. Hopefully this can be resolved by then, so I don’t have to worry about stuff pulling across the WAN!

[Wayne Workman]

@Bob-Henderson When you access the boot.php page, can you then immediately look at your apache error logs and see if there is anything relevant in there? They will have timestamps.
Web interface -> FOG Configuration -> Log Viewer -> Apache error logs

[Tom Elliott]

I’m fairly sure this is not related to the location plugin, at least not directly. I believe this is because the location that was trying to connect could not communicate with the database. I could be wrong, it happens a lot.

[Wayne Workman]

@Tom-Elliott Ah, right. That’s happening more often now.

@Bob-Henderson try to remotely connect to the fog server’s MySQL db using the fogstorage credentials and see what happens:
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Testing_MySQL

[Bob Henderson]

@Wayne-Workman I haven’t touched it in a while, but where do I grab the fogstorage credentials?

I can connect locally as the root user and such

[Wayne Workman]

@Bob-Henderson said in Could not image, Input/output error http://ipxe.org/Id0c6539:

where do I grab the fogstorage credentials?

Web interface -> FOG Configuration -> FOG Settings -> FOG Storage Nodes -> FOG_STORAGENODE_MYSQLUSER and FOG_STORAGENODE_MYSQLPASS

[Bob Henderson]

When I attempt that, I get ERROR 2003 (HY000): Can’t connect to MySQL server on ‘10.1.0.24’ (111) . Tried from 2 other linux boxes.

[Tom Elliott]

@Bob-Henderson on your main server cd to /etc and run grep -rl bind-address .

You will need to figure out the right file but edit them and comment the bind-address lines so they read as #bind-address = 127.0.0.1 then save the files. Once done restart MySQL services and try again.

[Bob Henderson]

@Tom-Elliott

After getting rid of the localhost bind, I can login fine. No issues at all.

[Tom Elliott]

I’ll bet your location will work fine now too.

[Bob Henderson]

@Tom-Elliott Sure does. Thanks for the help!