#45 No signing table match when using signing table stored in Postgres

[Rigved Rakshit]

Hello,

We have a setup where opendkim signs emails for around 250,000 domains. It randomly fails to sign emails for certain domains with the following error message:

opendkim[66]: 3E7BC782945: no signing table match for 'email id'

On restarting the application, it starts working fine for that email ID. However, after sometime, it starts to fail again for some other email ID.

Could someone please help out with this issue?

Details about the setup:

OpenDKIM version: 2.11.0~alpha-10+deb9u1
OS: Debian 9.2 Docker container
OpenDKIM has been installed from the Debian 9 "stretch/main" repo.

opendkim.conf:

# OpenDKIM config file
# See opendkim.conf(5) or /usr/share/doc/opendkim-2.1.3/opendkim.conf.sample for more
Mode                   s
Canonicalization       relaxed/relaxed
SigningTable           dsn:pgsql://username:password@port+load_balancer_domain.com/db/table=dkimtable?keycol=dvalue?datacol=keyname
KeyTable               dsn:pgsql://username:password@port+load_balancer_domain.com/db/table=dkimtable?keycol=keyname?datacol=dvalue,svalue,privatekey
LogWhy                 yes
Syslog                 yes
SyslogFacility         mail
MilterDebug             1
UserID                  opendkim
InternalHosts           /etc/opendkim/TrustedHosts
Socket                 inet:8891
Diagnostics             no
AutoRestart             no

Please let me know in case any further information is required.