Vicidial Scratch Only Databse server

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Vicidial Scratch Only Databse server

Postby maninutech » Thu Sep 15, 2016 8:07 am

HI,

VERSION: 2.12-563a
BUILD: 160801-2119
Svn : 2578


We installed MYSQL Database server on Centos server and we installed separate vicibox server added web and telephony server .we are able to get conference call recording's happening


Database server installation step:


yum -y install mysql mysql-server mysql-devel rdate svn


/etc/init.d/mysqld start
mysql_secure_installation
chkconfig mysqld on

service mysqld stop
cp /etc/my.cnf /etc/my.cnf.original
echo "" > /etc/my.cnf

vi /etc/my.cnf ; copy the below config to this file.

[mysql.server]
user = mysql
#basedir = /var/lib

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
datadir = /var/lib/mysql
#tmpdir = /home/mysql_tmp
socket = /var/lib/mysql/mysql.sock
user = mysql
old_passwords = 0
ft_min_word_len = 3
max_connections = 800
max_allowed_packet = 32M
skip-external-locking

log-error = /var/log/mysqld/mysqld.log

query-cache-type = 1
query-cache-size = 32M

long_query_time = 1
#slow_query_log = 1
#slow_query_log_file = /var/log/mysqld/slow-queries.log

tmp_table_size = 128M
table_cache = 1024

join_buffer_size = 1M
key_buffer = 512M
sort_buffer_size = 6M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M

max_tmp_tables = 64

thread_cache_size = 8
thread_concurrency = 8

# If using replication, uncomment log-bin below
#log-bin = mysql-bin

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
#log-error = /var/log/mysqld/mysqld.log
#pid-file = /var/run/mysqld/mysqld.pid

mkdir /var/log/mysqld
mv /var/log/mysqld.log /var/log/mysqld/mysqld.log
touch /var/log/mysqld/slow-queries.log
chown -R mysql:mysql /var/log/mysqld
service mysqld restart
Update the Timezone :


Configure the system time and update it.
Customize the timezone. Take a look inside /usr/share/zoneinfo/ for all possible values.
rm /etc/localtime
ln -sf /usr/share/zoneinfo/Asia/Kolkata /etc/localtime
rdate -s nist1-ny.ustiming.org


mysql -u root –p

CREATE DATABASE `asterisk` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'cron'@'localhost' IDENTIFIED BY '1234';
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO cron@'%' IDENTIFIED BY '1234';
GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES on asterisk.* TO cron@localhost IDENTIFIED BY '1234';
GRANT RELOAD ON *.* TO cron@'%';
GRANT RELOAD ON *.* TO cron@localhost;
flush privileges;
quit

mkdir /usr/src/astguiclient
cd /usr/src/astguiclient
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk

mysql -u root -p

Enter these MySQL commands:
mysql>SET GLOBAL connect_timeout=60;
mysql>use asterisk;
mysql>\. /usr/src/astguiclient/trunk/extras/MySQL_AST_CREATE_tables.sql
mysql>\. /usr/src/astguiclient/trunk/extras/first_server_install.sql
mysql>\. /usr/src/astguiclient/trunk/extras/sip-iax_phones.sql

mysql>quit



Please confirm that we are following correct methode or the wrong one ?
maninutech
 
Posts: 13
Joined: Tue Feb 11, 2014 4:55 am

Re: Vicidial Scratch Only Databse server

Postby williamconley » Thu Sep 15, 2016 9:29 pm

You should install the DB server with the Vicibox.com .iso. After that, you should install the Web/Dialer servers which will be automatically clustered to the DB server during installation. That's one of the BIG reasons the Vicibox .iso is so good: Multi-Server installation is built-in.

If you have a deep-seated reason to use CentOS for the DB (not a good idea, but if you have someone in IT with a problem, it happens, LOL), use the Goautodial installation CD, upgrade that server to the latest version of Vicidial .... THEN use the Vicibox.com .iso to add new servers for the rest of the servers.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicidial Scratch Only Databse server

Postby boybawang » Tue Oct 04, 2016 10:00 pm

It is working correctly, but I suggest you use MariaDB 5.5 instead of MySQL 5.5
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 988
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 60 guests