Librenms Gelera cluster configuration

Hi Team,

We have planned for Gelera cluster configuration for Librenms
Server 1: Librenms Web and poller
Server 2, server 3 and server 4 : 3 nodes Gelera cluster configiration

Post DB cluster configurations, Poller stop working. kindly some one assist on this issue. If any sync missed out as part of Custer configurations
Please find below ./validate.php output
[librenms@adsomnossapp01 ~]$ ./validate.php

Component Version
LibreNMS 24.8.0-21-g61ad4bfbb (2024-08-26T17:45:12+00:00)
DB Schema 2024_08_12_232009_ent_physical_table_rev_length (298)
PHP 8.1.28
Python 3.6.8
Database MariaDB 10.3.39-MariaDB
RRDTool 1.7.0
SNMP 5.8
===========================================

[OK] Composer Version: 2.7.9
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] APP_KEY does not match key used to encrypt data. APP_KEY must be the sam e on all nodes.
[FIX]:
If you rotated APP_KEY, run lnms key:rotate to resolve.
[OK] Database connection successful
[OK] Database Schema is current
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK] Database and column collations are correct
[OK] Database schema correct
[OK] MySQL and PHP time match
[FAIL] Poller is not running. No poller has run within the last 300 seconds.
[OK] Dispatcher Service not detected
[OK] Locks are functional
[FAIL] No active python wrapper pollers found
[OK] Redis is unavailable
[OK] rrdtool version ok
[OK] Connected to rrdcached
[WARN] Your install is over 24 hours out of date, last update: Mon, 26 Aug 2024 17:45:12 +0000
[FIX]:
Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
config/database.php
html/.htaccess
html/ajax_dash.php
html/ajax_form.php
html/ajax_list.php
html/ajax_listports.php
html/ajax_ossuggest.php
html/ajax_output.php
html/ajax_table.php
html/api_v0.php
html/bandwidth-graph.php
html/billing-graph.php
html/calendar.jpg
html/css/L.Control.Locate.min.css
html/css/L.Control.Locate.min.css.map
and 812 more…

how are you managing your galera cluster? Have you looked at using MaxScale ? If not you should look at it. Its FANTASTIC for this. I have my lnms set up using it and I have a very large network and I can hammer the DB and it doesn’t even flinch figuratively speaking.What does your config look like on your pollers and then your main server. If your .env file doesnt have the same APPKEY it wont work.

Hello Chain,

Thanks for your valuable time.

Right now only one mail poller and 3 separate servers for DB cluster configurations.
Those 3 DB servers we not installed librenms to use .env file. Only we installed Mariadb and Gelera.
Do we need to installed Librenms on DB servers also? to use same APPKEY on .env file.
Under main librenms server .env mentioned cluster configuration servers details and its working fine.
Post enabling clustering, polling not running. Not sure any sync we missed out as part of Gelera cluster configurations.
Kindly help us if any MariaDB Gelera Cluster configuration details. Please

Thank you

Hi Team,

Someone pls help to share Gelera cluster configuration for RHEL8 servers. Facing polling issues post gelera cluster configurations

Thank you