<div dir="ltr">Hi List,<br><br>After read the link <a href="http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip">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 id="table_results" class="data"><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"><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>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 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&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"><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&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"><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="" align="right"><i>NULL</i></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=""><i>NULL</i></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=""><i>NULL</i></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=""><i>NULL</i></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=""><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">0</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><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>