cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to login after migrating database

joshb
Champ in-the-making
Champ in-the-making
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 out what is going wrong?

EDIT: At http://127.0.0.1:8080/ I get the following:

Cannot find Alfresco Repository on this server. (Does this application have access to alfresco-global.properties? Does this application have cross-context permissions?)

Here is my alfresco-global.properties:

###############################
## Common Alfresco Properties #
###############################

#
# Sample custom content and index data location
#
dir.root=/srv/alfresco/alf_data
#dir.keystore=${dir.root}/keystore

#
# Sample database connection properties
#
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.host=localhost
db.port=5432
db.pool.max=40

#
# External locations
#————-
#ooo.exe=soffice
#ooo.enabled=false
#jodconverter.officeHome=./OpenOffice.org
#jodconverter.portNumbers=8101
#jodconverter.enabled=true
#img.root=./ImageMagick

#
# Windows specific environment variables (should not be set on unix) for ImageMagick
#
#img.coders=${img.root}/modules/coders
#img.config=${img.root}/config
#img.gslib=${img.root}/lib

#
# Property to control whether schema updates are performed automatically.
# Updates must be enabled during upgrades as, apart from the static upgrade scripts,
# there are also auto-generated update scripts that will need to be executed.  After
# upgrading to a new version, this can be disabled.
#
#db.schema.update=true

#
# MySQL connection
#
#db.driver=org.gjt.mm.mysql.Driver
#db.url=jdbc:mysql://localhost/alfresco?useUnicode=yes&characterEncoding=UTF-8

#
# Oracle connection
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbcSmiley Surprisedracle:thin:@localhost:1521:alfresco

#
# SQLServer connection
# Requires jTDS driver version 1.2.5 and SNAPSHOT isolation mode
# Enable TCP protocol on fixed port 1433
# Prepare the database with:
# ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;
#
#db.driver=net.sourceforge.jtds.jdbc.Driver
#db.url=jdbc:jtds:sqlserver://localhost:1433/alfresco
#db.txn.isolation=4096

#
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)
#
db.driver=org.postgresql.Driver
db.url=jdbcSmiley Tongueostgresql://localhost:5432/alfresco

#
# DB2 connection
#
#db.driver=com.ibm.db2.jcc.DB2Driver
#db.url=jdbc:db2://localhost:50000/alfresco:retrieveMessagesFromServerOnGetMessage=true;
#
# When schema is used which does not match DB2 username then currentSchema and hibernate.default_schema should be set
#db.url=jdbc:db2://localhost:50000/alfresco:retrieveMessagesFromServerOnGetMessage=true;currentSchema=${hibernate.default_schema};
#hibernate.default_schema=SAMPLE_SCHEMA

#
# Index Recovery Mode
#————-
#index.recovery.mode=AUTO

#
# Outbound Email Configuration
#————-
#mail.host=
#mail.port=25
#mail.username=anonymous
#mail.password=
#mail.encoding=UTF-8
#mail.from.default=alfresco@alfresco.org
#mail.smtp.auth=false

#
# Alfresco Email Service and Email Server
#————-

# Enable/Disable the inbound email service.  The service could be used by processes other than
# the Email Server (e.g. direct RMI access) so this flag is independent of the Email Service.
#————-
#email.inbound.enabled=true

# Email Server properties
#————-
#email.server.enabled=true
#email.server.port=25
#email.server.domain=alfresco.com
#email.inbound.unknownUser=anonymous

# A comma separated list of email REGEX patterns of allowed senders.
# If there are any values in the list then all sender email addresses
# must match. For example:
#   .*\@alfresco\.com, .*\@alfresco\.org
# Allow anyone:
#————-
#email.server.allowed.senders=.*

#
# The default authentication chain
# To configure external authentication subsystems see:
# http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems
#————-
#authentication.chain=alfrescoNtlm1:alfrescoNtlm

#
# URL Generation Parameters (The ${localname} token is replaced by the local server name)
#————-
#alfresco.context=alfresco
#alfresco.host=${localname}
#alfresco.port=8080
#alfresco.protocol=http
#
#share.context=share
#share.host=${localname}
#share.port=8080
#share.protocol=http

#imap.server.enabled=true
#imap.server.port=143
#imap.server.host=localhost

# Default value of alfresco.rmi.services.host is 0.0.0.0 which means 'listen on all adapters'.
# This allows connections to JMX both remotely and locally.
#
alfresco.rmi.services.host=0.0.0.0

#
#
# Assign individual ports for each service for best performance
# or run several services on the same port. You can even run everything on 50500 if needed.
#
# Select 0 to use a random unused port.
#
#monitor.rmi.service.port=50508

#Smart Folders Config Properties

smart.folders.enabled=true
smart.folders.model=alfresco/model/smartfolder-model.xml
smart.folders.model.labels=alfresco/messages/smartfolder-model

#Smart reference config

#smart.reference.classpath.hash=${smart.folders.config.vanilla.processor.classpath}->1,${smart.folders.config.system.templates.classpath}->2

#Smart store config

#Company home relative download associations of smart entries
#smart.download.associations.folder=${spaces.dictionary.childname}/${spaces.smartdownloads.childname}

#Generic virtualization methods config

#Vanilla JSON templates javascript processor classpath. A java script processor used to
#covert JSON templates to internal smart folder definitions.

#smart.folders.config.vanilla.processor.classpath=/org/alfresco/repo/virtual/node/vanilla.js

#System virtualization method config

#System virtualization method aspect.
#smart.folders.config.system.aspect=smf:systemConfigSmartFolder
#System virtualization method aspect defined template location property.
#smart.folders.config.system.aspect.template.location.property=smf:system-template-location
#Classpath to be explored for *.json entries defining system templates.
#smart.folders.config.system.templates.classpath=/org/alfresco/repo/virtual/node
#A company home relative name or qname path location of repository system templates.
#smart.folders.config.system.templates.path=${spaces.dictionary.childname}/${spaces.smartfolders.childname}
#Content sub type of repository system templates.
#smart.folders.config.system.templates.template.type=smf:smartFolderTemplate

#Custom virtualization method config

#Custom virtualization method aspect.
#smart.folders.config.custom.aspect=smf:customConfigSmartFolder
#Custom virtualization method aspect template content association.
#smart.folders.config.custom.aspect.template.association=smf:custom-template-association


#Type virtualization method config

#A company home relative name or qname path location of the type mapped templates.
#smart.folders.config.type.templates.path=${spaces.dictionary.childname}/${spaces.smartfolders.childname}
#Type and aspect qname regular expression filter.
#smart.folders.config.type.templates.qname.filter=none
4 REPLIES 4

jpotts
World-Class Innovator
World-Class Innovator
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.

joshb
Champ in-the-making
Champ in-the-making
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"]

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

jpotts
World-Class Innovator
World-Class Innovator
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