[Asterisk-Users] Asterisk Realtime IAX - Adding fields for database table

Jason Goecke jsgoecke at yahoo.com
Tue Dec 14 05:52:22 MST 2004


Hello,

Right now there is not a table build script at:

http://www.voip-info.org/wiki-Asterisk+RealTime+IAX

Therefore I have taken the SIP build script and added
a few fields that I use from my iax.conf (could be
more out there, please see the complete build script
below):

  `dbsecret` varchar(100) default '',
  `notransfer` varchar(100) default '',
  `inkeys` varchar(100) default '',
  `auth` varchar(100) default '',
  `qualify` varchar(4) default NULL,

While most of IAX peers are working for
inbound/outbound, Voicepulse is not (requires the
'qualify' field set to yes).  Not sure if this is a
problem on my side (although it works from the
iax.conf settings).

So, my question is.  Will the Asterisk Realtime code
pick up any new fields added to a table and use those
dynamically?

What else could the problem be?  Any ideas?
-----------------------------------------
# Host: X
# Database: my_table
# Table: 'iax_buddies'
# 
CREATE TABLE `iax_buddies` (
  `dbsecret` varchar(100) default '',
  `notransfer` varchar(100) default '',
  `inkeys` varchar(100) default '',
  `auth` varchar(100) default '',
  `name` varchar(30) NOT NULL default '',
  `accountcode` varchar(30) default NULL,
  `amaflags` char(1) default NULL,
  `callgroup` varchar(30) default NULL,
  `callerid` varchar(100) default NULL,
  `canreinvite` varchar(100) default '',
  `context` varchar(30) 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(100) default '',
  `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(10) default NULL,
  `port` varchar(5) NOT NULL default '',
  `qualify` varchar(4) default NULL,
  `restrictcid` char(1) default NULL,
  `rtptimeout` char(3) default NULL,
  `rtpholdtimeout` char(3) default NULL,
  `secret` longtext,
  `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 '',
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM; 
-----------------------------------------



More information about the asterisk-users mailing list