Upgrade from 8.8b to 1.3.7

[athornfam2]

Does anyone have updated step by step instructions on how to upgrade to the latest cacti?

[athornfam2]

Well, I got everything migrated to 1.3.7 at 3:00 am.... However, the graphs or poller is not working correctly.

[netniV]

You should probably check that all your timezones are properly set and being utilised in PHP/Apache/MySQL. Also, make sure that the poller is being called in the /etc/cron.d/cacti file. There have been some suggestions that making sure you have the correct cycles are being used and match the steps of the RRD file.

Also, check you log files to see if there are any errors about getting values from the device.

[athornfam2]

You should probably check that all your timezones are properly set and being utilised in PHP/Apache/MySQL. Also, make sure that the poller is being called in the /etc/cron.d/cacti file. There have been some suggestions that making sure you have the correct cycles are being used and match the steps of the RRD file.

Also, check you log files to see if there are any errors about getting values from the device.

Well, I checked the cacti file under /etc/cron.d this is the output

Code: Select all

*/5 * * * * root php /usr/share/cacti/poller.php > /dev/null 2>&1

date.timezone = America/New_York

Changed timezones in these files

./etc/php5/cli/php.ini
./etc/php5/apache2/php.ini
./etc/php/7.0/cli/php.ini
./etc/php/7.0/apache2/php.ini


Where would I go to change the MYSQL timezone?

[netniV]

There will b a MySQL ini or cnf file. For ubuntu this is normally under /etc/mysql/

[athornfam2]

Polling seemed to be consistent from 12 am to 7:30 am when I checked it... however, it was 10-15 minutes behind real time.

[athornfam2]

Any suggestions?

[netniV]

Any warnings or errors in the cacti.log file?

[athornfam2]

Errors
04/16/2018 10:30:07 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'value' cannot be null
04/16/2018 10:30:07 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:'REPLACE INTO settings (name, value) VALUES ('rrd_step_counter', ?)'

SQL Call
04/16/2018 10:30:07 - CMDPHP SQL Backtrace: (/poller_commands.php: 112 run_data_query)(/lib/data_query.php: 154 update_poller_cache_from_query)(/lib/utility.php: 90 update_poller_cache)(/lib/utility.php: 311 api_poller_cache_item_add)(/lib/api_poller.php: 87 api_poller_get_rrd_next_step)(/lib/api_poller.php: 149 db_execute_prepared)(/lib/database.php: 209 cacti_debug_backtrace)


Warnings

04/18/2018 14:10:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[11] Device[Bandwidth Test York ASA] Thread[1] DS[Bandwidth Test York ASA - 5 Minute CPU]
04/18/2018 14:10:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[4] Device[7] Device[3750-Stack] Thread[1] Graphs[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-2] Graphs[3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St1-1] Graphs[3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-1] Graphs[3750-Stack - Traffic - StackSub-St2-2, 3750-Stack - Traffic - StackSub-St2-2] DS[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-2]
04/18/2018 14:10:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[14] Device[Bandwidth - Dover ASA 5505] Thread[1] DS[Bandwidth - Dover ASA 5505 - 5 Minute CPU]
04/18/2018 14:05:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[11] Device[Bandwidth Test York ASA] Thread[1] DS[Bandwidth Test York ASA - 5 Minute CPU]
04/18/2018 14:05:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[4] Device[7] Device[3750-Stack] Thread[1] Graphs[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-2] Graphs[3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St1-1] Graphs[3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-1] Graphs[3750-Stack - Traffic - StackSub-St2-2, 3750-Stack - Traffic - StackSub-St2-2] DS[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-2]
04/18/2018 14:05:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[14] Device[Bandwidth - Dover ASA 5505] Thread[1] DS[Bandwidth - Dover ASA 5505 - 5 Minute CPU]
04/18/2018 14:00:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[11] Device[Bandwidth Test York ASA] Thread[1] DS[Bandwidth Test York ASA - 5 Minute CPU]
04/18/2018 14:00:03 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[4] Device[7] Device[3750-Stack] Thread[1] Graphs[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-2] Graphs[3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St1-1] Graphs[3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-1] Graphs[3750-Stack - Traffic - StackSub-St2-2, 3750-Stack - Traffic - StackSub-St2-2] DS[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-2]
04/18/2018 14:00:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[14] Device[Bandwidth - Dover ASA 5505] Thread[1] DS[Bandwidth - Dover ASA 5505 - 5 Minute CPU]
04/18/2018 13:57:03 - DSSTATS WARNING: File '/usr/share/cacti/rra/york_asa_5506-x_traffic_in_214.rrd' Graphs[York ASA 5506-X - Traffic - outside, York ASA 5506-X - Traffic - outside]DS[York ASA 5506-X - Traffic - 73.101.208.132 - outside] Does not exist
04/18/2018 13:55:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[11] Device[Bandwidth Test York ASA] Thread[1] DS[Bandwidth Test York ASA - 5 Minute CPU]
04/18/2018 13:55:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[4] Device[7] Device[3750-Stack] Thread[1] Graphs[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-2] Graphs[3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St1-1] Graphs[3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-1] Graphs[3750-Stack - Traffic - StackSub-St2-2, 3750-Stack - Traffic - StackSub-St2-2] DS[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-2]
04/18/2018 13:55:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[14] Device[Bandwidth - Dover ASA 5505] Thread[1] DS[Bandwidth - Dover ASA 5505 - 5 Minute CPU]
04/18/2018 13:50:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[11] Device[Bandwidth Test York ASA] Thread[1] DS[Bandwidth Test York ASA - 5 Minute CPU]
04/18/2018 13:50:03 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[4] Device[7] Device[3750-Stack] Thread[1] Graphs[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-2] Graphs[3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St1-1] Graphs[3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-1] Graphs[3750-Stack - Traffic - StackSub-St2-2, 3750-Stack - Traffic - StackSub-St2-2] DS[3750-Stack - Traffic - StackSub-St1-2, 3750-Stack - Traffic - StackSub-St1-1, 3750-Stack - Traffic - StackSub-St2-1, 3750-Stack - Traffic - StackSub-St2-2]
04/18/2018 13:50:02 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[14] Device[Bandwidth - Dover ASA 5505] Thread[1] DS[Bandwidth - Dover ASA 5505 - 5 Minute CPU]
04/18/2018 13:45:04 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[11] Device[Bandwidth Test York ASA] Thread[1] DS[Bandwidth Test York ASA - 5 Minute CPU]

[netniV]

04/16/2018 10:30:07 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'value' cannot be null
04/16/2018 10:30:07 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:'REPLACE INTO settings (name, value) VALUES ('rrd_step_counter', ?)'

That would be a big problem. I don't believe that should ever be null.

[netniV]

I've recorded that above log as Issue 1553

[athornfam2]

So is this an issue on my part or a bug? Should I upgrade from 1.1.37 to 1.1.38?

[phalek]

Well, you can set the initial value to 0 to start with:

Code: Select all

REPLACE INTO settings (name, value) VALUES ('rrd_step_counter', 0);

I assume it's a bug as this is not being pre-defined in the cacti.sql nor is is set somewhere else in the code ( checked with GitHub and my PHPStorm IDE ).

[athornfam2]

04/16/2018 10:30:07 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'value' cannot be null
04/16/2018 10:30:07 - DBCALL ERROR: A DB Exec Failed!, Error:1048, SQL:'REPLACE INTO settings (name, value) VALUES ('rrd_step_counter', ?)'

That would be a big problem. I don't believe that should ever be null.

I'm naive to this... where would I go to perform these changes like the last person said. The closest I've found to that SQL string is within the poller.php file but nothing exactly like it.

[netniV]

That is because it's actually a line that is something like read_config_option('rrd_step_counter')

The latest development code has been patched to correct this issue. You may want to check the link above to see the fix.