[asterisk-users] how to user SIP realtime option

[virendra bhati]

Hi List,

After read the link
http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip. I changes
all information in below conf files

*res_mysql.conf*

[mpathsala]
dbhost = localhost
dbname = mpathsala
dbuser = root
dbpass =
dbport = 3306

*extconfig.conf*

sipusers => mysql,mpathsala,sip_buddies
sippeers => mysql,mpathsala,sip_buddies

*mysql*

make same table sip_buddies in mpathsala database.
insert 1 row into database

[image: Full Texts]<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>
id
name host nat type accountcode amaflags call-limit callgroup callerid
cancallforward
canreinvite context defaultip dtmfmode fromuser fromdomain insecure language
mailbox md5secret deny permit mask musiconhold pickupgroup qualify
regexten restrictcid
rtptimeout rtpholdtimeout secret setvar disallow allow fullcontact ipaddr port
regserver regseconds lastms username defaultuser subscribecontext
useragent     [image:
Edit]<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>
 [image:
Delete]<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>
1 300 dynamic no friend *NULL* *NULL* *NULL* *NULL* 100 yes yes *NULL* *NULL
* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *
NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* *NULL* all
g729;ilbc;gsm;ulaw;alaw     0 *NULL* 0 0     *NULL* *NULL*

*sip.conf *

[general]

rtcachefriends=yes
rtsavesysname=yes
rtupdate=yes
rtautoclear=yes

After all when I check on CLI then I will get

*cent70*CLI> sip show peers*
Name/username              Host            Dyn Nat ACL Port     Status
Realtime
0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0
offline]

*cent70*CLI> sip show users*
Username                   Secret           Accountcode
Def.Context      ACL  NAT

Why SIP/300 is not display here ??

Please help me I want to learn asterisk real-time concept to make my server
real-time.
-----
Thanks and regards

 Virendra Bhati
+91-9172341457
Asterisk Engineer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110521/744f70a3/attachment.htm>