install CAMM

[Tapac]

Hi!
I can't install CAMM plugin!!!
Return FATAL: Database or Table does not exist

Cacti Version 0.8.7d
Plugin Architecture 2.4
Poller Type Cactid v
Server Info Linux 2.6.23.1-42.fc8
Web Server Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8b DAV/2 PHP/5.2.6
PHP Version 5.2.6
PHP Extensions xmlwriter, libxml, dom, xmlreader, xml, tokenizer, session, pcre, SimpleXML, SPL, PDO, sockets, snmp, SQLite, standard, Reflection, posix, pdo_sqlite, mysqli, mysql, mbstring, json, iconv, hash, gd, filter, date, ctype, apache2handler
MySQL Version 5.0.67-log
RRDTool Version 1.3.6
SNMP Version 5.4.2.1
Plugins Global Plugin Settings (settings - v0.5)
Configuration manager (configmanager - v0.76)
Thresholds (thold - v0.4.1)
Device Monitoring (monitor - v0.8.2)
Syslog Monitoring (syslog - v0.5.2)
Realtime Graph Viewer (realtime - v0.36)
Update Checker (update - v0.4)
Network Tools (tools - v0.3)
PHP Network Weathermap (weathermap - v0.95b)
Host Info (hostinfo - v0.2)
SSH Viewer (ssh - v1.0)
manage
sadd
SuperLinks (superlinks - v0.
Router Configs (routerconfigs - v0.1)
Login Page Mod (loginmod - v1.0)
Read-only Devices Tab (devices - v0.4)
sharednetworkclass
CAMM (CActi Message Manager) (CAMM - v1.5.0)

BBCode for Forum posts

[gthe]

Can you provide me full error ?

[Tapac]

Console->Plugin Management->camm>Install
Next page FATAL: Database or Table does not exist

[mcutting]

Had the same problem. Look in the sql folder - there are some tables you need to import before you can install.

[nallien]

have same problem here... try to look into setup.php file...

[gthe]

nallien, mcutting, Tapac - Do you have clean install CAMM or upgrade from old snmptt plugin ?

[mcutting]

Mine was a clean install, and I also had this issue. The reason for this is that database "syslog_ng" is not automatically created. If you create it, the installation works fine.

Failing that, when the install fails, click the back button, go to settings, CAMM, and then modify the syslog_ng database to one that you have.

Worked for me.

[gthe]

And your mysql user is root ? Or have access like root. I.e.

Code: Select all

GRANT ALL ON *.* TO cactiuser@localhost ....

[mcutting]

Yes, but I resolved this quite a while back, so no need for me to run this command.

[gthe]

And this is a problem.
If mysql user is NOT root

mysql> show tables from `not_exist_db`;
ERROR 1044 (42000): Access denied for user 'cactiusern'@'localhost' to database 'not_exist_db'

error not fatal (1044) and install work ok.

If mysql user is root

mysql> show tables from `not_exist_db`;
ERROR 1049 (42000): Unknown database 'not_exist_db'

and that is fatal error (1049) and install stop.

[mcutting]

Yes, I see this now. If Cacti doesn't run as root, then this woulf throw this error message, as "cactiuser" has no permissions into MySQL unless you explicity grant them.

[Ever]

Ok man thanks for the help I already read the other post, but I dont know how to import tables and how to create db in syslog, can you help me