topic Re: 3.4.0 to 4.2.c, can I do it directly in Alfresco Archive

3.4.0 to 4.2.c, can I do it directly

bisana — Wed, 23 Jan 2013 08:08:47 GMT

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.

Re: 3.4.0 to 4.2.c, can I do it directly

bisana — Thu, 24 Jan 2013 08:53:00 GMT

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

Re: 3.4.0 to 4.2.c, can I do it directly

bisana — Sun, 27 Jan 2013 05:54:44 GMT

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

Re: 3.4.0 to 4.2.c, can I do it directly

heiko_robert — Mon, 28 Jan 2013 09:52:18 GMT

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.

Re: 3.4.0 to 4.2.c, can I do it directly

bisana — Tue, 29 Jan 2013 04:27:29 GMT

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

Re: 3.4.0 to 4.2.c, can I do it directly

apitsos — Wed, 30 Jan 2013 09:20:11 GMT

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

Re: 3.4.0 to 4.2.c, can I do it directly

bisana — Wed, 30 Jan 2013 10:30:36 GMT

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

Re: 3.4.0 to 4.2.c, can I do it directly

apitsos — Wed, 30 Jan 2013 10:49:16 GMT

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

Re: 3.4.0 to 4.2.c, can I do it directly

apitsos — Thu, 31 Jan 2013 09:26:00 GMT

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

Re: 3.4.0 to 4.2.c, can I do it directly

bisana — Thu, 31 Jan 2013 10:21:05 GMT

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

‍‍‍‍‍‍‍‍

Re: 3.4.0 to 4.2.c, can I do it directly

apitsos — Thu, 31 Jan 2013 14:45:21 GMT

Hi Joseph!

Thank you very much for your previous post, which indeed was a great guide and helped me to proceed with the upgrade from 3.4.0 to 4.0.e. We did a clean installation of Alfresco 4.0.e with MySQL installed in advance, then we dumped the database from the old server and we transferred the data. As soon as we started the services, the database converted and the tables increased from 84 into 100. We could also be able to login and operate Alfresco with success.

In the meantime, trying to upgrade from 4.0.e to 4.2.c we faced problems, as we can't login. What we did…
1. We did backup the data and the database again.
2. We completely uninstalled Alfresco 4.0.e
3. We installed Alfresco 4.2.c without PostgreSQL
4. We configured Alfresco on the installer wizard to connect with the MySQL 5.5 (which was already installed from the previous step/installation)
Note: We did not touch the database, as it was converted already from the previous installation of Alfresco 4.0.e
5. We moved the backupped data into the new installation of Alfresco (4.2.c)
6. We started the services
7. We tried to login.

Failed to login!

Did we do any mistake on the procedure?

Also we noticed that the number of the tables were still 100. Should we see a bigger number on Alfresco 4.2.c?

Thank you very much for all your help and your kind support. It is much appreciated.

Kind regards,
Angelos Pitsos

Re: 3.4.0 to 4.2.c, can I do it directly

bisana — Fri, 01 Feb 2013 06:33:56 GMT

please repeat the steps, avoid unistalling, instead try moving the alfresco installlion directory to anothername

Re: 3.4.0 to 4.2.c, can I do it directly

apitsos — Fri, 01 Feb 2013 13:07:21 GMT

Dear Joseph,

We realized that there was an issue with the server name, which had some dashes and underscores. As soon as we changed the computer name it worked, but we had several problems. We realized that several things were not working properly.

So we decided to revert back to 4.0.e in order to see what we did wrong on that step. Guess what? Even in Alfresco 4.0.e the search and some other functions were not working properly, too! So we started searching what could caused that problem.

After several hours of trials and searches on the web we found an important information. The 4.0.e has "sorl" indexer by default, but the 3.4.0 had "lucene" indexer. So that maybe was a reason that we couldn't rebuild the index properly on the new installation (4.0.e).

We searched a lot trying to find a solution on this, but we didn't find anything that could help. Would you be so kind to help us with this if you know how to solve the issue we are facing now?

Kind regards,
Angelos Pitsos

Re: 3.4.0 to 4.2.c, can I do it directly

bisana — Fri, 01 Feb 2013 15:53:33 GMT

when upgrading do not copy all the files and dir in alf_data
you need only copy contentstore and contentstore.deleted dir

Re: 3.4.0 to 4.2.c, can I do it directly

apitsos — Mon, 04 Feb 2013 13:11:20 GMT

Hi Joseph,

I would like to thank you for all your help and your time. Actually we have finished with the upgrade of our Alfresco Server. I have to say that it was a nightmare to upgrade it. It took almost a week in order to complete all the steps and tests but now we are done!

I believe that we have to upgrade it more often in order to avoid the "steps" that we had to do this time, but you live and learn!

Again thanks a lot. Your help is much appreciated!

Kind regards,
Angelos Pitsos

Re: 3.4.0 to 4.2.c, can I do it directly

yasir — Sat, 31 Aug 2013 06:11:00 GMT

Hi apitsos,
I need your favour to let me know the upgrade steps alfresco 3.4.0 to alfresco 4.2
Please kindly help me out on this email: yasir@wasaaiq.com

Thanks in advance,
Awaiting your response

Regards,
Yasir

Re: 3.4.0 to 4.2.c, can I do it directly

yasir — Sat, 31 Aug 2013 06:12:00 GMT

Re: 3.4.0 to 4.2.c, can I do it directly

derek — Sun, 01 Sep 2013 16:01:05 GMT

Hi
You should always install a clean target version, start it up and familiarize yourself with it before attempting an upgrade. Then stop, switch in the old data and restart.

Yes, there are new tables, deleted tables and a whole lot of other bits done to your database. This is done automatically.