[Asterisk-Users] realtime - unable to find key

[andrew matthews]

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...

[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