[Asterisk-Users] Realtime Problems

bbench at mail.bg bbench at mail.bg
Tue Nov 22 00:36:16 MST 2005


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




More information about the asterisk-users mailing list