Here is my script to install A2Billing 1.6.0 in Elastix, this script can help you to quick install the latest A2Billing version in your Elastix System.

script name: a2billing-1.6.0.sh


#!/bin/sh

echo "This is the Elastix A2Billing setup script"
echo ""

# Step1: Removing A2billing Old files
rm -f -R /var/www/html/a2billing/
rm -f -R /var/www/html/a2customer/
rm -f -R /var/lib/asterisk/agi-bin/a2billing.php
rm -f -R /var/lib/asterisk/agi-bin/libs_a2billing/
rm -f -R /var/lib/asterisk/agi-bin/lib/
rm -f -R /etc/asterisk/additional_a2billing_iax.conf
rm -f -R /etc/asterisk/additional_a2billing_sip.conf
rm -f /etc/asterisk/a2billing.conf
rm -f /etc/a2billing.conf
rm -f -R /var/www/html/agent/
rm -f -R /var/www/html/common/
rm -f -R /usr/src/a2billing/

# Drop the old database (if it exists)
mysqladmin drop mya2billing -u root -peLaStIx.2oo7


# Step2: A2billing installation
cd /usr/src
mkdir a2billing
cd a2billing
wget www.asterisk2billing.org/downloads/A2Billing_1.6.0.tar.gz
tar -xzf A2Billing_1.6.0.tar.gz
chown -R root:root /usr/src/a2billing


mysql -u root -peLaStIx.2oo7 < /usr/src/a2billing/DataBase/mysql-5.x/a2billing-createdb-user.sql
mysql mya2billing -u root -peLaStIx.2oo7 < /usr/src/a2billing/DataBase/mysql-5.x/a2billing-schema-v1.4.0.sql

mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.0-to-v1.4.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.1-to-v1.4.2.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.2-to-v1.4.3.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.3-to-v1.4.4.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.4-to-v1.4.4.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.4.1-to-v1.4.5.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.5-to-v1.5.0.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.5.0-to-v1.5.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.5.1-to-v1.6.0.sql

# Step3: A2billing web interfaces installation
cp -rf /usr/src/a2billing/customer /var/www/html/a2customer
chmod 777 /var/www/html/a2customer/templates_c
cp -rf /usr/src/a2billing/agent /var/www/html
chmod 777 /var/www/html/agent/templates_c
cp -rf /usr/src/a2billing/admin /var/www/html/a2billing
chmod 777 /var/www/html/a2billing/templates_c
cp -Rf /usr/src/a2billing/common /var/www/html

cp /usr/src/a2billing/AGI/a2billing.php /var/lib/asterisk/agi-bin/
cp -rf /usr/src/a2billing/common/lib /var/lib/asterisk/agi-bin/
chmod +x /var/lib/asterisk/agi-bin/a2billing.php
chown -R asterisk:asterisk /var/lib/asterisk/agi-bin

# Step4: A2billing configuration files
cp /usr/src/a2billing/a2billing.conf /etc/asterisk
chown asterisk:asterisk /etc/asterisk/a2billing.conf
ln -sf /etc/asterisk/a2billing.conf /etc/a2billing.conf

sed -i "s/\(port *= *\)\(.*\)/\13306/" /etc/asterisk/a2billing.conf
sed -i "s/\(user *= *\)\(.*\)/\1a2billinguser/" /etc/asterisk/a2billing.conf
sed -i "s/\(password *= *\)\(.*\)/\1a2billing/" /etc/asterisk/a2billing.conf
sed -i "s/\(dbname *= *\)\(.*\)/\1mya2billing/" /etc/asterisk/a2billing.conf


mkdir -p /var/lib/asterisk/mohmp3/acc_1
mkdir -p /var/lib/asterisk/mohmp3/acc_2
mkdir -p /var/lib/asterisk/mohmp3/acc_3
mkdir -p /var/lib/asterisk/mohmp3/acc_4
mkdir -p /var/lib/asterisk/mohmp3/acc_5
mkdir -p /var/lib/asterisk/mohmp3/acc_6
mkdir -p /var/lib/asterisk/mohmp3/acc_7
mkdir -p /var/lib/asterisk/mohmp3/acc_8
mkdir -p /var/lib/asterisk/mohmp3/acc_9
mkdir -p /var/lib/asterisk/mohmp3/acc_10
chmod 777 /var/lib/asterisk/mohmp3/acc_*
chown -R asterisk:asterisk /var/lib/asterisk/mohmp3/

# A2billing Extra sounds
cd /usr/src/a2billing/addons/sounds
./install_a2b_sounds.sh

# Step6: Asterisk files
cd /etc/asterisk/
touch additional_a2billing_iax.conf
touch additional_a2billing_sip.conf
touch extensions_a2billing.conf

echo "#include additional_a2billing_sip.conf" >> /etc/asterisk/sip_custom.conf
echo "#include additional_a2billing_iax.conf" >> /etc/asterisk/iax_custom.conf
echo -e >> /etc/asterisk/extensions_custom.conf
echo "#include extensions_a2billing.conf" >> /etc/asterisk/extensions_custom.conf

# Step7: A2billing file permissions
chmod 666 /etc/asterisk/additional_a2billing_iax.conf
chmod 666 /etc/asterisk/additional_a2billing_sip.conf
chmod 666 /etc/asterisk/extensions_a2billing.conf
chown -R asterisk:asterisk /etc/asterisk/
chown -R asterisk:asterisk /var/www/html/common
chown -R asterisk:asterisk /var/www/html/a2billing
chown -R asterisk:asterisk /var/www/html/a2customer
chown -R asterisk:asterisk /var/www/html/agent
chown -R asterisk:asterisk /var/lib/asterisk/


# Cronjobs

echo "
# Automatically added for A2Billing
0 * * * * php /usr/src/a2billing/Cronjobs/a2billing_alarm.php
0 12 * * * php /usr/src/a2billing/Cronjobs/a2billing_archive_data_cront.php
0 10 21 * * php /usr/src/a2billing/Cronjobs/a2billing_autorefill.php
#Batch process at 00:20 each day
20 0 * * * php /usr/src/a2billing/Cronjobs/a2billing_batch_process.php
#Bill DID usage at 00:00 each day
0 0 * * * php /usr/src/a2billing/Cronjobs/a2billing_bill_diduse.php
#Remind users of low balance every day at 06:00
0 6 * * * php /usr/src/a2billing/Cronjobs/a2billing_check_account.php
#Generate Invoices at 7am everyday
#0 7 * * * php /usr/src/a2billing/Cronjobs/a2billing_invoice2_cront.php
#0 7 * * * php /usr/src/a2billing/Cronjobs/a2billing_invoice_cront.php
#Check if balance below preset value, and email user if so.
1 * * * * php /usr/src/a2billing/Cronjobs/a2billing_notify_account.php
#Charge subscriptions at 06:05 on the 1st of each month
0 6 1 * * php /usr/src/a2billing/Cronjobs/a2billing_subscription_fee.php
#Update currencies at 01:00 each day
0 1 * * * php /usr/src/a2billing/Cronjobs/currencies_update_yahoo.php
" >> /var/spool/cron/asterisk

# Create Log Files
# Log files and Permissions

mkdir -p /var/log/a2billing

touch /var/log/asterisk/a2billing-daemon-callback.log
touch /var/log/a2billing/a2billing-daemon-callback.log
touch /var/log/a2billing/cront_a2b_alarm.log
touch /var/log/a2billing/cront_a2b_autorefill.log
touch /var/log/a2billing/cront_a2b_batch_process.log
touch /var/log/a2billing/cront_a2b_bill_diduse.log
touch /var/log/a2billing/cront_a2b_subscription_fee.log
touch /var/log/a2billing/cront_a2b_currency_update.log
touch /var/log/a2billing/cront_a2b_invoice.log
touch /var/log/a2billing/cront_a2b_check_account.log
touch /var/log/a2billing/a2billing_paypal.log
touch /var/log/a2billing/a2billing_epayment.log
touch /var/log/a2billing/api_ecommerce_request.log
touch /var/log/a2billing/api_callback_request.log
touch /var/log/a2billing/a2billing_agi.log

chown asterisk:asterisk /var/log/asterisk/a2billing-daemon-callback.log
chown -R asterisk:asterisk /var/log/a2billing

Best Regards,

Saleh

Thanks! I've been working on it; first trying to install the 1.5 version, and suddenly the 1.6 come out the light the 16th of this February! One question, Saleh: What about the callback daemon? i dont see that funcionality in your script (only in the last part of the script is mentioned..)Dont you consider this necessary?

Regards,

Ivanof M.G.
Inteliredes Colombia
www.inteliredes.com

The scritp seems work well but at the login, I've this: (with php debug)


Connection failed

Now I can't use A2b.

Regards

Good Morning Franck.


Don't know yet (I was going to try it tomorrow)

but maybe

sed -i "s/(port *= *)(.*)/13306/" /etc/asterisk/a2billing.conf

is a perhaps a typo saleh?

sed -i "s/(port *= *)(.*)/3306/" /etc/asterisk/a2billing.conf

perchance?


dicko

If Y look at the config and the data base, there's some difference:
/etc/asterisk/a2billing.conf

[database]
hostname = localhost
; port for postgres is 5432 by default
port =
user = a2billing_dbuser
password = a2billing_dbpassword

dbname = a2billing_dbname
; dbtype setting can either be mysql or postgres
dbtype = mysql

With this, it seems that ok, but the account admin is deleted.

[database]
hostname = localhost
; port for postgres is 5432 by default
port =
; user = a2billing_dbuser
user = root
;password = a2billing_dbpassword
password = eLaStIx.2oo7

;dbname = a2billing_dbname
dbname = mya2billing
; dbtype setting can either be mysql or postgres
dbtype = mysql

Now it seems that root instead of admin
the root password is changepassword

Lots of config problem after using your script.

It's normal?

Regards

mysql here in Elastix world, which is 3306 not 13306, no?



(I read the script, and I might add it is a delightful script, but haven't run it yet so maybe I should STFU till then )

respectfully,

dicko

[edit]

so the ( ) and 1 's in the sed scripts need escaping with a backslash , it's the stupid board code here un-escaping the escape characters unless you escape the escape characters them-selves either inside or outside a \[code\] block how dumb is that!!


sed -i "s/\\(port *= *\\)\\(.*\\)/\\13306/" /etc/asterisk/a2billing.conf
sed -i "s/\\(user *= *\\)\\(.*\\)/\\1a2billinguser/" /etc/asterisk/a2billing.conf
sed -i "s/\\(password *= *\\)\\(.*\\)/\\1a2billing/" /etc/asterisk/a2billing.conf
sed -i "s/\\(dbname *= *)\\(.*\\)/\\1mya2billing/" /etc/asterisk/a2billing.conf

The script works without any problem tested in many Elastix System, the problem is in Joomla. To download the script

wget www.linuxsolutions.ps/a2billing-1.6.0.sh
chmod +x a2billing-1.6.0.sh
./a2billing-1.6.0.sh


>> Now it seems that root instead of admin
>> the root password is changepassword
>> Lots of config problem after using your script.
>> It's normal?

Yes, it's normal, there is a difference between the A2Billing version 1.3 and A2Billing versions 1.4.x , 1.5.x and 1.6.x

For A2Billing 1.6.0 default administration user is root and the password is changepassword and all configuration are in Data Base and you can configure it via the A2Billing web interface under the menu "SYSTEM SETTINGS"

Best Regards,

Saleh

Yes. ok it's right since tomorrow.

Good news, there's the French translation, I'm happy.

So, good work Saleh.

Best regards

Hi Dicko.

Tonight, I'm very tired, I made a little garden shed.
Arghhhh! I hurt my back.

I have modified the original script made by Saleh, combined with the instructions contained in the helpfile Centos.Install included in the sources of the 1.6 version; and some additional features from an existing a2billing install script, posted by Johnatan Roper in the a2billing forum. The main differences between the original and this one are the callback-daemon init scrit, the installation of sqlalchemy with easy_install tool, plus some python stuffs. Also added some recommended macros and few changes in the custom_dest table in the asterisk db. Fully functional for my production server actually. Any feedback about will be well received. The credits must be to Saleh and Johnatan Roper. (Cited in the script too...)

Regards;

Ivanof M.G.
InteliRedes Colombia S.A.S.
www.inteliredes.com.

And why not but, what happen if I already to run the first script?

Regards