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
Caugar,
Make sure you remove postgres from the exclude_modules?= line in the Makefile.
Recompile and install.
That should fix the could not open module error.
Steve
Knight Tiger wrote:
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
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
On Wednesday 21 March 2007 23:46, Knight Tiger wrote:
Hi
I have installed Openser v 1.2 no tls. I have Postgres version 8.0.7.
I tried openser start [..] 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"
There was an discussion about this problem one week ago, the subject was "openser+postgresql".
It seems that you need to upgrade your postgresql library to 8.0.8, as the missing symbol belongs to a security patch.
Cheers,
Henning
Thanks ! That worked..
Knight
On 3/22/07, Henning Westerholt henning.westerholt@1und1.de wrote:
On Wednesday 21 March 2007 23:46, Knight Tiger wrote:
Hi
I have installed Openser v 1.2 no tls. I have Postgres version 8.0.7.
I tried openser start [..] 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"
There was an discussion about this problem one week ago, the subject was "openser+postgresql".
It seems that you need to upgrade your postgresql library to 8.0.8, as the missing symbol belongs to a security patch.
Cheers,
Henning