I fixed it <was "I Broke It">

While I am not sure what the problem was or what caused it, I dropped
the database and reinitialized it. Since this was a newly installed test
system, that was an option.
It now works. The next step will be to install RTFM and see if the
problem comes back up. Fortunately, this time, I took a snap shot of
the vm in this working state.
Now that it works the real hard part is here… I need to sell the
higher ups that we (“I” is really more accurate here) think we should
move to RT from TrackIT.

Thanks;
James

James Alspach
Systems Applications Technician
Shasta County Office of Education

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of James Alspach
Sent: Friday, June 08, 2007 8:58 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RE: I broke it

I do not know if it really applies to my issue but, I just tested
rt-mailgate and it seems to work just fine. I used the example from
the
rt3.6-clients/README.Debian and it created a ticket right away.

James

James Alspach
Systems Applications Technician
Shasta County Office of Education

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of James Alspach
Sent: Friday, June 08, 2007 8:51 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RE: I broke it

It has been suggested that it may help if I posted my RT_SiteConfig
file
so… here it is.
Only the names and passwords have been removed to protect the
guilty.
The only thing I see that may be causing a problem (but really, if I
knew enough to self diagnose I would not be here asking for help.)
is
that I have sendmail instead of sendmailpipe. I have tried this
both
ways making sure to change the next line as well to add or remove
the
-t. I get the same results either way.
The reason I changed this was that I did not seem to have a
sendmailpipe
command on my system (Debian etch) however, looking at the exim4
config
makes me thing I should leave it in.
I am going to try running rt-mailgate from the command line to see
if
that works although my understanding is that that system is more for
the
inbound side of things which can wait a little bit.

Thank you for any help;
James

James Alspach
Systems Applications Technician
Shasta County Office of Education

-----Original Message-----
From: root [mailto:root@shastacoe.org]
Sent: Friday, June 08, 2007 8:28 AM
To: James Alspach
Subject: RT_SiteConfig

RT_SiteConfig.pm

These are the bits you absolutely must edit.

To find out how, please read

/usr/share/doc/request-tracker3.6/NOTES.Debian

THE BASICS:

Set($rtname, ‘shastacoe.org’);
Set($Organization, ‘shastacoe.org’);

Set($CorrespondAddress , ‘rt@shastacoe.org’);
Set($CommentAddress , ‘rt-comment@shastacoe.org’);

Set($Timezone , ‘America/Los_Angeles’); # obviously choose what
suits
you

THE DATABASE:

Set($DatabaseType, ‘Pg’); # e.g. Pg or mysql

These are the settings we used above when creating the RT

database,

you MUST set these to what you chose in the section above.

Set($DatabaseUser , ‘rtdbadminuser’);
Set($DatabasePassword , ‘rtdbadminuserpassword’);
Set($DatabaseName , ‘rtdatabase’);

The domain name of your database server

If you’re running mysql and it’s on localhost,

leave it blank for enhanced performance

Set($DatabaseHost , ‘’);
Set($DatabaseRTHost , ‘’);

THE WEBSERVER:

Set($WebPath , “/rt”);
#Set($WebBaseURL , “http://shastacoe.org”);
Set($WebBaseURL , “http://10.1.3.82”);

{{{ Incoming mail gateway configuration

OwnerEmail is the address of a human who manages RT. RT will send

errors generated by the mail gateway to this address. This

address

should not be an address that’s managed by your RT instance.

Set($OwnerEmail , ‘jalspach@shastacoe.org’);

sprintf() format of the friendly ‘From:’ header; its arguments

are SenderName and SenderEmailAddress.

Set($FriendlyFromLineFormat , “"%s via RT" <%s>”);

RT can optionally set a “Friendly” ‘To:’ header when sending

messages

to

Ccs or AdminCcs (rather than having a blank ‘To:’ header.

This feature DOES NOT WORK WITH SENDMAIL[tm] BRAND SENDMAIL

If you are using sendmail, rather than postfix, qmail, exim or

some

other MTA,

you must disable this option.

Set($UseFriendlyToLine , 1);

{{{ Web interface configuration

$LogoURL points to the URL of the RT logo displayed in the web UI

Set($LogoURL , $WebImagesURL . “bplogo.gif”);

If PreferRichText is set to a true value, RT will show HTML/Rich

text

messages in preference to their plaintext alternatives. RT

“scrubs”

the

html to show only a minimal subset of HTML to avoid possible

contamination

by cross-site-scripting attacks.

Set($PreferRichText, 1);

By default, RT shows newest transactions at the bottom of the

ticket

history page, if you want see them at the top set this to ‘0’.

Set($OldestTransactionsFirst, ‘0’);

#Sendmail Configuration

$MailCommand defines which method RT will use to try to send mail

We know that ‘sendmailpipe’ works fairly well.

If ‘sendmailpipe’ doesn’t work well for you, try ‘sendmail’

Note that you should remove the ‘-t’ from $SendmailArguments

if you use ‘sendmail’ rather than ‘sendmailpipe’

Set($MailCommand , ‘sendmail’);

$SendmailArguments defines what flags to pass to $Sendmail

assuming you picked ‘sendmail’ or ‘sendmailpipe’ as the

$MailCommand

James,
We are an RT shop, formerly TrackIT! shop. Feel free to e-mail me
offline (don’t want to bore the list) to discuss why RT is so much
better than TrackIT! :slight_smile:

HelmuthFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of James
Alspach
Sent: Monday, June 11, 2007 1:32 PM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] I fixed it <was “I Broke It”>

While I am not sure what the problem was or what caused it, I dropped
the database and reinitialized it. Since this was a newly installed test
system, that was an option.
It now works. The next step will be to install RTFM and see if the
problem comes back up. Fortunately, this time, I took a snap shot of
the vm in this working state.
Now that it works the real hard part is here… I need to sell the
higher ups that we (“I” is really more accurate here) think we should
move to RT from TrackIT.

Thanks;
James

James Alspach
Systems Applications Technician
Shasta County Office of Education

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of James Alspach
Sent: Friday, June 08, 2007 8:58 AM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RE: I broke it

I do not know if it really applies to my issue but, I just tested
rt-mailgate and it seems to work just fine. I used the example from
the
rt3.6-clients/README.Debian and it created a ticket right away.

James

James Alspach
Systems Applications Technician
Shasta County Office of Education

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-
bounces@lists.bestpractical.com] On Behalf Of James Alspach
Sent: Friday, June 08, 2007 8:51 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RE: I broke it

It has been suggested that it may help if I posted my RT_SiteConfig
file
so… here it is.
Only the names and passwords have been removed to protect the
guilty.
The only thing I see that may be causing a problem (but really, if I
knew enough to self diagnose I would not be here asking for help.)
is
that I have sendmail instead of sendmailpipe. I have tried this
both
ways making sure to change the next line as well to add or remove
the
-t. I get the same results either way.
The reason I changed this was that I did not seem to have a
sendmailpipe
command on my system (Debian etch) however, looking at the exim4
config
makes me thing I should leave it in.
I am going to try running rt-mailgate from the command line to see
if
that works although my understanding is that that system is more for
the
inbound side of things which can wait a little bit.

Thank you for any help;
James

James Alspach
Systems Applications Technician
Shasta County Office of Education

-----Original Message-----
From: root [mailto:root@shastacoe.org]
Sent: Friday, June 08, 2007 8:28 AM
To: James Alspach
Subject: RT_SiteConfig

RT_SiteConfig.pm

These are the bits you absolutely must edit.

To find out how, please read

/usr/share/doc/request-tracker3.6/NOTES.Debian

THE BASICS:

Set($rtname, ‘shastacoe.org’);
Set($Organization, ‘shastacoe.org’);

Set($CorrespondAddress , ‘rt@shastacoe.org’);
Set($CommentAddress , ‘rt-comment@shastacoe.org’);

Set($Timezone , ‘America/Los_Angeles’); # obviously choose what
suits
you

THE DATABASE:

Set($DatabaseType, ‘Pg’); # e.g. Pg or mysql

These are the settings we used above when creating the RT

database,

you MUST set these to what you chose in the section above.

Set($DatabaseUser , ‘rtdbadminuser’);
Set($DatabasePassword , ‘rtdbadminuserpassword’);
Set($DatabaseName , ‘rtdatabase’);

The domain name of your database server

If you’re running mysql and it’s on localhost,

leave it blank for enhanced performance

Set($DatabaseHost , ‘’);
Set($DatabaseRTHost , ‘’);

THE WEBSERVER:

Set($WebPath , “/rt”);
#Set($WebBaseURL , “http://shastacoe.org”);
Set($WebBaseURL , “http://10.1.3.82”);

{{{ Incoming mail gateway configuration

OwnerEmail is the address of a human who manages RT. RT will send

errors generated by the mail gateway to this address. This

address

should not be an address that’s managed by your RT instance.

Set($OwnerEmail , ‘jalspach@shastacoe.org’);

sprintf() format of the friendly ‘From:’ header; its arguments

are SenderName and SenderEmailAddress.

Set($FriendlyFromLineFormat , “"%s via RT" <%s>”);

RT can optionally set a “Friendly” ‘To:’ header when sending

messages

to

Ccs or AdminCcs (rather than having a blank ‘To:’ header.

This feature DOES NOT WORK WITH SENDMAIL[tm] BRAND SENDMAIL

If you are using sendmail, rather than postfix, qmail, exim or

some

other MTA,

you must disable this option.

Set($UseFriendlyToLine , 1);

{{{ Web interface configuration

$LogoURL points to the URL of the RT logo displayed in the web UI

Set($LogoURL , $WebImagesURL . “bplogo.gif”);

If PreferRichText is set to a true value, RT will show HTML/Rich

text

messages in preference to their plaintext alternatives. RT

“scrubs”

the

html to show only a minimal subset of HTML to avoid possible

contamination

by cross-site-scripting attacks.

Set($PreferRichText, 1);

By default, RT shows newest transactions at the bottom of the

ticket

history page, if you want see them at the top set this to ‘0’.

Set($OldestTransactionsFirst, ‘0’);

#Sendmail Configuration

$MailCommand defines which method RT will use to try to send mail

We know that ‘sendmailpipe’ works fairly well.

If ‘sendmailpipe’ doesn’t work well for you, try ‘sendmail’

Note that you should remove the ‘-t’ from $SendmailArguments

if you use ‘sendmail’ rather than ‘sendmailpipe’

Set($MailCommand , ‘sendmail’);

$SendmailArguments defines what flags to pass to $Sendmail

assuming you picked ‘sendmail’ or ‘sendmailpipe’ as the

$MailCommand

above.

If you picked ‘sendmailpipe’, you MUST add a -t flag to

$SendmailArguments

These options are good for most sendmail wrappers and workalikes

Set($SendmailArguments , “-oi”);

1;


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

This Electronic message contains information from CompuPay which may
be privileged. The information is intended to be for the use of the
addressee only. If you are not the addressee, or the employee or agent
responsible to deliver it to the intended recipient, note that any
disclosure, copy distribution or use of the contents of this message
is prohibited. If you have received this Electronic Message in error,
please promptly notify the sender by return e-mail. For more
information regarding our company please visit www.compupay.com
http://www.compupay.com/