[Serusers] SER / MySql Problem

[Duncan Glendinning]

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 at cox.net> Duncan.Glendinning at cox.net

  _____  

From: Pat Wang [mailto:wangyu39 at hotmail.com] 
Sent: Friday, March 17, 2006 10:02 PM
To: Duncan Glendinning; serusers at 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 at cox.net>  Glendinning 

To: serusers at 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 at cox.net> Duncan.Glendinning at cox.net

 


  _____  


_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060320/5e4fb405/attachment.htm>