We are not able to get the filestore functionality to work or gain access straight to the filestore directory using ftp. Also the filestore directories to not show up under Knowledge > Configuration > Document Management > Directories.
We are using v7 nightly build 22.07.2013 on Ubuntu 13.04 with PostgreSQL 9.2.4. We want to migrate to filestore for storing our attachments.
We have followed the various threads in the forum how to do this, although there was no one thread that explained exactly the process how to do this without something being open to interpretation or requiring other knowledge.
We created the directory /opt/openerp/filestore/test (test is the name of our database) Owner and group of filestore and test are openerp:openerp with octal permissions set at 775
We added under Settings > Technical > Parameters > System Parameters the Key: ir_attachment.location and gave it a Value of file:///opt/openerp/filestore/test (it was not clear if this was exactly the correct way to define the Value or why it should be this way)
In addition we added to the /etc/openerp-server.conf file the following lines for ftp (we were not sure if this was really necessary): ftp_server_host = localhost , ftp_server_port = 8021
vsftpd was setup for port 8021 and works.
We then restarted the machine.
Under Knowledge > Documents > Shared Repository (FTP) we get an ftp:// link to email@example.com:8021/test. <clicking> on Browse does not help as: a) the test directory is not under home in Ubuntu but under /opt/openerp/filestore/test b) using OpenERP credentials the FTP browser does not work, we have to enter a user/password of Ubuntu then it works.
Is there a way around a) so that the FTP browser OpenERP Link goes straight to the correct directory in filestore? Surely for b) it cannot be that OpenERP requires the same username also as a Ubuntu account aswell as an OpenERP user??
Under Knowledge > Configuration > Document Management > Directories , it is not possible to see our filestore or any of its subdirectories. It is like we never set the ir_attachment.location parameter.
We must be missing something basic here.
We presume that once the filestore becomes the default location that absolutely every new document will be saved in the filestore even for files newly stored in the existing directories that up to now stored the files in the database - is that the case?
Any help or tips of what we are forgetting would be much appreciated, thanks.
I think you had seen https://accounts.openerp.com/forum/Help-1/question/529
But there is an missing information : you must put your folder (containing files) in server/openerp/ folder (inside the source code server folder)
you can choose the name of this folder but define it in openerp like in 'where-are-document-attachments-stored' response
The disadvantage is you have binary datas in source code folder.
Solution : use symbolic link and that's all
Note you have to check writing file grants
I hope i could help
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/25/13, 9:00 AM|
|Seen: 6945 times|
|Last updated: 6/30/16, 10:21 AM|