How to install Asterisk2billing v1.2.3 in Trixbox v2.2

This document details the process for installing Asterisk2billing version 1.2.3 in Trixbox version 2.2.  Trixbox v2.2 no longer has a2billing installed by default, and I wasn't able to find it in the package manager, so it needs to be installed manually.

SureTeq is now an FtOCC authorized Trixbox support vendor.  We can provide remote support and troubleshooting, or we can design, implement and support your company's complete VoIP PBX solution.  Hourly rates and support contracts are available.  For pricing information and contact details, please email us.

- SureTeq now has a blog/RSS feed!  Subscribe to our blog for tips, tricks, news, and general information about all things Asterisk/Trixbox.  Click here for the SureTeq blog!

Not your version?  Click here to see the index of all SureTeq documentation! - Previous versions and other product documentation.

Download latest A2B tar file

Go to http://www.asterisk2billing.org and scroll to the bottom.  There will be a link for downloading the latest version.  I typically prefer to use wget, but I wasn't able to figure out the direct link to the file as the web page uses php to grab it.  So I downloaded it to my local computer (which has an FTP server) and then FTP'd the file to /usr/src of my Linux box.

Once the file has been downloaded, open your Linux CLI and do the following:

cd /usr/src

mkdir a2billing

mv Asterisk2Billing_release_Chameleon_v1_2_3.tar.gz a2billing (substitute filename with latest version's filename)

cd a2billing

tar zxvf Asterisk2Billing_release_Chameleon_v1_2_3.tar.gz

ls -la

You should now see a 'trunk' directory...it has been successfully extracted, and it is now time to start the upgrade.

Create the database

cd /usr/src/a2billing/trunk/DataBase/mysql/Mysql-3.x_4.x

mysql -u root -ppassw0rd < a2billing-MYSQL-createdb-user.sql (this assumes your mysql root password is the default 'passw0rd.')

mysql -u root -ppassw0rd mya2billing < a2billing-mysql-schema-MYSQL.3.X-4.X_v1.2.3.sql

Done!  Your a2b v1.2.3 database has been created!

Install HTTP UI

The following commands will install the web UI. 

Administration console:

cd /var/www/html

mkdir a2billing

chown –R asterisk: a2billing

cd a2billing

cp -r /usr/src/a2billing/trunk/A2Billing_UI/. .

User console:

cd /var/www/html

mkdir a2customer

chown –R asterisk: a2customer

cd a2customer

cp –r /usr/src/a2billing/trunk/A2BCustomer_UI/. .

Install AGI

The AGI files are how a2b speaks to Asterisk/Trixbox.  They consist of the libs_a2billing directory and the a2billing.php file.

cd /var/lib/asterisk/agi-bin

cp /usr/src/a2billing/trunk/A2Billing_AGI/a2billing.php .

cp -r /usr/src/a2billing/trunk/A2Billing_AGI/libs_a2billing .

chown asterisk: a2billing.php

chown –R asterisk: libs_a2billing

Install a2billing.conf file

cd /etc/asterisk

mv a2billing.conf a2billing_old.conf (for some reason, the a2billing.conf file still exists in Trixbox v2.2, so let's back it up).

cp /usr/src/a2billing/trunk/a2billing.conf .

chown asterisk: a2billing.conf

Change database type from postgres to mysql

nano /etc/asterisk/a2billing.conf

In [database] section, change:

dbtype=postgres

;dbtype=mysql

To:

;dbtype=postgres

dbtype=mysql

CTRL+X to exit nano, and then Y when asked to save.

Log into A2B

Open http://<asterisk IP>/a2billing in a browser.

Default username and password are:  admin / mypassword

All done!  I would recommend changing your admin password immediately for security.

Go to Administrator --> Show Administrator.  Click 'Edit' to the left of the admin login and change the password field to the new password.  Do the same for the root user.

That's it!

For a good step-by-step document on setting up a2billing from here, see http://www.sureteq.com/asterisk/a2bv1.2.3.htm.