Thanks - that did the trick. If only the documentation reflected mysql rather than sql, or described the purpose of each field in the url.
Thanks again - your hint was very helpful!
Duncan
---
mailto:Duncan.Glendinning@cox.net Duncan.Glendinning@cox.net
_____
From: Pat Wang [mailto:wangyu39@hotmail.com] Sent: Friday, March 17, 2006 10:02 PM To: Duncan Glendinning; serusers@lists.iptel.org Subject: Re: [Serusers] SER / MySql Problem
try to use "mysql" instead of sql in:
modparam("usrloc", "db_url", "sql://ser:heslo@localhost/ser")
Regards,
Pat
----- Original Message -----
From: Duncan mailto:Duncan.Glendinning@cox.net Glendinning
To: serusers@lists.iptel.org
Sent: Saturday, March 18, 2006 3:53 AM
Subject: [Serusers] SER / MySql Problem
Today, I successfully connected Asterisk to MySql, and began the process of connecting SER to MySql. However, I'm having a problem that I'm hoping someone can help me with. When I replace modparam("usrloc", "db_mode", 0) with modparam("usrloc", "db_mode", 2), I get the following error message:
Mar 17 16:43:22 dglendin-pbx /usr/local/sbin/ser[7478]: Maxfwd module- initializing
Mar 17 16:43:22 dglendin-pbx /usr/local/sbin/ser[7478]: bind_dbmod: Module sql does not export db_use_table function
Mar 17 16:43:22 dglendin-pbx /usr/local/sbin/ser[7478]: ERROR: mod_init(): Can't bind database module
Mar 17 16:43:22 dglendin-pbx /usr/local/sbin/ser[7478]: init_mod(): Error while initializing module usrloc
I can't seem to locate the origins of 'sql' in the bind_dbmod error message below - I would have expected the message to reference 'mysql'. Also, the failed bind_dbmod is strange because the modules/mysql/db_mod.c has the correct 'db_use_table' function entry. (I'm using 0.9.4 and completely recompiled today to eliminate that as an issue.)
Here is the top of my ser.cfg file, if this helps.
#
loadmodule "/usr/local/lib/ser/modules/mysql.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/acc.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
modparam("usrloc", "db_url", "sql://ser:heslo@localhost/ser")
#modparam("usrloc", "db_mode", 0)
modparam("usrloc", "db_mode", 2)
#modparam("auth_db", "calculate_ha1", yes)
#modparam("auth_db", "password_column", "password")
modparam("rr", "enable_full_lr", 1)
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", 1)
Any help / suggestions would be appreciated.
Thanks,
Duncan
---
mailto:Duncan.Glendinning@cox.net Duncan.Glendinning@cox.net
_____
_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers