connecting from trac: "no route to host" error

From: Ivan Uemlianin <ivan(at)llaisdy(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: connecting from trac: "no route to host" error
Date: 2010-05-13 14:15:30
Message-ID: 4BEC0982.8080708@llaisdy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear All

I am trying to set up trac with postgresql. However, in trac-admin
initenv I am receiving a "no route to host" error:

Database connection string [sqlite:db/trac.db]>
postgres://tdb_user:tdb_pass(at)locahost/tdb_dbname

Creating and Initializing Project
Initenv for '/opt/trac/pgtest' failed.
Failed to create environment.
could not connect to server: No route to host
Is the server running on host "locahost" and accepting
TCP/IP connections on port 5432?

Traceback (most recent call last):
File "build/bdist.linux-x86_64/egg/trac/admin/console.py", line 413,
in do_initenv
options=options)
File "build/bdist.linux-x86_64/egg/trac/env.py", line 221, in __init__
self.create(options)
File "build/bdist.linux-x86_64/egg/trac/env.py", line 410, in create
DatabaseManager(self).init_db()
File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 87, in init_db
connector.init_db(**args)
File "build/bdist.linux-x86_64/egg/trac/db/postgres_backend.py", line
98, in init_db
params)
File "build/bdist.linux-x86_64/egg/trac/db/postgres_backend.py", line
87, in get_connection
params)
File "build/bdist.linux-x86_64/egg/trac/db/postgres_backend.py", line
203, in __init__
port))
OperationalError: could not connect to server: No route to host
Is the server running on host "locahost" and accepting
TCP/IP connections on port 5432?

trac-admin is happy with sqlite.
I can login to postgresql using psql.
I have disabled iptables and selinux (It's all on a centos machine).
Stopping my web server (nginx) makes no difference.

ping localhost works but indeed ping localhost 5432 does not (receives
no packets). However, postgresql.conf has:

listen_addresses = 'localhost'
port = 5432

I have the feeling I'm missing something obvious (I have read the FAQ,
Googled, etc.). Please can anyone advise?

With thanks and best wishes

Ivan

--
============================================================
Ivan A. Uemlianin
Speech Technology Research and Development

ivan(at)llaisdy(dot)com
www.llaisdy.com
llaisdy.wordpress.com
www.linkedin.com/in/ivanuemlianin

"Froh, froh! Wie seine Sonnen, seine Sonnen fliegen"
(Schiller, Beethoven)
============================================================

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-05-13 14:46:48 Re: connecting from trac: "no route to host" error
Previous Message Atif Jung 2010-05-13 10:30:22 Re: Interrupt