Webmaster Security

#Log_12- PostgreSQL Log Example

Submitted by BURST, , Thread ID: 113920

Thread Closed
BURST
User Icon
$ cat /etc/passwd
Challenge
Expert in Security
Level:
1
Reputation:
70
Posts:
1.35K
Likes:
151
Credits:
169
30-12-2018, 05:45 AM
#1
Input / Output
Code:
[2007-08-31 19:22:21.469 ADT] :[unknown] LOG: connection received: host=192.168.2.99 port=52136
[2007-08-31 19:22:21.485 ADT] 192.168.2.99:ossecdb LOG: connection authorized: user=ossec_user database=ossecdb
[2007-08-31 19:22:22.427 ADT] 192.168.2.99:ossecdb LOG: disconnection: session time: 0:00:00.95 user=ossec_user database=ossecdb host=192.168.2.99 port=52136
[2007-09-27 11:02:44.941 ADT] 192.168.2.10:ossecdb ERROR: relation "lala" does not exist
[2007-09-27 11:02:46.444 ADT] 192.168.2.10:ossecdb LOG: disconnection: session time: 0:00:35.79 user=ossec_user database=ossecdb host=192.168.2.10 port=3584


Daily Messages
Code:
[2007-09-01 07:14:41.062 ADT] : LOG: autovacuum: processing database "template1"
[2007-09-01 07:15:41.079 ADT] : LOG: autovacuum: processing database "ossecdb"


Query Records
Code:
[2007-09-01 16:44:49.244 ADT] 192.168.2.10:ossecdb LOG: duration: 4.550 ms statement: SELECT id FROM location WHERE name = 'enigma->/var/log/messages' AND server_id = '1'
[2007-09-01 16:44:49.251 ADT] 192.168.2.10:ossecdb LOG: duration: 5.252 ms statement: INSERT INTO location(server_id, name) VALUES ('1', 'enigma->/var/log/messages')
[2007-09-01 16:44:49.252 ADT] 192.168.2.10:ossecdb LOG: duration: 0.016 ms statement: SELECT id FROM location WHERE name = 'enigma->/var/log/messages' AND server_id = '1'
[2007-09-27 11:02:51.611 ADT] 192.168.2.10:ossecdb LOG: statement: INSERT INTO alert(id,server_id,rule_id,timestamp,location_id,src_ip) VALUES ('3577', '1', '50503','1190916566', '140', '0')


Query Errors
Code:
[2007-08-31 19:17:42.128 ADT] 192.168.2.99:test ERROR: relation "alertaaa" does not exist
[2007-08-31 19:17:46.375 ADT] 192.168.2.99:test ERROR: syntax error at or near "a" at character 1
[2007-09-27 11:02:44.941 ADT] 192.168.2.10:ossecdb ERROR: relation "lala" does not exist


Authentication Error
Code:
[2007-09-01 19:08:49.862 ADT] : LOG: connection received: host=192.168.2.99 port=37142
[2007-09-01 19:08:49.869 ADT] 192.168.2.99: FATAL: password authentication failed for user "ossec_user"
[Image: e72398fe92beda2aa80d0329e8b9f4febece7568.gif]

RE: #Log_12- PostgreSQL Log Example

spravnyforumxd
Closed Account
Level:
0
Reputation:
0
Posts:
16
Likes:
0
Credits:
16
22-01-2019, 11:08 AM
#2
Etiam bibendum elit eget erat. Mauris suscipit, ligula sit amet pharetra semper, nibh ante cursus purus, vel sagittis velit mauris vel metus. Integer vulputate sem a nibh rutrum consequat.

Users browsing this thread: 1 Guest(s)