[jira] Created: (FTPSERVER-267) DbUserManager not authenticating with MySQL 5.0.x

[Javi (JIRA)]

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


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.