topic Re: Migration from Windows to Linux in Alfresco Archive

Migration from Windows to Linux

kbryd — Tue, 11 Aug 2009 12:21:47 GMT

HelloI have encountered on interesting problem. I have Alfresco running on Windows system ('production' system), sometimes I have to work on this repository and I copy it form that Windows box to my Linux system (no risk destroying production system). And this is where problem starts, when I copy My

Re: Migration from Windows to Linux

pmonks — Fri, 14 Aug 2009 19:37:35 GMT

From the symptoms listed above it's hard to be sure what the problem is, but my first suspicion is that you're running different binary builds of Alfresco on each environment.

Cheers,
Peter

Re: Migration from Windows to Linux

kbryd — Sat, 15 Aug 2009 10:27:57 GMT

Hello Peter

No, I copy whole Alfresco directory from Windows to Linux (except jdk and Open Office obviously) , then I do chmod +x tomcat/bin/* and start it as usual (I am using alfresco.sh form a Linux Alfresco installation because in Windows one there are only *.bat files).

I am using Alfresco Labs 3.0 Stable (exact version string is Alfresco started (Labs): Current version 3.0.0 (Stable 1526) schema 1002 - Installed version 3.0.0 (Stable 1526) schema 1002), could it be that the default MySQL configuration on Linux is different and not compatible with Windows?

Karol

Re: Migration from Windows to Linux

mike54 — Mon, 21 Sep 2009 16:38:07 GMT

I'm trying to do the same thing and I get the same error.
My current server is WIndows with Alfresco 3.2 and destination server is CentOS 5.3 with Alfresco 3.2
At the beginning I had Windows 3.0 and Centos 3.2 - but I have upgraded (with schema update) so that both systems run 3.2…

Centos version still wants to perform schema update and fails with:

e JBPM_ACTION add index FK_ACTION_REFACT (REFERENCEDACTION_), add constraint FK_ACTION_REFACT foreign key (REFERENCEDACTION_) references JBPM_ACTION (ID_)
   Error: Can't create table './alfresco/#sql-2c04_d8.frm' (errno: 121)
   File: /usr/share/tomcat5/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-40094.sql
   Line: 29
20:32:35,291 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table './alfresco/#sql-2c04_d8.frm' (errno: 121)‍‍‍‍‍‍

One more thing is that I don't know if the DB update was actually sucessful?
On the windowsmachine I can see:

18:42:38,738 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.2.0 (2039) schema 2019 - Installed version 3.0.0 (c 1342) schema 1000‍

I'm not sure if I understand - current version is 3.2 and installed versin is 3.0…?

Any sugestions please?

Re: Migration from Windows to Linux

norgan — Mon, 21 Sep 2009 19:55:10 GMT

That sounds like a bug, one of you should open an "support request" issue with issues.alfresco.com and post the link here so others can vote on it and add their comments.

Re: Migration from Windows to Linux

mike54 — Mon, 21 Sep 2009 20:16:48 GMT

OK, I know what was causing this problem!
I'm totally new to Linux / CentOS and it took me some time before I have realized, why it wants to perform schema update…?
I was thinking - what is different between those systems? In my case the answer was.. case sensitivity!
Migrated database was not "recognized" by alfresco under linux and it wanted to perform schema update that failed for the same reason.

I have added this option to MySQL server config file (my.cnf): lower_case_table_names=1

This resulted in a pretty looking clean log with only one warning that I still have to cope with, that is OpenOffice connection…

Regards,
Maciej

Re: Migration from Windows to Linux

zomurn — Tue, 09 Mar 2010 10:30:47 GMT

Mike54 > nice quote ! You gain one point to save me days of research . (unfortunately I can't because it is not a reply from you… )