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.conflog_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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
