OVSQLITE-UTIL(8) | InterNetNews Documentation | OVSQLITE-UTIL(8) |
ovsqlite-util - Overview manipulation utility for ovsqlite
ovsqlite-util [-AFghioO] [-a article] [-n newsgroup] [-p path]
ovsqlite-util is an administrative interface to the ovsqlite overview method for INN. It only works on ovsqlite overview databases, not on any other type of INN overview. (See dedicated ovdb_stat(8) and tdx-util(8) programs for ovdb and tradindexed overview methods.) It allows the administrator to dump various information about the internal state of the overview, audit it for errors, and fix these errors.
To audit the entire overview database for problems, use -A. The checks can take an extended period of time, depending on the number of newsgroups and articles present in the overview database. Any problems found will be reported to standard error. Use -F to correct the errors found.
It is safe to run this utility while the server is running. In case fixes should be made to the database (when using the -F flag), ovsqlite-util will properly pause the server before performing its operations, and then resume it.
The number of overview records stored in the database can be obtained with the "inndf -n" command.
The "DBI" Perl module with the "DBD::SQLite" driver must be installed for this program to work. They are present in most distributions as a package named like "libdbd-sqlite3-perl", "perl-DBD-SQLite" or "p5-DBD-SQLite". They can also be directly installed from CPAN ("DBI" and "DBD-SQLite" distributions available at <https://metacpan.org/dist/DBI> and <https://metacpan.org/dist/DBD-SQLite>).
Naturally, an ovsqlite overview database also needs being in use, as detailed in the ovsqlite(5) manual page.
Only useful in combination with the -g, -o and -O options to dump overview information.
To see what would be changed by -F, run ovsqlite-util with -A first.
If this option is given, the -n option must also be given to specify the newsgroup on which to act.
The fields are, in order, the newsgroup name, the high water mark, the low water mark, the count of articles in the group, the group status, the time (in seconds since epoch) when that newsgroup was last expired (or 0 if expireover hasn't run on it yet), and the deletion status of that newsgroup (0 if not marked for removal during the next expiration, and a positive value otherwise).
A particular newsgroup can be specified with the -n option. If -n is not given, the entire master index will be dumped.
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.
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.
Dump newsgroup-related overview information for the overview database in /news/overview, regardless of the overview path specified in inn.conf:
ovsqlite-util -i -p /news/overview
Dump overall overview information for example.test:
ovsqlite-util -g -n example.test
Dump the complete overview information for example.test:
ovsqlite-util -o -n example.test
Dump the overview information for articles 45 and higher in example.test:
ovsqlite-util -o -n example.test -a 45-
Audit the entire overview database for any problems:
ovsqlite-util -A
Written by Julien ELIE for InterNetNews.
2023-09-06 | INN 2.7.1 |