MySQL Connection Problems
Hello all,
I'm running into a intermittent and very annoying problem with all of
my servers. I'm currently running FreeBSD 4.11, exim-4.51-0, and
mySQL 4.1.13. My exim config is setup to have exim do a mySQL lookup
in order to determine whether a given user's e-mail is hosted by our
e-mail servers.
Periodically, Exim throws the following error into its panic log:
Feb 9 13:24:51 mx_server_1 exim[69953]: 2006-02-09 13:24:51 failed to
expand ${lookup mysql {select distinct domain from email_table where
domain='$domain'}{$value}} while checking a list: lookup of select
distinct domain from email_table where domain='bob.com' gave DEFER:
MYSQL connection failed: Can't connect to MySQL server on
'127.0.0.1' (61)
(where bob.com is one of our customer's domains that we host.)
This has been happening for months, and I'm trying to get rid of
these errors. The come in bursts - in a single second, I could get as
many as 30 to 40 of these messages.
Now, I've taken a few different steps to track this down, but the
problem is very elusive and hard to replicate. The mySQL error logs
are unhelpful. I'm sure that my mySQL server isn't running out of
connections, because if it was, I would receive a too many
connection error message. (I deliberately lowered the max number of
mySQL connections to test this.)
I'm wondering if there's a system level limit that I'm running into
that would be independant of exim or mySQL's configuration. I'm a
little hazy in this area, but I would be talking about some sysctl
variable, a ulimit on open sockets, or something to that effect.
I'm rather stumped on this issue, so if anyone has any suggestions or
hints on what might be causing this error or where I might start
looking to find the root cause of the problem, I would be very grateful.
Thanks,
Michael Jeung
NIS on FreeBSD 5.4/4.11
Good evening all, I am desperately trying to get NIS working in my FreeBSD 5.4 and 4.11 environment - specifically, I'm trying to get NIS set up such that a NIS client is able to change the password for an account. Like a good little rabbit, I have followed, step-by-step the NIS guide in the handbook: http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/network- nis.html In my test environment, I have two servers set up: BoxA and BoxB. BoxA is the NIS Master running 5.4, BoxB is the NIS client running 4.11. I have created a NIS user named charlie on BoxA. I am able to log into BoxB as charlie. Great so far, right? ypcat demonstrates that the correct user on BoxB is coming down and ypwhich passwd shows that BoxA is BoxB's daddy. Now, I want to be able to change charlie's NIS password while I'm logged into BoxB. Here's where I run into problems. Whenever I run yppasswd or passwd as charlie, I get Permission Denied. I know I've run into this error before (without ever being able to fix it) and after googling for quite some time, I've been unable to find anyone else who seems to be running into this problem -- but I know other people must have encountered this before, because I'm not doing anything fancy. This is the most vanilla install of NIS I can create. If anyone has any hints on where I should look from here, I would very much appreciate it! Thanks, Michael Jeung
routed on lo0 device
Hello everyone, I'm trying to get past a sticky routing situation by running routed on all of my machines in my server cluster. I've been instructed by several sources of authority that the best solution for a multi-homed ip address scenario is bind the ip addresses to the loopback device and use routed to advertise their presence. I'm having difficulty getting routed to bind to the loopback device. By default, routed seems to think the loopback device should be in passive mode - which causes routed to completely ignore all ips associated with the device. (Perhaps this is to avoid advertising routes to 127.0.0.1?) In any case, I was just curious as to whether anyone has every dealt with a situation like this before. Is there some sort of trick to getting routed to work with the loopback device? I want the loopback device to be active for routed, not passive. Thanks! Michael Jeung ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
