[SOLVED] Problems with Weathermaps 0.95b with Config. Files

[Howie]

OK, so are you SURE that the mysql user that cacti uses is allowed to create tables and so on?

[Lonlie]

OK, so are you SURE that the mysql user that cacti uses is allowed to create tables and so on?

How do I know if the mysql user that cacti uses is allowed to create tables ?

mysql : - user = root
- password = user5

I created a database : mysqladmin --user=root --password=user5 create cacti

And in the config.php :

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "root";
$database_password = "user5";
$database_port = "3306";

[Howie]

If it's root, then they probably can, but the sure way to test would be:

Code: Select all

>  mysql -uroot -p cacti
(enter your password)

mysql> create table testtable  (id INT ,name VARCHAR( 10 ) );

and see if it complains.

[Lonlie]

If it's root, then they probably can, but the sure way to test would be:

Code: Select all

>  mysql -uroot -p cacti
(enter your password)

mysql> create table testtable  (id INT ,name VARCHAR( 10 ) );

and see if it complains.

"Query OK, 0 rows affected <0.08 sec>"

I have new informations :
- When i use only Superlink plugin, it works, and i can save modifications on Host.
- When i use only Monitor plugin, it works, but i can't save modifications on Host.
- When i use only Weathermap plugin, it doesn't work, but i can save modifications on Host.


I changed the weathermap version, i used (0.95a, 0.941 and 0.94) and i had the same problem, it didn't work. The only changement is i don't have the same error message, when i add a config file, i have no error, just this message : No Weathermaps Configured.

Update
When I add a config file, in the cacti.log I have :

06/16/2008 10:15:09 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1364', SQL:"insert into weathermap_maps (configfile,titlecache,active,imagefile,htmlfile) VALUES ('example.conf','Network Overview','on','','')'

[Lonlie]

http://forums.cacti.net/about26289.html

Thanks Howie.