Re: Exim 4.99 mysql and pgsql lookups

On 2025/11/25 4:33 PM, Harry Mills via Exim-users wrote:
> unable to complete match against "+local_sender_domains": unknown lookup type "pgsql" inside .....
> 
> We get almost identical errors when the database lookup uses "mysql".
> 
> The base OS is Rocky Linux and both Rocky 8 and Rocky 9 are affected the same way. The Exim packages are installed from EPEL.

Sounds like either the exim binary has been built without either static-linked
or dynamic-linked lookups for those types, or dynamic and the lookups modules
cannot be loaded.

Does "exim bV' list them for "Lookups (built_in)"?
That's the static-build case.

What does "exim -bP macros | grep PGSQL" give?
That covers both cases.


For the cannot-load-module case, we'll need to discover where exim
was built to look for them.  Try:
   exim -dS -d -bV 2>&1 | grep 'lookup modules'

Modules should be in this directory as .so files. The one for pgsql
should be called "pgsql_lookup.so".  If there is a file called "pgsql.so"
then just rename it - and any other similar cases ( _lookup, _router,
_transport, _auth and _miscmod are the labels for various classes of
module).
-- 
Cheers,
   Jeremy

-- 
## subscription configuration (requires account):
##   https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
##   [email protected]
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/