Dear,
The problem is detected but the reason is still not clear. It seems that if
one is connecting via a ODBC link from a winbox to a postgresql database
the link first tries to connect via username Admin, see syslog :
Oct 25 07:47:52 backbone logger: verify_password: user 'Admin' not found in
password file.
Oct 25 07:47:52 backbone logger: Password authentication failed for user
'Admin'
Oct 25 07:47:52 backbone logger: 2002-10-25 07:47:52
[2938] DEBUG: connection: host=192.168.244.37 user=icsadmin
database=ics_poll
Oct 25 07:47:53 backbone logger: 2002-10-25 07:47:53
[2938] ERROR: Relation 'msysconf' does not exist
Does anybody has a clue what the relation msyconf means ?
With the settings in postgresql.conf as advised we found the problem thanks !!
Kind regards
Patrick
At 19:32 24/10/2002 +0530, Mohan A wrote:
>You could trace it in the log file by setting the following in
>postgresql.conf
>
>
>log_connections = true
>log_timestamp = true
>log_pid = true
>
>You should be getting entries in the log file as -
>
>2002-10-23 20:26:53 [18117] DEBUG: proc_exit(1)
>2002-10-23 20:26:53 [18117] DEBUG: shmem_exit(1)
>2002-10-23 20:26:53 [18117] DEBUG: exit(1)
>2002-10-23 20:28:51 [18070] DEBUG: BackendStartup: forked pid=18130
>socket=8
>2002-10-23 20:28:51 [18130] DEBUG: connection: host=192.168.1.62
>user=admin database=template1
>/var/local/pgsql/bin/postmaster child[18130]: starting with
>(postgres -d3 -v131072 -p template1 )
>
>Hope this helps.
>
>
>----- Original Message -----
>From: "Patrick Meylemans" <Patrick.Meylemans@wtcm.be>
>To: <pgsql-admin@postgresql.org>
>Sent: Thursday, October 24, 2002 6:06 PM
>Subject: [ADMIN] Errors in messages file
>
>
> > Dear,
> >
> > I'm receiving the following messages in the /var/log/message file :
> >
> > -> logger: verify_password: user 'Admin' not found in password file.
> >
> > We are running on RedHat7.0
> > Postgresql7.1.3
> >
> > How can I trace the IP adres of the client trying to connect as Admin to
> > our database ?
> >
> > Kind Regards
> >
> > Patrick Meylemans
> >
> > Manager ICS CRIF-WTCM
> > Celestijnenlaan 300C
> > 3001 Heverlee
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)