CKAN common errors

These are two errors and the solutions encountered installing CKAN:

1. Upload error: An Error occurred while sending the job: 500 Server Error: INTERNAL SERVER ERROR

with this error in datapusher.error.log:
OperationalError: (OperationalError) attempt to write a readonly database u’INSERT INTO jobs …

The solution is:

check the configuration parameter SQLALCHEMY_DATABASE_URI in datapusher_settings.py, it should point to a file where the webserver has permissions to write

2. Error: Process completed but unable to post to result_url

with this error in datapusher.error.log:
ConnectionError: (‘Connection aborted.’, error(111, ‘Connection refused’))

The solution is:

check the parameter ckan.site_url in development.ini/production.ini, it should have the correct port and host:

ckan.site_url=http://{ckan_host}:{ckan_port}