[ckan-dev] database connection error if database on a separate server

Thu May 4 12:26:59 UTC 2017

Unfortunately it didn't solve my problem. It still gives me a server error after a while connecting again (opening whatever page).
Is there anything which needs to be set on the database server ?

Is anyone using an external database or is this not recommended ?

Thank you.

Hilde
________________________________
From: ckan-dev [ckan-dev-bounces at lists.okfn.org] on behalf of Thompson, Ross (STATCAN) [ross.thompson at canada.ca]
Sent: 03 May 2017 15:07
To: 'ckan-dev at lists.okfn.org'
Subject: [ckan-dev] database connection error if database on a separate server

> Date: Wed, 3 May 2017 09:51:30 +0000
> From: <Hildegard.GERLACH at ec.europa.eu<mailto:Hildegard.GERLACH at ec.europa.eu>>
> To: <ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>>
> Subject: [ckan-dev] database connection error if database on a separate       server
> Message-ID:
>       <3389FFAB30EE96408E8C2058A564BF0A022E39C7 at S-DC-ESTC02-J.net1.cec.eu.int<mailto:3389FFAB30EE96408E8C2058A564BF0A022E39C7 at S-DC-ESTC02-J.net1.cec.eu.int>>
>
> Content-Type: text/plain; charset="cp1256"
>
> Dear all,
>
> I am having the following issue:
> I am setting up a production server on which I want to use the postgresql database on a separate database server instead installing it locally (with the local installations I never had this problem).
>
> I am using Ckan 2.5.1 and postgresql 9.6
> ……..

We experienced a similar problem in our environment – in our situation adding the following parameter to the sqlalchemy connection string seemed to resolve the issue: “?connect_timeout=30”

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20170504/772b8089/attachment-0003.html>