[ckan-dev] Dataproxy error

Mon May 6 13:08:34 UTC 2013

Hey,

On 6 May 2013, at 14:50, Isabel Ruiz <isaruizmellado at gmail.com> wrote:

> I executed this command and it works:
> 
> curl -X POST http://est50v:5000/api/3/action/datastore_create -H
> "Authorization:7be96e17-8a96-418d-8f6b-c5c8406f7fee" -d '{"resource_id":
> "b0c83fed-f423-46fc-bf3c-7933f889c9e6", "fields": [ {"id": "a"}, {"id":
> "b"} ], "records": [ { "a": 1, "b": "xyz"}, {"a": 2, "b": "zzz"} ]}'
> 
> I tried URL you send me and it returns the data.
> 
> The problem is:
> 
> If I upload a file inside CKAN web, I can save, but If I open the detail
> page, it shows this error:
> 
> 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://myIP/es/storage/f/2013-05-03T083242/file.csv)
> 
> Why does not datastorer extesion work?

Is celery running? Is the datastorer extension enabled? What is the output from celery (the datastorer)? What tables are in the datastore?

> 
> NOTE: I installed: CKAN from package and datastorer from source, but It
> seems it doesnt work
> 
> Thanks!

Cheers,
Dominik

> 
> 
> On Mon, May 6, 2013 at 11:00 AM, Dominik Moritz <dominik.moritz at okfn.org>wrote:
> 
>> Hey,
>> 
>> You don't have to configure anything. The preview will automatically use
>> the data from the datastore if it is present. Can you see your resource in
>> the _table_metadata[1] table in the datastore?
>> 
>> Best wishes,
>> Dominik
>> 
>> [1] /api/action/datastore_search?resource_id=_table_metadata
>> 
>> On 6 May 2013, at 09:16, Isabel Ruiz <isaruizmellado at gmail.com> wrote:
>> 
>>> Hi!
>>> 
>>> I had installed and configured datastorer and celery with Supervisor.
>>> 
>>> How can I configure CKAN to use local datastore instead of dataproxy?
>>> 
>>> datastorer seem does not work, because CKAN shows dataproxy error (CKAN
>> is
>>> connecting https://jsondataproxy.appspot.com).
>>> 
>>> 
>>> Thanks
>>> 
>>> 
>>> 
>>> On Fri, May 3, 2013 at 2:30 PM, Dominik Moritz <dominik.moritz at okfn.org
>>> wrote:
>>> 
>>>> Hi,
>>>> 
>>>> The dataproxy is a service on the internet (
>>>> https://jsonpdataproxy.appspot.com/). You could install it in your
>>>> intranet to use it. A better choice would be not to use the dataproxy
>> and
>>>> store all your data in the datastore (
>>>> http://docs.ckan.org/en/latest/datastore.html) which can be previewed
>>>> without access to the internet.
>>>> 
>>>> Best wishes,
>>>> Dominik
>>>> 
>>>> 
>>>> On 3 May 2013 08:47, Isabel Ruiz <isaruizmellado at gmail.com> wrote:
>>>> 
>>>>> My IP only can be reached from intranet.
>>>>> 
>>>>> is internet access mandatory?
>>>>> 
>>>>> If internet access is mandatory, is there another option?
>>>>> 
>>>>> Thanks!
>>>>> 
>>>>> 
>>>>> On Thu, May 2, 2013 at 2:35 PM, Dominik Moritz <
>> dominik.moritz at okfn.org>wrote:
>>>>> 
>>>>>> Hi,
>>>>>> 
>>>>>> Can you try to use http://www.downforeveryoneorjustme.com/ to see
>>>>>> wether you ip can be reached from the internet?
>>>>>> 
>>>>>> Cheers,
>>>>>> Dominik
>>>>>> 
>>>>>> On 2 May 2013, at 13:52, Isabel Ruiz <isaruizmellado at gmail.com>
>> wrote:
>>>>>> 
>>>>>>> Hi !
>>>>>>> 
>>>>>>> Here are my configurations:
>>>>>>> CKAN database is installed and works correct in Postgresql 9.1.9 on
>>>>>> Ubuntu
>>>>>>> 12.10.
>>>>>>> CKAN 1.8 is installed on a Ubuntu 10.0.4 VM Ware machine and works.
>>>>>>> 
>>>>>>> CKAN works fine. I can insert datasets and datastore from any
>> computer
>>>>>>> connected on my  network.
>>>>>>> 
>>>>>>> I click on a datastore and try to see details.
>>>>>>> 
>>>>>>> A new page is opened but it throws this error:
>>>>>>> 
>>>>>>> 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://myIP/es/storage/f/2013-05-02T102449/myCSVfile.csv)
>>>>>>> 
>>>>>>> I try:
>>>>>>> 
>>>>>>> - paste URL on Firefox and I can download this file.
>>>>>>> - run wget URL command in Linux terminal and I can download this
>> file.
>>>>>>> 
>>>>>>> What can be wrong?
>>>>>>> 
>>>>>>> 
>>>>>>> Thanks!
>>>>>>> 
>>>>>>> --
>>>>>>> Isabel M. Ruiz Mellado
>>>>>>> http://about.me/isabelruiz
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>> 
>>>>>> 
>>>>>> _______________________________________________
>>>>>> 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
>>>>>> 
>>>>> 
>>>>> 
>>>>> 
>>>>> --
>>>>> Isabel M. Ruiz Mellado
>>>>> http://about.me/isabelruiz
>>>>> 
>>>>> _______________________________________________
>>>>> 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
>>>>> 
>>>>> 
>>>> 
>>>> _______________________________________________
>>>> 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
>>>> 
>>>> 
>>> 
>>> 
>>> --
>>> Isabel M. Ruiz Mellado
>>> http://about.me/isabelruiz
>>> _______________________________________________
>>> 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
>> 
>> 
>> _______________________________________________
>> 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
>> 
> 
> 
> 
> -- 
> Isabel M. Ruiz Mellado
> http://about.me/isabelruiz
> _______________________________________________
> 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