How to upgrade from 2.0.3bx.y to 2.0.3bu.v

[eijal]

Hi,
How can I upgrade correctly a 2.0.3bx.y version?
For example now I am running a 2.0.3b4.5. And I am sure that so soon Vicidial version will be something like 2.0.3b5.5. Is it enough upgrading just the tables? like in the upgrade_2.0.3.sql document says

Code: Select all

mysql
use asterisk
\. /path/from/root/extras/upgrade_2.0.3.sql
quit


Or what else we must be carefull
Could you write this kind of upgrading in the .../extras/upgrade_2.0.3.sql document
Thanks

[mflorell]

Those are the instructions for upgrading from the last full release(2.0.2), to upgrade from one beta to another you need to open the upgrade_2.0.3.sql file and only update the newer SQL statements that you have not already run.

[eijal]

Ok
It could be posible to say us what are the newer SQL statements in the upgrade_2.0.3.sql or in another file?
Remember, we don't know the tables, scripts, etc. like you Matt. Some times we can forget something.

PD.
For upgrading from beta to beta I think, this is necessary:

Code: Select all

- cd /usr/src/astguiclient
- svn checkout svn://205.201.151.21:43690/agc_2-X
- cd agc_2-X/trunk/
- perl install.pl
- mysql
- use asterisk
- /path/from/root/extras/NewerSqlStatements_2.0.3.sql
- quit


Thanks

[mflorell]

the upgrade_2.0.3.sql file is written in sequential order of when I made database changes, What I usually do is look at the live database and see where the last change was implemented and then run all of the SQL statements after that one, not the best solution I know, I will have to figure out a way to make this more easy to follow in future releases.

[eijal]

Hi Matt
Now I am in a production environment, I am using vicidial version 2.0.3b4.5
I want to upgrade to vicidial version 2.0.3b5.5. In what I must be carefull?

THANKS

[dlapitan]

Hi,

is there any changes from 2.0.3b4 to 2.0.3b5?

[mflorell]

Yes.

Here are the MySQL changes since 2.0.4b4:

Code: Select all

ALTER TABLE system_settings ADD queuemetrics_eq_prepend VARCHAR(255) default 'NONE';

ALTER TABLE system_settings ADD vicidial_agent_disable ENUM('NOT_ACTIVE','LIVE_AGENT','EXTERNAL','ALL') default 'NOT_ACTIVE';

ALTER TABLE vicidial_campaigns ADD disable_alter_custdata ENUM('Y','N') default 'N';

ALTER TABLE vicidial_users ADD alter_custdata_override ENUM('NOT_ACTIVE','ALLOW_ALTER') default 'NOT_ACTIVE';

ALTER TABLE vicidial_campaigns ADD no_hopper_leads_logins ENUM('Y','N') default 'N';

ALTER TABLE phones ADD enable_sipsak_messages ENUM('0','1') default '0';

ALTER TABLE system_settings ADD allow_sipsak_messages ENUM('0','1') default '0';

ALTER TABLE system_settings ADD admin_home_url VARCHAR(255) default '../vicidial/welcome.php';


[dlapitan]

Hi,

Thanks matt,

Do i still need to run the 2.0.3b5 installer in order to upgrade from 2.0.3b4? or just run the above mysql.

thanks

[mflorell]

Yes, you need to run "perl install.pl" to get the new scripts into their proper place. You also need to either reboot or kill all of the screens that are running and run the ADMIN_keepalive_ALL.pl script.