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