vicidial.org

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

Those errors are fine when running that command, it means they had already been run, it causes no harm.

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

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

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.

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?

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

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.

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