Reference

rt-setup-database-3.6(8)

Set-up the database for Request Tracker

NAME

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

SYNOPSIS

 rt-setup-database --action init|drop|insert [--datafile <file>] \
     --dba <username> --prompt-for-dba-password|--dba-password <guess>

OPTIONS

 action:  init    Initialize the database
          drop    Drop the database.
                  This will ERASE ALL YOUR DATA
          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.
          acl     Initialize only the database ACLs
                  To use a local or supplementary datafile, specify it
                  using the '--datadir' option below.
          schema  Initialize only the database schema
                  To use a local or supplementary datafile, specify it
                  using the '--datadir' option below.
 datafile: /path/to/datafile
 datadir:  /path/to/            Used to specify a path to find the local
                                database schema and acls to be installed.
 dba:                      dba's username
 dba-password:             dba's password
 prompt-for-dba-password   Ask for the database administrator's
                           password interactively
 no-dba                    for 'init': assume that the database and the
                           user are already created, so we don't need 
                           administrator privileges (Debian-specific)

INTERNALS

get_system_dsn

Returns a dsn suitable for database creates and drops and user creates and drops

ACLEquivGroupId

Given a userid, return that user's acl equivalence group

History