The same trouble with: completely updated Centos 5 the last Kamailio RPM from http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_R... and postgresql-libs.x86_64.8.1.23-5.el5_8
several month ago I try postgresql84-libs.x86_64 with the same result.
It's not possible to use Kamailio RPM with postgres backend. Need to assemble it manually.
Bruno Bresciani wrote:
Hi,
I configure the Kamailio 3.1.2 with postgres but I cann't start. In the log file is generated the following error:
//
ERROR: load_module: could not open module </home2/local/kamailio/lib/kamailio/modules/db_ postgres.so>: /home2/local/kamailio/lib/kamailio/modules/db_postgres.so: undefined symbol: PQdescribePrepared
Have you built Kamailio yourself? Looks like db_postgres.so can not find the postgresql libraries, or it was built with a different library version.
Maybe ldd can give you some details:
ldd /home2/local/kamailio/lib/kamailio/modules/db_postgres.so
regards Klaus
Hello,
can you paste here the output of following command executed in the db_postgres module directory:
make Q=0
First run 'make proper' in the same directory. I want to see the compile flags and linked libs used for your system.
Cheers, Daniel
On 8/1/12 5:33 PM, Andrew O. Zhukov wrote:
The same trouble with: completely updated Centos 5 the last Kamailio RPM from http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_R...
and postgresql-libs.x86_64.8.1.23-5.el5_8
several month ago I try postgresql84-libs.x86_64 with the same result.
It's not possible to use Kamailio RPM with postgres backend. Need to assemble it manually.
Bruno Bresciani wrote:
Hi,
I configure the Kamailio 3.1.2 with postgres but I cann't start. In the log file is generated the following error:
//
ERROR: load_module: could not open module </home2/local/kamailio/lib/kamailio/modules/db_ postgres.so>:
/home2/local/kamailio/lib/kamailio/modules/db_postgres.so:
undefined symbol: PQdescribePrepared
Have you built Kamailio yourself? Looks like db_postgres.so can not find the postgresql libraries, or it was built with a different library version.
Maybe ldd can give you some details:
ldd /home2/local/kamailio/lib/kamailio/modules/db_postgres.so
regards Klaus
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
I had to upgrade to the lastest version of Postgres to get past this error but then ran into the problem of "undefined symbol TLSv1_method"
Thanks
Nathaniel On 8/1/2012 3:00 PM, Daniel-Constantin Mierla wrote:
Hello,
can you paste here the output of following command executed in the db_postgres module directory:
make Q=0
First run 'make proper' in the same directory. I want to see the compile flags and linked libs used for your system.
Cheers, Daniel
On 8/1/12 5:33 PM, Andrew O. Zhukov wrote:
The same trouble with: completely updated Centos 5 the last Kamailio RPM from http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_R...
and postgresql-libs.x86_64.8.1.23-5.el5_8
several month ago I try postgresql84-libs.x86_64 with the same result.
It's not possible to use Kamailio RPM with postgres backend. Need to assemble it manually.
Bruno Bresciani wrote:
Hi,
I configure the Kamailio 3.1.2 with postgres but I cann't start. In
the
log file is generated the following error:
//
ERROR: load_module: could not open module </home2/local/kamailio/lib/kamailio/modules/db_ postgres.so>:
/home2/local/kamailio/lib/kamailio/modules/db_postgres.so:
undefined symbol: PQdescribePrepared
Have you built Kamailio yourself? Looks like db_postgres.so can not find the postgresql libraries, or it was built with a different library version.
Maybe ldd can give you some details:
ldd /home2/local/kamailio/lib/kamailio/modules/db_postgres.so
regards Klaus
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
TLSV1_method is not used inside db_postgres, so it is a dependency of pg library. Do you have the tool pg_config installed in your system?
Cheers, Daniel
On 8/2/12 2:33 AM, Akan wrote:
I had to upgrade to the lastest version of Postgres to get past this error but then ran into the problem of "undefined symbol TLSv1_method"
Thanks
Nathaniel On 8/1/2012 3:00 PM, Daniel-Constantin Mierla wrote:
Hello,
can you paste here the output of following command executed in the db_postgres module directory:
make Q=0
First run 'make proper' in the same directory. I want to see the compile flags and linked libs used for your system.
Cheers, Daniel
On 8/1/12 5:33 PM, Andrew O. Zhukov wrote:
The same trouble with: completely updated Centos 5 the last Kamailio RPM from http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_R...
and postgresql-libs.x86_64.8.1.23-5.el5_8
several month ago I try postgresql84-libs.x86_64 with the same result.
It's not possible to use Kamailio RPM with postgres backend. Need to assemble it manually.
Bruno Bresciani wrote:
Hi,
I configure the Kamailio 3.1.2 with postgres but I cann't start.
In the
log file is generated the following error:
//
ERROR: load_module: could not open module </home2/local/kamailio/lib/kamailio/modules/db_ postgres.so>:
/home2/local/kamailio/lib/kamailio/modules/db_postgres.so:
undefined symbol: PQdescribePrepared
Have you built Kamailio yourself? Looks like db_postgres.so can not find the postgresql libraries, or it was built with a different library version.
Maybe ldd can give you some details:
ldd /home2/local/kamailio/lib/kamailio/modules/db_postgres.so
regards Klaus
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Yes but it was for an older version that was uninstalled. I changed the path to pull in the current version and still received the same error. I checked the version for openssl and the same thing was happening. I changed the path again and recompiled kamailio and still no change. I noticed when compiling kamailio, the tls.so module was complaining that the version of openssl was less then 1.0. The version that I installed is 1.0.1c.
Thanks
Nathaniel
On 8/2/2012 2:10 AM, Daniel-Constantin Mierla wrote:
TLSV1_method is not used inside db_postgres, so it is a dependency of pg library. Do you have the tool pg_config installed in your system?
Cheers, Daniel
On 8/2/12 2:33 AM, Akan wrote:
I had to upgrade to the lastest version of Postgres to get past this error but then ran into the problem of "undefined symbol TLSv1_method"
Thanks
Nathaniel On 8/1/2012 3:00 PM, Daniel-Constantin Mierla wrote:
Hello,
can you paste here the output of following command executed in the db_postgres module directory:
make Q=0
First run 'make proper' in the same directory. I want to see the compile flags and linked libs used for your system.
Cheers, Daniel
On 8/1/12 5:33 PM, Andrew O. Zhukov wrote:
The same trouble with: completely updated Centos 5 the last Kamailio RPM from http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_R...
and postgresql-libs.x86_64.8.1.23-5.el5_8
several month ago I try postgresql84-libs.x86_64 with the same result.
It's not possible to use Kamailio RPM with postgres backend. Need to assemble it manually.
Bruno Bresciani wrote:
Hi,
I configure the Kamailio 3.1.2 with postgres but I cann't start.
In the
log file is generated the following error:
//
ERROR: load_module: could not open module </home2/local/kamailio/lib/kamailio/modules/db_ postgres.so>:
/home2/local/kamailio/lib/kamailio/modules/db_postgres.so:
undefined symbol: PQdescribePrepared
Have you built Kamailio yourself? Looks like db_postgres.so can not find the postgresql libraries, or it was built with a different library version.
Maybe ldd can give you some details:
ldd /home2/local/kamailio/lib/kamailio/modules/db_postgres.so
regards Klaus
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Hello,
On 8/3/12 5:42 AM, Nathaniel L Keeling wrote:
Yes but it was for an older version that was uninstalled. I changed the path to pull in the current version and still received the same error. I checked the version for openssl and the same thing was happening. I changed the path again and recompiled kamailio and still no change. I noticed when compiling kamailio, the tls.so module was complaining that the version of openssl was less then 1.0. The version that I installed is 1.0.1c.
openssl libs can be installed with many versions at the same time, as the package names differ -- so 0.9x and 1.x can exist installed at the same time. Double check you don't have both installed, as some applications out there require 0.9, others 1.0, they could get installed due to dependencies.
It may happen that opensuse build service used a specific openssl version when building the rpms -- the rpm spec requires generic packages openssl and openssl-devel for building.
What is the version of your OS?
Cheers, Daniel
I am running Centos v5.5 and both openssl versions 0.9 and 1.0 are installed. I tried to uninstall version 0.9 but there were over 400 packages that were dependent upon that version.
Thanks
Nathaniel
On 8/3/2012 3:51 AM, Daniel-Constantin Mierla wrote:
Hello,
On 8/3/12 5:42 AM, Nathaniel L Keeling wrote:
Yes but it was for an older version that was uninstalled. I changed the path to pull in the current version and still received the same error. I checked the version for openssl and the same thing was happening. I changed the path again and recompiled kamailio and still no change. I noticed when compiling kamailio, the tls.so module was complaining that the version of openssl was less then 1.0. The version that I installed is 1.0.1c.
openssl libs can be installed with many versions at the same time, as the package names differ -- so 0.9x and 1.x can exist installed at the same time. Double check you don't have both installed, as some applications out there require 0.9, others 1.0, they could get installed due to dependencies.
It may happen that opensuse build service used a specific openssl version when building the rpms -- the rpm spec requires generic packages openssl and openssl-devel for building.
What is the version of your OS?
Cheers, Daniel
[root@new db_postgres]# make Q=0 config.mak included config.mak included gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c km_dbase.c -o km_dbase.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c km_db_postgres.c -o km_db_postgres.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c km_pg_con.c -o km_pg_con.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c km_res.c -o km_res.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c km_val.c -o km_val.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_cmd.c -o pg_cmd.o -MMD -MP pg_cmd.c: In function ‘get_types’: pg_cmd.c:206: warning: implicit declaration of function ‘PQdescribePrepared’ pg_cmd.c:206: warning: assignment makes pointer from integer without a cast pg_cmd.c: In function ‘pg_cmd_exec’: pg_cmd.c:449: warning: assignment makes pointer from integer without a cast gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_con.c -o pg_con.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_fld.c -o pg_fld.o -MMD -MP pg_fld.c: In function ‘pg_resolve_param_oids’: pg_fld.c:466: warning: implicit declaration of function ‘PQnparams’ pg_fld.c:473: warning: implicit declaration of function ‘PQparamtype’ gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_mod.c -o pg_mod.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_oid.c -o pg_oid.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_res.c -o pg_res.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_sql.c -o pg_sql.o -MMD -MP gcc -fPIC -DPIC -g -O9 -funroll-loops -Wcast-align -m64 -minline-all-stringops -falign-loops -ftree-vectorize -mtune=opteron -Wall -DNAME='"kamailio"' -DVERSION='"3.3.0"' -DARCH='"x86_64"' -DOS='linux_' -DOS_QUOTED='"linux"' -DCOMPILER='"gcc 4.1.2"' -D__CPU_x86_64 -D__OS_linux -DSER_VER=3003000 -DCFG_DIR='"/usr/local/etc/kamailio/"' -DPKG_MALLOC -DSHM_MEM -DSHM_MMAP -DDNS_IP_HACK -DUSE_IPV6 -DUSE_MCAST -DUSE_TCP -DDISABLE_NAGLE -DHAVE_RESOLV_RES -DUSE_DNS_CACHE -DUSE_DNS_FAILOVER -DUSE_DST_BLACKLIST -DUSE_NAPTR -DWITH_XAVP -DF_MALLOC -DMEM_JOIN_FREE -DUSE_TLS -DTLS_HOOKS -DUSE_CORE_STATS -DSTATISTICS -DMALLOC_STATS -DWITH_AS_SUPPORT -DFAST_LOCK -DADAPTIVE_WAIT -DADAPTIVE_WAIT_LOOPS=1024 -DCC_GCC_LIKE_ASM -DHAVE_GETHOSTBYNAME2 -DHAVE_UNION_SEMUN -DHAVE_SCHED_YIELD -DHAVE_MSG_NOSIGNAL -DHAVE_MSGHDR_MSG_CONTROL -DHAVE_ALLOCA_H -DHAVE_TIMEGM -DHAVE_SCHED_SETSCHEDULER -DUSE_RAW_SOCKS -DHAVE_EPOLL -DHAVE_SIGIO_RT -DSIGINFO64_WORKARROUND -DUSE_FUTEX -DHAVE_SELECT -I/usr/include -DSER_MOD_INTERFACE -DMOD_NAME='"db_postgres"' -c pg_uri.c -o pg_uri.o -MMD -MP Makefile.defs defs skipped make[1]: Entering directory `/root/kamailio-3.3.0/lib/srdb2' make[1]: `libsrdb2.so.1.0' is up to date. make[1]: Leaving directory `/root/kamailio-3.3.0/lib/srdb2' Makefile.defs defs skipped make[1]: Entering directory `/root/kamailio-3.3.0/lib/srdb1' make[1]: `libsrdb1.so.1.0' is up to date. make[1]: Leaving directory `/root/kamailio-3.3.0/lib/srdb1' gcc -shared -m64 -Wl,-O2 -Wl,-E km_dbase.o km_db_postgres.o km_pg_con.o km_res.o km_val.o pg_cmd.o pg_con.o pg_fld.o pg_mod.o pg_oid.o pg_res.o pg_sql.o pg_uri.o -L/usr/lib64 -lpq -L../../lib/srdb2/ -lsrdb2 -L../../lib/srdb1/ -lsrdb1 -Wl,-rpath,/root/kamailio-3.3.0/lib/srdb2 -Wl,-rpath,/root/kamailio-3.3.0/lib/srdb1 -o db_postgres.so
01.08.2012 23:00, Daniel-Constantin Mierla пишет:
Hello,
can you paste here the output of following command executed in the db_postgres module directory:
make Q=0
First run 'make proper' in the same directory. I want to see the compile flags and linked libs used for your system.
Cheers, Daniel
On 8/1/12 5:33 PM, Andrew O. Zhukov wrote:
The same trouble with: completely updated Centos 5 the last Kamailio RPM from http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_R...
and postgresql-libs.x86_64.8.1.23-5.el5_8
several month ago I try postgresql84-libs.x86_64 with the same result.
It's not possible to use Kamailio RPM with postgres backend. Need to assemble it manually.
Bruno Bresciani wrote:
Hi,
I configure the Kamailio 3.1.2 with postgres but I cann't start. In the log file is generated the following error:
//
ERROR: load_module: could not open module </home2/local/kamailio/lib/kamailio/modules/db_ postgres.so>:
/home2/local/kamailio/lib/kamailio/modules/db_postgres.so:
undefined symbol: PQdescribePrepared
Have you built Kamailio yourself? Looks like db_postgres.so can not find the postgresql libraries, or it was built with a different library version.
Maybe ldd can give you some details:
ldd /home2/local/kamailio/lib/kamailio/modules/db_postgres.so
regards Klaus
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Daniel,
I remove RPM-s
postgresql postgresql-devel postgresql-libs kamailio-postgres
install
postgresql84 postgresql84-devel postgresql84-libs
and assemble
db_postgres using make Q=0
in db_postgres directory.
then put db_postgres.so to /usr/lib64/kamailio/modules directory.
Currently I's only one way to fix it.
Yum rpm installation whant postgresql-libs depedency rpmbuild from src rpm whant postgresql-devel depedency
Thanks.
01.08.2012 23:00, Daniel-Constantin Mierla пишет:
Hello,
can you paste here the output of following command executed in the db_postgres module directory:
make Q=0
First run 'make proper' in the same directory. I want to see the compile flags and linked libs used for your system.
Cheers, Daniel
On 8/1/12 5:33 PM, Andrew O. Zhukov wrote:
The same trouble with: completely updated Centos 5 the last Kamailio RPM from http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_R...
and postgresql-libs.x86_64.8.1.23-5.el5_8
several month ago I try postgresql84-libs.x86_64 with the same result.
It's not possible to use Kamailio RPM with postgres backend. Need to assemble it manually.
Bruno Bresciani wrote:
Hi,
I configure the Kamailio 3.1.2 with postgres but I cann't start. In the log file is generated the following error:
//
ERROR: load_module: could not open module </home2/local/kamailio/lib/kamailio/modules/db_ postgres.so>:
/home2/local/kamailio/lib/kamailio/modules/db_postgres.so:
undefined symbol: PQdescribePrepared
Have you built Kamailio yourself? Looks like db_postgres.so can not find the postgresql libraries, or it was built with a different library version.
Maybe ldd can give you some details:
ldd /home2/local/kamailio/lib/kamailio/modules/db_postgres.so
regards Klaus
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Akan -
Andrew O. Zhukov -
Daniel-Constantin Mierla -
Nathaniel L Keeling