search

Cacti / plugin_flowview

FlowView Plugin for Cacti
GNU General Public License v2.0
18 stars 10 forks source link

"Unknown column 'version' in 'field list'", "Undefined variable $host in file" and "Unknown column 'source' in 'field list'". #131

Closed cheerfultime closed 2 weeks ago

cheerfultime commented 3 weeks ago

Hi,

AlmaLinux release 9.4 + cacti + flowview(3.4 latest develop from github on Jun 13)

1. 2024-06-13 08:48:05 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'version' in 'field list' 2024-06-13 08:48:05 - CMDPHP SQL Backtrace: (/plugins/flowview/flow_collector.php[716]:update_flowview_streams(), /plugins/flowview/flow_collector.php[793]:flowview_db_execute_prepared(), /plugins/flowview/database.php[82]:db_execute_prepared()) 2024-06-13 08:52:03 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'version' in 'field list' 2024-06-13 08:52:03 - CMDPHP SQL Backtrace: (/plugins/flowview/flowview_devices.php[89]:show_devices(), /plugins/flowview/flowview_devices.php[513]:flowview_dbfetch

When I add a 'version' column to 'plugin_flowview_device_streams' by referring 'plugins/flowview/setup.php', the error log no longer appears.

2. 2024-06-13 10:29:28 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 10:29:28 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1613]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler()) 2024-06-13 10:29:28 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'source' in 'field list' 2024-06-13 10:29:28 - CMDPHP SQL Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1613]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3745]:flowview_db_execute_prepared(), /plugins/flowview/database.php[82]:db_execute_prepared()) 2024-06-13 10:29:29 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'source' in 'field list' 2024-06-13 10:29:29 - CMDPHP SQL Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1613]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3707]:flowview_db_execute_prepared(), /plugins/flowview/database.php[82]:db_execute_prepared()) 2024-06-13 10:29:29 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'source' in 'field list' 2024-06-13 10:29:29 - CMDPHP SQL Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1613]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3707]:flowview_db_execute_prepared(), /plugins/flowview/database.php[82]:db_execute_prepared()) 2024-06-13 10:29:29 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'source' in 'field list' 2024-06-13 10:29:29 - CMDPHP SQL Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1613]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3707]:flowview_db_execute_prepared(), /plugins/flowview/database.php[82]:db_execute_prepared()) 2024-06-13 10:29:29 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 10:29:29 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1610]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler()) 2024-06-13 10:29:29 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'source' in 'field list'

Thanks.

TheWitness commented 3 weeks ago

Run ./flowview_upgrade.php --forcever=3.3

TheWitness commented 3 weeks ago

I'm still hammering though this section of the code logic. You can keep up by using that command. More coming tomorrow. If you can get me some Flow Template Image uploads like in Issue #111 , that would be awesome. I'm trying to find the common field set that can be supported accross devices.

TheWitness commented 3 weeks ago

In the end, the various Listener Pages should look something like this.

image

image

image

cheerfultime commented 3 weeks ago

Hi,

There is another issue. 2024-06-13 11:49:15 - CLEANUP WARNING: Flowview Listener child_1 by signal 2024-06-13 11:49:45 - CMDPHP ERROR: A DB Exec Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INTO cacti.plugin_flowview_device SET last_updated = NOW WHERE device_id ...' at line 1 2024-06-13 11:49:45 - CMDPHP SQL Backtrace: (/plugins/flowview/flow_collector.php[675]:flowview_db_execute_prepared(), /plugins/flowview/database.php[82]:db_execute_prepared())

Thanks!

cheerfultime commented 3 weeks ago

Listeners

Listeners-1

Listeners-2

Listeners-3

Listeners-4

Thanks!

cheerfultime commented 3 weeks ago

1. ./flowview_upgrade.php --forcever=3.3 2024-06-13 11:26:18 - FLOWVIEW Upgrading from v3.3 to 3.4 2024-06-13 11:26:20 - FLOWVIEW Altering Table plugin_flowview_raw_2024158 Using this alter CONVERT TO CHARACTER SET latin1. 2024-06-13 11:26:26 - FLOWVIEW Altering Table plugin_flowview_raw_2024159 Using this alter CONVERT TO CHARACTER SET latin1. 2024-06-13 11:26:50 - FLOWVIEW Altering Table plugin_flowview_raw_2024160 Using this alter CONVERT TO CHARACTER SET latin1. 2024-06-13 11:27:36 - FLOWVIEW Altering Table plugin_flowview_raw_2024161 Using this alter CONVERT TO CHARACTER SET latin1. 2024-06-13 11:29:06 - FLOWVIEW Altering Table plugin_flowview_raw_2024162 Using this alter CONVERT TO CHARACTER SET latin1. 2024-06-13 11:31:03 - FLOWVIEW Altering Table plugin_flowview_raw_2024163 Using this alter CONVERT TO CHARACTER SET latin1. 2024-06-13 11:32:24 - FLOWVIEW Altering Table plugin_flowview_raw_2024164 Using this alter CONVERT TO CHARACTER SET latin1. PHP Warning: Undefined variable $info in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 235 PHP Warning: Trying to access array offset on value of type null in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 235 PHP Warning: Undefined variable $info in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 236 PHP Warning: Trying to access array offset on value of type null in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 236 PHP Warning: Undefined variable $info in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 237 PHP Warning: Trying to access array offset on value of type null in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 237 PHP Warning: Undefined variable $info in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 238 PHP Warning: Trying to access array offset on value of type null in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 238 PHP Warning: Undefined variable $info in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 239 PHP Warning: Trying to access array offset on value of type null in /usr/share/cacti/plugins/flowview/flowview_upgrade.php on line 239 2024-06-13 11:33:01 - FLOWVIEW Flowview Database Upgrade Complete

2. 2024-06-13 12:03:31 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 12:03:31 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1610]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler()) 2024-06-13 12:03:31 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 12:03:31 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1610]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler()) 2024-06-13 12:03:32 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 12:03:32 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1610]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler()) 2024-06-13 12:03:38 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 12:03:38 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1610]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler()) 2024-06-13 12:03:48 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 12:03:48 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1610]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler()) 2024-06-13 12:03:48 - ERROR PHP WARNING in Plugin 'flowview': Undefined variable $host in file: /usr/share/cacti/plugins/flowview/functions.php on line: 3738 2024-06-13 12:03:48 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/flowview/flow_collector.php[729]:process_fv9(), /plugins/flowview/flow_collector.php[1196]:process_v9_v10(), /plugins/flowview/flow_collector.php[1610]:flowview_get_dns_from_ip(), /plugins/flowview/functions.php[3738]:CactiErrorHandler())

TheWitness commented 3 weeks ago

Are you sure you're fully updated? I fix these issues the $host I don't know about the $info though.

TheWitness commented 3 weeks ago

Could you post those template images in the template export topic and then call out the hardware manufacturer and model?