Problem with Asterisk13 Realtime Configuration on Centos7

Ask questions, find resources, browse the virtual shelves.
hn_taurus
Asternaut
Posts: 1
Joined: Wed Nov 11, 2015 1:19 pm

Problem with Asterisk13 Realtime Configuration on Centos7

Post by hn_taurus » Thu Nov 12, 2015 9:17 pm

Hello Dear Fellows
I installed asterisk 13 on cent os 7 which use MAriaDb mysql as database I have done all the configurations but apparently asteirsk is not connect to Database I checked setting by using "core show setting but "Realtime Architecture was disabled" I put my configuration files in the following , I really appreciate any guide regarding this matter.

Res_Mysql.conf
[general]
dbhost=127.0.0.1
dbname=asteriskDB
dbuser=root
dbpass=123a123A
dbport=3306
----------------------
Extconfig.conf
[setting]
Sippers=>mysql , general , sip_buddies
Extentions=> mysql,general , extensions

----------------------

Sip.conf
[general]

context= from-sip ;
bindport=5060;
bindaddr=0.0.0.0;
disallow=all;
allow=gsm
allow=ulaw
registerattempts=10
registertimeout=20

dbhost=127.0.0.1
dbname=asteriskDB
dbuser=root
dbpass=123a123A
dbport=3306
-----------------------------

Extensions.conf

[general]
dbhost=127.0.0.1
dbname=asteriskDB
dbuser=root
dbpass=123a123A
dbport=3306

[globals];
[from-sip]
Switch =>Realtime
-----------------------------

Modules.conf

Autoload=yes
Load =>res_config_mysql.so
load => func_realtime.so
Load =>app_realtime.so
Load =>pbx_realtime.so
------------------------------------------------------------------------------------------------------------------------------------------

create database if not exists `asteriskDB`;
use asteriskDB;

-----------------------------------------------------------------------------

Create Tables (sip_buddies & Extensions)

CREATE TABLE `sip_buddies` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL,
`callerid` varchar(80) default NULL,
`defaultuser` varchar(80) NOT NULL,
`regexten` varchar(80) NOT NULL,
`secret` varchar(80) default NULL,
`mailbox` varchar(50) default NULL,
`accountcode` varchar(20) default NULL,
`context` varchar(80) default NULL,
`amaflags` varchar(7) default NULL,
`callgroup` varchar(10) default NULL,
`canreinvite` char(3) default 'yes',
`defaultip` varchar(15) default NULL,
`dtmfmode` varchar(7) default NULL,
`fromuser` varchar(80) default NULL,
`fromdomain` varchar(80) default NULL,
`fullcontact` varchar(80) default NULL,
`host` varchar(31) NOT NULL,
`insecure` varchar(4) default NULL,
`language` char(2) default NULL,
`md5secret` varchar(80) default NULL,
`nat` varchar(5) NOT NULL default 'no',
`deny` varchar(95) default NULL,
`permit` varchar(95) default NULL,
`mask` varchar(95) default NULL,
`pickupgroup` varchar(10) default NULL,
`port` varchar(5) NOT NULL,
`qualify` char(3) default NULL,
`restrictcid` char(1) default NULL,
`rtptimeout` char(3) default NULL,
`rtpholdtimeout` char(3) default NULL,
`type` varchar(6) NOT NULL default 'friend',
`disallow` varchar(100) default 'all',
`allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
`musiconhold` varchar(100) default NULL,
`regseconds` int(11) NOT NULL default '0',
`ipaddr` varchar(15) NOT NULL,
`cancallforward` char(3) default 'yes',
`lastms` int(11) NOT NULL,
`useragent` char(255) default NULL,
`regserver` varchar(100) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=893 DEFAULT CHARSET=latin1;
CREATE TABLE `extensions` (
`id` int(11) NOT NULL auto_increment,
`context` varchar(20) NOT NULL default '',
`exten` varchar(20) NOT NULL default '',
`priority` tinyint(4) NOT NULL default '0',
`app` varchar(20) NOT NULL default '',
`appdata` varchar(128) NOT NULL default '',
PRIMARY KEY (`context`,`exten`,`priority`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=257 DEFAULT CHARSET=latin1;

-----------------------------------------------------------------------------

Insert into Tables (sip_buddies & Extensions)



INSERT INTO asteriskDB.sip_buddies (
NAME, defaultuser, secret, context, HOST, nat, qualify, TYPE)
VALUES (
'1000', '1000', '1234', 'from-sip', 'dynamic', 'yes', 'no', 'friend');
;

INSERT INTO asteriskDB.sip_buddies (
NAME, defaultuser, secret, context, HOST, nat, qualify, TYPE)
VALUES (
'2000', '2000', '1234', 'from-sip', 'dynamic', 'yes', 'no', 'friend');



INSERT INTO `extensions`(`context`,`exten`,`priority`,`app`,`appdata`)
values

('from-sip','12121111111',1,'Dial','SIP/1000|60'),
('from-sip','12122222222',1,'Dial','SIP/2000|60');

User avatar
bystander
Apathetic Retiree
Posts: 21590
Joined: Mon Aug 28, 2006 2:06 pm
Location: Oklahoma

Re: Problem with Asterisk13 Realtime Configuration on Centos7

Post by bystander » Thu Nov 12, 2015 9:34 pm

You probably want the Asterisk Project not this forum.

http://www.asterisk.org/
http://wiki.asterisk.org/wiki/
Know the quiet place within your heart and touch the rainbow of possibility; be
alive to the gentle breeze of communication, and please stop being such a jerk.
— Garrison Keillor