Hi List, 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.
*res_mysql.conf* [mpathsala] dbhost = localhost dbname = mpathsala dbuser = root dbpass = dbport = 3306 dbsock = /var/lib/mysql/mysql.sock *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=tbl_structure.php&dontlimitchars=1&token=977fd1644a5045dffe5dc1454df7dab7> 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 regexten restrictcid rtchachefriends 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=977fd1644a5045dffe5dc1454df7dab7&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=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> 1 300 dynamic no friend *NULL* *NULL* 5 *NULL* 100 yes yes *NULL* *NULL* rfc2833 *NULL* *NULL* no EN 100@default *NULL* *NULL* *NULL* *NULL* default *NULL* *NULL* *NULL* YES *NULL* *NULL* *NULL* *NULL* all g729;ilbc;gsm;ulaw;alaw 80 *NULL* 0 0 *NULL* *NULL* *sip.conf * [general] rtcachefriends=No rtsavesysname=yes rtupdate=yes rtautoclear=yes After all when I check on CLI then I will get **CLI> sip show inuse* * User name In use Limit * Peer name In use Limit **CLI> sip prune realtime users* Peer 'users' not found. User 'users' not found. **CLI> sip prune realtime peers* Peer 'peers' not found. User 'peers' not found. **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] **CLI> sip show users* Username Secret Accountcode Def.Context ACL NAT **CLI>* Is there any problem in my configuration ? On Sat, May 21, 2011 at 6:56 PM, Rafael dos Santos Saraiva < [email protected]> wrote: > 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 <[email protected]> > >> 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 > > > -- > _____________________________________________________________________ > -- 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 > -- ----- 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
