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