What is
Sometimes, we need to know what connections our local machine has, and what are their IP, domain name, program and parameters?
- get ip to domain
- Know the domian corresponding to the local network connection IP
How get Local network connection
# pid ip domain cmdAndArgs
./getCurNetConn.sh f
How install for macos
brew install mysql tmux
brew services start mysql
brew services list|grep mysql
pip3 install mysql-connector-python scapy pysnooper
ln -s `which python3` /usr/local/bin/py3
How init mysql
create database sgdb_51pwn default charset 'utf8';
create user 'sgdb_51pwn'@'%' identified by 'sgdb_51pwn';
grant all on sgdb_51pwn.* to 'sgdb_51pwn'@'%';
flush privileges;
CREATE TABLE `ip2domain` (
`id1` varchar(100) NOT NULL,
`id2` varchar(100) NOT NULL,
KEY `NewTable_id1_IDX` (`id1`) USING BTREE,
KEY `NewTable_id2_IDX` (`id2`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
How run
tmux
sudo py3 ip2domain.py
run for centos vps
python3 ip2domain2.py
rm -rf ip2d.txt
scp -i ~/.ssh/id_rsa -r -P $myVpsPort [email protected]:/root/ip2d.txt ./
sort -u ip2d.txt|uniq >ip2domain.txt
rm -rf ip2d.txt
mysqlimport -u sgdb_51pwn -psgdb_51pwn --local sgdb_51pwn `pwd`/ip2domain.txt
rm -rf ip2domain.txt
# or
mysql -u sgdb_51pwn -psgdb_51pwn
use sgdb_51pwn;
SET GLOBAL local_infile=1;
LOAD DATA LOCAL INFILE '/ip2domain/ip2domain.txt' INTO TABLE ip2domain FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n';
exit
rm -rf ip2domain.txt
How query ips
py3 ip2d4query.py -i 52.35.195.250,17.57.145.167
Know the domian corresponding to the local network connection IP
./getCurNetConn.sh f|awk '{print $2}'|xargs -I % py3 ip2d4query.py -i %
# Now you can see:
# pid ip domain cmd & args
./getCurNetConn.sh f
32 Oct 30, 2022
1 Nov 10, 2021
7 Apr 28, 2022
35 Oct 04, 2022
1 Mar 25, 2022
9.4k Jan 09, 2023
19 Dec 26, 2022
24 Nov 10, 2022
0 Jan 02, 2022
1 Jan 11, 2022
1 Nov 30, 2021
5 Dec 20, 2021
1.2k Jan 04, 2023
2 Jan 31, 2022
127 Dec 23, 2022
356 Dec 23, 2022
2 Aug 19, 2022
3 Feb 22, 2022
70 Dec 18, 2022
61 Dec 17, 2022