[rt-users] Debian setup: postgres problem?

[Karl Hegbloom]

On Fri, 2004-06-25 at 16:48 +1000, Jens Porup wrote:
> I am trying to install Request Tracker on Debian testing.

What's in your /etc/postgresql/pg_hba.conf file?  You need:

# host    template1   rtuser    127.0.0.1    255.255.255.255   md5
# local   template1   rtuser                                   md5
host    rtdb      rtuser    127.0.0.1    255.255.255.255   md5
local   rtdb      rtuser                                   md5

... right after where it says "put your actual configuration here".  The
lines I have commented off should be uncommented until after you have
loaded the initial RT database.  After you edit this file, you must run
"/etc/init.d/postgresql restart".  The IP address and mask that
connections are allowed from can be for another host, if your database
and RT are on separate boxes.

Rather than waiting for "nmap" to see what ports are open, why not just
use "netstat"?   "netstat --tcp -lp" will show you open TCP ports
programs are listening on, along with what programs they are.

-- 
Karl Hegbloom <hegbloom at pdx.edu>