[Serusers] SER / MySql Problem

Pat Wang wangyu39 at hotmail.com
Sat Mar 18 06:01:49 CET 2006


try to use "mysql" instead of sql in:
modparam("usrloc", "db_url", "sql://ser:heslo@localhost/ser")

Regards,

Pat
  ----- Original Message ----- 
  From: Duncan 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

  ---

  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/20060318/57cc7c14/attachment.htm>


More information about the sr-users mailing list