Your message dated Fri, 8 Apr 2005 00:40:53 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Closing old bug reports
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 21 Jan 2005 01:32:31 +0000
>From [EMAIL PROTECTED] Thu Jan 20 17:32:31 2005
Return-path: <[EMAIL PROTECTED]>
Received: from bay2-f6.bay2.hotmail.com (hotmail.com) [65.54.247.6]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Crnf5-000217-00; Thu, 20 Jan 2005 17:32:31 -0800
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
Thu, 20 Jan 2005 17:32:00 -0800
Message-ID: <[EMAIL PROTECTED]>
Received: from 211.30.24.5 by by2fd.bay2.hotmail.msn.com with HTTP;
Fri, 21 Jan 2005 01:31:26 GMT
X-Originating-IP: [211.30.24.5]
X-Originating-Email: [EMAIL PROTECTED]
X-Sender: [EMAIL PROTECTED]
From: "Axial Networks" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Bcc:
Subject: Authenitcation failure after update from mysql 3.23.49-8.8 3.23.49-8.9
Date: Fri, 21 Jan 2005 01:31:26 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
X-OriginalArrivalTime: 21 Jan 2005 01:32:00.0934 (UTC)
FILETIME=[01212C60:01C4FF59]
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-2.0 required=4.0 tests=BAYES_00,DATING,
FROM_HAS_MIXED_NUMS,FROM_HAS_MIXED_NUMS3,HAS_PACKAGE,
MSGID_FROM_MTA_HEADER autolearn=no
version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Package: libmysqlclient 3.23.49-8.9 and/or mysql-common and/or mysql-client
and/or mysql-server
Version: 3.23.49-8.9
Description:
After updating from version 3.23.49-8.8 to 3.23.49-8.9 of packages
libmysqlclient, mysql-common and mysql-client I found that I could no longer
autheticate as a particular user. Previously I could authenicate use the
command:
$ mysql -h 127.0.0.1 -u username -pPASSWORD mydatabase
mysql> quit
After applying the update I found that running the same command resulted in
the
an authenication failure.
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
This also affected services logging into this mysql database as this user (I
have a database which contains details of mail accounts which is used by
postfix
and courier).
To resolve the problem I simply gave permission for the user to connect from
'hostname' as well as localhost. However I did not expect an update such as
this to result in a change in the manner that mysql handled
authenticatation.
System details:
$ uname -a
Linux seagull.axial.net.au 2.4.18-1-686 #1 Wed Apr 14 18:20:10 UTC 2004 i686
unknown
$ dpkg -s libc6 | grep ^Version
Version: 2.2.5-11.8
/var/log/mail.log
Jan 20 18:17:03 hostname postfix/trivial-rewrite[1508]: warning: connect
to mysql server 127.0.0.1: Access denied for user: '@hostname' to
database 'database'
Jan 20 18:17:04 hostname authdaemond.mysql: authmysql:
mysql_select_db(maildb)
error: Access denied for user: '@hostname' to database 'database'
/var/log/mysql.log
050120 17:06:54 9 Connect [EMAIL PROTECTED] as anonymous on database
9 Init DB Access denied for user: '@hostname' to
database 'hostname'
10 Connect [EMAIL PROTECTED] as anonymous on database
10 Init DB Access denied for user: '@hostname' to
database 'hostname'
11 Connect [EMAIL PROTECTED] as anonymous on database
11 Init DB Access denied for user: '@hostname' to
database 'hostname'
12 Connect [EMAIL PROTECTED] as anonymous on database
12 Init DB Access denied for user: '@hostname' to
database 'hostname'
/etc/mysql/my.conf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[safe_mysqld]
err-log = /var/log/mysql/mysql.err
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
log = /var/log/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-locking
skip-innodb
[mysqldump]
quick
set-variable = max_allowed_packet=1M
[mysql]
[isamchk]
set-variable = key_buffer=16M
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
---------------------------------------
Received: (at 291487-done) by bugs.debian.org; 7 Apr 2005 22:40:55 +0000
>From [EMAIL PROTECTED] Thu Apr 07 15:40:55 2005
Return-path: <[EMAIL PROTECTED]>
Received: from gate.lathspell.de (app109.intern) [212.117.68.82]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DJfgE-0008PW-00; Thu, 07 Apr 2005 15:40:54 -0700
Received: by app109.intern (Postfix, from userid 1000)
id E3B1C2C909; Fri, 8 Apr 2005 00:40:53 +0200 (CEST)
Date: Fri, 8 Apr 2005 00:40:53 +0200
From: Christian Hammers <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Closing old bug reports
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.6+20040907i
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
X-CrossAssassin-Score: 3
I'm closing these bug reports as they were quite old and flagged
unreproducible for a white.
bye,
-christian-
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
