Errore avvio Alfresco MySQL Linux

cancel
Showing results for 
Search instead for 
Did you mean: 
snapster
Member II

Errore avvio Alfresco MySQL Linux

Buongiorno,
sto tentando di effettuare un'installazione di Alfresco 4.0.e non bundle su una macchina Linux/Ubuntu, e su DB MySQL.
Dopo aver creato (senza problemi) il database con il seguente script:


create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;


ho provveduto all'installazione di Alfresco prendendo spunto da questo <a href="http://www.cosenonjaviste.it/installazione-passo-per-passo-di-alfresco-community-4-2-c-su-ubuntu-12-...">articolo</a>, ho modificato il file alfresco-global.properties per la configurazione del DB e per la corretta assegnazione  della "dir.root".
Al riavvio del servizio di Alfresco però, il sistema va in errore. Di seguito il log:


09:32:20,786 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
09:32:20,886 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
09:32:28,764 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
09:32:31,656 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
09:32:31,659 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
09:32:36,812 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
09:32:38,023 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
09:32:38,282 WARN  [org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap] StoreRef 'workspace://SpacesStore' does not exist
09:32:38,456 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Search' subsystem, ID: [Search, managed, lucene]
09:32:38,747 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Search' subsystem, ID: [Search, managed, lucene] complete
09:32:39,495 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 02070000 Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:361)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:718)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5291)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:977)
   at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1655)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
   at java.util.concurrent.FutureTask.run(FutureTask.java:166)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
   at java.lang.Thread.run(Thread.java:679)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 20; column 16 due to error: Node has 0 primary paths: (25, workspace://SpacesStore/36dfffc7-b178-4358-a174-50ee62f9f113)
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:194)
   at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:414)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:252)
   at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstrap.java:475)
   at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBootstrap.java:70)
   at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBootstrap.java:350)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:354)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:357)
   … 25 more
Caused by: java.lang.RuntimeException: Node has 0 primary paths: (25, workspace://SpacesStore/36dfffc7-b178-4358-a174-50ee62f9f113)
   at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getPaths(AbstractNodeDAOImpl.java:3394)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPaths(DbNodeServiceImpl.java:2176)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPath(DbNodeServiceImpl.java:2158)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at sun.proxy.$Proxy8.getPath(Unknown Source)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
   at sun.proxy.$Proxy9.getPath(Unknown Source)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:305)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:305)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:305)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at sun.proxy.$Proxy8.getPath(Unknown Source)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:616)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.audit.DisableAuditableBehaviourInterceptor.invoke(DisableAuditableBehaviourInterceptor.java:113)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:147)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute(RetryingTransactionInterceptor.java:69)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke(RetryingTransactionInterceptor.java:59)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at sun.proxy.$Proxy8.getPath(Unknown Source)
   at org.alfresco.repo.model.filefolder.HiddenAspect.onHiddenPath(HiddenAspect.java:274)
   at org.alfresco.repo.model.filefolder.HiddenAspect.checkHidden(HiddenAspect.java:404)
   at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importNode(ImporterComponent.java:622)
   at org.alfresco.repo.importer.view.ViewParser.importNode(ViewParser.java:919)
   at org.alfresco.repo.importer.view.ViewParser.processStartAssoc(ViewParser.java:834)
   at org.alfresco.repo.importer.view.ViewParser.processStartElement(ViewParser.java:303)
   at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:176)
   … 34 more
09:32:47,221 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
09:32:47,280 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
09:32:47,281 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
09:32:47,284 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
09:32:48,822 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 312 Web Scripts (+0 failed), 322 URLs
09:32:48,822 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
09:32:48,822 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
09:32:49,011 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 1723.0046ms)
09:32:49,016 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
09:32:49,020 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js


Non riesco proprio a capire dove sia il problema. Una cosa che ho notato è che comunque vengono create le cartelle all'interno di "alf_data", ma non vengono create le cartelle relative ai nodi nella cartella "/opt/alfresco/alf_data/lucene-indexes/workspace/SpacesStore".

Grazie anticipatatente del supporto.

Giovanni
6 Replies
coyoteugly
Member II

Re: Errore avvio Alfresco MySQL Linux

Ciao, purtroppo non sono in grado di darti lumi sul tuo errore, però per quanto riguarda l'installazione no bundle con mysql puoi prendere spunto anche da questo articolo: http://www.whiteboardcoder.com/2013/01/install-alfresco-community-42-on-ubuntu_31.html

Ciao.
snapster
Member II

Re: Errore avvio Alfresco MySQL Linux

Niente da fare. Ho fatto una nuova installazione seguendo la guida che mi hai suggerito ma anzichè risolvere il problema l'ho peggiorato dato che ora non avviene la connessione al DB.
Nessuno può aiutarmi? La cosa è importante e sono decisamente ad un punto morto.
fcorti
Alfresco Employee

Re: Errore avvio Alfresco MySQL Linux

Ciao,

Su due piedi non capisco il problema però provo l'installazione e ti dico.
Se hai maggiori dettagli o vincoli postali qui o mandameli in posta del forum.
Stay tuned…
snapster
Member II

Re: Errore avvio Alfresco MySQL Linux

Ciao Francesco, ti ringrazio molto ma ho appena risolto…o meglio ho rifatto l'installazione da 0 e ha funzionato (non sò perchè, comunque poco male).
Ora Alfresco si avvia e sembra che funzioni tutto correttamente. Guardando il log di catalina.out però mi sono accorto del seguente errore:


mar 08, 2013 12:38:01 PM org.apache.catalina.startup.ClassLoaderFactory validateFile
WARNING: Problem with directory [/opt/tomcat/shared/lib], exists: [false], isDirectory: [false], canRead: [false]
mar 08, 2013 12:38:01 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/i386:/lib:/usr/lib
mar 08, 2013 12:38:02 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
mar 08, 2013 12:38:02 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
mar 08, 2013 12:38:02 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 625 ms
mar 08, 2013 12:38:02 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
mar 08, 2013 12:38:02 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.35
mar 08, 2013 12:38:02 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /opt/tomcat/webapps/alfresco.war
mar 08, 2013 12:38:11 PM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
2013-03-08 12:38:21,604  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
2013-03-08 12:38:21,660  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
2013-03-08 12:38:30,748  WARN  [alfresco.util.AbstractTriggerBean] [localhost-startStop-1] Job ehCacheTracerJob is not active/enabled
2013-03-08 12:38:35,112  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl
2013-03-08 12:38:35,115  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js
2013-03-08 12:38:41,026  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
2013-03-08 12:38:41,266  WARN  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 43 potential problems, results written to: /opt/tomcat/temp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-9131858902985648963.txt
2013-03-08 12:38:41,446  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7113392645680126014.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-RepoTables.sql).
2013-03-08 12:38:42,541  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6373891221973675816.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-LockTables.sql).
2013-03-08 12:38:42,561  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-883903403288022583.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-ContentTables.sql).
2013-03-08 12:38:42,693  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-5736852897685902679.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-PropertyValueTables.sql).
2013-03-08 12:38:42,839  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-70557341469406451.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-AuditTables.sql).
2013-03-08 12:38:42,854  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7435209922350453249.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-AvmTables.sql).
2013-03-08 12:38:43,143  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-5987272030137162346.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-ActivityTables.sql).
2013-03-08 12:38:43,166  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2721419643386555429.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-UsageTables.sql).
2013-03-08 12:38:43,179  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-31084445456943532.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoCreate-SubscriptionTables.sql).
2013-03-08 12:38:43,230  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6177473209477748818.sql (Generated).
2013-03-08 12:38:44,586  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-4290866305838528204.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-JBPM-Extra.sql).
2013-03-08 12:38:44,593  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1691934136888391896.sql (Copied from classpath:alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-JBPM-FK-indexes.sql).
2013-03-08 12:38:45,437  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] All executed statements:  /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-All_Statements-8591456419949142183.sql.
2013-03-08 12:38:45,894  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Compared database schema with reference schema (all OK): class path resource [alfresco/dbscripts/create/org.hibernate.dialect.MySQLInnoDBDialect/Schema-Reference.xml]
2013-03-08 12:38:46,383  INFO  [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /opt/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-1037573074613400556.xml.
2013-03-08 12:38:46,549  WARN  [repo.dictionary.DictionaryRepositoryBootstrap] [localhost-startStop-1] StoreRef 'workspace://SpacesStore' does not exist
2013-03-08 12:38:46,609  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Search' subsystem, ID: [Search, managed, lucene]
2013-03-08 12:38:46,975  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Search' subsystem, ID: [Search, managed, lucene] complete
2013-03-08 12:38:47,857  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
2013-03-08 12:38:48,705  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
2013-03-08 12:38:48,706  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]
2013-03-08 12:38:49,045  WARN  [alfresco.util.OpenOfficeConnectionTester] [localhost-startStop-1] An initial OpenOffice connection could not be established.
2013-03-08 12:38:49,049  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete
2013-03-08 12:39:09,799  INFO  [repo.admin.ConfigurationChecker] [localhost-startStop-1] The Alfresco root data directory ('dir.root') is: /alfresco/alf_data
2013-03-08 12:39:09,820  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1] Checking for patches to apply …
2013-03-08 12:39:10,712  WARN  [admin.patch.PatchExecuter] [localhost-startStop-1] Patch description is not available: Patch[ id=patch.migrateAttrDelete, description=patch.migrateAttrDelete.description, fixesFromSchema=0, fixesToSchema=4106, targetSchema=4107]
2013-03-08 12:39:10,825  WARN  [admin.patch.PatchExecuter] [localhost-startStop-1] Patch description is not available: Patch[ id=patch.activitiesEmailTemplate, description=patch.activitiesEmailTemplate.description, fixesFromSchema=0, fixesToSchema=5005, targetSchema=5006]
2013-03-08 12:39:10,947  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]    Applying patch 'patch.siteLoadPatch.swsdp' (Loads a sample site into the repository.).
2013-03-08 12:39:10,977  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2013-03-08 12:39:11,151  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete
2013-03-08 12:39:17,210  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]    Applying patch 'patch.exampleJavaScript' (Loads sample Javascript file into datadictionary scripts folder).
2013-03-08 12:39:17,406  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.4-UsageTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,406  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.0-ActivityTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.2-LockTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.2-ContentTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.2-PropertyValueTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.2-AvmTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.2-AuditTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.3-JBPM-Extra
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V3.4-JBPM-FK-indexes
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,407  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.db-V4.0-SubscriptionTables
RESULT:
Script completed
=====================================
2013-03-08 12:39:17,408  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.exampleJavaScript
RESULT:
Imported view into bootstrap location: /app:company_home/app:dictionary/app:scripts (workspace://SpacesStore/a66d0239-3567-401c-8beb-2a6a06d81653)
=====================================
2013-03-08 12:39:17,408  INFO  [admin.patch.PatchExecuter] [localhost-startStop-1]
=== Applied patch                 ===
ID: patch.siteLoadPatch.swsdp
RESULT:
Site swsdp imported.
=====================================
2013-03-08 12:39:17,412  INFO  [repo.module.ModuleServiceImpl] [localhost-startStop-1] Found 0 module(s).
2013-03-08 12:39:17,416  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'fileServers' subsystem, ID: [fileServers, default]
2013-03-08 12:39:18,135  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'fileServers' subsystem, ID: [fileServers, default] complete
2013-03-08 12:39:18,135  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'imap' subsystem, ID: [imap, default]
2013-03-08 12:39:18,135  ERROR [org.alfresco.fileserver] [FTP Server] [FTP] FTP Socket error : java.net.BindException: Permesso negato
2013-03-08 12:39:18,151  ERROR [org.alfresco.fileserver] [FTP Server] Error from JLAN
java.net.BindException: Permesso negato
   at java.net.PlainSocketImpl.socketBind(Native Method)
   at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:376)
   at java.net.ServerSocket.bind(ServerSocket.java:376)
   at java.net.ServerSocket.<init>(ServerSocket.java:237)
   at java.net.ServerSocket.<init>(ServerSocket.java:181)
   at org.alfresco.jlan.ftp.FTPServer.run(FTPServer.java:554)
   at java.lang.Thread.run(Thread.java:722)
2013-03-08 12:39:18,158  ERROR [org.alfresco.fileserver] [CIFS Server] [SMB] Server error : org.alfresco.jlan.server.config.InvalidConfigurationException: Error initializing TCP-IP SMB session handler, Permesso negato
2013-03-08 12:39:18,158  ERROR [org.alfresco.fileserver] [CIFS Server] Error from JLAN
org.alfresco.jlan.server.config.InvalidConfigurationException: Error initializing TCP-IP SMB session handler, Permesso negato
   at org.alfresco.jlan.smb.server.nio.NIOCifsConnectionsHandler.initializeHandler(NIOCifsConnectionsHandler.java:259)
   at org.alfresco.jlan.smb.server.SMBServer.run(SMBServer.java:475)
   at java.lang.Thread.run(Thread.java:722)
2013-03-08 12:39:18,244  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'imap' subsystem, ID: [imap, default] complete
2013-03-08 12:39:18,244  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'email' subsystem, ID: [email, outbound]
2013-03-08 12:39:18,373  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'email' subsystem, ID: [email, outbound] complete
2013-03-08 12:39:18,373  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'email' subsystem, ID: [email, inbound]
2013-03-08 12:39:18,463  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'email' subsystem, ID: [email, inbound] complete
2013-03-08 12:39:18,463  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'googledocs' subsystem, ID: [googledocs, default]
2013-03-08 12:39:18,524  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'googledocs' subsystem, ID: [googledocs, default] complete
2013-03-08 12:39:18,524  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Subscriptions' subsystem, ID: [Subscriptions, default]
2013-03-08 12:39:18,560  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Subscriptions' subsystem, ID: [Subscriptions, default] complete
2013-03-08 12:39:18,561  INFO  [repo.usage.UserUsageTrackingComponent] [localhost-startStop-1] Disabled - clear non-missing user usages …
2013-03-08 12:39:18,565  INFO  [repo.usage.UserUsageTrackingComponent] [localhost-startStop-1] Found 4 users to clear
2013-03-08 12:39:18,728  INFO  [repo.usage.UserUsageTrackingComponent] [localhost-startStop-1] … cleared non-missing usages for 4 users
2013-03-08 12:39:18,730  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Synchronization' subsystem, ID: [Synchronization, default]
2013-03-08 12:39:18,816  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Synchronization' subsystem, ID: [Synchronization, default] complete
2013-03-08 12:39:18,890  INFO  [service.descriptor.DescriptorService] [localhost-startStop-1] Alfresco JVM - v1.7.0_17-b02; maximum heap size 1820,500MB
2013-03-08 12:39:18,911  INFO  [service.descriptor.DescriptorService] [localhost-startStop-1] Alfresco started (Community). Current version: 4.0.0 (7) schema 5.025. Originally installed version: 4.0.0 (7) schema 5.025.
2013-03-08 12:39:18,913  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default]
2013-03-08 12:39:19,065  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default] complete
2013-03-08 12:39:19,066  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Replication' subsystem, ID: [Replication, default]
2013-03-08 12:39:19,078  WARN  [alfresco.util.OpenOfficeConnectionTester] [DefaultScheduler_Worker-1] Error trying to query Open Office version information. OpenOffice.org's ConfigurationRegistry not implemented in this version of OOo. This should not affect the operation of OOo.
2013-03-08 12:39:19,096  INFO  [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Replication' subsystem, ID: [Replication, default] complete
2013-03-08 12:39:19,174  INFO  [alfresco.util.OpenOfficeConnectionTester] [DefaultScheduler_Worker-1] The OpenOffice connection was re-established.
2013-03-08 12:39:28,124  WARN  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Unable to register script classpath:webscripts/org/springframework/extensions/cmis/content.get.desc.xml due to error: 02080000 Web Script document org/springframework/extensions/cmis/content.get.desc.xml is attempting to define the url '/cmis/content:GET' already defined by org/alfresco/cmis/client/content.get.desc.xml
2013-03-08 12:39:28,125  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 463 Web Scripts (+1 failed), 730 URLs
2013-03-08 12:39:28,125  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 2 Package Description Documents (+0 failed)
2013-03-08 12:39:28,125  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 1 Schema Description Documents (+0 failed)
2013-03-08 12:39:28,128  INFO  [extensions.webscripts.AbstractRuntimeContainer] [localhost-startStop-1] Initialised Repository Web Script Container (in 7075.7544ms)
2013-03-08 12:39:28,141  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2013-03-08 12:39:28,143  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
mar 08, 2013 12:39:31 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /opt/tomcat/webapps/share.war
2013-03-08 12:39:37,755  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2013-03-08 12:39:37,823  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
2013-03-08 12:39:37,824  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2013-03-08 12:39:37,827  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
2013-03-08 12:39:40,304  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 312 Web Scripts (+0 failed), 322 URLs
2013-03-08 12:39:40,304  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 8 Package Description Documents (+0 failed)
2013-03-08 12:39:40,305  INFO  [extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 0 Schema Description Documents (+0 failed)
2013-03-08 12:39:40,505  INFO  [extensions.webscripts.AbstractRuntimeContainer] [localhost-startStop-1] Initialised Spring Surf Container Web Script Container (in 2674.3032ms)
2013-03-08 12:39:40,513  INFO  [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl
2013-03-08 12:39:40,516  INFO  [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
mar 08, 2013 12:39:40 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/host-manager
mar 08, 2013 12:39:41 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/manager
mar 08, 2013 12:39:41 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/docs
mar 08, 2013 12:39:41 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/examples
mar 08, 2013 12:39:41 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory /opt/tomcat/webapps/ROOT
mar 08, 2013 12:39:41 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
mar 08, 2013 12:39:41 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
mar 08, 2013 12:39:41 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 99156 ms


Sapresti dirmi di cosa si tratta?

Grazie ancora
Giovanni
fcorti
Alfresco Employee

Re: Errore avvio Alfresco MySQL Linux

Meglio così!

Quello è un "finto errore" nel senso che lo da quando non attivi FTP e CIFS dal file alfresco-global.properties.
Attivali e sparirà.
Dal log tutto è ok: ha creato il db ed è partito correttamente.
Buon lavoro! ;-)
snapster
Member II

Re: Errore avvio Alfresco MySQL Linux

Molto bene. Grazie!

Giovanni