Hallo zusammen,ich versuche zur Zeit meine Alfresco 5.0.c Installation, die mit PostgreSQL laeuft, umzuziehen. Gleichzeitig will ich auch den Datenbank Server auf MySQL umstellen.Ich habe jetzt auf meiner bestehenden Installation einen PG_DUMP erzeugt und diesen nach http://www.pukkapanel.com/guide29/convert-postgresql-dump-to-mysql in ein MySQL SQL File konvertiert. Dies konnte ich jetzt auf meinem neuen Server in die MySQL Datenbank ein lesen. Nachdem Starten des Tomcat7 konnte ich mich nicht mehr anmelden. Es kommt nur noch die Meldung "Ihre Authentifizierungsdaten wurden nicht erkannt oder Alfresco ist zurzeit nicht verfügbar.". In catalina.out konnte ich folgende Eintraege finden:
2015-04-03 18:40:47,772 INFO [alfresco.repo.admin] [localhost-startStop-1] Connected to database MySQL version 5.5.41-0ubuntu0.14.10.1
2015-04-03 18:40:52,372 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
2015-04-03 18:40:52,391 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
2015-04-03 18:40:52,402 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes
2015-04-03 18:40:56,689 INFO [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl
2015-04-03 18:40:56,690 INFO [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js
2015-04-03 18:40:57,873 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
2015-04-03 18:40:57,897 INFO [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete
2015-04-03 18:40:57,925 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:mysql://localhost/pfarrei_alf?useUnicode=yes&characterEncoding=UTF-8, UserName=pfarrei@localhost, MySQL Connector Java
2015-04-03 18:40:57,926 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
2015-04-03 18:40:58,326 WARN [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 234 potential problems, results written to: /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-alf_-5617404871001400472.tx
2015-04-03 18:40:58,490 WARN [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 369 potential problems, results written to: /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-jbpm_-620924991441690840.tx
2015-04-03 18:40:58,597 WARN [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema validation found 208 potential problems, results written to: /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-MySQLInnoDBDialect-Validation-Pre-Upgrade-act_-7985090968661594782.tx
2015-04-03 18:40:58,977 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-alf_-8459165130986985667.xml.
2015-04-03 18:40:58,978 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-jbpm_-6816388499508662797.xml.
2015-04-03 18:40:58,978 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-act_-1630277546766940752.xml.
2015-04-03 18:40:59,061 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /tmp/tomcat7-tomcat7-tmp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-3854713294970287163.sql (Copied from classpath:alfresco/dbscripts/upgrade/4.1/o
2015-04-03 18:40:59,119 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /tmp/tomcat7-tomcat7-tmp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7715120621097951750.sql (Generated).
2015-04-03 18:41:17,801 INFO [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /tmp/tomcat7-tomcat7-tmp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-1362012473289214311.sql (Copied from classpath:alfresco/dbscripts/create/org.hi
2015-04-03 18:41:26,010 ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
org.springframework.dao.DuplicateKeyException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'
### The error may involve alfresco.appliedpatch.insert_AppliedPatch-Inline
### The error occurred while setting parameters
### SQL: insert into alf_applied_patch ( id, description, fixes_from_schema, fixes_to_schema, target_schema, applied_to_schema, applied_on_date, applied_to_server, was_executed, succeeded, rep
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'
; SQL []; Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
at com.sun.proxy.$Proxy5.insert(Unknown Source)
Hat einer ein Tip fuer mich, wie ich den Fehler beheben kann?Vielen Dank fuer Eure Hilfe.grussmartin
