Re: tracking down breakins?

Поиск
Список
Период
Сортировка
От Mike Mascari
Тема Re: tracking down breakins?
Дата
Msg-id 004601c2b734$0b28c980$0102a8c0@mascari.com
обсуждение исходный текст
Ответ на tracking down breakins?  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Список pgsql-general
IIRC, Microsoft Access first attempts to use the userid associated with the current Access session (default 'Admin') when access data through ODBC linked tables.
 
FWIW,
 
Mike Mascari
----- Original Message -----

Running PostgreSQL 7.2.1 on RedHat Linux 7.2

A similar question to what David Siebert was
asking - I am trying to locate users that are trying
to log in as someone else in PostgreSQL.

I have the postmaster running the debug with level 2
and when I review my logs, I see this:

[snip from logs]

Jan  6 09:11:46 test_srv postgres[30134]: [228919] FATAL 1:  Password
authentication failed for user "Admin"

[/snip from logs]

How can I trace back *who* is trying to log in as 'Admin' and how
can I stop it?  If I run debug on any higher level, the response is
much slower; perhaps there is another way?

 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Johnson, Shaunn"
Дата:
Сообщение: too many Fatal Error 1: shutdown messages
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgres (psql ?) rounds all odd second values to even seconds fo r timestamp(0) data type