Installing VoipMonitor on Trixbox and Elastix
Using Internet SIP trunking services with a VOIP phone system is incredibly cost effective. The only problem is the unreliability of the Internet. We’ve been expreimenting with several tools for monitoring phone call quality but VoipMonitor has been the most useful. Some of the most useful features are:
- Creates packet capture of each phone call. This is really useful because you get more manageable capture files, not one monster files containing all calls.
- It logs all calls to a MySQL database and calculates several important metrics like MOS. If you need an example of a bad quality call to send to your provider you can just sort the call table by MOS. Anything under 4.0 probably has some jitter or lag in the audio.
Here are the steps to install VoipMonitor (these are just slightly modified from http://www.voipmonitor.org/):
Install all dependencies through yum.
yum install subversion libmysql++-dev libvorbis-devel mysql-devel libpcap-devel php5-mysql php5-gd
Install libpcap. You need a version > 1.0 so the version in the yum repo is not current enough.
wget http://www.tcpdump.org/release/libpcap-1.1.1.tar.gz tar xzf libpcap-1.1.1.tar.gz cd libpcap* ./configure make make install
Install the mysql client that VoipMonitor uses to connect to MySQL
wget http://tangentsoft.net/mysql++/releases/mysql++-3.0.9.tar.gz tar xzf mysql++-3.0.9.tar.gz cd mysql++-3.0.9 ./configure make install ldconfig cp /usr/local/lib/libmysqlpp.so.3 /usr/lib/
Install VoipMonitor
wget http://dl.nvthost.com/downloads/voipmonitor-3.0.1.tar.gz tar zxf voipmonitor-2.0.tar.gz cd ../voipmonitor-2.0 make make install cp /usr/local/lib/libpcap.* /usr/lib
Next you need to create the MySQL database. Here we use the mysql command line client. You can also use phpMyAdmin or Webmin if you have access to it.
We always specify a MySQL root user password during the installation of Trixbox and Elastix so we just log in as the root user. Use mysql -u root and then you will be prompted for a password.
mysql
mysql> create database voipmonitor;
mysql> exit
Create the database tables.
cat cdrtable.sql | mysql voipmonitor
Start up VoipMonitor. The u and p switches are for the MySQL username and password. Call VoipMonitor with no arguments to see a list of possible command line switches.
voipmonitor -i eth0 -SRG -h localhost -b voipmonitor -u root -p passw0rd
Comments
i am getting this error at phase of installtion of Install the mysql client that VoipMonitor uses to connect to MySQL.
i am using Elatix server
Elastix
elastix 2.3.0 10
elastix-firstboot 2.3.0 9
elastix-reports 2.3.0 8
elastix-a2billing 1.9.4 5
elastix-asterisk-sounds 1.2.3 1
elastix-security 2.3.0 8
elastix-portknock 0.0.1 0
elastix-agenda 2.3.0 9
elastix-email_admin 2.3.0 11
elastix-addons 2.3.0 7
elastix-im 2.3.0 1
elastix-vtigercrm 5.2.1 7
elastix-fax 2.3.0 7
elastix-pbx 2.3.0 18
elastix-callcenter 2.1.99 6.alpha
elastix-framework 2.3.0 16
elastix-my_extension 2.3.0 1
elastix-extras 2.3.0 1
elastix-system 2.3.0 15
Linux localhost 2.6.18-308.el5 #1 SMP Tue Feb 21 20:06:06 EST 2012 x86_64 x86_64 x86_64 GNU/Linux on virtualbox
Error occurring
checking whether -lnsl is needed… no
checking for MySQL library directory… configure: error: Didn’t find mysqlclient library in ‘/usr/lib64 /usr/lib /usr/lib64/mysql /usr/lib/mysql /usr/local/lib64 /usr/local/lib /usr/local/lib/mysql /usr/local/mysql/lib /usr/local/mysql/lib/mysql /usr/mysql/lib/mysql /opt/mysql/lib /opt/mysql/lib/mysql /sw/lib /sw/lib/mysql’
any solution for that
thanks in advance
Make sure you run the first command to install all the requirements:
yum install subversion libmysql++-dev libvorbis-devel mysql-devel libpcap-devel php5-mysql php5-gd