vicibox 5.0.3 and restoring data from 4.0.3

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

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

vicibox 5.0.3 and restoring data from 4.0.3

Postby bghayad » Sun Sep 01, 2013 6:32 am

Hello;

vicibox 5.0.3, vicidial 2.8b0.5, Build 130605-0841, asterisk 1.4.39.1-vici, Single Machine, Vtiger 5.4

I installed vicibox 5.0.3, I took backup from vicibox 4.0.3 and vicidial 2.8b0.5 and the Build 130605-0841 and restore it for asterisk database for this vicibox 5.0.3.

The problem that, when I am going to Admin --> system settings, I can not see any information. WHY?

I applied the following:

Code: Select all
lab:/usr/src/astguiclient/trunk/extras #  mysql -f --database=asterisk < upgrade_2.8.sql
ERROR 1060 (42S21) at line 3: Duplicate column name 'ct_holidays'
ERROR 1060 (42S21) at line 7: Duplicate column name 'failed_login_count'
ERROR 1060 (42S21) at line 8: Duplicate column name 'last_login_date'
ERROR 1060 (42S21) at line 9: Duplicate column name 'last_ip'
ERROR 1060 (42S21) at line 10: Duplicate column name 'pass_hash'
ERROR 1060 (42S21) at line 12: Duplicate column name 'pass_hash_enabled'
ERROR 1050 (42S01) at line 32: Table 'vicidial_monitor_calls' already exists
ERROR 1050 (42S01) at line 50: Table 'vicidial_monitor_log' already exists


What I have to do? Do I miss something?

Regards
Bilal
bghayad
 
Posts: 579
Joined: Sun Jan 01, 2012 4:53 pm

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby mflorell » Sun Sep 01, 2013 6:51 am

Those errors are fine when running that command, it means they had already been run, it causes no harm.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby bghayad » Sun Sep 01, 2013 10:05 am

I agree with you. But still the problem existed.
What is the problem? The problem that I am not able to see any information in the admin --> System Settings and not able to set any values for any parameter (even if I selected for example the time zone and did submit, it is not stored !).

But these information in the admin --> System Settings are existed if the database is fresh (that is created during installation) and I can do any changes and settings.

What is the reason for this?

Regards
Bilal
bghayad
 
Posts: 579
Joined: Sun Jan 01, 2012 4:53 pm

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby bghayad » Sun Sep 01, 2013 11:25 am

OK, I ran upgrade_2.6.sql and then upgrade_2.8.sql, I am able to find some information in admin --> System Settings and I am able to set values for the parameters.

But, there is another problem I also noticed it now .. It is the list. The list is not existed if I used the database that was bring from vicibox 4.0.3 but if I used the default database, then it is available. What could be the reason for this?

From the other side, I came back to the vicibox 4.0.3 and I went for list then for load leads and I noticed that the version is 2.6 (really I do not know why it is 2.6 and not 2.8 while the vicidial is 2.8 and it is clear in the system settings of the vicibox 4.0.3 machine).

Just to declare, I am now using vicibox 5.0.3 and trying to bring the data from the vicibox 4.0.3 and I am facing these problems .. The most important one is the disappearing for List !

Regards
Bilal
bghayad
 
Posts: 579
Joined: Sun Jan 01, 2012 4:53 pm

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby Kumba » Sun Sep 01, 2013 7:37 pm

Or you could just use the vicibox-upgrade script that is already in ViciBox v.5.0.3. Just load your data in, and then run 'vicibox-upgrade'. It will take care of the schema updates for you.

So, here's how you do it:

1) run vicibox-install
2) copy database from old server to new server
3) run 'vicibox-upgrade'

you might want to delete the vicibox table by typing 'drop table vicibox' into mysql, but it will upgrade the schema and everything for you.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby actiondave » Thu Sep 17, 2015 6:25 pm

I am still using 4.0.3 and have zero issues.

I do want to upgrade to the latest version. I have a "spare" server in place ready for restore if my other server dies. Can I just install the latest version on the spare server and restore the the backup from my 4.0.3 version?

Is it that simple? Or do I have to upgrade in a sequence first?
New Setup:Vicibox Redux.x86 64-4.0.3
Database/Webserver - Asus KFSN4-DRE/SAS | 2x AMD Opteron 2356 Quad Core |8GB RAM

Telephony Server: HP Proliant DL380 G5 - 2x 2.5GHz Xeon Quad Core - 16GB RAM

Archive Server - 1.7GHz (recordings)
actiondave
 
Posts: 63
Joined: Mon Jun 20, 2011 9:46 pm

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby brell » Fri Sep 18, 2015 9:29 am

hey people, I am new in using vicidial, so I would to know how do I get started please assist me cuz its very urgent
brell
 
Posts: 1
Joined: Fri Sep 18, 2015 9:20 am

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby williamconley » Fri Sep 18, 2015 3:43 pm

brell wrote:hey people, I am new in using vicidial, so I would to know how do I get started please assist me cuz its very urgent

Download Vicibox.com's ISO image and follow the instructions in the PDF on that site. (Vicibox is the Approved Installer for Vicidial.)

After installation, configure Vicidial by using the Vicidial Manager's Manual available (free and paid versions) at EFLO.net's store. If you bump into a problem in the manual, be sure you started at PAGE 1 and did not skip ANYTHING. Bring us the page, line and problem. Post what you did and expected to happen, and of course what really happened and we'll see about getting you all the way to a functioning server.
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: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: vicibox 5.0.3 and restoring data from 4.0.3

Postby williamconley » Fri Sep 18, 2015 3:45 pm

actiondave wrote:I am still using 4.0.3 and have zero issues.

I do want to upgrade to the latest version. I have a "spare" server in place ready for restore if my other server dies. Can I just install the latest version on the spare server and restore the the backup from my 4.0.3 version?

Is it that simple? Or do I have to upgrade in a sequence first?

Yes, if all you do is restore the Database (not the rest of the code or configurations) and run the upgrade command as listed below (in theory).

We usually upgrade the db manually, but if Kumba has a restore command ... I'd go with it. 8-)

Verify that the Asterisk version is correct after the upgrade under Admin->servers and that the IP is correct (if not, you can just run the IP update script, of course).
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: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 57 guests