nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Alfresco Database storage

itsmanish

Hi,
    I installed alfresco on my machine using MySql database,
    I want to know where the documents I upload in alfresco is going to be   stored.
    Is it store in encripted format or in which tables it is stored ?

Find more posts tagged with

Comments

dbaran

Hello,

The Alfresco repository uses database and the filesystem to store respectively data about document and the document itself.
So, your upload documents can be found in the content store directory set by the dir.root property (defined by default as alf_data directory somewhere in tomcat installation, see Repository configuration wiki page to change it)
All uploaded documents are renamed using unique id of the node in the database (uid.bin), but content is not encrypted.

David

itsmanish

Hi David,
Thanks for the information I got the uploaded file in alf_data dir

I want to know some more things like :-
1. In which database table this unique id of the node is stored. Database would have information about this unique Id.
2. In which table matadata information of document is stored.
3. alf_data dir has content store folder and it has sub folders named numbers like 2007, 15,7 etc How I can know that in which folder which uploaded file is stored.

dbaran

Hi,

1. In which database table this unique id of the node is stored. Database would have information about this unique Id.

Check 'uuid' column in 'alf_node' table, where type_qname = '{http://www.alfresco.org/model/content/1.0}content'

2. In which table matadata information of document is stored.

In 'alf_node_properties' table

3. alf_data dir has content store folder and it has sub folders named numbers like 2007, 15,7 etc How I can know that in which folder which uploaded file is stored.

Sorry, I've no idea about that… :?

David

itsmanish

Ok no probs anyway thanks for info

frederick

Here is a short comment on the file structure:

http://forums.alfresco.com/viewtopic.php?t=6393

Note that at the time the content is stored, a new GUID is generated for the "***.bin" filename.
This GUID is not related to the GUID of the node owning the content (but the node does keep track of the contentUrl).