Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Aug 17, 2017 6:39 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't exist
PostPosted: Fri Jan 18, 2013 12:00 pm 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
Hi,

I try to configure routerconfigs . I have installed the plugin and i try to add a device into Utilities>"Router configs".
The device that i try to test is a cisco firewall "adaptative security appliance".
When i click on "Create" i have O rows..
I tried to write from the cacti database (as advised in a post):
select * from plugin_routerconfigs_devicetypes;
....And indeed the table 'cacti.plugin_routerconfigs_devicetypes' doesn't exist , but maybe it is normal when no devices are created yet , i don't know...

I have also a few doubts concerning the RRD Cleaner Backup directory : the soft has mentionned /usr/share/cacti/rra/backup/ for it automatically.
And for "Backup Directory Path" (The path to where your Configs will be backed up, it must be the path that the local TFTP Server writes to.):
/home/configs/backups (the same in /etc/xinetd.d/tftp).
I can also say that these 2 backups directory are both void for now...(and they exist).

Thank you.


Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Fri Jan 18, 2013 7:09 pm 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
I have reinstalled the plugin and I have tried to do this (i am not sure ...):
Code:
mysql -u root -p cacti < /usr/share/cacti/plugins/routerconfigs/routerconfigs.sql


And it seems that there is an error in cacti.sql ?! , i really don't understand:
Code:
ERROR 1064 (42000) at line 53: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 11


Maybe i have done something wrong , because now it is very weird for my directories:
/usr/share/cacti/cacti/cacti/cacti/cacti/cacti , and probably infinitly .
Probably now i have to go to "/usr/share/cacti " and write #rm -rf cacti ?

But that doesn't answer to : how can i import this sql file? (routerconfigs.sql)


Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Sat Jan 19, 2013 11:52 am 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
ok.I have deleted the bad directories.I have succedeed in adding a device, it is just that i have wrote nothing in "Directory
(This is the relative directory structure used to store the configs)." (is it good?) , i don't have tested the backup yet.
Maybe i have to wait tomorrow to see if it is working because now under configs i have : current - backups(0)


Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Sun Jan 20, 2013 9:40 am 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
Here is my question:
how can i import the plugin_routerconfigs_devicetypes table?

I look at my routerconfigs.sql script located at "/usr/share/cacti/plugins/routerconfigs" and my problem is that in phpmyadmin i have the tables :

- plugin_routerconfigs_accounts
- plugin_routerconfigs_backups
- plugin_routerconfigs_devices

I tried to add in phpmyadmin>sql:
Code:
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;



but i have the error:
Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 11


Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Sun Jan 20, 2013 9:44 am 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
I resolved myself this difficult problem:
I deleted myisam and now it works

(it was ENGINE = MYISAM AND NOT TYPE = MYISAM)

(So i guess that i also need to copy in phpmyadmin:
INSERT INTO plugin_routerconfigs_devicetypes (id, name, username, password, copytftp, version, confirm, forceconfirm) VALUES (1, 'Cisco IOS', 'sername:', 'assword:', 'copy run tftp', 'show version', 'y', 0),
(2, 'Cisco CatOS', 'sername:', 'assword:', 'copy config tftp', '', 'y', 1);

?
)


Last edited by magikk on Mon Jan 21, 2013 8:36 am, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Mon Jan 21, 2013 8:33 am 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
(i have added also , as the post said:
INSERT INTO plugin_routerconfigs_devicetypes (id, name, username, password, copytftp, version, confirm, forceconfirm) VALUES (3, 'ASA', 'sername:', 'assword:', 'write net', 'show version', 'y', 1)
)
***

I haven't succeed to backup my asa with routerconfigs yet , but i saw an error in the cacti's log (i am unable to interpret it - an id problem?).

(I copied 4 times with small differences of configuration to increase my chances of a backup).

Code:
01/21/2013 01:22:02 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM plugin_routerconfigs_backups WHERE id = "


Attachments:
backup.GIF
backup.GIF [ 16.67 KiB | Viewed 2066 times ]
Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Mon Jan 21, 2013 10:49 am 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
I made locate on : "plugin_routerconfigs_backups" , does that mean that the data are well backuped ? (even if it is the wrong directory : /var/lib/mysql/cacti/ )

/var/lib/mysql/cacti/plugin_routerconfigs_backups.MYD
/var/lib/mysql/cacti/plugin_routerconfigs_backups.MYI
/var/lib/mysql/cacti/plugin_routerconfigs_backups.frm

*******
devices types:


Attachments:
devTypes.GIF
devTypes.GIF [ 26.59 KiB | Viewed 2065 times ]
Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Tue Jan 22, 2013 11:10 am 
Offline
Cacti User

Joined: Sun Dec 23, 2012 9:59 am
Posts: 57
I have one stupid question: is it necessary to check the device and then click on : "choose an action > backup > go" if we want a backup?

(I forgot to do it at beginning , then i modified my functions.php file like in a post , and now i clicked on : "backup Go" - nothing changed)



************

I rechanged to my default functions.php and clicked on backup , and now i have an intersting message :
Code:
�������� User Access Verification ��Username: Username: �������� User Access Verification ��Username: Username: �������� User Access Verification ��Username: Username: �������� User Access Verification ��Username: Username: �������� User Access Verification ��Username: admin Password: ***************** Username: 192.168.0.253-> ERROR: TELNET login failed


And now ?


Top
 Profile  
 
 Post subject: Re: Table 'cacti.plugin_routerconfigs_devicetypes' doesn't e
PostPosted: Fri Nov 25, 2016 9:02 am 
Offline

Joined: Fri Nov 25, 2016 8:34 am
Posts: 1
This will help,
https://es.piliapp.com/mysql-syntax-check/

Copy and paste this part of the routerconfigs.sql file.

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;



Cheers


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group