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.