[OpenSIPS-Devel] Opensips 2.1 build error -- postgresql module

[John Nash]

Kindly ignore. It was pg_config issue. It was not added in path for
postgresql 9.2

On Thu, Jun 18, 2015 at 7:25 PM, John Nash <john.nash778 at gmail.com> wrote:

> Hello,
>
> Sorry I was held up in some other issues. After posting this I checked
> Makefile to see why it is unable to find pqlib headers. In my system all
> postgres files are in /usr/pgsql-9.2/ including
> /usr/pgsql-9.2/bin/pg_config but Makefile did not find the path, I then
> added the path in makefile where it tries to check header files and lib
> files and built successfully.
>
> Ideally it should take from pg_config but not sure why it did not. I will
> try to put some prints in makefile to see whats going on and update.
>
> Untill then i think i should not post it as bug right?
>
>
>
>
> On Thu, Jun 18, 2015 at 6:09 PM, Liviu Chircu <liviu at opensips.org> wrote:
>
>>  Hi John,
>>
>> Are you, by any chance, missing the "pg_config" binary usually provided
>> by "postgresql-devel"? If so, could you post the output of following
>> command:
>> "locate libpq-fe.h"
>>
>>
>> Here is a db_postgres build on Red Hat 6.4:
>>
>>
>> [root at VM-BUILD opensips_dev]# lsb_release -a
>> LSB
>> Version::base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
>> Distributor ID:RedHatEnterpriseServer
>> Description:Red Hat Enterprise Linux Server release 6.4 (Santiago)
>> Release:6.4
>> Codename:Santiago
>> [root at VM-BUILD opensips_dev]# make modules modules=modules/db_postgres
>>
>>
>> make[1]: Entering directory
>> `/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'
>> make[1]: Leaving directory
>> `/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'
>> make[1]: Entering directory
>> `/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'
>>
>> Compiling dbase.c
>> Compiling db_postgres.c
>> Compiling pg_con.c
>> Compiling res.c
>> Compiling val.c
>> Linking db_postgres.so
>> make[1]: Leaving directory
>> `/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'
>> [root at VM-BUILD opensips_dev]# locate libpq-fe.h
>> /usr/include/libpq-fe.h
>> [root at VM-BUILD opensips_dev]# yum list installed | grep postgre
>> postgresql.x86_64                  8.4.20-2.el6_6
>> @rhel-6-server-rpms
>> postgresql-devel.x86_64            8.4.20-2.el6_6
>> @rhel-6-server-rpms
>> postgresql-libs.x86_64             8.4.20-2.el6_6
>> @rhel-6-server-rpms
>>
>>
>> Best regards,
>>
>> Liviu Chircu
>> OpenSIPS Developerhttp://www.opensips-solutions.com
>>
>> On 16.06.2015 12:49, John Nash wrote:
>>
>>  When I try to build the latest 2.1 git version with postgresql module I
>> get errors..
>>  make include_modules="rtpengine db_postgres" modules
>>
>>
>> make[1]: Entering directory
>> `/usr/src/bridgeswitch/Switch2.0/opensips_2_1/modules/db_postgres'
>> Compiling dbase.c
>> Compiling pg_con.c
>> Compiling res.c
>> Compiling val.c
>> In file included from pg_con.c:22:
>> pg_con.h:39:22: error: libpq-fe.h: No such file or directory
>> In file included from pg_con.c:22:
>> pg_con.h:54: error: expected specifier-qualifier-list before âPGconnâ
>> pg_con.c: In function âdb_postgres_new_connectionâ:
>> pg_con.c:67: error: âstruct pg_conâ has no member named âconâ
>> --
>>
>>  I have postgresql 9. and have following libraries installed
>> postgresql92-devel.x86_64
>> postgresql92-libs.x86_64
>>
>>  Please confirm if its a bug I will open a ticket.
>>
>>
>>
>>
>>
>> _______________________________________________
>> Devel mailing listDevel at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/devel
>>
>>
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/devel/attachments/20150623/0fd29b40/attachment.htm>