Cacti No Graph Display

Hi,

My Graph server - CACTI stopped displaying graph after a reboot yesterday. the reason for reboot was server not responding. during bootup, OS informed file system corrupted and we performed fsck -y. this process got through and able to boot into OS.
We use CentOS, CACTI version 0.8.7c

Currently we are able to login into cacti but only able to see old graph. no new graph are displayed.
I tried to choose one of the graph for real-time display and able to see graph on that window.
at this point i am sure that polling process is working, just that no graph is updated to normal view.

I am attaching 2 image here to clarify


 realtime normal view
Kindly tell me how to fix this.
AntonVQAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
Does it report any errors?  You may need to reset the poll cache.
Double check that it can poll the servers in that it is supposed to graph.

You should consider updating as your cacti version is somewhat outdated.
Double check that your mysql database is not corrupt preventing the normal operation of cacti data collection.
tail /var/www/html/cacti/log/cacti.log
tail /var/log/mysqld/mysqld.log
0
AntonVQAuthor Commented:
Hi,

the cacti.log is not having output.

[root@traffic2 log]# pwd
/var/www/html/log
[root@traffic2 log]# ls -l
total 4
-rw-r--r--  1 root   root   52 Apr 10 14:40 boost.log
-rw-rw-rw-  1 apache apache  0 Apr  9 04:02 cacti.log
-rwxrwxrwx  1 apache apache  0 Apr  8 04:02 cacti.log.1
-rwxrwxrwx  1 apache apache  0 Apr  7 04:02 cacti.log.2
-rwxrwxrwx  1 apache apache  0 Apr  6 04:02 cacti.log.3
-rwxrwxrwx  1 apache apache  0 Apr  5 04:02 cacti.log.4
-rwxrwxrwx  1 apache apache  0 Apr  4 04:02 cacti.log.5
-rwxrwxrwx  1 apache apache  0 Apr  3 04:02 cacti.log.6
-rwxrwxrwx  1 apache apache  0 Apr  2 04:02 cacti.log.7

I am not sure why there is a +x permission on all cacti.log files, i tried remove the +x, but still the same

mysqld.log

110410 14:40:30  mysqld started
110410 14:40:31 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
110410 14:40:31 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
110410 14:40:31  InnoDB: Started; log sequence number 0 45702
110410 14:40:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.82sp1'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

I did a SNMP interface verbose query on a switch and able to get SNMP response

+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/html/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.1' value: '1'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.2' value: '2'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.3' value: '3'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.4' value: '4'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.5' value: '5'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.6' value: '6'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.7' value: '7'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.8' value: '8'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.9' value: '9'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.10' value: '10'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.11' value: '11'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.12' value: '12'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.13' value: '13'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.14' value: '14'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.15' value: '15'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.16' value: '16'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.17' value: '17'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.18' value: '18'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.19' value: '19'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.20' value: '20'
......

How to check if mysql database is working fine?



0
arnoldCommented:
Does your cacti related cron job run under the apache account or do you have it running under a cacti account?
Using the cacti web interface see whether it can get data for one of the devices and if not it should tell you what the error ie.
You may have to reset the polling cache.

Are you using cmd.php or poller.php?

Check the cacti log for errors.

mysqlcheck -u <username> -p<password> cacti
This will report the status of the table.  You will get errors if the cacti poller or being accessed at the time.


If you have SELinux enabled, check context for cacti
ls -lZ /var/www/html/cacti/

check table (list of tables)
myisamcheck is also a tool, but your setup seems to be using innodb engine.

http://www.felipecruz.com/repair-mysql-database.php
0
Daniel VegaCommented:
Wouldn't it be some file system full?
why dont' you check your system messages log?
Commonly found at  /var/log/messages or /var/adm/messages

Now to check if mysql is working OK, go into your  MySQL data_dir  and look for a file called yourhostname.err and display it to see all the log, or go to the point with last command, let's say:
# tail -20 /var/mysql/data/traffic2.err

Open in new window

Hope this helps...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Unix OS

From novice to tech pro — start learning today.