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 configuration
org.alfresco.jlan.server.config.InvalidConfigurationException: XML error
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguratio
n(CifsOnlyXMLServerConfiguration.java:215)
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguratio
n(CifsOnlyXMLServerConfiguration.java:178)
        at org.alfresco.jlan.app.JLANServer.loadConfiguration(JLANServer.java:59
6)
        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 er
ror
        at org.alfresco.jlan.app.XMLServerConfiguration.loadConfiguration(XMLSer
verConfiguration.java:168)
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguratio
n(CifsOnlyXMLServerConfiguration.java:209)
        … 4 more
Caused by: org.alfresco.jlan.server.config.InvalidConfigurationException: Driver
 context error, org.alfresco.jlan.server.core.DeviceContextException: [b]Database i
nterface initialization failure[/b], org.alfresco.jlan.server.config.InvalidConfigur
ationException: [b]Failed to create connection pool[/b], com.mysql.jdbc.Driver
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.addDiskShare(Cif
sOnlyXMLServerConfiguration.java:1921)
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.procSharesElemen
t(CifsOnlyXMLServerConfiguration.java:1200)
        at org.alfresco.jlan.app.XMLServerConfiguration.loadConfiguration(XMLSer
verConfiguration.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 configuration
org.alfresco.jlan.server.config.InvalidConfigurationException: XML error
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguratio
n(Unknown Source)
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.loadConfiguratio
n(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 er
ror
        at org.alfresco.jlan.app.XMLServerConfiguration.loadConfiguration(Unknow
n Source)
        … 5 more
Caused by: org.alfresco.jlan.server.config.InvalidConfigurationException: JCE pr
ovider class cryptix.jce.provider.CryptixCrypto not found
        at org.alfresco.jlan.server.config.SecurityConfigSection.setJCEProvider(
Unknown Source)
        at org.alfresco.jlan.app.CifsOnlyXMLServerConfiguration.procSecurityElem
ent(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>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍