Vicibox SVN Trunk Upgrade

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

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

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Thu Nov 22, 2012 10:33 am

Then you first have to upgrade using the 2.2.0 to 2.4 instructions and then again using the 2.4 to 2.6 instructions. If you then are sure you still want to reinstall everything with the latest Vicibox server you will backup your newly upgraded system, install the Vicibox latest version and restore that backup on your "new" system. If you don't desperately need the features coming with the new Vicibox setup disc and your current installation is not giving you any problems then rather just upgrade Vicidial.
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 williamconley » Thu Nov 22, 2012 12:44 pm

Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20239
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicibox SVN Trunk Upgrade

Postby kamirie » Thu Jan 03, 2013 7:19 am

I tried testing this update guide , with my vbox install of vicidial from 2.2.1 - 2.4

I run this at mysql \. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql ,
my db_schema was 1193 and \. /usr/src/astguiclient/trunk/extras/upgrade_2.4.sql starts at 1194 so i didn't delete anything from it and just run the script , after reinstalling the astguiclient again , my vicidial admin page refreshed but it's version was already at VERSION: 2.6-392a. I'm pretty sure i run the right upgrade command for 2.4. Mostly fields are blank such as phones , campaigns and the system settings are blank also .
Vicibox 6.0.3
http://download.vicidial.com/iso/vicibo ... nstall.pdf
VERSION: 2.12-492a
BUILD: 150701-1131

Single Server
Amd opteron Quad Core @ 3.0 Ghz
8GB RAM
kamirie
 
Posts: 84
Joined: Tue Dec 27, 2011 7:46 pm

Re: Vicibox SVN Trunk Upgrade

Postby DomeDan » Thu Jan 03, 2013 7:34 am

if you followed the guide and ran "svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk" then you downloaded the 2.6 trunk version,
then you need to run both upgrade_2.4.sql and upgrade_2.6.sql.
but if you really want 2.4 instead of 2.6 you can probably use svn://svn.eflo.net:3690/agc_2-X/branches/agc_2.4 instead.
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 rsaaris » Thu Jan 17, 2013 9:02 am

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


I am planning to do the SVN upgrade for my production enviroment with 1db, 2 dialers and 1 web server. So is it needed to halt all calling (e.g. removing all the lines from servers) when I am doing the database upgrade or running the install.pl? Just to make sure I don't have to halt production if it is not needed. Upgrade is from 2.6 to newer 2.6.

Vicibox 3.1.15 / .iso
VERSION: 2.6-393a
BUILD: 130124-1721
Asterisk version: 1.4.38-vici
IBM System X3550/X3650
Sangoma E1 -card
rsaaris
 
Posts: 50
Joined: Wed Dec 07, 2011 6:40 am

Re: Vicibox SVN Trunk Upgrade

Postby DomeDan » Thu Jan 17, 2013 9:25 am

You dont need to remove lines whatever that means
but you should NOT do a upgrade on a system when anyone uses it.

Do the upgrade after work-hour and make sure you got a few hours extra gap if something unexpected would happen
if your operating 24/7 then do a upgrade in a test-environment from a real backup and then schedule a break where you can do the upgrade
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 Trying » Thu Jan 17, 2013 10:40 am

Agreed, do it after hours but first test your backup and make sure it is fine! No need to remove telecom lines first. When you get used to the upgrade procedure you will find it is easy and should take no more than an hour at most.
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 williamconley » Mon Feb 04, 2013 9:28 pm

If you are unsure, your best bet would be to install your present version in a VMWare or Virtualbox or vSphere instance ... and then upgrade that instance. This will give you an idea of whether or not you will be successful.

And be VERY sure you get a solid backup off the server and verify that your database is intact (by loading that database into another mysql server and checking your last loaded lead ...). After all, a non-confirmed backup doesn't really exist. :)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20239
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicibox SVN Trunk Upgrade

Postby rsaaris » Tue Feb 05, 2013 9:22 am

I have 24/7 calls coming in so is it safest to halt all calling by removing telco lines? So that there won't be any new leads or other data coming to database. This situation is little tricky to simulate in vmware-enviroment so I have to do it direclty to production cluster. Should I also deactivate Remote Agents that are in enabled state? Just to make sure they don't do any log file additions to the database or anything like that.

Vicibox 3.1.15 / .iso
VERSION: 2.6-393a
BUILD: 130124-1721
Asterisk version: 1.4.38-vici
IBM System X3550/X3650
Sangoma E1 -card
rsaaris
 
Posts: 50
Joined: Wed Dec 07, 2011 6:40 am

Re: Vicibox SVN Trunk Upgrade

Postby williamconley » Tue Feb 05, 2013 7:05 pm

1) Full backup

2) Ensure full backup can be loaded onto another server and that your data is present! An untested backup is pointless and dangerous (false sense of security and all).

3) use the SVN system to load the new code (will not change your system, only copies new files into /usr/src/astguicient/trunk) by entering that folder and issuing "svn up".

4) read the UPGRADE document and understand it! It's in that folder you just updated the code in.

5) when ready,
* you can break the gateway of the server (change it to a wrong IP in yast) or just unplug the network/phones to be sure no calls pass through.
* or you can terminate asterisk and apache (if you are not using any API calls, this will suffice)

6) And initiate another local backup (to get any last second changes, now that you know backup is working properly ...)

7) And begin your upgrade according to the upgrade document.

8) When complete, reboot and reconnect anything you disconnected.

9) A little prayer would not hurt here. LOL (We've never had an upgrade fail except on a system with an altered database a long time ago ...).
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20239
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicibox SVN Trunk Upgrade

Postby roll72 » Wed Mar 06, 2013 2:10 am

Hello,

Before update 2.2 to 2.4, I need to know if I could have some issue with asterisk version, I read new trunk version are mostly asterisk 1.4x and when I check my actual asterisk it is a Asterisk 1.2.30.4. Does the svn update is making update on asterisk too ?

My vicidial is as follow :
VERSION: 2.2.1-237
BUILD: 100510-2015
roll72
 
Posts: 82
Joined: Wed Jun 10, 2009 12:32 pm

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Wed Mar 06, 2013 2:38 am

Hi

Yes, Asterisk also gets upgraded automatically.
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 williamconley » Wed Mar 06, 2013 5:56 pm

Um ... NO. SVN only upgrades the vicidial scripts and configuration files. It has zero effect on the OS or its installed packages (such as asterisk). It also does not update the database (this must be done in a sep step). The configuration files for asterisk 1.2 will be used for servers that have asterisk 1.2 instead of 1.4.

Trying was ... Trying to help, but I had to set that right 8-) (He is very helpful!)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20239
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Wed Mar 06, 2013 11:27 pm

Oh sorry about that. And for a moment I thought I was smart. :oops:
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 williamconley » Thu Mar 07, 2013 11:46 am

I think your memory is just getting fuzzy. Age does that. Trust me. Experience. :shock:
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20239
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Thu Mar 07, 2013 12:24 pm

Always a gentleman you are. Quite right, I KNOW IT ALL but just forgot for that split second! LOL!
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 PierreDeux » Wed May 29, 2013 4:57 pm

Hi everyone
I've decided to update my existing cluster setup (VERSION: 2.4-306a BUILD: 110310-0311) to the latest SVN trunk version.
It's a good idea to update test machine before touching the production one, so what I did:
1. Took one server from a cluster, installed mysql there, imported my live DB there.
2. Updated /etc/astguiclient.conf to point this server to a local (just imported DB)
3. Followed the manual in the first post (svn checkout, db update and ./install.pl)
Everything went fine without any errors and now I'm having VERSION: 2.8-403a BUILD: 130510-1350 on my test server, BUT:
I can't browse almost all menus: most of them are empty (like users, campaigns, inbound, etc), some are not: user groups and admin menu. However when I'm trying to click on any of my ingroups I'm getting "you don't have the rights blablabla" error. The same happens when I'm trying to add new user, browse any of reports or whatever in admin area, that is not empty.
I checked my DB and tried to update my admin (6666) user's permissions directly from my database, but got no luck - everything is still the same :( Any ideas?
PierreDeux
 
Posts: 58
Joined: Tue Jul 20, 2010 8:18 am

Re: Vicibox SVN Trunk Upgrade

Postby mflorell » Thu May 30, 2013 5:47 am

Did you upgrade to 2.4 first before going through the 2.6 and 2.8 upgrade processes as shown in the UPGRADE doc?
mflorell
Site Admin
 
Posts: 18381
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Vicibox SVN Trunk Upgrade

Postby PierreDeux » Thu May 30, 2013 9:43 am

Nope. I thought since I'm already running 2.4 I should just update to 2.6.
Should I update 2.4_my_version to 2.4 latest => 2.6 => 2.8?
PierreDeux
 
Posts: 58
Joined: Tue Jul 20, 2010 8:18 am

Re: Vicibox SVN Trunk Upgrade

Postby mflorell » Fri May 31, 2013 5:44 am

There you go.
mflorell
Site Admin
 
Posts: 18381
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Vicibox SVN Trunk Upgrade

Postby Kumba » Fri Aug 02, 2013 4:26 pm

There is an upgrade script included in ViciBox v.5.0 that you might be able to use. It's located at /usr/local/bin/vicibox-upgrade.pl

It will create a 'vicibox' table on the database and run all applicable schema updates for you. If your system was already built with a version of ViciBox then you can just download it and run it. It should work fine. It does require the SVN codebase to be preasent at /usr/src/astguiclient/trunk in case you run it on something you home-brewed. You will need to run it on the database FIRST, then run it elsewhere. You will still have to read the UPGRADE document to see if there are any chanes needed in the configuration files, crontab, etc. This is only a tool to make coordinating the vicidial code update easier. It is not a hands-off solution.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: Vicibox SVN Trunk Upgrade

Postby scopor » Mon Jun 16, 2014 11:42 am

My Install vicibox 5 i686-5.0.3 ISO |Vicidial VERSION:2.8-413a Build:130928-1130 |Asterisk 1.8.23.1-Vici|Single Server|No Digium/Sangoma Hardware|No Extra Software After Installation|Intel Xeon 2.4

I was able to successfully perform the backup in step 1. I attempted to upgrade my svn trunk following this post but I am unsuccessful. Am I missing something, or did I not followed the post or did I misinterpret something? This is the error I received after about 3 minutes of running the command.

vici1:/usr/src/astguiclient # svn checkout svn://svn.eflo.net:3690/agc_2-X/trunksvn: E000110: Unable to connect to a repository at URL 'svn://svn.eflo.net/agc_2-X/trunk'
svn: E000110: Can't connect to host 'svn.eflo.net': Connection timed out

I also tried "svn up" and got similar error. vici1:/usr/src/astguiclient/trunk # svn up
Updating '.':
svn: E000110: Unable to connect to a repository at URL 'svn://svn.eflo.net/agc_2-X/trunk'
svn: E000110: Can't connect to host 'svn.eflo.net': Connection timed out

Is this server offline? I've tried this at different times and days.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby DomeDan » Tue Jun 17, 2014 4:17 am

its not down what i can see, used it yesterday and right now. copied the command you wrote and it worked so its not a typo.
make sure you have internet connection on the server.
try to ping eflo.net
if you're behind a firewall then make sure its not blocking your attempts to connect out to port 3690
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 scopor » Tue Jun 17, 2014 6:11 am

I tried pinging it but I am getting no response. I can ping eflo.net which answers to ip address 208.38.149.188. However when I ping svn.eflo.net it answers to a different IP which I suspect is a different server. This is from a different location than my vicibox server just to rule out internet. When I do a traceroute it gets timed out after the 13th hop. I know this may not be much because it depends on my location and I may go through many more hops because I am outside the US. See my traceroute results below from my house which is not where my vicibox is.

C:\Users\kcnrj>tracert svn.eflo.net

Tracing route to svn.eflo.net [97.76.33.146]
over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms 10.20.10.1
2 * * * Request timed out.
3 10 ms 8 ms 9 ms te-4-1.tt.cm01.columbustrinidad.com [200.1.111.1
89]
4 15 ms 10 ms 9 ms 200.1.111.31
5 10 ms 9 ms 12 ms xe-0-0-0.tt.edge01.columbustrinidad.com [200.1.1
11.20]
6 56 ms 66 ms 57 ms 63.245.3.41
7 59 ms 60 ms 60 ms ip67-94-116-77.z116-94-67.customer.algx.net [67.
94.116.77]
8 76 ms 75 ms 75 ms 216.156.105.66.ptr.us.xo.net [216.156.105.66]
9 78 ms 105 ms 80 ms 72-31-188-179.net.bhntampa.com [72.31.188.179]
10 84 ms 83 ms 83 ms ten0-8-0-0.tamp20-CAR2.bhn.net [71.44.1.214]
11 * * * Request timed out.
12 80 ms 82 ms 82 ms tenngig8-7.tamp27-mar1.bhn.net [71.44.3.61]
13 93 ms 91 ms 82 ms ten17-10.0.tamp07-cts1.bhn.net [65.32.37.33]
14 * * * Request timed out.
15 * * * Request timed out.
16 * * * Request timed out.
17 * * * Request timed out.
18 * * * Request timed out.
19 * * * Request timed out.
20 * * * Request timed out.
21 * * * Request timed out.
22 * * * Request timed out.
23 * * * Request timed out.
24 * * * Request timed out.
25 * * * Request timed out.
26 * * * Request timed out.
27 * * * Request timed out.
28 * * * Request timed out.
29 * * * Request timed out.
30 * * * Request timed out.

Trace complete.

C:\Users\kcnrj>
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby DomeDan » Tue Jun 17, 2014 6:38 am

svn.eflo.net does not reply on ping.
can you reach the webserver on port 80? http://svn.eflo.net
try curl from the server:
curl svn.eflo.net
or the ip
curl 97.76.33.146
you should get: "<html><body><h1>It works!</h1></body></html>"
if the ip works then its a dns problem
either fix that or copy the trunk with the ip instead: svn://97.76.33.146:3690/agc_2-X/trunk

if you still cant reach it then its probably a firewall that's blocking port 3690
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 scopor » Wed Jun 18, 2014 9:00 am

Thank you DomeDan. The server is online. I tried upgrading another Vicibox and I was able to get past the issue. So I will double check whether a firewall rule is blocking the upgrade. I saw quite a few errors while doing the sql 2.4 and 2.6 upgrade so I am not sure if I missed something or whether the error is normal.

de_2.6.sql': Table 'vicidial_dial_log_archive' already exists
ERROR 1061 (42000) at line 65 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'vddla'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 73 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'voicemail_greeting'
ERROR 1060 (42S21) at line 75 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'voicemail_greeting'
ERROR 1060 (42S21) at line 77 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'allow_voicemail_greeting'
ERROR 1060 (42S21) at line 78 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'audio_store_purge'
ERROR 1060 (42S21) at line 80 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'audio_store_purge'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 84 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'svn_revision'
ERROR 1060 (42S21) at line 86 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'svn_revision'
ERROR 1060 (42S21) at line 87 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'svn_info'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 91 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'pause_after_next_call'
ERROR 1060 (42S21) at line 92 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'owner_populate'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1050 (42S01) at line 96 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_qc_agent_log' already exists
ERROR 1050 (42S01) at line 119 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_comments' already exists
ERROR 1050 (42S01) at line 136 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_configuration' already exists
ERROR 1050 (42S01) at line 143 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_lists_custom' already exists
ERROR 1060 (42S21) at line 150 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'qc_result_type'
ERROR 1062 (23000) at line 152 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCPASS' for key 'PRIMARY'
ERROR 1062 (23000) at line 153 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCFAIL' for key 'PRIMARY'
ERROR 1062 (23000) at line 154 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCCANCEL' for key 'PRIMARY'
ERROR 1062 (23000) at line 156 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'QCFAIL' for key 'PRIMARY'
ERROR 1062 (23000) at line 158 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate entry 'qc_database_version' for key 'name'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 165 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'queuemetrics_socket'
ERROR 1060 (42S21) at line 166 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'queuemetrics_socket_url'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1050 (42S01) at line 170 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_call_time_holidays' already exists
ERROR 1060 (42S21) at line 182 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'ct_holidays'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 187 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'expiration_date'
ERROR 1060 (42S21) at line 189 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'use_other_campaign_dnc'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 193 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'enhanced_disconnect_logging'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1050 (42S01) at line 203 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_email_list' already exists
ERROR 1050 (42S01) at line 230 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_email_accounts' already exists
ERROR 1050 (42S01) at line 253 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'inbound_email_attachments' already exists
ERROR 1050 (42S01) at line 266 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_email_log' already exists
ERROR 1060 (42S21) at line 281 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'allow_emails'
ERROR 1060 (42S21) at line 283 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'allow_emails'
ERROR 1060 (42S21) at line 285 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'group_handling'
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1060 (42S21) at line 288 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'agentcall_email'
ERROR 1060 (42S21) at line 289 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'modify_email_accounts'
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1061 (42000) at line 295 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'pvmid'
ERROR 1061 (42000) at line 296 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'pdpn'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 300 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'content_transfer_encoding'
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1060 (42S21) at line 308 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'amd_inbound_group'
ERROR 1060 (42S21) at line 309 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'amd_callmenu'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 313 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'level_8_disable_add'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 317 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 318 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 319 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1060 (42S21) at line 320 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1060 (42S21) at line 321 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'uniqueid'
ERROR 1060 (42S21) at line 322 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'uniqueid'
ERROR 1060 (42S21) at line 324 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 325 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_cause'
ERROR 1060 (42S21) at line 326 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1060 (42S21) at line 327 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'sip_hangup_reason'
ERROR 1061 (42000) at line 329 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'vddllid'
ERROR 1061 (42000) at line 330 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate key name 'vdcllid'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 334 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'caller_code'
ERROR 1060 (42S21) at line 335 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'caller_code'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1050 (42S01) at line 339 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Table 'vicidial_report_log' already exists
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 356 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'lata_type'
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1060 (42S21) at line 360 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.6.sql': Duplicate column name 'survey_wait_sec'
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Are these errors normal? I read through the upgrade document as well as the svn trunk upgrade post.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby dspaan » Thu Jun 19, 2014 2:41 am

I think these errors are normal, i always see them too. It has to do with the database upgrade file which tries to create tables which already exist. Also did you also run the 2.8 file? I think there might be a 2.10 file now too, not sure.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Thu Jun 19, 2014 3:04 am

Yes, there is a 2.10 file now us well. Thus far one new feature on there. Matt doesn't sleep! :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 scopor » Thu Jun 19, 2014 8:50 am

Thanks for all your assistance. My Version: is now 2.8b0.5 and SVN Version: 2040, and DB Schema Version: 1359. Is there any other upgrade to make? How do I know I am running the latest version? Build number at bottom left corner is still saying "VERSION: 2.8-417a BUILD: 131019-0849" Is this correct what else do I need to do? I tried upgrading the database to 2.10.sql as suggested but I got error as if that file doesn't exist. Also what exactly does this link mean "\. /path/from/root/extras/upgrade_2.8.sql" as this is stated on the forum and on the UPGRADE document but it doesn't work. This is the first time I am performing an upgrade so forgive my ignorance or lack of experience. In the near future I would be able to assist other newbies as I would no longer be a newbie.

Thanks everyone for your assistance.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby scopor » Thu Jun 19, 2014 9:17 am

So I perform another "svn up" and then a database upgrade to 2.10.sql and was successful. My version is now Version: 2.10b0.5
SVN Version:2040 DB Schema Version: 1381.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby scopor » Tue Jun 24, 2014 1:30 pm

Hi All,

I have a Second Vicibox 5 i686-5.0.3 |Vicidial VERSION:2.8.517a Build:131019-0849|Asterisk 1.8.23.1-Vici|Single Server|No Digium/Sangoma Hardware|No Extra Software After Installation|Intel Xeon 2.4. I have performed the svn update following the post here.In vicidial the buttom left of the screen is VERSION: 2.10-443a
BUILD: 140617-2017 after the upgrade. I was not able to get the 2.10.sql update. I was getting an error. So my database is not up to the latest.

After the upgrade I am getting "You do not have permission to view this page" when I try to go to reports or admin/system settings, admin/servers. I had this issue with another vicibox svn trunk upgrade and I was able to resolve it but I can't recall what I did to resolve it. I repeat what I thought I did to resolve it which is to rerun the perl ./install.pl but that didn't fix the issue. Can anyone tell me what may have caused this and how to resolve it as I can't administer my server. Thanks.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby dspaan » Tue Jun 24, 2014 3:40 pm

Did you check your own user account if it is still a member of the ADMIN usergroup and if all permissions are still set to 1 on your account?
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Vicibox SVN Trunk Upgrade

Postby scopor » Tue Jun 24, 2014 4:24 pm

I cannot see the list of users. When I click users the listing is all empty.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby dspaan » Wed Jun 25, 2014 2:30 am

I was not able to get the 2.10.sql update. I was getting an error. So my database is not up to the latest.


What did you mean by this. From which version were you upgrading? My bet is you should run the database upgrade scripts again.
You can also log into the database with something like Navicat and check your users table. Or do it via the command line.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Vicibox SVN Trunk Upgrade

Postby scopor » Thu Jun 26, 2014 6:06 am

dspaan You indicated that there might be a 2.10 upgrade and Trying confirm this. I was trying \. /usr/src/astguiclient/trunk/extras/upgrade_2.10.sql upgrade. I was able to get this upgrade on my other vicibox. However I am not getting the files to download on this box. I will try the database upgrade again.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Thu Jun 26, 2014 6:28 am

Did you svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk first?
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 dspaan » Thu Jun 26, 2014 6:39 am

Just repeat all the steps again.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Vicibox SVN Trunk Upgrade

Postby scopor » Fri Jun 27, 2014 7:45 am

@dspaan I repeated all the steps again and I still have the same problem.
scopor
 
Posts: 53
Joined: Fri Oct 04, 2013 8:44 am

Re: Vicibox SVN Trunk Upgrade

Postby Trying » Fri Jun 27, 2014 10:21 am

Did you check if the 2.10 trunk is even where you expect it to be?

cd /usr/src/astguiclient/trunk
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 » Fri Jun 27, 2014 10:47 am

I say again..... do svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk on ALL servers. Then go check on the servers where it actually is. Go check in usr/src/astguiclient/trunk somewhere. If you find it then use the path where it is exactly to upgrade. If it is not there then do a search to find it. I have not done an upgrade in a while so I am not sure exactly where those files download to nowadays. Maybe Matt can help then I will adjust the instructions accordingly.
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

PreviousNext

Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 20 guests