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 […]
Deleting ViCiDial list records with missing information Read More »
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 – change uitype from the current value to 10 vtiger_fieldmodulerel table – create a new row containing the original fieldid from the vtiger_field table, module where the data is located, module where the data should be
How to create a lookup / relation field in vTiger 7 Read More »
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
How to create a ViCiDial Suppression List Read More »
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.
Monitor / Barge Problem on GoAutoDial 3.3 / ViCiDial Read More »
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 it does have some drawbacks. Regardless of if the installation is done ‘from scratch’ or from the ISO, many users report problems with no audio when iptables is running. Solution
IncredbilePBX 13 No Audio / RTP Problem Fix Read More »
To remove a valid IP address from the iptables, log in via SSH and enter the following commands: iptables-save > tmp_filenano tmp_file Remove / delete the line containing the valid IP address iptables-restore < tmp_file & iptables-save To block an IP (example 111.222.333.444), please use the following command: iptables -A INPUT -s 111.222.333.444 -j DROP
Removing a valid IP from IPTables or blacklisting a hacker IP Read More »
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 edit the /modules/Vtiger/helpers/util.php file. Comment out the original $dateTime function and enter the following instead for imperial: public static function formatdatediffinstrings($datetime) {// http://www.php.net/manual/en/datetime.diff.php#101029$dateTime = Vtiger_Datetime_UIType::getDBDateTimeValue($dateTime);return date(“m-d-Y h:i:s a”, strtotime($dateTime));
vTiger Comments Time Format Read More »
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;
Updating all user and phone password in ViCiDial from the command line Read More »
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
Fix the Time Synchronization problem with ViCiDial Read More »
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 calls that are likely to be unlawful because they come from improper or invalid phone numbers, including those that do not or cannot make outgoing calls. Check out the details
Robocalls / Press1 Read More »
© OneCentVoIP, a brand of Omnia Business Solutions. Web by Internetize.Me.