<div dir="ltr">Hi List,<br><br>One more thing I got that mysql connection is not connected as per the cli command<br><br><b>cent211*CLI> realtime mysql cache</b><br><b>cent211*CLI> realtime mysql status</b><br>No connections configured.<br>
<br>Does it means my mysql database not connected or anything else ?<br><br><br><div class="gmail_quote">On Mon, May 23, 2011 at 12:44 PM, virendra bhati <span dir="ltr"><<a href="mailto:virbhati@gmail.com">virbhati@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr">Hi List,<br><br>As per you suggestion I had made changes but still no improvements. Some thing was missing so I am listing aging the configuration files details here.<div class="im">
<br><br><b>res_mysql.conf</b><br><br>[mpathsala]<br>
dbhost = localhost<br>dbname = mpathsala<br>dbuser = root<br>dbpass = <br>dbport = 3306 <br clear="all"></div>dbsock = /var/lib/mysql/mysql.sock<div><div></div><div class="h5"><br><br><b>extconfig.conf</b><br><br>sipusers => mysql,mpathsala,sip_buddies<br>
sippeers => mysql,mpathsala,sip_buddies<br><br><b>mysql</b><br><br>make same table sip_buddies in mpathsala database.<br>insert 1 row into database<br><br></div></div><table><thead><tr><th colspan="3">
<a href="http://192.168.193.69/phpmyadmin/sql.php?db=mpathsala&table=sip_buddies&sql_query=SELECT+%2A+FROM+%60sip_buddies%60&goto=tbl_structure.php&dontlimitchars=1&token=977fd1644a5045dffe5dc1454df7dab7" target="_blank"><img src="http://192.168.193.69/phpmyadmin/themes/original/img/s_fulltext.png" alt="Full Texts" title="Full Texts" height="20" width="50"></a>
</th>
<th>id
</th><th>name
</th><th>host
</th><th>nat
</th><th>type
</th><th>accountcode
</th><th>amaflags
</th><th>call-limit
</th><th>callgroup
</th><th>callerid
</th><th>cancallforward
</th><th>canreinvite
</th><th>context
</th><th>defaultip
</th><th>dtmfmode
</th><th>fromuser
</th><th>fromdomain
</th><th>insecure
</th><th>language
</th><th>mailbox
</th><th>md5secret
</th><th>deny
</th><th>permit
</th><th>mask
</th><th>musiconhold
</th><th>pickupgroup
</th><th>regexten
</th><th>restrictcid
</th><th>rtchachefriends
</th><th>rtptimeout
</th><th>rtpholdtimeout
</th><th>secret
</th><th>setvar
</th><th>disallow
</th><th>allow
</th><th>fullcontact
</th><th>ipaddr
</th><th>port
</th><th>regserver
</th><th>regseconds
</th><th>lastms
</th><th>username
</th><th>defaultuser
</th><th>subscribecontext
</th><th>useragent
</th></tr>
</thead>
<tbody>
<tr>
<td align="center">
<input name="rows_to_delete[+%60sip_buddies%60.%60id%60+%3D+1]" value="DELETE+FROM+%60sip_buddies%60+WHERE+%60sip_buddies%60.%60id%60+%3D+1+LIMIT+1" type="checkbox">
</td>
<td align="center">
<a href="http://192.168.193.69/phpmyadmin/tbl_change.php?db=mpathsala&table=sip_buddies&token=977fd1644a5045dffe5dc1454df7dab7&primary_key=+%60sip_buddies%60.%60id%60+%3D+1&sql_query=SELECT+%2A+FROM+%60sip_buddies%60&goto=sql.php" target="_blank"><img src="http://192.168.193.69/phpmyadmin/themes/original/img/b_edit.png" alt="Edit" title="Edit" height="16" width="16"></a>
</td>
<td align="center">
<a href="http://192.168.193.69/phpmyadmin/sql.php?db=mpathsala&table=sip_buddies&token=977fd1644a5045dffe5dc1454df7dab7&sql_query=DELETE+FROM+%60sip_buddies%60+WHERE+%60sip_buddies%60.%60id%60+%3D+1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dmpathsala%26table%3Dsip_buddies%26token%3D977fd1644a5045dffe5dc1454df7dab7%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560sip_buddies%2560%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php" target="_blank"><img src="http://192.168.193.69/phpmyadmin/themes/original/img/b_drop.png" alt="Delete" title="Delete" height="16" width="16"></a>
</td>
<td align="right">1</td>
<td>300</td>
<td>dynamic</td>
<td>no</td>
<td>friend</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td align="right">5</td>
<td><i>NULL</i></td>
<td>100</td>
<td>yes</td>
<td>yes</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td>rfc2833</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td>no</td>
<td>EN</td>
<td>100@default</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td>default</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td>YES</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td>all</td>
<td>g729;ilbc;gsm;ulaw;alaw</td>
<td> </td>
<td> </td>
<td align="right">80</td>
<td><i>NULL</i></td>
<td align="right">0</td>
<td align="right">0</td>
<td> </td>
<td> </td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
</tr>
</tbody>
</table>
<br><b>sip.conf </b><br><br>[general]<br><br>rtcachefriends=No<div class="im"><br>rtsavesysname=yes<br>rtupdate=yes<br>rtautoclear=yes<br><br><br>After all when I check on CLI then I will get <br><br></div><b>*CLI> sip show inuse</b><br>
* User name In use Limit<br>* Peer name In use Limit<br><b>*CLI> sip prune realtime users</b><br>Peer 'users' not found.<br>User 'users' not found.<br><b>*CLI> sip prune realtime peers</b><br>
Peer 'peers' not found.<br>User 'peers' not found.<div class="im"><br><b>*CLI> sip show peers</b><br>Name/username Host Dyn Nat ACL Port Status Realtime<br>0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]<br>
</div><div class="im"><b>*CLI> sip show users</b><br>Username Secret Accountcode Def.Context ACL NAT<br></div><b>*CLI></b><br><br>Is there any problem in my configuration ?<div>
<div></div><div class="h5"><br><br><br><div class="gmail_quote">
On Sat, May 21, 2011 at 6:56 PM, Rafael dos Santos Saraiva <span dir="ltr"><<a href="mailto:rafaelsnsa@gmail.com" target="_blank">rafaelsnsa@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>Hi</div><div>Trying exclude "rtcachefriends" from your sip.conf and include the field "rtchachefriends" in table sip_buddies. And exclude the field "qualify" from sip_buddies. Set YES in field rtcachefriends.</div>
<div><br></div>Att,<div>Rafael Saraiva</div><div><br><div class="gmail_quote"><div><div></div><div>2011/5/21 virendra bhati <span dir="ltr"><<a href="mailto:virbhati@gmail.com" target="_blank">virbhati@gmail.com</a>></span><br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div>
<div dir="ltr">Hi List,<br><br>After read the link <a href="http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip" target="_blank">http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip</a> . I changes all information in below conf files <br>
<br><b>res_mysql.conf</b><br><br>[mpathsala]<br>dbhost = localhost<br>dbname = mpathsala<br>dbuser = root<br>dbpass = <br>dbport = 3306 <br clear="all"><br><b>extconfig.conf</b><br><br>sipusers => mysql,mpathsala,sip_buddies<br>
sippeers => mysql,mpathsala,sip_buddies<br><br><b>mysql</b><br><br>make same table sip_buddies in mpathsala database.<br>insert 1 row into database <br><br><table><thead><tr><th colspan="3">
<a href="http://192.168.193.69/phpmyadmin/sql.php?db=mpathsala&table=sip_buddies&sql_query=SELECT+%2A+FROM+%60sip_buddies%60&goto=sql.php%3Fdb%3Dmpathsala%26amp%3Btable%3Dsip_buddies%26amp%3Btoken%3D0ba5913eba31b6657e85f0a1ffec66de%26amp%3Bsql_query%3DSELECT%2B%252A%2BFROM%2B%2560sip_buddies%2560&dontlimitchars=1&token=0ba5913eba31b6657e85f0a1ffec66de" target="_blank"><img src="" alt="Full Texts" title="Full Texts" height="20" width="50"></a>
</th>
<th>id
</th><th>name
</th><th>host
</th><th>nat
</th><th>type
</th><th>accountcode
</th><th>amaflags
</th><th>call-limit
</th><th>callgroup
</th><th>callerid
</th><th>cancallforward
</th><th>canreinvite
</th><th>context
</th><th>defaultip
</th><th>dtmfmode
</th><th>fromuser
</th><th>fromdomain
</th><th>insecure
</th><th>language
</th><th>mailbox
</th><th>md5secret
</th><th>deny
</th><th>permit
</th><th>mask
</th><th>musiconhold
</th><th>pickupgroup
</th><th>qualify
</th><th>regexten
</th><th>restrictcid
</th><th>rtptimeout
</th><th>rtpholdtimeout
</th><th>secret
</th><th>setvar
</th><th>disallow
</th><th>allow
</th><th>fullcontact
</th><th>ipaddr
</th><th>port
</th><th>regserver
</th><th>regseconds
</th><th>lastms
</th><th>username
</th><th>defaultuser
</th><th>subscribecontext
</th><th>useragent
</th></tr>
</thead>
<tbody>
<tr>
<td align="center">
<input name="rows_to_delete[+%60sip_buddies%60.%60id%60+%3D+1]" value="DELETE+FROM+%60sip_buddies%60+WHERE+%60sip_buddies%60.%60id%60+%3D+1+LIMIT+1" type="checkbox">
</td>
<td align="center">
<a href="http://192.168.193.69/phpmyadmin/tbl_change.php?db=mpathsala&table=sip_buddies&token=0ba5913eba31b6657e85f0a1ffec66de&primary_key=+%60sip_buddies%60.%60id%60+%3D+1&sql_query=SELECT+%2A+FROM+%60sip_buddies%60&goto=sql.php" target="_blank"><img src="" alt="Edit" title="Edit" height="16" width="16"></a>
</td>
<td align="center">
<a href="http://192.168.193.69/phpmyadmin/sql.php?db=mpathsala&table=sip_buddies&token=0ba5913eba31b6657e85f0a1ffec66de&sql_query=DELETE+FROM+%60sip_buddies%60+WHERE+%60sip_buddies%60.%60id%60+%3D+1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dmpathsala%26table%3Dsip_buddies%26token%3D0ba5913eba31b6657e85f0a1ffec66de%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560sip_buddies%2560%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dsql.php%3Fdb%3Dmpathsala%26amp%3Btable%3Dsip_buddies%26amp%3Btoken%3D0ba5913eba31b6657e85f0a1ffec66de%26amp%3Bsql_query%3DSELECT%2B%252A%2BFROM%2B%2560sip_buddies%2560" target="_blank"><img src="" alt="Delete" title="Delete" height="16" width="16"></a>
</td>
<td align="right">1</td>
<td>300</td>
<td>dynamic</td>
<td>no</td>
<td>friend</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td align="right"><i>NULL</i></td>
<td><i>NULL</i></td>
<td>100</td>
<td>yes</td>
<td>yes</td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
<td>all</td>
<td>g729;ilbc;gsm;ulaw;alaw</td>
<td> </td>
<td> </td>
<td align="right">0</td>
<td><i>NULL</i></td>
<td align="right">0</td>
<td align="right">0</td>
<td> </td>
<td> </td>
<td><i>NULL</i></td>
<td><i>NULL</i></td>
</tr>
</tbody>
</table>
<br><br><b>sip.conf </b><br><br>[general]<br><br>rtcachefriends=yes<br>rtsavesysname=yes<br>rtupdate=yes<br>rtautoclear=yes<br><br>After all when I check on CLI then I will get <br><br><b>cent70*CLI> sip show peers</b><br>
Name/username Host Dyn Nat ACL Port Status Realtime<br>0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]<br><br><b>cent70*CLI> sip show users</b><br>Username Secret Accountcode Def.Context ACL NAT<br>
<br>Why SIP/300 is not display here ??<br><div dir="ltr"><br>Please help me I want to learn asterisk real-time concept to make my server real-time. <br>-----<br>Thanks and regards<br><br> Virendra Bhati<br>+91-9172341457<br>
Asterisk Engineer<br></div><br>
</div>
<br></div></div>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>Att,<div>Rafael Saraiva</div>
<br>
</div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><br><br>
<br>-----<br>Thanks and regards<br><br> Virendra Bhati<br>+91-9172341457<br>Asterisk Engineer<br></div><br>
</div></div></div>
</blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><br><br><br>-----<br>Thanks and regards<br><br> Virendra Bhati<br>+91-9172341457<br>Asterisk Engineer<br></div><br>
</div>