[asterisk-users] how to user SIP realtime option
virendra bhati
virbhati at gmail.com
Mon May 23 02:55:04 CDT 2011
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 <virbhati at 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 at 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 <
> rafaelsnsa at 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 <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
>>
>>
>> --
>> _____________________________________________________________________
>> -- 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110523/10dc390b/attachment-0001.htm>
More information about the asterisk-users
mailing list