1 Aug
2012
1 Aug
'12
6:33 p.m.
The same trouble with:
completely updated Centos 5
the last Kamailio RPM from
http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_…
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
1 Aug
1 Aug
11 p.m.
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_…
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:
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
2 Aug
2 Aug
3:33 a.m.
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_…
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
10:10 a.m.
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:
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw
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:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users The same trouble with:
completely updated Centos 5
the last Kamailio RPM from
http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_…
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
3 Aug
3 Aug
6:42 a.m.
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:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users The same trouble with:
completely updated Centos 5
the last Kamailio RPM from
http://download.opensuse.org/repositories/home:/kamailio:/telephony/RedHat_…
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
11:51 a.m.
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
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Seattle, USA, Sep 23-26, 2012 - http://asipto.com/u/katu
Kamailio Practical Workshop, Netherlands, Sep 10-12, 2012 - http://asipto.com/u/kpw
9 Aug
9 Aug
6:42 a.m.
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
2 Aug
2 Aug
12:10 p.m.
[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_…
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
12:40 p.m.
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_…
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
4490
days inactive
4498
days old
8 comments
4 participants
participants (4)
-
Akan -
Andrew O. Zhukov -
Daniel-Constantin Mierla -
Nathaniel L Keeling