Hello Diego, It seems that the xml has been processed to avoid XSS attacks :-)
Still, I don't see the tags enclosing the update-user, insert-user SQL sentences... My suggestion is that you revert any changes to ftpd-full.xml and once the server starts, you can Carefully edit the file until it's fully configured :) 2010/7/23 Diego Silva e Silva <[email protected]>: > Obrigado por responder, > > não estou conseguindo entender a estrutura... meu arquivo xml que estou > passando como parametro esta da seguinte forma: > > > xml version="1.0" encoding="UTF-8" ?> > - > <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="myServer"> > <listeners> > name="default" port="21"> > <ssl> > <keystore file="./res/ftpserver.jks" > password="password" /> > ssl> > > listeners> > salted"> > > <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="myuser" /> > <beans:property name="password" value="secret" /> > beans:bean> > > INSERT INTO FTP_USER (userid, userpassword, > homedirectory, enableflag, writepermission, idletime, > uploadrate, > downloadrate) VALUES ('{userid}', '{userpassword}', > '{homedirectory}', > '{enableflag}', '{writepermission}', {idletime}, > {uploadrate}, > {downloadrate}) > UPDATE FTP_USER SET > > userpassword='{userpassword}',homedirectory='{homedirectory}',enableflag={enableflag},writepermission={writepermission},idletime={idletime},uploadrate={uploadrate},downloadrate={downloadrate} > WHERE userid='{userid}' > DELETE FROM FTP_USER WHERE userid = '{userid}' > > SELECT userid, userpassword, homedirectory, > enableflag, writepermission, idletime, uploadrate, > downloadrate FROM > FTP_USER WHERE userid = '{userid}' > SELECT userid FROM FTP_USER ORDER BY userid > > <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> > > server> > > > mas na inicialização do servidor passando esse arquivo como parametro me > retorna o seguinte erro: > > > C:\buffer\JFtpServer\apache-ftpserver-1.0.4\bin>ftpd.bat > c:\buffer\JFtpServer\ap > ache-ftpserver-1.0.4\res\conf\ftpd-full.xml > Using XML configuration file > c:\buffer\JFtpServer\apache-ftpserver-1.0.4\res\con > f\ftpd-full.xml... > org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line > 59 i > n XML document from file > [c:\buffer\JFtpServer\apache-ftpserver-1.0.4\res\conf\f > tpd-full.xml] is invalid; nested exception is org.xml.sax.SAXParseException: > cvc > -complex-type.2.4.d: Invalid content was found starting with element > 'beans:prop > erty'. No child element is expected at this point. > at > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadB > eanDefinitions(XmlBeanDefinitionReader.java:404) > at > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea > nDefinitions(XmlBeanDefinitionReader.java:342) > at > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea > nDefinitions(XmlBeanDefinitionReader.java:310) > at > org.springframework.beans.factory.support.AbstractBeanDefinitionReade > r.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143) > at > org.springframework.beans.factory.support.AbstractBeanDefinitionReade > r.loadBeanDefinitions(AbstractBeanDefinitionReader.java:178) > at > org.springframework.beans.factory.support.AbstractBeanDefinitionReade > r.loadBeanDefinitions(AbstractBeanDefinitionReader.java:149) > at > org.springframework.beans.factory.support.AbstractBeanDefinitionReade > r.loadBeanDefinitions(AbstractBeanDefinitionReader.java:212) > at > org.springframework.context.support.AbstractXmlApplicationContext.loa > dBeanDefinitions(AbstractXmlApplicationContext.java:113) > at > org.springframework.context.support.AbstractXmlApplicationContext.loa > dBeanDefinitions(AbstractXmlApplicationContext.java:80) > at > org.springframework.context.support.AbstractRefreshableApplicationCon > text.refreshBeanFactory(AbstractRefreshableApplicationContext.java:123) > at > org.springframework.context.support.AbstractApplicationContext.obtain > FreshBeanFactory(AbstractApplicationContext.java:423) > at > org.springframework.context.support.AbstractApplicationContext.refres > h(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.ja > va:132) > at org.apache.ftpserver.main.CommandLine.main(CommandLine.java:56) > Caused by: org.xml.sax.SAXParseException: cvc-complex-type.2.4.d: Invalid > conten > t was found starting with element 'beans:property'. No child element is > expected > at this point. > at > com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAX > ParseException(ErrorHandlerWrapper.java:195) > at > com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Err > orHandlerWrapper.java:131) > at > com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError( > XMLErrorReporter.java:384) > at > com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError( > XMLErrorReporter.java:318) > at > com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator$XSIErro > rReporter.reportError(XMLSchemaValidator.java:410) > at > com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.reportS > chemaError(XMLSchemaValidator.java:3165) > at > com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.handleS > tartElement(XMLSchemaValidator.java:1781) > at > com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.emptyEl > ement(XMLSchemaValidator.java:705) > at > com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scan > StartElement(XMLNSDocumentScannerImpl.java:377) > at > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp > l$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2747) > at > com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(X > MLDocumentScannerImpl.java:648) > at > com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next > (XMLNSDocumentScannerImpl.java:140) > at > com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp > l.scanDocument(XMLDocumentFragmentScannerImpl.java:510) > at > com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X > ML11Configuration.java:807) > at > com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X > ML11Configuration.java:737) > at > com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser. > java:107) > at > com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser. > java:225) > at > com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Doc > umentBuilderImpl.java:283) > at > org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocum > ent(DefaultDocumentLoader.java:75) > at > org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadB > eanDefinitions(XmlBeanDefinitionReader.java:396) > > > > ----- Mensagem original ----- > De: "Sergey Vladimirov" <[email protected]> > Para: [email protected] > Enviadas: Quinta-feira, 22 de Julho de 2010 20:50:15 > Assunto: Re: Conexão mina com banco de dados > > Diego, > > Did you read the following documentation page? > http://mina.apache.org/ftpserver/database-user-manager.html > > 2010/7/23 Diego Silva e Silva <[email protected]> > >> Boa noite, >> >> estou tentando fazer a autenticação dos usuários no banco de dados, mas, >> não estou conseguindo. A documentação está muito fraca... não especifica >> qual arquivo alterar, onde esse arquivo deve estar! >> >> Alguem pode me ajudar? >> >> >> > -- > Sergey Vladimirov >
