Page 1 of 1

reloaded database Woes

PostPosted: Thu Jun 11, 2015 6:16 pm
by Kinghtflyer
Hello everyone,
Inherited disgruntled OSdial user with supermicro servers purchased from OSdial.
Per my recommendations, they successfully loaded a single server and installed latest Vicidial preload and entered all their users and extension phones and campaigns and I built successfully their carrier info. Then it was discovered their local 'Guy' who installed neglected to build the server's RAID.

I did a mysqldump of the asterisk data, then they built the Raid array and reinstalled Vici. All was well until I did mysql -uroot asterisk <Vici.sql

I can ssh login and look at the restored vici tables all is well.
the web server dies trying to render the welcome screen after entering credentials. What am I missing?

Re: reloaded database Woes

PostPosted: Thu Jun 11, 2015 8:31 pm
by mflorell
How exactly is the "web server dying"?

When you say vicidial preload, do you mean vicibox preload? If so, what specific version?

We have had a few OSDial users call us in the last few months, apparently the project is no longer being supported. Unfortunately, OSDial forked the Vicidial database schema about 6 years ago and did some other things in very inefficient ways(like custom fields) that are not compatible with how Vicidial does them, so it's very difficult to do a full move over to Vicidial. Basic lead data and basic user data should move just fine, but there are just too many database changes to expect an OSDial DB dump to work with any Vicidial version from the last few years.

Re: reloaded database Woes

PostPosted: Mon Jun 29, 2015 11:04 pm
by williamconley
If there was an upgrade or change in the DB structure between your first and second runs ... the page is likely dying because the DB is out-of-date. Either downgrade your Vicidial code or upgrade the DB. Instructions in the UPGRADE document in the source code folder (/usr/src/astguiclient/trunk, most likely).

Did you drop and create the DB to avoid any possible conflicts from the fresh install vs the competing loading DB?

Did you verify that the fresh install worked before bringing the DB back into the server? Yep, installs fail from time to time... and you can spend quite a bit of time before finding out the CD is corrupt! 8-)