Dialer Tips

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 records with missing Last Name field within the list ‘123’. You can permutate last with first or any other column: DELETE from vicidial_list WHERE list_id=’123′ AND last_name=”; To run a […]

Creating a suppression list can be very useful when ordering new data / lists from data providers, helping you avoid purchasing duplicates. To create a suppression list, login via SSH and run the following commands: mysql -uroot -p When prompted, enter your password. The default for GoAutoDial is vicidalnow, ViciBox – blank. use asterisk; SELECT

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: For CentOs distros: yum install glibc.i686 -y For Ubuntu distros: apt-get install libc6-i386 Then run: usr/share/astguiclient/ip_replay/relay_control start Voila! *Please note that epel5 distros cannot be updated anymore as they are EOL.

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 following SQL statements: UPDATE phones set pass=’Your_Password’,conf_secret=’Your_Password’ where user_level=1; UPDATE vicidial_users set pass=’Your_Password’,phone_pass=’Your_Password’ where user_level=1;

When experiencing database problems, most often manifested by an outbound dialing issue or a time syncronization issue, try running the following command from your SSH client: mysqlcheck -u cron -p 1234 –auto-repair –check –optimize –all-databases You can also use the root MySQL credentials. Make sure to restart the asterisk service just in case: service asterisk