[Serusers] ser-0.9.0 and postgresql

[Gianni Olivieri -]

Hallo to all,

    I've just installed from source ser 0.9.0 and i've compiled the
postgres module.

I've create a db structure like this:

http://lists.iptel.org/pipermail/serusers/2003-November/003773.html



and this is my ser.cfg (only postgres part):

----
loadmodule "/usr/local/lib/ser/modules/postgres.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"

modparam("usrloc", "db_mode",   0)
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("auth_db","db_url", "sql://ser:mypass@localhost:5432/ser")
----



if i connect from shell:

----
# psql -U ser ser
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

ser=>
----

All is ok.

But when i start ser server:

----
postgres - initializing
stateless - initializing
 0(0) Maxfwd module- initializing
textops - initializing
 0(0) bind_dbmod: Module sql does not export db_use_table function
 0(0) ERROR: auth_db_bind: unable to bind to the database module
 0(0) init_mod(): Error while initializing module auth_db
ERROR: error while initializing modules
----



Where is the error?
Is possible to use postgresql instead of mysql?

Thanks.

-- 
Gianni Olivieri		|	Debian/GNU Linux On Kernel 2.6.9-mh4 
gianni at gnuthink.org	|	Linux registered user #333000
gianni at pureyang.org     |       <Jabber Id> gianni at ircshare.com

(8) It is more complicated than you think.
<RFC 1925 - Fundamental Truths of Networking>