mina-dev mailing list archives

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

     [ https://issues.apache.org/jira/browse/FTPSERVER-267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Javi updated FTPSERVER-267:
---------------------------

    Attachment: DbUserManager.java.patch

Patch to 1.0.0-RC1

> 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