$Id: FAQ.html,v 1.3 1999/12/16 04:56:03 jesse Exp $ -*- text -*- Archive-name: rt-faq Last-modified: Wednesday October 6 16:31:20 EST 1999
This is the RT Frequently Asked Questions list.
RT is an automated system for monitoring, answering, and documenting requests. It was designed as a system to aid helpdesks, but could conceivably work just as well for development teams, construction groups, political insurgencies, or circus performers -- in short, any situation in which a particular group of people needs to request information or action from another group of people, while monitoring the status of these requests.
RT was developed by Jesse Vincent <firstname.lastname@example.org> and he remains the primary maintainer aided and abetted by the members of the rt-devel mailing list. Development of RT has been sponsored in part by Utopia Inc, by The Leftbank Operation and by Wesleyan University. Some of the RT code has been derived from Remy Evard's req package.
This FAQ is maintained by Michael Brader. All errors are mine unless otherwise attributed :-) Special thanks to Jesse, Tobias, Charlie and the rt-devel mailing list for their contributions.
What's changed since last time?
This file was last modified on Wednesday December 15
3. Request manipulation
4. Web interface
The latest stable version is 1.0.7 which was released in November, 1999.
The latest released version of RT can be found at ftp://ftp.fsck.com/pub/rt/release/rt-1.0.7.tar.gz
[Developement of RT v.1 has stopped, it is recommended that you install RT 2, which may be found in the same directory.]
You will find alpha releases in ftp://ftp.fsck.com/pub/rt/devel/ directory. You should not use these unless you are on the rt-devel mailing list (email@example.com)
You will need the following packages to install and run RT successfully. The download URL for some of these resources can change frequently. If it doesn't work, go to the general URL and navigate to the version you require.
I know for sure that GNU Make supports the conditionals syntax RT's Makefile uses. I can't be sure about anything else. If you don't have GNU Make, but feel reasonably comfortable with Makefiles, you probably can get by without it.
You will need the following Perl packages, all available from CPAN:
Download URL: http://www.perl.com/CPAN/modules/by-module/Msql/
When installing Msql-Mysql-modules, it is imperative that you say yes when asked "Do you want to install the MysqlPerl emulation?" Please note that Msql-Mysql-modules requires DBD to be installed to function. See the Msql-Mysql-modules documentation for more information.
Download URL: http://www.perl.com/CPAN/modules/by-module/CGI/
CGI.pm and CGI::Cookie are used for our basic Form and Cookie processing. We recommend that you use at least 2.53 as we know that version works.
Download URL: http://www.perl.com/CPAN/modules/by-module/MD5/
Digest::MD5 is a perl module used for generating MD5 hashes of files or strings, in this case, the password hashes used by the Web interface. It is required for web authentication to work.
This is the contents of the file README.91UPGRADE which should be part of the release:
Since RT 0.9.1, the codebase and database format have undergone incompatible changes. This version of the installation package does NOT come with an easy upgrade path from 0.9.1 or before. However, the instructions below should make the upgrade possible. To upgrade from .9.1 to a post-.9.4 version : "mysqldump -c -t rt > (YOUR_RT_DUMP_FILE)" edit (YOUR_RT_DUMP_FILE) to remove the ACL line for "root" (Something like grep -v "INSERT INTO users VALUES ('root'" \ (YOUR_RT_DUMP_FILE) > (YOUR_RT_DUMP_FILE2) should do the trick copy your current RT installation to a safe location "mysqladmin drop rt" install a fresh copy of RT .9.8, as if for the first time mysql rt < (YOUR_RT_DUMP_FILE2) copy your transaction tree back into place copy rt/etc/templates/queues back into place
While you are installing and testing RT, you may end up with a lot of test transactions cluttering up the database. If you would like to clear them out, the following should do the trick (from Bryan Allbery firstname.lastname@example.org):
Run mysql, connect to the MySQL database, and delete everything in the each_req and transaction tables.
Then remove everything under the transactions directory wherever you installed RT (/usr/local/rt/transactions in my case).
You either have not yet installed Msql-Mysql-Modules or you did not answer "Y"es when asked if you wanted to enable MysqlPerl emulation.
There are several options. It is possible to run all services on seperate servers by sharing the transaction directory via NFS or any other networked file system connecting remotely to Mysql.
It's possible to use i.e. fetchmail or another POP/IMAP let RT suck mail from the mail server. Clark Shishido explains:
How to install RT on a standalone/non-mailhub machine Overview: Use sendmail to send everything to a central mailhub, create rt related aliases and mail accounts on the hub, use fetchmail to suck the mail directly into RT. If you don't already send all outgoing email to a central mailhub, create a sendmail.cf configuration that will give you this functionality. Add the following line to the bottom of the generic-[your platform].mc file. FEATURE(`nullclient', `yourmailhub.yourdomain.com') Then run it through m4 to generate your nullclient sendmail.cf. See sendmail documentation for your UNIX flavor. Create rt aliases and email accounts on your central mailserver, with real usernames and mailboxes for the user "rt" and each of your queues. Make the login shell /nonexistent or /dev/null or whatever so no one can actually login with a shell. You do not need to modify /etc/aliases on the machine with the RT installation. On the RT server, make sure fetchmail is installed. Also check to see if you have a home directory and shell for RT. Create a .fetchmailrc in RT's home directory. Here's the first two lines of a sample .fetchmailrc with the password asterixed (normally this is stored in clear text, but at least fetchmail forces you to 700 the file): poll mail.yourdomain.com proto pop3: username rt password ***** mda "/usr/local/rt/bin/rt-mailgate rt correspond" subsequent lines would have each be username [queue-username] password [password] mda "path to rt-mailgate [queue] [correspond/comment]" See RT's README for full details on mailgate options. As the rt user, run "fetchmail -d 300" to have fetchmail run every 300 seconds as a daemon to check for mail on the mail server. You may want to put this into a startup script. Caveats: time lag in processing email becuase of dependency on fetchmail Benefits: can place RT behind a firewall without increasing complexity of mailhub -clark
Your version of CGI.pm is out of date. Please upgrade to at least version 2.53.
Mysql has a command line interface. Log onto the database host and enter the following command, substituting symbols in ALL CAPS for those specified in the Makefile (or in etc/config.pm) where appropriate:
mysql -u <MYSQL_DBADMIN> -p -h <RT_MYSQL_HOST> rt
Enter the password at the prompt. The password is the one specified as RT_MYSQL_PASS in the Makefile.
You should see a prompt similar to this:
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4985 to server version: 3.22.23b Type 'help' for help. mysql>
You can then access the database using SQL commands. Enter "help" to get a summary of the available commands. For example, to see all RT users, enter "select * from users;" and you should see something like the following (the output has been edited, removing columns to fit inside 80 characters - missing fields are password, email, phone, office and comments):
+----------+-----------------------+-----+----------+ | user_id | real_name | ... | admin_rt | +----------+-----------------------+-----+----------+ | testuser | RT test user | ... | 0 | | charlieb | Charlie Brady | ... | 1 | | chris | Chris Maltby | ... | 0 | | mbrader | Michael Brader | ... | 1 | +----------+-----------------------+-----+----------+ 4 rows in set (0.01 sec)
Until you are successfully authenticated, this message and a login box are displayed. Enter your RT username and password and click OK.
If you still can't log in, you (or your administrator) will have to check whether you are in the database of users and that your password is correct.
The most common problems with authentication are:
Select the request you would like to merge into another request. Click on "Serial number", enter the serial number of the second request and click on the merge button.
If you get an error like the following:
----- The following addresses had permanent fatal errors ----- |"/usr/local/rt/bin/rt-mailgate general action" (expanded from: <email@example.com>) ----- Transcript of session follows ----- sh: rt-mailgate not available for sendmail programs 554 |"/usr/local/rt/bin/rt-mailgate general action"... Service unavailable
then, the following information from Jesse should help:
Sendmail has a program called smrsh. smrsh restricts what binaries can be run from sendmail aliases. I think it keeps the programs in /etc/smrsh on redhat6. add a symlink from /usr/local/rt/bin/rt-mailgate to /etc/smrsh/rt-mailgate and things should work better.
Older versions of RT (before 0.99.9) has a bug where lines beginning with 'From' were not being correctly escaped. You should upgrade to the latest version of RT.
RT 1.0.x does not currently have support for MIME. However, stripmime, a program contributed by Dave Troy is available at ftp://ftp.fsck.com/pub/rt/contrib/stripmime [Link broken] will help overcome this deficiency.
Peter Radcliffe has figured out how to get RT working with exim's native command execution subsystem. Documentation can be found at ftp://ftp.fsck.com/pub/rt/contrib/exim.README [Link Broken]
Currently, there are no newsgroups but there are several mailing lists:
To subscribe, send mail to firstname.lastname@example.org with a body containing the word
To unsubscribe, send mail to email@example.com with a body containing the word
To subscribe/unsubscribe, follow the instructions for rt-users but using the address firstname.lastname@example.org
If you're still having problems, I suggest the following steps:
Jesse began RT at the urgings of a coworker while working for the summer for Utopia, Inc, and continued work while attending Wesleyan University and working for Cohesive Network Systems' New England Division (at the time, the LeftBank Operation). All three groups have benefitted from it, and hoped to share these benefits with the user community at large by keeping Jesse fed and amused while working.
A lot of people are responsible for making RT a better program. Many thanks to Lauren Burka, who originally tasked me with writing this beast. She forced me to use a database backend. I've thanked her for it every day since. Rich West rewrote this readme and did some UI hacking. Adam Hirsch, Kit Kraysha, Robin Garner, Jens Glaser, John Adams, Trey Belew, Sean Dague, Nathan Mehl, Kee Hinckley, Rich West, Dale Bewley, Serge Zhuk, Gerald Abshez, Dave Hull, Dave Schenet Dave Walton, Jan Okrouhly, Tobias Brox Lamont Lucase and Charlie Brady have all contributed bug reports, code or ideas that have helped RT along. Arepa, Inc., Utopia Inc, Wesleyan University and The Leftbank Operation have paid me to update RT and release it to the public. Without their support RT would not exist. If I've left you out, please drop me a line ....it wasn't intentional. Enjoy Jesse Vincent email@example.com
Jesse maintains a web site for RT at http://www.fsck.com/projects/rt/
RT is © 1996-1999 by Jesse Vincent <firstname.lastname@example.org>
This FAQ is Copyright © 1999 Michael Brader <email@example.com>. Please send comments, and suggestions to me and the development mailing list <firstname.lastname@example.org>