<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 08.00.0681.000">
<TITLE>Build errors with --enable-core-pgsql-support</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Latest git pull of v1.2 stable on CentOS 6.5. I’m getting the following errors during make:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c: In function âswitch_pgsql_next_result_timedâ:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:389: error: âPGRES_SINGLE_TUPLEâ undeclared (first use in this function)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:389: error: (Each undeclared identifier is reported only once</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:389: error: for each function it appears in.)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:400: error: âPGRES_COPY_BOTHâ undeclared (first use in this function)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c: In function âswitch_pgsql_handle_exec_string_detailedâ:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:531: error: âPGRES_SINGLE_TUPLEâ undeclared (first use in this function)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">make[1]: *** [libfreeswitch_la-switch_pgsql.lo] Error 1</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">make: *** [all] Error 2</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Speaking with a few folks on irc gave me the impression that postgres support for FS isn’t quite ready for prime time on CentOS, but I wanted to see if there was something obvious that I was missing.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">The following relevant packages are installed:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql92-9.2.8-1PGDG.rhel6.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql-8.4.20-1.el6_5.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql92-odbc-09.02.0100-1PGDG.rhel6.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql-libs-8.4.20-1.el6_5.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql92-libs-9.2.8-1PGDG.rhel6.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql92-server-9.2.8-1PGDG.rhel6.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql-odbc-08.04.0200-1.el6.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql-devel-8.4.20-1.el6_5.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">postgresql92-devel-9.2.8-1PGDG.rhel6.x86_64</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">pgdg-centos92-9.2-6.noarch</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">PATH includes /usr/pgsql-9.2</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">,</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">/usr/pgsql-9.2/</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">bin</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">,</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">/usr/pgsql-9.2/</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">lib</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">,</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">/usr/pgsql-9.2/</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">include</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">,</FONT></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-us"> <FONT FACE="Calibri">and PKG_CONFIG_PATH is /usr/local/lib/pkgconfig which contains libpq.pc.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Attempting the configure with LDFLAGS:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">./configure --enable-zrtp --enable-core-pgsql-support LDFLAGS="-L/usr/pgsql-9.2/lib" CPPFLAGS="-I/usr/pgsql-9.2/include"</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">still generates the following errors:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c: In function âswitch_pgsql_next_result_timedâ:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:391: error: stray â#â in program</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:391: error: âiâ undeclared (first use in this function)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:391: error: (Each undeclared identifier is reported only once</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:391: error: for each function it appears in.)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:391: error: expected â;â before âendifâ</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">cc1: warnings being treated as errors</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:387: error: enumeration value âPGRES_TUPLES_OKâ not handled in switch</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">src/switch_pgsql.c:288:1: error: unterminated #ifdef</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">make[1]: *** [libfreeswitch_la-switch_pgsql.lo] Error 1</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">make: *** [all] Error 2</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Is this issue readily resolvable on this platform or are those of us running RHEL/CentOS mostly out of luck?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">I would be happy to file a Jira on this if it will help.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Thanks,</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">- Phil</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN></P>
</BODY>
</HTML>