[Asterisk-Users] Realtime UPDATE
Rod Bacon
rod.bacon at empoweredcomms.com.au
Thu Apr 7 15:15:24 MST 2005
As requested, here is my database setup....
+----------------+--------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+----------------+--------------+------+-----+---------------------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| name | varchar(80) | | UNI | |
|
| accountcode | varchar(20) | YES | | NULL |
|
| amaflags | varchar(7) | YES | | NULL |
|
| callgroup | varchar(10) | YES | | NULL |
|
| callerid | varchar(80) | YES | | NULL |
|
| canreinvite | char(3) | YES | | yes |
|
| context | varchar(80) | YES | | NULL |
|
| defaultip | varchar(15) | YES | | NULL |
|
| dtmfmode | varchar(7) | YES | | NULL |
|
| fromuser | varchar(80) | YES | | NULL |
|
| fromdomain | varchar(80) | YES | | NULL |
|
| host | varchar(31) | | | dynamic |
|
| insecure | varchar(4) | YES | | NULL |
|
| language | char(2) | YES | | NULL |
|
| mailbox | varchar(50) | YES | | NULL |
|
| md5secret | varchar(80) | YES | | NULL |
|
| nat | varchar(5) | | | no |
|
| permit | varchar(95) | YES | | NULL |
|
| deny | varchar(95) | YES | | NULL |
|
| mask | varchar(95) | YES | | NULL |
|
| pickupgroup | varchar(10) | YES | | NULL |
|
| port | varchar(5) | | | |
|
| qualify | char(3) | YES | | NULL |
|
| restrictcid | char(1) | YES | | NULL |
|
| rtptimeout | char(3) | YES | | NULL |
|
| rtpholdtimeout | char(3) | YES | | NULL |
|
| secret | varchar(80) | YES | | NULL |
|
| type | varchar(6) | | | friend |
|
| username | varchar(80) | | | |
|
| disallow | varchar(100) | YES | | all |
|
| allow | varchar(100) | YES | | ilbc;g726;alaw;ulaw |
|
| musiconhold | varchar(100) | YES | | NULL |
|
| regseconds | int(11) | | | 0 |
|
| ipaddr | varchar(15) | | | |
|
| regexten | varchar(80) | | | |
|
| cancallforward | char(3) | YES | | yes |
|
+----------------+--------------+------+-----+---------------------+----------------+
And the line containing extension 9999....
+----+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+----------+----------+---------+-----------+-----+--------+------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+----------+---------------------+-------------+------------+--------+----------+----------------+
| id | name | accountcode | amaflags | callgroup | callerid | canreinvite |
context | defaultip | dtmfmode | fromuser | fromdomain | host | insecure
| language | mailbox | md5secret | nat | permit | deny | mask | pickupgroup
| port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type
| username | disallow | allow | musiconhold | regseconds |
ipaddr | regexten | cancallforward |
+----+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+----------+----------+---------+-----------+-----+--------+------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+----------+---------------------+-------------+------------+--------+----------+----------------+
| 8 | 9999 | NULL | NULL | NULL | NULL | yes |
default | NULL | NULL | NULL | NULL | dynamic | NULL
| NULL | NULL | NULL | no | NULL | NULL | NULL | NULL
| | NULL | NULL | NULL | NULL | coco |
friend | 9999 | all | ilbc;g726;alaw;ulaw | NULL |
0 | | | yes |
+----+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+----------+----------+---------+-----------+-----+--------+------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+----------+---------------------+-------------+------------+--------+----------+----------------+
----- Original Message -----
From: "Matthew Boehm" <mboehm at cytelcom.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Thursday, April 07, 2005 11:31 PM
Subject: Re: [Asterisk-Users] Realtime UPDATE
>
>> Apr 7 09:09:20 DEBUG[3672]: db.c:177 ast_db_get: Unable to find key
>> '9999' in family 'SIP/Registry'
>
> This is the problem. Can you post your 'DESCRIBE <sip_table>' and
> the row containing user 9999?
>
> You using any NAT? You NAT column should be varchar(5) not int.
>
> -Matthew
>
>
> Rod Bacon wrote:
>> I have playing with these, to no effect.
>>
>> I am assuming that threre is indeed a bug.
>>
>>
>>
>> Arnaud PIGNARD wrote:
>>> Got the same problem, and i rollback to older version (before RT
>>> cache patch).
>>>
>>> There is a combinaison where you will get successfull update but for
>>> me, realtime was unstable.
>>> I haven't yet time to make more test for maybe report a potential
>>> bug.
>>>
>>> Try modify theses params to yes or no :
>>>
>>> Rtcachefriends=yes
>>> Rtnoupdate=yes
>>> Rtautoclear=yes
>>>
>>>
>>> At 01:39 07/04/2005, you wrote:
>>>
>>>> I had discovered this myself. Once I set this value, the updates
>>>> started to occur, but as shown in my earlier post, are all NULL
>>>> values.
>>>>
>>>>
>>>>
>>>> ----- Original Message ----- From: "Thierry Wehr" <wehr at japet.com>
>>>> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
>>>> <asterisk-users at lists.digium.com>
>>>> Sent: Thursday, April 07, 2005 9:36 AM
>>>> Subject: RE: [Asterisk-Users] Realtime UPDATE
>>>>
>>>>
>>>>> -----Message d'origine-----
>>>>> De : asterisk-users-bounces at lists.digium.com
>>>>> [mailto:asterisk-users-bounces at lists.digium.com] De la part
>>>>> de Rod Bacon
>>>>> Envoyé : jeudi 7 avril 2005 01:06
>>>>> À : asterisk-users at lists.digium.com
>>>>> Objet : [Asterisk-Users] Realtime UPDATE
>>>>
>>>>
>>>>> My problem is that upon registration, the UA's IP address and
>>>>> port information isn't being written to the MYSQL realtime
>>>>> database. Subsequently, calls to the UA fail if they originate from
>>>>> another * server (The server DOES attempt a lookup, but
>>>>> obviously gets no value for IP address / PORT).
>>>>
>>>>
>>>> Hi
>>>>
>>>> I'd the same problem and discovered that you have to put
>>>>
>>>> rtnoupdate=no in you'r sip.conf
>>>>
>>>> Hope it helps you
>>>>
>>>> Thierry
>>>>
>>>> _______________________________________________
>>>> Asterisk-Users mailing list
>>>> Asterisk-Users at lists.digium.com
>>>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>>> To UNSUBSCRIBE or update options visit:
>>>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>>>
>>>>
>>>> _______________________________________________
>>>> Asterisk-Users mailing list
>>>> Asterisk-Users at lists.digium.com
>>>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>>> To UNSUBSCRIBE or update options visit:
>>>> http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
More information about the asterisk-users
mailing list