Hi, I'm using freebsd 6.1 and _sometimes_ (one for every ~30-40 minutes) I get mysql connect errors with permission denied. The mysql_connect returns error code 1, which is permission denied. The same happed to me when i tried to open a tcp connection between jails and it wasn't mysql related. The same happened sometimes this dawn with a sendmail host lookup. On the console I got the permission denied. I don't really know what could cause this, but it's like a buffer gets full. I use pf for filtering and nat. I checked pfctl -si which says there are ~800-1000 states, so it's well below the max 10000. The question is that what could cause this thing and what should we try to solve this. Errors: sendmail[37085]: gethostbyaddr(IP) failed: 1 Can't connect to MySQL server on 'IP' (1) netstat -m 298/812/1110 mbufs in use (current/cache/total) 286/396/682/25600 mbuf clusters in use (current/cache/total/max) 286/322 mbuf+clusters out of packet secondary zone in use (current/cache) 0/0/0/0 4k (page size) jumbo clusters in use (current/cache/total/max) 0/0/0/0 9k jumbo clusters in use (current/cache/total/max) 0/0/0/0 16k jumbo clusters in use (current/cache/total/max) 646K/995K/1641K bytes allocated to network (current/cache/total) 65610/107271/98848 requests for mbufs denied (mbufs/clusters/mbuf+clusters) 0/0/0 requests for jumbo clusters denied (4k/9k/16k) 0/0/0 sfbufs in use (current/peak/max) 0 requests for sfbufs denied 0 requests for sfbufs delayed 45726 requests for I/O initiated by sendfile 118 calls to protocol drain routines Regards, Andras
Hi, On Fri, 19 May 2006 15:49:25 +0200 Andras Got <andrej@antiszoc.hu> wrote:> The question is that what could cause this thing and what should we try to solve this. > > Errors: > sendmail[37085]: gethostbyaddr(IP) failed: 1 > Can't connect to MySQL server on 'IP' (1)Don't know about the second error, but I believe the first one is printed by following chunk of src/contrib/sendmail/src/conf.c ======== start of the quote ======= sm_syslog(LOG_WARNING, NOQID, "gethostbyaddr(%.100s) failed: %d", anynet_ntoa(sa), #if NAMED_BIND h_errno #else /* NAMED_BIND */ -1 #endif /* NAMED_BIND */ ); ======== end of the quote ======= netdb.h has following description for that error number in h_errno: #define HOST_NOT_FOUND 1 /* Authoritative Answer Host not found */ So that specific error looks like a problem on your DNS.
On Fri, May 19, 2006, Andras Got wrote:> I'm using freebsd 6.1 and _sometimes_ (one for every ~30-40 minutes) I > get mysql connect errors with permission denied. The mysql_connect > returns error code 1, which is permission denied.Quite certainly not true:> Errors: > sendmail[37085]: gethostbyaddr(IP) failed: 1^^^^^^^^^^^^^> Can't connect to MySQL server on 'IP' (1)/usr/include/netdb.h:#define HOST_NOT_FOUND 1 /* Authoritative Answer Host not found */ HTH, -- sh -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 187 bytes Desc: not available Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20060520/de34556c/attachment.pgp