So I am currently working on a project to build a highly available Cacti solution and have ran into a small snag. This solution consists of 5 nodes (2-KeepAliveD/HAProxy nodes with Cacti installed behind NGINX/GlusterFS client mounting cacti Webroot from GlusterFS Servers) and (3-Galera/MariaDB cluster nodes for MySQL DB/GlusterFS Server for Webroot of cacti). All seems to be just fine however when I connect to the second Cacti Web frontend server I am getting the following error.
You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:
mysql -u cactiuser -p cactidb < cacti.sql
This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.
My assumption is that there is something in the CactiDB that is identifying the Web frontend I am connecting from and one is fine but the other is not. I can attempt to import the DB schema from the node that is experiencing the issue but of course that fails because the DB tables already exist and it errors out.
My hope is that maybe someone has some insight into standing up an HA Cacti solution or someone knows how to get around this issue.
Thanks a bunch!
BTW!!! I am putting this all together using Ansible so once I get this working completely it will be shared on my GitHub repo.