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