Cacti 1.2.8 & Weathermap 1.0

Support questions about the Network Weather Map plugin

Moderators: Developers, Moderators

RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

Hello,

I have got an issue when I installed Weathermap 1.0 on my Cacti 1.2.8. following this link => https://github.com/thurban/plugin_weath ... ree/master

I unzip it in the plugins directory and installed/enable it via Cacti Web page. But once I did that Cacti froze and I was not able to navigate through the web page. I had to disable it and then it turn back to normal.

This is whatI got in the log

Image

I tried it a second time, same behavior, navigation in Cacti froze but this time, I got nothing in the log, like if everything worked..

Is someone got any idea how to solve this?

Kind regards,

Robin.
Last edited by RobinBaillieux on Wed May 06, 2020 3:02 am, edited 1 time in total.
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

Ok, I tried a third time and now I got this in the log :

Image
Image
Last edited by RobinBaillieux on Mon May 04, 2020 4:17 am, edited 1 time in total.
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: Cacti 1.2.8 & Weathermap 1.0

Post by phalek »

It looks like the weathermap_* tables have not been created.
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: Cacti 1.2.8 & Weathermap 1.0

Post by phalek »

Looks like i forgot to merge the development changes back to the master. Try re-installing the master from https://github.com/thurban/plugin_weath ... ree/master and check these issues again
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

Thank for your reply Phalek!

I downloaded/install it again but it seems I got the same issue.

This what I got in the log now:

Code: Select all

2020/05/04 11:40:40 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[599]:CactiErrorHandler())
2020/05/04 11:40:40 - ERROR PHP WARNING in Plugin 'weathermap': Invalid argument supplied for foreach() in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 599
2020/05/04 11:40:40 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[594]:sizeof(), CactiErrorHandler())
2020/05/04 11:40:40 - ERROR PHP WARNING in Plugin 'weathermap': sizeof(): Parameter must be an array or an object that implements Countable in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 594
2020/05/04 11:40:40 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[590]:weathermap_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[836]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[823]:CactiErrorHandler())
2020/05/04 11:40:40 - ERROR PHP WARNING in Plugin 'weathermap': Invalid argument supplied for foreach() in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 823
2020/05/04 11:40:40 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[590]:weathermap_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[836]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[820]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:40:40 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[516]:sizeof(), CactiErrorHandler())
2020/05/04 11:40:40 - ERROR PHP WARNING in Plugin 'weathermap': sizeof(): Parameter must be an array or an object that implements Countable in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 516
2020/05/04 11:40:40 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[514]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:40:40 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[418]:sizeof(), CactiErrorHandler())
2020/05/04 11:40:40 - ERROR PHP WARNING in Plugin 'weathermap': sizeof(): Parameter must be an array or an object that implements Countable in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 418
2020/05/04 11:40:40 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[415]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:40:40 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[408]:db_fetch_cell(), /lib/database.php[362]:db_fetch_cell_prepared(), /lib/database.php[378]:db_execute_prepared())
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Cell Failed!, Error: Table 'cacti.weathermap_maps' doesn't exist
2020/05/04 11:40:40 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[285]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[823]:CactiErrorHandler())
2020/05/04 11:40:40 - ERROR PHP WARNING in Plugin 'weathermap': Invalid argument supplied for foreach() in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 823
2020/05/04 11:40:40 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[285]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[820]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: Cacti 1.2.8 & Weathermap 1.0

Post by phalek »

It looks like it is not able to create the tables. Can you check the log for these kind of error message and post the unique ones ?

Code: Select all

CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

Ok I filtered with 'A DB row failed' and this is what I got :

Code: Select all

2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:40:40 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:28:23 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:28:23 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:28:23 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 11:28:23 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 10:46:19 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 10:46:19 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 10:46:19 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/05/04 10:46:19 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/30 10:12:45 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/30 10:12:45 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/30 10:12:45 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/30 10:12:45 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/28 09:35:49 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/28 09:35:49 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/28 09:35:49 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/28 09:35:49 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_auth' doesn't exist
2020/04/02 12:44:59 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:59 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:59 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:59 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:59 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:59 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:58 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:58 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:58 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
2020/04/02 12:44:58 - CMDPHP ERROR: A DB Row Failed!, Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: Cacti 1.2.8 & Weathermap 1.0

Post by phalek »

What happens if you execute the following in your Cacti database:

Code: Select all

CREATE TABLE weathermap_auth (
  `userid` mediumint(9) NOT NULL default '0',
  `mapid` int(11) NOT NULL default '0'
) ENGINE=MyISAM;
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

Unfortunately I am not the one managing the DB and do not have any access to it.

I will ask to the person managing it and let you know once it is done.
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

OK they ran the code but I still got the same issue.

Code: Select all

2020/05/04 13:18:02 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[599]:CactiErrorHandler())
2020/05/04 13:18:02 - ERROR PHP WARNING in Plugin 'weathermap': Invalid argument supplied for foreach() in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 599
2020/05/04 13:18:02 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[594]:sizeof(), CactiErrorHandler())
2020/05/04 13:18:02 - ERROR PHP WARNING in Plugin 'weathermap': sizeof(): Parameter must be an array or an object that implements Countable in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 594
2020/05/04 13:18:02 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[590]:weathermap_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[836]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[823]:CactiErrorHandler())
2020/05/04 13:18:02 - ERROR PHP WARNING in Plugin 'weathermap': Invalid argument supplied for foreach() in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 823
2020/05/04 13:18:02 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[590]:weathermap_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[836]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[820]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 13:18:02 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_maps' doesn't exist
2020/05/04 13:18:02 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[516]:sizeof(), CactiErrorHandler())
2020/05/04 13:18:02 - ERROR PHP WARNING in Plugin 'weathermap': sizeof(): Parameter must be an array or an object that implements Countable in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 516
2020/05/04 13:18:02 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[420]:weathermap_fullview(), /plugins/weathermap/weathermap-cacti-plugin.php[514]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 13:18:02 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_maps' doesn't exist
2020/05/04 13:18:02 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[418]:sizeof(), CactiErrorHandler())
2020/05/04 13:18:02 - ERROR PHP WARNING in Plugin 'weathermap': sizeof(): Parameter must be an array or an object that implements Countable in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 418
2020/05/04 13:18:02 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[415]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 13:18:02 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_maps' doesn't exist
2020/05/04 13:18:02 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[292]:weathermap_thumbview(), /plugins/weathermap/weathermap-cacti-plugin.php[408]:db_fetch_cell(), /lib/database.php[362]:db_fetch_cell_prepared(), /lib/database.php[378]:db_execute_prepared())
2020/05/04 13:18:02 - CMDPHP ERROR: A DB Cell Failed!, Error: Table 'cacti.weathermap_maps' doesn't exist
2020/05/04 13:18:02 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[285]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[823]:CactiErrorHandler())
2020/05/04 13:18:02 - ERROR PHP WARNING in Plugin 'weathermap': Invalid argument supplied for foreach() in file: /cacti/www/plugins/weathermap/weathermap-cacti-plugin.php on line: 823
2020/05/04 13:18:02 - CMDPHP SQL Backtrace: (/plugins/weathermap/weathermap-cacti-plugin.php[285]:weathermap_get_valid_tabs(), /plugins/weathermap/weathermap-cacti-plugin.php[820]:db_fetch_assoc(), /lib/database.php[452]:db_fetch_assoc_prepared(), /lib/database.php[466]:db_execute_prepared())
2020/05/04 13:18:02 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.weathermap_maps' doesn't exist

They also notified that all others weatermap_* tables are missing.
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: Cacti 1.2.8 & Weathermap 1.0

Post by phalek »

Can you ask them if the Cacti user does have rights to actually create tables ??
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

yes, they gave me the access

mysql> show grants for `cacti`@`%`;
+---------------------------------------------------------+
| Grants for cacti@% |
+---------------------------------------------------------+
| GRANT USAGE ON *.* TO `cacti`@`%` |
| GRANT ALL PRIVILEGES ON `cacti`.* TO `cacti`@`%` |
| GRANT SELECT ON `mysql`.`time_zone_name` TO `cacti`@`%` |
+---------------------------------------------------------+
3 rows in set (0.00 sec)
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

Hello,

We reset the VM to it initial state. But we still got the same error.. Do you get any idea where it could from ?

kr,

Robin
RobinBaillieux
Posts: 17
Joined: Mon Apr 27, 2020 4:43 am

Re: Cacti 1.2.8 & Weathermap 1.0

Post by RobinBaillieux »

To complete the information.

We have done a complete new fresh install with an another version of Cacti => 1.2.12.

Once the installation was done we directly deployed Weathermap (from GitHub master directory) so it was a complete new install.

But once we click on "install" we still got the same error in the log :

Code: Select all

05/19/2020 11:03:17 - CMDPHP SQL Backtrace: (/plugins.php[74]:api_plugin_install(), /lib/plugins.php[625]:plugin_weathermap_install(), /plugins/weathermap/setup.php[34]:weathermap_setup_table(), /plugins/weathermap/setup.php[462]:db_execute(), /lib/database.php[213]:db_execute_prepared())
05/19/2020 11:03:17 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.weathermap_maps' doesn't exist
and once we click on "enable" we got this error in the log :

Code: Select all

05/19/2020 11:04:39 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
05/19/2020 11:04:39 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'weathermap'
05/19/2020 11:04:39 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler())
05/19/2020 11:04:39 - ERROR PHP ERROR in Plugin 'weathermap': Uncaught Error: Call to a member function prepare() on null in /cacti/www/plugins/weathermap/setup.php:298 Stack trace: #0 /cacti/www/plugins/weathermap/setup.php(594): weathermap_setup_table() #1 /cacti/www/lib/plugins.php(177): weathermap_show_tab(Array) #2 /cacti/www/lib/plugins.php(74): api_plugin_run_plugin_hook('top_graph_heade...', 'weathermap', 'weathermap_show...', Array) #3 /cacti/www/lib/html.php(1647): api_plugin_hook('top_graph_heade...') #4 /cacti/www/include/top_header.php(39): html_show_tabs_left() #5 /cacti/www/lib/functions.php(3282): include_once('/cacti/www/incl...') #6 /cacti/www/plugins.php(139): top_header() #7 {main} thrown in file: /cacti/www/plugins/weathermap/setup.php on line: 298
The strange thing is even if it says that "cacti.weathermap_maps' doesn't exist" it is actually into our DB...

Image

You can see that the timestamp match..

Robin.
User avatar
phalek
Developer
Posts: 2838
Joined: Thu Jan 31, 2008 6:39 am
Location: Kressbronn, Germany
Contact:

Re: Cacti 1.2.8 & Weathermap 1.0

Post by phalek »

Hm

That issue may only occurr if it is not able to connect to the database or is using a different database.

Where is your config.php file located and does it contain the correct database information? Maybe there's another config file lying around somewhere. Can you check ?

It should use these global variables:

Code: Select all

    global $database_type, $database_default, $database_hostname, $database_username, $database_password;
You can check if that weathermap is actually using the correct entries by adding the following to the lib/database.php file:

Code: Select all

 file_put_contents('/tmp/weathermap_database.txt', "$database_type, $database_default, $database_hostname, $database_username, $database_password");
 
so the function in the lib/database.php file looks like this:

Code: Select all

function weathermap_get_pdo()
{
    // This is the Cacti standard settings
    global $database_type, $database_default, $database_hostname, $database_username, $database_password;
    global $config;

    $cacti_version = $config["cacti_version"];

    $host = $database_hostname;
    $dbname = $database_default;
    $user = $database_username;
    $pass = $database_password;

    file_put_contents('/tmp/weathermap_database.txt', "$database_type, $database_default, $database_hostname, $database_username, $database_password");
 
    $pdo = null;

    try {
        # MySQL with PDO_MYSQL
        $pdo = new \PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    } catch (PDOException $e) {
        echo $e->getMessage();
    }

    return $pdo;
Then check the /tmp/weathermap_database.txt file
Greetings,
Phalek
---
Need more help ? Read the Cacti documentation or my new Cacti 1.x Book
Need on-site support ? Look here Cacti Workshop
Need professional Cacti support ? Look here CereusService
---
Plugins : CereusReporting
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests