[ckan-dev] Datastore - Could not connect to DataPusher

Thu Sep 29 19:15:25 UTC 2016

Probably the CKAN application needs to know how to access URLs using a
proxy. See this link for how to configure it:
https://github.com/ckan/datapusher/issues/60

Its worth doing it for CKAN and the Datapusher application so that the
Datapusher can also fetch external URLs to push the data to the datastore.

Best,
Matt

--
Matt Fullerton
Software development and data science for open data and mobility
matt at crowdsalad.de
+49 89 7456 0495 / +49 176 5789 6501
http://www.crowdsalad.de

On 29 September 2016 at 18:19, Pedro Ferro <pedro.ferro at gmail.com> wrote:

> Hi,
>
> I'm working behind a proxy and installed CKAN 2.5.1 with Solr 5.1.0 in Ubuntu14.04 virtual machine.
>
> When I add a file and then try to "Upload to Datastore" I get the error "Could not connect to DataPusher".
>
> I think it's because of that I can have all the views options (graph, grid...).
>
> Probably the problem is in my Datastore.
> Following the official documentation I tested the datastore with:curl -X GET "http://127.0.0.1:5000/api/3/action/datastore_search?resource_id=_table_metadata"
>
> but the result wasn't a json file withou errors but
>
> <h1>ERROR</h1>
> <h2>The requested URL could not be retrieved</h2>
> </div>
> <hr>
>
> <div id="content">
> <p>The following error was encountered while trying to retrieve the URL: <a href="http://127.0.0.1:5000/api/3/action/datastore_search?">http://127.0.0.1:5000/api/3/action/datastore_search?</a></p>
>
> <blockquote id="error">
> <p><b>Connection to 127.0.0.1 failed.</b></p>
> </blockquote>
>
> <p id="sysmsg">The system returned: <i>(111) Connection refused</i></p>
>
>
> I installed the Datastore like this:
>
> sudo -u postgres createuser -S -D -R -P -l datastore_default
>
> sudo -u postgres createdb -O ckan_default datastore_default -E utf-8
>
>  sudo vim /etc/ckan/default/development.ini
>
> ckan.datastore.write_url = postgresql://ckan_default:*ckan_default*@localhost/datastore_default
>
> ckan.datastore.read_url = postgresql://datastore_default:*ckan_default*@localhost/datastore_default
>
> ckan.plugins = datastore datapusher
>
> ckan.storage_path = /var/lib/ckan
>
> ckan.max_resource_size = 1000
>
> ckan.max_image_size = 200
>
> ckan.datapusher.url = http://0.0.0.0:8800/
>
> sudo mkdir -p /var/lib/ckan
>
> sudo chown `whoami`:`whoami` /var/lib/ckan
>
> paster --plugin=ckan datastore set-permissions -c /etc/ckan/default/development.ini | sudo -u postgres psql --set ON_ERROR_STOP=1
>
>  ln -s /usr/lib/ckan/default/src/ckan/who.ini /etc/ckan/default/who.ini
>
>
> Some of my configurations on development.ini
>
> ckan.site_url = http://10.0.70.76:5000
>
> solr_url = http://127.0.0.1:8983/solr/ckan
>
> ckanext.spatial.search_backend = solr-spatial-field
>
> ckan.views.default_views = image_view text_view recline_view geo_view
>
> ckan.datapusher.formats = csv xls xlsx tsv application/csv  application/vnd.ms-excel application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
>
> ckan.datapusher.url = http://0.0.0.0:8800/
>
>
>
> If someone could help I appreciate...
>
>
> Pedro
>
>
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160929/19978bb7/attachment-0003.html>