[ckan-dev] Unable to upload file on CKAN

[Library IT]

Thank Jason for your reply.

When I execute the following query as per you suggestion then it show me
ERROR
relation "_table_metadata" does not exist

[image: Inline image 2]

Currently, we have following databases in postgresql

[image: Inline image 1]

we have follow:
http://docs.ckan.org/en/latest/maintaining/installing/install-from-source.html

I think 'datastore_default' database is created but the tables is not
created. Can you please let me know if any step is missing while
installation from our side?

Thanks for your help till now.

Regards,
Bhavesh

On Wed, Oct 15, 2014 at 6:00 AM, Jason Tan <jason.tan at ersa.edu.au> wrote:

> 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/7d0d290c/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 58816 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141015/7d0d290c/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 9518 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141015/7d0d290c/attachment-0013.png>
-------------- 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/7d0d290c/attachment-0014.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/7d0d290c/attachment-0015.png>