SQL passwords

RT Users
1

Hey Guys,
I am trying to move my database from one machine to another.
When I installed mySQL and RT I don’t remember picking a password
from the mysql root or the rt user. Is there any way to figure out the
root and / or rt password?

Thanks for any info!

Ashby

2

I have installed Request Tracker on a FreeBSD machine and I’m getting the
following problem when I send a mail from other machine:

----- The following addresses had transient non-fatal errors -----
rt@host.domain.com

----- Transcript of session follows -----
… while talking to host.domain.com.:

MAIL From:sidney@land.ufrj.br SIZE=332
<<< 451 4.1.8 sidney@land.ufrj.br… Domain of sender address
sidney@land.ufrj.br does not resolve
rt@host.domain.com… Deferred: 451 4.1.8 sidney@land.ufrj.br…
Domain of sender address sidney@land.ufrj.br does not resolve
Warning: message still undelivered after 4 hours
Will keep trying until message is 5 days old

This error doesn’t happen if I send a mail from another user residing in
the same host where RT is installed.

Any help?

Thanks in advance.

Sidney Cunha de Lucena
sidney@rnp.br

Centro de Engenharia e Operacoes
Nucleo de Coordenacao (NC) - RJ
Rede Nacional de Pesquisa (RNP)
www.rnp.br

3

I’m having major problems with the mail functionality in RT. All messages
sent to the RT server bounce. This is the message we recieve:

The original message was received at Wed, 2 Apr 2003 11:45:24 -0500
from xxxxx.xxxxxxxx.com [10.1.0.4]

----- The following addresses had permanent fatal errors -----
“|/opt/rt3/bin/rt-mailgate --gueue general --action correspond --url
http://localhost/”
(reason: service unavailable)
(expanded from: rt@rt.xxxxxxx.com)

----- Transcript of session follows -----
smrsh: rt-mailgate not available for sendmail programs
554 5.0.0 Service unavailable

Jason Crocker

4

Jason Crocker wrote:

----- Transcript of session follows -----
smrsh: rt-mailgate not available for sendmail programs

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

The answer lies above.
�|� Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

5

correct, and for those who aren’t familiar with smrsh:

you basically need:

ln -s /RTINSTALLROOT/bin/rt-mailgate /etc/smrsh

(where both dirs can change, the first by your parameters, the second by
the distro / installation source. the directory name of the second,
however, should be smrsh anywhere. To be sure, you can look at the
sendmail config.On Thu, 3 Apr 2003, Phil Homewood wrote:

Jason Crocker wrote:

----- Transcript of session follows -----
smrsh: rt-mailgate not available for sendmail programs

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

The answer lies above.

Best regards,
Shimi

“Outlook is a massive flaming horrid blatant security violation, which
also happens to be a mail reader.”

“Sure UNIX is user friendly; it’s just picky about who its friends are.”

6

I’m having major problems with the mail functionality in RT. All
messages
sent to the RT server bounce. This is the message we recieve:

The original message was received at Wed, 2 Apr 2003 11:45:24 -0500
from xxxxx.xxxxxxxx.com [10.1.0.4]

----- The following addresses had permanent fatal errors -----
“|/opt/rt3/bin/rt-mailgate --gueue general --action correspond --url
http://localhost/”
(reason: service unavailable)
(expanded from: rt@rt.xxxxxxx.com)

----- Transcript of session follows -----
smrsh: rt-mailgate not available for sendmail programs
554 5.0.0 Service unavailable

Did You link /path/to/rt3/bin/rt-mailgate to /etc/smrsh (or whereever
that is located on your system)? Otherwise, sendmail won’t let incoming
mail be processed by the mailgate.

Regards,
Harald

Harald Wagener * FCB/Wilkens * An der Alster 42 * 20099 Hamburg

7

Hi,

I have 2 problems.
The first one is that when a ticket is created by email, there is no
autoreply to the requestor.
The second one is that only registered users can create tickets by
email. If an unregistered
user sends an email, it comes back saying that this user has no
permission to create tickets…

thanks for helping,

Vassilios

8

At 12:48 25.04.2003 +0200, you wrote:

I have 2 problems.
The first one is that when a ticket is created by email, there is no
autoreply to the requestor.
The second one is that only registered users can create tickets by email.
If an unregistered
user sends an email, it comes back saying that this user has no permission
to create tickets…

Did you give the pseudouser “everyone” the permission to create Tickets in
the queue in question?

Nils