[CKAN-support] URGENT: FW: CKAN setup/info

Mon Aug 26 12:53:21 UTC 2013

Howdy everyone, sounds like the below is relatively straightforward... Would appreciate a response this afternoon so it's with them in the morning.

Thanks 

Gavin 

-----Original Message-----
From: "Aaron McGlinchy" <McGlinchyA at landcareresearch.co.nz>
Sent: ‎25/‎08/‎2013 23:51
To: "gavin.chait at okfn.org" <gavin.chait at okfn.org>; "support at ckan.org" <support at ckan.org>
Cc: "Michael Speth" <SpethM at landcareresearch.co.nz>
Subject: RE: URGENT: FW: CKAN setup/info

Hi,
    Regards the preview question, specifically we were testing a CSV file. 

Checking it appears to preview a txt file OK.  Pdf files it does not preview, but that is because “no handler defined for data type pdf”.  It does preview a jpg image as well.
When we click to preview a CSV file it starts to attempt the preview and then returns error:

After searching the help forum we found this problem which sounded similar to ours (http://lists.okfn.org/pipermail/ckan-dev/2013-June/005177.html ) so we setup the datastore as per http://docs.ckan.org/dv/latest/datastore.html#datastorer.  We still could not preview the CSV file, and the error log from the Datastore is attached.

Domink gave us a suggestion via the listserver (email attached), but then indicated it might be an issue that was solved when we update to v2.1.  We’ve installed the update and problem persists, so it could be the permissions – we have not changed them yet.  

The database persmissions are:

postgres-# \l
                                     List of databases
       Name        |  Owner   | Encoding  | Collate | Ctype |      Access privileges       
-------------------+----------+-----------+---------+-------+------------------------------
 ckan_default      | postgres | UTF8      | C       | C     | =T/postgres                 +
                   |          |           |         |       | postgres=CTc/postgres       +
                   |          |           |         |       | ckan_default=CTc/postgres
 datastore_default | postgres | UTF8      | C       | C     | =T/postgres                 +
                   |          |           |         |       | postgres=CTc/postgres       +
                   |          |           |         |       | ckan_default=CTc/postgres   +
                   |          |           |         |       | datastore_default=c/postgres
 postgres          | postgres | SQL_ASCII | C       | C     | 
 template0         | postgres | SQL_ASCII | C       | C     | =c/postgres                 +
                   |          |           |         |       | postgres=CTc/postgres
 template1         | postgres | SQL_ASCII | C       | C     | =c/postgres                 +
                   |          |           |         |       | postgres=CTc/postgres

For DB: ckan_default db
postgres: CREATE | TEMPORARY | CONNECT
ckan_default: CREATE | TEMPORARY | CONNECT

For DB: postgres
postgres: CREATE | TEMPORARY | CONNECT
ckan_default: CREATE | TEMPORARY | CONNECT
datastore_default: CONNECT

Michael was wondering what are the necessary permissions for ckan_default & datastore_default?  Looking at /usr/lib/ckan/default/src/ckan/ckanext/datastore/bin/set_permissions.sql, it looks like ckan_default needs to have SELECT not just CONNECT?

Thanks
Aaron

From: Gavin Chait [mailto:gavin.chait at okfn.org] 
Sent: Friday, 23 August 2013 7:17 p.m.
To: Aaron McGlinchy
Cc: Michael Speth
Subject: RE: URGENT: FW: CKAN setup/info

Hi Aaron,

For the data preview, it would be good to know the specific problem. Is it not working at all or is it certain data types don’t preview?  A screenshot can sometimes be of use here, depending on the problem.

For the second, we are in the process of writing up our theme documentation (i.e. improving it to the point it becomes much easier to understand) and there are a few people who could help with this query.  I’ll pass it on to them and get back to you.

As far as process, please email support at ckan.org and we’ll make sure we get back to you with answers.  The more detail the better on queries

I’ll get back to you as soon as I can.

Regards

Gavin

Gavin Chait
Head of Services | skype: whythawk | M:  +44 (0) 78 9495 7090 | @GavinChait
The Open Knowledge Foundation
Empowering through Open Knowledge
http://okfn.org/ | @okfn | OKF on Facebook | Blog | Newsletter

From: Aaron McGlinchy [

[The entire original message is not included.]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130826/5b9c3838/attachment-0001.html>