CactiLog file error

[shazxr]

Hi,

am getting error in Cacti Log but still not able to find out what exactly these error. please check the attached file. Can you please help me in that

[gandalf]

Please enter mysql promt with the user that's defined in ./include/config.php. Then run one of those insert statements and check for errors
Reinhard

[shazxr]

Dear Reinhard

Thanks for reply, But im new in cacti and dummy user could you please let me know what should i run on mysql exactly.
Regards
Shaz

[gandalf]

Open ./include/config.php
Note <userid> and <password>
Enter mysql using

Code: Select all

mysql --user=<userid> --password=<password> cacti

Type one of those "insert ..." commands verbosely (or use cut and paste). End up with a ";"
Note any error message
Reinhard

[shazxr]

Thanks for quick reply, i added one table and used insert command but didnt got any error

mysql> CREATE TABLE lookup
-> (id INT, INDEX USING BTREE (id))
-> ENGINE = MEMORY;
Query OK, 0 rows affected (0.00 sec)



mysql> insert into lookup () VALUES();
Query OK, 1 row affected (0.00 sec)

[TheWitness]

I'd say the old double crontab issue.

TheWitness

[shazxr]

hi

I checked the crontab it seem working fine.

i tried to execute the error log command and didnt got any error. But in log file still getting same error even i purged it many time.


insert into poller_output (local_data_id, rrd_name, time, output) values (527, 'traffic_out', '2007-04-11 12:20:16', '3843487151');
Query OK, 1 row affected (0.00 sec)

[shazxr]

THANKS ..... The Witness

Yes It was Double crontab issue i removed it from /etc/crontab

Thanks again.

Regards
shaz