[SOLVED] Cacti / SNMP problem, wrong data.Also broken forum?

[mwadham]

your forum is broken! just tried posting and got:

------------
Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' forum_topics = forum_topics + 1 WHERE forum_id = 2' at line 2

UPDATE forums SET forum_posts = forum_posts + 1, forum_last_post_id = , forum_topics = forum_topics + 1 WHERE forum_id = 2

Line : 423
File : functions_post.php

[mwadham]

Let's see if i can reply to this post with the post that keeps generating the above error...

------------------

Hi,

I don't really understand Cacti to any great degree so I apologise if this is a trivial matter, but it's rather confusing.

We have recently changed the name of an interface on our core router but when executing the query via Cacti it seems to be sticking with the old information. The community string and other variables are all correct as a manual snmpwalk command does retrieve information back from the device, however I don't know how to manually retrieve interface names from it.

I have attached a screenshot from Cacti, which shows what comes up when I click "create graphs for this host". The problem is with the last line of output, the interface name, which I unfortunately have to blank out for company confidentiality, is still coming up as the old interface name.

How can I firstly query the router directly to make sure that it's returning the correct name, and secondly if it is returning the correct name, why isn't cacti picking this up?

Any troubleshooting steps or advice would be much appreciated.

[mwadham]

Weird how that now works but wouldn't let me create a post with it :/

Anyways here's the screenshot mentioned above.

[fmangeant]

Hi

can you click on the green circle to re-run the data query ?

[mwadham]

Hi,

Yeah we did that - the information doesn't change.

[fmangeant]

Can you run that :

Code: Select all

$ snmpwalk -v 1 -c yourcommunity xx.xx.xx.xx ifalias

[mwadham]

That command returns the correct information from the router.

[mwadham]

This is fixed - wrong version of SNMP was specified.

Apologies and thanks for the help