3.4.d to 4.0.d Upgrade Woes with LDAP...

[zanity84]

Hello everybody!

I have been adamantly searching this knowledge base as well as other sites looking for the methodology of upgrading from 3.4.d to 4.0.d that will work in our system. I've followed this post https://forums.alfresco.com/en/viewtopic.php?f=8&t=45911, with some slight tweaks of what I've seen on Alfresco's documentation area. The main requirement for this upgrade is to keep intact the MYSQL database and the contentstore. Currently, we are running the ldap-ad subsystem to authenticate against our AD server.  Below is a list of items I've done and where I'm running into trouble.

-Installed Centos 6.3 on a VM
-Installed the 4.0.d alfresco, clean, skipped the postgresql install
-Installed mysql-server and created a new blank alfresco database
-Mysqldump of 3.4.d database and imported it into the blank alfresco database

Here's where it gets troublesome:

-Backed up entire 3.4.d alf_data folder in hopes that I could copy the content store into the 4.0.d one
-I'm not sure what all data the database keeps with regard to users, but the LDAP-AD subsystem is installed on the 3.4.d
       -I tried two ways to implement the LDAP-AD subsystem into 4.0.d
               1) Mirroring the alfresco-global.properties from 3.4.d onto the new system (It used passthru with ldap to our AD servers), and this erred when attempting to authenticate using my AD credentials
               2) Commented out number 1's configuration and just added the authentication chain to ldap1:ldap-ad and added the ldap-ad-configuration in the Authentication folder, still no luck.

I'm going to try this: http://kksays.wordpress.com/2011/12/16/upgrade-alfresco-from-3-4-to-4-0x/, just to see if I can get all the remaining data correctly migrated. I want to make sure though,

Will I be able to see the migrated data in the contentstore and database BEFORE I try configuring LDAP? For instance, can I log in with the "admin" account and see the content in the share folder? If so, I'll do that first and then try troubleshooting the LDAP authentication. Thanks!

[jpotts]

LDAP is just for authentication (and, optionally, syncing users and groups) so you should definitely be able to move your database and content store over, validate that everything came over okay, and then get LDAP working.

Jeff

[zanity84]

Thank you for the response,

I kind of figured that this was the case, but I'm glad it's confirmed. I guess my problem lies in the migration in general. I'm looking the logs, and the only one that I think is causing problems when trying to log in is "unable to retrieve license from server 404" error alfresco.log. I'm not sure what's causing this error; I tried disabling the firewall temporarily to see if it was that type of issue, but I received the same error regardless.

When opening a browser after restarting the Alfresco service, the login screen automatically generates the error "The remote server may be unavailable or your authentication details have not been recognized" before even trying to log in. I'm thinking this might be why it's not indexing. Thanks!

[jpotts]

Can you try logging in to /alfresco instead of /share, just to verify that the repository is okay? Also, please check the alfresco log for any messages and include those here within

‍

tags.

Last, I think if you followed the directions in that other blog post you've probably already done this, but just to make sure, make sure you've disabled Solr and are using Lucene instead. After the migration you can switch to Solr if you'd like. When you do, you'll need to address the expired SSL cert problem.

Jeff

[zanity84]

Thank you,

Indeed, I had commented out the solr configuration part and made sure Lucene was put in the properties file. As I was working today, I noticed what may be causing my problems. I'll have you guys confirm this, but I noticed that the requirements of Alfresco 4.0 included having Mysql 5.5 installed. I've been using 5.1.61 from installing via "yum install mysql-server." Is it possible that I am having compatibility issues with Alfresco being able to contact the mysql databse because of the different versions?

[zanity84]

Hello again,

I was able to update to mysql 5.5 and import, but I'm encountering the same error. I tried logging into the /alfresco site, but it gives me a 404 error "the requested resource is not available." I have the mysql connector in the tomcat/lib folder. I'm not sure what else to do at this point.

[jpotts]

Seeing a 404 error on /alfresco most likely means there was an error of some sort when the repository tried to start up. Can you check $TOMCAT_HOME/logs/catalina.out for any exceptions or other error messages that might be in there?

Jeff