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?
 
advegaConnect With a Mentor Commented:
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
 
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
 
arnoldConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.