[OpenSIPS-Users] Is OpenSIPS Compatible with PostgreSQL 9.1?

[Jerry Richards]

Hello,

I'm wondering if OpenSIPS is compatible with PostgreSQL 9.1, because I'm getting the following compilation errors running on CentOS 5.7.

[root at Freeswitch-C57 opensips]#
[root at Freeswitch-C57 opensips]# make prefix=/opt/opensips all include_modules="db_postgres presence presence_xml presence_mwi presence_dialoginfo"
which: no lynx in (/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)


make[1]: Entering directory `/home/TeoUser/work/opensips/jt/opensips/modules/db_postgres'
Compiling dbase.c
In file included from dbase.c:77:
pg_con.h:41:22: error: libpq-fe.h: No such file or directory
In file included from dbase.c:77:
pg_con.h:53: error: expected specifier-qualifier-list before 'PGconn'
dbase.c: In function 'db_postgres_submit_query':
dbase.c:139: error: 'ExecStatusType' undeclared (first use in this function)
dbase.c:139: error: (Each undeclared identifier is reported only once
dbase.c:139: error: for each function it appears in.)
dbase.c:139: error: expected ';' before 'result'
dbase.c:140: error: 'PGresult' undeclared (first use in this function)
dbase.c:140: error: 'res' undeclared (first use in this function)
dbase.c:151: warning: implicit declaration of function 'PQstatus'
dbase.c:151: error: 'struct pg_con' has no member named 'con'
dbase.c:153: error: 'CONNECTION_OK' undeclared (first use in this function)
dbase.c:155: error: 'CONNECTION_BAD' undeclared (first use in this function)
dbase.c:157: warning: implicit declaration of function 'PQreset'
dbase.c:157: error: 'struct pg_con' has no member named 'con'
dbase.c:159: error: 'CONNECTION_STARTED' undeclared (first use in this function)
dbase.c:160: error: 'CONNECTION_MADE' undeclared (first use in this function)
dbase.c:161: error: 'CONNECTION_AWAITING_RESPONSE' undeclared (first use in this function)
dbase.c:162: error: 'CONNECTION_AUTH_OK' undeclared (first use in this function)
dbase.c:163: error: 'CONNECTION_SETENV' undeclared (first use in this function)
dbase.c:164: error: 'CONNECTION_SSL_STARTUP' undeclared (first use in this function)
dbase.c:165: error: 'CONNECTION_NEEDED' undeclared (first use in this function)
dbase.c:167: warning: implicit declaration of function 'PQerrorMessage'
dbase.c:167: error: 'struct pg_con' has no member named 'con'
dbase.c:167: error: 'struct pg_con' has no member named 'con'
dbase.c:167: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:174: error: 'struct pg_con' has no member named 'res'
dbase.c:179: warning: implicit declaration of function 'PQsendQuery'
dbase.c:179: error: 'struct pg_con' has no member named 'con'
dbase.c:183: warning: implicit declaration of function 'PQgetResult'
dbase.c:183: error: 'struct pg_con' has no member named 'con'
dbase.c:184: error: 'struct pg_con' has no member named 'res'
dbase.c:190: error: 'result' undeclared (first use in this function)
dbase.c:190: warning: implicit declaration of function 'PQresultStatus'
dbase.c:190: error: 'struct pg_con' has no member named 'res'
dbase.c:191: error: 'PGRES_FATAL_ERROR' undeclared (first use in this function)
dbase.c:197: error: 'struct pg_con' has no member named 'con'
dbase.c:197: error: 'struct pg_con' has no member named 'con'
dbase.c:197: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:199: error: 'struct pg_con' has no member named 'con'
dbase.c:201: error: 'struct pg_con' has no member named 'con'
dbase.c:204: error: 'struct pg_con' has no member named 'res'
dbase.c:212: error: 'struct pg_con' has no member named 'con'
dbase.c:212: error: 'struct pg_con' has no member named 'con'
dbase.c:212: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c: In function 'db_postgres_fetch_result':
dbase.c:225: error: 'ExecStatusType' undeclared (first use in this function)
dbase.c:225: error: expected ';' before 'pqresult'
dbase.c:245: error: 'pqresult' undeclared (first use in this function)
dbase.c:245: error: 'struct pg_con' has no member named 'res'
dbase.c:246: warning: implicit declaration of function 'PQresStatus'
dbase.c:246: error: 'struct pg_con' has no member named 'res'
dbase.c:246: error: 'struct pg_con' has no member named 'res'
dbase.c:246: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:250: error: 'PGRES_COMMAND_OK' undeclared (first use in this function)
dbase.c:255: error: 'PGRES_TUPLES_OK' undeclared (first use in this function)
dbase.c:264: error: 'PGRES_FATAL_ERROR' undeclared (first use in this function)
dbase.c:266: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:267: warning: implicit declaration of function 'PQresultErrorMessage'
dbase.c:267: error: 'struct pg_con' has no member named 'res'
dbase.c:267: error: 'struct pg_con' has no member named 'res'
dbase.c:267: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:273: error: 'PGRES_EMPTY_QUERY' undeclared (first use in this function)
dbase.c:275: error: 'PGRES_NONFATAL_ERROR' undeclared (first use in this function)
dbase.c:277: error: 'PGRES_COPY_OUT' undeclared (first use in this function)
dbase.c:278: error: 'PGRES_COPY_IN' undeclared (first use in this function)
dbase.c:280: error: 'PGRES_BAD_RESPONSE' undeclared (first use in this function)
dbase.c:283: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:284: error: 'struct pg_con' has no member named 'res'
dbase.c:284: error: 'struct pg_con' has no member named 'res'
dbase.c:284: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:300: warning: implicit declaration of function 'PQntuples'
dbase.c:300: error: 'struct pg_con' has no member named 'res'
dbase.c: In function 'free_query':
dbase.c:347: error: 'struct pg_con' has no member named 'res'
dbase.c:349: error: 'struct pg_con' has no member named 'res'
dbase.c:349: error: 'struct pg_con' has no member named 'res'
dbase.c:350: warning: implicit declaration of function 'PQclear'
dbase.c:350: error: 'struct pg_con' has no member named 'res'
dbase.c:351: error: 'struct pg_con' has no member named 'res'
dbase.c: In function 'db_postgres_store_result':
dbase.c:436: error: 'ExecStatusType' undeclared (first use in this function)
dbase.c:436: error: expected ';' before 'pqresult'
dbase.c:446: error: 'pqresult' undeclared (first use in this function)
dbase.c:446: error: 'struct pg_con' has no member named 'res'
dbase.c:448: error: 'struct pg_con' has no member named 'res'
dbase.c:448: error: 'struct pg_con' has no member named 'res'
dbase.c:448: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:452: error: 'PGRES_COMMAND_OK' undeclared (first use in this function)
dbase.c:458: error: 'PGRES_TUPLES_OK' undeclared (first use in this function)
dbase.c:471: error: 'PGRES_FATAL_ERROR' undeclared (first use in this function)
dbase.c:473: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:474: error: 'struct pg_con' has no member named 'res'
dbase.c:474: error: 'struct pg_con' has no member named 'res'
dbase.c:474: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:480: error: 'PGRES_EMPTY_QUERY' undeclared (first use in this function)
dbase.c:482: error: 'PGRES_NONFATAL_ERROR' undeclared (first use in this function)
dbase.c:484: error: 'PGRES_COPY_OUT' undeclared (first use in this function)
dbase.c:485: error: 'PGRES_COPY_IN' undeclared (first use in this function)
dbase.c:487: error: 'PGRES_BAD_RESPONSE' undeclared (first use in this function)
dbase.c:490: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
dbase.c:491: error: 'struct pg_con' has no member named 'res'
dbase.c:491: error: 'struct pg_con' has no member named 'res'
dbase.c:491: warning: format '%s' expects type 'char *', but argument 5 has type 'int'
make[1]: *** [dbase.o] Error 1
make[1]: Leaving directory `/home/TeoUser/work/opensips/jt/opensips/modules/db_postgres'
make: *** [modules] Error 2
[root at Freeswitch-C57 opensips]#

Thanks,
Jerry


From: Jerry Richards
Sent: Tuesday, December 06, 2011 8:52 AM
To: users at lists.opensips.org
Subject: Continually Prompted for postgres user password

Hello All,

Anyone know why I get prompted for the postgres user password endlessly when executing the command "./opensipsdbctl create"?  If I look in the database, I can see it is creating a lot of tables, but the script never ends because I am continually prompted for "Password for user postgres:".

Thanks,
Jerry

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120207/946272a3/attachment-0001.htm>