NAME

       rt-setup-database - Set-up the database for Request Tracker

SYNOPSIS

           rt-setup-database --action ...

OPTIONS

       action
           Several actions can be combined using comma separated list.

           init
               Initialize  the  database.  This  is  combination  of  multiple actions listed below.  Create DB,
               schema, setup acl, insert core data and initial data.

           upgrade
               Apply all needed schema/acl/content updates (will ask for version to upgrade from)

           create
               Create the database.

           drop
               Drop the database.  This will ERASE ALL YOUR DATA.

           schema
               Initialize only the database schema

               To use a local or supplementary datafile, specify it using the '--datadir' option below.

           acl Initialize only the database ACLs

               To use a local or supplementary datafile, specify it using the '--datadir' option below.

           coredata
               Insert data into RT's database. This data is required for normal functioning of any RT instance.

           insert
               Insert data into RT's database.  By default, will use RT's installation data.  To use a local  or
               supplementary datafile, specify it using the '--datafile' option below.

       datafile
           file path of the data you want to action on

           e.g. "--datafile /path/to/datafile"

       datadir
           Used to specify a path to find the local database schema and acls to be installed.

           e.g. "--datadir /path/to/"

       dba dba's username

       dba-password
           dba's password

       prompt-for-dba-password
           Ask for the database administrator's password interactively

       skip-create
           for  'init':  skip  creating  the  database  and  the  user  account,  so we don't need administrator
           privileges

       root-password-file
           for 'init' and 'insert': rather than using the default administrative password for RT's "root"  user,
           use the password in this file.

       package
           the  name  of the entity performing a create or upgrade. Used for logging changes in the DB. Defaults
           to RT, otherwise it should be the fully qualified package name of  the  extension  or  plugin  making
           changes to the DB.

       ext-version
           current  version of extension making a change. Not needed for RT since RT has a more elaborate system
           to track upgrades across multiple versions.

       upgrade-from
           for 'upgrade': specifies the version to upgrade from, and do not prompt for it if it appears to be  a
           valid version.

       upgrade-to
           for  'upgrade':  specifies  the version to upgrade to, and do not prompt for it if it appears to be a
           valid version.

perl v5.38.2                                       2023-10-29                               rt-setup-database(8)