Re: New basicbot module for accessing botnow.db data

[izzyb <izzyb@xxxxxxxxxxxxxxx>]

Hello codeforce,

This is a progress update on this project.  Its coming along nicely.  
Should be a very useful tool for investigating abuse and for getting 
info on users you're trying to support.  I've also started an IRCNOW 
library I'll be publishing soon also. It'll house the common code needed 
to access ircnow data sources.  It currently knows about the botnow 
database and the znc log file. I'll add other logs and data sources as 
it develops.  It now only responds in private message with private data 
and requires you to have authenticated with the bot to get data from 
it.  Let me know if you would like to see anything added to its data 
sources or output.

Here's the output of the updated help message.

15:33 <izzyb> help botnowdb
15:33 <ponBot> botnowdb: Database interface for botnow.db
15:33 <ponBot> ..  botnow User <username>
15:33 <ponBot> ..  botnow email <email address>
15:33 <ponBot> ..  botnow ip <IP Address>

Here's output of botnow user.  It now shows last irc activity and last 
znc login.  This is my nick.

15:45 <izzyb> botnow user izzyb
15:45 <ponBot> izzyb: izzyb@xxxxxxxxxxxxxxxxxxxxxxxxx
15:45 <ponBot> ..ZNC Last Connected: 2023-05-16 16:04:45
15:45 <ponBot> ..Last Seen: 2023-05-18 21:45:06 in msg
15:45 <ponBot> ..<private message>.
15:45 <ponBot> ..2022-03-12 22:31:39 --
15:45 <ponBot> ..2023-05-16 20:04:45 -- 104.157.94.37
15:45 <ponBot> ..2023-03-20 23:43:58 -- 
2001:56a:fb72:6400:b1b0:5f71:a73c:d784
15:45 <ponBot> ..2023-03-20 23:43:47 -- 199.7.159.16
15:45 <ponBot> ..2023-02-27 04:14:14 -- 75.158.138.249
15:45 <ponBot> ..2022-11-19 01:16:05 -- 38.87.162.182
15:45 <ponBot> ..2022-11-01 20:02:29 -- 2602:fccf:1:1182::
15:45 <ponBot> ..2022-06-27 20:19:11 -- 199.7.159.46
15:45 <ponBot> ..2022-06-15 22:51:19 -- 68.148.177.239
15:45 <ponBot> ..2022-06-15 19:56:55 -- 199.119.235.167
15:45 <ponBot> ..2022-04-15 02:06:57 -- 199.119.235.211
15:45 <ponBot> ..2022-04-15 00:13:08 -- 
2604:3d09:6988:57d0:8428:b019:f9fd:8da0

Here's output of botnow ip. This was a cloner removed back in February.

15:40 <izzyb> botnow ip 88.235.231.84
15:40 <ponBot> 2023-02-03 08:40:59 -- Aslan
15:40 <ponBot> ..2023-02-03 08:39:51 -- Aysu
15:40 <ponBot> ..2023-02-03 08:42:06 -- CMYLMZ
15:40 <ponBot> ..2023-02-03 08:46:29 -- Danger
15:40 <ponBot> ..2023-02-03 09:01:57 -- El
15:40 <ponBot> ..2023-02-03 08:37:09 -- Gokhan
15:40 <ponBot> ..2023-02-03 09:27:21 -- Kedi
15:40 <ponBot> ..2023-02-03 08:38:50 -- Kekebek
15:40 <ponBot> ..2023-02-03 08:51:01 -- KoTuCoCuK
15:40 <ponBot> ..2023-02-03 09:00:46 -- Lidia
15:40 <ponBot> ..2023-02-03 08:47:14 -- Lord
15:40 <ponBot> ..2023-02-03 08:56:54 -- MitNick
15:40 <ponBot> ..2023-02-03 10:17:37 -- Mobilci
15:40 <ponBot> ..2023-02-03 08:27:04 -- Network
15:40 <ponBot> ..2023-02-03 10:12:04 -- Number1
15:40 <ponBot> ..2023-02-03 09:07:09 -- Oya
15:40 <ponBot> ..2023-02-03 08:58:42 -- Park
15:40 <ponBot> ..2023-02-03 09:05:58 -- Psyc
15:40 <ponBot> ..2023-02-03 08:35:53 -- Pusu
15:40 <ponBot> ..2023-02-03 09:03:40 -- SaLTaNaT
15:40 <ponBot> ..2023-02-03 08:43:39 -- SoRRy
15:40 <ponBot> ..2023-02-03 08:49:16 -- Subzero
15:40 <ponBot> ..2023-02-03 08:34:45 -- System
15:40 <ponBot> ..2023-02-03 09:28:00 -- TeKSeN
15:41 <ponBot> ..2023-02-03 08:44:57 -- Tiky
15:41 <ponBot> ..2023-02-03 09:10:02 -- Trabzon
15:41 <ponBot> ..2023-02-03 08:33:43 -- cashmare
15:41 <ponBot> ..2023-02-03 08:42:06 -- erdogan
15:41 <ponBot> ..2023-02-03 09:07:35 -- gokay
15:41 <ponBot> ..2023-02-03 08:59:33 -- kedi
15:41 <ponBot> ..2023-02-03 08:51:08 -- yusuf

...Izzy

On 2023-05-15 14:03, izzyb wrote:
> Hello codeforce,
>
> I've started a plugin for Bot::BasicBot::Pluggable that can access the 
> botnow database data.  The goal is to provide team members with useful 
> data from the database to support users or investigate abuse.  It'll 
> be a tool to assist with
>
> https://wiki.ircnow.org/index.php?n=Police.Fingerprints
>
> I would like to make the process easier while also limiting how much 
> data team members have access to.  In part to limit how much data they 
> have to wade through, but also to reduce how much data can be leaked 
> about our users should we have bad actors among us. I intend to add 
> data from other sources like the logs and to enable it to exchange 
> data with other bots to provide a decentralized way to investigate 
> abusers.  The code is available here:
>
> https://got.ircnow.org/cgi-bin/gotweb/gotweb?path=basicbot-botnowDB&action=summary 
>
>
> Ponbot is currently using it.  Teams can create their own bots using 
> the following these instructions to create a Bot::BasicBot::Pluggable 
> bot of their own.
>
> https://wiki.ircnow.org/index.php?n=Bots.Basicbot
>
> Feel free to ask for assistance in irc or email if you have issues.  
> Ianj also built a centralized database this plugin can use as a 
> datasource.  I'll add support for accessing it once I have connection 
> details.  Ianj, could you also publish details about the database 
> redesign you did?  Think it is an appropriate place to discuss 
> redesign of the database also.
>
> If anyone has ideas or suggestions for other data sources that would 
> help with this let me know or contribute a patch to the list.  Guess I 
> should do a document on submitting patches in email via git/got.
>
> ...Izzy