Date: Tue, 23 Aug 2011 15:29:28 +0800 From: Gi Dot <gadidot@gmail.com> To: freebsd-pf@freebsd.org Cc: freebsd-net@freebsd.org Subject: Error - mysql_connect: Operation not permitted. Message-ID: <CAHGGWY6HRy=_%2ByV_3ymAr8jwJXg2xxFtua5Tuc6cuHkoAMOD6Q@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
Hi, I'm getting the following errors in my apache22 log: [Mon Aug 22 23:09:02 2011] [error] [client 192.168.30.10] PHP Warning: mysql_connect(): Operation not permitted in /usr/local/sites/xxx/demonlords4.lib.php on line 23, referer: http://a.b.com/main.php?location=missiondungeon&action=launchstop&perform=start&mid=358 [Mon Aug 22 23:09:03 2011] [error] [client 192.168.30.10] PHP Warning: mysql_connect(): [2002] Operation not permitted (trying to connect via tcp://10.10.10.101:3306) in /usr/local/sites/xxx/demonlords4.lib.php on line 23, referer: http://a.b.com/main.php?location=group [Mon Aug 22 23:09:03 2011] [error] [client 192.168.30.10] PHP Warning: mysql_connect(): Operation not permitted in /usr/local/sites/xxx/demonlords4.lib.php on line 23, referer: http://a.b.com/main.php?location=group . . . [Tue Aug 23 07:31:46 2011] [error] [client 192.168.30.10] PHP Warning: mysql_pconnect(): MySQL server has gone away in /usr/local/sites/xxx/test.php on line 282, referer: http://a.b.com/test.php [Tue Aug 23 07:31:50 2011] [error] [client 192.168.30.10] PHP Warning: mysql_pconnect(): MySQL server has gone away in /usr/local/sites/xxx/test.php on line 282 I just wonder if it could be caused by improper configurations in my pf.conf. I have found a couple of threads where the users managed to solve the problem by lowering the value of tcp.closed. It doesn't work for me though (I lowered the value from 90s to 15s). My apache22 run on jails and managed by haproxy. Both haproxy and apache22 reside in the same server (haproxy runs on host, apache22 run on 2 jails). Database also running on a jail but on a different host. All jails are using private IP addresses. Following is my pf.conf on web server(haproxy-1.4.15 & apache-2.2.19): http://pastebin.com/HM7jWH3X And this is my pf.conf on db server (mysql-server-5.5.14): http://pastebin.com/vFB7Jagt Both servers' uname -a: 8.2-RELEASE FreeBSD 8.2-RELEASE #7: Sun Jul 17 06:32:10 CEST 2011 root@webm01.xx.xx:/usr/obj/usr/src/sys/WEBM01 amd64 Appreciate any advice offered. Thanks.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAHGGWY6HRy=_%2ByV_3ymAr8jwJXg2xxFtua5Tuc6cuHkoAMOD6Q>