cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Users when Importing Alfresco Repository

lnagra
Champ in-the-making
Champ in-the-making
Hi,

We're using Alfresco 1.1

We wish to reuse a standard set of test data (documents + metadata) for every developer and between versions.

To export the data, I attempted to back up the source alf_data and performed a mysql dump of the alfresco database.

The target is a clean deployment of Alfresco with no documents or added users. I then reversed the export process for the import.

Copied across the backed up alf_data
and loaded the mysql dump into the target database

Searching and retrieving documents appears to work without a problem.
Users do not seem to be transferred across to the target database however.

e.g.
using http://localhost:8080/alfresco/faces/jsp/users/users.jsp to view the list of users only displays the default Admin user and we get error occuring on create user or delete user.

If you then log out and try to login again with the admin user, the following error is recieved:

HTTP Status 500 -type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exceptionorg.alfresco.repo.security.authentication.AuthenticationException: Could not find user by userName: admin   org.alfresco.repo.security.authentication.AbstractAuthenticationComponent.setCurrentUser(AbstractAuthenticationComponent.java:84)   org.alfresco.repo.security.authentication.AuthenticationServiceImpl.validate(AuthenticationServiceImpl.java:111)   sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source)   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   java.lang.reflect.Method.invoke(Method.java:585)   org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)   org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)   org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)   $Proxy19.validate(Unknown Source)   org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:66)   org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:67)note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It would appear this is because the user information becomes out of sync when transferring data.

Is it possible to either:

    Cleanly transfer users? OR
    Isolate users from being affected by the import process?

I appreciate that this will be something that is looked at in Alfresco 1.3, but our development effectiveness is currently hindered by not being able to quickly establish a test set of data to work with.

Kind Regards,

Lakhdip
1 REPLY 1

davidc
Star Contributor
Star Contributor
If you performed a full database export/import then users will be transferred.  Ensure your repository.properties on your destination alfresco point to your new imported database and copied alf_data directory.