PAM authentication plugin

2014-09-17 Thread geetanjali mehra
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

Re: MySQL LDAP Authentication Plugin - Full example with source code

2012-08-20 Thread Ignacio Ocampo
t" 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: MyS

RE: MySQL LDAP Authentication Plugin - Full example with source code

2012-08-20 Thread Rick James
> 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/ > > -- > Ig

MySQL LDAP Authentication Plugin - Full example with source code

2012-08-12 Thread Ignacio Ocampo
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

Messed up authentication

2011-12-01 Thread Johan De Meersman
ted to throw it out here in case someone has a clue 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 t

using mod auth_mysql with apache for authentication

2011-08-08 Thread Rajeev Prasad
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 box.

Re: strange authentication issue

2010-08-01 Thread Claudio Nanni
h privileges; mysql 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 F

Re: strange authentication issue

2010-08-01 Thread Claudio Nanni
h privileges; mysql 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 F

Re: strange authentication issue

2010-07-31 Thread Corey
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

Re: strange authentication issue

2010-07-31 Thread Claudio Nanni
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 20

Re: strange authentication issue

2010-07-31 Thread Corey
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. Command

Re: strange authentication issue

2010-07-31 Thread Claudio Nanni
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, w

Re: strange authentication issue

2010-07-31 Thread Corey
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, whoo

Re: strange authentication issue

2010-07-31 Thread chaim rieger
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: http://lists.mysql.co

Re: strange authentication issue

2010-07-31 Thread Corey
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

Re: strange authentication issue

2010-07-31 Thread chaim rieger
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

strange authentication issue

2010-07-31 Thread Corey
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

Authentication issue

2010-06-09 Thread Johan De Meersman
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 refus

RE: mysql user and authentication ???

2008-08-31 Thread Martin Gainty
other than intended recipient. Sender does not necessarily 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

mysql user and authentication ???

2008-08-31 Thread Alex Katebi
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

RE: Client does not support authentication protocol requested by server

2007-10-10 Thread Reinhart Viane
t. 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

Client does not support authentication protocol requested by server

2007-10-09 Thread John Berman
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 ('xxx

RE: Problem with authentication

2007-04-05 Thread Cruz, Edwin \(GE, Corporate, consultant\)
: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 r

Re: Problem with authentication

2007-04-04 Thread John Meyer
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

Problem with authentication

2007-04-04 Thread Mahmoud Badreddine
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

Source code about user authentication in MySQL 5

2006-08-10 Thread Arjan Hulshoff
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

Re: stuck on localhost authentication

2006-08-05 Thread Brad Jahnke
23 > > I think this is the problem - 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 , &#x

stuck on localhost authentication

2006-08-05 Thread Jeff Drew
ff % *4232432323 I think this is the problem - 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&

Re: Client does not support authentication protocol requested by server

2006-03-26 Thread Michael Stassen
file and/or command line options. You can verify 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 di

Re: Client does not support authentication protocol requested by server

2006-03-26 Thread Bluejays PC Services
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 Oliv

Re: Client does not support authentication protocol requested by server

2006-03-26 Thread Andrew
>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 passwor

Re: Client does not support authentication protocol requested by server

2006-03-26 Thread Dan Nelson
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

Client does not support authentication protocol requested by server

2006-03-26 Thread Andrew
e, passowrd, database, etc.), looping 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','xxxx',...) failed: Client does not support authent

Re: A different authentication question ...

2006-03-18 Thread barney
to the PHP code not the actual > PHP/MYSQL/APACHE programs. 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, > > &

Re: A different authentication question ...

2006-03-18 Thread Jeremy Oliver
he 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 installed PHP 4.3.11 and Apache 2.0.55. so now I

A different authentication question ...

2006-03-18 Thread barney
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) foll

Re: RE: Backward-compatible authentication in v5.0?

2005-11-16 Thread cnelson
> 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

RE: Backward-compatible authentication in v5.0?

2005-11-16 Thread ISC Edwin Cruz
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

Backward-compatible authentication in v5.0?

2005-11-16 Thread cnelson
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

Re: authentication - which hostname is used?

2005-07-19 Thread Gleb Paharenko
rse 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 authenticate

authentication - which hostname is used?

2005-07-17 Thread Per Jessen
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 aut

Re: mysql - Client does not support authentication protocol requested by server

2005-05-18 Thread Gleb Paharenko
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

mysql - Client does not support authentication protocol requested by server

2005-05-16 Thread ymarkiv
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

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-04 Thread Mark Sargent
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 the

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-04 Thread Hassan Schroeder
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 /usr/local/mysql/bi

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-04 Thread Mark Sargent
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.

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-02 Thread Hassan Schroeder
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 \

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-02 Thread Mark Sargent
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

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-02 Thread Hassan Schroeder
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 are

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-02 Thread Mark Sargent
-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. Mark Sargent. See here: http://dev.mysql.com/doc/mysql/en/password-hashing.html

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-02 Thread Mark Sargent
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 do

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-02 Thread Mark Sargent
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.?

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-01 Thread Mark Sargent
t -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. Mark Sargent. See here: http://dev.mysql.com/doc/mysql/en/password-hashing.html Presumably your server

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-01 Thread Simon Garner
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

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-01 Thread Mark Sargent
ROR 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 with

RE: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-01 Thread John Schmidt
CTED] Sent: Sun 5/1/2005 10:37 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, > > mysql&g

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-01 Thread Simon Garner
On 2/05/2005 5:21 p.m., Mark Sargent wrote: Hi All, I did this below, mysql>SET 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 no

ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

2005-05-01 Thread Mark Sargent
Hi All, I did this below, mysql>SET 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 requeste

Fw: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-17 Thread webmaster
TED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: 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 n

RE: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-16 Thread Dathan Vance Pattishall
://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; consid

Re: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-16 Thread Jeff Smelser
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 a

Re: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-16 Thread William R. Mussatto
> 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

Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-16 Thread webmaster
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 requeste

Re: User Authentication

2004-10-06 Thread James Weisensee
that user with that password and allowed from that host. This is the information PHP will use when connecting to MySQL. HTH, James --- Brandon Carter <[EMAIL PROTECTED]> wrote: > I have never set up a web site running a mysql > server, > so I am little fuzzy on details concern

Re: User Authentication

2004-10-06 Thread SGreen
for the > > server to know what > > pages that visitor has rights to see. Some web > > servers check user > > credentials against a list of users they maintain, > > others allow your users > > to use a system login (if they have one) > > > > Your a

Re: User Authentication

2004-10-06 Thread SGreen
e a system 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

RE: User Authentication

2004-10-06 Thread Ed Lazor
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,

User Authentication

2004-10-06 Thread Brandon Carter
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

MySQL Authentication Scheme Bypass

2004-07-12 Thread Mike Blezien
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, -- MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publish

Re: authentication error

2004-07-06 Thread Egor Egorov
"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

RE: authentication error

2004-07-01 Thread Chip Bell
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

RE: authentication error

2004-07-01 Thread Victor Pendleton
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

RE: authentication error

2004-07-01 Thread Chip Bell
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

RE: authentication error

2004-07-01 Thread Victor Pendleton
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

RE: authentication error

2004-07-01 Thread Chip Bell
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

RE: authentication error

2004-07-01 Thread Victor Pendleton
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

RE: authentication error

2004-07-01 Thread Chip Bell
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

2004-07-01 Thread Chip Bell
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 error

2004-07-01 Thread Victor Pendleton
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

RE: authentication error

2004-07-01 Thread Chip Bell
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

Re: authentication error

2004-07-01 Thread Egor Egorov
"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 a

RE: authentication error

2004-07-01 Thread Chip Bell
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]

RE: authentication error

2004-06-30 Thread Victor Pendleton
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 &

RE: authentication error

2004-06-30 Thread Chip Bell
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

RE: authentication error

2004-06-30 Thread Chip Bell
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. ---

RE: authentication error

2004-06-30 Thread Victor Pendleton
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

RE: authentication error

2004-06-30 Thread Victor Pendleton
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

RE: authentication error

2004-06-30 Thread Chip Bell
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

RE: authentication error

2004-06-29 Thread Victor Pendleton
/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

RE: authentication error

2004-06-29 Thread Chip Bell
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

RE: authentication error

2004-06-29 Thread Victor Pendleton
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

RE: authentication error

2004-06-29 Thread Chip Bell
[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

RE: authentication error

2004-06-29 Thread Victor Pendleton
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

RE: authentication error

2004-06-29 Thread Chip Bell
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? --

RE: authentication error

2004-06-29 Thread Victor Pendleton
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

RE: authentication error

2004-06-29 Thread Chip Bell
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.

RE: authentication error

2004-06-29 Thread Victor Pendleton
>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

RE: authentication error

2004-06-29 Thread Chip Bell
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

RE: authentication error

2004-06-29 Thread Victor Pendleton
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

RE: authentication error

2004-06-29 Thread Chip Bell
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

  1   2   >