On Monday 21 November 2005 11:18, scott wrote: > Hi > > Thank you for your reply. > I have tried various definitions in the sipusers table but none seem to be > working :-( > > I have attached mey structure and content export below for your attention. > > Many thanks > Scott Pinhorne > > -- > -- Table structure for table `sip_users` > -- > > CREATE TABLE `sip_users` ( > `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, > `fullcontact` 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` varchar(5) NOT NULL default 'no', > `deny` varchar(95) default NULL, > `permit` 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`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 > ; > > -- > -- Dumping data for table `sip_users` > -- > > INSERT INTO `sip_users` VALUES (1, '114', NULL, NULL, NULL, '114', 'yes', > 'default', '192.168.10.136', 'info', NULL, NULL, '114', '192.168.10.136', > NULL, NULL, NULL, NULL, 'no', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, > NULL, '114', 'friend', '114', 'all', 'g729;ilbc;gsm;ulaw;alaw', NULL, 0, > '', '', 'yes'); From wiki: "You do not need to insert the ipaddr, port or regseconds information. These columns will be updated periodicaly by RealTime. " That's valid also for the fullcontact; it appears if: rtcachefriends=yes in sip.conf otherwise stays empty. If I am not mistaken you have filled in "fullcontact" with 114. benchev
_______________________________________________ --Bandwidth and Colocation sponsored by Easynews.com -- 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
