Hi all,
I am trying to implement PAM authentication plugin. I am using Server
version: 5.6.15-enterprise-commercial-advanced. I am following these steps:
mysql show variables like '%plugin%';
+---++
| Variable_name | Value
Does that depend on mysql running as root in order to see /etc/shadow (or
whatever)?
If so, that is too big a security hole to do.
-Original Message-
From: Ignacio Ocampo [mailto:naf...@gmail.com]
Sent: Sunday, August 12, 2012 3:54 PM
To: mysql
Subject: MySQL LDAP Authentication
in order to see /etc/shadow
(or whatever)?
If so, that is too big a security hole to do.
-Original Message-
From: Ignacio Ocampo [mailto:naf...@gmail.com]
Sent: Sunday, August 12, 2012 3:54 PM
To: mysql
Subject: MySQL LDAP Authentication Plugin - Full example with source
code
I have published in my blog, an full example (with source code) of a LDAP
Authentication plugin for MySQL.
http://nafiux.com/blog/2012/08/11/mysql-ldap-authentication-plugin/
--
Ignacio Ocampo
about possible
causes or needs to know they're not alone.
The setup is simple: a site on a staging environment that hasn't been used in a
few weeks is suddenly unable to connect to the database. The error message
makes it clear that it's an authentication issue, not a connection issue
Hello,
currently i have mod auth_mysql configured and running as plaintext password:
1. how can i generate crypt_des passwords to store in database?
2. how can i get a user log out once the browser tab is closed. seems i have
to close the browser and reopen, then only i am presented login
authentication system is logging you on as 'empty' user.
you will be ok after that ;)
Man, thanks a ton! That was it!
I'll have to look into why/how an empty user was created... but
at least it's fixed now.
Beers!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
authentication system is logging you on as 'empty' user.
you will be ok after that ;)
Man, thanks a ton! That was it!
I'll have to look into why/how an empty user was created... but
at least it's fixed now.
Beers!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hello - I'm only moderately familiar with mysql; the following issue has me
stumped.
I just noticed that some scripts on one of my client's servers suddenly
started failing due to being no longer able to log into the mysql db.
I have not touched the mysql config on that machine in months.
The
Just a stab but what's the max connect set to ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Saturday 31 July 2010 4:30:00 chaim rieger wrote:
Just a stab but what's the max connect set to ?
Thanks a ton for the quick response - I'm at wits end, been working on
this for hours!
max_connections is set to 0.
(but it is also set to 0 on another server, which largely follows the
same
Another thing I just noticed
In your first example you are using localhost, which probably means you are
connecting via network
The second option you don't define a host, which means you're prolly using
socket connection
--
MySQL General Mailing List
For list archives:
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
Another thing I just noticed
In your first example you are using localhost, which probably means you are
connecting via network
The second option you don't define a host, which means you're prolly using
socket connection
Oh, whoops -
after login to mysql issue:
select user();
and
select current_user();
and post output
you will see they dont match.
Claudio
On 8/1/2010 1:47 AM, Corey wrote:
On Saturday 31 July 2010 4:40:14 chaim rieger wrote:
Another thing I just noticed
In your first example you are using localhost,
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:
after login to mysql issue:
select user();
and
select current_user();
and post output
you will see they dont match.
/usr/local/mysql/bin/mysql -h localhost -u scripts -p
Enter password:
Welcome to the MySQL monitor. Commands end
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authentication system is logging you on as 'empty' user.
you will be ok after that ;)
Claudio
On 8/1/2010 2:02 AM, Corey wrote:
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote:
login as root and remove 'empty' user ,issue:
delete from mysql.user where user='';
flush privileges;
mysql authentication system is logging you on as 'empty' user.
you will be ok after that ;)
Man, thanks a ton
Hi list,
I'm migrating a Java application from it's local MySQL server (5.0) to
a remote 5.1 server. I've transferred the data and slaved the new
server to keep it in sync, but when I try to switch out the datasource
(that is, just change from localhost to the remote server), the
application
Hello,
I just installed the 6.0.6 version of the mysqld on Linux using the
binary RPM.
The RPM installed all the programs then it started the mysqld server.
I read lots of documents about mysql user and password. But I have no idea
what the users are used for, and how users are created.
The
endorse content contained within this
transmission. Date: Sun, 31 Aug 2008 19:38:15 -0400 From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com Subject: mysql user and authentication ???
Hello, I just installed the 6.0.6 version of the mysqld on Linux using the
binary RPM. The RPM installed all
.
At least that is what I think...
Regards
-Oorspronkelijk bericht-
Van: John Berman [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 9 oktober 2007 23:47
Aan: mysql@lists.mysql.com
Onderwerp: Client does not support authentication protocol requested by
server
Hi
We have php 4.3.4 and mysql 5
My
Hi
We have php 4.3.4 and mysql 5
My test script produces this
Client does not support authentication protocol requested by server
http://www.jewishgen.org/cemetery/connect-test.php
Research suggests that I can upgrade php or
SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD ('
:16 p.m.
To: mysql@lists.mysql.com
Subject: Re: Problem with authentication
Mahmoud Badreddine wrote:
Hello to all
I had an old MySQL 4.0 running on a Windows Machine.
I removed that version and I installed the MySQL 5.0 .
When I went to run phpMyAdmin this is the error I receive.
#1251
Hello to all
I had an old MySQL 4.0 running on a Windows Machine.
I removed that version and I installed the MySQL 5.0 .
When I went to run phpMyAdmin this is the error I receive.
#1251 - Client does not support authentication protocol requested by server;
consider upgrading MySQL client
Mahmoud Badreddine wrote:
Hello to all
I had an old MySQL 4.0 running on a Windows Machine.
I removed that version and I installed the MySQL 5.0 .
When I went to run phpMyAdmin this is the error I receive.
#1251 - Client does not support authentication protocol requested by
server;
consider
Can someone tell me where I can find the source code files whit th
user authentication in it? I want to see if I can integrate LDAP
authentication myself.
_
Express yourself instantly with MSN Messenger! Download today - it's FREE
- the following getConnection() method is
directed to the 2nd entry because it has a password, but it's not localhost
so my localhost-based Java app is denied.
In Java, I use:
DriverManager.getConnection( /localhost/tm , 'jeff','xyz' );
Then I get an authentication failed error.
I've also tried
it has a password, but it's not localhost
so my localhost-based Java app is denied.
In Java, I use:
DriverManager.getConnection( /localhost/tm , 'jeff','xyz' );
Then I get an authentication failed error.
Connector/J on 'nix types, only works via TCP/IP. Your app may be trying
over the two sets of
authentication tokens; a connection to A is established, but, trying to connect
to B, the script returns:
DBI connect('database=cif;host=xxx.xxx.xxx.xxx;port=3306','',...) failed:
Client does not support authentication protocol requested by server; consider
upgrading
In the last episode (Mar 26), Andrew said:
What could ever be the problem with the failing Perl DBI (C-B)
connection, if everything is OK with a C-A connection (with and
without Perl), and, in addition, a command-line C-B connection
works?
The password on B is a new-style password, and perl
In the last episode (Mar 26), Andrew said:
What could ever be the problem with the failing Perl DBI (C-B)
connection, if everything is OK with a C-A connection (with and
without Perl), and, in addition, a command-line C-B connection
works?
The password on B is a new-style password, and perl
Andrew
Your client application is trying to authenticate with the old mysql
method, you need to update your client script or alternatively reset
password to old version using:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Hope this helps
Regards
Jeremy
--
Jeremy
what
the server on B is doing with
SHOW VARIABLES LIKE 'old_passwords';
One possibility is that this will return OFF for server B. I would *guess*
that this is not your problem, but it is worth checking.
Second, the difference in authentication is that before 4.1, mysql used a
16-byte
with MySQL 3.23.x, I got the
Client does not support authentication ... error.
I finally corrected by updating the 'user' table with the OLD_PASSWORD()
function, and was able to access the databases. Using old_password() in the
config file did not work.
My question(s) follow.
Since
MYSQL authentication method.
Hope this helpseven a little.
Regards
Jeremy
www.bluejayspc.co.uk
barney wrote:
Folk,
Just installed MySQL 4.1.14 on a new Windows XP Pro system - this is a
development system, no domain. Also installed PHP 4.3.11 and Apache 2.0.55.
so now I have WAMP, right
. you need to update your PHP code to work
with the updated MYSQL authentication method.
Hope this helpseven a little.
Regards
Jeremy
www.bluejayspc.co.uk
barney wrote:
Folk,
Just installed MySQL 4.1.14 on a new Windows XP Pro system - this is a
development system, no domain. Also
I'm trying to upgrade MySQL from v4.x to v5.0 under an existing
Tcl-based application that uses MySQLTcl and I'm getting:
mysqlconnect/db server: Client does not support authentication
protocol requested by server; consider upgrading MySQL client
Is there something I can do to MySQL v5 server
07:40 p.m.
Para: mysql@lists.mysql.com
Asunto: Backward-compatible authentication in v5.0?
I'm trying to upgrade MySQL from v4.x to v5.0 under an existing Tcl-based
application that uses MySQLTcl and I'm getting:
mysqlconnect/db server: Client does not support authentication protocol
requested
Hi! It is a common error, have a look here:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
I have had the same error.
Tbanks. I found that -- eventually -- in the manual. It took several
searches to find it but it seems to work now, not only for my Tcl
application but for MySQL
is used by
mysql for
user authentication? Right now (4.1.11) it looks like the first record is
used, which
I'm not sure good enough. Shouldn't mysql check all the returned names and
see if one of
them authenticates?
/Per Jessen, Z$rich
--
For technical support contracts
Hi,
when an IP-address is reverse mapped to multiple names, which one is used by
mysql for
user authentication? Right now (4.1.11) it looks like the first record is
used, which
I'm not sure good enough. Shouldn't mysql check all the returned names and see
if one of
them authenticates
Hello.
See:
http://dev.mysql.com/doc/mysql/en/old-client.html
ymarkiv [EMAIL PROTECTED] wrote:
Dear all,
I'm mysql newbie.
When I try to connect to mysql using php script, it answers:
Warning: mysql_connect(): Client does not support authentication
protocol
Dear all,
I'm mysql newbie.
When I try to connect to mysql using php script, it answers:
Warning: mysql_connect(): Client does not support authentication
protocol requested by server. Consider upgrading MySQL client
in /usr/local/www/data-dist/grad-web/email.php on line 18
It talks about
Hassan Schroeder wrote:
Mark Sargent wrote:
h, that is annoying, as I did a yum remove mysql b4 installing
4.1. Shouldn't the yum remove, remove it fully..?
Sorry, can't help there, don't know anything about 'yum'.
[EMAIL PROTECTED] ~]# mysql -p
Enter password:
Welcome to the MySQL monitor.
Mark Sargent wrote:
ok, I don't fully understand why, but, mysql is still installed in
/usr/bin. What I've done, just for now, is renamed mysql in that dir to
mysqlold. I've added /usr/local/mysql/bin to my path. I then tried the
cmd mysql and also ./mysql from within the dir
Hassan Schroeder wrote:
Mark Sargent wrote:
ok, I don't fully understand why, but, mysql is still installed in
/usr/bin. What I've done, just for now, is renamed mysql in that dir
to mysqlold. I've added /usr/local/mysql/bin to my path. I then tried
the cmd mysql and also ./mysql from within
authentication protocol requested
by server; consider upgrading MySQL client
What is this..? Why is it asking me to upgrade the client.? Cheers.
Mark Sargent.
See here:
http://dev.mysql.com/doc/mysql/en/password-hashing.html
Presumably your server is running 4.1 with new passwords and your
client
On 2/05/2005 6:05 p.m., Mark Sargent wrote:
Hi All,
master/client are the same machine. I installed via tar.gz, ver 4.1
following this page
http://dev.mysql.com/doc/mysql/en/installing-binary.html
for installation on FC3. Why would it say that the client doesn't
support it.? Cheers.
P.S. I now
does not support authentication protocol
requested by server; consider upgrading MySQL client
What is this..? Why is it asking me to upgrade the client.? Cheers.
Mark Sargent.
See here:
http://dev.mysql.com/doc/mysql/en/password-hashing.html
Presumably your server is running 4.1 with new passwords
Simon Garner wrote:
On 2/05/2005 6:05 p.m., Mark Sargent wrote:
Hi All,
master/client are the same machine. I installed via tar.gz, ver 4.1
following this page
http://dev.mysql.com/doc/mysql/en/installing-binary.html
for installation on FC3. Why would it say that the client doesn't
support it.?
Mark Sargent wrote:
Simon Garner wrote:
On 2/05/2005 6:05 p.m., Mark Sargent wrote:
Hi All,
master/client are the same machine. I installed via tar.gz, ver 4.1
following this page
http://dev.mysql.com/doc/mysql/en/installing-binary.html
for installation on FC3. Why would it say that the client
ERROR 1251: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
What is this..? Why is it asking me to upgrade the client.? Cheers.
Mark Sargent.
See here:
http://dev.mysql.com/doc/mysql/en/password-hashing.html
Presumably your server is running 4.1
Mark Sargent wrote:
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client does not support authentication protocol requested
by server; consider upgrading MySQL client
What is this..? Why is it asking me to upgrade the client.? Cheers.
master/client
Hassan Schroeder wrote:
Mark Sargent wrote:
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
What is this..? Why is it asking me to upgrade the client
Mark Sargent wrote:
h, that is annoying, as I did a yum remove mysql b4 installing 4.1.
Shouldn't the yum remove, remove it fully..?
Sorry, can't help there, don't know anything about 'yum'.
[EMAIL PROTECTED] ~]# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
Hi All,
I did this below,
mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka');
and then tried logging on,
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client does not support authentication protocol requested by
server; consider upgrading
On 2/05/2005 5:21 p.m., Mark Sargent wrote:
Hi All,
I did this below,
mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka');
and then tried logging on,
[EMAIL PROTECTED] bluefish-1.0]# mysql -h localhost -u root -pwhatafraka
ERROR 1251: Client does not support authentication protocol
PM
To: mysql@lists.mysql.com
Subject: Re: ERROR 1251: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
On 2/05/2005 5:21 p.m., Mark Sargent wrote:
Hi All,
I did this below,
mysqlSET PASSWORD FOR 'root'@'localhost' = PASSWORD('whatafraka
: Tuesday, November 16, 2004 9:34 PM
Subject: RE: Mysql-4.1.7 and client library - Client does not support
authentication protocol requested by server; consider upgrading MySQL
client
You need to reinstall your mysql api library to talk to mysql-4.1.7:
4.1.7
has a different auth implementation
They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the
suggestions
of Gleb Paharenko. Now when use webmin (last version 1.170) o phpmyadmin (last
version -2.6.0-pl2) I have this problem:
DBI connect failed : Client does not support authentication protocol requested
They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to
the suggestions of Gleb Paharenko. Now when use webmin (last version
1.170) o phpmyadmin (last version -2.6.0-pl2) I have this problem:
DBI connect failed : Client does not support authentication protocol
requested
On Tuesday 16 November 2004 02:15 pm, William R. Mussatto wrote:
I had a similar problem with DBI/DBD. The solution I used was to create
the passwords using OLD_PASSWORD('plaintextPassword') function
Look at http://dev.mysql.com/doc/mysql/en/Password_hashing.html for the
details as well as
://www.friendster.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 11:38 AM
To: [EMAIL PROTECTED]
Subject: Mysql-4.1.7 and client library - Client does not support
authentication protocol requested by server; consider upgrading MySQL
client
I have never set up a web site running a mysql server,
so I am little fuzzy on details concerning user
authentication. Let's say I am creating a page where
the user will enter his/her information. I write a
PHP script to update the mysql table when they click
'submit'. Do I have to grant
Are you talking about user authentication for the purpose of people
accessing the MySQL database or are you talking about user authentication in
terms of people accessing restricted areas on a website?
-Original Message-
I have never set up a web site running a mysql server,
so I am
login (if they have one)
Your application can also maintain a set of login credentials for the
users of your site. You can chose to inherit the username from the Web
Server, the Operating system, or from an authentication process written
specifically for you application. This is the step where
can chose to inherit the
username from the Web
Server, the Operating system, or from an
authentication process written
specifically for you application. This is the step
where your application
verifies that the current user is authorized to use
your application. Your
application
,
so I am little fuzzy on details concerning user
authentication. Let's say I am creating a page
where
the user will enter his/her information. I write a
PHP script to update the mysql table when they click
'submit'. Do I have to grant priveleges to anyone
but
myself on that table
Hello,
Happen to come accross this articale
http://www.securiteam.com/unixfocus/5BP0420DFQ.html
and was wondering, using 4.0.20, if we need to make some changes or has this
been addressed by MySQL staff ??
TIA,
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet
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.net/
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] '
Subject: RE: authentication error
Do
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 same
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 run a toaster email server
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
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: RE: authentication
: 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; '[EMAIL PROTECTED] '
Subject
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
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: authentication error
My bad
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 now
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_read_request
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
: 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 error
Key_Reads
: 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. You could turn on the slow query log
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
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
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.
-Original
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 sir...
-Original Message-
From
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 delayed_insert_limit
Could
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
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
: 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, I run a toaster email server which
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
:[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_connect_errors was
reached
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 from both
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
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
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?
-Original Message-
From: Chip Bell
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
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?
-Original Message
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
1 - 100 of 186 matches
Mail list logo
