Skip to main content

Goautodial 4 HOWTO Update latest version via Github

HOWTO Update latest version via Github


Make sure to backup your existing configuration first!

cd /var/www/html/

cp astguiclient.conf astguiclient.conf.bak
cp php/Config.php php/Config.php.bak
cp php/goCRMAPISettings.php php/goCRMAPISettings.php.bak

Update database tables:

mysql goautodial -A

ALTER TABLE go_campaigns ADD COLUMN auto_dial_level VARCHAR(20) DEFAULT 'NORMAL';
ALTER TABLE go_campaigns ADD COLUMN cb_noexpire TINYINT(1) DEFAULT '0';
ALTER TABLE go_campaigns ADD COLUMN cb_sendemail TINYINT(1) DEFAULT '0';
ALTER TABLE go_campaigns ADD COLUMN default_country_code VARCHAR(20) DEFAULT 'USA_1';
ALTER TABLE go_campaigns ADD COLUMN enable_callback_alert TINYINT(1) DEFAULT '0';
ALTER TABLE go_campaigns ADD COLUMN google_sheet_ids TEXT;
ALTER TABLE go_campaigns ADD COLUMN google_sheet_list_id BIGINT(14) UNSIGNED DEFAULT '0';
ALTER TABLE go_campaigns ADD COLUMN manual_dial_min_digits INT(11) DEFAULT '6';

ALTER TABLE users ADD COLUMN enable_chat tinyint(1) NULL DEFAULT '1';
ALTER TABLE users ADD COLUMN enable_webrtc tinyint(1)  DEFAULT '1';
use asterisk

UPDATE system_settings SET agent_whisper_enabled='1';
UPDATE system_settings SET active_voicemail_server="127.0.0.1";

Update existing GOautodial v4 web application:

cd /var/www/html/
git config --global user.email "root@localhost" 
git stash
git pull

cd /var/www/html/goAPIv2/
git stash
git pull

Edit Config.php

nano /var/www/html/php/Config.php

<?php
// database configuration
define('DB_USERNAME', 'goautodialu');
define('DB_PASSWORD', 'goautodialu1234');
define('DB_HOST', 'localhost');
define('DB_NAME', 'goautodial');
define('DB_PORT', '3306');
define('DB_NAME_ASTERISK', 'asterisk');
define('DB_USERNAME_KAMAILIO', 'kamailiou');
define('DB_PASSWORD_KAMAILIO', 'kamailiou1234');
define('DB_HOST_KAMAILIO', 'localhost');
define('DB_NAME_KAMAILIO', 'kamailio');
define('DB_PORT_KAMAILIO', '3306');

// other configuration parameters
define('CRM_ADMIN_EMAIL', 'admin@localhost.com');
?>

Edit goCRMAPISettings.php

nano /var/www/html/php/goCRMAPISettings.php

<?php
define ('gourl', 'https://YOUR_SERVER_IP_ADDRESS/goAPIv2');
define ('goUser', 'goAPI');
define ('goPass', 'KToB93bzjGd1RS4mDqePJ6Uk.jgNRrK');
define ('responsetype', 'json');
?>

To generate encrypted password

php /var/www/html/bin/pass_hasher.php --pass=UNENCRYPTED_PASSWORD

Update the vicidial_users table for goAPI example

mysql asterisk -A

UPDATE vicidial_users SET pass_hash='ENCRYPTED_PASSWORD' WHERE user='goAPI';

In the example above, the ENCRYPTED_PASSWORD is 'KToB93bzjGd1RS4mDqePJ6Uk.jgNRrK'.

mysql asterisk -A

UPDATE vicidial_users SET pass_hash='KToB93bzjGd1RS4mDqePJ6Uk.jgNRrK' WHERE user='goAPI';

Important!!! Please change the default encrypted password above to your own encrypted password.

Comments

Popular posts from this blog

Vicidial Scratch installation Alma -9

Step 1 – Download the dependencies   hostnamectl set-hostname xxxxxx.xxxxx.xxx ### Use YOUR SubDomain vi /etc/hosts ##Change domain name for actual server ip (xxx.xxx.xxx.xxx   complete domain name    subdomain only) timedatectl set-timezone Asia/Kolkata yum check-update yum update -y yum -y install epel-release yum update -y yum install git -y yum install -y kernel* #Disable SELINUX sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config     reboot Step 2 – Run the Script cd /usr/src/ git clone https://github.com/manish23k/vicidial-install-scripts cd vicidial-install-scripts chmod +x alma-rocky9-ast16.sh ./alma-rocky9-ast16.sh Or the Asterisk 18 version: chmod +x alma-rocky9-ast18.sh ./alma-rocky9-ast18.sh

Vicidial Scratch installation Debian 11 with Asterisk 16, WebRTC and Dynamic Portal

  Vicidial Scratch installation Debian 11  Asterisk 16, WebRTC and Dynamic Portal apt update apt upgrade apt-get install git nano wget cd /usr/src/ git clone https://github.com/manish23k/Vici_Install_Scripts_Deb_11.git cd Vici_Install_Scripts_Deb_11/ chmod +x *.sh Run ./vici_install_deb_ast16.sh Install WebRTC ./vicidial-install-webrtc.sh Once Done with Configuration Secure Server with Vici Dynamic Portal Run ./vici_dynportal.sh

How to delete old call logs and other logs in vicidial or goautodial.

Step 1 : SSH to the server using the Putty Step 2:   login to mysql by typing   mysql -p                    (if you dont know password try below command )               mysql -ucron -p1234 Step 3 : select the asterisk database by typing               use asterisk step 4: Run the below command to check total disk occupied by asterisk database                SELECT table_schema AS "asterisk", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema; Step 5 : Run the below command to check disk space consumed by each table in asterisk database SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "asterisk" ORDER BY (data_length + inde...