X-Git-Url: http://ftp.carnet.hr/carnet-debian/scm?p=ossec-hids.git;a=blobdiff_plain;f=src%2Fos_dbd%2FREADME;fp=src%2Fos_dbd%2FREADME;h=881d656366f96f1624ea13c37f9666c1776c5829;hp=129e60f3b964c5054ac49493a81b6de636c06b7a;hb=3f728675941dc69d4e544d3a880a56240a6e394a;hpb=927951d1c1ad45ba9e7325f07d996154a91c911b diff --git a/src/os_dbd/README b/src/os_dbd/README index 129e60f..881d656 100644 --- a/src/os_dbd/README +++ b/src/os_dbd/README @@ -24,7 +24,7 @@ 5- View all alerts (with IP as string): -> SELECT rule_id, timestamp, INET_ATON(src_ip) srcip from alert; +> SELECT rule_id, timestamp, INET_NTOA(src_ip) srcip from alert; 6- View all alerts, including locations (IP as string and time as string): @@ -44,4 +44,3 @@ Output: | 2007-08-18 00:38:06 | 5715 | enigma->/var/log/authlog | 192.168.2.10 | Aug 18 00:38:02 enigma sshd[24284]: Accepted password for dcid from 192.168.2.10 port 34631 ssh2 | | 2007-08-18 00:38:21 | 5715 | enigma->/var/log/authlog | 192.168.2.10 | Aug 18 00:38:15 enigma sshd[20749]: Accepted password for dcid from 192.168.2.10 port 35755 ssh2 | +---------------------+---------+---------------------------+--------------+--------------------------------------------------------------------------------------------------+ -