3.4.0 to 4.2.c, can I do it directly

[bisana]

Hi All
I am planning to try upgrading 3.4.0 to 4.2.c. I want advice on this:-
Does a direct upgrading is possible ?
I plan to do in this manner, before taking backup I will disable the search and restart the 3.4.0 instance, then take a copy of the DB, alf_data and tomcat/shared directories.
install 4.2.x in a directory(do not start),copy the alf_data/contentstore  alf_data/contentstore.deleted from 3.4.0 backup to 4.2.x alf_data. Then after checking the configuration files and chaning it  for correctnes, start the service

Is the above mentioned method correct for upgrading from 3.4.0 to 4.2.c directly
Thanks

[bisana]

Hi
I tried out,direct upgradation from 3.4.0 to 4.2.c not possible, I came to know by trying out.
3.4.0 has 84 database table while 4.2.c has 100 tables.
I am now trying to upgrade to next release and check,  will give my experience posted on the forum
Thanks

[bisana]

I was able to upgrade, first I upgraded from 3.4 to 4.0. and from 4.0 to 4.1 and then from 4.1 to 4.2.
Thanks
Joseph John

[heiko_robert]

Hi Joseph,
do you refer to Enterprise or Community?
4.2 –> Community
4.1 –> Enterprise

We were able to upgrade Community installations 3.4.d –> 4.0.e –> 4.2.c with some manual fixes in the repository if the repository was initially installed before 2010.

[bisana]

Sorry, It was a dump typing mistake. while in a hurry to post the error came in
It was community edition only,
4.1 I did not do, the community edition only I upgraded
Extremly sorry for the typing mistake

[apitsos]

Hello there,

Could you please help me with this? I am having also an Alfresco isntallation (3.4.0) on a Windows 2003 std Server and I am planning to upgrade to 4.2.c but I am not sure how to proceed with this. I have read the Documentation at http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/upgrade-process.html, but it's not very clear how to proceed with it.

I would appreciate if you could provide a step-by-step guide in order to upgrade Alfresco Community 3.4.0 into 4.2.c.

Thanks a lot in advance for your time and your support!


Kind regards,
Angelos Pitsos

[bisana]

Ya happy to help, I assume u will try it in a test instance first than on production
First step:- Shut down alfresco, take the DB and Alfresco backup
Choose a test machine, Install the 4.0, do not start the service
restore the database on the test machine, copy the alf_data directory of the previous (3.4) to the new 4.0  install
Start the alfresco, check the logs, try to login
—
If my post is usefull, please mark comment as usefull

[apitsos]

Hi there!

Thanks a lot for your reply. Actually I am trying to upgrade the production server. I have informed the users that today it will be out of order, so I will be able to do it. The reason that I am not doing it on a test machine it's because it is a Virtual Machine and I took a snapshot. So whatever it happened I would restore it to the previous state by reverting the snapshot.

Now, according to your suggestion I realize that I can't just "upgrade" the existing installation. So I will prepare a new Virtual Machine with the same operating system (Windows 2003 std) and I will install there the latest version (4.2.c). As soon as I am done with it I will transfer the database and the data, according to your suggestion.

In case I face any issues, I will post here again, taking advantage of your kindness


Kind regards,
Angelos Pitsos

[apitsos]

Hi Joseph!

I would like to ask for a clarification. When you say "Install the 4.0" you mean that I can't do the migration/upgrade of Alfresco by installing 4.2.c, which is the latest version? Also I noticed that Alfresco 4.2.c has PostgreSQL and not MySQL as 3.4.0. I assume that this is a problem for the database restore. These two RDBMS are not compatible, isn't like that? And finally I was wondering, if you really mean to install 4.0, does this version have MySQL instead of PostgreSQL? And if yes, would be able then to upgrade 4.0 to 4.2.c? And would that mean that I will setup a third machine again?

Thanks a lot in advance for your support and your time!


Kind regards,
Angelos Pitsos

[bisana]

Hi Angelo
some points
from 3.4 u cannot directly upgrade to 4.2, from 3.4.x you upgrade to 4.0 and then to 4.2

About DB, you can have mysql in 4.2, you need to chose custom installation (option 2) and give the JDBC, DB Name, DB user and Password. After the installation is over you need to download the JDBC driver of MySQL (mysql-connector-java-5.1.22-bin.jar) and keep it in /tomcat/lib folder

You dont need to have postgresql installed for the upgrade, niether third machine

It is possible, follow the custom installation method(option 2)

For ur reference I am just adding the MySQL or DB parameter which u have to give during installation

db.driver=org.gjt.mm.mysql.Driver
db.username=urmysqlusername
db.password=urmysqlusernamepassword
db.name=urmysqldatabasename
db.url=jdbc:mysql://localhost/urmysqldatabasename?useUnicode=yes&characterEncoding=UTF-8

‍‍‍‍‍‍‍‍