Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

13. ... r-q1


computers / news.software.nntp / Re: Renumber articles by posting date?

SubjectAuthor
* Renumber articles by posting date?Jesse Rehmer
`* Re: Renumber articles by posting date?Julien ÉLIE
 `- Re: Renumber articles by posting date?Julien ÉLIE

1
Renumber articles by posting date?

<0745151644.8be5251d@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=1086&group=news.software.nntp#1086

  copy link   Newsgroups: news.software.nntp
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!news.usenet.blueworldhosting.com!.POSTED!not-for-mail
From: jesse.re...@blueworldhosting.com (Jesse Rehmer)
Newsgroups: news.software.nntp
Subject: Renumber articles by posting date?
Date: Sat, 6 Aug 2022 17:37:32 -0000 (UTC)
Organization: BlueWorld Hosting Usenet (https://usenet.blueworldhosting.com)
Message-ID: <0745151644.8be5251d@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=fixed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 6 Aug 2022 17:37:32 -0000 (UTC)
Injection-Info: news.usenet.blueworldhosting.com;
logging-data="86845"; mail-complaints-to="usenet@blueworldhosting.com"
User-Agent: Usenapp for MacOS
Cancel-Lock: sha1:tPsrg/fB7SwNxD/G5XGh++aQix4= sha256:RMjgQeMxLPhv/lrBvhODRARQHShVQ8Mu2aqgP69O75Y=
sha1:s+InWfie/m3PNTPHINGT6bVEGxU= sha256:Mqa9R8bUwPDlMd9x+/m+HNZdxEF2aQ/judQvoAQssuc=
X-Usenapp: v1.22/d - Full License
 by: Jesse Rehmer - Sat, 6 Aug 2022 17:37 UTC

Is there a way one can renumber articles contained on a INN tradspool in
chronological order?

I've been pulling in articles over time from various sources, so I have a wide
range of article numbers and posting dates that are out of sequence. When a
newsreader fetches X number of headers it may get some articles from 2003 and
some from 2022, but be missing a lot in between until all headers are loaded
and the reader sorts by the Date header.

I've been thinking that INN stores the posting date as one of the values in
the history file, there may be some way to do this, perhaps not in place, but
I'm not sure how to sort the input for innxmit. I am thinking if I can figure
out how to do that I could seed another server and then retire the current
one.

I do not have any readers besides myself at the moment, still getting
everything "just right", so I'm not worried about article renumbering issues
from that angle.

Cheers,

Jesse

Re: Renumber articles by posting date?

<tcmfnv$35klc$1@news.trigofacile.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=1087&group=news.software.nntp#1087

  copy link   Newsgroups: news.software.nntp
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.trigofacile.com!.POSTED.176-143-2-105.abo.bbox.fr!not-for-mail
From: iul...@nom-de-mon-site.com.invalid (Julien ÉLIE)
Newsgroups: news.software.nntp
Subject: Re: Renumber articles by posting date?
Date: Sat, 6 Aug 2022 21:34:22 +0200
Organization: Groupes francophones par TrigoFACILE
Message-ID: <tcmfnv$35klc$1@news.trigofacile.com>
References: <0745151644.8be5251d@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 6 Aug 2022 19:34:23 -0000 (UTC)
Injection-Info: news.trigofacile.com; posting-account="julien"; posting-host="176-143-2-105.abo.bbox.fr:176.143.2.105";
logging-data="3330732"; mail-complaints-to="abuse@trigofacile.com"
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.12.0
Cancel-Lock: sha1:EJxYgLUgvMfT6Bh+ZrEIwsq96mk= sha256:ZU8GXhPc7TBcZvA6SLd5y01CalbkrSos0Z4BhqXqZ0A=
sha1:Wj6QxFEyR2HMUcZIhuazabFWHi8= sha256:8wJo1EvQ1GCynnUbeJJpJANfzNa+bHiGQanGkTEJAK4=
In-Reply-To: <0745151644.8be5251d@dont-email.me>
 by: Julien ÉLIE - Sat, 6 Aug 2022 19:34 UTC

Hi Jesse,

> Is there a way one can renumber articles contained on a INN tradspool in
> chronological order?
>
> I've been thinking that INN stores the posting date as one of the values in
> the history file, there may be some way to do this, perhaps not in place, but
> I'm not sure how to sort the input for innxmit.

Exactly!
The third timestamp in the history file (1632832725 in the example
below) is the posting time.

[8FEB593A03B03416C6AD1CED669BC442] 1632832728~-~1632832725
@030346523100000000000000002800000001@

I would suggest to sort the history file with that field, and keep the
token in the output

sort -t '~' -k3n | cut -f 3 < history > tokens.sorted

will do that I think.
You'll obtain an ordered list of article storage tokens by posting time.

This file is a suitable entry for innxmit. If present in
<pathoutgoing>, then run "innxmit your.news.server tokens.sorted" and
they will be fed to your new news server in the expected order.

--
Julien ÉLIE

« – Alors j'ai eu une idée géniale : ramener à César un des Gaulois
irréductibles de la région !
– Mais, préfet, ces Gaulois irréductibles ont un grand défaut !
– Ah ? Lequel ?
– C'est qu'ils sont irréductibles justement ! » (Astérix)

Re: Renumber articles by posting date?

<tcmgge$35l0l$1@news.trigofacile.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=1088&group=news.software.nntp#1088

  copy link   Newsgroups: news.software.nntp
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.trigofacile.com!.POSTED.san13-h02-176-143-2-105.dsl.sta.abo.bbox.fr!not-for-mail
From: iul...@nom-de-mon-site.com.invalid (Julien ÉLIE)
Newsgroups: news.software.nntp
Subject: Re: Renumber articles by posting date?
Date: Sat, 6 Aug 2022 21:47:26 +0200
Organization: Groupes francophones par TrigoFACILE
Message-ID: <tcmgge$35l0l$1@news.trigofacile.com>
References: <0745151644.8be5251d@dont-email.me>
<tcmfnv$35klc$1@news.trigofacile.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 6 Aug 2022 19:47:26 -0000 (UTC)
Injection-Info: news.trigofacile.com; posting-account="julien"; posting-host="san13-h02-176-143-2-105.dsl.sta.abo.bbox.fr:176.143.2.105";
logging-data="3331093"; mail-complaints-to="abuse@trigofacile.com"
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
Gecko/20100101 Thunderbird/91.12.0
Cancel-Lock: sha1:LtMNoVDdgojmGLkmFgQOR+E+hUo= sha256:GWFUPeqeElcgJ8Xio3tPlxcTUw2La753N8kVB7zQCi8=
sha1:8OkeyrZHHRTm4YztY8ZtGgSrxtU= sha256:rvqcFrZKfdsben7tw57Lu1YqF9eyZSx/E2b8MzdlPX0=
In-Reply-To: <tcmfnv$35klc$1@news.trigofacile.com>
 by: Julien ÉLIE - Sat, 6 Aug 2022 19:47 UTC

>   sort -t '~' -k3n | cut -f 3 < history > tokens.sorted

It will be better with parenthesis, sorry... (I had tested with "head
history | sort -t '~' -k3n | cut -f 3" but not what I wrote).

(sort -t '~' -k3n | cut -f 3) < history > tokens.sorted

--
Julien ÉLIE

« – Heureusement, nous aurons bientôt le TGV !
– C'est quoi le tégévé ?
– C'est le Transport Gaulois Véloce. » (Astérix)

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor