[Users] Openser + postgres not starting

[Stephen Varga]

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 at openser /usr/local/lib]# openser start
> ERROR: bad config file (1 errors)
>
>
> [root at 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 at 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 at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>