• Deleting a newsgroup and all its data in Rocksolid Light

    From Byrl Raze Buckbriar@news0@octade.net to rocksolid.nodes.help on Fri Sep 20 05:00:22 2024
    From Newsgroup: rocksolid.nodes.help

    --Signature=_Fri__20_Sep_2024_00_00_31_-0500_gC31ZCm+wED5dZo4
    Content-Type: text/plain; charset=US-ASCII
    Content-Disposition: inline
    Content-Transfer-Encoding: quoted-printable

    I want to delete a newsgroup and scrub every vestige of its data and histor=
    y from the spool directory without breaking something. So I want nothing re= garding that newsgroup left in the spool databases, as if the group had nev=
    er been added in the first place.

    How might I do this?

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

    --Signature=_Fri__20_Sep_2024_00_00_31_-0500_gC31ZCm+wED5dZo4
    Content-Type: application/pgp-signature

    -----BEGIN PGP SIGNATURE-----

    iHUEARYIAB0WIQRneuMjkp+P7n1uq4moad1ZYOZmFwUCZu0BbwAKCRCoad1ZYOZm F4yRAP4l52O17SzwP9y3txcWo5nAVlCBqh7lGwBA63uoLKzztgEA0FQWenpCk2ez YXnI9vpJCvB5SVlA+qfRMfT9QjxziAA=
    =dYEE
    -----END PGP SIGNATURE-----

    --Signature=_Fri__20_Sep_2024_00_00_31_-0500_gC31ZCm+wED5dZo4--
    --- Synchronet 3.21a-Linux NewsLink 1.2
  • From Marco Moock@mm+usenet-es@dorfdsl.de to rocksolid.nodes.help on Fri Sep 20 10:35:42 2024
    From Newsgroup: rocksolid.nodes.help

    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

    --- Synchronet 3.21a-Linux NewsLink 1.2
  • From Retro Guy@retroguy@novabbs.com to rocksolid.nodes.help on Fri Sep 20 10:51:28 2024
    From Newsgroup: rocksolid.nodes.help

    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
    --- Synchronet 3.21a-Linux NewsLink 1.2