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; }