How to get the latest GOadmin code through GIThub¶

Github - GoAutoDial Repositories¶

URL: https://github.com/goautodial

Install git on your GOautodial CE server:¶

Install git from GoAutoDial Repository

yum install -y git

Move the /var/www/html and /usr/share/goautodial folders:¶

mv /var/www/html /var/www/html.orig
mv /usr/share/goautodial /usr/share/goautodial.orig

Checkout or clone a working copy on your local machine.¶

cd /var/www/
git clone https://github.com/goautodial/ce-www.git html

NOTE: This will download the latest version committed on our Github repository and will create a new local folder "html" in /var/www

Make sure to copy .htaccess to your new html folder¶

cp /var/www/html.orig/.htaccess /var/www/html/

cd /usr/share/
git clone https://github.com/goautodial/ce-share.git goautodial

NOTE: This will download the latest version committed on our Github repository and will create a new local folder "goautodial" in /usr/share

To update your working copy or get current updates:¶

cd /var/www/html
git pull
cd /usr/share/goautodial
git pull

For more info about GIThub and git's command, login to http://git-scm.com/docs

Once done updating, make sure to change the permission of the following folders inside your html root directory to 777:¶

cd /var/www/html
chmod 777 data
chmod 777 uploads
chmod 777 cache

Make sure to create the following tables in their respective databases:¶

Log-in on MySQL console, type

mysql -p

Once logged in, copy/paste the following queries on the MySQL console

use goautodial;

CREATE TABLE IF NOT EXISTS `go_server_settings` (
  `username` varchar(20) collate utf8_unicode_ci NOT NULL,
  `company_name` varchar(100) collate utf8_unicode_ci NOT NULL,
  `company_logo` varchar(100) collate utf8_unicode_ci NOT NULL,
  `theme_color` varchar(50) collate utf8_unicode_ci NOT NULL,
  `login_color` varchar(50) collate utf8_unicode_ci NOT NULL,
  `login_button` varchar(100) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `go_server_settings` (`username`, `company_name`, `company_logo`, `theme_color`, `login_color`, `login_button`) VALUES
('admin', 'GoAdmin ® 3.0', 'goautodial_logo.png', '59b42d', 'FFFFFF', 'portal-login-button.png');

CREATE TABLE IF NOT EXISTS `go_language` (
  `id` int(6) UNSIGNED NOT NULL auto_increment,
  `lang` varchar(10) collate utf8_unicode_ci NOT NULL,
  `name` varchar(100) collate utf8_unicode_ci NOT NULL,
  `path` varchar(255) collate utf8_unicode_ci,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

INSERT INTO `go_language` (lang,name,path) VALUES('en_us','English (US)','english');
INSERT INTO `go_language` (lang,name,path) VALUES('fil','Filipino','filipino');
INSERT INTO `go_language` (lang,name,path) VALUES('es','Spanish','spanish');
INSERT INTO `go_language` (lang,name,path) VALUES('it','Italian','italian');

use asterisk;

CREATE TABLE IF NOT EXISTS `vicidial_list_archive` (
  `lead_id` int(9) unsigned NOT NULL auto_increment,
  `entry_date` datetime default NULL,
  `modify_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `status` varchar(6) default NULL,
  `user` varchar(20) default NULL,
  `vendor_lead_code` varchar(20) default NULL,
  `source_id` varchar(50) default NULL,
  `list_id` bigint(14) unsigned NOT NULL default '0',
  `gmt_offset_now` decimal(4,2) default '0.00',
  `called_since_last_reset` enum('Y','N','Y1','Y2','Y3','Y4','Y5','Y6','Y7','Y8','Y9','Y10') default 'N',
  `phone_code` varchar(10) default NULL,
  `phone_number` varchar(18) NOT NULL,
  `title` varchar(4) default NULL,
  `first_name` varchar(30) default NULL,
  `middle_initial` varchar(1) default NULL,
  `last_name` varchar(30) default NULL,
  `address1` varchar(100) default NULL,
  `address2` varchar(100) default NULL,
  `address3` varchar(100) default NULL,
  `city` varchar(50) default NULL,
  `state` varchar(2) default NULL,
  `province` varchar(50) default NULL,
  `postal_code` varchar(10) default NULL,
  `country_code` varchar(3) default NULL,
  `gender` enum('M','F','U') default 'U',
  `date_of_birth` date default NULL,
  `alt_phone` varchar(12) default NULL,
  `email` varchar(70) default NULL,
  `security_phrase` varchar(100) default NULL,
  `comments` varchar(255) default NULL,
  `called_count` smallint(5) unsigned default '0',
  `last_local_call_time` datetime default NULL,
  `rank` smallint(5) NOT NULL default '0',
  `owner` varchar(20) default '',
  `entry_list_id` bigint(14) unsigned NOT NULL default '0',
  PRIMARY KEY  (`lead_id`),
  KEY `phone_number` (`phone_number`),
  KEY `list_id` (`list_id`),
  KEY `called_since_last_reset` (`called_since_last_reset`),
  KEY `status` (`status`),
  KEY `gmt_offset_now` (`gmt_offset_now`),
  KEY `postal_code` (`postal_code`),
  KEY `last_local_call_time` (`last_local_call_time`),
  KEY `phone_list` (`phone_number`,`list_id`),
  KEY `list_phone` (`list_id`,`phone_number`),
  KEY `list_status` (`list_id`,`status`),
  KEY `rank` (`rank`),
  KEY `owner` (`owner`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0;

CREATE TABLE `go_agent_sessions` (
  `agent_session_id` int(11) NOT NULL auto_increment,
  `sess_agent_user` varchar(25) collate utf8_unicode_ci NOT NULL,
  `sess_agent_phone` varchar(25) collate utf8_unicode_ci NOT NULL,
  `sess_agent_status` varchar(25) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`agent_session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE system_settings ADD COLUMN default_language varchar(10) DEFAULT 'en_us';