Issue with the inventory (SVN 3067)
-
Looks like a null hostID in the mysql table. What was the host name?
-
host name is TC102-11,
-
Can you login to the mysql database?
[CODE]mysql -u root fog[/CODE]Then run:
[code]delete from hosts where hostName=“TC102-11”;[/code]Report back with the message right after. Should looks something like [code]Query OK, 1 rows affected (0.00 sec)[/code]
-
did it, the issue remains the same (0 rows affected)
i have dropped the database (fog) and let fog make a new empty database
the issue still remains the same, it will not save the inventory in the inventory table and it’s stuck on “attempting to save inventory…”
the system is registered in the host table. -
Let’s see if you are getting the same issue as I am.
Boot the host into network and on the FOG Menu select “Client System Information (Compatibility)” THEN hit option 2 “Ip Information”
What is the Link encap and inet addr?
-
link encap: Ethernet inet addr: 192.168.51.61
this seems ok to me? -
excellent. Not the same related issue. Please update to r3068. Tom has fixed the inventory issue.
-
just update to r3068
inventory will save in table inventory now, only with iID 0 ?
but still no show in web ui (no result found)
will try tomorrow with a empty database… -
considering you DROPPED the database I would say you created that issue.
-
ok, did restore the database from a backup before I dropped the database. normally this works.
-
but your right this does point out something interesting that should not have happened.
-
You failed to mention that other information in the table is not filled out either. for example: (Invalid iID and missing info)
| 0 | 1081 | | | | 2015-03-03 09:38:54 | 0000-00-00 00:00:00 | | | | | | | | | | | | | | | | | | | | | | | | | |
but with Tom’s new update it is now: (valid iID but missing info)
| 749 | 1083 | | | | 2015-03-03 12:38:01 | 0000-00-00 00:00:00 | | | | | | | | | | | | | | | | | | | | | | | | | |
Tom is checking into the blank info and why it is not saving. -
[SIZE=4][FONT=arial][COLOR=#222222]couldn’t resist[/COLOR] to install r3072, it seems my issues are solved…:)[/FONT][/SIZE]
[SIZE=4][FONT=arial]what a great support :)[/FONT][/SIZE]
[SIZE=4][FONT=arial]I am very very grateful…:)[/FONT][/SIZE]