[SOLVED] no rrd files being generated

[Andy1972]

Hi @ll,

as im about to cut my server into pieces i will try this way before

Yesterday i've installed rrdtool and cacti 0.8.6i.
First everythings seems to work fine. But there are nor graphs at all. As i've figured out, cacti doesnt generate any rrd files in the rra directory.

As cacti is running under the apache user i've tried to generate an rrd file over cli under the apache user, which works fine.

Now, about 10 hours later, i really ran out of ideas. Nothing of the threads in this forum and nothing of the ideas google brought out seems to work.

Poll.php seems to work fine but didn't seem to update anything. Ive removed the -q and ran it over cli but it returned nothing.
Even an hand created rrd in the right directory won't be updated.

The cacti log level is on HIGH. But the log remains empty. If i turn loglevel to DEBUG i see all the sql queries but nothing more - no errors or warnings at all! Even if i remove a device and add it again and ran poll.php after that the log remains empty.
I'm not really sure but i think even in syslog there is nothing to see.

So after im sure snmpd is working right (MRTG is working really fine on the very same machine) and rrdtool is working (as said before im able to execute the rrdt commands, cacti shows me successfully) what can i do to make cacti realizing i like it to work even on my little machine? kneefalls doesn't help - i've tried so believe me

Im working on Debian Sarge with rrdtool 1.0.49, net-smnp 5.1.2. Both are from stable. Cacti is from the cacti website.

Any more informations i can provide?

The "NaN Debugging" howto doesn't help me 'cause there is no graph at all.

The Apache user is able to create files. I've tried to generate an upload from typo3 backend which worked fine. Even thoug apache is able to write in cactis' /log/ directory, which has the same permissions as the /rra/ directory.

I will be really pleased if someone can point me to the right direction.

[TheWitness]

1) Have you added snmp devices and created graphs?
2) have your run "php cmd.php" in MEDIUM yet?
3) set your poller to cmd.php and run "php poller.php".

Post the output of all steps.

TheWitness

[Andy1972]

1) Have you added snmp devices and created graphs?

Yes
Output:
SNMP Information
System: SpeedTouch 5x6
Uptime: 20350708 (2 days, 8 hours, 31 minutes)
Hostname: SpeedTouch 5x6
Location: Customer Premises
Contact: Service Provider

And a long list of Data Query Information. Shuold i post this also?

Output of 'Create Graphs for this Host':
+ Created graph: Speedtouch 546 - Traffic - IP: loop
+ Created graph: Speedtouch 546 - Traffic - IP: Internet
+ Created graph: Speedtouch 546 - Traffic - IP: LocalNetwor
+ Created graph: Speedtouch 546 - Traffic - ethport1
+ Created graph: Speedtouch 546 - Traffic - ethport2
+ Created graph: Speedtouch 546 - Traffic - ethport3
+ Created graph: Speedtouch 546 - Traffic - ethport4
+ Created graph: Speedtouch 546 - Traffic - ethoa_Internet
+ Created graph: Speedtouch 546 - Traffic - AAL5
+ Created graph: Speedtouch 546 - Traffic - ATM: PORT 0
+ Created graph: Speedtouch 546 - Traffic - ATM: PORT 1
+ Created graph: Speedtouch 546 - Traffic - ATM: PORT 2
+ Created graph: Speedtouch 546 - Traffic - PVIF: ATM PORT
+ Created graph: Speedtouch 546 - Traffic - PVIF: ATM PORT
+ Created graph: Speedtouch 546 - Traffic - adsl601
+ Created graph: Speedtouch 546 - Traffic - adsl602
+ Created graph: Speedtouch 546 - Traffic - adsl603

2) have your run "php cmd.php" in MEDIUM yet?

No, i've only run poller.php.

But cmd.php produces no output on the command line, even if i remove the '-q' option.

3) set your poller to cmd.php and run "php poller.php".

That's what i've done all the time before. As said before, no output here.

Post the output of all steps.

TheWitness

Really strange: The cacti.log remains empty:
10/21/2006 12:28:56 AM - WEBUI: Cacti Log Cleared from Web Management Interface
Thats all!

I really don't know how to go on.
Any forther ideas?

Aditionally: i'm running PHP 5.1.4

[Andy1972]

i don't know why but right now i've found a new entry in my cacti.log:

10/21/2006 07:57:30 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select output_string from data_input where id=3"

which ist true because there is no field 'output_string' in 'data_input'. even in cacti.sql the table definition for 'data_input' does't show such a field.

as far as i can remember its the first time that this error occurs.

maybe this can help someone to help me?

[TheWitness]

Where did you get your install from? Have you applied any mod's/plugins? I don't seem to recall that call either.

TheWitness

[Andy1972]

Where did you get your install from? Have you applied any mod's/plugins? I don't seem to recall that call either.

TheWitness

The cacti Installation is from the cacti Website. I've installed it as told in the howto. It's the naked cacti Installation as it comes out the .tar.gz file without any mods or plugins.

[Andy1972]

Finally i've found the troublemaker: it was the php-cli configuration.
It was different fom the php-apache configuration in terms of loaded extensions.

The mysql Extension wasn't loaded so poller.php couldn't work. I've added mysql Support and now it works fine.

Thank you for you inspiration!

Andy

[fla_roadkill]

Hello, can you please explain what you did? I am having the same issue and its driving me up a wall. Im running Fedora Core 5, Cacti-i and Cactidi, no RRD's are being generated.

[Andy1972]

Hello, can you please explain what you did? I am having the same issue and its driving me up a wall. Im running Fedora Core 5, Cacti-i and Cactidi, no RRD's are being generated.

Hi!

Well, my problem was, that the command line version of php used an other php.ini where MySQL-Support was disabled. So the poller wasn't able to get and store informations from and to the database.
I've figured out which php.ini is responsible (php -i|grep php.ini) for the cli-php binary, added the right extension_dir to the mysql.so library and enabled the mysql extension through extension=mysql.so.

But as it seems that you are using cactid (have you activated the daemon in Console -> Settings -> Poller -> Poller Type?) i really don't know whether your problem is the same or not. If i'm right cactid is a C-Programm which doesn't need PHP. But i've never used it since now. It's even not be installed on my machine right now.

Hope this helps.

[cshepherd]

Thanks for this solution. Maybe this should be wiki'd for Debian users. I had an identical install and identical problems.

Fixed by uncommenting the following line in /etc/php4/cli/php.ini
# mysql.so

[harry_harcort]

Hi
Just wanted to say thanks, you seemed to have corrected our poller problem by pointing us to a (non-existent) php.ini file which should have been in the php5/etc directory.
By the way we are using Solaris 10 x86, Coolstack 1.2, with other stuff.
Thanks at least the poller is now working, however we don't seem to be creating rrd files, any ideas?
Best regards

[kp2a]

able to create one graph on one host AOK - second host failed
tried to add a graph to a second device
(the same type of graph on the same type of device)
data is collected and remains in poller_output at end of cycle
WARNING: Poller Output Table not Empty. Issues Found: 2, Data Sources: traffic_in(DS[7228]), traffic_out(DS[7228])
but the corresponding rrd file is never created

ping latency graph running AOK of both devices

Host Template - Mikrotic
Data Source Template - Mikrotik - Queue - Simple Packets
Data Input Method - Get SNMP Data (Indexed)
Graph Template - Mikrotik - Queue - Simple Traffic (bits/sec, Total Bandwidth)

where do I start look for the problem?

utilities.php.html attached