Project

General

Profile

Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0)

Added by ed dagohoy over 10 years ago

Hi,

My setup:

DB:
DB name was change from asterisk to asterisk1.
root password was change also.

Question: Do I have to change all to its original DB name and root password to default before i update it to lates version?

Newbie


Replies (9)

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by Demian Biscocho over 10 years ago

Yes. You need to revert them back to the default settings (DB name, password and etc) before you upgrade.

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by ed dagohoy over 10 years ago

and also the location of my DB is in different host. Do I have to revert it back to the asterisk/web host?

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by Demian Biscocho over 10 years ago

You can manually update your DB server. Is it a dedicated DB server with a vanilla CentOS or is it also from the GOautodial CE ISO?

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by ed dagohoy over 10 years ago

Hi,

Done updating to new version 3.0. But when i import back the DB to different host and type the IP 192.168.0.2 it showed an error.

error message: Unable to connect to your database server using the provided settings.

DB: 192.168.0.3
asterisk/web: 192.168.0.2(mysql-stop)

When i start the mysql in 192.168.0.2 it opens(no error) and the data(like campaign,list,etc) is not from .3 but instead from .2. I already update the settings in /etc/astguiclient to point to .3 but still nothing.It seems like it will look to its default setting. Where can i modify it to point it to my new db host?

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by ed dagohoy over 10 years ago

@ Demian Biscocho

The DB is in different host and also installed using goautodial.

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by Demian Biscocho over 10 years ago

The upgrade document is for a single server GOautodial CE system. You need to adapt the instructions for a multi-server GOautodial system.

On the DB server, copy the following (from one of your updated Asterisk servers):

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

You then need to manually update the Asterisk and GOautodial databases.

mysql -f -p<$PASSWORD> asterisk /usr/src/vicidial/extras/upgrade_2.4.sql
mysql -f -p<$PASSWORD> asterisk /usr/src/vicidial/extras/upgrade_2.6.sql
mysql -f -p<$PASSWORD> asterisk /usr/src/goautodial/sql/asterisk.sql
mysql -f -p<$PASSWORD> goautodial /usr/src/goautodial/sql/goautodial.sql
mysql -f -p<$PASSWORD> limesurvey /usr/src/goautodial/sql/limesurvey.sql

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by ed dagohoy about 10 years ago

Hi,

Tried to access https://IP/login/ but the credentials still default and the data seems generated from the host itself,even if i updated the /etc/astguiclient/ to a new DB server(same goautodial). Then campaigns only showed test campaign and also the the rest supposedly generated from the DB did not appeared.

https://IP/vicidial/admin.php << works fine.. the data from DB displayed properly..

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by Demian Biscocho about 10 years ago

You also need to edit /etc/goautodial.conf in your web server and point the database IP address to your DB server.

RE: Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0) - Added by ed dagohoy about 10 years ago

Hi,

Tried to edit /etc/goautodial.conf but still nothing.
    (1-9/9)
    Go to top