<html 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=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EstiloCorreo18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EstiloCorreo19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 69.6pt 70.85pt 69.6pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ES link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hello all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>I want to use mysql for to save the users of my
asterisk PBX. I use the realtime solution with mysql but when I made the
‘sip show peers’ command doesn’t appear my users. My
configurations are:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>res_mysql.conf <o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'> [general]<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbhost = 127.0.0.1<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbname = asterisk<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbuser = asterisk<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbpass = satec<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbport = 3306<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbsock = /var/run/mysqld/mysqld.sock<o:p></o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>sip.conf <o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>[general]<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbuser=asterisk<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbpass=satec<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbhost=127.0.0.1<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>dbname=asterisk <o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>table=sipusers<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>rtcachefriends=yes<o:p></o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>extconfig.conf<o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>sipusers => mysql, asterisk,
sipusers<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>sippeers => mysql, asterisk,
sipusers<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>and the output of the ‘realtime mysql status’
<o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>asterisk2006*CLI> realtime mysql
status<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>Connected to asterisk@127.0.0.1, port
3306 with username asterisk for 3 minutes, 42 seconds.<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>asterisk2006*CLI> sip show peers<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>Name/username
Host <st1:place w:st="on"><st1:PlaceName w:st="on">Dyn</st1:PlaceName>
<st1:PlaceName w:st="on">Nat</st1:PlaceName> <st1:PlaceName w:st="on">ACL</st1:PlaceName>
<st1:PlaceType w:st="on">Port</st1:PlaceType></st1:place> Status <o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>0 sip peers [0 online , 0 offline]<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>asterisk2006*CLI> sip show users<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>Username
Secret Accountcode Def.Context ACL NAT <o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt;font-weight:bold'>asterisk2006*CLI><o:p></o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>What is the problem?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Thanks and Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Sergio<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>