topic Migration PostgreSQL nach MySQL in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migration-postgresql-nach-mysql/m-p/29992#M15373 <HTML><HEAD></HEAD><BODY><SPAN>Hallo zusammen,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><SPAN>Ich habe jetzt auf meiner bestehenden Installation einen PG_DUMP erzeugt und diesen nach </SPAN><A href="http://www.pukkapanel.com/guide29/convert-postgresql-dump-to-mysql" rel="nofollow noopener noreferrer">http://www.pukkapanel.com/guide29/convert-postgresql-dump-to-mysql</A><SPAN> 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:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR /> 2015-04-03 18:40:47,772&nbsp; INFO&nbsp; [alfresco.repo.admin] [localhost-startStop-1] Connected to database MySQL version 5.5.41-0ubuntu0.14.10.1<BR /> 2015-04-03 18:40:52,372&nbsp; INFO&nbsp; [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]<BR /> 2015-04-03 18:40:52,391&nbsp; INFO&nbsp; [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete<BR /> 2015-04-03 18:40:52,402&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes<BR /> 2015-04-03 18:40:56,689&nbsp; INFO&nbsp; [extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl<BR /> 2015-04-03 18:40:56,690&nbsp; INFO&nbsp; [extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js<BR /> 2015-04-03 18:40:57,873&nbsp; INFO&nbsp; [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]<BR /> 2015-04-03 18:40:57,897&nbsp; INFO&nbsp; [management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete<BR /> 2015-04-03 18:40:57,925&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbc:mysql://localhost/pfarrei_alf?useUnicode=yes&amp;characterEncoding=UTF-8, UserName=pfarrei@localhost, MySQL Connector Java<BR /> 2015-04-03 18:40:57,926&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.<BR /> 2015-04-03 18:40:58,326&nbsp; WARN&nbsp; [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<BR /> 2015-04-03 18:40:58,490&nbsp; WARN&nbsp; [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<BR /> 2015-04-03 18:40:58,597&nbsp; WARN&nbsp; [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<BR /> 2015-04-03 18:40:58,977&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-alf_-8459165130986985667.xml. <BR /> 2015-04-03 18:40:58,978&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-jbpm_-6816388499508662797.xml.<BR /> 2015-04-03 18:40:58,978&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Normalized schema dumped to file /tmp/tomcat7-tomcat7-tmp/Alfresco/Alfresco-schema-MySQLInnoDBDialect-pre-upgrade-act_-1630277546766940752.xml.<BR /> 2015-04-03 18:40:59,061&nbsp; INFO&nbsp; [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<BR /> 2015-04-03 18:40:59,119&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] [localhost-startStop-1] Executing database script /tmp/tomcat7-tomcat7-tmp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7715120621097951750.sql (Generated).<BR /> 2015-04-03 18:41:17,801&nbsp; INFO&nbsp; [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<BR /> 2015-04-03 18:41:26,010&nbsp; ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed<BR /> org.springframework.dao.DuplicateKeyException: <BR />### Error updating database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'<BR />### The error may involve alfresco.appliedpatch.insert_AppliedPatch-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into alf_applied_patch&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id, description,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fixes_from_schema, fixes_to_schema, target_schema,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; applied_to_schema, applied_on_date, applied_to_server,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; was_executed, succeeded, rep<BR />### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'patch.db-V4.0-Activiti-task-id-indexes' for key 'PRIMARY'<BR />; 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'<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.sun.proxy.$Proxy5.insert(Unknown Source)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Hat einer ein Tip fuer mich, wie ich den Fehler beheben kann?</SPAN><BR /><BR /><SPAN>Vielen Dank fuer Eure Hilfe.</SPAN><BR /><BR /><SPAN>gruss</SPAN><BR /><BR /><SPAN>martin</SPAN></BODY></HTML> Fri, 03 Apr 2015 17:05:30 GMT msauer75 2015-04-03T17:05:30Z Migration PostgreSQL nach MySQL https://connect.hyland.com/t5/alfresco-archive/migration-postgresql-nach-mysql/m-p/29992#M15373 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/guide2 Fri, 03 Apr 2015 17:05:30 GMT https://connect.hyland.com/t5/alfresco-archive/migration-postgresql-nach-mysql/m-p/29992#M15373 msauer75 2015-04-03T17:05:30Z Re: Migration PostgreSQL nach MySQL https://connect.hyland.com/t5/alfresco-archive/migration-postgresql-nach-mysql/m-p/29993#M15374 <HTML><HEAD></HEAD><BODY><SPAN>Hallo,</SPAN><BR /><BR /><SPAN>solche foren finde ich immer wieder toll, bei denen man ueberhaupt keine Antwort auf Probleme bekommt. Gibt hier es denn niemanden, der bereit ist einem zu helfen?</SPAN><BR /><BR /><SPAN>gruss</SPAN><BR /><BR /><SPAN>msauer75</SPAN></BODY></HTML> Sat, 11 Apr 2015 13:55:58 GMT https://connect.hyland.com/t5/alfresco-archive/migration-postgresql-nach-mysql/m-p/29993#M15374 msauer75 2015-04-11T13:55:58Z