[ckan-dev] Unable to upload file on CKAN

Wed Oct 15 06:37:15 UTC 2014

Dear Jason,

Thanks for your mail.. Now I am able to GRAN permission to
datastore_default database

Sorry Jason.. I was executing the Grant table permission from outside of
database.

[image: Inline image 1]

After doing this Once again I checked the ckan_log

This log generated after clicking on Additional Info Button..
-----------------------
File
"/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 300, in do_rollback
[Wed Oct 15 11:56:09 2014] [error] connection.rollback()
[Wed Oct 15 11:56:09 2014] [error] InterfaceError: (InterfaceError)
connection already closed None None
----------------------------------------------------------------------------

I have already re-started the apache and postgresql services.

What may be the issue ?...Please help me

Regards,

Bhavesh

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

> You need to look at the information available to you and *think *about it.
> All of the info needed is in the screen shot you sent.
>
> Look at your second image/screenshot.
> 3rd line from the bottom.
> Then look up about 16 lines from the bottom - it tells you the name of the
> data base you are connected to,
>
> Taken together this  shows the table _table_metadata exists in the
> datastore_default database.
> So try executing the grant in the database where the table exists, i.e. in
> the datastore_default database
>
> Jason
>
> On 15 October 2014 14:29, Library IT <libraryit at iimahd.ernet.in> wrote:
>
>> 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
>>>
>>
>>
>
>
> --
> 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/90da7edc/attachment-0003.html>
-------------- 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/90da7edc/attachment-0015.png>
-------------- 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/90da7edc/attachment-0016.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/90da7edc/attachment-0017.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 60972 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141015/90da7edc/attachment-0018.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/90da7edc/attachment-0019.png>