AnsweredAssumed Answered

JLAN database configuration

Question asked by david.blin on Jul 16, 2008
Latest reply on Dec 19, 2008 by glob
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.

Outcomes