[ckan-dev] Setting up DataStore

Sat Oct 6 17:34:11 UTC 2012

Hi Joshua,

You discovered a bug in the installation script. Thank you very much for that. You questions and error descriptions are very useful and help improving the setup a lot.

For now, you can run this command to fix the permissions in your setup:

ALTER DEFAULT PRIVILEGES FOR USER "{writeuser}" IN SCHEMA public
   GRANT SELECT ON TABLES TO "{readonlyuser}";

I'm sorry that you have run into all these issues with the set-up. There are just so many configurations which makes the set-up phase really difficult to test. I hope that you'll enjoy the datastore once it's set up.

Regards,
Dominik

On Oct 5, 2012, at 22:55 , Joshua Tauberer <tauberer+consulting at govtrack.us> wrote:

> On 10/04/2012 03:29 PM, Dominik Moritz wrote:
>> The datastore works with PostgreSQL 9.0 to 9.2. CKAN 2 runs on all distros. The OKFN uses debian based distros for their demos and the datahub.
>> 
> 
> Okay, I've switched to Ubuntu 12.04 which has Postgres 9
> 
> I've gotten through more or less all of the install steps through create-read-only-user. Except I had to create the write user on my own before the create-read-only-user step (e.g. createuser -S -D -R -P ckan_datastore_rw_user), which isn't clear from the documentation.
> 
> But at runtime accessing a resource page (e.g. /dataset/test/resource/GUID) I get:
> 
> ProgrammingError: (ProgrammingError) permission denied for relation _table_metadata
> 'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL' (u'1b34c911-ed48-4563-b638-653132a9a2f1',)
> 
> Seems like the write user lost its access to the datastore table. (I checked that the postgres user can execute that statement OK.) I'm not familiar with Postgres permissions or the DataStore table layout so I don't know what I should do to fix that.
> 
> Thanks.
> 
> (These questions are helpful, right? I don't want to be bugging you if the best thing is for me to just hang tight for a while.)
> 
> -- 
> - Joshua Tauberer
> - http://razor.occams.info
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2726 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20121006/4a8c7a05/attachment-0003.bin>