[Serusers] migration 0.8.14 -> 0.9.0 and SQL broken

[Evan Borgström]

	Change all of the db urls from "sql://..." to "mysql://..."

-Evan

Mik wrote:
> 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;
> }
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers