IPXE problems with Broadcom netXtreme II

[Tom Elliott]

emkey,

Do you have a gmail address you can share with me and BPSTravis in Convo?

[emkey]

Yes, I will send you an address today.

Meanwhile I tried a fresh installation and during the db schema installation I got the following error:
[CODE]Update/Install Successful!

Click here to login.

The following errors occured
Update ID: 130 - 5

Database Error:

No database selected
Database SQL:

INSERT INTO fog.hostMAC (hmMAC,hmHostID,hmPending) (SELECT pmAddress,pmHostID,‘1’ FROM pendingMACS)[/CODE]

I think there is an error in the db setup script. Can you hint me where I can fidn it?

[BPSTravis]

If it’s a true fresh install there are no hosts to move so that won’t even matter.

[emkey]

Yes, it is. The only thing I reused is my datastore I mount as /images folder.

After installation again i can log in and everything looks quite fine. But again newly added hosts are not shown in the host list.

[BPSTravis]

Can you pull your /var/log/apache2/error.log? Are there any errors showing when viewing the hos list or searching for the newly added host? Better yet, is there an error when you create the new host(you can use tail-f /var/log/apache2/error.log to watch it real time.

Edit: I was able to duplicate this issue on my end, the issue is it’s inserting the mac record with no host id tied to it. We are looking into it and get back to you once we resolve it.

[BPSTravis]

This is now fixed in svn 2391.

[emkey]

I will check the new version tomorrow morning, otherwise I will provide you the error log.

Also: PM with email. But maybe this might be interesting for other people, too.

[emkey]

Okay, tried the new build. After not being able to add a host via pxe register or manually via the web interface I checked the database and the hostMAC field is missing on table hosts. As it is a fresh installation there still seems to be some faults in your database setup script.

Can you tell me where the script is located to check it for errors?

[Tom Elliott]

emkey,

We’re transitioning from multiple points of mac addresses to a single table.

That table is called hostMAC.

In that table you should notice that your MAC’s are associated by Primary MAC, Pending Mac’s and there’s a couple other fields.

There can only be one primary mac per host and it should have the relevant host’s id in the hmHostID field.

[emkey]

Hey there,

sorry for letting you wait this long. Today I found some time to test a little bit and things look a lot better meanwhile.

I did another fresh install from the current svn and now the iPXE boot works without any flaws! I will now test to Up- and Download some images. I will keep you up to date!