bareos-dbcheck/bareos-dir -t fails everytime

[Max]

Hi guys,

I've got  a Rocky 9 Linux VM with a predeployed PostgreSQL-DB (14.11) via ansible.

The name, dbname, dbuser & dbpassword are set correctly in "/etc/bareos/bareos-dir.d/catalog/MyCatalog.conf" and the bconsole seem to work also.

I encounter the following error everytime I run "bareos-dbcheck" OR "bareos-dir -t"  with the bareos system user:

[bareos@storage-test01 ~]$ bareos-dir -t
bareos-dir: /usr/pgsql-14/lib/libpq.so.5: no version information available (required by /usr/lib64/bareos/libbareossql.so.23)

the commands also dont work as root or postgres user.

ps aux | grep postgres output:
[root@storage-test01 ~]# ps aux | grep postgres
postgres   39294  0.0  0.7 1162756 57780 ?       Ss   13:59   0:00 /usr/pgsql-14/bin/postmaster -D /var/lib/pgsql/14/data/
postgres   39295  0.0  0.0  65268  5776 ?        Ss   13:59   0:00 postgres: logger  
postgres   39297  0.0  0.2 1162972 19516 ?       Ss   13:59   0:00 postgres: checkpointer  
postgres   39298  0.0  0.1 1162756 13300 ?       Ss   13:59   0:00 postgres: background writer  
postgres   39299  0.0  0.3 1162756 23228 ?       Ss   13:59   0:00 postgres: walwriter  
postgres   39300  0.0  0.0  66144  5724 ?        Ss   13:59   0:00 postgres: stats collector  
postgres   39301  0.0  0.0 1163188 7232 ?        Ss   13:59   0:00 postgres: logical replication launcher

 

Im hoping someone can help me since I dont know anymore what to check.

best regards 

Max

[Sebastian Sura]

Hi Max,

does the same warning occur if you try to run psql ? I suspect that libpq and your postgres server have different versions.
Is it possible you installed them from different sources ? E.g. one is from your distributions repository while the other is from the postgres themselves ?

Kind Regards
Sebastian Sura

26.04.24 um 14:28 schrieb Max:

--
You received this message because you are subscribed to the Google Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/6b441319-cb58-4349-9e94-179f87686988n%40googlegroups.com.

-- 
 Sebastian Sura                  sebasti...@bareos.com
 Bareos GmbH & Co. KG            Phone: +49 221 630693-0
 https://www.bareos.com
 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
 Komplementär: Bareos Verwaltungs-GmbH
 Geschäftsführer: Stephan Dühr, Jörg Steffens, Philipp Storz

[Andreas Rogge]

Hi Max,

that is reported by libpq (i.e. the PostgreSQL client library). I guess
you're using a third-party packaged libpq (instead of the one provided
by Rocky).
As far as I can tell this is only a warning message.

Best Regards,
Andreas

Am 26.04.24 um 14:28 schrieb Max:

> Hi guys,
> I've got  a Rocky 9 Linux VM with a predeployed PostgreSQL-DB (14.11)
> via ansible.
> The name, dbname, dbuser & dbpassword are set correctly in
> "/etc/bareos/bareos-dir.d/catalog/MyCatalog.conf" and the bconsole seem
> to work also.
>
> I encounter the following error everytime I run "bareos-dbcheck" OR
> "bareos-dir -t"  with the bareos system user:
>
> [bareos@storage-test01 ~]$ bareos-dir -t
> bareos-dir: /usr/pgsql-14/lib/libpq.so.5: no version information
> available (required by /usr/lib64/bareos/libbareossql.so.23)

--
Andreas Rogge andrea...@bareos.com
Bareos GmbH & Co. KG Phone: +49 221-630693-86
http://www.bareos.com

[Max]

Hey Andreas,

thanks for reaching out!

I think you are right with it being just a warning since everthing seems to work properly except the db self-checks.

The database gets installed via our own postgres ansible role to meet our standards, the used repos are seen in the output of dnf info *postgres*:

Installierte Pakete
Name         : bareos-database-postgresql
Version      : 23.0.3~pre104.aaf825630
Release      : 84.el9
Architektur  : x86_64
Größe        : 57 k
Quelle       : bareos-23.0.3~pre104.aaf825630-84.el9.src.rpm
Paketquelle  : @System
Aus Paketque : bareos


Name         : postgresql14
Version      : 14.11
Release      : 1PGDG.rhel9
Architektur  : x86_64
Größe        : 7.6 M
Quelle       : postgresql14-14.11-1PGDG.rhel9.src.rpm
Paketquelle  : @System
Aus Paketque : pgdg14

Name         : postgresql14-contrib
Version      : 14.11
Release      : 1PGDG.rhel9
Architektur  : x86_64
Größe        : 2.6 M
Quelle       : postgresql14-14.11-1PGDG.rhel9.src.rpm
Paketquelle  : @System
Aus Paketque : pgdg14

Name         : postgresql14-libs
Version      : 14.11
Release      : 1PGDG.rhel9
Architektur  : x86_64
Größe        : 930 k
Quelle       : postgresql14-14.11-1PGDG.rhel9.src.rpm
Paketquelle  : @System
Aus Paketque : pgdg14

Name         : postgresql14-server
Version      : 14.11
Release      : 1PGDG.rhel9
Architektur  : x86_64
Größe        : 23 M
Quelle       : postgresql14-14.11-1PGDG.rhel9.src.rpm
Paketquelle  : @System
Aus Paketque : pgdg14

best regards

Max

[Andreas Rogge]

Hi Max,

Am 29.04.24 um 13:13 schrieb Max:

> The database gets installed via our own postgres ansible role to meet
> our standards, the used repos are seen in the output of dnf info *postgres*:
>

[...]

>
> Name         : postgresql14
> Version      : 14.11
> Release      : 1PGDG.rhel9
> Architektur  : x86_64
> Größe        : 7.6 M
> Quelle       : postgresql14-14.11-1PGDG.rhel9.src.rpm
> Paketquelle  : @System
> Aus Paketque : pgdg14

[...]

Yep. That's a third-party repository. While it is probably the "most
official" version of PostgreSQL you can acquire, its libpq seems to be
unhappy, because the Bareos build you're using was buillt with this:

Name : libpq
Version : 13.11
Release : 1.el9
Architecture : x86_64
Source : libpq-13.11-1.el9.src.rpm
Repository : rhel-9-for-x86_64-appstream-rpms

I'm not sure if there is a workaround to silence the warning or if
you're possibly going to run into problems with that setup.
However, you can always build your own RPMs that link to the libpq you want.

Best Regards,
Andreas