Dears,
I am using windows 10 os,
I have configured Elasicsearch, kibana and packebeat as per standard
I have installed pcapng too
In powershell after execute the .\packetbeat.exe -devices command
0: \Device\NPF_{5BC8D54F-F098-49C3-8D2D-969E839DFA8E} (Intel(R) Ethernet Connection I219-V) (fe80::79b6:7ad7:e5c6:9de9
192.168.2.120)
1: \Device\NPF_{11FF37BF-069C-481D-8EEE-1E1FB9BD69F6} (Microsoft) (fe80::dfa:60ab:c73d:87c7 2408:210:28ec:b800:9cfb:b3
bd:bf27:b3f8 2408:210:28ec:b800:dfa:60ab:c73d:87c7 192.168.2.100)
2: \Device\NPF_{AA15BD21-3348-460A-8081-023207EABD27} (MS NDIS 6.0 LoopBack Driver) (fe80::f180:c469:a35a:4b9e 0.0.0.0
)
like devices are displaying
so I set
packetbeat.interfaces.device: 2 in packbeat.yml file
I want to receive packet from PostgreSQL or MySQL so I set
packetbeat.flows:
timeout: 10s
period: 10s
packetbeat.protocols.http:
ports: [80, 8080, 8000, 5000, 8002, 8099]
packetbeat.protocols.mysql:
ports: [3306]
packetbeat.protocols.pgsql:
ports: [5432]
output.elasticsearch:
hosts: ["127.0.0.1:9200"]
after start packetbeat, wireshark also stared
I did operations on PostgreSQL/MySQL, I couldn't get any packets in elasticsearch, the same I can able to catch packets in wireshark
Is there anything I have missed
Thanks & Regards,
Nagarajan.H
steffens
(Steffen Siering)
May 19, 2017, 11:06am
2
did you check packetbeat logs?
Can you find flows in ES/Kibana?
Yes, I have checked the log it seams packebeat is running and able to capture others ports packets
2017-05-19T10:34:11+09:00 INFO Resolved device index 2 to device: \Device\NPF_{AA15BD21-3348-460A-8081-023207EABD27}
2017-05-19T10:34:11+09:00 DBG Sniffer type: pcap device: \Device\NPF_{AA15BD21-3348-460A-8081-023207EABD27}
2017-05-19T10:34:11+09:00 DBG new flows worker. timeout=10s, period=10s, tick=10s, ticksTO=1, ticksP=1
2017-05-19T10:34:11+09:00 DBG Local IP addresses: [fe80::79b6:7ad7:e5c6:9de9 169.254.157.233 fe80::f180:c469:a35a:4b9e 169.254.75.158 fe80::fdca:b6a4:4ef5:7e66 169.254.126.102 2408:210:28ec:b800:dfa:60ab:c73d:87c7 2408:210:28ec:b800:9cfb:b3bd:bf27:b3f8 fe80::dfa:60ab:c73d:87c7 192.168.2.100 ::1 127.0.0.1 2001:0:4137:9e76:1874:25:c5fe:1fcb fe80::1874:25:c5fe:1fcb fe80::5efe:c0a8:264]
2017-05-19T10:34:11+09:00 DBG tcp%!(EXTRA string=Port map: %v, map[uint16]protos.Protocol=map[8000:http 3306:mysql 5432:pgsql 80:http 8080:http 5000:http 8002:http 8099:http 11211:memcache])
2017-05-19T10:34:11+09:00 DBG Port map: map[11211:memcache]
2017-05-19T10:34:11+09:00 DBG register flow counter: net_packets_total
2017-05-19T10:34:11+09:00 DBG register flow counter: net_bytes_total
2017-05-19T10:34:11+09:00 DBG Layer type: Ethernet
2017-05-19T10:34:11+09:00 INFO packetbeat start running.
2017-05-19T10:34:30+09:00 DBG Publish: {
"@timestamp ": "2017-05-19T01:34:30.001Z",
"beat": {
"hostname": "DESKTOP-TI70K7V",
"name": "DESKTOP-TI70K7V",
"version": "5.4.0"
},
"dest": {
"ip": "239.255.255.250",
"mac": "01:00:5e:7f:ff:fa",
"port": 1900
},
"final": true,
"flow_id": "EQIA////DP////8U//8BAAEBAF5///oCAExPT1Dv///6qf5LnmwHwtQ",
"last_time": "2017-05-19T01:34:12.390Z",
"source": {
"ip": "169.254.75.158",
"mac": "02:00:4c:4f:4f:50",
"port": 54466,
"stats": {
"net_bytes_total": 1276,
"net_packets_total": 4
}
},
"start_time": "2017-05-19T01:34:12.390Z",
"transport": "udp",
"type": "flow"
}
Where are PostgreSQL and MySQL running? How are you performing operations? Since you are listening on the loopback device, are you sure the commands are communicating to the loopback interface and are unencrypted?
MySQL and PostgreSQL are running in same pc only where the packetbeat, elasticsearch and kibana are configured, Everything is in local(same pc), I tested with Insert/Retriew records(Insert command and Select query) and not encrypted one
steffens
(Steffen Siering)
June 6, 2017, 8:54am
6
Is it possible, PostgreSQL/MySQL using named pipes instead of a network socket?
I want to execute in local system only
steffens
(Steffen Siering)
June 7, 2017, 10:14am
8
have you checked you client is connection to MySql/PostgreSQL via named pipes or network socket?
system
(system)
Closed
July 5, 2017, 10:15am
9
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.