What writes to the vicibox MySQL table?

[AkkerKid]

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.

[Kumba]

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.

[AkkerKid]

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!

[Kumba]

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.

[williamconley]

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