Vicibox SVN Trunk Upgrade

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Vicibox SVN Trunk Upgrade

Postby Trying » Tue Feb 15, 2011 8:41 am

I have put together the little procedure underneath to upgrade Vicibox to SVN Trunk. The two reasons for putting this together is to ensure I do not make a mistake with my first upgrade and also help newbies. Could you please check if the steps and procedures are 100% correct? Please also change or add whatever is needed.



1. Backup existing system:

1.1 Run this for a 1-server system or server with database on it:
(this may take hours on large system)
/usr/share/astguiclient/ADMIN_backup.pl --debugX

1.2 Run this on dialer/Asterisk-only servers:
(do not run this if you only have one server):
/usr/share/astguiclient/ADMIN_backup.pl --debugX --without-db --without-web

2. Test backup:

Create a new (any name) database on any mysql server, apply the backup data to it, and verify a new lead from TODAY is actually in there.

3. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient

Download Vicidial trunk on ALL servers

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

4. On ONLY database server:

Going into mysql and executing the upgrade sql file:
mysql (alternatively use mysql -u root -p)
use asterisk
\. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql
quit

(When you do an update on the Database side by issuing a
"\. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql" from mysql prompt you also need to 'run':
"\. /usr/src/astguiclient/trunk/extras/upgrade_2.6.sql"

The 2.6 upgrade will add 3 columns to the vicidial_campaigns table " in_group_dial | in_group_dial_select | safe_harbor_audio_field". If you don't do the 2.6 upgrade SQL you will have problems...)

5. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient/trunk
perl ./install.pl

Your original settings should still be the same so you really just have to double check the settings and hit enter through all the options.

NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.

6. For each of your ViciDial servers:

go to 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.

7. On one server only, update your phone codes data:

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

Last edited by Trying on Fri Jun 22, 2012 3:44 am, edited 6 times in total.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Tue Feb 15, 2011 11:21 am

It looks good, but from experience: You MUST restore that database on another server to prove it was successfully backed up. Other things can be "worked with" and/or "reconstructed". But if the database "goes missing" or was corrupted ... one more booboo and you can lose your job. We've had to clean that up more than once.

All that's really required is to create a new (any name) database on any mysql server, apply the backup data to it, and verify a new lead from Today is actually in there. Then, if really bad things happen, at least you have your database and can 'work it out' if you need to.

It's not necessary to perform this restore daily, but during a major upgrade it's a necessary Best Practice.
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby Trying » Tue Feb 15, 2011 11:22 am

Thanks for the reply! Looking forward to our first upgrade :)
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Tue Feb 15, 2011 11:26 am

Vicidial's upgrade procedure has proven very reliable. We have yet to hear of or have any problems ... as long as the database is available. We've upgraded from 2.0.5 to 2.2.1 or 2.4 (starting with VicidialNOW, Vicibox or Scratch and ending with Vicibox or GoAutoDial 2.2.1). So far, no serious issues or complications EXCEPT occasional 2.4->2.4 updates that required editing of the sql file to remove previously applied changes (that could not be made again) to get to the final dbschema.
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby Trying » Tue Feb 15, 2011 11:43 am

Here are the adjusted steps:

1. Backup existing system:

1.1 Run this for a 1-server system or server with database on it:
(this may take hours on large system)
/usr/share/astguiclient/ADMIN_backup.pl --debugX

1.2 Run this on dialer/Asterisk-only servers:
(do not run this if you only have one server):
/usr/share/astguiclient/ADMIN_backup.pl --debugX --without-db --without-web

2. Test backup:

Create a new (any name) database on any mysql server, apply the backup data to it, and verify a new lead from Today is actually in there.

3. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient

Download Vicidial trunk on ALL servers

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

4. On ONLY database server:

Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /usr/src/astguiclient/trunk/extras/upgrade_2.8.sql
quit

5. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient/trunk
perl ./install.pl
NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.


6. On one server only, update your phone codes data:

/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table –debug
Last edited by Trying on Sun Apr 13, 2014 5:48 am, edited 1 time in total.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby DarknessBBB » Wed Feb 16, 2011 6:47 am

For me the mysql login works only in this way:
Code: Select all
vicidial:~ # mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
vicidial:~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 173942
Server version: 5.1.46-log SUSE MySQL RPM

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>


Can this thread be sticky? :)
DarknessBBB
 
Posts: 327
Joined: Mon Jul 16, 2007 10:14 am

Postby mflorell » Wed Feb 16, 2011 7:10 am

It has been made sticky. Please correct any changes made in the first posting.
mflorell
Site Admin
 
Posts: 17352
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Trying » Wed Feb 16, 2011 7:15 am

Changes made. Let me know if there are any other additions or changes to be made.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby dspaan » Tue May 17, 2011 8:17 pm

Thanks for this guide, it worked just fine for me :D
Regards, Dennis

Vicibox 8.1.2
Version: 2.14-717a
SVN Version: 3129
DB Schema Version: 1574
Build: 190724-1603
dspaan
 
Posts: 1233
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Postby josh1856 » Fri Jun 17, 2011 7:41 am

Is there any specific reason why every time a do a SVN update my settings in the admin.php disappear?

All the campaign, lists and data is there however any of the settings are basically gone. For instance if I go to campaigns they are all listed, however there is not any data set within the campaign itself like the campaign ID, campaign name, description, change date, active are all just blank and none of my settings were saved.

Is there a way to restore those settings from my backup?

ViciBox Redux 3.1.0 | ViciDial 2.4-317a | Build: ? | Dbschema ? | Asterisk 1.4.27.1-vici | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation
josh1856
 
Posts: 39
Joined: Thu Mar 18, 2010 12:05 am

Postby mflorell » Fri Jun 17, 2011 8:01 am

Are you doing a database schema upgrade after running the install.pl?
mflorell
Site Admin
 
Posts: 17352
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby josh1856 » Fri Jun 17, 2011 8:04 am

Matt,
I just ran a database schema upgrade using the command

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

and then ran the upgrade again and everything is working like a charm now.

thanks.
jpg
josh1856
 
Posts: 39
Joined: Thu Mar 18, 2010 12:05 am

Re: Vicibox SVN Trunk Upgrade

Postby douglaswscott » Thu Aug 25, 2011 11:15 am

I did all this, everything works except my admin.php - no login no screen.

Trying wrote:I have put together the little procedure underneath to upgrade Vicibox to SVN Trunk. The two reasons for putting this together is to ensure I do not make a mistake with my first upgrade and also help newbies. Could you please check if the steps and procedures are 100% correct? Please also change or add whatever is needed.



1. Backup existing system:

1.1 Run this for a 1-server system or server with database on it:
(this may take hours on large system)
/usr/share/astguiclient/ADMIN_backup.pl --debugX

1.2 Run this on dialer/Asterisk-only servers:
(do not run this if you only have one server):
/usr/share/astguiclient/ADMIN_backup.pl --debugX --without-db --without-web

2. Test backup:

Create a new (any name) database on any mysql server, apply the backup data to it, and verify a new lead from TODAY is actually in there.

3. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient

Download Vicidial trunk on ALL servers

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

4. On ONLY database server:

Going into mysql and executing the upgrade sql file:
mysql (alternatively use mysql -u root -p)
use asterisk
\. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql
quit

5. On ALL servers: (Database, web, telephony)

cd /usr/src/astguiclient/trunk
perl ./install.pl

Your original settings should still be the same so you really just have to double check the settings and hit enter through all the options.

NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.

6. For each of your ViciDial servers:

go to 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.

7. On one server only, update your phone codes data:

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

douglaswscott
 
Posts: 71
Joined: Fri Apr 01, 2011 9:58 am

Postby williamconley » Thu Aug 25, 2011 5:21 pm

try not to doublepost.
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby randy_delgado_03 » Thu Sep 01, 2011 6:35 pm

@Trying

Are these steps applicable to 2.4 > 2.4?

Anyone have tried this upgrade from 2.4 to 2.4?

Thanks ...
ViciBox v.7.0.3-160505
Asterisk 11.22.0-vici
Vicidial: VERSION: 2.12-563a BUILD: 160801-2119
Servers: Stand alone server (Database, Web, Telephony)
No Additional Softwares, No Third Party Softwares
randy_delgado_03
 
Posts: 178
Joined: Wed Dec 01, 2010 2:50 pm
Location: Manila, QC

Postby williamconley » Thu Sep 01, 2011 7:11 pm

with 2.4 to 2.4 we have found that it can be more "safe" to open that sql file, find your present db_schema_version and delete all the lines above (as those have obviously run, resulting in your present schema). Then execute all the remaining lines only.

we've found this to remove certain bugs for earlier versions of 2.4 where the lines between creating and deleting certain fields and indexes get somewhat fuzzy ... which can stop the mysql upgrade in its tracks. but so far we've had very few problems if we have deleted the prior database entries. runs quite smoothly.

also remember that there are (from time to time) changes required or suggested in the sample ".conf" files, and we always recommend loading these fresh on each install to be sure (say yes when prompted). But this obviously means you cannot have any custom entries in the .conf files ... find a way to store everything in the vicidial database tables (there are several places for custom entries).
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby knotbeerdan » Thu Sep 08, 2011 1:50 pm

Worked perfectly!!! Thanks :lol:
GoAutoDial 2.1CE - standard install | Asterisk: 1.4.27.1-1 | Vicidial: 2.4-309a | Build: 110430-1642| Telephony cards: none
knotbeerdan
 
Posts: 40
Joined: Thu May 05, 2011 4:31 pm
Location: Phoenix, AZ

SVN Upgrade from 2.0.5 to the lates

Postby voipart » Tue Jan 10, 2012 9:20 am

I have tried my upgradation exactly as mentioned in this post of SVN Upgradation,
everything went on well except too many messages (which scrolled on) in SqL upgradation part,
Now when I login from web I have no administrative access, Any modification ( i can see List of , phones, IngruupId, DID, etc...) but click on Modification not allowing , also I cannot see any users in the user list...
When I look on my database directly I can see all users (about 100) there and Active.
I DOnt know where it went wrong, appreciate help from you experts,

My instalation is Dual Server
Web+DB in One Server, Asterisk In another Server , Vicidial Version 2.0.5 | Asterisk 1.2.30.2 | Users 80 | Servers Quad Process Dell Servers

All of them ware working perfect But in inbound calls the call Recording has a delay in starting Recording( 5-15 sec very call to call) (Configuration: ALLFORCE /0 Delay)
[/b]
voipart
 
Posts: 40
Joined: Tue Jan 10, 2012 9:04 am

Solution for Not seeing Users after upgradation

Postby voipart » Wed Jan 11, 2012 10:27 am

In regards to my own posting as I could not see users or not able to edit any records after an update from 2.0.5 to 2.4
I have found that it worked when i have updated s1l from 2.2.0 and then to 2.4

\. /usr/src/astguiclient/trunk/extras/upgrade_2.2.0.sql
\. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql
voipart
 
Posts: 40
Joined: Tue Jan 10, 2012 9:04 am

Postby Trying » Wed Jan 11, 2012 10:38 am

Thanks for the feedback!
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Wed Jan 11, 2012 1:41 pm

the upgrade instructions do mention that you must upgrade incrementally. you cannot skip a generation.

2.0.4
2.0.5
2.2.0
2.4
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby rougeleaf » Tue Feb 07, 2012 4:05 pm

Speaking of versions.

When upgrading to a newer SVN trunk, where is the list of versions the other scripts will be or should be.

for example I have,
admin.php VERSION: 2.4-357a BUILD: 120125-2107
agc.new/vicidial.php 2.2.1-260 BUILD: 100527-2211

Thanks in advanced.
SVN trunk update:
VERSION: 2.4-357a
BUILD: 120125-2107

goautodial-ce-2.1-final.iso
VERSION: 2.2.1-237 Asterisk 1.4.27.1-1 vici
BUILD: 100510-2015 i7 950 @ 3.07GHz, 6G ram, Raid1 2drives (single server)
Kernel 2.6.18-194.8.1.el5.goPAE (SMP)
rougeleaf
 
Posts: 21
Joined: Fri Mar 04, 2011 1:44 am
Location: AK

Postby williamconley » Tue Feb 07, 2012 4:11 pm

there are no "other scripts". When you upgrade, the installer will automatically install ALL necessary scripts. ALL. Not just the modified ones. You are not "Upgrading" Vicidial.

You are "Upgrading" the SVN source code from a prior SVN to a different SVN. Then you are "upgrading" the database using the sql commands included in that source. Then you are resinstalling Vicidial on top of the prior vicidial installation.

When you are done, the "script versions" will be whatever was downloaded with the rest of the source via svn. There is no present codified correlation between script versions and SVN version.
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby chasejordan1 » Sat Feb 18, 2012 6:33 pm

What if my DB server is just a CentOS DB server no astguiclient?
chasejordan1
 
Posts: 180
Joined: Fri Mar 07, 2008 11:57 am

Postby williamconley » Sun Feb 19, 2012 9:40 am

the location of the database is not relevant. as long as you are capable of executing commands on that database server as a common sense way to update the correct database.
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby rougeleaf » Thu Feb 23, 2012 6:41 pm

there are no "other scripts". When you upgrade, the installer will automatically install ALL necessary scripts. ALL. Not just the modified ones. You are not "Upgrading" Vicidial.

You are "Upgrading" the SVN source code from a prior SVN to a different SVN. Then you are "upgrading" the database using the sql commands included in that source. Then you are resinstalling Vicidial on top of the prior vicidial installation.

When you are done, the "script versions" will be whatever was downloaded with the rest of the source via svn. There is no present codified correlation between script versions and SVN version.


Perhaps I did not ask correctly, but I think I found an answer...
We found that version 2.2.1-260 BUILD: 100527-2211 is not correct, but does work.
This is the version we need to work with the new SVN update
/agc/vicidial.php# VERSION: 2.4-340c BUILD: 111227-1940

The SVN update does not update the index.php home page. Thus the AGENT LOGIN link was taking us to
Code: Select all
http://host*/agc.new/vicidial.php?relogin=YES

where the newest version is found
Code: Select all
http://host/agc/vicidial.php?relogin=YES


So yes there is some correlation between versions
where features such as: screen labels, call notes, lead search; do require version 2.4-340c. Since agc.new was not replaced you can understand my confusion :wink:

We are enjoying all the new feature, thanks to all those involved in writing them. Any time frame on an updated manual?
SVN trunk update:
VERSION: 2.4-357a
BUILD: 120125-2107

goautodial-ce-2.1-final.iso
VERSION: 2.2.1-237 Asterisk 1.4.27.1-1 vici
BUILD: 100510-2015 i7 950 @ 3.07GHz, 6G ram, Raid1 2drives (single server)
Kernel 2.6.18-194.8.1.el5.goPAE (SMP)
rougeleaf
 
Posts: 21
Joined: Fri Mar 04, 2011 1:44 am
Location: AK

Postby mflorell » Thu Feb 23, 2012 7:51 pm

This is the Vicibox forum, not the goautodial forum, we don't support the altered goautodial agent interface.
mflorell
Site Admin
 
Posts: 17352
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Vicibox SVN Trunk Upgrade

Postby GaD » Sun Jun 10, 2012 8:11 pm

Just as an added note to this thread. I've just done an SVN update on my system with the 'tutorial' listed up there and came to realize that when I went into 'Campaign Details I was getting an error: "Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /srv/www/htdocs/vicidial/admin.php line 20432".

To not bore you with a bunch of info.... When you do an update on the Database side by issuing a
"\. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql" from mysql prompt you also need to 'run':
"\. /usr/src/astguiclient/trunk/extras/upgrade_2.6.sql"

The 2.6 upgrade will add 3 columns to the vicidial_campaigns table " in_group_dial | in_group_dial_select | safe_harbor_audio_field". If you don't do the 2.6 upgrade SQL you will have problems...

Perhaps Trying or Matt or William can update the 'tutorial' provided up there which has been my 'Update Bible' all along!

Cheers!
Vicibox Reddux 3.1.15||Asterisk 1.4.39.2-vici||VERSION: 2.8-403a
BUILD: 130510-1350
Kernel Version: 2.6.34.10-0.6-default #1 SMP
GaD
 
Posts: 191
Joined: Fri Jul 08, 2011 3:56 pm

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Fri Jun 22, 2012 3:44 am

Hi

Thank you very much for this. I updated the post.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Re: Vicibox SVN Trunk Upgrade

Postby tarundas » Mon Jul 16, 2012 12:01 pm

7. On one server only, update your phone codes data:

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


Does it mean it needs to be run on any one server in a cluster setup? or this has to do with single sever setup?
Some people aren't just missing a SCREW... they're missing the whole damn TOOLBOX!
tarundas
 
Posts: 62
Joined: Wed Nov 25, 2009 3:02 pm
Location: Calcutta

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Mon Jul 16, 2012 12:06 pm

As far as the instructions go only on one server in a cluster set up. Surely it won't hurt running it on all the servers if you want to be safe :D
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Re: Vicibox SVN Trunk Upgrade

Postby GaD » Mon Jul 16, 2012 12:10 pm

Only in one server. The script will connect to the database and make the appropiate arrangements regarding the timezones. If you do it once in every server you will end up doing the same thing over and over again so long you are sunning it in servers within the same cluster. If you have separate clusters, you need to run it once (from only one computer) in every cluster every time you update.
Vicibox Reddux 3.1.15||Asterisk 1.4.39.2-vici||VERSION: 2.8-403a
BUILD: 130510-1350
Kernel Version: 2.6.34.10-0.6-default #1 SMP
GaD
 
Posts: 191
Joined: Fri Jul 08, 2011 3:56 pm

Re: Vicibox SVN Trunk Upgrade

Postby williamconley » Mon Jul 16, 2012 2:59 pm

Of course, if you use the Vicibox Redux installation and answer the questions properly, the various servers install scripts should handle this for you (ie: install it on only one server).

We usually just run this script on the DB server for each system. Since there is Only One DB server in each cluster (and each standalone).
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18992
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicibox SVN Trunk Upgrade

Postby simonc » Wed Aug 15, 2012 10:39 pm

To upgrade from BUILD: 120529-2112 to the latest SVN code, i assume that i don't need to rerun the database 2.6 script?
Single Server | GoAutoDial 2.1 Base - Updated CentOS | VERSION: 2.6-370a | BUILD: 120529-2112
Server Specs : 2 X Dual Xeon 2.0Ghz on SuperMicro based server | 4GB DDR2 ECC Ram | 100Mbps Dedicated | 2 X 250GB 7200RPM IN RAID
simonc
 
Posts: 49
Joined: Thu May 17, 2012 9:53 am

Re: Vicibox SVN Trunk Upgrade

Postby randy_delgado_03 » Mon Aug 27, 2012 4:17 pm

Is it possible to upgrade for a particular build? Or is it possible to just the files from a particular build?
ViciBox v.7.0.3-160505
Asterisk 11.22.0-vici
Vicidial: VERSION: 2.12-563a BUILD: 160801-2119
Servers: Stand alone server (Database, Web, Telephony)
No Additional Softwares, No Third Party Softwares
randy_delgado_03
 
Posts: 178
Joined: Wed Dec 01, 2010 2:50 pm
Location: Manila, QC

Re: Vicibox SVN Trunk Upgrade

Postby DomeDan » Tue Aug 28, 2012 4:10 am

simonc: I think you should, because time to time things get changed in the database structure

randy_delgado_03: Yeah, kind of, but you need to find out the revision of that specific build
Code: Select all
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk
svn log trunk | less
#find out the revision number, lets say you want this version: "r1847 | mattf | 2012-08-10 14:31:28 +0200 (fre, 10 aug 2012) | 1 line | Added recording and webserver functions to the agent API"
#then specify that with svn like this:
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk@1847 trunk_1847
ls trunk_1847
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: Vicibox SVN Trunk Upgrade

Postby racosta79 » Thu Nov 22, 2012 9:18 am

Hello everybody!

I have a System installed using Vicibox Redux 3.1.15 with the following server components:
1 Database
2 Asterisk
2 Web
1 FTP

Now I need to upgrade it to the latest Vicibox Server 4.0.1 SVN version.

As this is a very important call center that cannot be stopped, I wonder if you can confirm that this procedure is correct?

Thank you in advance!

Roger Acosta
Viva Paraguay!
racosta79
 
Posts: 28
Joined: Fri Nov 19, 2010 7:27 pm

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Thu Nov 22, 2012 9:36 am

You need to specify at least what the version and build of the Vicidial is. Also what is your database schema number? Above 1316 or below?

Remember Vicibox is not a Vicidial version, it is merely an installer. The easiest is always obviously to simply just upgrade Vicidial and not reinstall everything with a new Vicibox disc.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Thu Nov 22, 2012 9:39 am

The below is an extract from the upgrade document:

########## UPGRADING FROM 2.4 TO 2.6 ##########

OPTIONAL STEPS(But highly recommended) - Backup existing system:

1. Run this for a 1-server system or server with database on it:
(this may take hours on large system)
/usr/share/astguiclient/ADMIN_backup.pl --debugX

2. Run this on dialer/Asterisk-only servers:
(do not run this if you only have one server):
/usr/share/astguiclient/ADMIN_backup.pl --debugX --without-db --without-web


REQUIRED STEPS!!!

1. Check system_settings, make sure you are at DB Schema Version 1316 or higher
If not, run the instructions for 2.2.0 to 2.4 before this section.

2. upgrade the MySQL asterisk database(you have two options):
A. Running the upgrade file directly from Linux:
mysql -f --database=asterisk < /path/from/root/extras/upgrade_2.6.sql

B. Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.6.sql
quit

3. install new files:
perl ./install.pl
NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.

4. 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.

5. On one server only, update your phone codes data:
/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table --debug

########## UPGRADING FROM 2.2.0 TO 2.4 ##########

OPTIONAL STEPS(But highly recommended) - Backup existing system:

1. Run this for a 1-server system or server with database on it:
(this may take hours on large system)
/usr/share/astguiclient/ADMIN_backup.pl --debugX

2. Run this on dialer/Asterisk-only servers:
(do not run this if you only have one server):
/usr/share/astguiclient/ADMIN_backup.pl --debugX --without-db --without-web


REQUIRED STEPS!!!

1. upgrade the MySQL asterisk database(you have two options):
A. Running the upgrade file directly from Linux:
mysql -f --database=asterisk < /path/from/root/extras/upgrade_2.4.sql

B. Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.4.sql
quit

2. install new files:
perl ./install.pl
NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.

3. 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.

4. On one server only, update your phone codes data:
/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table --debug

Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Re: Vicibox SVN Trunk Upgrade

Postby racosta79 » Thu Nov 22, 2012 10:24 am

Thank you for your reply.

This is my Vicidial version and build number:
VERSION: 2.2.1-237 BUILD: 100510-2015

Version: 2.2.1 DB Schema Version: 1193 DB Schema Update Date: 2012-03-09 23:01:57 Auto User-add Value: 101 Install Date: 2012-03-09

Thank you again!

Roger
racosta79
 
Posts: 28
Joined: Fri Nov 19, 2010 7:27 pm

Next

Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 3 guests