Your message dated Thu, 08 Jul 2010 11:24:01 +0200
with message-id <[email protected]>
and subject line Re: Bug#588428: pure-ftpd-mysql: apparently, only md5
passwords are recognized
has caused the Debian Bug report #588428,
regarding pure-ftpd-mysql: apparently, only md5 passwords are recognized
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 this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
588428: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=588428
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: pure-ftpd-mysql
Version: 1.0.21-11.4
Severity: normal
Hi,
I just wanted to add a new user to a MySQL database for authentication.
So I did something along "insert ... (username, password, ...) values
('bla', password ('blubb'), ...)".
The result was that I could not authenticate as that user. Then I did
"update ... set password = md5('blubb') where username = 'bla';", and
then I could authenticate as the user.
In my mysql.conf file for pure-ftpd, I have:
MYSQLCrypt any
The MySQL server resides on the same machine and has this version:
ii mysql-server-5.0 5.0.51a-24+lenny4
I also have:
ii libmysqlclient15off 5.0.51a-24+lenny4
This suggests that, contrary to the documentation, authentication with
eg. MySQL passwords does not work.
Kind regards,
--Toni++
-- System Information:
Debian Release: 5.0.5
APT prefers stable
APT policy: (990, 'stable'), (500, 'proposed-updates'), (450, 'testing'),
(250, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-2-amd64 (SMP w/2 CPU cores)
Locale: LANG=de_DE.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
--- End Message ---
--- Begin Message ---
On 07/08/2010 11:10 AM, Toni Mueller wrote:
Package: pure-ftpd-mysql
Version: 1.0.21-11.4
Severity: normal
Hi,
I just wanted to add a new user to a MySQL database for authentication.
So I did something along "insert ... (username, password, ...) values
('bla', password ('blubb'), ...)".
The result was that I could not authenticate as that user. Then I did
"update ... set password = md5('blubb') where username = 'bla';", and
then I could authenticate as the user.
In my mysql.conf file for pure-ftpd, I have:
MYSQLCrypt any
The MySQL server resides on the same machine and has this version:
ii mysql-server-5.0 5.0.51a-24+lenny4
I also have:
ii libmysqlclient15off 5.0.51a-24+lenny4
This suggests that, contrary to the documentation, authentication with
eg. MySQL passwords does not work.
Use encrypt(..) instead of password(..). MySQL passwords from password() are not
supported - this is a MySQL specific format.
Regards
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
--- End Message ---
