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

Thu Sep 29 16:19:01 UTC 2016

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160929/9ad88519/attachment-0002.html>