error:Table 'cacti.manage_host' doesn't exist

grodno5 · Post by **grodno5** » Fri Jul 14, 2006 8:37 am

does anyone know how to fix this error?
error:Table 'cacti.manage_host' doesn't exist
look for more info few topics above

ddonohue · Post by **ddonohue** » Fri Jul 14, 2006 8:39 am

i had to fix this w/ permissions i think it was. If not permissions, i think it was the 2-3 upgrade, the alter statement didn't work right, so, i kinda had to hack it apart and make it work right for me, then run the rest of the upgrade by hand.

grodno5 · Post by **grodno5** » Fri Jul 14, 2006 8:48 am

is there any way that you can provide more detail, so i can fix my stuff. At this time nothing works at all and i'm getting that stupid error when i go to the browser. And just to mention, i'm on the latest cacti version
thanks

ddonohue · Post by **ddonohue** » Fri Jul 14, 2006 9:16 am

well, i'm on unix, and the permissions on the folder, was different b/c i unziped it as root, therefor i had to do this

cd /cacti/plugins

chown -R cacti manage

After doing that, i was able to do it without problem.

grodno5 · Post by **grodno5** » Fri Jul 14, 2006 9:20 am

well, in my case i'm on unix too, but permission are the same as for all other plugins and it still doesn't work. It looks to me that somehow it's related to the SQL tables, but i'm not sure. I hope there someone who migh know how to fix it.
thanks

ddonohue · Post by **ddonohue** » Fri Jul 14, 2006 9:26 am

what i had to do , is open up the .sql files and look for the creation of the manage_host table, and then log into mysql and create it by hand.

I found this is manage-0.1.sql

CREATE TABLE manage_host ( id mediumint(8) unsigned NOT NULL default '0', uptime bigint(20) default NULL, type mediumint(8) unsigned NOT NULL default '0', services text, statut text);

I then logged into mysql

mysql cacti as root, w/ password

then ran the above line. Your line will be different depending on user/auth.

After doing this to create the table, i then, ran the other 2 updates, the same way you normally wold

mysql <cactidb> < upgrade-0.1-0.2.sql
mysql <cactidb> < upgrade-0.2-0.3.sql

grodno5 · Post by **grodno5** » Fri Jul 14, 2006 9:44 am

thanks a lot. looks like this solve the problem. Now i have to figure out how to configure and use this plugin.
One more question for you. By any chance you have MACtrack plugin installed? How does it work? For some reason it doesn't give me any information when i search by IP, name or MAC. Is there something else i need to do with that?
thanks in advance.

Cacti