<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.<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">dbsock = /var/lib/mysql/mysql.sock<br><br><b>extconfig.conf</b><br><br>sipusers =&gt; mysql,mpathsala,sip_buddies<br>

sippeers =&gt; 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 id="table_results" class="data"><thead><tr><th colspan="3">
<a href="http://192.168.193.69/phpmyadmin/sql.php?db=mpathsala&amp;table=sip_buddies&amp;sql_query=SELECT+%2A+FROM+%60sip_buddies%60&amp;goto=tbl_structure.php&amp;dontlimitchars=1&amp;token=977fd1644a5045dffe5dc1454df7dab7"><img class="fulltext" 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 class="odd">
    <td align="center">
        <input id="id_rows_to_delete0" 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&amp;table=sip_buddies&amp;token=977fd1644a5045dffe5dc1454df7dab7&amp;primary_key=+%60sip_buddies%60.%60id%60+%3D+1&amp;sql_query=SELECT+%2A+FROM+%60sip_buddies%60&amp;goto=sql.php"><img class="icon" 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&amp;table=sip_buddies&amp;token=977fd1644a5045dffe5dc1454df7dab7&amp;sql_query=DELETE+FROM+%60sip_buddies%60+WHERE+%60sip_buddies%60.%60id%60+%3D+1+LIMIT+1&amp;zero_rows=The+row+has+been+deleted&amp;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"><img class="icon" src="http://192.168.193.69/phpmyadmin/themes/original/img/b_drop.png" alt="Delete" title="Delete" height="16" width="16"></a>
    </td>
    <td class=" nowrap" align="right">1</td>
    <td class="">300</td>
    <td class="">dynamic</td>
    <td class="">no</td>
    <td class="">friend</td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class=" nowrap" align="right">5</td>
    <td class=""><i>NULL</i></td>
    <td class="">100</td>
    <td class="">yes</td>
    <td class="">yes</td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class="">rfc2833</td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class="">no</td>
    <td class="">EN</td>
    <td class="">100@default</td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class="">default</td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class="">YES</td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
    <td class="">all</td>
    <td class="">g729;ilbc;gsm;ulaw;alaw</td>
    <td class=""> </td>
    <td class=""> </td>
    <td class=" nowrap" align="right">80</td>
    <td class=""><i>NULL</i></td>
    <td class=" nowrap" align="right">0</td>
    <td class=" nowrap" align="right">0</td>
    <td class=""> </td>
    <td class=""> </td>
    <td class=""><i>NULL</i></td>
    <td class=""><i>NULL</i></td>
</tr>
            
</tbody>
</table>

    <br><b>sip.conf </b><br><br>[general]<br><br>rtcachefriends=No<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><b>*CLI&gt; sip show inuse</b><br>
* User name               In use          Limit<br>* Peer name               In use          Limit<br><b>*CLI&gt; sip prune realtime users</b><br>Peer &#39;users&#39; not found.<br>User &#39;users&#39; not found.<br><b>*CLI&gt; sip prune realtime peers</b><br>
Peer &#39;peers&#39; not found.<br>User &#39;peers&#39; not found.<br><b>*CLI&gt; 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>
<b>*CLI&gt; sip show users</b><br>Username                   Secret           Accountcode      Def.Context      ACL  NAT<br><b>*CLI&gt;</b><br><br>Is there any problem in my configuration ?<br><br><br><div class="gmail_quote">
On Sat, May 21, 2011 at 6:56 PM, Rafael dos Santos Saraiva <span dir="ltr">&lt;<a href="mailto:rafaelsnsa@gmail.com">rafaelsnsa@gmail.com</a>&gt;</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 &quot;rtcachefriends&quot; from your sip.conf and include the field &quot;rtchachefriends&quot; in table sip_buddies. And exclude the field &quot;qualify&quot; 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 class="h5">2011/5/21 virendra bhati <span dir="ltr">&lt;<a href="mailto:virbhati@gmail.com" target="_blank">virbhati@gmail.com</a>&gt;</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 class="h5">
<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 =&gt; mysql,mpathsala,sip_buddies<br>


sippeers =&gt; 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&amp;table=sip_buddies&amp;sql_query=SELECT+%2A+FROM+%60sip_buddies%60&amp;goto=sql.php%3Fdb%3Dmpathsala%26amp%3Btable%3Dsip_buddies%26amp%3Btoken%3D0ba5913eba31b6657e85f0a1ffec66de%26amp%3Bsql_query%3DSELECT%2B%252A%2BFROM%2B%2560sip_buddies%2560&amp;dontlimitchars=1&amp;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&amp;table=sip_buddies&amp;token=0ba5913eba31b6657e85f0a1ffec66de&amp;primary_key=+%60sip_buddies%60.%60id%60+%3D+1&amp;sql_query=SELECT+%2A+FROM+%60sip_buddies%60&amp;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&amp;table=sip_buddies&amp;token=0ba5913eba31b6657e85f0a1ffec66de&amp;sql_query=DELETE+FROM+%60sip_buddies%60+WHERE+%60sip_buddies%60.%60id%60+%3D+1+LIMIT+1&amp;zero_rows=The+row+has+been+deleted&amp;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&gt; 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&gt; 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>