[Asterisk-Users] realtime - unable to find key

Ronald Wiplinger ronald at elmit.com
Thu Mar 24 22:58:37 MST 2005


andrew matthews wrote:

>ok so my table looks like this...
>
>REATE TABLE `sip` (
> `id` int(11) NOT NULL auto_increment,
> `name` varchar(80) NOT NULL default '',
> `accountcode` varchar(20) default NULL,
> `amaflags` varchar(7) default NULL,
> `callgroup` varchar(10) default NULL,
> `callerid` varchar(80) default NULL,
> `canreinvite` char(3) default 'yes',
> `context` varchar(80) default NULL,
> `defaultip` varchar(15) default NULL,
> `dtmfmode` varchar(7) default NULL,
> `fromuser` varchar(80) default NULL,
> `fromdomain` varchar(80) default NULL,
> `host` varchar(31) NOT NULL default '',
> `insecure` varchar(4) default NULL,
> `language` char(2) default NULL,
> `mailbox` varchar(50) default NULL,
> `md5secret` varchar(80) default NULL,
> `nat` int(1) NOT NULL default '1',
> `permit` varchar(95) default NULL,
> `deny` varchar(95) default NULL,
> `mask` varchar(95) default NULL,
> `pickupgroup` varchar(10) default NULL,
> `port` varchar(5) NOT NULL default '',
> `qualify` char(3) default NULL,
> `restrictcid` char(1) default NULL,
> `rtptimeout` char(3) default NULL,
> `rtpholdtimeout` char(3) default NULL,
> `secret` varchar(80) default NULL,
> `type` varchar(6) NOT NULL default 'friend',
> `username` varchar(80) NOT NULL default '',
> `disallow` varchar(100) default 'all',
> `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
> `musiconhold` varchar(100) default NULL,
> `regseconds` int(11) NOT NULL default '0',
> `ipaddr` varchar(15) NOT NULL default '',
> `regexten` varchar(80) NOT NULL default '',
> `cancallforward` char(3) default 'yes',
> PRIMARY KEY  (`id`),
> UNIQUE KEY `name` (`name`),
> KEY `name_2` (`name`)
>) TYPE=MyISAM ROW_FORMAT=DYNAMIC; 
>
>and my extconfig.conf looks like this...
>  
>
... and which dates are in the table?

>[settings]
>sipusers => mysql,voip,sip 
>sippeers => mysql,voip,sip 
>voicemail => mysql,voip,voicemail
>extensions => mysql,voip,extensions
>
>
>and when my phone tries to register i get
>
>Mar 24 21:26:32 DEBUG[28397]: res_config_mysql.c:117 realtime_mysql:
>MySQL RealTime: Retrieve SQL: SELECT * FROM sip WHERE name =
>'5625551212'
>Mar 24 21:26:32 DEBUG[28397]: res_config_mysql.c:605 mysql_reconnect:
>MySQL RealTime: Everything is fine.
>Mar 24 21:26:32 DEBUG[28397]: db.c:177 ast_db_get: Unable to find key
>'5625551212' in family 'SIP/Registry'
>Mar 24 21:26:32 DEBUG[28397]: chan_sip.c:1440 create_addr: Setting NAT
>on RTP to 524288
>Mar 24 21:26:51 DEBUG[28397]: chan_sip.c:920 __sip_autodestruct: Auto
>destroying call '00036b09-56b60002-32ccd9fc-122011c0 at 192.168.4.22'
>
>any idea's what could cause this?
>
>Thank you in advanced.
>
>Andrew
>_______________________________________________
>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
>
>
>
>  
>


-- 
Ronald Wiplinger  (CEO of ELMIT)
http://www.elmit.com    +886 (0) 939--77-55-16  or FWD 511208
- I'm a SpamCon Foundation Member, #694, Verify it at http://www.spamcon.org

PS: Spam prevention!
Our system is protected with a spam prevention program. 
If you send us an e-mail, our system will send you a confirmation message back. Just reply to this confirmation message please. 
After receiving this confirmation message, our system will send the hold message (one) and all future messages (after the received confirmation message) to me without asking you again.





More information about the asterisk-users mailing list