[ckan-dev] data store permission problem

Mon May 27 16:49:55 UTC 2013

Hi Don,

On 27 May 2013 18:21, Don Gourley <donald.gourley at gmail.com> wrote:
> What other information would be useful to troubleshoot my "permission denied
> for schema public" problem?

Have you seen my answer to your first Email? Did it help or change
anything? If not, `\l` could help me to debug the problem.

>
> thanks, Don

Cheers,
Dominik

>
>
>> Date: Sat, 25 May 2013 12:54:07 -0400
>> From: Don Gourley <donald.gourley at gmail.com>
>> Subject: [ckan-dev] data store permission problem
>> To: ckan-dev at lists.okfn.org
>> Message-ID:
>>
>> <CABPWEL-pn8pFnNKJqnar2Dy0GpPQ9OSrY8grhoG4R_kkZbjnZw at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>>
>> After getting basic CKAN 2.0 working on CentOS 6, I set up the data store
>> according to the directions at
>> http://docs.ckan.org/en/ckan-2.0/datastore-setup.html
>>
>> When I try to test my installation with this URL:
>>
>> http://localhost/api/3/action/datastore_search?resource_id=_table_metadata
>>
>> I get a 500 server error. In the error log:
>>
>> [Sat May 25 11:47:44 2013] [error] [client 10.12.15.181] Error - <class
>> 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError) permission denied
>> for schema public
>> [Sat May 25 11:47:44 2013] [error] [client 10.12.15.181]  'CREATE TYPE
>> "nested" AS (json json, extra text)' {}
>>
>> The paster set-permissions command ran without error. I had to move CKAN
>> from PostgreSQL 8.4 to 9.2, and dumped and loaded the ckan database to do
>> that, but the data store database was created and set up directly on the
>> 9.2 database. I don't know much about the postgreSQL permissions or access
>> control model, but here's what my databases look like in postgres:
>>
>>                                   List of databases
>>    Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access
>> privileges
>>
>> -----------+----------+----------+-------------+-------------+-----------------------
>>  ckandb    | ckanuser | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
>> =Tc/ckanuser
>>         +
>>            |          |          |             |             |
>> ckanuser=CTc/ckanuser
>>  ckandstor | ckanuser | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
>> =Tc/ckanuser
>>         +
>>            |          |          |             |             |
>> ckanuser=CTc/ckanuser+
>>            |          |          |             |             |
>> ckandsro=c/ckanuser
>>
>>
>> Any ideas where I went wrong?
>>
>> -Don
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>