- Package:
- prelude-manager
- Source:
- prelude-manager
- Description:
- Security Information and Events Management System [ Manager ]
- Submitter:
- Krzysztof Jastrzębski
- Date:
- 2023-02-14 17:33:05 UTC
- Severity:
- normal
Trying to use postgresql backend ends with: prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) WARNING: /usr/lib/x86_64-linux-gnu/libpreludedb/plugins/sql/pgsql: file not found. prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) WARNING: Option error: error initializing libpreludedb SQL interface: Could not load sql plugin 'pgsql'. prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) INFO: Subscribing Normalize to active decoding plugins. prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) INFO: server started (listening on 127.0.0.1 port 4690). prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) INFO: server started (listening on 192.168.1.xx port 4690). systemd[1]: prelude-manager.service: Main process exited, code=exited, status=255/EXCEPTION systemd[1]: prelude-manager.service: Failed with result 'exit-code'. Using mysql backend (libpreludedb7-mysql) works fine. Although first warning (file not found) is returned regardless of used driver. Both libs are in the same place with same extensions and rigts: /usr/lib/x86_64-linux-gnu/libpreludedb/plugins/sql -rw-r--r--. 1 root root 947 2020-12-07 mysql.la -rw-r--r--. 1 root root 22696 2020-12-07 mysql.so -rw-r--r--. 1 root root 947 2020-12-07 pgsql.la -rw-r--r--. 1 root root 26792 2020-12-07 pgsql.so Expected behaviour: Be able to use both database backends. My OS (up2date): VERSION="11 (bullseye)" Can it be problem with: ii libpreludedb7-pgsql:amd64 5.2.0-1+b1 ???
Under Centos-like distros, postgres backend is usable. EPEL RPM: preludedb-pgsql.x86_64 5.2.0-2.el9 @epel [root@rocky ~]# rpm -ql preludedb-pgsql | grep pgsql.so /usr/lib64/libpreludedb/plugins/sql/pgsql.so Above driver is found by prelude-manager, loaded and used. So if same upstrem sources were used, maybe problem is with Debian libpq-dev package? BTW: also trying pgsql driver with prewikka Debian package ends with: /usr/lib/x86_64-linux-gnu/libpreludedb/plugins/sql/pgsql: file not found. (also in 5.2.0-2 version under bookworm) Centos is not planned - good to see prelude at production...