You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@mina.apache.org by "David Latorre (JIRA)" <ji...@apache.org> on 2009/01/20 13:17:59 UTC
[jira] Commented: (FTPSERVER-267) DbUserManager not authenticating
with MySQL 5.0.x
[ https://issues.apache.org/jira/browse/FTPSERVER-267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12665415#action_12665415 ]
David Latorre commented on FTPSERVER-267:
-----------------------------------------
The documented query string for the authentication statement is this one:
<authenticate>SELECT userpassword from FTP_USER WHERE userid='{userid}'</authenticate>
It is available at : http://mina.apache.org/ftpserver/database-user-manager.html be we might need to check the project so sample XML files have this sentence.
If using that statement you do not need to change the provided DBUserManager.
I'm opening a bug report for a "documentation improvement" and closing this one. Please feel free to open a new issue if this is not working for you.
> DbUserManager not authenticating with MySQL 5.0.x
> -------------------------------------------------
>
> Key: FTPSERVER-267
> URL: https://issues.apache.org/jira/browse/FTPSERVER-267
> Project: FtpServer
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.0.0-RC1
> Reporter: Javi
> Priority: Critical
> Attachments: DbUserManager.java.patch
>
>
> DbUserManager does not set password, failing in the SQL:
> [ INFO] 2009-01-20 01:47:48,322 [admin] [127.0.0.1] SELECT userid from FTP_USER WHERE userid='admin' AND userpassword=''
> In order to get it running 2 changes needs to be done:
> 1- Configuration file modify
> <authenticate>SELECT userid from FTP_USER WHERE userid='{userid}' AND userpassword='{userpassword}'</authenticate>
> Per this one:
> <authenticate>SELECT userid, userpassword from FTP_USER WHERE userid='{userid}' AND userpassword='{userpassword}'</authenticate>
> 2- Modify DbUserManager.authenticate from:
> HashMap<String, Object> map = new HashMap<String, Object>();
> map.put(ATTR_LOGIN, escapeString(user));
> To this one:
> HashMap<String, Object> map = new HashMap<String, Object>();
> map.put(ATTR_LOGIN, escapeString(user));
> map.put(ATTR_PASSWORD, getPasswordEncryptor().encrypt(password));
> Notice bug https://issues.apache.org/jira/browse/FTPSERVER-105 is unfixed in 1.0.0-RC1 and need to add command "INSERT IGNORE" or MySQL won't run.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.