Page 3 of 3

Re: Vicibox SVN Trunk Upgrade

PostPosted: Sat Nov 29, 2014 4:01 am
by boiken
In the case of a All In One Server (Vicibox Standart Installation) ill suggest to make a HDD Clone Using Clonezina and save as an image to an external HDD.

Re: Vicibox SVN Trunk Upgrade

PostPosted: Mon Jun 01, 2015 6:38 am
by Alex
Hi. I'm creating the custom fields in VICIdial 2.7, asterisk version 1.8. but it gives error "ERROR: no custom list fields table" while launhing the FORM in agent screen.
Also not able to make any modifications to existing custom fields. It is not reflecting in the database table as well. Please advice.

Re: Vicibox SVN Trunk Upgrade

PostPosted: Mon Jun 01, 2015 9:42 am
by dspaan
Please post a screenshot of the custom fields you've created.

Re: Vicibox SVN Trunk Upgrade

PostPosted: Fri Jan 08, 2016 4:51 pm
by soulofmischief87
What would be the necessary steps to updating to SVN trunk when using ViciBox Redux v.6.0-beta? I need to update to allow for DNC.com integration in this box(http://vicidial.org/docs/DNC-dot-COM_integration.txt). Can someone advise me?

Thanks

Re: Vicibox SVN Trunk Upgrade

PostPosted: Fri Jan 08, 2016 7:57 pm
by mflorell
cd /usr/src/astguiclient/trunk
svn update
perl install.pl


Then you need to follow the UPGRADE document to upgrade the database.

Re: Vicibox SVN Trunk Upgrade

PostPosted: Mon Mar 06, 2017 5:21 am
by Alex
Hi. I have just faced issue of unable to login into the admin page after doing SVN upgrade for vicidial-2.14.
Then I did the following procedure to resolve the administrator login issue. Now I'm able to login into the administrator after SVN trunk upgrade without any issue.

- mv /usr/src/astguiclient /usr/src/astguiclient-old
- mkdir /usr/src/astguiclient
- svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk
- \. /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
- mysql -f --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
- perl ./install.pl
- /usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table –debug


Hope it helps.

Re: Vicibox SVN Trunk Upgrade

PostPosted: Mon Mar 12, 2018 9:56 pm
by actiondave
Because I tried to upgrade many times with fail, I am adding the exact steps I used to complete my first upgrade that was long overdue. I did this on a spare server.

What I did is pretty much what was already described but when I tried just using the upgrade document or what was given in this thread I still failed for silly reasons of my own.

Initial vicidial: One Server setup
version: 2.8b0.5
SVN Version: 1995
DB Schema Version: 1351
DB Schema Update Date: 2013-06-21 14:39:41

VERSION: 2.8-404a
BUILD: 130605-0841
-----------------------------------------------------------
UPGRADE

First I created a backup and restored it to my spare server. You definitely want to run a backup on your current setup prior to any upgrades as suggested. Most likely you won't be doing this on a spare server but if you do, it is good for learning and not messing up your working system.

Then as follows:
*credit to alex (above) for moving astguiclient and creating a new astguiclient directory-that helped me a lot

mv /usr/src/astguiclient /usr/src/astguiclient-old
mkdir /usr/src/astguiclient
cd /usr/src/astguiclient
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk

changed svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk

TO: "svn checkout svn://svn.eflo.net/agc_2-X/trunk" as it did not work with the :3690

cd /

mysql
use asterisk

\. /usr/src/astguiclient/trunk/extras/upgrade_2.8.sql

\. /usr/src/astguiclient/trunk/extras/upgrade_2.10.sql

\. /usr/src/astguiclient/trunk/extras/upgrade_2.12.sql

\. /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql

quit

cd /usr/src/astguiclient/trunk

perl ./install.pl

cd /

/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table –debug


For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
page and set each one to "Rebuild conf files = Y" and click submit.
This will rebuild the conf files to ensure any changes are updated.


VERSION: 2.14-664a
BUILD: 180310-2321

Re: Vicibox SVN Trunk Upgrade

PostPosted: Fri May 22, 2020 11:27 pm
by carpenox
For new DB schema upgrades make sure you use the following command:

mysql -p -f --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql