problems loading a xls file: permission denied

[Ivan Marchesini]

Dear formhub developers,

I apologize for writing also in this list (I have already posted in the user list) but could be this is a problem related to the developers list.

 

I'm becoming crazy trying to correctly configure formhub to work with apache.

I have installed formhub exploiting this page: 

https://github.com/SEL-Columbia/formhub/blob/master/docs/install/README.md

Then I was able to configure mod_wsgi to deploy formhub with apache2 .

I have simply configured the wsgi.py file:

import django.core.handlers.wsgi
import os
import sys

sys.path.insert(0, '/home/fhuser/formhub')
os.environ["DJANGO_SETTINGS_MODULE"] = "formhub.preset.default_settings"
application = django.core.handlers.wsgi.WSGIHandler()

and I have prepared a virtual host like this:

<VirtualHost *:80>
 WSGIScriptAlias / /home/fhuser/formhub/formhub/wsgi.py
<Directory /home/fhuser/formhub/formhub>
<Files wsgi.py>
Require all granted
</Files>
</Directory>
Alias /static /home/fhuser/formhub/static/

<Directory /home/fhuser/formhub/static/>
Options FollowSymLinks
AllowOverride AuthConfig Limit FileInfo
Require all granted
</Directory>
ErrorLog /var/log/apache2/error-formhub.log

LogLevel debug
CustomLog /var/log/apache2/access-formhub.log combined
</VirtualHost>

The formhub application correctly answer at the apache 80 port.

User can correctly register (I set up a smtp gmail account) and should be able to uplaod a xls form.

The problem is here: when they try to upload the file something happen and I receive:

[Errno 13] Permission denied: '/USERNAME'

After a while (a lot of unlucky tests) I have altered the linux permission to 777 to all files and I have also set www-data:www-data as the owner of all the files and folders starting from /home and going down to the formhub folders.

Nothing!!!  the permission denied error persists.

I have also tried to move the application to a native folder for apache: 

mkdir /var/www/html/formhub

cp -r /home/fhuser/formhub  /var/www/html/formhub

And I have chenged the wsgi and the virtual host accordingly.

Nothing!!!  the error is there!

Obviously using manage.py runserver all is correctly working.

May I ask your help?

Any idea?

thank you very much

Ivan

[Ivan Marchesini]

it was my fault!!

setting MEDIA_ROOT and MEDIA_URL in settings.py solved the problem.

sorry.

Ivan