What writes to the vicibox MySQL table?

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

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

What writes to the vicibox MySQL table?

Postby AkkerKid » Fri Oct 26, 2018 9:29 am

I've inherited a cluster and need to add servers to it.
I've found the vicibox table on the primary DB is either far out of date or completely wrong all together.
It's got only three servers with IPs and passwords that aren't applicable to my setup.
Is there any process I can run on a live system to update or rewrite the vicibox table based on the current active settings?
I'd rather not attempt to rebuild it by hand if at all possible.
Thanks!

Other info:
New server with vicibox 8.1
Existing servers seem to have the vicidial-install file of 8.0
Current and desired cluster svn revision is 3032
Have one DB server, 15 dialers.
Web traffic is load balanced using pfSense as a round-robin relay across dialer servers. That seems to work great but I'd like to add dedicated web servers to cover all troubleshooting baicsa and best practice recommendations.
DB: Dual E5-2697 12-core @ 2.7GHz, 128GB DDR3, RAID1 240GB SSD, 45GB SWAP is never used.
Dialers: 15X Single CPU E3-1231 @ 3.4GHz, 16GB DDR3, 256GB SSD, 2GB SWAP, Amfeltec PCI-e timing card
Vicibox 8.1 Build 3032
250-280 agent upper limit before meltdown
AkkerKid
 
Posts: 15
Joined: Mon Sep 15, 2014 10:57 am

Re: What writes to the vicibox MySQL table?

Postby Kumba » Fri Oct 26, 2018 9:34 am

Unfortunately there isn't any sort of process to rebuild that table. The most important thing is to make sure it has the correct SVN version set on the database entry.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: What writes to the vicibox MySQL table?

Postby AkkerKid » Fri Oct 26, 2018 9:52 am

That needs to be the SVN version of vici as a whole, correct? IE: 3032, in my case... I'm verifying because I've seen references to a revision of the database as if the revision of the table structure was a separate thing with a much lower number. Is that relevant or even a real thing?
Thanks!
DB: Dual E5-2697 12-core @ 2.7GHz, 128GB DDR3, RAID1 240GB SSD, 45GB SWAP is never used.
Dialers: 15X Single CPU E3-1231 @ 3.4GHz, 16GB DDR3, 256GB SSD, 2GB SWAP, Amfeltec PCI-e timing card
Vicibox 8.1 Build 3032
250-280 agent upper limit before meltdown
AkkerKid
 
Posts: 15
Joined: Mon Sep 15, 2014 10:57 am

Re: What writes to the vicibox MySQL table?

Postby Kumba » Fri Oct 26, 2018 11:01 am

AkkerKid wrote:That needs to be the SVN version of vici as a whole, correct? IE: 3032, in my case... I'm verifying because I've seen references to a revision of the database as if the revision of the table structure was a separate thing with a much lower number. Is that relevant or even a real thing?
Thanks!


Correct, that needs to be the SVN revision that was used on the currently installed database. Assuming no one has messed with anything since the last ViciDial install, you can run 'svn info /usr/src/astguiclient/trunk' to see what SVN revision your database is on or by looking in the Admin --> System Settings page.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida

Re: What writes to the vicibox MySQL table?

Postby williamconley » Fri Oct 26, 2018 1:32 pm

Never hurts to verify with:

Code: Select all
diff /srv/www/htdocs/vicidial/admin.php /usr/src/astguiclient/trunk/www/vicidial/admin.php


If there's no output, those files are identical and it's very likely your SVN repository (or at least the one at/usr/src/astguiclient/trunk) is what's currently installed in the server.

We've had a few instances ... 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: 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 46 guests