Package: monitorix
Severity: normal

Dear Maintainer,

As reported in https://github.com/YunoHost-Apps/monitorix_ynh/issues/77 it seems that monitorix needs to be adjusted to be able to connect to MariaDB instead of MySQL.

If I'm not mistaken this applies to the Debian package and not to the derived version provided by YunoHost maintainers.

The dependencies probably need an adjustment to include libdbd-mariadb-perl (suggested ?) and the source for the connection string needs to be adjusted (see patch at https://github.com/YunoHost-Apps/monitorix_ynh/issues/77#issuecomment-2782379357)

Hope this helps,

-- System Information:
Debian Release: 12.9
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 6.12.12+bpo-amd64 (SMP w/4 CPU threads; PREEMPT)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages monitorix depends on:
ii init-system-helpers 1.65.2
pn libconfig-general-perl <none>
pn libdbi-perl <none>
pn libhttp-server-simple-perl <none>
ii libio-socket-ssl-perl 2.081-2
ii libmailtools-perl 2.21-2
pn libmime-lite-perl <none>
pn librrds-perl <none>
ii libwww-perl 6.68-1
ii libxml-libxml-perl 2.0207+dfsg+really+2.0134-1+b1
pn libxml-simple-perl <none>
pn net-tools <none>
ii perl 5.36.0-7+deb12u1
pn rrdtool <none>

monitorix recommends no packages.

monitorix suggests no packages.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Hi Olivier,

On Mon, 2025-04-07 at 18:52 +0200, Olivier Berger wrote:

As reported in
https://github.com/YunoHost-Apps/monitorix_ynh/issues/77 it seems
that monitorix needs to be adjusted to be able to connect to MariaDB
instead of MySQL.

I just tested and it seems to work fine with libdbd-mysql-perl
installed and MariaDB.

Unless you have a configuration where this does not work, I don't think
we need to change the URI in the mysql.pm file or switch to libdbd- mariadb-perl.

If I'm not mistaken this applies to the Debian package and not to the
derived version provided by YunoHost maintainers.

The dependencies probably need an adjustment to include
libdbd-mariadb-perl (suggested ?) and the source for the connection
string needs to be adjusted (see patch at

https://github.com/YunoHost-Apps/monitorix_ynh/issues/77#issuecomment-2782379357)

I can certainly add libdbd-mariadb-perl (and libdbd-pg-perl) to
Suggests to hint for their installation.

Let me know what you think,

Best,
--
Baptiste Beauplat

-----BEGIN PGP SIGNATURE-----

iHUEABYIAB0WIQQt4kiVMTxdp/CJ4U4XSUsQeV3XMwUCZ/VSKwAKCRAXSUsQeV3X MzSqAP9bUoaqibdfsoLD+gABGiA2vz9exwbmDS/6ivUw/TdXTgEA9oC6HoIpKUEa GNTh9l54mClVMloeOX1n04e9BxbzHgw=
=gVh5
-----END PGP SIGNATURE-----

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Tue, 2025-04-08 at 18:43 +0200, Baptiste Beauplat wrote:

Hi Olivier,

On Mon, 2025-04-07 at 18:52 +0200, Olivier Berger wrote:

As reported in
https://github.com/YunoHost-Apps/monitorix_ynh/issues/77 it seems
that monitorix needs to be adjusted to be able to connect to MariaDB instead of MySQL.

I just tested and it seems to work fine with libdbd-mysql-perl
installed and MariaDB.

Unless you have a configuration where this does not work, I don't think
we need to change the URI in the mysql.pm file or switch to libdbd- mariadb-perl.

If I'm not mistaken this applies to the Debian package and not to the derived version provided by YunoHost maintainers.

The dependencies probably need an adjustment to include
libdbd-mariadb-perl (suggested ?) and the source for the connection
string needs to be adjusted (see patch at

https://github.com/YunoHost-Apps/monitorix_ynh/issues/77#issuecomment-2782379357)

I can certainly add libdbd-mariadb-perl (and libdbd-pg-perl) to
Suggests to hint for their installation.

Mmm, I meant libdbd-mysql-perl here, sorry.

Let me know what you think,

Best,
--
Baptiste Beauplat

-----BEGIN PGP SIGNATURE-----

iHUEABYIAB0WIQQt4kiVMTxdp/CJ4U4XSUsQeV3XMwUCZ/VYRQAKCRAXSUsQeV3X M1wcAQCyPV32nrlhmiGZ0ZZvHIvV8313IHJSMm52mR9nPYx7rwD/UMzS76nWRqKj z4tLFcgkMQb3cRbnC4yOkLxR4JA/Bgw=
=y8vf
-----END PGP SIGNATURE-----

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Hi.

Thanks for caring.

Indeed, it seems to be working fine by juste adding the libdbd-mysql-perl package.

I was probably confused by the fact that I saw that we only had a MariaDB install running.

Sorry about the mess.

I'll revert my changes to the .pm code.

Thanks.

Best regards,

Le Tue, Apr 08, 2025 at 06:43:23PM +0200, Baptiste Beauplat a écrit :

I just tested and it seems to work fine with libdbd-mysql-perl
installed and MariaDB.

Unless you have a configuration where this does not work, I don't think
we need to change the URI in the mysql.pm file or switch to libdbd- mariadb-perl.

--
Baptiste Beauplat

--
Olivier BERGER
(OpenPGP: 4096R/7C5BB6A5)
http://www.olivierberger.com/weblog/

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)