[ckan-dev] Datastore and preview of CSV file

Mon Aug 5 22:03:47 UTC 2013

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

-------------- 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/5fa45e6d/attachment-0001.sig>