Package: dovecot-pgsql
Version: 1:2.4.1+dfsg1-7
Severity: grave
Justification: renders package unusable
Dear Maintainer,
This morning, my Sid system upgraded dovecot-pgsql from 1:2.4.1+dfsg1-6
to 1:2.4.1+dfsg1-7. During the same upgrade, libpq5 was updated from 17.6 to
18~rc2.
After this, dovecot is unable to connect to the database, spewing errors
like:
Sep 23 10:38:58 mango dovecot[4295]: auth: Error: Couldn't load plugin
/usr/lib/dovecot/modules/auth/libdriver_pgsql.so: dlopen() failed:
/usr/lib/dovecot/modules/auth/libdriver_pgsql.so: undefined symbol: PQsendQuery
Sep 23 10:38:58 mango dovecot[4295]: auth: Fatal: passdb sql: Unknown database
driver 'pgsql'
Looking at ldd for ldd /usr/lib/dovecot/modules/libdriver_pgsql.so, I
see that it is not linked against libpq5.so.
I tried reinstalling either package, but this did not fix the issue.
The same file on Debian Trixie is linked against libpq5.so. There might
have been a change between the dovecot in Trixie and Sid, or the Sid
package might need to be rebuilt and linked against the new libpq5?
I don't seem to have a copy of the old package file around, so I am
converting my installation to not use Postgresql to ensure I can receive
email.
Best regards,
Pieter Lexis
-- Package-specific info:
dovecot configuration
---------------------
# 2.4.1-4 (7d8c0e5759): /etc/dovecot/dovecot.conf
# Pigeonhole version 2.4.1-4 (0a86619f)
# OS: Linux 6.16.8+deb14-amd64 x86_64 Debian forky/sid
# Hostname: mango.plexis.eu
# 4 default setting changes since version 2.4.0
dovecot_config_version = 2.4.0
auth_mechanisms = plain
dovecot_storage_version = 2.4.0
fts_autoindex = yes
fts_autoindex_max_recent_msgs = 999
fts_search_add_missing = yes
lda_mailbox_autocreate = yes
lda_mailbox_autosubscribe = yes
mail_privileged_group = mail
protocols {
imap = yes
lmtp = yes
sieve = yes
}
sql_driver = pgsql
ssl = required
pgsql localhost {
parameters {
dbname = mail
host = /var/run/postgresql
user = mailreader
}
}
passdb sql {
default_password_scheme = SHA512
query = SELECT email as user, password from users where email = '%{user}'
}
userdb sql {
query = SELECT email as user, '/srv/mail/maildir/'||maildir as mail_path,
'/srv/mail/home/'||maildir as home, 500 as uid, 500 as gid FROM users WHERE
email = '%{use
r}'
}
namespace inbox {
inbox = yes
mailbox Drafts {
auto = subscribe
special_use = "\\Drafts"
}
mailbox Junk {
auto = subscribe
special_use = "\\Junk"
}
mailbox Trash {
auto = subscribe
special_use = "\\Trash"
}
mailbox Sent {
auto = subscribe
special_use = "\\Sent"
}
mailbox "Sent Messages" {
special_use = "\\Sent"
}
}
service imap-login {
inet_listener imap {
}
inet_listener imaps {
}
}
service pop3-login {
inet_listener pop3 {
}
inet_listener pop3s {
}
}
service lmtp {
unix_listener /var/spool/postfix/private/dovecot-lmtp {
group = postfix
mode = 0666
user = postfix
}
}
service imap {
}
service pop3 {
}
service auth {
unix_listener auth-userdb {
}
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0666
user = postfix
}
}
service auth-worker {
}
service dict {
unix_listener dict {
}
}
ssl_server {
cert_file = /etc/letsencrypt/live/mail.plexis.eu/fullchain.pem
key_file = /etc/letsencrypt/live/mail.plexis.eu/privkey.pem
}
protocol imap {
mail_max_userip_connections = 30
}
protocol lmtp {
hostname = mail.plexis.eu
mail_plugins {
sieve = yes
}
postmaster_address = [email protected]
}
service managesieve-login {
inet_listener sieve {
port = 4190
}
}
service managesieve {
}
-- System Information:
Debian Release: forky/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 6.16.8+deb14-amd64 (SMP w/1 CPU thread; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8),
LANGUAGE=en_US:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages dovecot-pgsql depends on:
ii dovecot-core 1:2.4.1+dfsg1-7
ii libc6 2.41-12
dovecot-pgsql recommends no packages.
dovecot-pgsql suggests no packages.
Versions of packages dovecot-pgsql is related to:
ii dovecot-core [dovecot-common] 1:2.4.1+dfsg1-7
pn dovecot-dev <none>
pn dovecot-gssapi <none>
ii dovecot-imapd 1:2.4.1+dfsg1-7
pn dovecot-ldap <none>
ii dovecot-lmtpd 1:2.4.1+dfsg1-7
ii dovecot-managesieved 1:2.4.1+dfsg1-7
pn dovecot-mysql <none>
ii dovecot-pgsql 1:2.4.1+dfsg1-7
pn dovecot-pop3d <none>
ii dovecot-sieve 1:2.4.1+dfsg1-7
pn dovecot-sqlite <none>
-- no debconf information
