Provided by: inn2_2.7.2~20240212-1build3_amd64 bug

NAME

       tdx-util - Overview manipulation utility for tradindexed

SYNOPSIS

       tdx-util [-AFcgioO] [-a article] [-f status] [-n newsgroup] [-p path] [-R path]

DESCRIPTION

       tdx-util is an administrative interface to the tradindexed overview method for INN.  It only works on
       tradindexed overview databases, not on any other type of INN overview.  (See dedicated ovdb_stat(8) and
       ovsqlite-util(8) programs for ovdb and ovqslite overview methods.)  It allows the administrator to dump
       various information about the internal state of the overview, audit it for errors, and rebuild portions
       of the overview database.

       The tradindexed overview method should lock properly and therefore it should be safe to run this utility
       and perform any operation it performs, including full repairs or per-group overview rebuilds, while the
       server is running.  However, note that some of the operations performed by this utility can take an
       extended period of time and will hold locks in the overview database during that period, which depending
       on what the server is doing may cause the server to stall until tdx-util completes its operation.

       The dump operations are -i, which dumps the master index for the overview database, -g, which dumps the
       index for an individual group, and -o and -O, which dump the overview information for a particular group
       (including the additional metadata stored in the index) in two different formats.  For -g, -o, and -O,
       the -n option must also be given to specify a newsgroup to operate on.

       To add a new newsgroup to the overview database, use -c.  A group must be specified with -n.  If the
       group status is something other than "y", it should be specified with -f, and the low and high article
       numbers may be specified with -a.  If only one number is given rather than a range, it will be taken to
       be the high water mark and the low mark will be set to 1.

       To audit the entire overview database for problems, use -A.  Any problems found will be reported to
       standard error.  Use -F to correct the errors found.

       To rebuild the database for a particular newsgroup, use -R.  The -R option takes a path to a directory
       which contains all of the articles for that newsgroup, one per file.  The names of the files must be the
       numbers of the articles in that group.  (In other words, this directory must be a traditional spool
       directory for that group.)  The -n option must also be given to specify the newsgroup for which the
       overview is being rebuilt.

       For all operations performed by tdx-util, a different overview database than the one specified in
       inn.conf may be specified using the -p option.

       The number of overview records stored in the database can be obtained with the "inndf -n" command.

OPTIONS

       -a article
           The  article  number  or  numbers  to  act on.  article is a valid NNTP range, meaning that it can be
           either a single article number or a range of article numbers (like "1-5").  Either the start  or  the
           end  (or  both)  of  the  range  may  be omitted, in which case they will be set to the first or last
           article number in the group.  Passing "-" for article is therefore equivalent to  not  using  the  -a
           option at all.

           Only  useful  in  combination  with  the -o and -O options to dump overview information or with -c to
           specify the low and high article numbers when creating a group.

       -A  Audit the entire overview database for problems.  This runs the  internal  consistency  checks  built
           into  the  tradindexed overview implementation, checking such things as the validity and reachability
           of all group index entries, the format of the individual  overview  entries,  the  correspondence  of
           index  entries  to  overview data, and similar such things.  No changes will be made to the database,
           but problems will be reported to standard error.

       -c  Create a new group in the overview database.  The group must be specified  with  -n.   The  newsgroup
           status  defaults  to "y" but may be set with -f.  The low and high article numbers default to 1 and 0
           respectively, but may be set with -a.  If only one number is given to -a, it is  taken  as  the  high
           article number.

       -F  Audit  the  entire  overview  database  for problems, fixing them as they're detected where possible.
           This runs the internal  consistency  checks  built  into  the  tradindexed  overview  implementation,
           checking  such  things as the validity and reachability of all group index entries, the format of the
           individual overview entries, the correspondence of index entries to overview data, and  similar  such
           things.   The  strategy  used  when fixing problems is to throw away data that's unrecoverable, so be
           warned that using this option may result in inaccessible articles if their  overview  data  has  been
           corrupted.

           To see what would be changed by -F, run tdx-util with -A first.

       -f status
           When  creating  a  newsgroup  with -c, set the status of the newly created group to status instead of
           "y".  Only useful with -c.

       -g  Dump the index of a particular group.  The fields are, in order, the article number,  the  offset  of
           the  data for that article in the overview data file for that group, the length of the overview data,
           the time (in seconds since epoch) when the article arrived on the server, the time (in seconds  since
           epoch)  when the article should expire based on its Expires header field (or 0 if there is no Expires
           header field), and the storage API token of the article.

           If this option is given, the -n option must also be given to specify the newsgroup on which to act.

       -i  Dump the master index of the overview database.  This contains  similar  information  to  the  server
           active  file,  such  as  high  and low water marks and moderation status, and is the information that
           nnrpd hands out to clients.

           The fields are, in order, the newsgroup name, the high water mark,  the  low  water  mark,  the  base
           article  number  (the point at which the group index begins), the count of articles in the group, the
           group status, the time (in seconds since epoch) when that newsgroup was deleted or  0  if  it  hasn't
           been, and the inode of the index file for that group.

           A  particular  newsgroup  can be specified with the -n option.  If -n is not given, the entire master
           index will be dumped.

       -n newsgroup
           Specify the newsgroup on which to act, required for the -c, -g, -o, -O, and -R options, and  optional
           for the -i option.

       -o  Dump  the overview information for a newsgroup, in the same format as it would be returned to clients
           but with one modification.  Appended to the end of each entry will be four additional pieces of data:
           the article number according to the index file for that group labelled with "Article:",  the  storage
           API token for that article labelled with "Token:", the arrival date for that article on the server in
           RFC 5322  date  format  labelled  with "Arrived:", and the expiration date for that article (from the
           Expires header field) in RFC 5322 date format if there is any, labelled with "Expires:".

           If this option is given, the -n option must also be given to specify the newsgroup on which  to  act.
           By  default,  all  of the overview information for that newsgroup is dumped, but the -a option may be
           given to restrict the dump to the information for a single article or a range of article numbers.

       -O  Dump the overview information for a newsgroup in the format used by overchan  as  input.   Each  line
           will  start  with  the  storage  API token, the arrival timestamp in seconds since epoch, the expires
           timestamp in the same format (or 0 if there is no Expires header field), and then the overview data.

           If this option is given, the -n option must also be given to specify the newsgroup on which  to  act.
           By  default,  all  of the overview information for that newsgroup is dumped, but the -a option may be
           given to restrict the dump to the information for a single article or a range of article numbers.

       -p path
           Act on the overview database rooted in path, overriding the overview path specified in inn.conf.

       -R path
           Rebuild the overview for a given group from the articles stored in path.  The articles must be in the
           form of a traditional spool directory; in other words, each article must be in a  separate  file  and
           the name of the file must match the article number of the article.

           If this option is given, the -n option must also be given to specify the newsgroup on which to act.

EXAMPLES

       Dump  the  master  index  for  the  overview  database in /news/overview, regardless of the overview path
       specified in inn.conf:

           tdx-util -i -p /news/overview

       Dump the group index for example.test:

           tdx-util -g -n example.test

       Dump the complete overview information for example.test:

           tdx-util -o -n example.test

       Dump the overview information for articles 45 and higher in example.test:


           tdx-util -o -n example.test -a 45-
       Create an entry for example.test with mode m and low and high article numbers of 4 and 23, respectively.

           tdx-util -c -n example.test -f m -a 4-23

       Audit the entire overview database for any problems:

           tdx-util -A

       Rebuild the overview information for example.test from a traditional spool directory:

           tdx-util -R <patharticles in inn.conf>/example/test -n example.test

       The last command may be useful for recovering from a bad crash or corrupted overview  information  for  a
       particular group, if you are also using the tradspool article storage method.

HISTORY

       Written by Russ Allbery <eagle@eyrie.org> for InterNetNews.

SEE ALSO

       inndf(8), makehistory(8), nnrpd(8).

INN 2.7.2                                          2024-03-31                                        TDX-UTIL(8)