JLAN database configuration

[david_blin]

hello.

I have problems running the samples with databases for JLAN. (on windows)
what ever configuration is, I have:

%% Failed to load server configurationorg.alfresco.jlan.server.config.InvalidConfigurationException: XML error        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguration(CifsOnlyXMLServerConfiguration.java:215)        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguration(CifsOnlyXMLServerConfiguration.java:178)        at org.alfresco.jlan.app.JLANServer.loadConfiguration(JLANServer.java:596)        at org.alfresco.jlan.app.JLANServer.start(JLANServer.java:190)        at org.alfresco.jlan.app.JLANServer.main(JLANServer.java:123)Caused by: org.alfresco.jlan.server.config.InvalidConfigurationException: XML error        at org.alfresco.jlan.app.XMLServerConfiguration.loadConfiguration(XMLServerConfiguration.java:168)        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguration(CifsOnlyXMLServerConfiguration.java:209)        … 4 moreCaused by: org.alfresco.jlan.server.config.InvalidConfigurationException: Driver context error, org.alfresco.jlan.server.core.DeviceContextException: [b]Database interface initialization failure[/b], org.alfresco.jlan.server.config.InvalidConfigurationException: [b]Failed to create connection pool[/b], com.mysql.jdbc.Driver        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.addDiskShare(CifsOnlyXMLServerConfiguration.java:1921)        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.procSharesElement(CifsOnlyXMLServerConfiguration.java:1200)        at org.alfresco.jlan.app.XMLServerConfiguration.loadConfiguration(XMLServerConfiguration.java:147)        … 5 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have tried with Derby and mysql (I'm going to try with oracle).
I'm not used to derby but I know mysql is working and is accepting connections.

my config file is:

<driver><class>org.alfresco.jlan.server.filesys.db.DBDiskDriver</class><CacheTime>300</CacheTime><DatabaseInterface><class>org.alfresco.jlan.server.filesys.db.mysql.MySQLDBInterface</class><DSN>jdbc:mysql://myIP/toto</DSN><Username>dbuser</Username><Password>dbpassword</Password><ConnectionPool>10:20</ConnectionPool><FileSystemTable>filesys</FileSystemTable><StreamsTable>filestrm</StreamsTable></DatabaseInterface><FileLoader><class>org.alfresco.jlan.server.filesys.db.DBFileLoader</class><ThreadPoolSize>6:2</ThreadPoolSize><TempDirectory>C:\tmp\mysqlcTemp\</TempDirectory> <MaximumFilesPerDirectory>1000</MaximumFilesPerDirectory><SmallFileSize>100K</SmallFileSize><FilesPerJar>500</FilesPerJar><SizePerJar>1000K</SizePerJar><JarCompressionLevel>9</JarCompressionLevel></FileLoader></driver></diskshare>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

my log level is:

<sessionDebug flags="Negotiate,Socket,Tree,state,error,negotiate,transact,IPC,netbios"/>‍

does anyone has tested it, and can help me ?

thanks for your help.

[glob]

hello sirs,
  I met some questions to JLAN's installation, and they are familiar with this topic.
the questions i met were when my first time installing the jlan server, I met the following  condition with the command "java -cp .\alfresco-jlan.jar org.alfresco.jlan.app.JLANServer jlanConfig.xml" and "java -jar .\alfresco-jlan.jar jlanconfig.xml".
Thing is that it seems to be sth incorrect with format of setting, i.e., the file "jlanConfig.xml"

%% Failed to load server configurationorg.alfresco.jlan.server.config.InvalidConfigurationException: XML error        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguration(Unknown Source)        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguration(Unknown Source)        at org.alfresco.jlan.app.JLANServer.loadConfiguration(Unknown Source)        at org.alfresco.jlan.app.JLANServer.start(Unknown Source)        at org.alfresco.jlan.app.JLANServer.main(Unknown Source)Caused by: org.alfresco.jlan.server.config.InvalidConfigurationException: XML error        at org.alfresco.jlan.app.XMLServerConfiguration.loadConfiguration(Unknown Source)        … 5 moreCaused by: org.alfresco.jlan.server.config.InvalidConfigurationException: JCE provider class cryptix.jce.provider.CryptixCrypto not found        at org.alfresco.jlan.server.config.SecurityConfigSection.setJCEProvider(Unknown Source)        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.procSecurityElement(Unknown Source)        … 6 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

My JLAN is version 4.0 and the cofiguration file is as below:
* I simply modified the part of smb(neglect the other supported functions) and closed the port 445 before configuration, but it doesn't work at all….btw, i've read the installation guide many times as well….

Can  someone give me any suggestion or point out the misleadings? 

Thanks a lot!

<jlanserver>  <servers>    <SMB/>  </servers>     <SMB>    <host name="JLANSRV" domain="WORKGROUP">      <bindto>192.168.11.83</bindto>      <broadcast>192.168.11.255</broadcast>      <smbdialects>Core,LanMan,NT</smbdialects>      <comment>Alfresco JLAN Server</comment>      <Win32NetBIOS/>      <Win32Announce interval="5"/>            <!– Requires running the server using the root account –>            <tcpipSMB platforms="linux,macosx,solaris"/>      <!– To run the server using a non-root account on linux, Mac OS X, Solaris –>      <!–      <netBIOSSMB sessionPort="1139" namePort="1137" datagramPort="1138" platforms="linux,macosx,solaris"/>      <tcpipSMB port="1445" platforms="linux,macosx,solaris"/>      –>            <hostAnnounce interval="5"/>    </host>    <sessionDebug flags="Negotiate,Socket,Tree"/><!–    <netbiosDebug/> –><!–    <announceDebug/> –>          <authenticator type="local">         <mode>USER</mode>         <NOallowGuest/>      <Debug/>      </authenticator>      </SMB>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍