topic Re: Upgrading Alfresco CE version in Alfresco Archive

Upgrading Alfresco CE version

redbull — Mon, 08 Feb 2016 18:44:11 GMT

this page: http://docs.alfresco.com/5.0/concepts/upgrade-path.htmldescribes the general upgrade paths, so I understand that from 3.x to 5.x it's necessary go towards 4.x before.For the database, the path suppose "Backing up and restoring the repository"; now, my 3.x database is MYSQL. How I can use

Re: Upgrading Alfresco CE version

mitpatoliya — Mon, 08 Feb 2016 20:37:39 GMT

You can configure your new alfresco instance(with upgraded version) to use MySQL and then point to same db. You may run in to issues if you try to migrate from MySQL to PostSQL which is unnecessary if you just want to upgrade alfresco.

Re: Upgrading Alfresco CE version

redbull — Tue, 09 Feb 2016 10:19:25 GMT

Thank you mitpatoliya for the suggest,
I have a doubt: the MySQL 3.x database is perfectly compatible with Alfresco 4.x or this (new alfresco instance) introduces changes to the structure of the tables?

Re: Upgrading Alfresco CE version

mrogers — Tue, 09 Feb 2016 11:32:30 GMT

Yes there will be differences but alfresco will deal with it in the upgrade process.

Re: Upgrading Alfresco CE version

redbull — Tue, 09 Feb 2016 14:49:55 GMT

so, following your tips I did a test.
The starting point was to have 3.4.d working version. Then:
1) install Alfresco CE 4.2.f
2) start Alfresco CE 4.2.f to verify that it works; …and stop Alfresco: all is OK
3) modify 4.2.f alfresco-global.properties:
   A) configure MySQL database instead of POSTGRES:
      ### POSTGRES database connection properties ###
      ### db.driver=org.postgresql.Driver
      ### db.username=alfresco
      ### db.password=alfresco
      ### db.name=alfresco
      ### db.url=jdbcostgresql://localhost:7432/${db.name}
      ### MYSQL database connection properties
      ### NOTE: this is the same MYSQL istance used by Alf 3.4.d
      db.driver=org.gjt.mm.mysql.Driver
      db.username=alfresco
      db.password=alfresco
      db.name=alfresco
      db.url=jdbc:mysql://localhost:3366/${db.name}?useUnicode=yes&characterEncoding=UTF-8
      Copy the JAR file mysql-connector-java-5.1.13-bin.jar into the <TOMCAT_HOME>/lib directory for Tomcat (C:\Alfresco_4.2.f\tomcat\lib)
   B) configure dir.root:
      ### dir.root=C:/ALFRES~1.F/alf_data
      NOTE: this is the same dir.root used by Alf 3.4.d
      dir.root=C:/Alfresco_3.4.d/alf_data
   C) replace SOLR with LUCENE:
      ### Solr indexing ###
      ### index.subsystem.name=solr
      ### dir.keystore=${dir.root}/keystore
      ### solr.port.ssl=8543
      ### Lucene indexing ###
      index.subsystem.name=lucene

Start mysql and alfresco 4.2.f tomcat services: they start.
With Alfresco Explorer I did a check: see ALL the 3.4.d repo (user, space, ACL,…) but checking a space content I don't see any documents!!!
In what I did wrong?

Re: Upgrading Alfresco CE version

mrogers — Tue, 09 Feb 2016 15:53:14 GMT

Are you accessing the correct database? Do you have an instance of mysql that is separate from alfresco or one that is bundled inside?

Re: Upgrading Alfresco CE version

redbull — Tue, 09 Feb 2016 15:57:09 GMT

I use bundled inside MYSQL instance, the one that comes with ALF 3.4.d version.

Re: Upgrading Alfresco CE version

redbull — Wed, 10 Feb 2016 08:28:26 GMT

I redid the test, following the same steps described above and magically all work correctly!
Now I can see the documents!
I don't know if this is the correct procedure to upgrade 3.x to 4.x version, anyway I can say it works.
Thanks to mitpatoliya and mrogers for the support.