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" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@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" <[EMAIL PROTECTED]> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <asterisk-users@lists.digium.com> Sent: Thursday, April 07, 2005 9:36 AM Subject: RE: [Asterisk-Users] Realtime UPDATE
-----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Rod Bacon Envoyé : jeudi 7 avril 2005 01:06 À : asterisk-users@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@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@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@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@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
