Latest FOG 0.33b
-
Update: we’ve installed 12.04 fog R976.
Everything works fine until we import our SQL from .32 .
33b goes nuts, throws errors , any suggestions ?I’m assuming the exported SQL database is not compatible with .33b so what changed.
-
You must remember that, more or less, FOG 0.33b was a complete rewrite of the original code from 0.01 thru 0.32. Many things got changed. It is not recommended to use 0.32 database for 0.33 as it’s too difficult to determine exactly all the changes between the two. I can provide a diff file if necessary, but it’s quite a bit of change. For one, hosts no longer has a hostOS field for example. I do understand the reasoning for wanting to import the old database and am working on trying to figure out the best approach to this, but in the mean time, the best recommendation I can give is to export the elements you need for sure. When exporting the Hosts, export only the name mac and, as necessary or possible, the imageID. Exporting the images get the path, imageID, and name if you can. Also, when exporting do a right inner join to obtain the OSID from the 0.32 code for implementation into 0.33 images field. This last part is especially important as otherwise the system won’t know what OS it is and everything, I imagine, would try to be dd imaged if I understand the fog scripts well enough.
I’m sure there’s other things to need as well, but there is so many changes between the two databases.
-
[quote=“Tom Elliott, post: 18358, member: 7271”]r976 released,
Fixes type on ImageManagementPage for editing the images.
Also corrects the Host edit to keep you from having to change the hostname any time you make a change to some field other than the hostname.[/quote]
Hmm… I see you didn’t use my patch, and removed the internationalization support on ImageManagementPage.class.php line 243… Not sure that’s a good thing
[code] <h2><?php print “Edit image definition”; ?></h2>[/code]
Also at some point, I think I could bring a lot of help in there, but is there :
- a project management tool (or is it the forum) ?
- a project leader, or some roadmap (besides ironing out the new 0.33 OO code) ?
- coding guidelines ?
and who manages the SVN access on SF ? In case, my SF id is gilou-epik.
-
[quote=“Gilou, post: 18381, member: 3221”]Hmm… I see you didn’t use my patch, and removed the internationalization support on ImageManagementPage.class.php line 243… Not sure that’s a good thing
[code] <h2><?php print “Edit image definition”; ?></h2>[/code][/quote]
How do you say I didn’t use the patch file?
According to your description:
[code]- <h2><?php print _(“Add new image definition”); ?></h2>
-
<h2><?php print _("Edit image definition"); ?></h2>[/code] These were the referenced variables.
The only thing I did was remove the _() parts. Maybe I just don’t understand, but what exactly does the _( ) wrapping actually do?
I tried researching it, but it’s kind of difficult even with the best google ninja’s.
-
-
It is a wrapper for the gettext function, that uses the .pot file as a reference to ease the translation in other languages.
-
I found that out and am changing all the elements that I remove the _() tags from right now. I didn’t now. I’m sorry I was so STOOPID
-
ok… we’ve finessed our export/imports and are confident we can make 033b happen. However one tiny problem that’s probably easy to fix., when you search for any piece of hardware like a serial number or asset tag, search results are 0.
We use this quite extensively to search for Dell tags.Can you try on in your database to search for something in the hardware… like [FONT=Ubuntu][COLOR=#555555]System Serial Number ?[/COLOR][/FONT]
-
Yes I can,
Relatively speaking this is very easy, except the search protocols don’t look at the inventory tables … yet, I’ll try to look into this over the weekend if that’s okay!
-
yes ! that’s fine… we do appreciate the time and effort ! Fog is the cornerstone of our IT department
-
I already have this figure out and, somewhat, tested.
For all:
Not only can you now search for host by hostname, mac, id, description, serial, or what have you! You can also search for a host by group name from the hosts page, and you can search for a group containing a specific hostname. I thought this could be useful and hope you all think the same.
r979 out.
Something to be aware of, as well,
Searching by ID’s isn’t supported, yet. It would only take an add to the searchQuery string in <class>Manager.class.php though!
-
[quote=“Ed Blom, post: 18407, member: 2503”]ok… we’ve finessed our export/imports and are confident we can make 033b happen. However one tiny problem that’s probably easy to fix., when you search for any piece of hardware like a serial number or asset tag, search results are 0.
We use this quite extensively to search for Dell tags.Can you try on in your database to search for something in the hardware… like [FONT=Ubuntu][COLOR=#555555]System Serial Number ?[/COLOR][/FONT][/quote]
how did you export and import from .32 to .33
-
exported from .32 using phpmyadmin.
What was important for us was the host name, mac address and hardware info.
So we exported to .csv format the hosts from the old .32 install.
Finessed the data in excel, we had to add four columns. then imported the .csv in the new install.
same with printers and images.
The easiest one was inventory -which holds all your hardware info, this was a straight SQL export.So you need to csv export:
-
hosts
-
images
-
printers -if you use printers-
-
inventory (SQL table export)
Then use phpmyadmin on .33 and import into the sql.
I can be more specific, but that’ll be Monday when I’m back at work.
-
-
Thank you ed.
-
r981 out.
Added ID searching fields to the Group and Host searching elements.
Still working towards reintegrating Internationalization bits, but almost there!.
Moved inventory display to Inventory Class.
-
Hmm I’ve imported all my stuff and search does not work
-
You may have to ensure the hostid matches the inventory hostid
-
Also,
Have you upgraded to the latest revision? I’m guess you have, but that would only leave the thought from above. When you imported the hosts, did you import as CSV? If you did with CSV, it recreates the hostID’s so the Inventory table’s iHostID would be incorrect.
-
Yes I’m on R982, I’ve imported the hostid’s from CSV into a testserver then exported the SQL to my NEW testserver… I’ll double check, I can click on hardware for a host and get the correct info
BTW a search for a dell[FONT=sans-serif][COLOR=#000000] service tag, results in fog showing me all my hosts[/COLOR][/FONT]
-
What element of the search are you looking for?
Here are all the options that are searched for:
[php] public $searchQuery = ‘SELECT hosts.* FROM hosts
LEFT OUTER JOIN
(SELECT * FROM hostMAC WHERE hmMAC LIKE “%${keyword}%”) hostMAC
ON (hmHostID=hostID)
LEFT OUTER JOIN
inventory
ON (iHostID=hostID)
LEFT OUTER JOIN
(SELECT * FROM groups INNER JOIN groupMembers ON (gmGroupID=groupID) WHERE groupName LIKE “%${keyword}%” OR groupDesc LIKE “%${keyword}%”) groupMembers
ON (gmHostID=hostID)
WHERE
hostID LIKE “%${keyword}%” OR
hostName LIKE “%${keyword}%” OR
hostDesc LIKE “%${keyword}%” OR
hostIP LIKE “%${keyword}%” OR
hostMAC LIKE “%${keyword}%” OR
groupID LIKE “%${keyword}%” OR
groupName LIKE “%${keyword}%” OR
groupDesc LIKE “%${keyword}%” OR
iSysserial LIKE “%${keyword}%” OR
iCaseserial LIKE “%${keyword}%” OR
iMbserial LIKE “%${keyword}%” OR
iPrimaryUser LIKE “%${keyword}%” OR
iOtherTag LIKE “%${keyword}%” OR
iOtherTag1 LIKE “%${keyword}%” OR
iSysman LIKE “%${keyword}%” OR
iSysproduct LIKE “%${keyword}%”
GROUP BY
hostID DESC’;[/php] -
[FONT=Ubuntu][COLOR=#555555]If I do a search for [/COLOR][/FONT][FONT=monospace][COLOR=#dd0000]iSysserial[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#555555]HDYZDK1 or a host [/COLOR][/FONT][FONT=Ubuntu][COLOR=#555555]name like 2014-spare-01 or part of a name[/COLOR][/FONT]
[FONT=Ubuntu][COLOR=#555555]Fog will show ALL my hosts.[/COLOR][/FONT][FONT=Ubuntu][COLOR=#555555]Also doublechecked my hostID and inventory iHostID they match.If I seach for something I know is not there I get an error searching message.[/COLOR][/FONT]
