J'essaie d'utiliser Alfresco (2.0) sous Windows...

[tegyat]

J'essaie d'utiliser Alfresco (2.0) sous Windows XP avec MySQL
J'ai apporté les modification necessaires, mais au démarage de Tomcat une erreur se produit:
loj4: Error occured while converting date.
java.lang.NullPointerException

Est ce que quelqu'un a idée de ce que je doit faire pour réuissir l'utilisation de Mysql?

[lme]

Bonjour,

C'est la seule erreur que tu as ? Tu n'as pas une trace Java plus complète ? Parce qu'avec ça, on ne va pas pouvoir aller très loin…
Et sans MySQL, tu arrives à démarrer Alfresco ? Quelle version de MySQL ?

[michaelh]

Et hop, un lien vers le message magique http://forum.alfresco-fr.org/viewtopic.php?id=86

Je sais, je le poste souvent, mais c'est mon petit plaisir du matin

[tegyat]

Bonjour,
-sans mysql ça marche.

-ci dessous la trace java

7 mars 2007 09:03:10 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
7 mars 2007 09:03:11 org.apache.catalina.startup.HostConfig deployWAR
INFO: DÚploiement de l'archive alfresco.war de l'application web
09:04:07,453 WARN  [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI re
gistry - creating new one
09:04:26,750 WARN  [repo.admin.ConfigurationChecker] The Alfresco 'dir.root' pro
perty is set to a relative path './alf_data'.  'dir.root' should be overridden t
o point to a specific folder.
09:04:26,750 INFO  [repo.admin.ConfigurationChecker] The Alfresco root data dire
ctory ('dir.root') is: .alf_data
09:04:27,281 ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: In
dexes not found for 4 stores.
09:04:27,281 INFO  [repo.admin.ConfigurationChecker] You may set 'index.recovery
.mode=FULL' if you need to rebuild the indexes.
09:04:27,281 ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Sy
stem content not found in content store.
09:04:27,281 ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root'
property is pointing to the correct data location.
09:04:27,312 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property
 is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:313)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:74)
        at org.alfresco.repo.admin.ConfigurationChecker$1.doWork(ConfigurationCh
ecker.java:180)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr
ansactionUtil.java:176)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio
n(TransactionUtil.java:82)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:184)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
211)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73
9)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
50)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:709
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
09:04:27,312 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envo
i de l'ÚvÞnement contexte initialisÚ (context initialized) Ó l'instance de class
e d'Úcoute (listener) org.springframework.web.context.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property
 is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:313)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:74)
        at org.alfresco.repo.admin.ConfigurationChecker$1.doWork(ConfigurationCh
ecker.java:180)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr
ansactionUtil.java:176)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio
n(TransactionUtil.java:82)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:184)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
211)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73
9)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
50)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:709
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
09:04:27,312 ERROR [[Catalina].[localhost].[/alfresco]] Exception lors de l'envo
i de l'ÚvÞnement contexte initialisÚ (context initialized) Ó l'instance de class
e d'Úcoute (listener) org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Ensure that the 'dir.root' property
 is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationCheck
er.java:313)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(Configuration
Checker.java:74)
        at org.alfresco.repo.admin.ConfigurationChecker$1.doWork(ConfigurationCh
ecker.java:180)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(Tr
ansactionUtil.java:176)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransactio
n(TransactionUtil.java:82)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(Configuratio
nChecker.java:184)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLi
fecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.m
ulticastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publis
hEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplica
tionContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationCon
text(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationConte
xt(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitiali
zed(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3763)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
211)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:73
9)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)

        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698
)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472
)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)

        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)

        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442
)
        at org.apache.catalina.core.StandardService.start(StandardService.java:4
50)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:709
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
7 mars 2007 09:04:27 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
7 mars 2007 09:04:27 org.apache.catalina.core.StandardContext start
GRAVE: Erreur de dÚmarrage du contexte [/alfresco] suite aux erreurs prÚcÚdentes

7 mars 2007 09:04:30 org.apache.coyote.http11.Http11BaseProtocol start
INFO: DÚmarrage de Coyote HTTP/1.1 sur http-8080
7 mars 2007 09:04:30 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
7 mars 2007 09:04:30 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/94  config=null
7 mars 2007 09:04:30 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
7 mars 2007 09:04:30 org.apache.catalina.startup.Catalina start
INFO: Server startup in 80937 ms
7 mars 2007 09:05:14 org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already.  C
ould not load org.quartz.StatefulJob.  The eventual following stack trace is cau
sed by an error thrown for debugging purposes as well as to attempt to terminate
 the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1241)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1201)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at org.quartz.JobDetail.class$(JobDetail.java:279)
        at org.quartz.JobDetail.isStateful(JobDetail.java:425)
        at org.quartz.simpl.RAMJobStore.triggerFired(RAMJobStore.java:1296)
        at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:
313)
Exception in thread "DefaultScheduler_QuartzSchedulerThread" java.lang.NoClassDe
fFoundError: org.quartz.StatefulJob
        at org.quartz.JobDetail.class$(JobDetail.java:279)
        at org.quartz.JobDetail.isStateful(JobDetail.java:425)
        at org.quartz.simpl.RAMJobStore.triggerFired(RAMJobStore.java:1296)
        at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:
313)
7 mars 2007 09:05:17 org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already.  C
ould not load org.alfresco.repo.avm.OrphanReaper$1TxnWork.  The eventual followi
ng stack trace is caused by an error thrown for debugging purposes as well as to
 attempt to terminate the thread which caused the illegal access, and has no fun
ctional impact.
java.lang.IllegalStateException
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1241)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1201)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at org.alfresco.repo.avm.OrphanReaper.doBatch(OrphanReaper.java:340)
        at org.alfresco.repo.avm.OrphanReaper.run(OrphanReaper.java:213)
        at java.lang.Thread.run(Thread.java:619)
Exception in thread "Thread-8" java.lang.NoClassDefFoundError: org/alfresco/repo
/avm/OrphanReaper$1TxnWork
        at org.alfresco.repo.avm.OrphanReaper.doBatch(OrphanReaper.java:340)
        at org.alfresco.repo.avm.OrphanReaper.run(OrphanReaper.java:213)
        at java.lang.Thread.run(Thread.java:619)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Merci.

[tegyat]

Question plus precise
a quoi sert dir.root?
Autre chose
pour utiliser MySql, que doit etre le contenu de dir.root?

[lme]

Pour commencer, le log que tu nous as donné ne contient pas ton erreur initiale (loj4: Error occured while converting date).

09:04:27,281 ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Sy
stem content not found in content store.
09:04:27,281 ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root'
property is pointing to the correct data location.

Pour avoir cette erreur, tu as certainement dû changer ta base de données (hsql -> mysql ou mysql -> hsql) sans vider le contenu de ton répertoire alf_data. Si tu changes de base de données (et repasse par la phase de bootstrape), il faut supprimer le contenu de ce répertoire.

a quoi sert dir.root?

Il indique juste le chemin vers ton alf_data. Ce répertoire contient les documents ajoutés dans alfresco et les indexes lucence.


Ce que je te conseille :
- modifie la configuration d'alfresco pour passer en MySQL
- supprime la base alfresco de ton serveur MySQL
- recrée cette base
- supprime le contenu de ton répertoire alf_data

[tegyat]

Ok c'est bon ca marche.

J'ai supprimé le contenu de alf_data, j'ai recréé la base.