Unable to login after migrating database

joshb — Mon, 09 May 2016 17:32:43 GMT

I've installed Alfresco Community locally, then switched to my own installation of PostgreSQL. Upon attempting to login, I get the error "Your authentication details have not been recognized or Alfresco may not be available at this time." at /share, and a 404 at /alfresco.Can anybody help me figure

Re: Unable to login after migrating database

jpotts — Mon, 09 May 2016 20:50:38 GMT

If you installed Alfresco and started it up, then shut it down and switched the database, but you did not completely wipe out your content store, you've effectively created a corrupt repository. That's because your new database is completely empty but your content store has files in it, which is bad.

Try shutting down and removing everything under alf_data, making sure you've created your database in postgresql and that it is empty, then restart.

Also, don't use /share as an indicator of whether or not Alfresco is working. Use /alfresco. Once that responds without error then you should be able to use /share to log in. When /alfresco returns an error then you need to look in $TOMCAT_HOME/logs/catalina.out to figure out why.

Re: Unable to login after migrating database

jpotts — Mon, 09 May 2016 20:53:22 GMT

Also check to see that the user running Alfresco has read/write access to your content store, which according to your props file is /srv/alfresco/alf_data.

Jeff

Re: Unable to login after migrating database

joshb — Tue, 10 May 2016 12:47:00 GMT

Removing everything under alf_data causes Tomcat to be unable to start. Should I be removing particular files?

EDIT: Here is my catalina.out:


INFO: Deploying configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\alfresco.xml
May 10, 2016 8:45:38 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Error listenerStart
May 10, 2016 8:45:38 AM org.apache.catalina.core.StandardContext startInternal
SEVERE: Context [/alfresco] startup failed due to previous errors
May 10, 2016 8:45:38 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deployment of configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\alfresco.xml has finished in 76,041 ms
May 10, 2016 8:45:38 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\share.xml
May 10, 2016 8:46:22 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deployment of configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\share.xml has finished in 44,136 ms
May 10, 2016 8:46:22 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\solr4.xml
May 10, 2016 8:46:22 AM org.apache.catalina.startup.SetContextPropertiesRule begin
WARNING: [SetContextPropertiesRule]{Context} Setting property 'debug' to '0' did not find a matching property.
May 10, 2016 8:46:47 AM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deployment of configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\solr4.xml has finished in 25,070 ms
May 10, 2016 8:46:47 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\alfresco-community\tomcat\webapps\ROOT.war
May 10, 2016 8:46:47 AM org.apache.catalina.startup.SetContextPropertiesRule begin
WARNING: [SetContextPropertiesRule]{Context} Setting property 'debug' to '100' did not find a matching property.
May 10, 2016 8:46:48 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive C:\alfresco-community\tomcat\webapps\ROOT.war has finished in 381 ms
May 10, 2016 8:46:48 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive C:\alfresco-community\tomcat\webapps\_vti_bin.war
May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive C:\alfresco-community\tomcat\webapps\_vti_bin.war has finished in 900 ms
May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\alfresco-community\tomcat\webapps\host-manager
May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\alfresco-community\tomcat\webapps\host-manager has finished in 194 ms
May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\alfresco-community\tomcat\webapps\manager
May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\alfresco-community\tomcat\webapps\manager has finished in 202 ms
May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8443"]
May 10, 2016 8:46:49 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 147444 ms
May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["http-apr-8080"]
May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["ajp-apr-8009"]
May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol pause
INFO: Pausing ProtocolHandler ["http-bio-8443"]
May 10, 2016 8:46:49 AM org.apache.catalina.core.StandardService stopInternal
INFO: Stopping service Catalina
May 10, 2016 8:46:50 AM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["http-apr-8080"]
May 10, 2016 8:46:50 AM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["ajp-apr-8009"]
May 10, 2016 8:46:50 AM org.apache.coyote.AbstractProtocol stop
INFO: Stopping ProtocolHandler ["http-bio-8443"]
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Unable to login after migrating database

joshb — Tue, 10 May 2016 17:14:41 GMT

I ended up simply reinstalling alfresco without the built in PostgreSQL module and setting it up directly, it worked fine.

topic Re: Unable to login after migrating database in Alfresco Archive

Unable to login after migrating database

Re: Unable to login after migrating database

Re: Unable to login after migrating database

Re: Unable to login after migrating database

Re: Unable to login after migrating database