Debian Resources

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 `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!