Can´t add any maps to weathermap

[big-timmy]

Hi @ all,

I have installed weathermap 0.95 on cacti 0.87b on Windows Server 2003 running Apache 2.2.

Seems that the poller cannot create the needed sql tables in mysql.

Here is the cacti logfile output:

04/05/2008 04:24:53 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"update weathermap_maps set sortorder=id where sortorder is null or sortorder=0;'
04/05/2008 04:24:53 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update weathermap_maps set sortorder=id where sortorder is null or sortorder=0;"
04/05/2008 04:24:53 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"update weathermap_maps set filehash=LEFT(MD5(concat(id,configfile,rand())),20) where filehash = '';'
04/05/2008 04:24:53 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update weathermap_maps set filehash=LEFT(MD5(concat(id,configfile,rand())),20) where filehash = '';"
04/05/2008 04:24:53 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"CREATE TABLE weathermap_maps ( id int(11) NOT NULL auto_increment, sortorder int(11) NOT NULL default 0, active set('on','off') NOT NULL default 'on', configfile text NOT NULL, imagefile text NOT NULL, htmlfile text NOT NULL, titlecache text NOT NULL, filehash varchar (40) NOT NULL default '', warncount int(11) NOT NULL default 0, config text NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM;'
04/05/2008 04:24:53 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "CREATE TABLE weathermap_maps ( id int(11) NOT NULL auto_increment, sortorder int(11) NOT NULL default 0, active set('on','off') NOT NULL default 'on', configfile text NOT NULL, imagefile text NOT NULL, htmlfile text NOT NULL, titlecache text NOT NULL, filehash varchar (40) NOT NULL default '', warncount int(11) NOT NULL default 0, config text NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM;"
04/05/2008 04:24:53 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"update weathermap_maps set sortorder=id where sortorder is null;'


Can anyone halp me to fix the problem?

ArchitecturePlugin is installed and I successfully run the check.php from weathermap via browser and command line.

Many thanks in advance.

Tim

[Howie]

Well, *does* your cacti database user have permission to create tables?

check.php doesn't check anything to do with the database, only that various php functions exist.

[big-timmy]

Hi Howie,

I have followed the cacti installation guide step by step and one step was
"GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'mapasswd'".

I think, the cactiuser has the right to create tables then.

I tried to create the table by myself and got the error that the config is not allowed to have an default value. I edited the command and removed the value for config and then I was able to create the table.

After that I still wasn´t able to add a network weathermap.

Any other tipps so far??

Thanks.

Tim

[Howie]

[big-timmy]

Again HI!

Sorry for my wrong information I gave........I have already installed version 0.95b.

[Howie]

Which version of mysql do you use? I will try and recreate the problem here - it's obviously not fixed after all...

(and do you use any special settings for mysql? strict mode for example?)

[big-timmy]

HI!

I´m not in the office right now, but I am very sure I user mysql v5.0.

I do not use any special settings. Everything is installed with default settings.

Here is the version, I use:
mysql-5.0.51a-win32

[aflower]

I have the same problem, can't add Weathermaps. No error message, it just returns to the Management -> Weathermaps view.

The Cacti log has the following message:

04/28/2008 11:22:30 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"update weathermap_maps set sortorder=id where sortorder is null or sortorder=0;'
04/28/2008 11:22:30 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"update weathermap_maps set filehash=LEFT(MD5(concat(id,configfile,rand())),20) where filehash = '';'
04/28/2008 11:22:30 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1101', SQL:"CREATE TABLE weathermap_maps ( id int(11) NOT NULL auto_increment, sortorder int(11) NOT NULL default 0, active set('on','off') NOT NULL default 'on', configfile text NOT NULL, imagefile text NOT NULL, htmlfile text NOT NULL, titlecache text NOT NULL, filehash varchar (40) NOT NULL default '', warncount int(11) NOT NULL default 0, config text NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM;'
04/28/2008 11:22:30 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"update weathermap_maps set sortorder=id where sortorder is null;'


Weathermap 0.95b
Cacti 0.8.7b
Cacti Plugin Architecture 2.1
MySQL 5.0.51b
php 5.2.5
IIS 6.0
Windows 2003 SP2

[aflower]

I just installed Weathermaps version 0.941 instead, works like a charm. Guess I'll have to wait for 0.96 for this to be fixed then

[Howie]

[aflower]

I just thought so because it was supposed to have been fixed in 0.95b

[Howie]

[aflower]

Do you run the same version as me? (5.0.51b).

I have set up MySQL like this with the Configuration Wizard:

- Server Machine
- Non-Transactional Database Only
- Decision Support (DSS)/OLAP
- Enable TCP/IP Networking
- Enable Strict Mode
- Standard Character Set (latin1)
- Install as a Windows Service
- Include Bin Directory in Windows PATH

[mullier_p]

Hello,

I have the same problem on my new Cacti installation.
Here are the versions:
cacti: 0.8.7b
weathermaps: 0.95b
mysql: 5.0.51a

When I try to add a map, I have the following PHP error:

[Howie]

I think this must be something to do with strict mode, because I don't get this issue with 5.0.(something). I'll look into it some more at some stage. It only seems to be windows users, too, for some reason.