reloaded database Woes

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

reloaded database Woes

Postby Kinghtflyer » Thu Jun 11, 2015 6:16 pm

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?
Kinghtflyer
 
Posts: 69
Joined: Wed Sep 19, 2012 12:10 pm

Re: reloaded database Woes

Postby mflorell » Thu Jun 11, 2015 8:31 pm

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.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: reloaded database Woes

Postby williamconley » Mon Jun 29, 2015 11:04 pm

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-)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 91 guests