[Freeswitch-users] Build errors with --enable-core-pgsql-support

[Phil Quesinberry]

Latest git pull of v1.2 stable on CentOS 6.5.  I’m getting the following
errors during make:
src/switch_pgsql.c: In function âswitch_pgsql_next_result_timedâ:
src/switch_pgsql.c:389: error: âPGRES_SINGLE_TUPLEâ undeclared (first use in
this function)
src/switch_pgsql.c:389: error: (Each undeclared identifier is reported only
once
src/switch_pgsql.c:389: error: for each function it appears in.)
src/switch_pgsql.c:400: error: âPGRES_COPY_BOTHâ undeclared (first use in
this function)
src/switch_pgsql.c: In function âswitch_pgsql_handle_exec_string_detailedâ:
src/switch_pgsql.c:531: error: âPGRES_SINGLE_TUPLEâ undeclared (first use in
this function)
make[1]: *** [libfreeswitch_la-switch_pgsql.lo] Error 1
make: *** [all] Error 2

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.

The following relevant packages are installed:
postgresql92-9.2.8-1PGDG.rhel6.x86_64
postgresql-8.4.20-1.el6_5.x86_64
postgresql92-odbc-09.02.0100-1PGDG.rhel6.x86_64
postgresql-libs-8.4.20-1.el6_5.x86_64
postgresql92-libs-9.2.8-1PGDG.rhel6.x86_64
postgresql92-server-9.2.8-1PGDG.rhel6.x86_64
postgresql-odbc-08.04.0200-1.el6.x86_64
postgresql-devel-8.4.20-1.el6_5.x86_64
postgresql92-devel-9.2.8-1PGDG.rhel6.x86_64
pgdg-centos92-9.2-6.noarch

PATH includes /usr/pgsql-9.2, /usr/pgsql-9.2/bin, /usr/pgsql-9.2/lib,
/usr/pgsql-9.2/include, and PKG_CONFIG_PATH is /usr/local/lib/pkgconfig
which contains libpq.pc.

Attempting the configure with LDFLAGS:
./configure --enable-zrtp --enable-core-pgsql-support
LDFLAGS="-L/usr/pgsql-9.2/lib" CPPFLAGS="-I/usr/pgsql-9.2/include"

still generates the following errors:

src/switch_pgsql.c: In function âswitch_pgsql_next_result_timedâ:
src/switch_pgsql.c:391: error: stray â#â in program
src/switch_pgsql.c:391: error: âiâ undeclared (first use in this function)
src/switch_pgsql.c:391: error: (Each undeclared identifier is reported only
once
src/switch_pgsql.c:391: error: for each function it appears in.)
src/switch_pgsql.c:391: error: expected â;â before âendifâ
cc1: warnings being treated as errors
src/switch_pgsql.c:387: error: enumeration value âPGRES_TUPLES_OKâ not
handled in switch
src/switch_pgsql.c:288:1: error: unterminated #ifdef
make[1]: *** [libfreeswitch_la-switch_pgsql.lo] Error 1
make: *** [all] Error 2

Is this issue readily resolvable on this platform or are those of us running
RHEL/CentOS mostly out of luck?

I would be happy to file a Jira on this if it will help.

Thanks,

- Phil
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140425/07efd119/attachment.html