[ckan-dev] Could not connect to server: Connection refused - Postgresql in CKAN

Tue Jul 22 10:38:48 UTC 2014

Assuming you followed the instructions and setup the virtualenv, you need to either:

source /usr/lib/ckan/default/bin/activate  # before running paster
paster serve …..

or,

/usr/lib/ckan/default/bin/paster serve ….

Currently it looks like you’re running a system-wide version of paster.

Ross

On 22 Jul 2014, at 11:35, Library IT <libraryit at iimahd.ernet.in> wrote:

> Dear Jason,
> 
> When I reboot the system and start apache and postgresql service..
> 
> When  i try to execute http://192.168.251.89   (apache) then it's showing me the 500 Internal server error.
> 
> also see the attachment.   what may be the problem ?
> 
> 
> 
> On Tue, Jul 22, 2014 at 2:24 PM, Library IT <libraryit at iimahd.ernet.in> wrote:
> Thanks Jason,
> 
> I have just change the path /etc/ckan/default/development.ini to use 127.0.0.1:5432 instead of 192.168.251.89:5432 and update pg_hba.conf to suit.
> 
> and it's Initialising DB: SUCCESS
> 
> Thanks,
> Bhavesh
> 
> 
> On Tue, Jul 22, 2014 at 1:10 PM, Jason Tan <jason.tan at ersa.edu.au> wrote:
> Hi Again,
> 
> Paster is telling you thatpostgres is not listening on the 192.168.251.89 IP on port 5432.
> 
> Is 192.168.251.89 the postgres database server?
> 
> If 192.168.251.89 IS the psotgres server then log into 192.168.251.89 and run:
> 
> ps auxwww|grep postmaster
> 
> You should get something like:
> [jtan at ckan-db ~]$ ps auxwww | grep postmaster
> postgres  1579  0.0  0.0 216512  5776 ?        S    Jun30   1:34 /usr/pgsql-9.0/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data -i -h 192.168.251.89
> 
> 
> The important bit is the 
>  -i -h 192.168.251.89
> 
> The -'i' says listen on internet sockets (as opposed to unix sockets)
> The '-h 192.168.251.89' says what host/IP address to listen on.
> 
> If both paster and postgres are running on 192.168.251.89 you can simply change the postgres URLs in 
> /etc/ckan/default/development.ini to use 127.0.0.1:5432 instead of 192.168.251.89:5432 and update pg_hba.conf to suit.
> 
> Jason
> 
> 
> 
> On 22 July 2014 16:45, Library IT <libraryit at iimahd.ernet.in> wrote:
> Dear All,
> 
> We are installing CKAN using Source.
> 
> http://docs.ckan.org/en/1117-start-new-test-suite/install-from-source.html
> 
> We are facing some issue while execute the step no : 6 Create database tables
> 
> paster db init -c /etc/ckan/default/development.ini
> 
> <image.png>
> 
> 
> Database list :
> 
> <image.png>
> 
> pg_hba.conf file
> 
> 
> <image.png>
> 
> CKAN Config : development.ini
> 
> <image.png>
> 
> Please let me know what may be the issue ?
> 
> 
> 
> -- 
> Jason Tan
> Data Infrastructure Specialist, eResearch SA
> 
> phone: +61 8 8313 2184
> Mob: +61 407 268 270
> email: jason.tan at ersa.edu.au
> web: http://www.ersa.edu.au
> 
> 
> <paster_close_unexpectedly.png>

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