Page 1 of 1

Vicidial Database

PostPosted: Thu Jan 19, 2017 3:53 am
by justicemudzova
Good day, l am new to this forumn and l am looking for assiastance. I have been tasked to install and tasked to confihure Vicidial, Pliz may you assist on how l can backup and restore the Vicidial Databes?

Re: Vicidial Database

PostPosted: Thu Jan 19, 2017 6:41 am
by mflorell
Here's the built-in backup script in VICIdial:

# /usr/share/astguiclient/ADMIN_backup.pl --help
allowed run time options:
[--db-only] = only backup the database
[--db-settings-only] = only backup the database without leads, logs, servers or phones
[--db-without-logs] = do not backup the log tables in the database
[--db-without-archives] = do not backup the archive tables in the database
[--dbs-selected=X] = backup only selected databases, default uses conf file db only
to backup databases X and Y, use X---Y, can use --ALL-- for all dbs on server
you can use --ALLNS-- for all non-mysql dbs(will ignore 'test', 'mysql','information_schema')
This feature will NOT work with '--db_raw_files_copy' option
[--conf-only] = only backup the asterisk conf files
[--without-db] = do not backup the database
[--without-conf] = do not backup the conf files
[--without-web] = do not backup web files
[--without-sounds] = do not backup asterisk sounds
[--without-voicemail] = do not backup asterisk voicemail
[--without-crontab] = do not backup crontab
[--ftp-transfer] = Transfer backup to the 'REPORTS' FTP server
[--ftp-server=XXXXXXXX] = OVERRIDE FTP server to send file to
[--ftp-login=XXXXXXXX] = OVERRIDE FTP user
[--ftp-pass=XXXXXXXX] = OVERRIDE FTP pass
[--ftp-dir=XXXXXXXX] = OVERRIDE remote FTP server directory to post files to
[--debugX] = super debug
[--debug] = debug
[--test] = test
[--db_raw_files_copy] = if set the backup won't be a mysql dump. It will tar the /var/lib/mysql folder. WARNING, THIS OPTION WILL STOP THE MYSQL SERVER!
[--archive_path=/PATH/FROM/ROOT] = absolute path to store the resulting backup

This will create gz files, one of which contains the database, just move that file to the new server, unzip it and import it into mysql.

Re: Vicidial Database

PostPosted: Thu Jan 19, 2017 9:07 am
by justicemudzova
Another question, can Vicidial be Virtualised? For example having a Windows Hyper V with a Vicidial Database Virtual Machine?

Re: Vicidial Database

PostPosted: Thu Jan 19, 2017 10:14 am
by mflorell
CAN it be virtualized? Yes. SHOULD it be virtualized? No.

Virtualization causes all sorts of problems with VICIdial because it's a Real-Time system, it's not a good idea at all, and we tell clients that all the time, yet new clients keep trying every month :)

Re: Vicidial Database

PostPosted: Thu Jan 19, 2017 2:40 pm
by frequency
mflorell wrote:CAN it be virtualized? Yes. SHOULD it be virtualized? No.

Virtualization causes all sorts of problems with VICIdial because it's a Real-Time system, it's not a good idea at all, and we tell clients that all the time, yet new clients keep trying every month :)


I have a machine with 16c-32threads, 256g ram with 2x3 hdd on raid-10, running over KVM and hosting about 25 servers without any issues. Another node with 8 cores running 6 servers. Only good for 12 agents and less people only. load average on the node stays 8.00 to 14.00 during peak hours since cronjobs run all the same time on all the servers. you cannot run on public virtualised environment easily. Load average on each kvm box remains between 3 to 4 with each server have 4c/8t

Risk is big since if the node goes down due to any technical fault, all 25 clients ring your bells. Hence we replace our equipment every year to minimize the equipment failure.

Re: Vicidial Database

PostPosted: Fri Jan 20, 2017 2:52 am
by justicemudzova
Thank you for all the help. Is there any Graphical (GUI) way to manage the Database?

Re: Vicidial Database

PostPosted: Fri Jan 20, 2017 6:41 am
by mflorell
When you say "manage the database", what exactly do you mean?

Re: Vicidial Database

PostPosted: Fri Jan 20, 2017 8:00 am
by justicemudzova
I mean something like myphp admin which is a full GUI mySQL Database Manager.

Re: Vicidial Database

PostPosted: Fri Jan 20, 2017 11:05 am
by jshasteen
Nothing built into Vicidial but your can always download a tool like Heidi SQL and point it at your Vicidial asterisk database.

Re: Vicidial Database

PostPosted: Mon Jan 23, 2017 9:04 am
by justicemudzova
jshasteen wrote:Nothing built into Vicidial but your can always download a tool like Heidi SQL and point it at your Vicidial asterisk database.


I sthey a document or guide l can follow to setup that up?