Nothing Shows in Graph Mgmt after Creating

[dlockwood]

I'm working on a new install of Cacti running the following builds:

Cacti .0.8.6h
Cactd .0.0.6g
mySQL 5.0.21
PHP 5.1.4
RRDtool 1.2.12

After following the install guide I am able to see data graphed for my localhost. I subsequently added several Cisco routers through the "Devices" link. SNMP data is returned fine and when I click "* Create Graphs for this Host" I am presented with a list of interfaces for the router. I pick the interfaces that I want to be graphed and click "Create". No errors are shown, but no entries are created in the "Graph Management" section.

A manual query of "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 5) ORDER by host_id" shows only the five (5) entries that are associated with my 'localhost' device. Does anyone know why the router interfaces are not being inserted to the DB? Clearly I am overlooking something simple.

Best regards,
Dan

[BSOD2600]

Hmm, thats odd. while in graph management, from the host dropdown box, select one of your routers. There are no graphs? What about in the Data Sources section; any for your routers?

Did you apply all the patches for cacti?

[dlockwood]

When selecting the 'Any' filter, five (5) rows are returned when I look at data sources; these relate the the localhost. There are four (4) rows returned when looking at graph management, also related to the local host. Nothing for the other routers.

I believe that i'm patched correctly. I copied all the files from the 'cacti-0.8.6.pre-patched' folder to my Cacti web folder at 'c:\inetpub\wwwroot\cacti\'. Not to be over specific be I do want to make sure that I have infact followed the instructions. I have attached screenshots for the graph mgmt and data sources screens.

Also, when I 'create' the graphs for the router interfaces, there is text at the top of the following page (after clicking create) that indicates that the graphs were successfully created. This clearly isn't the case, but thought it might help narrow the search.

[BSOD2600]

Did you follow the installation guide in my signature or from the website? If the latter, you really should re-read over my guide in case you missed something.

As for the localhost stuff being there, what it's set up for won't work because its using linux templates. My install guide instructs you to delete it and recreate it using the windows host template stuff.

Yes, that is the correct way to patch.

Are you running in sql-strict mode (check in my.ini) ? If so, disable it. You also *must* have patched cacti and cacti.sql before importing cacti.sql into the mysql database.

[dlockwood]

After reinstalling the DB several times I must have missed the part about deleting and recreating the sample localhost device. I disabled strict mode in mySQL which seems to have solved the problem. I didn't see any reference to it in the setup guide so the data below summarizes the change that I made to the my.ini file. Hopefully this will help someone googling in the future.

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

I commented out the top line (original) and added the second line.

Thanks!
Dan