Weathermap issues

[markgiusti]

Hello,

Im having another issues with weathermap. I installed the plugin and the editor seems to be working,but when it comes to viewing the map it inst working as it should. The map comes up without an image, just presented with the timestamp (image 1). Another issue is once i add the maps, the title doesnt show up (image 2).
Cacti: 0.8.8f
Weathermap: 0.98
php: 0.56.33

22121.PNG (4.81 KiB) Viewed 3482 times

(image 2)

11111.PNG (9.91 KiB) Viewed 3482 times

(image 1)

[Howie]

There's no config file name there. I think that the output is probably what you would get from a completely blank file.

If you remove that map (click the cross on the right) and re-add it, does the filename show up then? If not, what is the filename?

[markgiusti]

Thats what i was thinking, but they arent empty files.

I did as you asked and added the maps, which displays the following:

2.PNG (13 KiB) Viewed 3466 times

The configs do have filenames:

3.PNG (5.66 KiB) Viewed 3466 times

Could this be a permissions issue ?
I have set the permissions to the appropriate folders as specified in various installation tutorials.

[Howie]

I don't think it can be permissions, or the 'add file' picker wouldn't be able to show the title.

Could you try and add one more map, and check the httpd error_log and cacti.log for errors, please? I guess this must be database related.

[markgiusti]

[Mon Feb 05 15:42:14.154134 2018] [:error] [pid 41986] [client **.**.**.**] PHP Stack trace:, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php
[Mon Feb 05 15:42:14.154141 2018] [:error] [pid 41986] [client **.**.**.**] PHP 1. {main}() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:0, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php
[Mon Feb 05 15:42:14.154158 2018] [:error] [pid 41986] [client **.**.**.**] PHP 2. weathermap_translate_id() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:27, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php

[Mon Feb 05 15:42:14.154167 2018] [:error] [pid 41986] [client **.**.**.**] PHP 3. mysql_real_escape_string() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:654 referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php



CACTI.LOG


Log File [Total Lines: 500 - All Items Shown]
02/05/2018 03:45:07 PM - WEATHERMAP: Poller[0] STATS: Weathermap 0.98 run complete - Mon, 05 Feb 18 15:45:07 +0100: 3 maps were run in 0 seconds with 0 warnings.
02/05/2018 03:45:07 PM - WEATHERMAP: Poller[0] [Map 30] : Wrote map to /usr/share/cacti/site/plugins/weathermap/output/.png and /usr/share/cacti/site/plugins/weathermap/output/.thumb.png
02/05/2018 03:45:07 PM - WEATHERMAP: Poller[0] [Map 30] : About to write image file. If this is the last message in your log, increase memory_limit in php.ini [WMPOLL01]
02/05/2018 03:45:07 PM - WEATHERMAP: Poller[0] [Map 30] : Map: /usr/share/cacti/site/plugins/weathermap/configs/ -> /usr/share/cacti/site/plugins/weathermap/output/.html &

02/05/2018 03:54:40 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"update weathermap_maps set filehash=LEFT(MD5(concat(id,configfile,rand())),20) where id='
02/05/2018 03:54:40 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"insert into weathermap_auth (mapid,userid) VALUES (,1)'

[Howie]

I think you missed a bit off of the first log - the all-important line with the error message!

[markgiusti]

Sorry for the inconvenience.


05 16:22:35.518934 2018] [:error] [pid 39587] [client **.**.**.**] PHP Deprecated: mysql_real_escape_string(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php on line 654, referer: http://**.**.**.**/cacti/plugins/weathermap$
[Mon Feb 05 16:22:35.518940 2018] [:error] [pid 39587] [client **.**.**.**] PHP Stack trace:, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=viewmap&id=
[Mon Feb 05 16:22:35.518953 2018] [:error] [pid 39587] [client **.**.**.**] PHP 1. {main}() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:0, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=viewmap&id=
[Mon Feb 05 16:22:35.518960 2018] [:error] [pid 39587] [client **.**.**.**] PHP 2. weathermap_translate_id() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:27, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=viewmap&id=
[Mon Feb 05 16:22:35.518967 2018] [:error] [pid 39587] [client **.**.**.**] PHP 3. mysql_real_escape_string() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:654, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=viewmap&id=
[Mon Feb 05 16:22:35.519226 2018] [:error] [pid 39587] [client **.**.**.**] PHP Warning: mysql_real_escape_string(): Access denied for user ''@'localhost' (using password: NO) in /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php on line 654, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=vie$
[Mon Feb 05 16:22:35.519238 2018] [:error] [pid 39587] [client **.**.**.**] PHP Stack trace:, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=viewmap&id=
[Mon Feb 05 16:22:35.519245 2018] [:error] [pid 39587] [client **.**.**.**] PHP 1. {main}() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:0, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=viewmap&id=
[Mon Feb 05 16:22:35.519251 2018] [:error] [pid 39587] [client **.**.**.**] PHP 2. weathermap_translate_id() /usr/share/cacti/site/plugins/weathermap/weathermap-cacti-plugin.php:27, referer: http://**.**.**.**/cacti/plugins/weathermap/weathermap-cacti-plugin.php?action=viewmap&id=

[Howie]

This is a bit strange:

Code: Select all

Access denied for user ''@'localhost'

OK, you could try the (not yet released) 0.98a quick-fix release. That changes out the whole database access for PDO, so it works with PHP 7 (and gets less warnings with 5.6) but still only works on Cacti 0.8.8.

http://www.network-weathermap.com/files ... -test1.zip

Any issues related to mysql_XXXXX() should go away with that. But be aware that you'd also be about the 3rd person to use it