[ckan-dev] Datastore and preview of CSV file

Tue Aug 6 09:37:51 UTC 2013

Hey Aaron,

We just noticed there is a but that has been fixed in 2.1 but not in 2.0 which causes the problem with the datastore that you reported. You can either wait for CKAN 2.0.2 which will include the fix [1] or just connect to your database with psql and execute: "CREATE TYPE "nested" AS (json text, extra text)" (on pg 9.1 and below) or "CREATE TYPE "nested" AS (json json, extra text)" (pg 9.2 and higher).

I'm sorry about the inconveniences,
Dominik

[1] https://github.com/okfn/ckan/pull/1160

On 6 Aug 2013, at 00:03, Dominik Moritz <dominik.moritz at okfn.org> wrote:

> Hey Aaron,
> 
> The log says that there is a problem with the permissions (permission denied for schema public). During set-up, you created two users for the datastore. One with only read permissions and one with write permissions. The second user seems to have the wrong permissions. Could you rerun the step that sets the permissions? If that doesn't help, try one of the other options. You can try the permissions by connecting directly to the database using psql and the read-write user. You should be able to create tables and types with that user. 
> 
> If that doesn't help either, please tell me a little bit more about your set-up. 
> 
> Having said this, the error from you email is not related to the datastore. The problem here (DNS lookup failed for URL) is that the resource you are trying to preview is in a location that cannot be reached from the internet. As long as your resource is not in the datastore, the file needs to be accessible from the web to be previewable.  
> 
> Best wishes,
> Dominik
> 
> 
> On 5 Aug 2013, at 23:40, Aaron McGlinchy <McGlinchyA at landcareresearch.co.nz> wrote:
> 
>> Hi, we have setup the datastore and configured the database as per http://docs.ckan.org/dv/latest/datastore.html
>> 
>> However when we go to preview the file we get an error:
>> 
>> "This resource can not be previewed at the moment.
>> Could not load preview: DataProxy returned an error (Data transformation failed. error: An error occured while connecting to the server: DNS lookup failed for URL: http://ckan.zen.landcareresearch.co.nz/storage/f/2013-08-01T02%3A56%3A29.990Z/track2.csv)"
>> 
>> The datastore error log generated is attached  (too long to include in message).  Any help appreciated.
>> 
>> Thanks
>> Aaron
>> 
>> ________________________________
>> 
>> Please consider the environment before printing this email
>> Warning: This electronic message together with any attachments is confidential. If you receive it in error: (i) you must not read, use, disclose, copy or retain it; (ii) please contact the sender immediately by reply email and then delete the emails.
>> The views expressed in this email may not be those of Landcare Research New Zealand Limited. http://www.landcareresearch.co.nz
>> <ckan_datastore_error.txt>_______________________________________________
>> 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
> 
> Dominik Moritz
> CKAN developer  |  skype: d.moritz  |  @doobly_doo
> The Open Knowledge Foundation
> Empowering through Open Knowledge
> http://okfn.org/  |  @okfn  |  http://ckan.org  |  @CKANproject
> 

Dominik Moritz
CKAN developer  |  skype: d.moritz  |  @doobly_doo
The Open Knowledge Foundation
Empowering through Open Knowledge
http://okfn.org/  |  @okfn  |  http://ckan.org  |  @CKANproject

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 495 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130806/b95f2939/attachment-0001.sig>