Project

General

Profile

Forums » GOautodial Help »

Upgrade to 3.0 from 2.1 with databse on external server.

Added by Chad Fraser over 11 years ago

Hi i have a multi server setup. two goautodial, one apache and a database cluster. i got the update with no errors. the update used a local database on the server. however i want to be able to use the database on mysql cluster. is there an update sql script that i can run manually to do the update. i saw the sql scripts in the source files but i am not sure which one is the correct one. Please Help.


Replies (2)

RE: Upgrade to 3.0 from 2.1 with databse on external server. - Added by Demian Biscocho over 11 years ago

You first need to update the Vicidial database. Copy the following directories to your database server /usr/src/.

/usr/src/goautodial/
/usr/src/vicidial/

Run the following commands:

cd /usr/src/vicidial/extras
mysql -p asterisk -f < upgrade_2.4.sql
mysql -p asterisk -f < upgrade_2.6.sql

This will output messages that you can safely ignore.

You then need to install the GOautodial database:

cd /usr/src/goautodial/sql
mysql -p asterisk -f < asterisk.sql
mysql -p -f < goautodial.sql
mysql -p -f < limesurvey.sql

Restart your database server and let us know how it goes.

    (1-2/2)     Go to top