The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
FTN-Database-0.17
River stage one • 2 direct dependents • 2 total dependents
/ ftnpldb-nodelist

NAME

ftnpldb-nodelist - Fidonet/FTN Nodelist related processing using an SQL Database.

VERSION

Version 0.17

DESCRIPTION

This script both provides an example of using the FTN::Database and FTN::Database::Nodelist modules as well as providing some basic functionality related to using an SQL Database for Fidonet/FTN related processing. The SQL Database engine is one for which a DBD module exists, defaulting to SQLite.

SYNOPSIS

ftnpldb-nodelist [-c config_file] [-t tablename] [-f nodelist_file] [-l log_file] [-d domain] [-n net] [-z zone] [-e] [-v] [-x] load

ftnpldb-nodelist [-c config_file] [-t tablename] [-l log_file] [-n net] [-z zone] [-o outfile] [-v] [-x] list

ftnpldb-nodelist [-h | --help]

ftnpldb-nodelist --version

OPTIONS

-c

This is the filename and path of a configuration file, with the default being ftnpldb.cfg in the current directory.

-l

This would be the filename and path of a log file, with the default being ftnpldb.log in the current directory.

-v

Verbose option.

-x

Debug option.

-f

The nodelist file. If the -e option is also set, then this is an exact file name. If -e is not set, then this is the basename of the nodelist files. If -f is not set, then when needed it defaults to "nodelist".

-e

If set, then the -f option must be exact file name. If not set, then the -f option is the basename of a nodelist file.

-t

The nodelist table name to be used. Note that if there is a period in the name, that period will be changed to an underscore.

-n

If set, it is the FTN Net number being operated on.

-z

If defined; is the only zone being operated on.

-d

If defined, this is the domain of the nodelist being loaded. Defaults to fidonet.

-o

Output file. This needs to be at least the filename and can also include a path.

COMMANDS

load

This will load an FTN Nodelist database table in an SQL database server being used for Fidonet/FTN processing.

list

This will list information from an FTN Nodelist database table in an SQL database server being used for Fidonet/FTN processing, by a specified zone and/or net number.

CONFIGURATION

The Database section in the configuration file has the following keywords:

Type

Database type. This needs to be a database type for which a DBD module exists, the type being the name as used in the DBD module. The default type is SQLite.

Name

Database name. For an SQLite database; this needs to be at least the filename and can also include a path.

User

Database user. For an SQLite database, this defaults to an empty string as it is not needed for that type of database.

Password

Database password. For an SQLite database, this defaults to an empty string as it is not needed for that type of database.

The Nodelist section in the configuration file has the following keywords:

Directory

The directory where the FTN Nodelist files are located.

This is an example of the contents of an ftnpldb.cfg file for use with FTN Nodelist related processing:

    [Database]
    Type=mysql
    Name=ftndbtst
    User=sysop
    Password=ftndbtst

    [Nodelist]
    Directory=/var/lib/ftn/nodelist

EXAMPLES

Given that NODELIST is the base nodelist filename and that $CFGFILE is an existing configuration file, the following command line can be used to load an FTN nodelist from a set of nodelist files all with the same basename of NODELIST:

ftnpldb-nodelist -c $CFGFILE -f NODELIST -d fidonet -v load

Given that $CFGFILE is an existing configuration file, the following command line can be used to load a specified zone of the specified domain from a specified nodelist:

ftnpldb-nodelist -c $CFGFILE -f nodelist.197 -d fidonet -z 1 -e -v load

AUTHOR

Robert James Clay, <jame at rocasa.us>

BUGS

Please report any bugs or feature requests to bug-ftn-database at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=FTN-Database. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

You can find documentation for this module with the perldoc command.

    perldoc ftnpldb-nodelist

You can also look for information at:

SEE ALSO

 L<FTN::Database>, L<FTN::Database::Nodelist>, and L<ftnpldb-admin>.

COPYRIGHT & LICENSE

Copyright 2010 Robert James Clay, all rights reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

1 POD Error

The following errors were encountered while parsing the POD:

Around line 245:

'=item' outside of any '=over'