Cacti 1.2.25, Ubuntu 22.04, plugin won't install

[NextbrickInc]

Describe the bug I just got cacti functional on Ubuntu 22. MySQL version is 8.0.33, running InnoDB Cluster on 3 machines. Plugin will not install.

To Reproduce Check out this git project into Cacti's plugin directory. In the Cacti UI, go to Configuration->Plugins, see the Flowview plugin. Click the Install icon for the plugin.

Expected behavior I expected the plugin to install and let me configure it.

Plugin (please complete the following information):

• Version: [info] name = flowview version = 3.3 longname = FlowView author = The Cacti Group email = homepage = http://www.cacti.net compat = 1.2.17
• Source: [e.g. cacti.net, package, github] github

**Desktop

• OS: Ubuntu Desktop 22.04
• Browser: Firefox Beta 115.0b07 (installed via snap)

**Server

• Dell PowerEdge R720xd
• OS: Ubuntu Server 22.04
• Kernel info:Linux smeagol 6.1.0-1014-oem #14-Ubuntu SMP PREEMPT_DYNAMIC Fri May 19 06:02:46 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
• mysql info: mysql Ver 8.0.33 for Linux on x86_64 (MySQL Community Server - GPL)
• Running in Apache2 behind haproxy, using php-fpm.
• PHP info: PHP 8.1.2-1ubuntu2.11

Smartphone (please complete the following information):

• Not using a phone

Additional context log from an install attempt:

2023-06-22 13:30:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 13:30:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 13:30:02 - SYSTEM STATS: Time:1.2251 Method:cmd.php Processes:1 Threads:1 Hosts:2 HostsPerProcess:2 DataSources:8 RRDsProcessed:0
2023-06-22 13:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:02 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[81]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 13:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:02 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[98]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 13:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:02 - CMDPHP SQL Backtrace:  (/poller_reports.php[136]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 13:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:02 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[93]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 13:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:02 - CMDPHP SQL Backtrace:  (/poller_reports.php[175]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 13:30:02 - SYSTEM MAINT STATS: Time:0.01
2023-06-22 13:30:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 13:30:02 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[127]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())

[elyograg]

I just realized that I was not logged in as myself when I created this issue.

[elyograg]

I did see the note in the README about manual changes being required to work with mysql 8.x, but there was no info about what those changes would be. I know a little bit about relational database design, but I am definitely not an expert.

InnoDB cluster does not support foreign keys that cascade, but from what I can tell, there are no foreign keys in the cacti database.

[TheWitness]

What table?

[TheWitness]

It's a cacti issue. The "process" table is memory. Switch it to innodb.

[TheWitness]

You will likely experience other issues. The table poller_output is also memory. It's a guess anyway. It will impact scalability, but with clustering both these tables can be ignored for replication, so you should exclude them.

[elyograg]

The only info I have is in the log excerpt I pasted. I turned on the debug option that was supposed to log actual SQL ... it didn't.

[elyograg]

That info may not even be related to the attempt to install the plugin. I clicked the install button a bunch of times and no new logs appeared. But then the same set of logs appeared again while I wasn't clicking anything.

[elyograg]

I followed all the instructions, only adjusting for the fact that the database isn't on localhost and a slightly different location under /var/www.

[elyograg]

Those logs are happening precisely on five minute boundaries.

2023-06-22 21:35:00 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:00 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:35:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:01 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:35:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:35:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:01 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:35:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:35:02 - SYSTEM STATS: Time:2.2334 Method:cmd.php Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:17 RRDsProcessed:0
2023-06-22 21:35:03 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:03 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[81]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:35:03 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:03 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[98]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:35:03 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:03 - CMDPHP SQL Backtrace:  (/poller_reports.php[136]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:35:03 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:03 - CMDPHP SQL Backtrace:  (/poller_reports.php[175]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:35:03 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:03 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[93]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:35:03 - SYSTEM MAINT STATS: Time:0.02
2023-06-22 21:35:03 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:35:03 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[127]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:40:00 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:00 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:40:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:01 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:40:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:40:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:01 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:40:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:40:01 - SYSTEM STATS: Time:1.2269 Method:cmd.php Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:17 RRDsProcessed:0
2023-06-22 21:40:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:02 - CMDPHP SQL Backtrace:  (/poller_reports.php[136]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:40:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:02 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[93]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:40:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:02 - CMDPHP SQL Backtrace:  (/poller_reports.php[175]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:40:02 - SYSTEM MAINT STATS: Time:0.02
2023-06-22 21:40:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:02 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[127]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:40:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:02 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[81]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:40:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:40:02 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[98]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:45:00 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:00 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:45:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:45:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:01 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:45:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:01 - CMDPHP SQL Backtrace:  (/cmd.php[341]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:45:01 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:01 - CMDPHP SQL Backtrace:  (/cmd.php[441]:db_execute(), /lib/database.php[357]:db_execute_prepared())
2023-06-22 21:45:01 - SYSTEM STATS: Time:1.2372 Method:cmd.php Processes:1 Threads:1 Hosts:5 HostsPerProcess:5 DataSources:17 RRDsProcessed:0
2023-06-22 21:45:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:02 - CMDPHP SQL Backtrace:  (/poller_reports.php[136]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:45:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:02 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[81]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:45:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:02 - CMDPHP SQL Backtrace:  (/poller_reports.php[175]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:45:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:02 - CMDPHP SQL Backtrace:  (/poller_spikekill.php[98]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())
2023-06-22 21:45:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:02 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[93]:register_process_start(), /lib/poller.php[2369]:register_process(), /lib/poller.php[2416]:db_execute_prepared())
2023-06-22 21:45:02 - SYSTEM MAINT STATS: Time:0.02
2023-06-22 21:45:02 - CMDPHP ERROR: A DB Exec Failed!, Error: The table does not comply with the requirements by an external plugin.
2023-06-22 21:45:02 - CMDPHP SQL Backtrace:  (/poller_maintenance.php[127]:unregister_process(), /lib/poller.php[2439]:db_execute_prepared())

[TheWitness]

You are not very familiar with MySQL are you?

Run this query:

SELECT table_name FROM information_schema.tables WHERE table_schema='cacti' AND engine='MEMORY';

Then, for each table:

ALTER TABLE $table_name ENGINE=InnoDB;

This is a limitation likely due to the fact that you are doing Binary logging, or replication and MySQL is not being nice to Memory Storage engine any longer.

[TheWitness]

This really is more about Cacti that flowview as well. So, I'll close. You can continue to comment if you like. Something I would be interested to know is what plugin is MySQL barking about.

[elyograg]

I deleted cacti completely, pulled it down again from github, deleted the database, and reinstalled. Cacti is version 1.3.0 now.

Then I proceeded to change the engine on all the MEMORY tables to InnoDB. My MYSQL server is three servers running InnoDB Cluster, in multi-master mode.

Now Cacti itself is working properly where it wasn't before. My graphs actually populate now, and the errors in cacti.log are gone.

But it still will not install flowview. No messages of any kind show up in cacti.log when I do the install, it just doesn't work.

[elyograg]

I renamed the plugin directory from plugins_flowview (which the git clone created) to flowview and it installed. I edited the config to point to the correct webroot directory, installed/started the service, and configured a Listener.

There is nothing that I could find about how to actually USE the plugin.

[TheWitness]

Hmm. I should update the readme. You need to add a listener, and the direct your routers to send v5, v9, or IPFIX to the listener port.

Then you setup filters to view reports. There is a DNS cache hack to go to IANNA if the domain does not resolve. I think that needs an overhaul.