Re: [Sqlgrey-users] A smarter smart

[Michel B. <mi...@bo...>]

Le Mardi 15 F=E9vrier 2005 15:38, Michel Bouissou a =E9crit :
>
> It's heuristic... So imperfect, but my tests show it gives much more
> accurate results compared to the original simpler algorithm.

Here is an example of a series of hostnames/addresses that the original=20
SQLgrey would take as "Class C" (for they don't have the end of their IP=20
address in their hostname), and my patch will consider "dynamic / end-use=
r"=20
machines, and thus use the full IP address :

0x503ead5c.bynxx8.adsl-dhcp.tele.dk[80.62.173.92]
0xd5aae2a2.dhcp.kabelnettet.dk[213.170.226.162]
ACB021F3.ipt.aol.com[172.176.33.243]
ACB296F3.ipt.aol.com[172.178.150.243]
ACB59FAD.ipt.aol.com[172.181.159.173]
ACB7FAB2.ipt.aol.com[172.183.250.178]
ACC8EBB5.ipt.aol.com[172.200.235.181]
adsl21118.estpak.ee[80.235.8.154]
adsl-dc-36cd0.adsl.wanadoo.nl[83.118.10.208]
asd-z-efb1.adsl.wanadoo.nl[81.69.13.177]
c8a65c72.bhz.virtua.com.br[200.166.92.114]
c8fbc881.bhz.virtua.com.br[200.251.200.129]
c906651b.virtua.com.br[201.6.101.27]
c906712d.virtua.com.br[201.6.113.45]
c90688a5.virtua.com.br[201.6.136.165]
c906e92a.virtua.com.br[201.6.233.42]
c9110cb5.rjo.virtua.com.br[201.17.12.181]
catv-5062ae15.catv.broadband.hu[80.98.174.21]
catv-506315e6.catv.broadband.hu[80.99.21.230]
catv-d5de9650.catv.broadband.hu[213.222.150.80]
cbl-il8-48.casscabletv.com[12.163.48.49]
cc550873-a.hnglo1.ov.home.nl[217.122.248.216]
cp346637-a.tilbu1.nb.home.nl[84.24.101.229]
cp427353-a.tilbu1.nb.home.nl[84.24.100.163]
cp644250-a.venlo1.lb.home.nl[84.29.41.12]
CPE00055df38a0c-CM00407b87707e.cpe.net.cable.rogers.com[69.197.247.61]
CPE00062930c118-CM014090206357.cpe.net.cable.rogers.com[24.100.251.82]
CPE0008a12a42eb-CM400047235173.cpe.net.cable.rogers.com[24.100.193.230]
CPE000ae6a33a8c-CM000a735f750d.cpe.net.cable.rogers.com[69.198.32.123]
CPE000cf1727e77-CM0012c90feac2.cpe.net.cable.rogers.com[69.193.9.232]
CPE0010dc418a71-CM012059934437.cpe.net.cable.rogers.com[24.156.89.186]
CPE00402b4b28ed-CM00080d53844c.cpe.net.cable.rogers.com[69.194.52.136]
CPE0080c6eaa3d6-CM013359900259.cpe.net.cable.rogers.com[24.156.43.203]
CPE0080c8b37441-CM0012250232ca.cpe.net.cable.rogers.com[69.197.38.226]
dial-369.lodz.dialog.net.pl[62.87.196.113]
dsl81-214-11370.adsl.ttnet.net.tr[81.214.44.106]
dsl81-214-11652.adsl.ttnet.net.tr[81.214.45.132]
dsl81-214-11805.adsl.ttnet.net.tr[81.214.46.29]
dsl81-214-12018.adsl.ttnet.net.tr[81.214.46.242]
dsl81-214-29753.adsl.ttnet.net.tr[81.214.116.57]
dsl81-214-39833.adsl.ttnet.net.tr[81.214.155.153]
dsl81-215-21703.adsl.ttnet.net.tr[81.215.84.199]
dsl81-215-24770.adsl.ttnet.net.tr[81.215.96.194]
dsl81-215-29615.adsl.ttnet.net.tr[81.215.115.175]
dsl81-215-30444.adsl.ttnet.net.tr[81.215.118.236]
dsl81-215-30614.adsl.ttnet.net.tr[81.215.119.150]
dsl81-215-30905.adsl.ttnet.net.tr[81.215.120.185]
dsl81-215-4517.adsl.ttnet.net.tr[81.215.17.165]
dsl81-215-53937.adsl.ttnet.net.tr[81.215.210.177]
dsl81-215-54155.adsl.ttnet.net.tr[81.215.211.139]
dsl81-215-54618.adsl.ttnet.net.tr[81.215.213.90]
dsl81-215-55123.adsl.ttnet.net.tr[81.215.215.83]
dsl81-215-62680.adsl.ttnet.net.tr[81.215.244.216]
dsl-hmlgw1he3.dial.inet.fi[80.220.227.227]
dsl-mm224.ez-net.com[65.172.188.109]
gv-vb-3c9f.adsl.wanadoo.nl[212.129.188.159]
h00061bda6f73.ne.client2.attbi.com[24.218.168.78]
h00095b733a11.ne.client2.attbi.com[65.96.237.21]
h00095b733a11.ne.client2.attbi.com[65.96.239.10]
h00096b197238.ne.client2.attbi.com[24.61.250.89]
h000ea69e7af4.ne.client2.attbi.com[24.128.63.191]
h0011110f7ab3.ne.client2.attbi.com[24.128.58.142]
h00118018fafb.ne.client2.attbi.com[24.128.215.26]
h0040ca40da7b.ne.client2.attbi.com[24.91.82.249]
h00e06fbe43f5.ne.client2.attbi.com[66.31.5.211]
kf-sdm-tg06-0727.dial.kabelfoon.nl[62.45.194.216]
lbc9-d9ba927f.pool.mediaWays.net[217.186.146.127]
lbc9-d9ba9291.pool.mediaWays.net[217.186.146.145]
lbc9-d9ba92ac.pool.mediaWays.net[217.186.146.172]
lbck-d9b886b3.pool.mediaWays.net[217.184.134.179]
lls-c-1e8a1.adsl.wanadoo.nl[81.70.6.161]
mstr195175-28763.dial-in.ttnet.net.tr[195.175.192.92]
mstr195175-28807.dial-in.ttnet.net.tr[195.175.192.136]
mstr195175-29523.dial-in.ttnet.net.tr[195.175.195.84]
mstr195175-29524.dial-in.ttnet.net.tr[195.175.195.85]
mstr195175-29617.dial-in.ttnet.net.tr[195.175.195.178]
mstr195175-30261.dial-in.ttnet.net.tr[195.175.198.54]
mstr195175-30277.dial-in.ttnet.net.tr[195.175.198.70]
mstr195175-30294.dial-in.ttnet.net.tr[195.175.198.87]
mstr195175-30405.dial-in.ttnet.net.tr[195.175.198.198]
mstr195175-30425.dial-in.ttnet.net.tr[195.175.198.218]
Ottawa-HSE-ppp4085231.sympatico.ca[70.49.34.242]
oxfo-dhcp-ws-186.dsl.maqs.net[66.187.40.187]
oxford-dsl-26.swnebr.net[69.2.6.155]
p3E9E4915.dip.t-dialin.net[62.158.73.21]
p3EE0A92D.dip.t-dialin.net[62.224.169.45]
p50823AF8.dip.t-dialin.net[80.130.58.248]
p5082557F.dip0.t-ipconnect.de[80.130.85.127]
p50837D68.dip0.t-ipconnect.de[80.131.125.104]
p50837F3A.dip0.t-ipconnect.de[80.131.127.58]
p50923A15.dip.t-dialin.net[80.146.58.21]
p54856CB1.dip.t-dialin.net[84.133.108.177]
p54857A2B.dip.t-dialin.net[84.133.122.43]
p5485901E.dip0.t-ipconnect.de[84.133.144.30]
p548C8DE6.dip.t-dialin.net[84.140.141.230]
pcp0010439227pcs.parads01.nm.comcast.net[68.35.123.64]
pcp0010846152pcs.essex01.md.comcast.net[68.48.130.57]
pcp0011134165pcs.neave01.pa.comcast.net[69.248.43.94]
pcp0011537562pcs.aboit01.in.comcast.net[69.245.133.123]
pcp01934410pcs.nhaven01.ct.comcast.net[68.63.87.156]
pcp02171061pcs.brghtn01.mi.comcast.net[68.43.207.125]
pcp02861817pcs.flrnc01.al.comcast.net[68.62.232.163]
pcp03267103pcs.waldlk01.mi.comcast.net[68.60.178.140]
pcp03766529pcs.montvl01.pa.comcast.net[68.34.242.208]
pcp03822180pcs.clintn01.ct.comcast.net[68.46.210.153]
pcp04591547pcs.harimn01.tn.comcast.net[68.47.189.215]
pcp08020054pcs.dalect01.va.comcast.net[68.48.155.156]
pcp08774927pcs.mtlrel01.nj.comcast.net[68.36.36.37]
pcp08935357pcs.trentn01.nj.comcast.net[69.141.145.106]
pcp09003316pcs.spedwy01.in.comcast.net[68.58.13.174]
pcp09946743pcs.hyatsv01.md.comcast.net[69.140.15.206]
pD9503DE4.dip.t-dialin.net[217.80.61.228]
pD9521AC6.dip.t-dialin.net[217.82.26.198]
pD952496A.dip.t-dialin.net[217.82.73.106]
pD95256B2.dip.t-dialin.net[217.82.86.178]
pD95314D1.dip.t-dialin.net[217.83.20.209]
pD9542A7A.dip.t-dialin.net[217.84.42.122]
pD954ADEB.dip.t-dialin.net[217.84.173.235]
pD955E999.dip.t-dialin.net[217.85.233.153]
pD95731A6.dip0.t-ipconnect.de[217.87.49.166]
pD958902E.dip.t-dialin.net[217.88.144.46]
pD9589A3B.dip.t-dialin.net[217.88.154.59]
pD95EEF12.dip.t-dialin.net[217.94.239.18]
pD95F43DE.dip0.t-ipconnect.de[217.95.67.222]
pD95F46CE.dip0.t-ipconnect.de[217.95.70.206]
pD95F4828.dip0.t-ipconnect.de[217.95.72.40]
pD95F484B.dip0.t-ipconnect.de[217.95.72.75]
pD9E182A1.dip.t-dialin.net[217.225.130.161]
pD9E44064.dip.t-dialin.net[217.228.64.100]
pD9E488B2.dip.t-dialin.net[217.228.136.178]
pD9E59AA3.dip.t-dialin.net[217.229.154.163]
pD9FE2D54.dip0.t-ipconnect.de[217.254.45.84]
poctnt-1-235.dialup.enter.net[216.193.169.15]
ppp2582.hakata01.bbiq.jp[210.203.194.42]
rt-z-23c40.adsl.wanadoo.nl[81.70.90.64]
S01060000b4921e35.cg.shawcable.net[68.145.237.24]
S01060001023fd7dc.cg.shawcable.net[68.144.193.49]
S01060004e20311de.ed.shawcable.net[68.149.226.216]
S010600055d29d6f0.vc.shawcable.net[24.85.71.78]
S010600065b1cf9d8.vc.shawcable.net[24.86.104.115]
S0106000795aeb64d.vc.shawcable.net[24.80.152.113]
S01060008a10ccf19.vf.shawcable.net[70.68.209.121]
S01060008a10ccf19.vf.shawcable.net[70.68.244.221]
S01060008a11e94cc.ed.shawcable.net[68.149.249.248]
S0106000b6a93aadb.vc.shawcable.net[24.84.40.203]
S0106000bdb0e2be7.ok.shawcable.net[24.70.174.225]
S0106000c7615dd58.wp.shawcable.net[24.77.235.208]
S01060010a4991948.cg.shawcable.net[68.146.151.175]
S010600112f46d19f.vc.shawcable.net[24.83.7.214]
S01060040ca4003c4.wp.shawcable.net[24.77.99.183]
S01060060b0a3cd95.ed.shawcable.net[68.150.64.140]
S01060080c6ee43f8.vs.shawcable.net[24.84.102.153]
S01060080c876a2df.vc.shawcable.net[24.83.21.154]
S01060080c8e2e5a7.ed.shawcable.net[68.149.0.81]
S01060090f52ad732.ed.shawcable.net[68.150.31.145]
S010600d0b7c4df4a.ed.shawcable.net[68.151.5.108]
user-0c6t3il.cable.mindspring.com[24.110.142.85]
user-0c8htoa.cable.mindspring.com[24.136.247.10]
user-0ccstki.cable.mindspring.com[24.206.118.146]
user-0cdveau.cable.mindspring.com[24.223.185.94]
user-0cetrmf.cable.mindspring.com[24.238.238.207]
user-10lf4ta.cable.mindspring.com[65.87.147.170]
user-10lf97p.cable.mindspring.com[65.87.164.249]
user-12hc73a.cable.mindspring.com[69.22.28.106]
user-12hcc0d.cable.mindspring.com[69.22.48.13]
user-12hcqi5.cable.mindspring.com[69.22.106.69]
user-12hcqph.cable.mindspring.com[69.22.107.49]
user-12l2ttt.cable.mindspring.com[69.81.119.189]
user-12ldaom.cable.mindspring.com[69.86.171.22]
user-12lm16t.cable.mindspring.com[69.91.4.221]
user-12lm33c.cable.mindspring.com[69.91.12.108]
user-12lmp25.cable.mindspring.com[69.91.100.69]
xdsl-2836.walbrzych.dialog.net.pl[84.40.186.20]
xdsl-4689.zgora.dialog.net.pl[84.40.166.81]
xdsl-4875.wroclaw.dialog.net.pl[84.40.128.11]
xdsl-7183.wroclaw.dialog.net.pl[84.40.137.15]

--=20
Michel Bouissou <mi...@bo...> OpenPGP ID 0xDDE8AC6E