Can't login after upgrade
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2016 03:51 AM
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
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!
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

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!
Labels:
- Labels:
-
Archive
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-10-2016 02:21 PM
Are there any error messages in the logs?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-11-2016 02:35 AM
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?
I searched through following:
alfresco.log
share.log
catalina.out
postgresql.log
Any other log I should inspect?

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-04-2016 08:42 AM
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-06-2016 10:43 AM
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!
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!

