Router Configs stopped working with error SQL Row Failed!

[mmartens]

Hi,

First the backup with the Router Configs plugin performed good then it suddenly stopped.
I get the following error in the log:
CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "

Any idea?
Thanks in advance

[mmartens]

Does anyone have any idea?

Thanks in advance.

[expo]

I am also having an almost similar problem with router configs. this started when my machine restarted. the tftp server and the one written in cacti had a different path. when I changed the path of the tftp server to the right one, I received an error message

CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"INSERT INTO plugin_routerconfigs_backups (device, btime, directory, filename, config, lastchange, username)

I am using
Cacti Version 0.8.7i
Cacti OS win32
SNMP Version NET-SNMP version: 5.6.1.1
RRDTool Version RRDTool 1.4.x
PHP Version 5.3.8
PHP OS WINNT

I've been working on this for 2 days now and still cannot make it work

[expo]

i've read from a different forum that importing the sql file found in the routerconfigs folder will solve the issue. sorry for the question but how will you import the sql file? where do you import it? thank you.

[expo]

I found this link http://forums.cacti.net/viewtopic.php?f=14&t=36543 where you need to import the sql file. you also need to make changes in the sql. i have tried it today and will see tom if nightly backup has been done.

[mmartens]

Ok thanks for the feedback.
Please let us know if it worked so we/I can use it as well?

[expo]

i regret to inform you that auto backup is unsuccessful. what happens now, the backup file is missing from the path i have specified to be saved. you can view the config using the view config link. same error is still seen at the cacti log file.

[phalek]

I am also having an almost similar problem with router configs. this started when my machine restarted. the tftp server and the one written in cacti had a different path. when I changed the path of the tftp server to the right one, I received an error message

CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"INSERT INTO plugin_routerconfigs_backups (device, btime, directory, filename, config, lastchange, username)
...

You should get the complete SQL statement, go into a mysql cli and execute it. You will get a better error message then just "1064".

This may have multiple issues, but could simply be that the "id" column reached it's max, or it's trying to add a duplicate entry/id ...

Post the errror message you get here for further analysis.

[phalek]

Hi,

First the backup with the Router Configs plugin performed good then it suddenly stopped.
I get the following error in the log:
CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "

Any idea?
Thanks in advance

Did it have any other error messages regarding SQL statements ? As noted before, it may be that the id column just got maxed out.

[expo]

thank you for your reply. i did go into mysql 5.5 cli.
what i did is :
mysql> use cacti

mysql> SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0;

after that i received an error:
ERROR 1146 (42S02): Table 'cacti.plugin_routerconfigs_devicetypes' doesn't exist

then i checked the database by typing:

mysql> show tables;

then i saw that there is no "plugin_routerconfigs_devicetypes" table. i can only see

plugin_routerconfigs_accounts
plugin_routerconfigs_backups
plugin_routerconfigs_devices

then i opened the routerconfigs.sql and found that there is a command creating a plugin_routerconfigs_devicetypes which is:

CREATE TABLE plugin_routerconfigs_devicetypes (
id int(12) NOT NULL auto_increment,
`name` varchar(128) NOT NULL,
username varchar(64) NOT NULL default 'sername:',
`password` varchar(128) NOT NULL default 'assword:',
copytftp varchar(64) NOT NULL default 'copy tftp run',
version varchar(64) NOT NULL default 'show version',
confirm varchar(64) NOT NULL default '',
forceconfirm int(1) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

I noticed from the other created tables that their ending is "ENGINE=MyISAM;"
i changed the TYPE=MyISAM to ENGINE=MyISAM; and i paste the command in mysql:

mysql> CREATE TABLE plugin_routerconfigs_devicetypes (
-> id int(12) NOT NULL auto_increment,
-> `name` varchar(128) NOT NULL,
-> username varchar(64) NOT NULL default 'sername:',
-> `password` varchar(128) NOT NULL default 'assword:',
-> copytftp varchar(64) NOT NULL default 'copy tftp run',
-> version varchar(64) NOT NULL default 'show version',
-> confirm varchar(64) NOT NULL default '',
-> forceconfirm int(1) NOT NULL,
-> PRIMARY KEY (id)
-> ) ENGINE=MyISAM;

then the table was created. i tested to do a manual backup and a file appeared on my specified path. no errors in cacti log file.
however, there are no backups saved in cacti web interface. it is always 0. sorry if this is too detailed. i did this for others like me who do not know anything on sql. hope this makes it more easier. will give feedback if auto backup will work tom.

[expo]

hi, i want to inform you that the cacti interface for router configs is still the same. there is still no backup that can be viewed in the backup page. however, there is a file in the specified path where backups should be placed. it did auto backup. i only tested with 1 router. i will add several routers more and will test if this will work. on the other hand, may i know what error should occur when the id has maxed out and how to solve it? i am thinking of placing more than 30 devices and i might encounter this error. thank you in advance and i will advise tom. if auto backup will occur on several devices.

[expo]

i regret to inform you that when i added 9 more devices, the auto backup is not working and is not saving any config in the specified path. the backup link in the cacti interface is now incrementing when i do manual backup. you can also view the config when you click on the backup. there is no longer error message in he cacti log file. any suggestion i can do to make this work? thank you