Upgrading from 1.138 to 1.2.17

[vossler19]

Hi all - I have a new server built for cacti - but when I installed fresh it pulled version 1.138. I have no RRA or graphs, and nothing in the database. Following this, however I am still stuck at 1.138 --

https://github.com/Cacti/documentation/ ... g-Cacti.md

I seem to be missing something obvious - any tips? 1.1.38 loads up fine via web browser - but nothing seems to be copying 1.2.17 to the correct directory -

1.13.8 is currently in /usr/share/cacti, I do not see anything in /var/www/html/

[bmfmancini]

Going to need a lot more info on this

how are you doing the upgrade package or compiling ?
when you say the database is empty are all of the tables empty or there is no data at all ?

did you by chance import the cacti.sql database ? you should not do that if this is an upgrade

[vossler19]

Brand new install - I installed all the pre-reqs - did and apt-get cacti and on Ubuntu 18.04 and it installed 1.138. There are no graphs/RRAs/anything - database was created when Cacti was installed and the password change - that is all. Is there a specific link I should be using to go directly to 1.2.17 instead of installing 1.138?

EDIT - Sean - your own article helped me out - mad props man!

https://www.seanmancini.com/2019/02/fix ... ion-error/

[bmfmancini]

follow this guide

https://github.com/Cacti/documentation/ ... -Debian.md

[vossler19]

So going through that - and ran into this error - after attempting to run this command -

\sudo mysql -u root cacti < /var/www/html/cacti/cacti.sql

ERROR 1071 (42000) at line 1987: Specified key was too long; max key length is 767 bytes

I did create the database with these settings-

CREATE DATABASE cacti DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci; ;
GRANT ALL PRIVILEGES ON cacti.* TO 'cacti'@'localhost' IDENTIFIED BY 'cacti';
GRANT SELECT ON mysql.time_zone_name TO cacti@localhost;
ALTER DATABASE cacti CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
FLUSH PRIVILEGES;

Now getting this - which I believe is tied to the above -

[bmfmancini]

ensure your my.cnf has
innodb_large_prefix = 1
if not add it restart mysql or mariadb
then try to re-import the db

[bmfmancini]

Here is a sample my.cnf you should match up

innodb_file_format = Barracuda
character_set_client = utf8mb4
max_allowed_packet = 16777777
join_buffer_size = 32M
innodb_file_per_table = ON
innodb_large_prefix = 1
innodb_buffer_pool_size = 250M
innodb_additional_mem_pool_size = 90M
innodb_flush_log_at_trx_commit = 2
innodb_doublewrite = ON

[vossler19]

Getting closer - but in adding this to the client server area of the /etc/mysql/my.cnf - I get an error on each line -

mysql: unknown variable 'innodb_file_format=Barracuda'

I commented that out - then on the very next line -

mysql: unknown variable 'character_set_client=utf8mb4'

Attached is a SS of the my.cnf file - I am sure I am missing something again -

Also - here is the version of my mariadb - Server version: 10.1.47-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

[vossler19]

Fixed it - needed to add a [mysqld} tag - Thanks so much so far for your help Sean!

[vossler19]

Making some progress -- I have the timezone set in my system as the database is using system as the timezone as well -- Is there any way to bypass these checks? (attached)

[bmfmancini]

oh for that make sure you have the timezone set in php.ini
there are two of them for ubuntu/debian

cli/php.ini
apache/php.ini

usually in /etc/php/<version number>/cli

[vossler19]

Yep your own linked helped out - any ideas on this error when attempting to install plugins?


Disregard - I had capitalized in the directory -- all set now.

[vossler19]

What is the correct crontab setting - I am getting the "The cacti poller has not run yet.".

After banging my head against it - got it.

[macan]

What is the correct crontab setting - I am getting the "The cacti poller has not run yet.".

After banging my head against it - got it.

Bad username, in /etc/crontab is something like this:
*/5 * * * * cacti /usr/local/bin/php /usr/local/share/cacti/poller.php 2>&1

6th column is username. Poller is running with this user's privileges You have here wrong username.

[vossler19]

Yep - I got it by using the google machine. Thanks for all the help!