[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