cacti.mac_track_ports doesn't exist

[thomaslam]

MacTrack version 4.4, Cacti version 1.2.3

Keeps getting - cacti.mac_track_ports' doesn't exist

Tried sudo -u www-data php -q upgrade_database.php --forcever=1.1.38

Upgrading from v1.1.38
Upgrading from v1.1.38 (DB 1.2.3) to v1.2.0
++++++++++++++-+++++++++++++++++++++++
Upgrading from v1.2.0 (DB 1.2.3) to v1.2.1
++
Upgrading from v1.2.1 (DB 1.2.3) to v1.2.2
+
Upgrading from v1.2.2 (DB 1.2.3) to v1.2.3
++++++


Didn't work, any suggestion?

[thomaslam]

2019/09/16 02:06:54 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[880]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2019/09/16 02:06:54 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_ports' doesn't exist
2019/09/16 02:06:53 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[863]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2019/09/16 02:06:53 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_aggregated_ports' doesn't exist
2019/09/16 02:06:53 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[862]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2019/09/16 02:06:53 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_aggregated_ports' doesn't exist
2019/09/16 02:06:53 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[662]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2019/09/16 02:06:53 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_ports' doesn't exist

[netniV]

MacTrack itself creates those tables. If it is unable to create them, this is likely to be due to the innodb large prefix issue (search the forums or our core issue tracker on github).

[thomaslam]

MacTrack itself creates those tables. If it is unable to create them, this is likely to be due to the innodb large prefix issue (search the forums or our core issue tracker on github).

I did verified the large prefix is set.

#
collation-server = utf8mb4_unicode_ci
max_heap_table_size = 128M
tmp_table_size = 128M
join_buffer_size = 64M
innodb_buffer_pool_size = 512M
innodb_doublewrite = off
innodb_additional_mem_pool_size=96M
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16
innodb_file_format = Barracuda
innodb_large_prefix = 1

[netniV]

It looks like a problem with newer MySQL and the default value for the scan date. I was actually missing that table too when I installed so I use the mactrack.sql file to create the table manually.

Code: Select all

ERROR 1067 (42000): Invalid default value for 'scan_date'

Can you report this on github so we can track, fix and notify you?

[thomaslam]

It looks like a problem with newer MySQL and the default value for the scan date. I was actually missing that table too when I installed so I use the mactrack.sql file to create the table manually.

Code: Select all

ERROR 1067 (42000): Invalid default value for 'scan_date'

Can you report this on github so we can track, fix and notify you?

Thanks for the prompt response, I have created a bug #2948

[netniV]

Thanks!

[thomaslam]

Hi,

Any workaround for this? or will need to wait for a later update?


regards,
T

[Linked2828]

It looks like a problem with newer MySQL and the default value for the scan date. I was actually missing that table too when I installed so I use the mactrack.sql file to create the table manually.

Code: Select all

ERROR 1067 (42000): Invalid default value for 'scan_date'

Can you report this on github so we can track, fix and notify you?

Hi netniV,

I could see this is an issue in new version of MySQL for others. Could you please elaborate further how we can create table manually to solve the issue mentioned by Thomas.

Thanks

[TheWitness]

Likely in setup.php you can search for scan_date and set a "real" default. I'm surprised actually that our database session settings are not working. What version of MariaDB/MySQL is this?

[Linked2828]

Likely in setup.php you can search for scan_date and set a "real" default. I'm surprised actually that our database session settings are not working. What version of MariaDB/MySQL is this?

Hi TheWitness,

Thank you for your respond. Please find the MariaDB version.

Version 10.1.44-MariaDB-0ubuntu0.18.04.1

We are getting lots of following log messages:

2020/07/07 14:12:27 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[880]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2020/07/07 14:12:27 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_ports' doesn't exist
2020/07/07 14:12:26 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[863]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2020/07/07 14:12:26 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_aggregated_ports' doesn't exist
2020/07/07 14:12:26 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[862]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2020/07/07 14:12:26 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_aggregated_ports' doesn't exist
2020/07/07 14:12:26 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[228]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[662]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2020/07/07 14:12:26 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_ports' doesn't exist
2020/07/07 14:12:26 - CMDPHP SQL Backtrace: (/plugins/mactrack/mactrack_resolver.php[186]:db_execute(), /lib/database.php[187]:db_execute_prepared())
2020/07/07 14:12:26 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'N' in 'field list'
2020/07/07 14:12:26 - CMDPHP SQL Backtrace: (/plugins/mactrack/mactrack_resolver.php[186]:db_execute(), /lib/database.php[187]:db_execute_prepared())


Kind Regards

[Linked2828]

Likely in setup.php you can search for scan_date and set a "real" default. I'm surprised actually that our database session settings are not working. What version of MariaDB/MySQL is this?

Hi TheWitness,

Today I was also not able to find scan_date in setup.php.

We installed Spine 1.2.13 in our Cacti 1.2.3.

But we are still getting the log messages mentioned above. Please let us know if there is any work around to solve the MacTrack issue.

Kind Regards,

[TheWitness]

Once you get to Cacti 1.2.14, this problem should no longer occur.

[jpthor]

Hi,
I have this problem with my mactrack plugins
my config is:
cacti 1.2.16, mactrack 4.4, et 10.1.47-MariaDB-0ubuntu0.18.04.1.
The error message is:
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[881]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_ports' doesn't exist
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[877]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_ips' doesn't exist
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[875]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_temp_ports' doesn't exist
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[864]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_aggregated_ports' doesn't exist
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[863]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_aggregated_ports' doesn't exist
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[858]:mactrack_process_mac_auth_report(), /plugins/mactrack/poller_mactrack.php[892]:db_fetch_assoc(), /lib/database.php[476]:db_fetch_assoc_prepared(), /lib/database.php[490]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.mac_track_temp_ports' doesn't exist
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[759]:db_fetch_assoc_prepared(), /lib/database.php[490]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.mac_track_ips' doesn't exist
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[679]:db_fetch_assoc(), /lib/database.php[476]:db_fetch_assoc_prepared(), /lib/database.php[490]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'cacti.mac_track_temp_ports' doesn't exist

Can you help me ?

[sd3m0n]

Hi,
I have this problem with my mactrack plugins
my config is:
cacti 1.2.16, mactrack 4.4, et 10.1.47-MariaDB-0ubuntu0.18.04.1.
The error message is:
2020-12-15 13:54:16 - CMDPHP SQL Backtrace: (/plugins/mactrack/poller_mactrack.php[229]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[881]:db_execute(), /lib/database.php[213]:db_execute_prepared())
2020-12-15 13:54:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.mac_track_ports' doesn't exist
....

Hi,

I have the same issue: Error: Table 'cacti.mac_track_ports' doesn't exist

Cacti 1.2.16, MariaDB 10.3, Debian 10.7