|
Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 0
|
|
Hello to all,
It wanted to update the version of 1.3.0 to 1.7.1
I need instructions
I have tried with several systems that encontre but then not finciona and I have to format and to begin again.
Thank you for the HELP.
Hola a todos,
Quisiera actualizar la version de 1.3.0 a la 1.7.1
Necesito instrucciones
He intentado con varios sistemas que encontre pero luego no finciona y tengo que formatear y comenzar de nuevo.
Gracias por la AYUDA.
|
|
|
|
|
|
|
Re:Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 97
|
I have just finished a procedure to install the a2billing 1.7.1, as I said, to install NOT to update.
I have based the following steps based on the information provided by saleh at:
www.elastix.org/index.php/en/component/k...ipt-for-elastix.html
| Code: |
1. yum -y install perl-DBD-Pg subversion
2. mkdir /usr/local/src/a2billing
3. cd /usr/local/src/a2billing
4. svn co --username guest --password guest http://svn.a2billing.net/svn/asterisk2billing/trunk/ /usr/local/src/a2billing
5. cp /usr/local/src/a2billing/a2billing.conf /etc/
6. vim /etc/a2billing.conf
Inside the database section, leave those values, like these ones:
port = 5432
user = a2billinguser
password = a2billing
dbname = mya2billing
7. chown asterisk:asterisk /etc/a2billing.conf
8. chmod 664 /etc/a2billing.conf
9. cd /usr/local/src/a2billing/DataBase/mysql-5.x
10. mysqladmin drop mya2billing -u root -peLaStIx.2oo7
11. mysql -u root -peLaStIx.2oo7 < /usr/local/src/a2billing/DataBase/mysql-5.x/a2billing-createdb-user.sql
12.
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/a2billing-schema-v1.4.0.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.0-to-v1.4.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.1-to-v1.4.2.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.2-to-v1.4.3.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.3-to-v1.4.4.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.4-to-v1.4.4.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.4.1-to-v1.4.5.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.5-to-v1.5.0.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.5.0-to-v1.5.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.5.1-to-v1.6.0.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.6.0-to-v1.6.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.6.1-to-v1.6.2.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.6.2-to-v1.7.0.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.7.0-to-v1.7.1.sql
mysql mya2billing -u root -peLaStIx.2oo7 </usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.7.1-to-v1.7.2.sql
13.
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 -R /var/www/html/agent/
rm -f -R /var/www/html/common/
rm -f -R /usr/src/a2billing/
14.
cp -rf /usr/local/src/a2billing/customer /var/www/html/a2customer
chmod 777 /var/www/html/a2customer/templates_c
cp -rf /usr/local/src/a2billing/agent /var/www/html
chmod 777 /var/www/html/agent/templates_c
cp -rf /usr/local/src/a2billing/admin /var/www/html/a2billing
chmod 777 /var/www/html/a2billing/templates_c
cp -Rf /usr/local/src/a2billing/common /var/www/html
cp /usr/local/src/a2billing/AGI/a2billing.php /var/lib/asterisk/agi-bin/
cp -rf /usr/local/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
15.
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/
16.
cd /usr/local/src/a2billing/addons/sounds
./install_a2b_sounds.sh
17.
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
18.
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/
19.
echo "
# Automatically added for A2Billing
0 * * * * php /usr/local/src/a2billing/Cronjobs/a2billing_alarm.php
0 12 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_archive_data_cront.php
0 10 21 * * php /usr/local/src/a2billing/Cronjobs/a2billing_autorefill.php
#Batch process at 00:20 each day
20 0 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_batch_process.php
#Bill DID usage at 00:00 each day
0 0 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_bill_diduse.php
#Remind users of low balance every day at 06:00
0 6 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_check_account.php
#Generate Invoices at 7am everyday
#0 7 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_invoice2_cront.php
#0 7 * * * php /usr/local/src/a2billing/Cronjobs/a2billing_invoice_cront.php
#Check if balance below preset value, and email user if so.
1 * * * * php /usr/local/src/a2billing/Cronjobs/a2billing_notify_account.php
#Charge subscriptions at 06:05 on the 1st of each month
0 6 1 * * php /usr/local/src/a2billing/Cronjobs/a2billing_subscription_fee.php
#Update currencies at 01:00 each day
0 1 * * * php /usr/local/src/a2billing/Cronjobs/currencies_update_yahoo.php
" >> /var/spool/cron/asterisk
20.
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
21. vim /etc/asterisk/manager_custom.conf
Add the following lines at the end of the file
[myasterisk]
secret = mycode
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read = system,call,log,verbose,command,agent,user
write = system,call,log,verbose,command,agent,user
22. asterisk -rx "module reload"
NOTE:
User: root
Password: changepassword
|
I havent yet test a2billing functionality, you will need to test it, and tell me if there is any issue
|
|
|
|
Last Edit: 2011/01/10 09:53 By jgutierrez.
Do you want a fast response service?
Do you want more help?
Try our Official Elastix Paid Support Service (English/Español) at:
store.palosanto.com
Soporte Elastix Palosanto Solutions
Santiago de Guayaquil
|
|
|
Re:Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 155
|
|
Nice update jgutierrez
I suspect you might need to append:-
mysql_fix_privilege_tables --password=eLaStIx.2oo7
for a "new" install, on an Elastix box.
I might also suggest that lines 2-"the end of section 12" could be replaced effectively with:-
touch -t 1001130600 /usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.4.4-to-v1.4.4.1.sql
# that to fix a temporal discontinuity at a2billing
for i in `ls -X /usr/local/src/a2billing/DataBase/mysql-5.x/UPDATE-a2billing-v1.*`;do (/usr/bin/mysql mya2billing -u root -peLaStIx.2oo7 < $i ) ;done
seeing as you are svn'ing the trunk and this directory will unlikely remain static (it changed a couple of times in the last few weeks)
regards
dicko
|
|
|
|
Last Edit: 2010/06/09 13:19 By dicko.
There are other solutions!!
|
|
|
Re:Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 0
|
|
this worked great except...
using root / changepassword I cannot log in.
suggestions?
|
|
|
|
|
|
|
Re:Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 0
|
|
I ran this command:
update cc_ui_authen set pwd_encoded='410fc6268dd3332226de95e42d9efa4046c5463769d7493b85e65cfa5c26362dc2455cc23c0bc5831deb008def4ab11a9eaa9b76ba3f377da134f39ec60dd758' where login='root';
to change the password for root to "password" MySQL returned 1 row matched but didn't do the update.
|
|
|
|
|
|
|
Re:Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 155
|
You probably shouldn't have done that, that was for 1.4, by my math 1.4 <> 1.7, things change, so do concepts of security. It always helps to know what you are doing. It should just work after you use the UI to do the changes, but if you are struggling try the a2billing forum, they will likely be more authoritative. Or in your case I suggest you start over AFTER doing that RTFM thingy
dicko
|
|
|
|
Last Edit: 2010/06/09 18:48 By dicko.
There are other solutions!!
|
|
|
Re: Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 0
|
Thank you for the good realized work, all the steps OK.
The problem is that when I introduce the user and the password he says the following message to me:
Error : A2Billing configuration file is missing!
Solved copying again the file /etc/a2billing.conf
THANK YOU VERY MUCH.
-------------
Gracias por el buen trabajo realizado, todos los pasos OK.
El problema es que cuando introduzco el usuario y el password me dice el siguiente mensaje:
Error : A2Billing configuration file is missing!
Solucionado copiando de nuevo el fichero /etc/a2billing.conf
MUCHAS GRACIAS. 
|
|
|
|
Last Edit: 2010/06/10 03:12 By chimo.
|
|
|
Re: Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 97
|
|
Yes, that is correct, that was why on step #5 and step #6, you will see that a2billing.cong is placed under the /etc/ directory
|
|
|
|
Do you want a fast response service?
Do you want more help?
Try our Official Elastix Paid Support Service (English/Español) at:
store.palosanto.com
Soporte Elastix Palosanto Solutions
Santiago de Guayaquil
|
|
|
Re: Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 97
|
|
jgutierrez escribió:
Yes, that is correct, that was why on step #5 and step #6, you will see that a2billing.conf is placed under the /etc/ directory
|
|
|
|
Do you want a fast response service?
Do you want more help?
Try our Official Elastix Paid Support Service (English/Español) at:
store.palosanto.com
Soporte Elastix Palosanto Solutions
Santiago de Guayaquil
|
|
|
Re: Update 1.3.0 > 1.7.1 1 Year, 8 Months ago
|
Karma: 0
|
|
GRACIAS
|
|
|
|
|
|
|