Are Your Calls Marked as Spam?

If you have noticed that your calls have been marked as spam or have been blocked by major mobile carriers such as AT&T, T-mobile or …

How to export callbacks from ViCiDial

In order to export all callbacks (CBHOLD) from the entire dialer, please log into the MySQL and run the following query: SELECT * FROM vicidial_list …

How to reduce dialer database size by deleting logs

Small, clean database will always perform better than a huge one. In order to see what is the total size of all the databases in …

Finding files larger than … in Linux

In order to locate any files larger than a certain size, please run the following command. The below example searches for all files larger than …

Searching for a string in Asterisk

If you wish to search for a certain string in Asterisk only (Example: only show carrier congestion), launch the Asterisk CLI along with the grep …

Deleting recordings older than X days

To remove recordings older than X days (i.e. 3 days), SSH into your dialer and run the following command: find /var/spool/asterisk/monitorDONE/MP3 -type f -mtime +3 …

How to export leads with certain disposition only from ViCiDial / GoAutoDial using PHPMyAdmin

To export only leads with a specific disposition (in this example SALE) from only certain campaigns (in this example 1000, 2000), please log in to …

How to export all leads from specific certain cities from the entire database / dialer

Just run the following from your MySQL / MariaDB console: SELECT first_name, last_name, address1, city, postal_code, phone_number FROM vicidial_list WHERE list_id in (select list_id from vicidial_lists) and city in ('X','Y','Z') …

Installing Fail2Ban on a CentOS server

If you are running a predictive dialer (or any kind of Asterisk server) or a web hosting server, you have probably experienced often hacker/lamer brute force attempts. These attacks …

Resetting only specific call statuses within a specific campaign

Sometimes, admin would like to change / reset only specific dial statuses within only specific campaign – i.e. Reset all NA, NI, NP and similar …

Deleting ViCiDial list records with missing information

Some list vendors will often sell low-quality dialer lists with a lot of missing information. As an example, here is a command to delete all …

How to create a lookup / relation field in vTiger 7

When creating a fields, following changes are needed in database: vtiger_field table – change typeofdata from the current value whatever it might be to I~O vtiger_field table – …

How to create a ViCiDial Suppression List

Creating a suppression list can be very useful when ordering new data / lists from data providers, helping you avoid purchasing duplicates. To create a …

Monitor / Barge Problem on GoAutoDial 3.3 / ViCiDial

GoAutoDial CE 3.3 monitoring and barge function do not work out of the box. To fix this, log in via SSH and run the following commands: …

IncredbilePBX 13 No Audio / RTP Problem Fix

IncrediblePBX (beefed up FreePBX) is one of our favorite PBX distros. The version 13 by ingenious Ward Mundy is even better than it’s predecessors but …

Removing a valid IP from IPTables or blacklisting a hacker IP

To remove a valid IP address from the iptables, log in via SSH and enter the following commands: iptables-save > tmp_file nano tmp_file Remove / delete …

vTiger Comments Time Format

Lot of our clients using vTiger have complained about the default Comments time format (X days ago and similar). To use a more standard timestamp, please …

Updating all user and phone password in ViCiDial from the command line

To simultaneously update all of the username and phone passwords in ViCiDial, please log in to your MySQL (or PhpMyAdmin, if available) and run the …

Fix the Time Synchronization problem with ViCiDial

When experiencing database problems, most often manifested by an outbound dialing issue or a time synchronization issue, try running the following command from your SSH …

Robocalls / Press1

The Federal Communications Commission (FCC) has taken steps to address the Robocall problem by adopting rules that allow carriers to proactively block certain kinds of …

Our PBXs are now in the cloud!

Due to needed increase in security, stability and reliability, we have moved all of our hosted PBX systems to Amazon AWS or Vultr cloud instances, …

ViCiDial + WebRTC Integration

Imagine using your ViCiDial dialer without the need to install, configure and constantly deal with softphones such as Zoiper, X-lite, Eyebeam and similar. As a …

vTiger 7.X CE Roles Fix

Fresh installs of self-hosted vTiger 7 come with a bug where leads and opportunities are not visible for any newly created roles unless the user …