asterisk2billing.org http://forum.asterisk2billing.org/ |
|
Easy Upgrade V1.2.3 to 1.3.0 http://forum.asterisk2billing.org/viewtopic.php?f=17&t=2393 |
Page 1 of 1 |
Author: | ladca2003 [ Wed Aug 01, 2007 12:05 pm ] |
Post subject: | Easy Upgrade V1.2.3 to 1.3.0 |
Upgrading a2billing v.1.2.3 to v.1.3.0 including production boxes Most of this document has been copied from SureTeq document to upgrade an older version of a2billing and the install guide. Hope they don’t mind and I thank them for producing it. It saves so much time. Thank you. I have tested this upgrade several times and was able to restore my data. Having said that I will not be responsible for data loss. If you have any type of problem which you should not, you can always go back to your original version and upload your data the same way. Download latest A2Billing tar file Create an a2billing directory. mv /usr/src/a2billing a2billing_old (if you had this directory before) mkdir /usr/src/a2billing cd /usr/src/a2billing Go to http://trac.asterisk2billing.org/cgi-bin/trac.cgi 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. You can also use WinSCP3 is an excellent program to work between you local Windows and your linux box. (look for the file you need) Download the a2billing tar file to the a2billing directory you just created. Once the file has been downloaded to your /usr/src/a2billing directory open your Linux CLI and do the following: cd /usr/src/a2billing tar zxvf A2Billing_1.3.0.tar.gz Go to your a2billing program and do a backup of your data file with the Administrator => database backup. The backup will be placed in the /tmp directory. Update your DataBase to V1.3.0 (or current version) cd /usr/src/a2billing/DataBase/mysql/Mysql-5.x mysql -u root -ppassw0rd mya2billing < UPDATE-a2billing-v1.2.3-to-v1.3.0-mysql.sql if you get an error using the password then use your DB password or the same statement without the password command as follows. mysql -u root mya2billing < UPDATE-a2billing-v1.2.3-to-v1.3.0-mysql.sql Done! Your a2b v1.2.3 database has been converted to v1.3.0! Install HTTP UI The following commands will make a copy of your old UI and copy the new UI in its place. Keep in mind sometimes the (–) in front of the R or r in the chown statement do not transfer when you copy and paste so fix it by hand. Keep in mind the upper and lower case in directory names so you can call the application correctly later. cd /var/www/html mv a2billing_UI a2billing_UI_old mkdir a2billing_UI chown –R asterisk:asterisk a2billing_UI cd a2billing_UI cp -r /usr/src/a2billing/A2Billing_UI/. . (include last two dots) chmod 777 /var/www/html/a2billing_UI/templates_c Install Customer console: cd /var/www/html mv a2bcustomer_UI a2bcustomer_UI_old mkdir a2bcustomer_UI chown –R asterisk:asterisk a2bcustomer_UI cd a2bcustomer_UI cp –r /usr/src/a2billing/A2BCustomer_UI/. . chmod 777 /var/www/html/a2bcustomer_UI/templates_c 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 mv a2billing.php a2billing_old.php cp /usr/src/a2billing/A2Billing_AGI/a2billing.php . (include the dot) mv libs_a2billing libs_a2billing_old cp -r /usr/src/a2billing/A2Billing_AGI/libs_a2billing . chown asterisk:asterisk a2billing.php chown –R asterisk:asterisk libs_a2billing Install a2billing.conf file cd /etc/asterisk mv a2billing.conf a2billing_old.conf cp /usr/src/A2Billing_1.3.0/a2billing.conf . (include the dot) chown asterisk:asterisk a2billing.conf Edit the a2billing.conf file to select your database. Change to the database you use. If you use mysql then change from postgres to mysql. Default is postgres. Edit /etc/asterisk/a2billing.conf with your editor and comment out the database you use. nano /etc/asterisk/a2billing.conf In [database] section, change: dbtype=postgres ;dbtype=mysql To: ;dbtype=postgres dbtype=mysql Log In. Log into your new A2Billing v.1.3.0 by opening your browser and using the following address. http://asterisk or box IP/a2billing_UI login with your username and password Your done!!! |
Author: | Rahail [ Thu Aug 16, 2007 1:41 pm ] |
Post subject: | |
I did what you said on that confg but I am getting this error for login even i change the lenght on conf still same Invalid card number lenght defined in configuration. |
Author: | fdilecce [ Fri Aug 17, 2007 10:22 am ] |
Post subject: | ERROR 1060 (42S21) at line 2: Duplicate column name 'calleri |
I have followed the instructions but during the update of the db: mysql -u root -p mya2billing < UPDATE-a2billing-v1.2.3-to-v1.3.0-mysql.sql i have this: ERROR 1060 (42S21) at line 2: Duplicate column name 'calleridprefix' you can help me? tanks |
Author: | ladca2003 [ Fri Aug 17, 2007 11:04 am ] |
Post subject: | |
keep going with the rest of the upgrade. You will be ok. I had the same happened to me and it will upgrade perfectly. |
Author: | Rahail [ Sat Aug 18, 2007 12:24 am ] |
Post subject: | Re: ERROR 1060 (42S21) at line 2: Duplicate column name 'cal |
fdilecce wrote: I have followed the instructions but during the update of the db:
mysql -u root -p mya2billing < UPDATE-a2billing-v1.2.3-to-v1.3.0-mysql.sql i have this: ERROR 1060 (42S21) at line 2: Duplicate column name 'calleridprefix' you can help me? tanks I have the same error can some one guide us please |
Author: | fdilecce [ Sat Aug 18, 2007 11:51 am ] |
Post subject: | UPDATE OK. |
i have going with the rest of the upgrade but th db is not imported. and when i go to tht Customer interface at: http://mysite.com/a2customer i have page blank!!! Added after 28 minutes: I have mistaken the name of the db. The Update is OK. Tanks!!! |
Author: | psuarez [ Mon Sep 10, 2007 1:40 pm ] |
Post subject: | a2customer |
hi the update seem to go ok.., but when i acces the a2customer interface the page is blank... does anyone know how to fix this problem, please any help will be much appriciated. thanks. that work !!! thank you very much for your help. |
Author: | ladca2003 [ Mon Sep 10, 2007 1:45 pm ] |
Post subject: | |
Try this cd /var/www/html/A2BCustomer_UI or cd /var/www/html/a2customer chmod 777 templates_c depending where you have the file located template_c needs 777 permission in A2BCustomer_UI. |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |