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 '[EMAIL PROTECTED]' any idea's what could cause this? Thank you in advanced. Andrew _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
