Postgresql undefined symbol PQinitSSL
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@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
Thor Spruyt wrote:
Any ideas on what could be the problem here or any solution or tips on where to look further?
FreeRADIUS is built with Postgresql && SSL. So it assumes that Postgresql can do SSL, too. The simple fix is to go to the sql_postgresql.c file, and delete the code which refers to PQinitSSL A longer term fix is to update the "configure" script to look for PQinitSSL. Alan DeKok.
Hi Alan, Yes, I removed the code and then it runs ;-) Thanks, Thor. ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Wednesday, September 28, 2011 3:28:14 PM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna Subject: Re: Postgresql undefined symbol PQinitSSL Thor Spruyt wrote:
Any ideas on what could be the problem here or any solution or tips on where to look further?
FreeRADIUS is built with Postgresql && SSL. So it assumes that Postgresql can do SSL, too. The simple fix is to go to the sql_postgresql.c file, and delete the code which refers to PQinitSSL A longer term fix is to update the "configure" script to look for PQinitSSL. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Thor Spruyt