Hi,
I'm new to the list, and unfortunately new to Java apps. so am
really
struggling with trying to get the server setup to use MySQL as
the user
base
under OS X
I downloaded the server and got it running using the ftpd-
typical.xml no
problems. I've also downloaded commons-dbcp, and added
commons-dbcp-1.2.2.jar to the common/lib folder. I've also got
the MySQL
database/table setup.
Within the config xml file I've now got the setup as below,
however when
I
try to start the server, I get this error;
org.springframework.beans.factory.BeanCreationException: Error
creating
bean with name
'org.apache.ftpserver.usermanager.DbUserManagerFactory#0':
Cannot create inner bean
'org.apache.commons.dbcp.BasicDataSource#7361e2'
of
type [org.apache.commons.dbcp.BasicDataSource] while setting bean
property
'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error
creating
bean
with name 'org.apache.commons.dbcp.BasicDataSource#7361e2'
defined in
file
[/Users/stevewinter/Downloads/apache-ftpserver-1.0.0/res/conf/
ftpd-typical.xml]:
Instantiation of bean failed; nested exception is
java.lang.NoClassDefFoundError:
org/apache/commons/pool/impl/GenericObjectPool
Any help with resolving this very much appreciated...
Cheers
Steve
<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="myServer">
<listeners>
<nio-listener name="default" port="2121">
<ssl>
<keystore file="./res/ftpserver.jks"
password="password" />
</ssl>
</nio-listener>
</listeners>
<db-user-manager encrypt-passwords="salted">
<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/ftpd" />
<beans:property name="username"
value="ftp" />
<beans:property name="password"
value="password"
/>
</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 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>
