<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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Courier;
        panose-1:2 7 4 9 2 2 5 2 4 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@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;}
p
        {mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";}
span.EmailStyle17
        {mso-style-type:personal;
        font-family:"Comic Sans MS";
        color:blue;
        font-weight:normal;
        font-style:normal;
        text-decoration:none none;}
span.EmailStyle19
        {mso-style-type:personal-reply;
        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>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white 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'>Thanks –
that did the trick. If only the documentation reflected mysql rather than sql,
or described the purpose of each field in the url.<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 again –
your hint was very helpful!<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><st1:City w:st="on"><st1:place 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:place></st1:City><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>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Pat Wang
[mailto:wangyu39@hotmail.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, March 17, 2006 10:02
PM<br>
<b><span style='font-weight:bold'>To:</span></b> Duncan Glendinning; <st1:PersonName
w:st="on">serusers@lists.iptel.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [Serusers] SER /
MySql Problem</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 color=black face=Courier><span lang=PT-BR
style='font-size:12.0pt;font-family:Courier;color:black'>try to use
"mysql" instead of sql in:</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 color=black face=Courier><span lang=PT-BR
style='font-size:12.0pt;font-family:Courier;color:black'>modparam("usrloc",
"db_url", "sql://ser:heslo@localhost/ser")</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 color=black face=Courier><span lang=PT-BR
style='font-size:12.0pt;font-family:Courier;color:black'>Regards,</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 color=black face=Courier><span lang=PT-BR
style='font-size:12.0pt;font-family:Courier;color:black'>Pat<o:p></o:p></span></font></p>
</div>
<blockquote style='border:none;border-left:solid black 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>----- Original Message ----- <o:p></o:p></span></font></p>
</div>
<div style='font-color:black'>
<p class=MsoNormal style='background:#E4E4E4'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>From:</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> <a
href="mailto:Duncan.Glendinning@cox.net" title="Duncan.Glendinning@cox.net">Duncan
Glendinning</a> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>To:</span></font></b><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'> <a
href="mailto:serusers@lists.iptel.org" title="serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>Sent:</span></font></b><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'> Saturday, March
18, 2006 3:53 AM<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>Subject:</span></font></b><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'> [Serusers] SER /
MySql Problem<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<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 class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>_______________________________________________<br>
Serusers mailing list<br>
serusers@lists.iptel.org<br>
http://lists.iptel.org/mailman/listinfo/serusers<o:p></o:p></span></font></p>
</blockquote>
</div>
</body>
</html>