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

Tue Jul 22 10:35:44 UTC 2014

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: Inline image 1]
>>>
>>>
>>> Database list :
>>>
>>> [image: Inline image 2]
>>>
>>> pg_hba.conf file
>>>
>>>
>>> [image: Inline image 3]
>>>
>>> CKAN Config : development.ini
>>>
>>> [image: Inline image 4]
>>>
>>> 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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/ed0916e3/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 18929 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/ed0916e3/attachment-0015.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 13851 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/ed0916e3/attachment-0016.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 7755 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/ed0916e3/attachment-0017.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 3573 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/ed0916e3/attachment-0018.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: paster_close_unexpectedly.png
Type: image/png
Size: 384597 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/ed0916e3/attachment-0019.png>