migration problem

[trel0d0c]

Hello everyone, i've faced a problem today at work. we have an alfresco 4.0d running on a windows server and the database that was connected with was on a second linux server. we set up a new seperate ubuntu server and install on it the bitnami-alfresco 4.2e. Based on the alfresco documentation for migration i took the root.dir from the first server and place it on the new one. i opened the alfresco-global.properties file and change the path for the new root.dir folder. Inside this file in the section where we declare the database connection properties, i let it as it was because it would take the same database as the old server from the database server.
like this:
"db.url=jdbc:mysql://database_domain:3306/alfresco4d?useUnicode=yes&characterEncoding=UTF-8"
after that the database on the database server was upgrated to the new version and we cannot connect to the old alfresco server.
I don't know how that happened an i try to find a solution.
Can anyone help?

[colindstephenso]

Can you confirm your approach?

1. Alfresco 4.0d on a windows server
2. Installed Alfresco 4.2e on new server
3. You copied the alf_data from the 4.0d server to the 4.2e server
4. You pointed Alfresco 4.2e to the 4.0d database instance

If this is correct you are essentially attempting to share the database between 2 different versions of Alfresco which is not going to be a good thing.

Unless you plan to cluster the 2 servers (and upgrade the version on the windows server) you would need to create a new database for the new Alfresco 4.2e instance, copy the old alfresco database into the new one, then upgrade this instance.  It sounds like the problem you are facing is Alfresco 4.0d on Windows is not trying to communicate with a 4.2e version of the database.

Regards,
Colin.