topic Unable to login after migrating database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296540#M249670 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Can anybody help me figure out what is going wrong?</SPAN><BR /><BR /><SPAN>EDIT: At </SPAN><A href="http://127.0.0.1:8080/" rel="nofollow noopener noreferrer">http://127.0.0.1:8080/</A><SPAN> I get the following:</SPAN><BR /><BR /><SPAN>Cannot find Alfresco Repository on this server. (Does this application have access to alfresco-global.properties? Does this application have cross-context permissions?)</SPAN><BR /><BR /><SPAN>Here is my alfresco-global.properties:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">###############################<BR />## Common Alfresco Properties #<BR />###############################<BR /><BR />#<BR /># Sample custom content and index data location<BR />#<BR />dir.root=/srv/alfresco/alf_data<BR />#dir.keystore=${dir.root}/keystore<BR /><BR />#<BR /># Sample database connection properties<BR />#<BR />db.username=alfresco<BR />db.password=alfresco<BR />db.name=alfresco<BR />db.host=localhost<BR />db.port=5432<BR />db.pool.max=40<BR /><BR />#<BR /># External locations<BR />#————-<BR />#ooo.exe=soffice<BR />#ooo.enabled=false<BR />#jodconverter.officeHome=./OpenOffice.org<BR />#jodconverter.portNumbers=8101<BR />#jodconverter.enabled=true<BR />#img.root=./ImageMagick<BR /><BR />#<BR /># Windows specific environment variables (should not be set on unix) for ImageMagick<BR />#<BR />#img.coders=${img.root}/modules/coders<BR />#img.config=${img.root}/config<BR />#img.gslib=${img.root}/lib<BR /><BR />#<BR /># Property to control whether schema updates are performed automatically.<BR /># Updates must be enabled during upgrades as, apart from the static upgrade scripts,<BR /># there are also auto-generated update scripts that will need to be executed.&nbsp; After<BR /># upgrading to a new version, this can be disabled.<BR />#<BR />#db.schema.update=true<BR /><BR />#<BR /># MySQL connection<BR />#<BR />#db.driver=org.gjt.mm.mysql.Driver<BR />#db.url=jdbc:mysql://localhost/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8<BR /><BR />#<BR /># Oracle connection<BR />#<BR />#db.driver=oracle.jdbc.OracleDriver<BR />#db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@localhost:1521:alfresco<BR /><BR />#<BR /># SQLServer connection<BR /># Requires jTDS driver version 1.2.5 and SNAPSHOT isolation mode<BR /># Enable TCP protocol on fixed port 1433<BR /># Prepare the database with:<BR /># ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON; <BR />#<BR />#db.driver=net.sourceforge.jtds.jdbc.Driver<BR />#db.url=jdbc:jtds:sqlserver://localhost:1433/alfresco<BR />#db.txn.isolation=4096<BR /><BR />#<BR /># PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)<BR />#<BR />db.driver=org.postgresql.Driver<BR />db.url=jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/alfresco<BR /><BR />#<BR /># DB2 connection<BR />#<BR />#db.driver=com.ibm.db2.jcc.DB2Driver<BR />#db.url=jdbc:db2://localhost:50000/alfresco:retrieveMessagesFromServerOnGetMessage=true;<BR />#<BR /># When schema is used which does not match DB2 username then currentSchema and hibernate.default_schema should be set<BR />#db.url=jdbc:db2://localhost:50000/alfresco:retrieveMessagesFromServerOnGetMessage=true;currentSchema=${hibernate.default_schema};<BR />#hibernate.default_schema=SAMPLE_SCHEMA<BR /><BR />#<BR /># Index Recovery Mode<BR />#————-<BR />#index.recovery.mode=AUTO<BR /><BR />#<BR /># Outbound Email Configuration<BR />#————-<BR />#mail.host=<BR />#mail.port=25<BR />#mail.username=anonymous<BR />#mail.password=<BR />#mail.encoding=UTF-8<BR />#mail.from.default=alfresco@alfresco.org<BR />#mail.smtp.auth=false<BR /><BR />#<BR /># Alfresco Email Service and Email Server<BR />#————-<BR /><BR /># Enable/Disable the inbound email service.&nbsp; The service could be used by processes other than<BR /># the Email Server (e.g. direct RMI access) so this flag is independent of the Email Service.<BR />#————-<BR />#email.inbound.enabled=true<BR /><BR /># Email Server properties <BR />#————-<BR />#email.server.enabled=true<BR />#email.server.port=25<BR />#email.server.domain=alfresco.com<BR />#email.inbound.unknownUser=anonymous<BR /><BR /># A comma separated list of email REGEX patterns of allowed senders.<BR /># If there are any values in the list then all sender email addresses<BR /># must match. For example:<BR />#&nbsp;&nbsp; .*\@alfresco\.com, .*\@alfresco\.org<BR /># Allow anyone:<BR />#————-<BR />#email.server.allowed.senders=.*<BR /><BR />#<BR /># The default authentication chain<BR /># To configure external authentication subsystems see:<BR /># <A href="http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems</A><BR />#————-<BR />#authentication.chain=alfrescoNtlm1:alfrescoNtlm<BR /><BR />#<BR /># URL Generation Parameters (The ${localname} token is replaced by the local server name)<BR />#————-<BR />#alfresco.context=alfresco<BR />#alfresco.host=${localname}<BR />#alfresco.port=8080<BR />#alfresco.protocol=http<BR />#<BR />#share.context=share<BR />#share.host=${localname}<BR />#share.port=8080<BR />#share.protocol=http<BR /><BR />#imap.server.enabled=true<BR />#imap.server.port=143<BR />#imap.server.host=localhost<BR /><BR /># Default value of alfresco.rmi.services.host is 0.0.0.0 which means 'listen on all adapters'.<BR /># This allows connections to JMX both remotely and locally.<BR />#<BR />alfresco.rmi.services.host=0.0.0.0<BR /><BR />#<BR />#<BR /># Assign individual ports for each service for best performance <BR /># or run several services on the same port. You can even run everything on 50500 if needed.<BR />#<BR /># Select 0 to use a random unused port.<BR /># <BR />#monitor.rmi.service.port=50508<BR /><BR />#Smart Folders Config Properties<BR /><BR />smart.folders.enabled=true<BR />smart.folders.model=alfresco/model/smartfolder-model.xml<BR />smart.folders.model.labels=alfresco/messages/smartfolder-model<BR /><BR />#Smart reference config<BR /><BR />#smart.reference.classpath.hash=${smart.folders.config.vanilla.processor.classpath}-&gt;1,${smart.folders.config.system.templates.classpath}-&gt;2<BR /><BR />#Smart store config<BR /><BR />#Company home relative download associations of smart entries <BR />#smart.download.associations.folder=${spaces.dictionary.childname}/${spaces.smartdownloads.childname}<BR /><BR />#Generic virtualization methods config<BR /><BR />#Vanilla JSON templates javascript processor classpath. A java script processor used to <BR />#covert JSON templates to internal smart folder definitions.<BR /><BR />#smart.folders.config.vanilla.processor.classpath=/org/alfresco/repo/virtual/node/vanilla.js<BR /><BR />#System virtualization method config<BR /><BR />#System virtualization method aspect.<BR />#smart.folders.config.system.aspect=smf:systemConfigSmartFolder<BR />#System virtualization method aspect defined template location property.<BR />#smart.folders.config.system.aspect.template.location.property=smf:system-template-location<BR />#Classpath to be explored for *.json entries defining system templates.<BR />#smart.folders.config.system.templates.classpath=/org/alfresco/repo/virtual/node<BR />#A company home relative name or qname path location of repository system templates.<BR />#smart.folders.config.system.templates.path=${spaces.dictionary.childname}/${spaces.smartfolders.childname}<BR />#Content sub type of repository system templates.<BR />#smart.folders.config.system.templates.template.type=smf:smartFolderTemplate<BR /><BR />#Custom virtualization method config<BR /><BR />#Custom virtualization method aspect.<BR />#smart.folders.config.custom.aspect=smf:customConfigSmartFolder<BR />#Custom virtualization method aspect template content association.<BR />#smart.folders.config.custom.aspect.template.association=smf:custom-template-association<BR /><BR /><BR />#Type virtualization method config<BR /><BR />#A company home relative name or qname path location of the type mapped templates.<BR />#smart.folders.config.type.templates.path=${spaces.dictionary.childname}/${spaces.smartfolders.childname}<BR />#Type and aspect qname regular expression filter. <BR />#smart.folders.config.type.templates.qname.filter=none</BLOCKQUOTE></BODY></HTML> Mon, 09 May 2016 17:32:43 GMT joshb 2016-05-09T17:32:43Z Unable to login after migrating database https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296540#M249670 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 Mon, 09 May 2016 17:32:43 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296540#M249670 joshb 2016-05-09T17:32:43Z Re: Unable to login after migrating database https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296541#M249671 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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.</SPAN></BODY></HTML> Mon, 09 May 2016 20:50:38 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296541#M249671 jpotts 2016-05-09T20:50:38Z Re: Unable to login after migrating database https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296542#M249672 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Mon, 09 May 2016 20:53:22 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296542#M249672 jpotts 2016-05-09T20:53:22Z Re: Unable to login after migrating database https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296543#M249673 <HTML><HEAD></HEAD><BODY><SPAN>Removing everything under alf_data causes Tomcat to be unable to start. Should I be removing particular files?</SPAN><BR /><BR /><SPAN>EDIT: Here is my catalina.out:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />INFO: Deploying configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\alfresco.xml<BR />May 10, 2016 8:45:38 AM org.apache.catalina.core.StandardContext startInternal<BR />SEVERE: Error listenerStart<BR />May 10, 2016 8:45:38 AM org.apache.catalina.core.StandardContext startInternal<BR />SEVERE: Context [/alfresco] startup failed due to previous errors<BR />May 10, 2016 8:45:38 AM org.apache.catalina.startup.HostConfig deployDescriptor<BR />INFO: Deployment of configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\alfresco.xml has finished in 76,041 ms<BR />May 10, 2016 8:45:38 AM org.apache.catalina.startup.HostConfig deployDescriptor<BR />INFO: Deploying configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\share.xml<BR />May 10, 2016 8:46:22 AM org.apache.catalina.startup.HostConfig deployDescriptor<BR />INFO: Deployment of configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\share.xml has finished in 44,136 ms<BR />May 10, 2016 8:46:22 AM org.apache.catalina.startup.HostConfig deployDescriptor<BR />INFO: Deploying configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\solr4.xml<BR />May 10, 2016 8:46:22 AM org.apache.catalina.startup.SetContextPropertiesRule begin<BR />WARNING: [SetContextPropertiesRule]{Context} Setting property 'debug' to '0' did not find a matching property.<BR />May 10, 2016 8:46:47 AM org.apache.catalina.startup.HostConfig deployDescriptor<BR />INFO: Deployment of configuration descriptor C:\alfresco-community\tomcat\conf\Catalina\localhost\solr4.xml has finished in 25,070 ms<BR />May 10, 2016 8:46:47 AM org.apache.catalina.startup.HostConfig deployWAR<BR />INFO: Deploying web application archive C:\alfresco-community\tomcat\webapps\ROOT.war<BR />May 10, 2016 8:46:47 AM org.apache.catalina.startup.SetContextPropertiesRule begin<BR />WARNING: [SetContextPropertiesRule]{Context} Setting property 'debug' to '100' did not find a matching property.<BR />May 10, 2016 8:46:48 AM org.apache.catalina.startup.HostConfig deployWAR<BR />INFO: Deployment of web application archive C:\alfresco-community\tomcat\webapps\ROOT.war has finished in 381 ms<BR />May 10, 2016 8:46:48 AM org.apache.catalina.startup.HostConfig deployWAR<BR />INFO: Deploying web application archive C:\alfresco-community\tomcat\webapps\_vti_bin.war<BR />May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployWAR<BR />INFO: Deployment of web application archive C:\alfresco-community\tomcat\webapps\_vti_bin.war has finished in 900 ms<BR />May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory<BR />INFO: Deploying web application directory C:\alfresco-community\tomcat\webapps\host-manager<BR />May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory<BR />INFO: Deployment of web application directory C:\alfresco-community\tomcat\webapps\host-manager has finished in 194 ms<BR />May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory<BR />INFO: Deploying web application directory C:\alfresco-community\tomcat\webapps\manager<BR />May 10, 2016 8:46:49 AM org.apache.catalina.startup.HostConfig deployDirectory<BR />INFO: Deployment of web application directory C:\alfresco-community\tomcat\webapps\manager has finished in 202 ms<BR />May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol start<BR />INFO: Starting ProtocolHandler ["http-apr-8080"]<BR />May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol start<BR />INFO: Starting ProtocolHandler ["ajp-apr-8009"]<BR />May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol start<BR />INFO: Starting ProtocolHandler ["http-bio-8443"]<BR />May 10, 2016 8:46:49 AM org.apache.catalina.startup.Catalina start<BR />INFO: Server startup in 147444 ms<BR />May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol pause<BR />INFO: Pausing ProtocolHandler ["http-apr-8080"]<BR />May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol pause<BR />INFO: Pausing ProtocolHandler ["ajp-apr-8009"]<BR />May 10, 2016 8:46:49 AM org.apache.coyote.AbstractProtocol pause<BR />INFO: Pausing ProtocolHandler ["http-bio-8443"]<BR />May 10, 2016 8:46:49 AM org.apache.catalina.core.StandardService stopInternal<BR />INFO: Stopping service Catalina<BR />May 10, 2016 8:46:50 AM org.apache.coyote.AbstractProtocol stop<BR />INFO: Stopping ProtocolHandler ["http-apr-8080"]<BR />May 10, 2016 8:46:50 AM org.apache.coyote.AbstractProtocol stop<BR />INFO: Stopping ProtocolHandler ["ajp-apr-8009"]<BR />May 10, 2016 8:46:50 AM org.apache.coyote.AbstractProtocol stop<BR />INFO: Stopping ProtocolHandler ["http-bio-8443"]<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 10 May 2016 12:47:00 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296543#M249673 joshb 2016-05-10T12:47:00Z Re: Unable to login after migrating database https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296544#M249674 <HTML><HEAD></HEAD><BODY><SPAN>I ended up simply reinstalling alfresco without the built in PostgreSQL module and setting it up directly, it worked fine.</SPAN></BODY></HTML> Tue, 10 May 2016 17:14:41 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-login-after-migrating-database/m-p/296544#M249674 joshb 2016-05-10T17:14:41Z