Hi List, One more thing I got that mysql connection is not connected as per the cli command
*cent211*CLI> realtime mysql cache* *cent211*CLI> realtime mysql status* No connections configured. Does it means my mysql database not connected or anything else ? On Mon, May 23, 2011 at 12:44 PM, virendra bhati <virbh...@gmail.com> wrote: > 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 < > rafaels...@gmail.com> 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 <virbh...@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 >> >> >> -- >> _____________________________________________________________________ >> -- 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 > > -- ----- 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