Errors & Database Maintenance monitor Red.

[Mario]

Like it

Up

1

Down

Drop it

::

Hello, good afternoon,

The best way to check the problem you are reporting is to run the pandora_db script and the Pandora FMS server process manually.

To execute pandora_db maintenance script in shell CLI:

perl /usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf

To execute pandora_server as process:

/usr/bin/pandora_server /etc/pandora/pandora_server.conf

Please send us the output of these commands.

Kind regards

[JonRussell]

Like it

Up

0

Down

Drop it

::

Hi,

Thanks for the fast reply.

> perl /usr/share/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf
Pandora FMS DB Tool v7.0NG.777 Build 240612 
This program is Free Software, licensed under the terms of GPL License v2 
You can download latest versions and documentation at official web 
[*] DB Host is 127.0.0.1 
install_driver(mysql) failed: Can't load '/usr/lib/x86_64-linux-gnu/perl5/5.34/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/x86_64-linux-gnu/perl5/5.34/auto/DBD/mysql/mysql.so: undefined symbol: mysql_sqlstate at /usr/lib/x86_64-linux-gnu/perl-base/DynaLoader.pm line 187. 
at (eval 25) line 3. 
Compilation failed in require at (eval 25) line 3. 
Perhaps a required shared library or dll isn't installed where expected 
at /usr/lib/perl5/PandoraFMS/DB.pm line 159.

That looks like it might be the mysql driver?

However, what’s very weird, is it seems to run perfectly, if I start it from the command line. But not when I start it with systemctl?

> /usr/bin/pandora_server /etc/pandora/pandora_server.conf
Pandora FMS Server v7.0NG.777 Build 240612
This program is OpenSource, licensed under the terms of GPL License version 2.
You can download latest versions and documentation at official web page.
 [*] DB Host is 127.0.0.1
 [*] Pandora FMS Enterprise module not available.
 [*] NetFlow daemon disabled.
 [*] sFlow daemon disabled.
 [*] Starting Pandora FMS Data Server.
 [*] Starting Pandora FMS Network Server.
 [*] Starting Pandora FMS Discovery Server.
 [*] Starting Pandora FMS WMI Server.
 [*] Starting Pandora FMS Plugin Server.
 [*] Starting Pandora FMS Web Server.
 [*] Starting Pandora FMS Inventory Server.

The web gui is fine and everything is running.

But if I start it with :

> systemctl start pandora_server
> systemctl status pandora_server
* pandora_server.service - LSB: Pandora FMS Server startup script
     Loaded: loaded (/etc/init.d/pandora_server; generated)
     Active: active (running) since Tue 2026-01-20 18:43:18 CET; 9s ago
       Docs: man:systemd-sysv-generator(8)
    Process: 6840 ExecStart=/etc/init.d/pandora_server start (code=exited, status=0/SUCCESS)
      Tasks: 1 (limit: 2139)
     Memory: 38.8M
        CPU: 255ms
     CGroup: /system.slice/pandora_server.service
             └─6866 /usr/bin/perl /usr/bin/pandora_ha -d -p /var/run/pandora_ha.pid /etc/pandora/pandora_server.conf
Jan 20 18:43:16 pandora systemd[1]: Starting LSB: Pandora FMS Server startup script...
Jan 20 18:43:16 pandora pandora_server[6858]: Pandora FMS Daemon Watchdog 7.0NG.777 240612 Copyright (c) Pandora FMS
Jan 20 18:43:16 pandora pandora_server[6858]: Pandora HA v7.0NG.777 Build 240612
Jan 20 18:43:16 pandora pandora_server[6858]: This program is OpenSource, licensed under the terms of GPL License version 2.
Jan 20 18:43:16 pandora pandora_server[6858]: You can download latest versions and documentation at official web page.
Jan 20 18:43:16 pandora pandora_server[6858]:  [*] DB Host is 127.0.0.1
Jan 20 18:43:18 pandora pandora_server[6840]: Pandora FMS Server is now running with PID 6866
Jan 20 18:43:18 pandora systemd[1]: Started LSB: Pandora FMS Server startup script.

Although it says its started, the web gui complains there are no services running, and none of my monitors update.

ChatGPT suggested I should diable the ha feature, as I’m only running a single server, and that was causing the problem. do you think it has anything to do with ha ?

ChatGPT:

OPTION A (Recommended): Disable HA wrapper if you’re single-node
If you are not using Pandora HA, disable it.
Edit:
/etc/pandora/pandora_server.conf
Set:
ha_enabled 0
Then:
systemctl stop pandora_server
rm -f /var/run/pandora/*.pid
systemctl start pandora_server
This fixes 90% of cases like yours.

[JonRussell]

Like it

Up

1

Down

Drop it

::

I’ve fixed it, with the help of ChatGPT. It was the ubuntu mysql lib.

These commands fixed it. from two different chatGPT questions. The first set still gave errors, but the second set fixed it. I think the cpanm DBD command was wrong in the first set, as it switched to cpanm DBI in the second and that worked. My server is now up and running again and the DB maintenance task completes.

It seems there is a problem with the Ubuntu libdbd-mysql-perl that was released this week.

This is the solution. Not sure if all these are needed, but it works now ..

sudo apt remove libdbd-mysql-perl
sudo apt install libperconaserverclient21 percona-server-client
sudo apt install build-essential libmysqlclient-dev cpanminus
sudo cpanm DBD::mysql
sudo apt-mark hold libdbd-mysql-perl

sudo apt install libdbi-perl
sudo cpanm DBI

Thanks!

[Mario]

Like it

Up

1

Down

Drop it

::

Great!

It must be that with the update of some system package, you lost that library because it wasn’t necessary (Ubuntu sometimes does these things…).

Kind regards