<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:"Comic Sans MS";
        panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:"Comic Sans MS";
        color:blue;
        font-weight:normal;
        font-style:normal;
        text-decoration:none none;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>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:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>Mar 17 16:43:22
dglendin-pbx /usr/local/sbin/ser[7478]: Maxfwd module- initializing <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=red face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:red'>Mar 17 16:43:22
dglendin-pbx /usr/local/sbin/ser[7478]: bind_dbmod: Module sql does not export
db_use_table function <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>Mar 17 16:43:22
dglendin-pbx /usr/local/sbin/ser[7478]: ERROR: mod_init(): Can't bind database
module <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>Mar 17 16:43:22
dglendin-pbx /usr/local/sbin/ser[7478]: init_mod(): Error while initializing
module usrloc <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>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.)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>Here is the top
of my ser.cfg file, if this helps.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>#<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/mysql.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/sl.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/tm.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/rr.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/maxfwd.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/usrloc.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/registrar.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/acc.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/textops.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>loadmodule
"/usr/local/lib/ser/modules/exec.so"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
lang=PT-BR style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>modparam("usrloc",
"db_url", "sql://ser:heslo@localhost/ser")<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
lang=PT-BR style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>#modparam("usrloc",
"db_mode", 0)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
lang=PT-BR style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>modparam("usrloc",
"db_mode", 2)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>#modparam("auth_db",
"calculate_ha1", yes)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>#modparam("auth_db",
"password_column", "password")<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>modparam("rr",
"enable_full_lr", 1)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>modparam("acc",
"log_level", 1)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>modparam("acc",
"log_flag", 1)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>Any help /
suggestions would be appreciated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=3
color=blue face="Comic Sans MS"><span style='font-size:12.0pt;font-family:
"Comic Sans MS";color:blue'>Duncan</span></font></st1:City></st1:place><font
color=blue><span style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:blue'>---</span></font><font
color=blue><span style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue'><a href="mailto:Duncan.Glendinning@cox.net"><font
face="Comic Sans MS"><span style='font-family:"Comic Sans MS"'>Duncan.Glendinning@cox.net</span></font></a></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>