Verification:Upgrade GOautodial CE 2.1 to the latest version (3.0)
Added by ed dagohoy over 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 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 11 years ago
Hi,
Tried to edit /etc/goautodial.conf but still nothing.