[ckan-dev] datastore: permission denied Schema public

Mon Mar 25 16:28:53 UTC 2013

Hi,

I today installed CKAN 2.1a freshly from master branch (commit 818e60588485938a15f2552e26e2cb2972704643 from 21.03.2013). So far my basic installation works.

But I am not able to activate the datastore plugin. I have set it up according to http://docs.ckan.org/en/latest/datastore-setup.html with "ckanuser" as write-user. Apache gives following error:

#####################
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] mod_wsgi (pid=26913): Target WSGI script '/opt/ckan/pyenv/src/ckan/bin/xxx.de.py' cannot be 
loaded as Python module.
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] mod_wsgi (pid=26913): Exception occurred processing WSGI script '/opt/ckan/pyenv/src/ckan/bin/xxx.de.py'.
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] Traceback (most recent call last):
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/src/ckan/bin/xxx.de.py", line 11, in <module>
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] application = loadapp('config:%s' % config_filepath)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 247, in loadapp
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] return loadobj(APP, uri, name=name, **kw)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 272, in loadobj
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] return context.create()
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 710, in create
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] return self.object_type.invoke(self)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/paste/deploy/loadwsgi.py", line 146, in invoke
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] return fix_call(context.object, context.global_conf, **context.local_conf)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/paste/deploy/util.py", line 56, in fix_call
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] val = callable(*args, **kw)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/src/ckan/ckan/config/middleware.py", line 54, in make_app
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] load_environment(conf, app_conf)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/src/ckan/ckan/config/environment.py", line 349, in load_environment
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] plugin.configure(config)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/src/ckan/ckanext/datastore/plugin.py", line 66, in configure
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] self._check_read_permissions()
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/src/ckan/ckanext/datastore/plugin.py", line 166, in _check_read_permissions
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] read_connection.execute(sql)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] params)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] statement, parameters
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] context)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] context)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] File "/opt/ckan/pyenv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] cursor.execute(statement, parameters)
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] ProgrammingError: (ProgrammingError) FEHLER: keine Berechtigung f\xc3\xbcr Schema public
[Mon Mar 25 17:12:37 2013] [error] [client 192.168.1.3] 'CREATE TABLE public._bar (id INTEGER, name VARCHAR)' {}
#####################

The 2nd line from bottom says "ERROR: no permission for Schema public" (it's in German).

I have set the permissions using all of the three described options (and tested in between). No luck. From my perspective the schema permissions should be fine. Is there something I am missing or is the datastore not fully integrated into the actual master branch?

My system:
openSUSE 12.3
postgresql 9.2.3
Apache 2.2.22
mod_wsgi-3.3

Thanks in advance
Ralf