cacti_user_stats.php PINE: Poller[Main Poller] Device[System Device] DS[Cacti Stats - User Stats] Graphs[Cacti Stats -

[ivansaez]

hi,

I've moved cacti from an Ubuntu machine to a Oracle Linux 9 server. The version of cacti is the same: 1.2.25
Cacti collects data on the new server but in the logging I see this kind of errors:

2024-05-29 10:30:03 - SPINE: Poller[Main Poller] PID[296494] PT[140120956548672] Device[System Device] DS[Cacti Stats - User Stats] Graphs[Cacti Stats - User Types] ERROR: Empty result []: '/usr/bin/php -q /usr/share/cacti/site/scripts/cacti_user_stats.php'
2024-05-29 10:30:03 - SPINE: Poller[Main Poller] PID[296491] PT[140459096958528] Device[System Device] DS[Cacti Stats - User Stats] Graphs[Cacti Stats - User Types] ERROR: Empty result []: '/usr/bin/php -q /usr/share/cacti/site/scripts/cacti_user_stats.php'
2024-05-29 10:30:03 - SPINE: Poller[Main Poller] PID[296494] PT[140120956548672] Device[System Device] DS[Cacti Stats - User Stats] Graphs[Cacti Stats - User Sessions] ERROR: Empty result []: '/usr/bin/php -q /usr/share/cacti/site/scripts/cacti_user_stats.php'
2024-05-29 10:30:03 - SPINE: Poller[Main Poller] PID[296491] PT[140459096958528] Device[System Device] DS[Cacti Stats - User Stats] Graphs[Cacti Stats - User Sessions] ERROR: Empty result []: '/usr/bin/php -q /usr/share/cacti/site/scripts/cacti_user_stats.php'
2024-05-29 10:30:02 - SPINE: Poller[Main Poller] PID[296494] PT[140120956548672] Device[System Device] DS[Cacti Stats - User Stats] Graphs[Cacti Stats - User Logins] ERROR: Empty result []: '/usr/bin/php -q /usr/share/cacti/site/scripts/cacti_user_stats.php'
2024-05-29 10:30:02 - SPINE: Poller[Main Poller] PID[296491] PT[140459096958528] Device[System Device] DS[Cacti Stats - User Stats] Graphs[Cacti Stats - User Logins] ERROR: Empty result []: '/usr/bin/php -q /usr/share/cacti/site/scripts/cacti_user_stats.php'


This errors are recurring: every 5 minutes. I've been searching for a cause/solution but have failed.
Any ideas?

regards,

Ivan

[macan]

are both path correct? Try these commands:
/usr/bin/php -version
ls -al /usr/share/cacti/site/scripts/cacti_user_stats.php

[ivansaez]

macan,

php -version
PHP 8.0.30 (cli) (built: Aug 3 2023 17:13:08) ( NTS gcc x86_64 )
Copyright (c) The PHP Group
Zend Engine v4.0.30, Copyright (c) Zend Technologies
with Zend OPcache v8.0.30, Copyright (c), by Zend Technologies

and
ls -al /usr/share/cacti/site/scripts/cacti_user_stats.php
-rwxr-xr-x. 1 apache root 7178 May 22 08:37 /usr/share/cacti/site/scripts/cacti_user_stats.php

regards,

Ivan

[macan]

try to run php /usr/share/cacti/site/scripts/cacti_user_stats.php

Is returned something like "valid:0 invalid:0 active:0 sleeping:0 garbage:0 uactive:0 usleeping:0" ?

[ivansaez]

Macan,

It returns nothing:

[root]# php /usr/share/cacti/site/scripts/cacti_user_stats.php
[root]# echo $?
255

I'm intrigued by that return code 255. What does it means?

And I see also the following warning in the logs:

POLLER: Poller[Main Poller] PID[559798] WARNING: Invalid output! MULTI DS[Cacti Stats - User Stats] Graphs[Cacti Stats - User Types] Encountered Expected[uactive:value usleeping:value]

This warning and above error seems related: both are about "Cacti Stats - User Stats"

regards,

Ivan

[macan]

strange. For test, try in script change line 26 from
error_reporting(0);
to
error_reporting(1);

And run again. Any output?

Don't forget revert error reporting back!

[ivansaez]

Macan,

Yes!

PHP Fatal error: Uncaught Error: Call to undefined function get_current_page() in /usr/share/cacti/site/include/global.php:284
Stack trace:
#0 /usr/share/cacti/site/include/cli_check.php(45): include()
#1 /usr/share/cacti/site/scripts/cacti_user_stats.php(29): include('...')
#2 {main}
thrown in /usr/share/cacti/site/include/global.php on line 284

I've checked the php files above and they are present.

regards,

Ivan

[ivansaez]

Macan,

I think I've fixed it:

php couldn't find get_current_page ( Uncaught Error: Call to undefined function get_current_page() in /usr/share/cacti/site/include/global.php:284)

and I did search all php file for that function and the issue is that there was no lib folder in /usr/share/cacti/site/
so I copied /usr/share/cacti/lib to site:

find . -name '*.php' -exec grep -il get_current_page {} \;
./lib/functions.php
./lib/html.php
./lib/html_reports.php
./lib/html_utility.php
./lib/html_form.php
./lib/clog_webapi.php
./include/global.php
./include/auth.php
./include/top_graph_header.php
./site/include/global.php
./site/include/auth.php
./site/include/top_graph_header.php
./auth_login.php
./auth_changepassword.php
./plugins/thold/setup.php
./plugins/thold/includes/settings.php
./plugins/thold/includes/tab.php
./plugins/monitor/setup.php
./plugins/webseer/setup.php
[root@lnx158 cacti]# cd site
[root@lnx158 site]# ls
cache include log rra scripts
[root@lnx158 site]# cp -r ../lib .
[root@lnx158 site]# php /usr/share/cacti/site/scripts/cacti_user_stats.php
valid:0 invalid:0 active:0 sleeping:0 garbage:0 uactive:0 usleeping:0[root@lnx158 site]#

So cacti_user_stats.php seems to work fine now.

regards,

Ivan

[ivansaez]

Macan,

The warnings and errors are gone so it is fixed. There is one thing that bothers me: In Data Collection -> Data Collectors
I get every time the following screen when I click on the main collector:

Sorry, we could not process your last action.
Save Failed due to field input errors (Check red fields).

I don't see red fields and the data seems okay to me. Also the content in the poller table seems fine to me.

regards,

Ivan

[macan]

try run php /path/to/cacti/cli/audit_database.php
I expect few errors, show result

[ivansaez]

macan,

Thanks for you help!
And this is the output of the audit_database.php
By the way: I'm confused the audit_database.php is located in /var/lib/cacti/cli
but most of the php scripts are located on /usr/share/cacti. Is this normal?

And this is the output of the audit_database.php:

php /var/lib/cacti/cli/audit_database.php --report
FATAL: Failed to find Audit Schema
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_graph_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_devices' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rules' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_ips' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_match_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_networks' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rule_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rules' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'cdef' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'cdef_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'color_template_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'color_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'colors' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_debug' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_data' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_fields' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_local' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_cf' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_rra' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_action' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_temp' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_daily' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_last' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_monthly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_weekly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_yearly' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_data' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_rrd' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'external_links' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_local' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input_defs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_gprint' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_query' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_snmp_query' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'notification_queue' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_config' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_db_changes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_hooks' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_dashboard' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_dashboard' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_data' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_definition' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_trends' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_user_auth' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_dashboards' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_notify_history' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_reboot_history' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_uptime' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_notification_lists' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_realms' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_contacts' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_data' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_processes' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_failed' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_template' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_log' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_template_contact' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_threshold_contact' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_contacts' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_proxies' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_servers' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_servers_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_urls' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_urls_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_command' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_data_template_field_mappings' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_item' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_realtime' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_reindex' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_resource_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller_time' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'reports' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'reports_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'rrdcheck' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'sessions' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_tree' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user_group' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'sites' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd_sv' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_sv' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_notifications' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_textual_conventions' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers_notifications' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_mibs' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_notifications_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'table_columns' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'table_indexes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'thold_data' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'thold_template' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_members' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_perms' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_realm' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_perms' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_realm' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_row_cache' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains_ldap' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'user_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'vdef' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'vdef_items' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'version' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Audit was clean, no errors or warnings
---------------------------------------------------------------------------------------------


regards,

Ivan

[macan]

By the way: I'm confused the audit_database.php is located in /var/lib/cacti/cli
but most of the php scripts are located on /usr/share/cacti. Is this normal?

If it is normal installation, all should be in one directory.
Please show
ls -al /var/lib/cacti
ls -al /usr/share/cacti

[ivansaez]

Macan,

ls -al /var/lib/cacti
total 28
drwxr-xr-x. 7 root root 4096 May 21 16:23 .
drwxr-xr-x. 44 root root 4096 May 28 12:55 ..
drwxr-xr-x. 6 apache apache 4096 May 17 13:30 cache
drwxr-xr-x. 2 apache apache 4096 May 17 13:30 cli
drwxr-xr-x. 2 apache apache 4096 May 17 13:30 csrf
lrwxrwxrwx. 1 root root 24 Oct 13 2023 include -> /usr/share/cacti/include
lrwxrwxrwx. 1 root root 20 Oct 13 2023 lib -> /usr/share/cacti/lib
drwxr-xr-x. 5 apache apache 4096 May 17 13:30 resource
lrwxrwxrwx. 1 root root 25 May 21 14:04 rra -> /usr/share/cacti/site/rra
drwxr-xr-x. 2 apache apache 4096 May 29 08:21 scripts
[root@lnx158 httpd]# ls -al /usr/share/cacti
total 2728
drwxr-xr-x. 11 root root 4096 May 30 10:23 .
drwxr-xr-x. 141 root root 4096 May 28 12:55 ..
-rwxr-xr-x. 1 root root 5669 Sep 5 2023 about.php
-rwxr-xr-x. 1 root root 63052 Sep 5 2023 aggregate_graphs.php
-rwxr-xr-x. 1 root root 18586 Sep 5 2023 aggregate_items.php
-rwxr-xr-x. 1 root root 25664 Sep 5 2023 aggregate_templates.php
-rwxr-xr-x. 1 root root 16213 Sep 5 2023 auth_changepassword.php
-rwxr-xr-x. 1 root root 15211 Sep 5 2023 auth_login.php
-rwxr-xr-x. 1 root root 19161 Sep 5 2023 auth_profile.php
-rwxr-xr-x. 1 root root 24203 Sep 5 2023 automation_devices.php
-rwxr-xr-x. 1 root root 36742 Sep 5 2023 automation_graph_rules.php
-rwxr-xr-x. 1 root root 42897 Sep 5 2023 automation_networks.php
-rwxr-xr-x. 1 root root 31747 Sep 5 2023 automation_snmp.php
-rwxr-xr-x. 1 root root 18785 Sep 5 2023 automation_templates.php
-rwxr-xr-x. 1 root root 38723 Sep 5 2023 automation_tree_rules.php
-rwxr-xr-x. 1 root root 2955 Sep 5 2023 boost_rrdupdate.php
lrwxrwxrwx. 1 root root 20 Oct 13 2023 cache -> /var/lib/cacti/cache
-rwxr-xr-x. 1 root root 7215 Sep 5 2023 cactid.php
-rwxr-xr-x. 1 root root 29149 Sep 5 2023 cdef.php
lrwxrwxrwx. 1 root root 18 Oct 13 2023 cli -> /var/lib/cacti/cli
-rwxr-xr-x. 1 root root 2227 Sep 5 2023 clog.php
-rwxr-xr-x. 1 root root 2233 Sep 5 2023 clog_user.php
-rwxr-xr-x. 1 root root 34405 Sep 5 2023 cmd.php
-rwxr-xr-x. 1 root root 8843 Sep 5 2023 cmd_realtime.php
-rwxr-xr-x. 1 root root 24350 Sep 5 2023 color.php
-rwxr-xr-x. 1 root root 13259 Sep 5 2023 color_templates_items.php
-rwxr-xr-x. 1 root root 24849 Sep 5 2023 color_templates.php
-rwxr-xr-x. 1 root root 36440 Sep 5 2023 data_debug.php
-rwxr-xr-x. 1 root root 32966 Sep 5 2023 data_input.php
-rwxr-xr-x. 1 root root 50911 Sep 5 2023 data_queries.php
-rwxr-xr-x. 1 root root 37372 Sep 5 2023 data_source_profiles.php
-rwxr-xr-x. 1 root root 67636 Sep 5 2023 data_sources.php
-rwxr-xr-x. 1 root root 48361 Sep 5 2023 data_templates.php
drwxr-xr-x. 2 root root 4096 May 17 13:30 formats
-rwxr-xr-x. 1 root root 14319 Sep 5 2023 gprint_presets.php
-rwxr-xr-x. 1 root root 6862 Sep 5 2023 graph_image.php
-rwxr-xr-x. 1 root root 9136 Sep 5 2023 graph_json.php
-rwxr-xr-x. 1 root root 23109 Sep 5 2023 graph.php
-rwxr-xr-x. 1 root root 17520 Sep 5 2023 graph_realtime.php
-rwxr-xr-x. 1 root root 26995 Sep 5 2023 graphs_items.php
-rwxr-xr-x. 1 root root 35686 Sep 5 2023 graphs_new.php
-rwxr-xr-x. 1 root root 90148 Sep 5 2023 graphs.php
-rwxr-xr-x. 1 root root 9586 Sep 5 2023 graph_templates_inputs.php
-rwxr-xr-x. 1 root root 30755 Sep 5 2023 graph_templates_items.php
-rwxr-xr-x. 1 root root 41401 Sep 5 2023 graph_templates.php
-rwxr-xr-x. 1 root root 32392 Sep 5 2023 graph_view.php
-rwxr-xr-x. 1 root root 12466 Sep 5 2023 graph_xport.php
-rwxr-xr-x. 1 root root 4155 Sep 5 2023 help.php
-rwxr-xr-x. 1 root root 68026 Sep 5 2023 host.php
-rwxr-xr-x. 1 root root 30062 Sep 5 2023 host_templates.php
drwxr-xr-x. 2 root root 4096 May 17 13:30 images
drwxr-xr-x. 8 root root 4096 May 21 14:03 include
-rwxr-xr-x. 1 root root 5721 Sep 5 2023 index.php
drwxr-xr-x. 4 root root 4096 May 17 13:30 install
drwxr-xr-x. 2 root root 4096 May 17 13:30 lib
-rwxr-xr-x. 1 root root 3532 Sep 5 2023 link.php
-rwxr-xr-x. 1 root root 21899 Sep 5 2023 links.php
drwxr-xr-x. 4 root root 4096 May 17 13:30 locales
lrwxrwxrwx. 1 root root 15 Oct 13 2023 log -> /var/log/cacti/
-rwxr-xr-x. 1 root root 3862 Sep 5 2023 logout.php
-rwxr-xr-x. 1 root root 38107 Sep 5 2023 managers.php
drwxr-xr-x. 2 root root 4096 May 17 13:30 mibs
-rwxr-xr-x. 1 root root 30823 Sep 5 2023 package_import.php
-rwxr-xr-x. 1 root root 3410 Sep 5 2023 permission_denied.php
drwxrwxr-x. 7 root root 4096 Nov 3 2023 plugins
-rwxr-xr-x. 1 root root 28356 Sep 5 2023 plugins.php
-rwxr-xr-x. 1 root root 38621 Sep 5 2023 poller_automation.php
-rwxr-xr-x. 1 root root 42865 Sep 5 2023 poller_boost.php
-rwxr-xr-x. 1 root root 13204 Sep 5 2023 poller_commands.php
-rwxr-xr-x. 1 root root 11633 Sep 5 2023 poller_dsstats.php
-rwxr-xr-x. 1 root root 22049 Sep 5 2023 poller_maintenance.php
-rwxr-xr-x 1 root root 39222 May 30 10:23 poller.php
-rwxr-xr-x. 1 root root 9955 Sep 5 2023 poller_realtime.php
-rwxr-xr-x. 1 root root 8826 Sep 5 2023 poller_recovery.php
-rwxr-xr-x. 1 root root 5718 Sep 5 2023 poller_reports.php
-rwxr-xr-x. 1 root root 8507 Sep 5 2023 poller_rrdcheck.php
-rwxr-xr-x. 1 root root 39401 Sep 5 2023 pollers.php
-rwxr-xr-x. 1 root root 8269 Sep 5 2023 poller_spikekill.php
-rwxr-xr-x. 1 root root 14793 Sep 5 2023 remote_agent.php
-rwxr-xr-x. 1 root root 5475 Sep 5 2023 reports_admin.php
-rwxr-xr-x. 1 root root 5376 Sep 5 2023 reports_user.php
lrwxrwxrwx. 1 root root 23 Oct 13 2023 resource -> /var/lib/cacti/resource
lrwxrwxrwx. 1 root root 18 Oct 13 2023 rra -> /var/lib/cacti/rra
-rwxr-xr-x. 1 root root 9748 Sep 5 2023 rrdcheck.php
-rwxr-xr-x. 1 root root 20183 Sep 5 2023 rrdcleaner.php
lrwxrwxrwx. 1 root root 22 Oct 13 2023 scripts -> /var/lib/cacti/scripts
-rwxr-xr-x. 1 root root 14760 Sep 5 2023 script_server.php
-rwxr-xr-x. 1 root root 1728 Sep 5 2023 service_check.php
-rwxr-xr-x. 1 root root 45097 Sep 5 2023 settings.php
drwxr-xr-x. 8 apache root 4096 May 30 16:33 site
-rwxr-xr-x. 1 root root 21306 Sep 5 2023 sites.php
-rwxr-xr-x. 1 root root 3749 Sep 5 2023 snmpagent_mibcachechild.php
-rwxr-xr-x. 1 root root 2414 Sep 5 2023 snmpagent_mibcache.php
-rwxr-xr-x. 1 root root 5506 Sep 5 2023 snmpagent_persist.php
-rwxr-xr-x. 1 root root 3987 Sep 5 2023 spikekill.php
-rwxr-xr-x. 1 root root 6597 Sep 5 2023 templates_export.php
-rwxr-xr-x. 1 root root 15952 Sep 5 2023 templates_import.php
-rwxr-xr-x. 1 root root 69096 Sep 5 2023 tree.php
-rwxr-xr-x. 1 root root 100190 Sep 5 2023 user_admin.php
-rwxr-xr-x. 1 root root 29909 Sep 5 2023 user_domains.php
-rwxr-xr-x. 1 root root 89786 Sep 5 2023 user_group_admin.php
-rwxr-xr-x. 1 root root 114626 Sep 5 2023 utilities.php
-rwxr-xr-x. 1 root root 29080 Sep 5 2023 vdef.php

[macan]

I don't see directory docs where must be file audit_schema.sql so you get always error:
FATAL: Failed to find Audit Schema

Download cacti 1.2.25, copy directory docs to /usr/share/cacti
and run audit again

[ivansaez]

Macan,

I did install cacti with yum install and that doesn't create a docs folder. I've download the zip file from https://files.cacti.net/cacti/linux/ and created the docs folder and now the audit_database.php does give usable info:

php /var/lib/cacti/cli/audit_database.php --report
SUCCESS: Loaded the Audit Schema
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_graph'
ERROR Col: 'image_format_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'auto_scale_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_item'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_graph_item'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_devices'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'known', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'up', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'time', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rule_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rules' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_ips' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_match_rule_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_networks' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_processes'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp_items'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp_retries', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_templates'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'
ERROR Col: 'host_template', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rule_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rules' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'cdef' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'cdef_items'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'color_template_items'
ERROR Col: 'color_template_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'color_templates' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'colors' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_debug'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'
ERROR Col: 'started', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'done', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'user', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'datasource', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'issue', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input'
ERROR Col: 'type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_data' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_fields' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_local'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'mediumint(8) unsigned'
ERROR Col: 'orphan', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_cf' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_rra' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_action'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_temp'
ERROR Col: 'in_cacti', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_daily' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_last' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_monthly' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_weekly' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_yearly' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_data' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_rrd' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'external_links'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'
ERROR Col: 'sortorder', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_local' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input_defs'
ERROR Col: 'graph_template_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_gprint' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_graph'
ERROR Col: 'image_format_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'auto_scale_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_item'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'
ERROR Col: 'consolidation_function_id', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree'
ERROR Col: 'locked', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree_items' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'ping_port', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'ping_timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'ping_retries', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'device_threads', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'
ERROR Col: 'total_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'
ERROR Col: 'failed_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 10, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_graph' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_cache'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_query' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_graph' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_snmp_query' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'notification_queue' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_config'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_db_changes' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_hooks'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_dashboard' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_dashboard' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_data' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_definition' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_trends' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_user_auth' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_dashboards' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_notify_history' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_reboot_history' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_monitor_uptime' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_notification_lists' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_realms' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_contacts' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_data' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_processes' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_failed' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_template' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_log' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_template_contact' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_threshold_contact' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_contacts' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_processes' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_proxies' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_servers' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_servers_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_urls' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_webseer_urls_log' - Does not Exist. Possible Plugin
---------------------------------------------------------------------------------------------
Checking Table: 'poller'
ERROR Col: 'dbretries', Attribute 'Null' invalid. Should be: 'YES', Is: 'NO'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_command' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_data_template_field_mappings' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_item'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'rrd_num', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_processes' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_realtime' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_reindex'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(4)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_resource_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'poller_time'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'processes'
ERROR Col: 'timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(11)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'reports'
ERROR Col: 'offset', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'reports_items'
ERROR Col: 'item_type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'site_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'host_template_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'host_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'graph_template_id', Attribute 'Null' invalid. Should be: 'NO', Is: 'YES'
ERROR Col: 'align', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'rrdcheck' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'sessions' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings'
ERROR Col: 'value', Attribute 'Type' invalid. Should be: 'varchar(2048)', Is: 'varchar(4096)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'settings_tree'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user_group' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'sites' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd_sv' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_sv' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_notifications' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_textual_conventions' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'
ERROR Col: 'max_log_size', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint(5) unsigned'
ERROR Col: 'snmp_message_type', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers_notifications'
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_mibs'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_notifications_log'
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12)'
ERROR Col: 'severity', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint(1)'
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(8)'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'table_columns' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'table_indexes' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'thold_data' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'thold_template' - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth'
ERROR Col: 'login_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'policy_graphs', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_trees', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_hosts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_graph_templates', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'lastchange', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int(12)'
ERROR Col: 'lastlogin', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int(12)'
ERROR Col: 'lastfail', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12)'
ERROR Col: 'reset_perms', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int(12) unsigned'

ERRORS: 9, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group'
ERROR Col: 'login_opts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'
ERROR Col: 'policy_graphs', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_trees', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_hosts', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'
ERROR Col: 'policy_graph_templates', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1) unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_members' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_perms'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_realm' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_perms'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2) unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_realm' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_row_cache' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains'
ERROR Col: 'defdomain', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(3)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains_ldap' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'user_log'
ERROR Col: 'result', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(1)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'vdef' - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'vdef_items'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint(2)'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'version' - Clean
---------------------------------------------------------------------------------------------
ERRORS are fixable using the --repair option. WARNINGS will not be repaired
due to ambiguous use of the column.
---------------------------------------------------------------------------------------------