Apache-Mina FTPServer数据库用户pipe理器失败

概述Apache-Mina FTPServer数据库用户pipe理器失败

我正在尝试使用Apache FTPServerbuild立一个基于windows的FTP服务器，但是当我使用db-user-manager而不是file-user-manager时，我一直在遇到同样的问题。 我们的数据库中有将近6000个用户，我们希望迁移到windows，所以文件用户pipe理器就不足够了（因为大小是IMMENSE）。 我已经使用WAMP创build了本地sql服务器，并将其设置为供Apache FTP使用，并且具有一个脚本来将远程数据库中的用户每天查询/复制/组织到本地。

我遇到的问题是，无论什么原因，Apache FTPServer不断给我下面的错误，当我运行该程序：

org.springframework.beans.factory.xml.XmlBeanDeFinitionStoreException: line 27 in XML document from file [c:apache-ftpserver-1.0.5resconfftpd-full.xml] is invalID; nested exception is org.xml.sax.SAXParseException: The prefix "beans" for element "beans:bean" is not bound. at org.springframework.beans.factory.xml.XmlBeanDeFinitionReader.doloadBeanDeFinitions(XmlBeanDeFinitionReader.java:404) at org.springframework.beans.factory.xml.XmlBeanDeFinitionReader.loadBeanDeFinitions(XmlBeanDeFinitionReader.java:342) at org.springframework.beans.factory.xml.XmlBeanDeFinitionReader.loadBeanDeFinitions(XmlBeanDeFinitionReader.java:310) at org.springframework.beans.factory.support.AbstractBeanDeFinitionReader.loadBeanDeFinitions(AbstractBeanDeFinitionReader.java:143) at org.springframework.beans.factory.support.AbstractBeanDeFinitionReader.loadBeanDeFinitions(AbstractBeanDeFinitionReader.java:178) at org.springframework.beans.factory.support.AbstractBeanDeFinitionReader.loadBeanDeFinitions(AbstractBeanDeFinitionReader.java:149) at org.springframework.beans.factory.support.AbstractBeanDeFinitionReader.loadBeanDeFinitions(AbstractBeanDeFinitionReader.java:212) at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDeFinitions(AbstractXmlApplicationContext.java:113) at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDeFinitions(AbstractXmlApplicationContext.java:80) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshbeanfactory(AbstractRefreshableApplicationContext.java:123) at org.springframework.context.support.AbstractApplicationContext.obtainFreshbeanfactory(AbstractApplicationContext.java:423) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:353) at org.springframework.context.support.fileSystemXmlApplicationContext.<init>(fileSystemXmlApplicationContext.java:140) at org.springframework.context.support.fileSystemXmlApplicationContext.<init>(fileSystemXmlApplicationContext.java:84) at org.apache.ftpserver.main.Commandline.getConfiguration(Commandline.java:132) at org.apache.ftpserver.main.Commandline.main(Commandline.java:56) Caused by: org.xml.sax.SAXParseException: The prefix "beans" for element "beans:bean" is not bound. at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195) at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:174) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:388) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318) at com.sun.org.apache.xerces.internal.impl.XMLNSdocumentScannerImpl.scanStartElement(XMLNSdocumentScannerImpl.java:310) at com.sun.org.apache.xerces.internal.impl.XMLdocumentFragmentScannerImpl$FragmentContentDriver.next(XMLdocumentFragmentScannerImpl.java:2755) at com.sun.org.apache.xerces.internal.impl.XMLdocumentScannerImpl.next(XMLdocumentScannerImpl.java:648) at com.sun.org.apache.xerces.internal.impl.XMLNSdocumentScannerImpl.next(XMLNSdocumentScannerImpl.java:140) at com.sun.org.apache.xerces.internal.impl.XMLdocumentFragmentScannerImpl.scandocument(XMLdocumentFragmentScannerImpl.java:511) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:808) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:737) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:119) at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:235) at com.sun.org.apache.xerces.internal.jaxp.documentBuilderImpl.parse(documentBuilderImpl.java:284) at org.springframework.beans.factory.xml.DefaultdocumentLoader.loaddocument(DefaultdocumentLoader.java:75) at org.springframework.beans.factory.xml.XmlBeanDeFinitionReader.doloadBeanDeFinitions(XmlBeanDeFinitionReader.java:396) ... 15 more

我从http://dev.MysqL.com/downloads/connector/下载了http://commons.apache.org/dbcp/和MysqL连接器(version 5.1.6 at that time) DBCP基本数据源文件。 j /并按照指示将所有文件放入通用 lib文件夹中。

我确定删除了其他用户pipe理代码“file-user-manager”

无法运行由Vagrant安装的windows 2008 R2 Standard中的PowerShell脚本

带有windows的IIS服务器上的Joomla PHP表单 – 错误

CreateDC失败，错误代码为0

摄像头，vIDeo源对话框出现

Z轴窗口值

我还是不明白…为什么不起作用？

这是我的XML文件：

<?xml version="1.0" enCoding="UTF-8"?> <!-- licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache license,Version 2.0 (the "license"); you may not use this file except in compliance with the license. You may obtain a copy of the license at http://www.apache.org/licenses/liCENSE-2.0 Unless required by applicable law or agreed to in writing,software distributed under the license is distributed on an "AS IS" BASIS,WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,either express or implIEd. See the license for the specific language governing permissions and limitations under the license. --> <server xmlns="http://mina.apache.org/ftpserver/spring/v1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://mina.apache.org/ftpserver/spring/v1 http://mina.apache.org/ftpserver/ftpserver-1.0.xsd " ID="Prometheus"> <Listeners> <nio-Listener name="default" port="2121" /> </Listeners> <db-user-manager> <data-source> <beans:bean > <beans:property name="driverClassname" value="com.MysqL.jdbc.Driver" /> <beans:property name="url" value="jdbc:MysqL://127.0.0.1/apache_test" /> <beans:property name="username" value="admin" /> <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,downloadrate,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>

Femibuild议编辑后出现新的错误：

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#c832d2' 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#c832d2' defined in file [C:apache-ftpserver-1.0.5resconfftpd-full.xml]: Instantiation of bean Failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedobjectPoolFactory at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveInnerBean(BeanDeFinitionValueResolver.java:230) at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveValueIfNecessary(BeanDeFinitionValueResolver.java:117) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.applyPropertyValues(AbstractautowireCapablebeanfactory.java:1245) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.populateBean(AbstractautowireCapablebeanfactory.java:1010) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.doCreateBean(AbstractautowireCapablebeanfactory.java:472) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory$1.run(AbstractautowireCapablebeanfactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.createBean(AbstractautowireCapablebeanfactory.java:380) at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221) at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:261) at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:185) at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:164) at org.springframework.beans.factory.support.Defaultlistablebeanfactory.preInstantiateSingletons(Defaultlistablebeanfactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:729) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381) at org.springframework.context.support.fileSystemXmlApplicationContext.<init>(fileSystemXmlApplicationContext.java:140) at org.springframework.context.support.fileSystemXmlApplicationContext.<init>(fileSystemXmlApplicationContext.java:84) at org.apache.ftpserver.main.Commandline.getConfiguration(Commandline.java:132) at org.apache.ftpserver.main.Commandline.main(Commandline.java:56) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.commons.dbcp.BasicdataSource#c832d2' defined in file [C:apache-ftpserver-1.0.5resconfftpd-full.xml]: Instantiation of bean Failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedobjectPoolFactory at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.instantiateBean(AbstractautowireCapablebeanfactory.java:883) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.createBeanInstance(AbstractautowireCapablebeanfactory.java:839) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.doCreateBean(AbstractautowireCapablebeanfactory.java:440) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory$1.run(AbstractautowireCapablebeanfactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.createBean(AbstractautowireCapablebeanfactory.java:380) at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveInnerBean(BeanDeFinitionValueResolver.java:219) ... 19 more Caused by: java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedobjectPoolFactory at java.lang.class.getDeclaredConstructors0(Native Method) at java.lang.class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.class.getConstructor0(Class.java:2699) at java.lang.class.getDeclaredConstructor(Class.java:1985) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:54) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.instantiateBean(AbstractautowireCapablebeanfactory.java:877) ... 25 more Caused by: java.lang.classNotFoundException: org.apache.commons.pool.KeyedobjectPoolFactory at java.net.urlclassloader$1.run(urlclassloader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.urlclassloader.findClass(urlclassloader.java:190) at java.lang.classLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.classLoader.loadClass(ClassLoader.java:248) ... 31 more

Femibuild议的第二次更改后出现新的错误：

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.ftpserver.FtpServerFactory#0': Cannot create inner bean '(inner bean)' while setting bean property 'u serManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#1': Instantiation of bean Failed; nested exception is org.springfr amework.beans.factory.BeanDeFinitionStoreException: Factory method [public org.apache.ftpserver.ftplet.UserManager org.apache.ftpserver.usermanager.DbUserManagerFactory.createuserManager()] threw exce ption; nested exception is org.apache.ftpserver.FtpServerConfigurationException: Failed to open connection to user database at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveInnerBean(BeanDeFinitionValueResolver.java:230) at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveValueIfNecessary(BeanDeFinitionValueResolver.java:122) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.applyPropertyValues(AbstractautowireCapablebeanfactory.java:1245) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.populateBean(AbstractautowireCapablebeanfactory.java:1010) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.doCreateBean(AbstractautowireCapablebeanfactory.java:472) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory$1.run(AbstractautowireCapablebeanfactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.createBean(AbstractautowireCapablebeanfactory.java:380) at org.springframework.beans.factory.support.Abstractbeanfactory$1.getobject(Abstractbeanfactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221) at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:261) at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:185) at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:164) at org.springframework.beans.factory.support.Defaultlistablebeanfactory.preInstantiateSingletons(Defaultlistablebeanfactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:729) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381) at org.springframework.context.support.fileSystemXmlApplicationContext.<init>(fileSystemXmlApplicationContext.java:140) at org.springframework.context.support.fileSystemXmlApplicationContext.<init>(fileSystemXmlApplicationContext.java:84) at org.apache.ftpserver.main.Commandline.getConfiguration(Commandline.java:132) at org.apache.ftpserver.main.Commandline.main(Commandline.java:56) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#1': Instantiation of bean Failed; nested exception is org.springframework.beans.factory. BeanDeFinitionStoreException: Factory method [public org.apache.ftpserver.ftplet.UserManager org.apache.ftpserver.usermanager.DbUserManagerFactory.createuserManager()] threw exception; nested exceptio n is org.apache.ftpserver.FtpServerConfigurationException: Failed to open connection to user database at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:444) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.instantiateUsingFactoryMethod(AbstractautowireCapablebeanfactory.java:903) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.createBeanInstance(AbstractautowireCapablebeanfactory.java:817) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.doCreateBean(AbstractautowireCapablebeanfactory.java:440) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory$1.run(AbstractautowireCapablebeanfactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractautowireCapablebeanfactory.createBean(AbstractautowireCapablebeanfactory.java:380) at org.springframework.beans.factory.support.BeanDeFinitionValueResolver.resolveInnerBean(BeanDeFinitionValueResolver.java:219) ... 19 more Caused by: org.springframework.beans.factory.BeanDeFinitionStoreException: Factory method [public org.apache.ftpserver.ftplet.UserManager org.apache.ftpserver.usermanager.DbUserManagerFactory.createUs erManager()] threw exception; nested exception is org.apache.ftpserver.FtpServerConfigurationException: Failed to open connection to user database at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:127) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:435) ... 26 more Caused by: org.apache.ftpserver.FtpServerConfigurationException: Failed to open connection to user database at org.apache.ftpserver.usermanager.impl.DbUserManager.<init>(DbUserManager.java:103) at org.apache.ftpserver.usermanager.DbUserManagerFactory.createuserManager(DbUserManagerFactory.java:89) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:115) ... 27 more Caused by: org.apache.commons.dbcp.sqlnestedException: Cannot create PoolableConnectionFactory (Access denIEd for user 'user'@'localhost' (using password: YES)) at org.apache.commons.dbcp.BasicdataSource.createPoolableConnectionFactory(BasicdataSource.java:1549) at org.apache.commons.dbcp.BasicdataSource.createDataSource(BasicdataSource.java:1388) at org.apache.commons.dbcp.BasicdataSource.getConnection(BasicdataSource.java:1044) at org.apache.ftpserver.usermanager.impl.DbUserManager.createConnection(DbUserManager.java:307) at org.apache.ftpserver.usermanager.impl.DbUserManager.<init>(DbUserManager.java:98) ... 33 more Caused by: java.sql.sqlException: Access denIEd for user 'user'@'localhost' (using password: YES) at com.MysqL.jdbc.sqlError.createsqlException(sqlError.java:1055) at com.MysqL.jdbc.sqlError.createsqlException(sqlError.java:956) at com.MysqL.jdbc.MysqLIO.checkerrorPacket(MysqLIO.java:3491) at com.MysqL.jdbc.MysqLIO.checkerrorPacket(MysqLIO.java:3423) at com.MysqL.jdbc.MysqLIO.checkerrorPacket(MysqLIO.java:910) at com.MysqL.jdbc.MysqLIO.secureAuth411(MysqLIO.java:3923) at com.MysqL.jdbc.MysqLIO.doHandshake(MysqLIO.java:1273) at com.MysqL.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031) at com.MysqL.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718) at com.MysqL.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.MysqL.jdbc.Util.handleNewInstance(Util.java:406) at com.MysqL.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) at com.MysqL.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicdataSource.valIDateConnectionFactory(BasicdataSource.java:1556) at org.apache.commons.dbcp.BasicdataSource.createPoolableConnectionFactory(BasicdataSource.java:1545) ... 37 more

无法在windows上构buildrustless

在windows上运行zopeskel后缺less本地命令

UDID或IMEI-哪个更好？

从shell程序运行八度脚本没有横幅信息

Qt / C ++：当程序在windows *** 作系统下运行时，图标不显示

它不是一个DBCP问题，它是一个Spring配置问题。 更改XML文件的顶部以包含spring bean定义，我认为你会没事的。

<server xmlns="http://mina.apache.org/ftpserver/spring/v1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans" xsi:schemaLocation=" http://mina.apache.org/ftpserver/spring/v1 http://mina.apache.org/ftpserver/ftpserver-1.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" ID="Prometheus">

您可能需要将最后的2.0.xsd更改为2.0.xsd ，具体取决于随MINA 3.0.xsd的Spring版本。

而不是commons-pool-1.6 （或上面的链接），安装common/lib commons-dbcp-1.4这3个jar文件。

http://commons.apache.org/dbcp/download_dbcp.cgi

这对我有效。

总结

以上是内存溢出为你收集整理的Apache-Mina FTPServer数据库用户pipe理器失败全部内容，希望文章能够帮你解决Apache-Mina FTPServer数据库用户pipe理器失败所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。