Page 1 of 1

Vicidial update

PostPosted: Tue Mar 30, 2021 5:47 am
by frank83
Hello guys,
I would like to update the installation of vicidial from VERSION: 2.14-766a BUILD: 200816-0912 to VERSION: 2.14-787a BUILD: 210211-1145, which is the best way to do it?
I've a cluster installation with 1 DB, 1 WEB, 1 SIP.

I found this procedure:

- mkdir /usr/src/astguiclient
- cd /usr/src/astguiclient
- svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk
- cd trunk
- perl install.pl

Upgrade schema
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.8.sql

Is it still valid?

Re: Vicidial update

PostPosted: Tue Mar 30, 2021 1:57 pm
by carpenox

Re: Vicidial update

PostPosted: Wed Mar 31, 2021 4:44 am
by frank83
Thanks carpenox.

Re: Vicidial update

PostPosted: Wed Mar 31, 2021 7:45 am
by carpenox
no prob bud, hope it helped

Re: Vicidial update

PostPosted: Thu Apr 01, 2021 3:47 am
by frank83
Sorry if I bother you again but I have a latest question, should the sql file always be executed?
Because I try to update the vicidial version: 2.14-787a BUILD: 210211-1145 and when i run mysql -p -f --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql I receive a lot of errors like these:

ERROR 1050 (42S01) at line 9: Table 'parked_channels_recent' already exists
ERROR 1060 (42S21) at line 18: Duplicate column name 'internal_chat_type'
ERROR 1060 (42S21) at line 19: Duplicate column name 'internal_chat_type'

Re: Vicidial update

PostPosted: Thu Apr 01, 2021 9:04 am
by carpenox
thats ok, its just tables that already exist, the new ones are still added. youre good

Re: Vicidial update

PostPosted: Fri Apr 02, 2021 2:09 am
by frank83
Thanks again bud.