Rocksolid Light

News from da outaworlds

mail  files  register  groups  login

Message-ID:  

BOFH excuse #163: no "any" key on keyboard

rocksolid / Rocksolid Nodes Help / Deleting a newsgroup and all its data in Rocksolid Light

SubjectAuthor
* Deleting a newsgroup and all its data in Rocksolid LightByrl Raze Buckbriar
`* Re: Deleting a newsgroup and all its data in Rocksolid LightMarco Moock
 `- Re: Deleting a newsgroup and all its data in Rocksolid LightRetro Guy

1
Subject: Deleting a newsgroup and all its data in Rocksolid Light
From: Byrl Raze Buckbriar
Newsgroups: rocksolid.nodes.help
Organization: OCTADE
Date: Fri, 20 Sep 2024 05:00 UTC
Attachments: unnamed (application/pgp-signature)
Path: eternal-september.org!news.eternal-september.org!feeder3.eternal-september.org!i2pn.org!i2pn2.org!.POSTED!not-for-mail
From: news0@octade.net (Byrl Raze Buckbriar)
Newsgroups: rocksolid.nodes.help
Subject: Deleting a newsgroup and all its data in Rocksolid Light
Date: Fri, 20 Sep 2024 05:00:22 +0000
Organization: OCTADE
Message-ID: <45b8a55eba247c6074470cd641bea8f8$1@octade.net>
MIME-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature";
micalg="PGP-SHA256";
boundary="Signature=_Fri__20_Sep_2024_00_00_31_-0500_gC31ZCm+wED5dZo4"
Injection-Info: i2pn2.org;
logging-data="2725548"; mail-complaints-to="usenet@i2pn2.org";
posting-account="OI6weT9bZt7saiRF3+XsJJTIMUPjpyh/q6ChV6DtztU";
User-Agent: OCTADE
X-Spam-Checker-Version: SpamAssassin 4.0.0
X-Newsreader: OCTADE
View all headers

I want to delete a newsgroup and scrub every vestige of its data and history from the spool directory without breaking something. So I want nothing regarding that newsgroup left in the spool databases, as if the group had never been added in the first place.

How might I do this?

--
Byrl Raze Buckbriar . OCTADE . < https://octade.net >
Hacker Hotline . voice & SMS . (781) OCT-AGON
KeyOxide . < https://keyoxide.org/keyoxide0@octade.net >

Attachments: unnamed (application/pgp-signature)
Subject: Re: Deleting a newsgroup and all its data in Rocksolid Light
From: Marco Moock
Newsgroups: rocksolid.nodes.help
Organization: A noiseless patient Spider
Date: Fri, 20 Sep 2024 08:35 UTC
References: 1
Path: eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: mm+usenet-es@dorfdsl.de (Marco Moock)
Newsgroups: rocksolid.nodes.help
Subject: Re: Deleting a newsgroup and all its data in Rocksolid Light
Date: Fri, 20 Sep 2024 10:35:42 +0200
Organization: A noiseless patient Spider
Lines: 21
Message-ID: <vcjc4v$104eh$1@dont-email.me>
References: <45b8a55eba247c6074470cd641bea8f8$1@octade.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 20 Sep 2024 10:35:43 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="580a66b53aeec27d73679e087bba87c3";
logging-data="1053137"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18VfaaIEfkbvyhesd+dNYW6"
Cancel-Lock: sha1:2sgiUOs6z5bZeRvNrLLZ9rfD6vs=
View all headers

On 20.09.2024 um 05:00 Uhr Byrl Raze Buckbriar wrote:

> I want to delete a newsgroup and scrub every vestige of its data and
> history from the spool directory without breaking something. So I
> want nothing regarding that newsgroup left in the spool databases, as
> if the group had never been added in the first place.
>
> How might I do this?

I did this by removing it from the groups.txt file, then deleting the
sqlite databases from /var/spool/rslight.
After some time it should also disappear from the website group
overview.
The articles are already unavailable after deleting the sqlite stuff.

--
kind regards
Marco

Send spam to 1726801222muell@cartoonies.org

Subject: Re: Deleting a newsgroup and all its data in Rocksolid Light
From: Retro Guy
Newsgroups: rocksolid.nodes.help
Organization: Rocksolid Light
Date: Fri, 20 Sep 2024 10:51 UTC
References: 1 2
Path: eternal-september.org!news.eternal-september.org!feeder3.eternal-september.org!i2pn.org!i2pn2.org!.POSTED!not-for-mail
From: retroguy@novabbs.com (Retro Guy)
Newsgroups: rocksolid.nodes.help
Subject: Re: Deleting a newsgroup and all its data in Rocksolid Light
Date: Fri, 20 Sep 2024 10:51:28 +0000
Organization: Rocksolid Light
Message-ID: <c9e864121482ee2779855f866136e9cc@www.novabbs.org>
References: <45b8a55eba247c6074470cd641bea8f8$1@octade.net> <vcjc4v$104eh$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Info: i2pn2.org;
logging-data="2753697"; mail-complaints-to="usenet@i2pn2.org";
posting-account="gg+dDWHMzVrdxGO9Gmt8aqyeWDXqlxfqiuS0jX/WMXY";
User-Agent: Rocksolid Light
X-Rslight-Posting-User: a93aefeeff923def71455caae2dbfb277a59e046
X-Face: .&YR-G(w(DZ$$,}%k=]*5*!p'=(anr"IT`wZG'2VWdfl\r)l[42u7JH`n(JUQ*e5*A|XCDf
?&\X&uwkl38"CYX3O8m}C8E4p'%N$2#kSTVzx{Ly|DjLT\Vk7NE}NQ(VC$Yq]i:7|z[.9iv^g>*8_B
H0=hZt'[%)4kG|
X-Spam-Checker-Version: SpamAssassin 4.0.0
X-Rslight-Site: $2y$10$vNr8YVAAiBL1Ex0ZXC/AsOGJ4XqtEXxV4398S/xlLNqjYkvMwuKn.
View all headers

On Fri, 20 Sep 2024 8:35:42 +0000, Marco Moock wrote:

> On 20.09.2024 um 05:00 Uhr Byrl Raze Buckbriar wrote:
>
>> I want to delete a newsgroup and scrub every vestige of its data and
>> history from the spool directory without breaking something. So I
>> want nothing regarding that newsgroup left in the spool databases, as
>> if the group had never been added in the first place.
>>
>> How might I do this?
>
> I did this by removing it from the groups.txt file, then deleting the
> sqlite databases from /var/spool/rslight.
> After some time it should also disappear from the website group
> overview.
> The articles are already unavailable after deleting the sqlite stuff.

Run <config_dir>/scripts/maintenance.php:
-help: This help page
-version: Display version
******************* IMPORTANT **************************
*** PLEASE DISABLE cron.php WHEN RUNNING THIS SCRIPT ***
********************************************************
-clean: Remove extraneous group db3 files
-import: Import articles from a .db3 file (-import alt.test-articles)
You must first add group name to
<config_dir>/<section>/groups.txt manually
-remove: Remove all data for a group (-remove alt.test)
You must also remove group name from
<config_dir>/<section>/groups.txt manually
-reset: Reset a group to restart from zero messages (-reset alt.test)

When you run it with '-remove', it will remove all data from the group
from the overview db and history db.

It will also delete all spool files related to the group, except the
article database, which it will rename to
<group-name>-articles.db3-removed, which you may then delete.

--
Retro Guy

1

rocksolid light 0.9.8
clearnet tor