Page 1 of 1

Can Vicidial 2.0.4 use database Newest DB Schema (1135)

PostPosted: Fri Jul 17, 2009 5:07 pm
by omarrodriguezt
We have two servers running with vicidial.

One server is using vicidialnow 1.1 and the other is using vicibox

We have another server only for database purposes, that is working fine with vicidial now

We want to upgrade the database schema of the DB Server in order to have both dialers using the same database server. (for this purpose we will use the the sql script file upgrade_2.0.5.sql)


Server 1

Version of VICIDIAL: 2.0.4
Server specs 2 2.50 Ghz Quad-Core Processors and 4 GB RAM
Codecs used ( g711, gsm, ulaw, alaw)
VOIP or PSTN (Voip)
OS (Centos)


Server 2

Version of VICIDIAL: 2.0.5 Installed from vicibox iso CD (step by step)
Server Specifications (Dell Optiplex 330, Processor X86 Family 6 model 15 ~ 2393 Mhz, 2048 Memory Ram,80 GB Hard Disk)
4) Codecs used ( g711, gsm, ulaw, alaw)
5) VOIP or PSTN (Voip)
6) OS (ubuntu)
Asterisk version 1.2.26.2
DB Schema Version: 1135

Can use the newest schema on vicidialnow?

Thank you in advance.

PostPosted: Fri Jul 17, 2009 6:05 pm
by mflorell
The database schema will only work with the version it is included with.

Ok.

PostPosted: Sat Jul 18, 2009 8:07 am
by omarrodriguezt
Ok.
Thank you!

PostPosted: Sat Jul 18, 2009 3:34 pm
by williamconley
which in NO WAY implies that you cannot share the database SERVER with two vicidial installs that are entirely unaware of each other.

just change the name of the database.

mysqldump from your 2.0.4 and load into a completely different database on the mysql server, then set up the 2.0.4 vicidial server to ask for the NEW database name instead. There is NO rule that it must be named "asterisk". You can always name it Fred (or Martha, gotta give equal time here, right?). I've even been known to name it something completely unorthodox like vici-(boxname) to allow sharing among an unlimited number of vici servers which are then completely unaware of each others existence (but eventually end up sharing DNC list data!).