cancel
Showing results for 
Search instead for 
Did you mean: 

Can't login after upgrade

ms
Champ in-the-making
Champ in-the-making
Hello,

I have a strange error when upgrading 5.0d - > 5.1.
We started on 4.2 (still have the old install in some folder) and upgraded to 5.0.d without issues.

I followed the upgrade procedure:

http://docs.alfresco.com/5.1/tasks/upgrade-process.html

We have a multi tenant setup on 5.0d, but tbh, I don't understand point 6 in that guide since I don't have a "mt" folder anywhere to begin with Smiley Happy
I tried searching for those files but couldn't find them. The wording is also a bit awkward since it says delete but I think I should copy over those files?
Anyway, I don't have 'em on 5.0.d not 5.1.

I did the following to upgrade:
1. Installed in a fresh folder
2. Edited alfresco global properties
3. Restored the postgres DB
4. Copied over contentstores
5. Deleted (to the best of my knowledge) solr indexes (directories are different on sorlr4)

After the upgrade I can log in fine with some users, cannot login with others on the same tenant.
The master admin does not work.

Tried the following with no avail:

http://docs.alfresco.com/5.0/concepts/admin-password.html

Pulled users from 5.0.d install:

SELECT anp1.node_id,
       anp1.qname_id,      
       anp1.string_value      
FROM alf_node_properties anp1 
   INNER JOIN alf_qname aq1 ON aq1.id = anp1.qname_id  
   INNER JOIN alf_node_properties anp2 ON anp2.node_id = anp1.node_id   
   INNER JOIN alf_qname aq2 ON aq2.id = anp2.qname_id                   
WHERE aq1.local_name = 'password'
AND aq2.local_name = 'username'

Row count is different after starting up 5.1 than on 5.0.d
A user is missing that I can actually log in with? He's a tenant site admin, but not global admin.

Thoroughly confused since I know too little of DB schema to draw any useful conclusions.

Halp and thanks in advance!
4 REPLIES 4

art99trash
Star Contributor
Star Contributor
Are there any error messages in the logs?

ms
Champ in-the-making
Champ in-the-making
I have no errors during startup. Also, while trying to log in unsuccessfully, I don't get any errors in logs.

I searched through following:

alfresco.log
share.log
catalina.out
postgresql.log

Any other log I should inspect?

dbthomson
Champ in-the-making
Champ in-the-making
We are using the Enterprise version but had a similar issue when we went from 4.2.4 to 5.1.   The upgrade seemed to work ok but after I shut down alfresco and restarted we weren't able to login with the admin user.   To solve our issue we had to add alfresco.cluster.enabled=false to our alfreco-global.properties file.  Once I restarted with clustering disabled I was able to login fine.

chribu
Champ in-the-making
Champ in-the-making
Hi dbthomson,

i have had the same login-problems after my upgrade from 4.2.e to 5.1 and with your hind it works fine again!
Thanks, you are my hero! Smiley Very Happy