From: Scott Marlowe <smarlowe@qwest.net>
To: Jens Porup <jens@cyber.com.au>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres IDENT auth problems...
Date: Thu, 01 Jul 2004 09:25:29 -0600
Message-ID: <1088695529.14882.3.camel@localhost.localdomain> (raw)
In-Reply-To: <20040701054614.GB9047@vanilla.office.cyber.com.au>
References: <20040701033844.GA7583@vanilla.office.cyber.com.au>
<1088659984.4056.9.camel@localhost.localdomain>
<20040701054614.GB9047@vanilla.office.cyber.com.au>
On Wed, 2004-06-30 at 23:46, Jens Porup wrote:
> On Wed, Jun 30, 2004 at 11:33:04PM -0600, Scott Marlowe wrote:
> > On Wed, 2004-06-30 at 21:38, Jens Porup wrote:
> >
> > > The request tracker database setup script dies trying to connect to
> > > the database:
> > >
> > > DBI connect('dbname=template1;host=localhost','rtuser',...) failed: could not
> > > connect to server: Connection refused at /usr/sbin/rt-setup-database line 110
> > >
> <snip>
> > >
> > > Now before you ask:
> > >
> > > Yes, the following lines appear uncommented in my
> > > /etc/postgresql/postgresql.conf:
> > >
> > > tcpip_socket = true
> > > port = 5432
> > >
> > > But then:
> > >
> > > root@request-tracker:~# netstat -auntp
> > >
> > > shows postmaster running on a udp port???
> > >
> > > udp 0 0 127.0.0.1:1042 127.0.0.1:1042 ESTABLISHED18375/postmaster
> > >
> >
> > But can you nmap it? And that's not the right default port 5432...
> > Maybe it's some new feature I'm familiar with, or you've changed it.
>
> Trust me, I am a postgres newbie... I'm not trying to do anything but a *very*
> ordinary install!
Well, something is quite wrong then. Find your postgresql.conf file and
see what port it is set to there. port 1042 is definitely not the
default port.
Also, try two things:
nmap -p 1042
psql -h 127.0.0.1 -p 1042
If nmap can see the port open, and psql can open it, then you can just
use it like that by specifying that port each time in your connect
string.
> >
> > What does nmap <ip> show?
>
> root@request-tracker:~# nmap localhost
>
> Starting nmap 3.50 ( http://www.insecure.org/nmap/ ) at 2004-07-01 15:39 EST
> Interesting ports on localhost (127.0.0.1):
> (The 1654 ports scanned but not shown below are in state: closed)
> PORT STATE SERVICE
> 22/tcp open ssh
> 25/tcp open smtp
> 80/tcp open http
> 113/tcp open auth
> 515/tcp open printer
>
> Nmap run completed -- 1 IP address (1 host up) scanned in 1.735 seconds
> root@request-tracker:~#
>
> > > A server restart shows:
> > >
> > > root@request-tracker:~# /etc/init.d/postgresql restart
> > > Stopping PostgreSQL database server: autovacuumNo pg_autovacuum found running;
> > > none killed.
> > > postmaster.
> > > Starting PostgreSQL database server: postmaster autovacuum.
> >
> > Sounds like a firewall to me.
> >
> My colleague here at work who built the user mode linux image I'm using
> (the virtual "box") assures me there's no firewall installed.... how
> would I check if there were?
IF the database is configured for port 1042, then it might not be a
firewall, just a misconfiguration of the database.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@qwest.net, jens@cyber.com.au
Subject: Re: Postgres IDENT auth problems...
In-Reply-To: <1088695529.14882.3.camel@localhost.localdomain>
References: <20040701033844.GA7583@vanilla.office.cyber.com.au> <1088659984.4056.9.camel@localhost.localdomain> <20040701054614.GB9047@vanilla.office.cyber.com.au> <1088695529.14882.3.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox