vicidial.org

Hi,

I am having an issue with a manual dial campaign where it gives me the error below if I try to do the second dial after dispositioning the first.

System Delay, Please try again
code:19499 - 1 - 0

It only seems to happen if the my iptables filter is applied

Code: Select all

Chain INPUT (policy DROP)
target     prot opt source               destination
ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0
WHITELIST      all  --  0.0.0.0/0            0.0.0.0/0
DROP       all  --  0.0.0.0/0            0.0.0.0/0            match-set geoblock src
DROP       all  --  0.0.0.0/0            0.0.0.0/0            match-set badips src
ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0
ACCEPT     all  --  0.0.0.0/0            0.0.0.0/0            ctstate ESTABLISHED
ACCEPT     icmp --  0.0.0.0/0            0.0.0.0/0            ctstate RELATED
input_ext  all  --  0.0.0.0/0            0.0.0.0/0
LOG        all  --  0.0.0.0/0            0.0.0.0/0            limit: avg 3/min burst 5 LOG flags 6 level 4 prefix "SFW2-IN-ILL-TARGET "
DROP       all  --  0.0.0.0/0            0.0.0.0/0

The first rule accepts packets from the loopback
Second rule allows certain IPs and blocks the rest.

If the first two rules are enabled then I get the issue, which is strange because that how I whitelist ips on a couple of other similar installations without any issues.

Anyone know what could be causing this?

Setup:
Single server install
VERSION: 2.14-661a
BUILD: 180222-0017

That issue is usually related to database load, I haven't seen a firewall cause it to trigger before.

Have you looked at slow queries on your database server?

How do we know slow queries on your database server ? Thank you

You have to make sure your database server has "log_slow_queries" in it's /etc/my.cnf file. If not, you won't be logging slow queries.

After that, you just have to look for where the slow query file is located, which depends on the version of MySQL/MariaDB you are using, and your database settings. In one of our db servers, it is located here: /var/lib/mysql/mysqld-slow.log

Just an update,

I was able to resolve the issue by adding the following to the firewall:

Code: Select all

-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT

Thanks for letting us know SPAMSAM!

This firewall thing sounds like it could be important.

JM