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@Freeswitch-C57 opensips]# [root@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@Freeswitch-C57 opensips]# Thanks, Jerry From: Jerry Richards Sent: Tuesday, December 06, 2011 8:52 AM To: [email protected] 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
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
