<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR><o:SmartTagType name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[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 vLink=purple link=blue bgColor=#ffffff>
<DIV><SPAN lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><FONT
face=Courier color=#000000>try to use "mysql" instead of sql
in:</FONT></SPAN></DIV>
<DIV><SPAN lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><FONT
color=#000000><FONT face=Courier>modparam("usrloc", "db_url",
"sql://ser:heslo@localhost/ser")</FONT></FONT></SPAN></DIV>
<DIV><SPAN lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><FONT
color=#000000><FONT face=Courier></FONT></FONT></SPAN> </DIV>
<DIV><SPAN lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><FONT
color=#000000><FONT face=Courier>Regards,</FONT></FONT></SPAN></DIV>
<DIV><SPAN lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><FONT
color=#000000><FONT face=Courier></FONT></FONT></SPAN> </DIV>
<DIV><SPAN lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><FONT
color=#000000><FONT face=Courier>Pat<o:p></o:p></FONT></FONT></SPAN></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Duncan.Glendinning@cox.net
href="mailto:Duncan.Glendinning@cox.net">Duncan Glendinning</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, March 18, 2006 3:53
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Serusers] SER / MySql
Problem</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">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 face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">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 face="Comic Sans MS" color=red size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: red; FONT-FAMILY: 'Comic Sans MS'">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 face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">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 face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">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 face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">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 face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">Here is the
top of my ser.cfg file, if this helps.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">#<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/mysql.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/sl.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/tm.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/rr.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/maxfwd.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/usrloc.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/registrar.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/acc.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/textops.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">loadmodule
"/usr/local/lib/ser/modules/exec.so"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">modparam("usrloc",
"db_url", "sql://ser:heslo@localhost/ser")<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">#modparam("usrloc",
"db_mode", 0)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
lang=PT-BR
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">modparam("usrloc",
"db_mode", 2)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">#modparam("auth_db",
"calculate_ha1", yes)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">#modparam("auth_db",
"password_column", "password")<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">modparam("rr",
"enable_full_lr", 1)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">modparam("acc",
"log_level", 1)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">modparam("acc",
"log_flag", 1)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">Any help /
suggestions would be appreciated.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">Thanks,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><FONT
face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">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 face="Comic Sans MS" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">---</SPAN></FONT><FONT
color=blue><SPAN style="COLOR: blue"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" color=blue size=3><SPAN
style="FONT-SIZE: 12pt; 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 face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Serusers mailing
list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE></BODY></HTML>