ftndb-admin - Administration of an SQL database for Fidonet/FTN processing.
Version 0.37
Administration of a database for Fidonet/FTN related processing. The SQL database engine is one for which a DBD module exists, defaulting to SQLite.
ftndb-admin -c config_file [options] [-d databasename] create|drop database
ftndb-admin -c config_file [options] [-t tablename] create|drop table
ftndb-admin [-h | --help]
ftndb-admin --version
This is the filename and path of a configuration file, with the default being ftndb.cfg in the current directory.
Debug option.
Verbose option.
Name of the database being created or dropped.
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.
This will create a database an SQL database server being used for Fidonet/FTN processing. If it already exists, it will drop it first, before going on to create it again.
This will drop a database if it exists in an SQL database server being used for Fidonet/FTN processing.
This will create a nodelist table in an SQL database being used for Fidonet/FTN nodelist processing. If it already exists, it will drop it first before going on to create it again.
This will drop a database table if it exists in an SQL database server being used for Fidonet/FTN processing.
Configuration information not provided by the command line options are obtained from a configuration file. That can be defined by setting the "-c" option, which is the path and file name of the configuration file to be used. If that is not defined, it looks for a file named ftndb.cfg in the current directory. The file contains configuration items listed outside of a named section as well as those listed within a named section, and blank lines and lines starting with a "#" are ignored.
The first items in the file are those outside of a named section:
This is the rquired filename and path of a log file.
The Database section in the configuration file has the following keywords:
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.
Database name. For an SQLite database; this needs to be at least the filename and can also include a path.
Database user. For an SQLite database, this defaults to an empty string as it is not needed for that type of a database.
Database password. For an SQLite database, this defaults to an empty string as it is not needed for that type of a database.
This is an example of the contents of an ftndb.cfg file:
# ftndb.cfg LogFile=/opt/ftndb/ftndb.log [Database] Type=mysql Name=ftndbtst User=sysop Password=ftndbtst
Given that $CFGFILE is a configuration file, the following command line can be used to create an FTN Nodelist table in that database file:
ftndb-admin -c $CFGFILE -t Nodelist -v create table
Robert James Clay, <jame at rocasa.us>
<jame at rocasa.us>
Please report any bugs or feature requests via the web interface at https://sourceforge.net/p/ftnpl/ftndb/tickets/. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.
Note that you can also report any bugs or feature requests to bug-ftndb at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=ftndb; however, the FTN Database application Issue tracker at the SourceForge project is preferred.
bug-ftndb at rt.cpan.org
You can find documentation for this module with the perldoc command.
perldoc ftndb-admin
You can also look for information at:
FTN Database application issue tracker
https://sourceforge.net/p/ftnpl/ftndb/tickets/
RT: CPAN's request tracker
http://rt.cpan.org/NoAuth/Bugs.html?Dist=ftndb
Search CPAN
http://search.cpan.org/dist/ftndb
L<FTN::Database>, L<FTNDB::Nodelist>, and L<ftndb-nodelist>.
Copyright 2010-2012 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.
To install FTNDB, copy and paste the appropriate command in to your terminal.
cpanm
cpanm FTNDB
CPAN shell
perl -MCPAN -e shell install FTNDB
For more information on module installation, please visit the detailed CPAN module installation guide.