I've tried both active and passive modes, both with same results.

Using version 1.02. 

Strangely, this issue doesn't occur again after trying to run it.

The configuration code is just the standard file that comes with it. Haven't 
made any changes to it. The plet is just to catch the onUploadEnd event and 
insert the user data to the db for further processing.

<server xmlns="http://mina.apache.org/ftpserver/spring/v1";
        xmlns:beans="http://www.springframework.org/schema/beans"; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
        xsi:schemaLocation="
           http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd 
           http://mina.apache.org/ftpserver/spring/v1 
http://mina.apache.org/ftpserver/ftpserver-1.0.xsd        
           "
        id="localhost"
        max-logins="1000000"
        anon-enabled="false"

        >
        <listeners>
                <nio-listener name="default" port="2121" implicit-ssl="false">
                                </nio-listener>
        </listeners>
        <ftplets>
        <ftplet name="ftplet1">
            <beans:bean class="Plet">
                   
            </beans:bean>
        </ftplet>
    </ftplets>
        <db-user-manager encrypt-passwords="md5">
                <data-source>
                        <beans:bean 
class="org.apache.commons.dbcp.BasicDataSource">
                          <beans:property name="driverClassName" 
value="com.mysql.jdbc.Driver" />
                          <beans:property name="url" 
value="jdbc:mysql://localhost/abc" />
                          <beans:property name="username" value="ftp" />
                          <beans:property name="password" value="123" />
                        </beans:bean>
                </data-source>
                <insert-user>INSERT INTO FTP_USER (userid, userpassword,
                        homedirectory, enableflag, writepermission, idletime, 
uploadrate,
                        downloadrate) VALUES ('{userid}', '{userpassword}', 
'{homedirectory}',
                        {enableflag}, {writepermission}, {idletime}, 
{uploadrate},
                        {downloadrate})
                </insert-user>
                <update-user>UPDATE FTP_USER SET
                                
userpassword='{userpassword}',homedirectory='{homedirectory}',enableflag={enableflag},writepermission={writepermission},idletime={idletime},uploadrate={uploadrate},downloadrate={downloadrate}
                                WHERE userid='{userid}'
                </update-user>
                <delete-user>DELETE FROM FTP_USER WHERE userid = '{userid}'
                </delete-user>
                <select-user>SELECT userid, userpassword, homedirectory,
                                enableflag, writepermission, idletime, 
uploadrate, downloadrate, enableflag,
                                maxloginnumber, maxloginperip FROM
                                FTP_USER WHERE userid = '{userid}'
                </select-user>
                <select-all-users>SELECT userid FROM FTP_USER ORDER BY userid
                </select-all-users>
                <is-admin>SELECT userid FROM FTP_USER WHERE userid='{userid}' 
AND
                                userid='admin'
                </is-admin>
                <authenticate>SELECT userpassword from FTP_USER WHERE 
userid='{userid}'</authenticate>

        </db-user-manager>
                
</server>

I will send the netstat -a results when the problem occurs on my server.

I am indeed using commons-dbcp.

Reply via email to