Not being an asterisk expert, but having been around the block once or twice when it comes to data and the like, I have made some observations based on the examples given on voip-info.org Sip configs.
it appears there is an adjustment to be made in the sip_buddies example table:
>>> name Although set to 30 characters, I don't see where it is limited in the text file. In theory, this field could be 250 chars long for those who like to get descriptive in there naming convention. ( I guess this is personal taste).
>>> insecure The column "insecure" is 1 character long. according to a search on the key sip insecure, the 3 values that are allowed are Null (no value) "yes" and "very" so it appears that column should be at least 4 chars long .
Example (from voip-info)
insecure=very
insecure=yes ; To match a peer based by IP address only and not peer insecure=very ; To allow registered hosts to call without re-authenticating
Typically used to allow incoming calls (e.g. from FWD) while having a type=friend entry defined with username and password.
>>> amaflags The column "amaflags" currently 1 character long should be at least 13 chars long
amaflag- Categorization for CDR records. Choices are default, omit, billing, documentation
and of course Null though not stated.
>>> canreinvite
this looks to be 3 chars not 1 (Null, no, yes)
>>> context
See name above
>>> incominglimit/outgoinglimit
these have been depreciated and probably should be removed unless there is come Realtime coding that requires these fields to be present.
>>> restrictcid
currently 1 char long, should be 3 chars for values (Null, no, yes)
>>> pickupgroup
Since callgroup was set to 30 I just set this value to 30 chars since the example shows the same number of characters.
CREATE TABLE `sip_buddies` ( `uniqueid` int(11) NOT NULL auto_increment, `name` varchar(250) NOT NULL default '', `accountcode` varchar(30) default NULL, `amaflags` char(1) default NULL, `callgroup` varchar(30) default NULL, `callerid` varchar(50) default NULL, `canreinvite` char(3) default NULL, `context` varchar(250) default NULL, `defaultip` varchar(15) default NULL, `dtmfmode` varchar(7) default NULL, `fromuser` varchar(50) default NULL, `fromdomain` varchar(31) default NULL, `host` varchar(31) NOT NULL default '', `incominglimit` char(2) default NULL, `outgoinglimit` char(2) default NULL, `insecure` varchar(4) default NULL, `language` char(2) default NULL, `mailbox` varchar(50) default NULL, `md5secret` varchar(32) default NULL, `nat` varchar(5) default NULL, `permit` varchar(95) default NULL, `deny` varchar(95) default NULL, `pickupgroup` varchar(30) default NULL, `port` varchar(5) NOT NULL default '', `qualify` varchar(4) default NULL, `restrictcid` char(3) default NULL, `rtptimeout` char(3) default NULL, `rtpholdtimeout` char(3) default NULL, `secret` varchar(30) default NULL, `type` varchar(6) NOT NULL default '', `username` varchar(30) NOT NULL default '', `allow` varchar(100) default NULL, `disallow` varchar(100) default NULL, `regseconds` int(11) NOT NULL default '0', `ipaddr` varchar(15) NOT NULL default '', PRIMARY KEY (`uniqueid`), UNIQUE KEY `name` (`name`), KEY `name_2` (`name`) ) TYPE=MyISAM AUTO_INCREMENT=1 ;
Regards Greg Cirino
_______________________________________________ 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
