Cannot login after migrate Alfresco to new server

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

jack_chuong

Hi all,
I have Alfresco Community 5.0.b on Centos 6.4 64 bit, installation directory : /opt/alfresco-5.0.b , my Alfresco use MySQL 5.1.67 database . Here is my alfresco-global.properties :

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

dir.root=/opt/alfresco-5.0.b/alf_data

alfresco.context=alfresco
alfresco.host=192.168.0.8
alfresco.port=8080
alfresco.protocol=http

share.context=share
share.host=192.168.0.8
share.port=8080
share.protocol=http

### Database connection Mysql server ##
db.name=alfresco
db.username=alfresco
db.password=******
db.host=192.168.0.8
db.port=3306
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=yes&characterEncoding=UTF-8

# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
db.pool.max=275
db.pool.validate.query=SELECT 1

# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN

### FTP Server Configuration ###
ftp.port=2121

### RMI registry port for JMX ###
alfresco.rmi.services.port=50500

### External executable locations ###
ooo.exe=/opt/alfresco-5.0.b/libreoffice/program/soffice
ooo.enabled=true
ooo.port=8100
img.root=/opt/alfresco-5.0.b/common
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
swf.exe=/opt/alfresco-5.0.b/common/bin/pdf2swf
swf.languagedir=/opt/alfresco-5.0.b/common/japanese

jodconverter.enabled=false
jodconverter.officeHome=/opt/alfresco-5.0.b/libreoffice
jodconverter.portNumbers=8100

# Determines if the JBPM engine is enabled
system.workflow.engine.jbpm.enabled=true
system.workflow.engine.jbpm.definitions.visible=true

### Initial admin password ###
alfresco_user_store.adminpassword=c8cb1a868ca479248a463cb165fb6011


### License location ###
dir.license.external=/opt/alfresco-5.0.b

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.port.ssl=8443

### BPM Engine ###
system.workflow.engine.jbpm.enabled=false

### Allow extended ResultSet processing
security.anyDenyDenies=fals
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Now I want to move Alfresco to new server Centos 7.0 64 bit , with mariadb-5.5.41 . What should I do ?
I followed article here http://docs.alfresco.com/4.1/concepts/migrating-servers.html but it didn't work.
I tried:
1. Stop Alfresco on old server
2. copy entire /opt/alfresco-5.0.b folder from old server to new server
3. dump and import alfresco mysql database from old server to new server
4. Change ip address of alfresco.host , share.host , db.host in alfresco-global.properties to new server ip address
When I start Alfresco and try login http://192.168.7.20:8080/share , it says "Your authentication details have not been recognized or Alfresco may not be available at this time."

Thanks for your help.

jack_chuong

I think the reason because Alfresco cannot connect to mariadb, after install a fresh Alfresco on new server i figured out that there is no table created in alfresco database.
I download mariadb-java-client-1.1.8.jar and put it in /opt/alfresco-5.0.b/tomcat/lib , how I edit db.driver & db.url in alfresco-global.properties to make it work ?