[ckan-dev] Dataset upload error

Thu Feb 6 09:34:27 UTC 2014

Hi Cliff,

I have a few questions for you that might help us debug your situation a
bit better.
* Does the db user used to connect to the database own the database used
for CKAN?
* Did you create the database using the steps described in the
documentation?
* What version of CKAN are you on?
* Do you have any custom extensions enabled?

Nigel Babu

Developer  |  @nigelbabu <https://twitter.com/nigelbabu>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge

http://okfn.org/  |  @okfn <http://twitter.com/OKFN>  |  OKF on
Facebook<https://www.facebook.com/OKFNetwork> |
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>

 CKAN | http://ckan.org/ | @CKANproject
<http://twitter.com/CKANproject> |the world’s leading open-source data
portal platform

On 5 February 2014 22:44, Cliff Ingham <inghamn at bloomington.in.gov> wrote:

> I am getting a postgresql error when attempting to upload a file for a
> dataset.
>
> (ProgrammingError) permission denied for relation _table_metadata
>
> I have tried the Alter Table command as described from an older email in
> this mailing list:
> https://lists.okfn.org/pipermail/ckan-dev/2012-October/003227.html
>
> ALTER DEFAULT PRIVILEGES FOR USER "{writeuser}" IN SCHEMA public
>    GRANT SELECT ON TABLES TO "{readonlyuser}";
>
> But still, no luck.  I am unfamiliar with Postgres and am not sure where
> the _table_metadata table is. (This is my first use of Postgres, I have
> only use MySQL, Oracle, and MSSql before.)
>
> Here's the full error from the log:
>
> (ProgrammingError) permission denied for relation _table_metadata
>  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
> (u'2bba4af2-95e4-43c4-b555-970d0d59a10d',)
> Traceback (most recent call last):
>   File "/srv/sites/ckan/python_env/src/ckan/ckan/model/modification.py",
> line 79, in notify
>     observer.notify(entity, operation)
>   File
> "/srv/sites/ckan/python_env/src/ckan/ckan/lib/search/__init__.py", line
> 128, in notify
>     {'id': entity.id}),
>   File "/srv/sites/ckan/python_env/src/ckan/ckan/logic/__init__.py",
> line 419, in wrapped
>     result = _action(context, data_dict, **kw)
>   File "/srv/sites/ckan/python_env/src/ckan/ckan/logic/action/get.py",
> line 856, in package_show
>     resource_dict = item.before_show(resource_dict)
>   File
> "/srv/sites/ckan/python_env/src/ckan/ckanext/datastore/plugin.py", line
> 245, in before_show
>     resource_dict['id']
>   File
>
> "/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 1449, in execute
>     params)
>   File
>
> "/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 1628, in _execute_text
>     statement, parameters
>   File
>
> "/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 1698, in _execute_context
>     context)
>   File
>
> "/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 1691, in _execute_context
>     context)
>   File
>
> "/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
> line 331, in do_execute
>     cursor.execute(statement, parameters)
> ProgrammingError: (ProgrammingError) permission denied for relation
> _table_metadata
>  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
> (u'2bba4af2-95e4-43c4-b555-970d0d59a10d',)
> Error - <class 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError)
> permission denied for relation _table_metadata, referer:
>
> http://rogue.bloomington.in.gov/ckan/dataset/new_resource/video-services-franchise-revenue-history
>  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
> (u'2bba4af2-95e4-43c4-b555-970d0d59a10d',), referer:
>
> http://rogue.bloomington.in.gov/ckan/dataset/new_resource/video-services-franchise-revenue-history
> --
> Cliff Ingham
> http://www.ohloh.net/accounts/inghamn
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140206/fa4a3ab1/attachment-0003.html>