Hi
I am trying to setup IAX realtime table but IAX isn’t loading the values I enter to the database:
extconfig.conf
iaxusers => odbc,asterisk,iax
iaxpeers => odbc,asterisk,iax
MySQL database structure:
CREATE TABLE IF NOT EXISTS iax (
name varchar(40) NOT NULL DEFAULT ‘’,
type varchar(10) NOT NULL DEFAULT ‘friend’,
username varchar(40) DEFAULT NULL,
mailbox varchar(40) DEFAULT NULL,
secret varchar(40) DEFAULT NULL,
dbsecret varchar(40) DEFAULT NULL,
context varchar(40) DEFAULT NULL,
regcontext varchar(40) DEFAULT NULL,
host varchar(40) DEFAULT ‘dynamic’,
ipaddr varchar(20) DEFAULT NULL,
port int(5) DEFAULT NULL,
defaultip varchar(20) DEFAULT NULL,
sourceaddress varchar(20) DEFAULT NULL,
mask varchar(20) DEFAULT NULL,
regexten varchar(40) DEFAULT NULL,
regseconds int(11) DEFAULT NULL,
accountcode varchar(20) DEFAULT NULL,
mohinterpret varchar(20) DEFAULT NULL,
mohsuggest varchar(20) DEFAULT NULL,
inkeys varchar(40) DEFAULT NULL,
outkey varchar(40) DEFAULT NULL,
language varchar(10) DEFAULT NULL,
callerid varchar(100) DEFAULT NULL,
cid_number varchar(40) DEFAULT NULL,
sendani varchar(10) DEFAULT NULL,
fullname varchar(40) DEFAULT NULL,
trunk varchar(3) DEFAULT NULL,
auth varchar(20) DEFAULT NULL,
maxauthreq varchar(5) DEFAULT NULL,
requirecalltoken varchar(4) DEFAULT NULL,
encryption varchar(20) DEFAULT NULL,
transfer varchar(10) DEFAULT NULL,
jitterbuffer varchar(3) DEFAULT NULL,
forcejitterbuffer varchar(3) DEFAULT NULL,
disallow varchar(40) DEFAULT NULL,
allow varchar(40) DEFAULT NULL,
codecpriority varchar(40) DEFAULT NULL,
qualify varchar(10) DEFAULT NULL,
qualifysmoothing varchar(10) DEFAULT NULL,
qualifyfreqok varchar(10) DEFAULT NULL,
qualifyfreqnotok varchar(10) DEFAULT NULL,
timezone varchar(20) DEFAULT NULL,
adsi varchar(10) DEFAULT NULL,
amaflags varchar(20) DEFAULT NULL,
setvar varchar(200) DEFAULT NULL,
PRIMARY KEY (name),
KEY name (name,host),
KEY name2 (name,ipaddr,port),
KEY ipaddr (ipaddr,port),
KEY host (host,port)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
MySQL Database entry:
INSERT INTO iax VALUES (‘dbstest’,‘friend’,‘dbstest’,NULL,‘fqlaskjjdgf827382’,NULL,‘external’,NULL,‘169.255.228.100’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,‘yes’,NULL,NULL,NULL,NULL,NULL,NULL,NULL,‘all’,‘g729:20’,NULL,‘yes’,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
I then do a “core reload”
Reloading IAX only gives me the following error:
iax2 reload
[2018-02-22 11:05:51] NOTICE[25033]: iax2/provision.c:562 iax_provision_reload: No IAX provisioning configuration found, IAX provisioning disabled.
Secondly, any suggestions on how to register the trunk to my provider: exp
register => username:password@10.10.10.100
Regards