FreeBSD rlm_sql_postgresql "could not link driver rlm_sql: ..."

[Mathieu Simon (Lists)]

Hi

Yes, I've read the section in the wiki about this error message*

This happens on on FreeBSD 10.2 using the version in ports, though I'm
uncertain whether I'm looking at the problem from the correct angle as
ldd isn't crying about missing libraries:

# ldd /usr/local/lib/freeradius-3.0.10/rlm_sql_postgresql.so
/usr/local/lib/freeradius-3.0.10/rlm_sql_postgresql.so:
        libpq.so.5 => /usr/local/lib/libpq.so.5 (0x801608000)
        libc.so.7 => /lib/libc.so.7 (0x800821000)
        libthr.so.3 => /lib/libthr.so.3 (0x801836000)
        libintl.so.8 => /usr/local/lib/libintl.so.8 (0x801a5a000)
        libssl.so.7 => /usr/lib/libssl.so.7 (0x801c65000)
        libcrypto.so.7 => /lib/libcrypto.so.7 (0x801ed1000)

There seems not to be a library it cannot find (same for radiusd itself)?

The build logs seem to compile rlm_sql_postgresql without hickup either
and I see no check error:

LINK build/lib/rlm_sql.la
CC src/modules/rlm_sql/drivers/rlm_sql_unixodbc/rlm_sql_unixodbc.c
LINK build/lib/rlm_sql_unixodbc.la
CC src/modules/rlm_sql/drivers/rlm_sql_mysql/rlm_sql_mysql.c
LINK build/lib/rlm_sql_mysql.la
CC src/modules/rlm_sql/drivers/rlm_sql_postgresql/rlm_sql_postgresql.c
LINK build/lib/rlm_sql_postgresql.la
CC src/modules/rlm_sql/drivers/rlm_sql_sqlite/rlm_sql_sqlite.c
LINK build/lib/rlm_sql_sqlite.la
CC src/modules/rlm_sql/drivers/rlm_sql_null/rlm_sql_null.c

I've rebuilt both postgresql93-client and freeradius from source using
FreeBSD's poudriere tool, not difference there.

Any idea where I could look further into this?

-- Mathieu

*
http://wiki.freeradius.org/guide/FAQ#It-says-%22Could-not-link-...-file-not-found%22,-what-do-I-do?