Cache Hosts - Which are tempting max_connect_errors?

2008-12-02 Thread Tuc at T-B-O-H.NET
why they didn't say to just use --skip-cache-host . Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [mysql] Re: SELECT to return 0 instead of NULL?

2008-05-23 Thread Tuc at T-B-O-H.NET
> > On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote: > > Hi, > > > >I'm running a query : > > > > SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; > > > >But if the

SELECT to return 0 instead of NULL?

2008-05-23 Thread Tuc at T-B-O-H.NET
can't change the application, but I can change the SQL) Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Connection time out/slow response from server

2007-05-30 Thread Tuc at T-B-O-H.NET
happening? I'm using TCPWrappers to help control access to the database instead of going to firewall rules. I'd rather not do this, defeats what TCPWrappers was all about. Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

TCPWrappers and database unavailibility

2007-05-23 Thread Tuc at T-B-O-H.NET
s not responding" Is there something I can do to prevent this from causing all the problems? Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connections with bad DNS cause lockups

2005-09-14 Thread Tuc at T-B-O-H
clues? Thanks, Tuc > Hello. > > When I suggested to create a trace file, I wanted to find the place > where mysqld hangs. In my opinion, it is possible. You should > research the last entries at the end of the trace file (using tail, > for example) after mysql has hung.

Re: Connections with bad DNS cause lockups

2005-09-05 Thread Tuc at T-B-O-H
so that if it does start to become uncontactable I'll get paged. Thanks, Tuc > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >Ok. Is there a way to get a timestamp in the file too? If > > this happens while I'm not ne

Re: Connections with bad DNS cause lockups

2005-09-05 Thread Tuc at T-B-O-H
Hi, Ok. Is there a way to get a timestamp in the file too? If this happens while I'm not near a machine I want to make sure I can find the right time frame in the file. Thanks, Tuc > > Hello. > > When I suggested to create a trace file, I wanted

Re: Connections with bad DNS cause lockups

2005-09-03 Thread Tuc at T-B-O-H
ot show any attempts from the hosts that are causing the problems. Thanks, Tuc > > Hello. > > > To make the suggestions, we should have enough amount of information. > If your MySQL server isn't heavy loaded, create a trace file and find > out the

Re: Connections with bad DNS cause lockups

2005-09-03 Thread Tuc at T-B-O-H
the database (A searchable orchid database) stop, and monitoring detects it down and pages out. Thanks, Tuc > > >> > >> > >So if thats the way (FreeBSD ports), then besides the already > > suggested > > changing to pure IP, is the

Re: Connections with bad DNS cause lockups

2005-09-02 Thread Tuc at T-B-O-H
ended way to run MySQL on FreeBSD is compiling it from the > ports. > > So if thats the way (FreeBSD ports), then besides the already suggested changing to pure IP, is there any other ways to stop the DOS? Thanks, Tuc -- MySQL General Mailing List For l

Re: Connections with bad DNS cause lockups

2005-09-01 Thread Tuc at T-B-O-H
l, so it would mean that every time they added/deleted a host, I would have to be told of it. I think /etc/hosts would also do forward DNS only, while TCPWrappers also wants reverse DNS (PTR). While in concept the suggestion is a work around, I think it then breaks every thing around it.

Re: Connections with bad DNS cause lockups

2005-09-01 Thread Tuc at T-B-O-H
rom "hosts: files dns" to just "hosts: files"? Would be a SLIM possibility, if this wasn't a machine that didn't only do MySQL and other things in my TCPWrappers (/etc/hosts.allow) did partial domain matching for clients. Thanks, Tuc > >

Re: Connections with bad DNS cause lockups

2005-09-01 Thread Tuc at T-B-O-H
tion! Just also seems difficult to keep proper documentation if we are using IPs and not complete hostnames. Thanks, Tuc > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >We seem to be running into a probl

Connections with bad DNS cause lockups

2005-08-30 Thread Tuc at T-B-O-H
hine outside the /24. At times, all of a sudden the server seems to "freeze". It appears that we've narrowed it down to an issue with people attacking the server that come from a site that has a bad reverse DNS setup. Has anyone else seen this, or knows how to stop it?

flush-hosts/tcpwrapper problems

2005-02-01 Thread Tuc
ot;, it runs quite slow. Has anyone heard/seen/experienced this? On some other customer servers, we just had to put "mysqld:ALL" into /etc/hosts.allow to prevent the database from becoming unusable. Thanks, Tuc/TTSG Internet Services, Inc. -- MySQL General

Looking to resolve odd response to DOS

2005-01-04 Thread Tuc
ot;, it runs quite slow. Has anyone heard/seen/experienced this? On some other customer servers, we just had to put "mysqld:ALL" into /etc/hosts.allow to prevent the database from becoming unusable. Thanks, Tuc/TTSG Internet Services, Inc. -- MySQL General

MYSQL dies after FreeBSD 4.6.2-cvsup-4.7

2003-01-29 Thread Tuc
Any ideas where to start? Tried to recompile mysql to see if it just needed that, and it didn't change anything. (This is 3.23.54a) Thanks, Tuc/TTSG Internet Services, Inc. - Before posting, please

Re: Re: Cannot compile on BSDI

2001-09-05 Thread Tuc
t; After you run the configure, edit the "client/Makefile", and remove the "-fno-exceptions". Tuc/TTSG Internet Services, Inc. database,sql,query,table database,sql,query,table database,sql,query,table

-fno-exceptions and BSDI 4.0.1/gcc 2.7.2.1

2001-08-16 Thread Tuc
nts for 8 4.0.1 systems, and the server will be on Solaris 2.7 and BSDI 4.2 . Are we safe just removing it from the Makefile? Thanks, Tuc/TTSG Internet Services, Inc. database,sql,query,table - Before postin

FINALLY, got a core!

2001-07-03 Thread Tuc
So, where do I go from here?! Thanks, Tuc/TTSG Internet Services, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: Host "" is not allowed to connect to this MySQL Server

2001-06-27 Thread Tuc
ne or more of the systems decides it can't talk to the server, I just run that and its all happy again. Thanks, Tuc/TTSG Internet Services, Inc. - Before posting, please check: http://www.mysql.com/man

FOLLOWUP - Seg Fault/No core, WHY?

2001-05-17 Thread Tuc
nfigure/install and it was ok. We need to fall back and continue trying to debug why the install falls over, and (to a lesser extent) why it doesn't produce a core. (Then again, to debug, it might take producing the core first so there is something to

Seg Fault/No core, WHY?

2001-05-16 Thread Tuc
I know the first thing people will say is "UPGRADE", but I'd like to see if there is something we can do while we try to schedule this with the user. Or, something we should do when we put the lastest in incase it has t