mina-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Latorre (JIRA)" <j...@apache.org>
Subject [jira] Commented: (FTPSERVER-267) DbUserManager not authenticating with MySQL 5.0.x
Date Tue, 20 Jan 2009 12:17:59 GMT

    [ 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.


Mime
View raw message