Wrong APF forewall configuration is creating problem for mysql connections ??
Recently I have configured APF firewall for the mysql server.
But I am getting the error for a database and the user as:
040725 12:50:29 Aborted connection 299028 to db: 'atul' user: 'atul' host: `x.x.x.x' (Got an error reading communication packets)
040725 12:50:29 Aborted connection 299028 to db: 'atul' user: 'atul' host: `x.x.x.x'(Got an error reading communication packets)
040725 12:50:29 Aborted connection 299028 to db: 'atul' user: 'atul' host: `x.x.x.x' (Got an error reading communication packets)
I amn't getting why this is so?I think due to wrong configuration of ports in firewall file,this is showing the error .Yesterday my mysql server went down and I suppose this could be the reason..
Again when I checked my /var/log/messages I found the message
Jul 26 06:41:21 kernel: ** IN_TCP DROP ** IN=eth0 OUT= MAC=x:x:x:x:x:x:x:x SRC
=x.x.x.x DST=x.x.x.x LEN=48 TOS=0x04 PREC=0x00 TTL=112 ID=61239 DF PROTO=TCP SPT=4278 DPT=5554 WIN
DOW=16384 RES=0x00 SYN URGP=0
I think this is a wrong port configuration.And I guess both of the errors are co-related...
my port configuration is :
IG_TCP_CPORTS="21,22,25,53,80,110,143,443,465,953,993,995,2082,2083, 2086,2087, 2095, 2096,3000_3500,6666"
What Should i do now?
Please help !!!
