Vicidial Database

[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?

[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.

[justicemudzova]

Another question, can Vicidial be Virtualised? For example having a Windows Hyper V with a Vicidial Database Virtual Machine?

[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

[frequency]

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.

[justicemudzova]

Thank you for all the help. Is there any Graphical (GUI) way to manage the Database?

[mflorell]

When you say "manage the database", what exactly do you mean?

[justicemudzova]

I mean something like myphp admin which is a full GUI mySQL Database Manager.

[jshasteen]

Nothing built into Vicidial but your can always download a tool like Heidi SQL and point it at your Vicidial asterisk database.

[justicemudzova]

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?