<div dir="ltr"><div><div><div>Hello,<br><br></div>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.<br><br></div>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.<br><br></div>Untill then i think i should not post it as bug right?<br><div><br><br><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 18, 2015 at 6:09 PM, Liviu Chircu <span dir="ltr"><<a href="mailto:liviu@opensips.org" target="_blank">liviu@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<tt>Hi John,<br>
<br>
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:<br>
"locate libpq-fe.h"<br>
<br>
<br>
Here is a db_postgres build on Red Hat 6.4:<br>
<br>
<br>
[root@VM-BUILD opensips_dev]# lsb_release -a<br>
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<br>
Distributor ID:RedHatEnterpriseServer<br>
Description:Red Hat Enterprise Linux Server release 6.4 (Santiago)<br>
Release:6.4<br>
Codename:Santiago<br>
[root@VM-BUILD opensips_dev]# make modules
modules=modules/db_postgres<br>
<br>
<br>
make[1]: Entering directory
`/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'<br>
make[1]: Leaving directory
`/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'<br>
make[1]: Entering directory
`/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'
<br>
Compiling dbase.c<br>
Compiling db_postgres.c<span class=""><br>
Compiling pg_con.c<br>
Compiling res.c<br>
Compiling val.c<br></span>
Linking db_postgres.so<br>
make[1]: Leaving directory
`/usr/local/src/rpm/opensips/SOURCES/opensips_dev/modules/db_postgres'<br>
[root@VM-BUILD opensips_dev]# locate libpq-fe.h<br>
/usr/include/libpq-fe.h<br>
[root@VM-BUILD opensips_dev]# yum list installed | grep postgre<br>
postgresql.x86_64 8.4.20-2.el6_6
@rhel-6-server-rpms <br>
postgresql-devel.x86_64 8.4.20-2.el6_6
@rhel-6-server-rpms <br>
postgresql-libs.x86_64 8.4.20-2.el6_6
@rhel-6-server-rpms<br>
<br>
<br>
Best regards,<br>
</tt>
<pre cols="72">Liviu Chircu
OpenSIPS Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre><div><div class="h5">
<div>On 16.06.2015 12:49, John Nash wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>
<div>When I try to build the latest 2.1 git version with
postgresql module I get errors..<br>
make include_modules="rtpengine db_postgres" modules<br>
<br>
<br>
make[1]: Entering directory
`/usr/src/bridgeswitch/Switch2.0/opensips_2_1/modules/db_postgres'<br>
Compiling dbase.c<br>
Compiling pg_con.c<br>
Compiling res.c<br>
Compiling val.c<br>
In file included from pg_con.c:22:<br>
pg_con.h:39:22: error: libpq-fe.h: No such file or directory<br>
In file included from pg_con.c:22:<br>
pg_con.h:54: error: expected specifier-qualifier-list before
âPGconnâ<br>
pg_con.c: In function âdb_postgres_new_connectionâ:<br>
pg_con.c:67: error: âstruct pg_conâ has no member named
âconâ<br>
--<br>
<br>
</div>
I have postgresql 9. and have following libraries installed<br>
postgresql92-devel.x86_64<br>
postgresql92-libs.x86_64 <br>
<br>
</div>
Please confirm if its a bug I will open a ticket.<br>
<div><br>
<div><br>
<br>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
Devel mailing list
<a href="mailto:Devel@lists.opensips.org" target="_blank">Devel@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a>
</pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
Devel mailing list<br>
<a href="mailto:Devel@lists.opensips.org">Devel@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a><br>
<br></blockquote></div><br></div>