search

scline / docker-cacti

Cacti version 1+ under Docker
113 stars 56 forks source link

Plugin caching_sha2_password could not be loaded #88

Open chrisgerman opened 3 years ago

chrisgerman commented 3 years ago

Getting the following error and yes I'm using MySql 8.0.23 when installing the docker image.

ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: /usr/lib64/mariadb/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

chrisgerman commented 3 years ago

P.S. I checked the folder and I don't see caching_sha2_password.so but after doing yum update then install. It shows up?

chrisgerman commented 3 years ago

It seems I got it working after doing a yum update and yum upgrade, then manually adding the USER in MySQL with the following commands

USE cacti; CREATE USER 'cacti'@'%' IDENTIFIED BY 'password'; GRANT ALL ON *.* TO 'cacti'@'%'; GRANT SELECT ON mysql.time_zone_name TO 'cacti'@'%'; FLUSH PRIVILEGES;

Had to do this because MySql 8 syntax is different.

Then removed the install.lock with rm -f /cacti/install.lock to force another install after restarting the container.

I have a few issues with my database like giving it more and buffer size. I will do that and see what happens.