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:19:59 UTC
[jira] Closed: (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:all-tabpanel ]
David Latorre closed FTPSERVER-267.
-----------------------------------
Resolution: Invalid
> 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.