Re: Problem w/ IDENT authentication

Tom Lane wrote:
>
> Is it possible that jdbc tries to use an IPv6 rather than IPv4
> connection in your setup?

I just tried it with "jdbc:postgresql://127.0.0.1/tomcat4" with the same
result.

> It might be worth looking in the postmaster's stderr log to see if any
> more information about the connection failure is there.  We often log
> information that we don't report to the client for security reasons.

Where can I find this log?

I've cranked up the logging verbosity in postgresql.conf:


#syslog = 0            # range 0-2; 0=stdout; 1=both; 2=syslog
syslog = 2
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'

# - When to Log -

#client_min_messages = notice    # Values, in order of decreasing detail:
                #   debug5, debug4, debug3, debug2, debug1,
                #   log, info, notice, warning, error
client_min_messages = debug5

#log_min_messages = notice    # Values, in order of decreasing detail:
                #   debug5, debug4, debug3, debug2, debug1,
                #   info, notice, warning, error, log, fatal,
                #   panic
log_min_messages = debug5

#log_error_verbosity = default   # terse, default, or verbose messages
log_error_verbosity = verbose

#log_min_error_statement = panic # Values in order of increasing severity:
                 #   debug5, debug4, debug3, debug2, debug1,
                 #   info, notice, warning, error, panic(off)
log_min_error_statement = debug5

#log_min_duration_statement = -1 # Log all statements whose
                 # execution time exceeds the value, in
                 # milliseconds.  Zero prints all queries.
                 # Minus-one disables.

#silent_mode = false         # DO NOT USE without Syslog!

# - What to Log -

#debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
#log_connections = false
log_connections = true
#log_duration = false
#log_pid = false
#log_statement = false
#log_timestamp = false
#log_hostname = false
#log_source_port = false

All I see in the syslog for a failed connection is:

Jul 26 11:22:48 home postgres[24968]: [30-1] LOG:  00000: connection
received: host=127.0.0.1 port=34676
Jul 26 11:22:48 home postgres[24968]: [30-2] LOCATION:  BackendFork,
postmaster.c:2395
Jul 26 11:22:51 home postgres[24968]: [31-1] FATAL:  28000: IDENT
authentication failed for user "tomcat4"
Jul 26 11:22:51 home postgres[24968]: [31-2] LOCATION:  auth_failed,
auth.c:395

This doesn't tell me anything that I didn't already know.

--
========================================================================
Ian Pilcher                                        i.pilcher@comcast.net
========================================================================