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

Support questions about the Network Weather Map plugin

Moderators: Developers, Moderators

User avatar
Howie
Cacti Guru User
Posts: 5508
Joined: Thu Sep 16, 2004 5:53 am
Location: United Kingdom
Contact:

Post by Howie »

OK, so are you SURE that the mysql user that cacti uses is allowed to create tables and so on?
Weathermap 0.98a is out! & QuickTree 1.0. Superlinks is over there now (and built-in to Cacti 1.x).
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)
Lonlie
Posts: 23
Joined: Thu Jun 05, 2008 3:36 am
Location: France

Post by Lonlie »

Howie wrote: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";
User avatar
Howie
Cacti Guru User
Posts: 5508
Joined: Thu Sep 16, 2004 5:53 am
Location: United Kingdom
Contact:

Post by 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.
Weathermap 0.98a is out! & QuickTree 1.0. Superlinks is over there now (and built-in to Cacti 1.x).
Some Other Cacti tweaks, including strip-graphs, icons and snmp/netflow stuff.
(Let me know if you have UK DevOps or Network Ops opportunities, too!)
Lonlie
Posts: 23
Joined: Thu Jun 05, 2008 3:36 am
Location: France

Post by Lonlie »

Howie wrote: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
Posts: 23
Joined: Thu Jun 05, 2008 3:36 am
Location: France

Post by Lonlie »

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests