"Chip Bell" <[EMAIL PROTECTED]> wrote:
> The email users authenticate against a MySQL table...
Then it's not about MySQL, it's about the imap/pop3 server.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.ne
27;
Subject: RE: authentication error
Those values are good. What query is being run when the users are
authenticating? Have you looked at the explain plan for that query?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 12:22 PM
Subject: RE: authentication e
Those values are good. What query is being run when the users are
authenticating? Have you looked at the explain plan for that query?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 12:22 PM
Subject: RE: authentication error
Key_Reads 57
Key_Reads 57
Key_read_request 16218
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 1:17 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
What is the value of
key_reads/key_re
What is the value of
key_reads/key_read_request?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 12:11 PM
Subject: RE: authentication error
I had my admin turn it down from 256M to 50M and it started just dogging
at 40 connections. We're n
Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
Can you tweak your key_buffer and see what results you get?
-Original Message-
From: Chip Bell
To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 9:38 AM
Subject: RE: authenticatio
Can you tweak your key_buffer and see what results you get?
-Original Message-
From: Chip Bell
To: Chip Bell; Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 9:38 AM
Subject: RE: authentication error
My bad, just realized that read_buffer_size USED to be record_buffer
My total @ 100
bject: RE: authentication error
Ok, I have no "read_buffer" anywhere...
256M (key) + 20 (sort) * 100 (connections)
Correct?
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 10:09 AM
To: Chip Bell; Victor Pendleton; &#
: RE: authentication error
Do the math and see what your memory usage is with 100 simultaneous
connections. If I recal you said you had three gigs of ram.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 5:27 AM
Subject: RE: authentication error
Nope
Do the math and see what your memory usage is with 100 simultaneous
connections. If I recal you said you had three gigs of ram.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 7/1/04 5:27 AM
Subject: RE: authentication error
Nope, nothing out of the
The email users authenticate against a MySQL table...
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 6:12 AM
To: [EMAIL PROTECTED]
Subject: Re: authentication error
"Chip Bell" <[EMAIL PROTECTED]> wrote:
> Hello, I
"Chip Bell" <[EMAIL PROTECTED]> wrote:
> 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
ing that and watching, but you guys seem to know A
LOT more than I do so I thought someone may have seen this...or have an
idea.
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 4:45 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED]
Are you using delayed insert statements?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:50 PM
Subject: RE: authentication error
After looking through, "show variables;" the only one I found with a
value of "100" is the &
ell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
Do you have a high number of temp tables being created or high i/o?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:44 PM
Subject: RE: authentication error
No
No sir...
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 30, 2004 4:43 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
I would check to see if your server is swapping at this point.
---
Do you have a high number of temp tables being created or high i/o?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/30/04 3:44 PM
Subject: RE: authentication error
No sir...
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED
I would check to see if your server is swapping at this point.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
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
riginal Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 3:12 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
You should just become familiar with your data and the queries that are
sent
to the database. Y
/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:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 1:54 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
S
Is there anything I should set in my startup options to accommodate
this?
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 1:54 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
The val
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; [EMAIL PROTECTED]
Sent: 6/29/04 12:43 PM
Subject: RE: authentication error
Ok, we might be on to something. Right now
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 1:31 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
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
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; [EMAIL PROTECTED]
Sent: 6/29/04 12:12 PM
Subject: RE: authentication error
It's all o
ECTED]
Sent: Tuesday, June 29, 2004 1:11 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
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?
--
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; [EMAIL PROTECTED]
Sent: 6/29/04 12:05 PM
Subject: RE: authentication error
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 1:02 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
>From the mysql monitor it is `FLUSH HOSTS;` . Does the email server not
log
fail
>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; [EMAIL PROTECTED]
Sent: 6/29/04 11:55 AM
Subject: RE: authentication error
Ok, I tried to run "flush-hosts" fr
ndleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 12:53 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
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_c
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; [EMAIL PROTECTED]
Sent: 6/29/04 11:47 AM
Subject: RE: authentication error
mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 12:04 PM
To: Chip Bell; '[EMAIL PROTECTED] '
Subject: RE: authentication error
What does the error log say?
-Original Message-
From: Chip Bell
To: [EMAIL PROTECTED]
Sent: 6/29/04 9:03 AM
Subject: authentication error
Hello
What does the error log say?
-Original Message-
From: Chip Bell
To: [EMAIL PROTECTED]
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
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
33 matches
Mail list logo
