Re: tracing users ip address
От | Ken Godee |
---|---|
Тема | Re: tracing users ip address |
Дата | |
Msg-id | 3DF718E7.18262.DEFFBE@localhost обсуждение исходный текст |
Ответ на | tracing users ip address ("Johnson, Shaunn" <SJohnson6@bcbsm.com>) |
Список | pgsql-general |
Couldn't you just run something like ethereal and "filter/capture to log" all requests to the port? More then likely it's all in clear text. > Running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7-10 > > I'm looking at my logs / messages and I'm trying to figure out > how to trace some users. For example, I am trying to make > the server a bit more secure and in some of the logs I see > someone called 'Admin' trying to access the database (and > failing ... but for how long?) > > I don't know who this is, but, I'd like to know. Is there a way > I can track down the IP address of users trying to access > the database? I would imagine the debug that is running - currently > I'm running debug level 2 ... seems that any higher would > slow my server down. > > I don't seem to be able to see them ('Admin') using things like 'last', 'w' > or > anything like that. > > Suggestions? Thank you. > > -X >
В списке pgsql-general по дате отправления: