[Users] Openser + postgres not starting - sr-users

22 Mar 2007

Hi

I have installed Openser v 1.2 no tls. I have Postgres version 8.0.7.

I tried openser start

[root@openser /usr/local/lib]# openser start
ERROR: bad config file (1 errors)

[root@openser /usr/local/lib]# openser -c

 0(29611) ERROR: load_module: could not open module
</usr/local/lib/openser/modules/postgres.so>:
/usr/local/lib/openser/modules/postgres.so: Undefined symbol
"PQescapeStringConn"
 0(29611) parse error (41,13-14): failed to load module
ERROR: bad config file (1 errors)
 0(29611) INFO:mi_fifo:mi_destroy:memory for the child's mi_fifo_pid
was not allocated -> nothing to destroy

I then ran openserctl moni

cycle #1, if constant make sure server lives

My openser.cfg file

# ----------- global configuration parameters ------------------------

debug=3            # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no    # (cmd line: -E)
children=4

# Uncomment these lines to enter debugging mode
#fork=no
#log_stderror=yes
#

port=5060

# uncomment the following lines for TLS support
#disable_tls = 0
#listen = tls:your_IP:5061
#tls_verify_server = 1
#tls_verify_client = 1
#tls_require_client_certificate = 0
#tls_method = TLSv1
#tls_certificate = "/usr/local/etc/openser/tls/user/user-cert.pem"
#tls_private_key = "/usr/local/etc/openser/tls/user/user-privkey.pem"
#tls_ca_list = "/usr/local/etc/openser/tls/user/user-calist.pem"

# ------------------ module loading ----------------------------------

#set module path
mpath="/usr/local/lib/openser/modules/"

# Uncomment this if you want to use SQL database
#loadmodule "mysql.so"
loadmodule "postgres.so"

loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
loadmodule "registrar.so"
loadmodule "textops.so"
loadmodule "mi_fifo.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
#loadmodule "auth.so"
#loadmodule "auth_db.so"

# ----------------- setting module-specific parameters ---------------

# -- mi_fifo params --

modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")

# -- usrloc params --

modparam("usrloc", "db_mode",   0)

# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)

# -- auth params --
# Uncomment if you are using auth module
#
#modparam("auth_db", "calculate_ha1", yes)
#
# If you set "calculate_ha1" parameter to yes (which true in this config),
# uncomment also the following parameter)
#
#modparam("auth_db", "password_column", "password")

# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
 ......
....

I checked for the PQescapeStringConn and found this
www.mail-archive.com/devel@openser.org.msg05182.html

but I could not make anything out of it

I dont want authentication just yet.  Can anyone tell me what is wrong ?

Thanks in advance

Caugar