List:General Discussion« Previous MessageNext Message »
From:Chip Bell Date:June 30 2004 8:44pm
Subject:RE: authentication error
View as plain text  
No sir...

-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Wednesday, June 30, 2004 4:43 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error

I would check to see if your server is swapping at this point.

-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/30/04 3:27 PM
Subject: RE: authentication error

Hi Victor,

I have stumbled on to something.  The server is bouncing back and forth
b/t fast and slow.  When I do "show processlist" and its above 100, it's
slow.  When it's below, it's fine.

What variable is wrong?  I have Max_connections = 250?

Thanks

Chip

-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Tuesday, June 29, 2004 3:12 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error

You should just become familiar with your data and the queries that are
sent
to the database. You could turn on the slow query log and after a few
days
or hours or whatever see what queries are logged. 

-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 1:03 PM
Subject: RE: authentication error

Is there anything I should set in my startup options to accommodate
this?

-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Tuesday, June 29, 2004 1:54 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error

The values in the `State` and `Command` fields of the queries are what
you
should be looking at. For example if you have a select statement that is
running over an acceptable threshold you should look into that. If you
have
a query that is taking a `long` time to create a temp table , you should
look at that one. You just need to identify what is acceptable and
normal
behaviour and correct where possible.

-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 12:43 PM
Subject: RE: authentication error

Ok, we might be on to something.  Right now, the server is running fine.
I did a "show processlist" and got back 138 rows.  There are times
ranging from 0-14556.  Granted, it's an email server so people are
staying logged in...

-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Tuesday, June 29, 2004 1:31 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error

Do you have an `execessive` numer of processes running? Do you have any
processes that have been running for an `abnormal` length of time? 

-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 12:12 PM
Subject: RE: authentication error

It's all on the same box.  I'm familiar with the "show processlist" but
I don't know what to look for.  See what I mean lol?  I know most of the
commands, but not quite what I'm looking for.



-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Tuesday, June 29, 2004 1:11 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error

What is the connection like between the two servers? Once you are logged
in
can you do a show processlist and see if anything is bottelnecking the
database?

-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 12:05 PM
Subject: RE: authentication error

I ran the FLUSH HOSTS and it said "0 rows affected"  The authentication
goes against the mysql table, which is where I'm guessing the errors
would show.  When I try to log in during the "slow down" of the server,
it just hangs and hangs and finally will let me through.



-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Tuesday, June 29, 2004 1:02 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error

From the mysql monitor it is `FLUSH HOSTS;` . Does  the email server not
log
failed connection attempts?

-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 11:55 AM
Subject: RE: authentication error

Ok, I tried to run "flush-hosts" from both # and inside mysql..nada.
How can I do this exactly?  Sorry about my lack of knowledge, I'm still
green. I have my books though and am feverishly trying to find the
answer!

Thanks for your help!!

-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Tuesday, June 29, 2004 12:53 PM
To: Chip Bell; Victor Pendleton; 'mysql@stripped '
Subject: RE: authentication error

Can you view or log the errors that imap and the web authentication are
getting? Try issuing a  flush-hosts to see if the max_connect_errors was
reached. 

-----Original Message-----
From: Chip Bell
To: Victor Pendleton; mysql@stripped
Sent: 6/29/04 11:47 AM
Subject: RE: authentication error

Nothing actually.  I'm guessing I don't have "enough" logging turned on.
The only thing my servername.err files shows is

Cannot initialize InnoDB as 'innodb_data_file_path' is not set.  If you
do do not.....etc



-----Original Message-----
From: Victor Pendleton [mailto:VPendleton@stripped] 
Sent: Tuesday, June 29, 2004 12:04 PM
To: Chip Bell; 'mysql@stripped '
Subject: RE: authentication error

What does the error log say? 

-----Original Message-----
From: Chip Bell
To: mysql@stripped
Sent: 6/29/04 9:03 AM
Subject: authentication error

Hello,  I run a toaster email server which is having trouble
authenticating at times.  Both methods of authentication, imap AND web
for some reason just hang.  I'm pretty new to MySql but I figure if both
methods are trying to authenticate against the same table, the problem
is there.  I activated binary logging, what else can I do to find the
issue?

 

Thanks
Thread
authentication errorChip Bell29 Jun
  • Re: authentication errorEgor Egorov1 Jul
RE: authentication errorVictor Pendleton29 Jun
RE: authentication errorChip Bell29 Jun
RE: authentication errorVictor Pendleton29 Jun
RE: authentication errorChip Bell29 Jun
RE: authentication errorVictor Pendleton29 Jun
RE: authentication errorChip Bell29 Jun
RE: authentication errorVictor Pendleton29 Jun
RE: authentication errorChip Bell29 Jun
RE: authentication errorVictor Pendleton29 Jun
RE: authentication errorChip Bell29 Jun
RE: authentication errorVictor Pendleton29 Jun
RE: authentication errorChip Bell29 Jun
RE: authentication errorVictor Pendleton29 Jun
RE: authentication errorChip Bell30 Jun
RE: authentication errorVictor Pendleton30 Jun
RE: authentication errorVictor Pendleton30 Jun
RE: authentication errorChip Bell30 Jun
RE: authentication errorChip Bell30 Jun
RE: authentication errorVictor Pendleton30 Jun
RE: authentication errorChip Bell1 Jul
RE: authentication errorChip Bell1 Jul
  • Re: authentication errorEgor Egorov6 Jul
RE: authentication errorVictor Pendleton1 Jul
RE: authentication errorChip Bell1 Jul
RE: authentication errorChip Bell1 Jul
RE: authentication errorVictor Pendleton1 Jul
RE: authentication errorChip Bell1 Jul
RE: authentication errorVictor Pendleton1 Jul
RE: authentication errorChip Bell1 Jul
RE: authentication errorVictor Pendleton1 Jul
RE: authentication errorChip Bell1 Jul