[SR-Users] postgres in kamailio 3.3.0-9.1

[Andrew O. Zhukov]

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_RHEL-5/
>>
>> 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 at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>