[ckan-dev] Unable to upload file on CKAN

Wed Oct 15 00:30:55 UTC 2014

Hi There,

I may have something that might help.
We got errors about the _table_metadata an this is what fixed it for me.

I think the problem is that that table is not created when you do the
install, but at some point at runtime later AND it is not included in the
set_permissions.sql.

ideally it should be created at install time and included in the
set_permissions.sql script or some other script.

Anyway this fixed our _table_metadata problem - it might work for you too.

grant select on _table_metadata to *<your_datastore_readonly_user>*;

You'll need to change the *<your_datastore_readonly_user>* to whatever is
the appropriate postgres user on your system.
If you If you followed the docco here
http://docs.ckan.org/en/latest/maintaining/datastore.html then
*<your_datastore_readonly_user>
*would be *datastore_default.*
Regards
Jason

On 14 October 2014 17:42, Library IT <libraryit at iimahd.ernet.in> wrote:

> Dear Tech team,
>
> We are not able to upload file on Dataset.
>
> It's giving some error
> [ckan.model.modification] (ProgrammingError) permission denied for
> relation _table_metadata
>
> Please check the attached log file for more detail.
>
> While checking log it's seems to be some permission issue on postgresql so
> I try following operations (plz see the below image). but into that the
> role attribute is not shown on ckan_default as well as datastore_default.
>
>
> [image: Inline image 1]
>
> I have confusion on this.
>
> I have also set 777 persmission on datastore folder
>
> /mnt/ckandata
>
> [image: Inline image 2]
>
> Please help me on this.
>
> Thanks,
> Bhavesh
>

-- 
Jason Tan
Data Infrastructure Specialist, eResearch SA

phone: +61 8 8313 2184
Mob: +61 407 268 270
email: jason.tan at ersa.edu.au
web: http://www.ersa.edu.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141015/870d8216/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 71368 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141015/870d8216/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 78024 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141015/870d8216/attachment-0007.png>