[Asterisk-Users] sip_buddies mysql table

[Greg - Cirelle Enterprises]

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