mysql
5 posts.
Running the VICIdial database on its own server
Splitting MySQL onto a dedicated database server frees the telephony box for Asterisk and opens the door to replication. Here is when and how to do it.
Read postWhy installing VICIdial yourself is harder than it looks
A clean VICIdial install means compiling Perl and Asterisk, sorting codecs and NAT, tuning MySQL, and wiring the keepalive cron. The 3am failure modes are where it bites.
Read postCommon VICIdial install errors and fixes
The install errors that actually stop a VICIdial build — missing Perl modules, Asterisk compile failures, MySQL grant problems, and SELinux — and how to clear each one.
Read postRunning a VICIdial database schema upgrade
When VICIdial code expects new columns, you run the upgrade SQL script to bring the schema forward. Here is what the ALTER scripts do and how to run them safely.
Read postSetting up MySQL/MariaDB for VICIdial
What VICIdial needs from its database: the asterisk database, the cron and DB users, MyISAM tables, basic tuning, and keeping the DB on the right box.
Read post