graphing stops until a reboot

[BSOD2600]

php-cgi.exe is supposed to stay running for a predetermined time... it's that FastCGI process. this isnt the source of your problem.

[bonj87]

i havent ever update php on the server... does the newest CACTI work with php 5.3?

[BSOD2600]

Yes, php 5.3.x works fine as does mysql 5.5.x

[bonj87]

great..now i gotta figure out how to update both

[BSOD2600]

Both should install/upgrade over the previous just fine... as usual, make a backup of your cacti data before doing so.

[bonj87]

ok i havent rebuilt it yet, as im waiting on a new pc to do it all fresh..
however, on a hunch i went to do a database repair.. i got this..

any idea on how to find which one is the problem?

i ran
php <cactipath>\cli\repair_database.php


which produced..
Repairing Table -> 'snmp_query_graph_sv' Successful
Repairing Table -> 'thold_data' Successful
Repairing Table -> 'thold_template' Successful
Repairing Table -> 'user_auth' Successful
Repairing Table -> 'user_auth_perms' Successful
Repairing Table -> 'user_auth_realm' Successful
Repairing Table -> 'user_log' Successful
Repairing Table -> 'version' Successful
Repairing Table -> 'weathermap_auth' Successful
Repairing Table -> 'weathermap_data' Successful
Repairing Table -> 'weathermap_groups' Successful
Repairing Table -> 'weathermap_maps' Successful
Repairing Table -> 'weathermap_settings' Successful

NOTE: Checking for Invalid Cacti Templates
NOTE: 1 Invalid Data Input Data Rows Found in Data Templates

WARNING: Serious Cacti Template Problems found in your Database. Using the '--f
orce' option will remove
the invalid records. However, these changes can be catastrophic to existing dat
a sources. Therefore, you
should contact your support organization prior to proceeding with that repair.

[BSOD2600]

Does \cacti\cli\repair_templates.php report any problems?

After backing up the database, go ahead and run repair_database.php -f -v and see what it repairs.

[bonj87]

after i ran the repair.

cacti\cli\repair_templates.php

cacti\cli\repair_templates.php
Did not find 'mgmt' in module RFC1155-SMI (C:\php\extras\mibs/RFC1213.mib)
Unlinked OID in RFC1213-MIB: mib-2 ::= { mgmt 1 }
NOTE: Performing Check of Templates
NOTE: Performing Check of Data Templates
NOTE: No Damaged Data Templates Found
NOTE: Performing Check of Graph Templates
NOTE: No Damaged Graph Templates Found

my graphing still stops, but if i mess around with a bit.. do a database table check.. optimize or repair (even with no problems reported).. or clear the poller cache or reboot the server, it starts working.. ive been trying different combinations but cant find one ,specifically that will work to keep it graphing.. im thinking... maybe there is an issue with the database... is there a way to make a new database?

[BSOD2600]

sounds like there are other issues with the server which are affecting Cacti. ran a chkdsk /f yet?

yes, you can create a new database, knowing that all your existing graphs/templates/configurations will be lost. the collected data still resides in the *.rrd files though.

Code: Select all

mysql --user=root --password drop database cacti
mysqladmin --user=root --password create cacti
mysql --user=root --password cacti < C:\Inetpub\wwwroot\cacti\cacti.sql