Postgresql undefined symbol PQinitSSL

[Thor Spruyt]

Hi,

I have the same problem with both 2.1.11 and 2.1.12-pre ...

I'm on CentOS 4.6 with following RPMs:

$ rpm -qa | grep devel
glibc-devel-2.3.4-2.39
krb5-devel-1.3.4-60.el4_7.2
mysql-devel-5.0.54-1.el4.centos
openssl-devel-0.9.7a-43.17.el4_8.5
kernel-smp-devel-2.6.9-67.0.4.EL
e2fsprogs-devel-1.35-12.17.el4
zlib-devel-1.2.1.2-1.2
openldap-devel-2.2.13-12.el4
kernel-devel-2.6.9-67.0.4.EL
cyrus-sasl-devel-2.1.19-14
postgresql-devel-7.4.19-1.el4_6.1

$ rpm -qa | grep postgresql
postgresql-7.4.19-1.el4_6.1
postgresql-libs-7.4.19-1.el4_6.1
postgresql-server-7.4.19-1.el4_6.1
postgresql-devel-7.4.19-1.el4_6.1

$ rpm -qa | grep openssl
openssl-devel-0.9.7a-43.17.el4_8.5
xmlsec1-openssl-1.2.6-3
openssl096b-0.9.6b-22.46
openssl-0.9.7a-43.17.el4_8.5

I use the following configure options:
./configure --prefix=/opt/freeradius-server-2.1.12 --with-mysql --with-postgresql --with-openldap --with-openssl --without-snmp --without-krb5 --without-dhcp

Everything seems to build fine, here's the postgresql module build output:
Making all in rlm_sql_postgresql.
gmake[10]: Entering directory `/home/thor/freeradius-server-2.1.12/src/modules/rlm_sql/drivers/rlm_sql_postgresql'
/home/thor/freeradius-server-2.1.12/libtool --mode=compile gcc  -g -O2 -Wall -D_GNU_SOURCE -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -DNDEBUG -I../.. -I/home/thor/freeradius-server-2.1.12/src/ -I/usr/include/postgresql -I/home/thor/freeradius-server-2.1.12/libltdl -c sql_postgresql.c
mkdir .libs
 gcc -g -O2 -Wall -D_GNU_SOURCE -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -DNDEBUG -I../.. -I/home/thor/freeradius-server-2.1.12/src/ -I/usr/include/postgresql -I/home/thor/freeradius-server-2.1.12/libltdl -c sql_postgresql.c  -fPIC -DPIC -o .libs/sql_postgresql.o
sql_postgresql.c: In function `sql_init_socket':
sql_postgresql.c:153: warning: implicit declaration of function `PQinitSSL'
 gcc -g -O2 -Wall -D_GNU_SOURCE -D_REENTRANT -D_POSIX_PTHREAD_SEMANTICS -DNDEBUG -I../.. -I/home/thor/freeradius-server-2.1.12/src/ -I/usr/include/postgresql -I/home/thor/freeradius-server-2.1.12/libltdl -c sql_postgresql.c -o sql_postgresql.o >/dev/null 2>&1
/home/thor/freeradius-server-2.1.12/libtool --mode=link gcc -release 2.1.12 \
-module -export-dynamic   -o rlm_sql_postgresql.la \
-rpath /opt/freeradius-server-2.1.12/lib sql_postgresql.lo -L/usr/lib -lpq
gcc -shared  .libs/sql_postgresql.o  -L/usr/lib -lpq  -Wl,-soname -Wl,rlm_sql_postgresql-2.1.12.so -o .libs/rlm_sql_postgresql-2.1.12.so
(cd .libs && rm -f rlm_sql_postgresql.so && ln -s rlm_sql_postgresql-2.1.12.so rlm_sql_postgresql.so)
ar cru .libs/rlm_sql_postgresql.a  sql_postgresql.o
ranlib .libs/rlm_sql_postgresql.a
creating rlm_sql_postgresql.la
(cd .libs && rm -f rlm_sql_postgresql.la && ln -s ../rlm_sql_postgresql.la rlm_sql_postgresql.la)
gmake[10]: Leaving directory `/home/thor/freeradius-server-2.1.12/src/modules/rlm_sql/drivers/rlm_sql_postgresql'

But then when starting the server with -X with my configuration, I get the following and it stops:
rlm_sql Creating new attribute sql_auth1-SQL-Group
rlm_sql (sql_auth1): Driver rlm_sql_postgresql (module rlm_sql_postgresql) loaded and linked
rlm_sql (sql_auth1): Attempting to connect to radius at 195.130.158.155:/radius
rlm_sql (sql_auth1): starting 0
rlm_sql (sql_auth1): Attempting to connect rlm_sql_postgresql #0
/opt/radproxyin/freeradius/sbin/radiusd: symbol lookup error: /opt/freeradius-server-2.1.12/lib/rlm_sql_postgresql-2.1.12.so: undefined symbol: PQinitSSL


Any ideas on what could be the problem here or any solution or tips on where to look further?
P.S.: I'm not looking to get SSL working for my database connections, I just want to get the server running with postgresql and eap support built in.

Regards,
Thor