Rescue files/data from Alfresco system

[floher]

Hi there,

I am currently facing a serious problem with our alfresco installation. We were using alfresco for a time period of about 2 years. The only feature we made use of was the file storage of alfresco share. Due to different reasons we have to change our system and we are not able to use alfresco any longer. Now I would like to migrate the stored files to our new system.

The problem is that I am not able to Login to Alfresco any longer. I tried to install a plugin called "Bulk export" and since than I was not able to login. Trying to login, I get the famous message of remoteserver not available or wrong login credentials….
Due to the fact that I do only need to export the stored files I am currently looking for a way to export this data without having to put too much effort in reactivating the system itself (which I have already tried for many hours).

So do you see any possibility to extract the files with the help of the database and the content_store directory, without having to set up the whole alfresco system?

[afaust]

Hello,

just a quick question: The problem about login your describing sounds like you've tried with /share. Please try to login to /alfresco which should always work as long as your Alfresco still starts up. From there you are able to browse and export the stored content as well, just in a different UI.

Have you tried deinstalling the "Bulk Export" plugin?

If even your Alfresco Repository server does not start up, you can use the database tables alf_node, alf_child_assoc, alf_qname and alf_node_properties to reconstruct a minimal folder-document hierarchy. Use alf_content_data / alf_content_url to retrieve the actual path of a document in the file content store.

Regards
Axel

[floher]

Hi,

yes I tried to login into /share. But if I try to open /alfresco I get the following message:

type Status report

message /alfresco/

description The requested resource (/alfresco/) is not available.

How can I get /alfresco running, this would be perfectly enough for me. Regarding your second advice, I already thought about recovering my data like this, but I did not manage to get any relation from the tables alf_content_data and alf_content_url to the alf_node tables. The uuids are not really matching and I tried to loop through the alf_data dir and to get for each file the corresponding information of alf_content and alf_node tables but I am missing the relation.

Thank you so far,
best regards, Florian Herborn

[afaust]

Hello,

how to get /alfresco running depends on the kind of errors you receive. If you could post your logfile of Alfresco (alfresco.log / catalina.out) we could take a look and point you in the right direction.

The relation to content can be obtained by associating alf_node with alf_node_properties via id = node_id and associating alf_node_properties with alf_content_data via long_value = id (for those entries where alf_node_properties associated with alf_qname via qname_id = id has a local_name of "content"). Or to express it in SQL

select * from alf_node left join alf_node_properties on alf_node.id = alf_node_properties.node_id left join alf_content_data on alf_node_properties.long_value = alf_content_data.id left join alf_qname as propQName on propQName.id = alf_node_properties.qname_id left join alf_qname as typeQName on typeQName.id = alf_node.type_qname_id left join alf_content_url on alf_content_data.content_url_id = alf_content_url.id where typeQName.local_name = "content" and propQName.local_name = "content";
‍‍‍

Now you obviously still need the name of a file object, but this requires just a simple adjustment…

Regards
Axel

[g_rathod]

Axel is right,
Unless specific error in log file we can't measure the problem you are facing.
First try to up alfresco client instead /share.

Please post your error which is appear in log. (Full log)