Note:*****This Tutorial is incomplete
This is an Asterisk Realtime setup from start to finish.
First follow the tutorial Basic Net Installation.(time approx. 20 minutes)
apt-get update
apt-get install ssh ntp build-essential
apt-get install libncurses5-dev mysql-client libmysqlclient15-dev
Let’s install XAMPP (APACHE MYSQL PHPMYADMIN and FTP, SSL)
mkdir /opt/
cd /opt
wget http://www.apachefriends.org/download.php?xampp-linux-1.6.7.tar.gz
tar xvfz xampp-linux-1.6.7.tar.gz -C /opt
Start:
/opt/lampp/lampp start
To auto start,
Find your default runlevel by issuing this command:
egrep :initdefault: /etc/inittab
then goto the appropriate directory eg.: cd /etc/rc2.d/
and run these two commands:
ln -s /opt/lampp/lampp S99lampp
ln -s /opt/lampp/lampp K01lampp
then reboot to test.
Now let’s setup MySQL:
open your favorite browser and access:
http://server-ip-address/phpmyadmin
Please replace server-ip-address with your server’s ip address
Then click on SQL button second TOP-LEFT under the logo phpMyAdmin
enter the following code
create user asterisk identified by 'asterisk';
create database asterisk;
UPDATE mysql.user SET Password=PASSWORD('***') WHERE User='asterisk' AND Host='localhost';
GRANT ALL PRIVILEGES ON *.* TO 'asterisk'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
FLUSH PRIVILEGES;
Then click the GO button DOWN-RIGHT of the window
Now let’s enter the appropriate tables:
Same as before, click on SQL button and enter the following code:
use asterisk;
CREATE TABLE IF NOT EXISTS `sipusers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default ”,
`accountcode` varchar(20) default NULL,
`amaflags` varchar(7) default NULL,
`callgroup` varchar(10) default NULL,
`callerid` varchar(80) default NULL,
`canreinvite` char(3) default ‘yes’,
`context` varchar(80) default NULL,
`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 default ”,
`insecure` varchar(4) default NULL,
`language` char(2) default NULL,
`mailbox` varchar(50) 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 default ”,
`qualify` char(3) default NULL,
`restrictcid` char(1) default NULL,
`rtptimeout` char(3) default NULL,
`rtpholdtimeout` char(3) default NULL,
`secret` varchar(80) default NULL,
`type` varchar(6) NOT NULL default ‘friend’,
`username` varchar(80) NOT NULL default ”,
`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 default ”,
`regexten` varchar(80) NOT NULL default ”,
`cancallforward` char(3) default ‘yes’,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `cdr` (
`calldate` datetime NOT NULL default ’0000-00-00 00:00:00′,
`clid` varchar(80) NOT NULL default ”,
`src` varchar(80) NOT NULL default ”,
`dst` varchar(80) NOT NULL default ”,
`dcontext` varchar(80) NOT NULL default ”,
`channel` varchar(80) NOT NULL default ”,
`dstchannel` varchar(80) NOT NULL default ”,
`lastapp` varchar(80) NOT NULL default ”,
`lastdata` varchar(80) NOT NULL default ”,
`duration` int(11) NOT NULL default ’0′,
`billsec` int(11) NOT NULL default ’0′,
`disposition` varchar(45) NOT NULL default ”,
`amaflags` int(11) NOT NULL default ’0′,
`accountcode` varchar(20) NOT NULL default ”,
`userfield` varchar(255) NOT NULL default ”,
KEY `calldate` (`calldate`),
KEY `dst` (`dst`),
KEY `calldate_2` (`calldate`),
KEY `dst_2` (`dst`),
KEY `accountcode` (`accountcode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `voicemail_users` (
`uniqueid` int(11) NOT NULL auto_increment,
`customer_id` varchar(11) NOT NULL default ’0′,
`context` varchar(50) NOT NULL default ”,
`mailbox` varchar(11) NOT NULL default ’0′,
`password` varchar(5) NOT NULL default ’0′,
`fullname` varchar(150) NOT NULL default ”,
`email` varchar(50) NOT NULL default ”,
`pager` varchar(50) NOT NULL default ”,
`tz` varchar(10) NOT NULL default ‘central’,
`attach` varchar(4) NOT NULL default ‘yes’,
`saycid` varchar(4) NOT NULL default ‘yes’,
`dialout` varchar(10) NOT NULL default ”,
`callback` varchar(10) NOT NULL default ”,
`review` varchar(4) NOT NULL default ‘no’,
`operator` varchar(4) NOT NULL default ‘no’,
`envelope` varchar(4) NOT NULL default ‘no’,
`sayduration` varchar(4) NOT NULL default ‘no’,
`saydurationm` tinyint(4) NOT NULL default ’1′,
`sendvoicemail` varchar(4) NOT NULL default ‘no’,
`delete` varchar(4) NOT NULL default ‘no’,
`nextaftercmd` varchar(4) NOT NULL default ‘yes’,
`forcename` varchar(4) NOT NULL default ‘no’,
`forcegreetings` varchar(4) NOT NULL default ‘no’,
`hidefromdir` varchar(4) NOT NULL default ‘yes’,
`stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`uniqueid`),
KEY `mailbox_context` (`mailbox`,`context`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
apt-get install linux-headers-$(uname -r) bison openssl libssl-dev libeditline0 libeditline-dev libedit-dev gcc make g++ mc php5-cli
And Realtime dependancies:
apt-get install ssh ntp build-essential
apt-get install libncurses5-dev mysql-client libmysqlclient15-dev
Next, you need to follow the tutorial Asterisk PBX.(time approx. 20 minutes)
Take note that the software versions might have changed and make sure you download in the directory /opt
Then come back here!
