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>
Rafael dos Santos Saraiva
2011-May-21 13:26 UTC
[asterisk-users] how to user SIP realtime option
Hi 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. Att, Rafael Saraiva 2011/5/21 virendra bhati <virbhati at gmail.com>> 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 > > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-- Att, Rafael Saraiva -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110521/ed453d9c/attachment.htm>