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(a)gnuthink.org | Linux registered user #333000
gianni(a)pureyang.org | <Jabber Id> gianni(a)ircshare.com
(8) It is more complicated than you think.
<RFC 1925 - Fundamental Truths of Networking>