[Serusers] migration 0.8.14 -> 0.9.0 and SQL broken

Mik mik at ttn.ru
Tue May 10 19:53:33 CEST 2005


Hello,

I am started using SER from 0.8.14 version. All was fine. I use postgres 
SQL for registered location, stored cridentical username & password.
But I needed some basic UAC functionalities like client authentication 
on other SIP-proxy. I take uac module. This module don't work with 
0.8.14 SER. And I take 0.9.0. Compile and install new ser & modules. 
After that ALL my SQL shema is broken! SER don't work with SQL! Why? I 
nothing change in ser.cfg..... Old version 0.8.14 work, but new version 
0.9.0 don't work.

postgres - initializing
stateless - initializing
textops - initializing
  0(0) Maxfwd module- initializing
acc - initializing
exec - initializing
  0(0) bind_dbmod: Module sql does not export db_use_table function
  0(0) ERROR: mod_init(): Can't bind database module
  0(0) init_mod(): Error while initializing module usrloc
ERROR: error while initializing modules

If I am deleted 2 modules from SER.CFG:
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
I have error in other module

postgres - initializing
stateless - initializing
textops - initializing
  0(0) Maxfwd module- initializing
acc - initializing
exec - 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


SER.CFG (very simple for debug):
# ----------- global configuration parameters ------------------------

user=voip
listen=213.24.21.2
log_stderror=yes

debug=3
fifo="/var/run/ser.pipe"
fifo_mode=0600
children=5
alias=tagan.ru
alias=megalink.com.ru
sip_warning=no

# ------------------ module loading ----------------------------------

loadmodule "/usr/local/lib/ser/modules/postgres.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/textops.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/registrar.so"
loadmodule "/usr/local/lib/ser/modules/acc.so"
loadmodule "/usr/local/lib/ser/modules/xlog.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"


# ----------------- setting module-specific parameters ---------------

modparam("usrloc", "db_url" ,"sql://pgsql@localhost/megalink")
modparam("usrloc", "db_mode", 1)

modparam("auth_db", "db_url" ,"sql://pgsql@localhost/megalink")
modparam("auth_db", "password_column", "password")
modparam("auth_db", "calculate_ha1", yes)

modparam("acc", "log_level", 1)
modparam("acc", "early_media", 1)
modparam("acc", "failed_transactions", 1)
modparam("acc", "log_missed_flag", 3)
modparam("acc", "report_cancels", 1)
#modparam("acc", "db_url" ,"sql://pgsql@localhost/megalink")
modparam("acc", "log_flag", 1)

# -------------------------  request routing logic -------------------

route [0] {
     break;
}




More information about the sr-users mailing list