Hello.
Searching through the code shown me that all stuff is located in
sql/hostname.cc file. MySQL depends on gethostbyaddr_r and uses
the "official" name of the host which it returns. According to
rfc897:
"Hosts have an official (or primary) name and possibly several
nicknames. When
"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; &#
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; '[EMAIL PROTECTED] '
Subject
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 ju
Can you do a ps -ef | grep mysql? I would like to see the output.
-Original Message-
From: Daniel Shriver
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 5/10/04 3:55 PM
Subject: Re: authentication problem on non-standard port
Victor Pendleton wrote:
>Are you specifyi
Victor Pendleton wrote:
Are you specifying either the socket or the host/port combination? What
types of error messages are you getting
Here is an example of it working and not working (with machine,
usernames omitted)
$ mysql -h -u -p
Enter password:
Welcome to the MySQL monitor. Commands
Are you specifying either the socket or the host/port combination? What
types of error messages are you getting
-Original Message-
From: Daniel Shriver
To: [EMAIL PROTECTED]
Sent: 5/10/04 3:24 PM
Subject: authentication problem on non-standard port
I am having problems authenticating to
Nicholas Fitzgerald wrote:
go to the command prompt and use mysql or mysqladmin I get "access
deniged for user "@localhost". No "root" or anything like that. I don't
know where I screwed up, but I obviously screwed up something. Any ideas
out there on how I can get back in control of this situa
"ketvin" <[EMAIL PROTECTED]> wrote:
> Access denied for user: '@localhost' to database 'database'
>
>
> I have a database named 'database' and i got this problem while trying to
> get it run. I am connecting that database to localhost without user and
> password, it works just fine on my previous
While connected to MySQL, issue the following instruction:
GRANT ALL PRIVILEGES to 'YourChoosesUsername'@'%' ON `database`
I don't remember exactly the syntax, but I think this should work. It means,
you giving all the permissions to the user YourChoosenUsername and you are
allowing him/her to
At 9:17 +0200 6/17/03, Laura del Cano wrote:
Hello,
I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000.
I create a new database in Mysql and a user with all the privileges on it
(using GRANT ALL privileges...).
I create a User DSN in the windows Control Panel and when I test the
connec
Dan,
Friday, April 05, 2002, 3:21:46 AM, you wrote:
DE> I tried to add a user to my mysql system for the MTA (exim) but am having a
DE> hard time making it work.
DE> I used grant to give exim permissions:
DE> grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD
DE> ;
DE> and
did you FLUSH (reload) your mysql server?
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Dan Egli" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 6:21 PM
Subject: Authentication messed up?
> I trie
From: Don Smith <[EMAIL PROTECTED]>
> our other alternative ms sql server 2000 which has the ability to
> authenticate off samba
Uh, oh! Another of our brethren is being tempted by the Dark Side.
I doubt that MySQL could be easily coerced into external authentication, since the
existing authe
I would like to use a single sign on for samba, mysql, and login...is
this possible?
our other alternative ms sql server 2000 which has the ability to
authenticate off samba.is external authentication on the todo list?
many thanks
don smith
44 matches
Mail list logo
