Asterisk CDR in MySQL

Install Mysql Server and MysqlClient

apt-get install php5-mysql mysql-client-5.0 mysql-client libmysqlclient15-de mysql-server mysql-common

Install Asterisk-Addons

cd /usr/src

wget http://downloads.asterisk.org/pub/telephony/asterisk/asterisk-addons-1.4.9.tar.gz

tar xvzf asterisk-addons-1.4.9.tar.gz

cd asterisk-addons*

./configure

make menuselect

select:

–> 1. Applications
[*] 1. app_addon_sql_mysql
–> 2. Call Detail Recording
[*] 1. cdr_addon_mysql

make && make install

Create Database

mysql -u root -p

CREATE DATABASE asterisk;

GRANT INSERT
ON asterisk.*
TO asterisk@localhost
IDENTIFIED BY ’yourpassword’;

USE asterisk;

CREATE TABLE `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 ”
);

ALTER TABLE `cdr` ADD `uniqueid` VARCHAR(32) NOT NULL default ”;
ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );

Configure Asterisk CDR Mysql

vim /etc/asterisk/cdr.conf

[general]

enabled=yes

vim /etc/asterisk/cdr_mysql.conf

[global]
hostname=localhost
dbname=asterisk
table=cdr
password=”yourpassword”
user=asterisk
port=3306
;sock=/tmp/mysql.sock
;userfield=1

vim /etc/asterisk/modules.conf

load => cdr_addon_mysql.so

Restarting Asterisk

asterisk -r

CLI> restart when convenient

CLI > asterisk -r

CLI > cdr mysql status
Connected to asterisk@localhost, port 3306 using table cdr for 1 minutes, 28 seconds.
Wrote 0 records since last restart.

This it all..

Asterisk VoIP Security

I leave here a link to the webinar on security in asterisk that took place last Friday. The speakers were an FBI agent, an expert from VOIPSA and two employee of the company Digium.

very interesting ..

Provisioning Linksys SPA922

When I started in the world of Asterisk, one of the important things to deploy a VoIP network is the segmentation of the network VLANs to separate voice and data. When I started two years ago, only knew two options:

- Use different network but this implies duplicate the number of the switches (much money and in my opinion unprofessional).
- Use VLAN’s to separate the networks. This option is better although requires much administrative work whenever there is change a site computer or telephone.

I was investigating the way this is done automatically and it seems that something went.

Here I leave an example implementation.

In this scenario We are going to configure a system to provisioning Linksys Phones (SPA922). Firts We have to configure our network LAN with 2 vlans (or more) to separate the data and voice network. We have used Cisco Switches (Catalyst 2960 and 3750).

Networking

The IP range ov Vlans are this:

Vlan 1 -> data network -> 192.168.1.0/24
Vlan 2 -> voice network -> 10.3.3.0/24

We need to have two DHCP servers, one in each vlan. In the vlan 1 we have configured one DHCP server (Windows 2003 Server) which will be the principal DHCP server. This is the configuration:

003 Router 192.168.1.1
006 DNS Servers 192.168.1.5 192.168.1.6
015 DNS Domain Name testing.lan.com
044 WINS/NBNS Servers 192.168.1.5
046 WINS/NBNS Node Type 0×8
066 Boot Server Host Name 10.3.3.3 (TFTP Server)

In the other Vlan (voIP), we have Asterisk server with DHCP server and TFTP Server. These are the configs:

apt-get install dhcpd

/etc/dhcp3# vim dhcpd.conf

subnet 10.3.3.0 netmask 255.255.255.0
{
range 10.3.3.100 10.3.3.254;
option domain-name-servers 192.168.1.6;
option routers 10.3.3.1;
option subnet-mask 255.255.255.0;
option broadcast-address 10.3.3.255;
option tftp-server-name "10.3.3.3";
default-lease-time 600;
max-lease-time 7200;
}

Provisioning

apt-get install atftpd

/etc/default# vim atftpd

USE_INETD=true
OPTIONS="--daemon --port 69 --tftpd-timeout 300 --retry-timeout 5 --mcast-port 1758 --mcast-addr 239.239.239.0-255 --mcast-ttl 1 --maxthread 100 --verbose=5 /tftpboot"

The tftp server configuration file indicates that the config are int tftpboot directory where we have configured the general config file for all phones and the especific config files to the phones too.

/etc/tftpboot# vim spa922.cfg

<flat-profile>

<!-- PROVISIONING -->
<Resync_Periodic>10</Resync_Periodic>
<Resync_Error_Retry_Delay>20</Resync_Error_Retry_Delay>
<Profile_Rule ua="na">/spa922-MAC/spa922-$MA.cfg</Profile_Rule>

<!-- SYSTEM -->
<Primary_NTP_Server ua="na">192.168.1.10</Primary_NTP_Server>
<Time_Zone ua="na">GMT+01:00</Time_Zone>

<!-- TIMERS -->
<Interdigit_Long_Timer ua="na">25</Interdigit_Long_Timer>

<!-- SIP -->
<Proxy_1_>10.3.3.3</Proxy_1_>

<Use_Auth_ID_1_ ua="na">No</Use_Auth_ID_1_>
<Preferred_Codec_1_>G711a</Preferred_Codec_1_>
<Use_Pref_Codec_Only_1_>no</Use_Pref_Codec_Only_1_>

<Dial_Plan_1_ ua="na">([1345]xxxS0|6xxxxxxxxS0|9xxxxxxxxS0|xx.)</Dial_Plan_1_>
<Enable_IP_Dialing_1_ ua="na">No</Enable_IP_Dialing_1_>

<Enable_VLAN ua="rw"> yes </Enable_VLAN>
<VLAN_ID ua="rw"> 2 </VLAN_ID>

</flat-profile>

Debian “Etch” + Asterisk + Asterisk-Addons + Zaptel + Libpri + mISDN + Asterisk-GUI

This Howto is to install Asterisk on a fresh Debian “Etch” system.
After download a netinstall image of Debian 4.0r1 and configure localization, language, partitions and so on, in the final steps, debian should now be asking you what packages you want installed.

Choose base system only.

After finish installation and first reboot, login with root and:

aptitude update
aptitude upgrade

reboot

aptitude install ssh ntp

From here, the next steps were done from a ssh session with putty client.

Compiling New Custom Kernel *** Optional ***

aptitude install kernel-package libncurses5-dev fakeroot wget bzip2 build-essential

cd /usr/src

wget http://www.kernel.org/pub/linux/kernel/v2.6/linux-2.6.23.12.tar.bz2

tar xjf linux-2.6.*

ln -s /usr/src/linux-2.6.23.12 /usr/src/linux

cd /usr/src/linux

Copy the current kernel configuration to /usr/src/linux

make clean && make mrproper

cp /boot/config-`uname -r` ./.config

make menuconfig

In the configuration menu, we select “Load alternate configuration…” and choose the config file that we have copy in the /usr/src/linux directory. /usr/src/linux/.config

We are going to modify some parameters in the kernel configuration:

In the subsection “Processor type and features” we check:

“Enable IRQ balancing” is disabled
“Timer frequency” change the value 250 Hz by 1000 Hz.
“High Resolution Timer Option” and “HPET Timer Support” as built-in.
For users with NVidia SATA drives unchek “Paravirtualization Support”.

And under “Library Routines” subsection, “CONFIG_CRC_CCITT” must be enabled.

When we had made this changes we save the configuration and exit.

Building the new .deb kernel and headers packages :

make-kpkg clean
fakeroot make-kpkg –initrd –append-to-version=-custom kernel_image kernel_headers

After the compilation will be two .deb packages under directory /usr/src/

Install the new packages.

cd /usr/src
dpkg -i linux-image-2.6.23.12-custom_2.6.23.12-custom-10.00.Custom_i386.deb
dpkg -i linux-headers-2.6.23.12-custom_2.6.23.12-custom-10.00.Custom_i386.deb

reboot

Test the new kernel is loaded.

uname -a

The output must be something similar to “Linux asterisk 2.6.23.12-custom“

*** Finish *** Optional *** Compiling Custom Kernel

Go for dependencies…

aptitude install build-essential libcurl3-dev libvorbis-dev libspeex-dev unixodbc unixodbc-dev libiksemel-dev flex xsltproc

aptitude install linux-headers-`uname -r` g++ libncurses5-dev libnewt-dev libusb-dev subversion git-core

Downloading and untarring…

cd /usr/src

wget http://downloads.digium.com/pub/asterisk/asterisk-1.4-current.tar.gz
wget http://downloads.digium.com/pub/zaptel/zaptel-1.4-current.tar.gz
wget http://downloads.digium.com/pub/libpri/libpri-1.4-current.tar.gz
wget http://www.misdn.org/downloads/mISDN.tar.gz
wget http://www.misdn.org/downloads/mISDNuser.tar.gz
wget http://downloads.digium.com/pub/asterisk/releases/asterisk-addons-1.4.5.tar.gz

tar xvzf asterisk-1.4-current.tar.gz && tar xvzf zaptel-1.4-current.tar.gz && tar xvzf libpri-1.4-current.tar.gz && tar xvzf mISDN.tar.gz && tar xvzf mISDNuser.tar.gz && tar xvzf asterisk-addons-1.4.5.tar.gz

Installing Zaptel

cd /usr/src/zaptel-1.4*
./install_prereq test
./install_prereq install

./configure
make
make install
make config
modprobe ztdummy

Installing Libpri

cd /usr/src/libpri-1.4*
make && make install

Installing mISDN

Note: The current version (1.1.7) not compile with the last kernel (2.6.23.12). The (2.6.18.10) is tested that works.

cd /usr/src/mISDN
make
make install
cd /usr/src/mISDNuser/
make && make install

Configuring…

mISDN scan
mISDN config

This creates the file /etc/mISDN.conf which you should review and/or edit.

vi /etc/mISDN.conf

If everything looks good, going to start mISDN

mISDN start

and check everything is right,

misdnportinfo

Running on startup…

/usr/sbin/update-rc.d mISDN defaults 15 30

Installing Asterisk

cd /usr/src/asterisk-1.4*
./configure

The next step is not mandatory. For install core and extra sounds in different languages:

make menuselect

select the core-sounds you would like to play and extra sounds. Exit with “x” to save.

make
make install
make samples
make config
asterisk -vvvc
stop now
echo “ztdummy” >> /etc/modules

Note: If you make a mistake and/or fail compilation, you need to run:

make clean then ./configure and make install again.

Going to reboot for test the system startup is correct.

reboot

asterisk -r
exit

Install Asterisk-Addons

cd /usr/src/asterisk-addons*

./configure && make && make install

make samples

Install Asterisk-GUI

If you have asterisk config files (no new install), backup it…

cp -r /etc/asterisk /etc/asterisk.bak

Download and install Asterisk-GUI

cd /usr/src
svn checkout http://svn.digium.com/svn/asterisk-gui/trunk asterisk-gui
cd /usr/src/asterisk-gui
./configure && make && make install
make samples

Some tweaks to configuration files…

cat << EOF >/etc/asterisk/http.conf
[general]
enabled=yes
enablestatic=yes
EOF

cat << EOF >/etc/asterisk/manager.conf
[general]
displaysystemname = yes
enabled = yes
webenabled = yes
port = 5038
;httptimeout = 60
bindaddr = 0.0.0.0

[admin]
secret = admin
read = system,call,log,verbose,command,agent,config
write = system,call,log,verbose,command,agent,config
EOF

Checking configuration…

make checkconfig

asterisk -r
reload
exit

Try, configure and enjoy your new system… with admin/admin login or your setup config…

http://IPADDRESS:8088/asterisk/static/config/setup/install.html
http://IPADDRESS:8088/asterisk/static/config/cfgbasic.html