33 messages in com.mysql.lists.mysqlRE: authentication error
FromSent OnAttachments
Chip Bell29 Jun 2004 07:02 
Victor Pendleton29 Jun 2004 09:03 
Chip Bell29 Jun 2004 09:47 
Victor Pendleton29 Jun 2004 09:52 
Chip Bell29 Jun 2004 09:55 
Victor Pendleton29 Jun 2004 10:02 
Chip Bell29 Jun 2004 10:05 
Victor Pendleton29 Jun 2004 10:10 
Chip Bell29 Jun 2004 10:11 
Victor Pendleton29 Jun 2004 10:31 
Chip Bell29 Jun 2004 10:42 
Victor Pendleton29 Jun 2004 10:53 
Chip Bell29 Jun 2004 11:03 
Victor Pendleton29 Jun 2004 12:11 
Chip Bell30 Jun 2004 13:27 
Victor Pendleton30 Jun 2004 13:42 
Chip Bell30 Jun 2004 13:43 
Victor Pendleton30 Jun 2004 13:44 
Chip Bell30 Jun 2004 13:50 
Victor Pendleton30 Jun 2004 14:09 
Egor Egorov01 Jul 2004 03:11 
Chip Bell01 Jul 2004 03:26 
Chip Bell01 Jul 2004 04:09 
Victor Pendleton01 Jul 2004 07:08 
Chip Bell01 Jul 2004 07:16 
Chip Bell01 Jul 2004 07:38 
Victor Pendleton01 Jul 2004 07:50 
Chip Bell01 Jul 2004 10:11 
Victor Pendleton01 Jul 2004 10:16 
Chip Bell01 Jul 2004 10:22 
Victor Pendleton01 Jul 2004 10:28 
Chip Bell01 Jul 2004 10:33 
Egor Egorov06 Jul 2004 06:46 
Subject:RE: authentication error
From:Victor Pendleton (VPen@hoovers.com)
Date:06/29/2004 10:31:07 AM
List:com.mysql.lists.mysql

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; mys@lists.mysql.com 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:VPen@hoovers.com] Sent: Tuesday, June 29, 2004 1:11 PM To: Chip Bell; Victor Pendleton; 'mys@lists.mysql.com ' 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; mys@lists.mysql.com 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:VPen@hoovers.com] Sent: Tuesday, June 29, 2004 1:02 PM To: Chip Bell; Victor Pendleton; 'mys@lists.mysql.com ' 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; mys@lists.mysql.com 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:VPen@hoovers.com] Sent: Tuesday, June 29, 2004 12:53 PM To: Chip Bell; Victor Pendleton; 'mys@lists.mysql.com ' 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; mys@lists.mysql.com 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:VPen@hoovers.com] Sent: Tuesday, June 29, 2004 12:04 PM To: Chip Bell; 'mys@lists.mysql.com ' Subject: RE: authentication error

What does the error log say?

-----Original Message----- From: Chip Bell To: mys@lists.mysql.com 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