Which field contains the comments or replies

RT Users
1

Hello,

which field in which table contains the comments and replies made to a
request? If I open a request I can see that comments were made. But the text
of the comments is not longer there.

Thanks, Jens

Jens Mattfeld
IT-Operations

Atmel Germany GmbH
Theresienstr. 2

74072 Heilbronn

Tel. +49 (0)7131 672613
Fax +49 (0)7131 672210

email: jens.mattfeld@atmel-wm.com
web: www.atmel-wm.com

2

Hello,

which field in which table contains the comments and replies made to a
request? If I open a request I can see that comments were made. But the text
of the comments is not longer there.

The body of the comments + replies is stored in the filesystem, not in the
database. Check out the subdirectory “transactions” in your RT
installation directory.

Hope this helps,

CS

Christian Schwarz, F&F UNIX/Linux System Administrator
F&F Computer Anwendungen Tel: 089/51727-0
und Unternehmensberatung GmbH Fax: 089/51727-111
Westendstr. 195 Mail:C.Schwarz@ff-muenchen.de
D-80686 Muenchen http://www.ff-muenchen.de

3

Hello all,

RT passed QA with flying colors on my test box.

Now I have installed it on what will be in the production environment and
got a new error I have never seen before:

Nov 8 14:56:53 tps sendmail[1595]: OAA01594:
to=|"/usr/local/rt/bin/rt-mailgate opsrequest correspond", delay=00:00:00,
xdelay=00:00:00, mailer=prog, stat=Service unavailable

Nov 8 14:56:53 tps sendmail[1595]: OAA01594: OAA01595: DSN: Service
unavailable

I would very much like to ditch our old worthless ticketing system- so any
help would be great.

Thanks,

Valerio Romano
grasshopper

4

I just ran into this problem exactly. Newer versions of sendmail have a security
feature in them that won’t allow them to run arbitrary executables.

What you need to do to fix this is make a link in the /etc/smrsh folder to the rt-
mailgate executable.

This will fix the problem.

Russ---- Original Message ----
From: Valerio Romano
Date: Wed 11/8/00 15:12
To: rt-users@lists.fsck.com
Subject: [rt-users] sendmail service unavailable

Hello all,

RT passed QA with flying colors on my test box.

Now I have installed it on what will be in the production environment and
got a new error I have never seen before:

Nov 8 14:56:53 tps sendmail[1595]: OAA01594:
to=|“/usr/local/rt/bin/rt-mailgate opsrequest correspond”, delay=00:00:00,
xdelay=00:00:00, mailer=prog, stat=Service unavailable

Nov 8 14:56:53 tps sendmail[1595]: OAA01594: OAA01595: DSN: Service
unavailable

I would very much like to ditch our old worthless ticketing system- so any
help would be great.

Thanks,

Valerio Romano
grasshopper

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

5

| Hello all,
|
| RT passed QA with flying colors on my test box.
|
| Now I have installed it on what will be in the production environment and
| got a new error I have never seen before:
|
| Nov 8 14:56:53 tps sendmail[1595]: OAA01594:
| to=|“/usr/local/rt/bin/rt-mailgate opsrequest correspond”, delay=00:00:00,
| xdelay=00:00:00, mailer=prog, stat=Service unavailable
±–>8

Look in /etc/sendmail.cf (or /etc/mail/sendmail.cf, as appropriate) and see
if the “prog” mailer uses smrsh. If so, you need to put a symlink to
rt-mailgate in the /etc/smrsh.

brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]