RT/BSDI/postfix


#1

Hi, first off I’d just like to say hello and thanks for a great program.
Been testing RT for awhile at home and recently setup it up at work as
an alternative to Jitterbug that I’d been using for tracking change
requests and also set up a queue for our tech support.

Running it at home I’ve had no problems at all (Linux, RT 1.0.7, postfix,
and MySQL 3.23.32).

At work we use BSDI 3.1, RT 1.0.7, postfix, and MySQL 3.22.32. After getting
by the initial installation hurdles (BSDI doesn’t have a ‘root’ group,
tweaked the Makefile to use group ‘wheel’ instead). Creating a queue also
always errors out when copying the templates, haven’t figured that out yet,
it looks like a umask problem or problem, wasn’t to worried about that as I
just copied them over manually and reran ‘gmake fixperms’.

Once installed it runs great entering in requests, etc. but it has major
problems replying, responding, etc. to them. For instance if I reply to
a request it eventually times out (3-4 minutes) and the browser comes back
with ‘No data’ instead of redisplaying the request with the new transaction
data, yet if I go back to the queue and then redisplay the request then I
see everything. Also while the browser is spinning its wheels the reply
email is sent ok. Using ‘top’ I can see a perl process running and a
’tail -f’ of the mysql log shows a query entered:

536 Query select effective_sn from each_req WHERE serial_num = 5

And it just sits there for awhile (3-4 minutes) and then quits at which time
the browser returns the ‘No data’. Yet the perl process is still running and
I have to manually kill it off. At one time I had 6-7 perl processes left
hanging around driving up the load average and consuming all the cpu (0% idle)
thats when I really noticed something wasn’t cool :slight_smile: It doesn’t do this
for each transaction, every once in a while it works fine but at least half
the time I see this problem.

Anyway, I was wondering if there are any known problems, issues, MySQL tweaks,
etc. when running with BSDI. Also any ideas on how to further debug and
track down the problem would be very helpful.

PS: I initially had RT and MySQL on seperate machines, but after I started
seeing this problem I re-installed RT on the MySQL machine to avoid
accessing the database remotely but that didn’t make any difference.

Do files get embarrassed when you unzip them ???

Mike Hall,
Unix Admin - Rock Island Communications mikeh@rockisland.com
System Admin - riverside.org mhall@riverside.org


#2

hmm… this sounds like it might be a misconfiguration with sendmail. On
my RT server (solaris 7 box) i needed to set the smart relay host in the
sendmail.cf file to my company’s SMTP server otherwise sendmail was spinning
for a while when sending mail, and RT was waiting for sendmail to return,
thus causing the occasional time-out. Check your syslog to see if there are
complaints from sendmail that it can’t resolve external hosts or can’t get
its own fully qualified domain name.

hope this helps

JustinFrom: “Michael Hall” mhall@riverside.org
To: “RT-Users” rt-users@lists.fsck.com
Sent: Wednesday, February 21, 2001 4:03 PM
Subject: [rt-users] RT/BSDI/postfix

Hi, first off I’d just like to say hello and thanks for a great program.
Been testing RT for awhile at home and recently setup it up at work as
an alternative to Jitterbug that I’d been using for tracking change
requests and also set up a queue for our tech support.

Running it at home I’ve had no problems at all (Linux, RT 1.0.7, postfix,
and MySQL 3.23.32).

At work we use BSDI 3.1, RT 1.0.7, postfix, and MySQL 3.22.32. After
getting
by the initial installation hurdles (BSDI doesn’t have a ‘root’ group,
tweaked the Makefile to use group ‘wheel’ instead). Creating a queue also
always errors out when copying the templates, haven’t figured that out
yet,
it looks like a umask problem or problem, wasn’t to worried about that as
I
just copied them over manually and reran ‘gmake fixperms’.

Once installed it runs great entering in requests, etc. but it has major
problems replying, responding, etc. to them. For instance if I reply to
a request it eventually times out (3-4 minutes) and the browser comes back
with ‘No data’ instead of redisplaying the request with the new
transaction
data, yet if I go back to the queue and then redisplay the request then I
see everything. Also while the browser is spinning its wheels the reply
email is sent ok. Using ‘top’ I can see a perl process running and a
’tail -f’ of the mysql log shows a query entered:

536 Query select effective_sn from each_req WHERE serial_num = 5

And it just sits there for awhile (3-4 minutes) and then quits at which
time
the browser returns the ‘No data’. Yet the perl process is still running
and
I have to manually kill it off. At one time I had 6-7 perl processes left
hanging around driving up the load average and consuming all the cpu (0%
idle)
thats when I really noticed something wasn’t cool :slight_smile: It doesn’t do this
for each transaction, every once in a while it works fine but at least
half
the time I see this problem.

Anyway, I was wondering if there are any known problems, issues, MySQL
tweaks,
etc. when running with BSDI. Also any ideas on how to further debug and
track down the problem would be very helpful.

PS: I initially had RT and MySQL on seperate machines, but after I started
seeing this problem I re-installed RT on the MySQL machine to avoid
accessing the database remotely but that didn’t make any difference.


Do files get embarrassed when you unzip them ???

Mike Hall,
Unix Admin - Rock Island Communications mikeh@rockisland.com
System Admin - riverside.org mhall@riverside.org


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


#3

hmm… this sounds like it might be a misconfiguration with sendmail. On
my RT server (solaris 7 box) i needed to set the smart relay host in the
sendmail.cf file to my company’s SMTP server otherwise sendmail was spinning
for a while when sending mail, and RT was waiting for sendmail to return,
thus causing the occasional time-out. Check your syslog to see if there are
complaints from sendmail that it can’t resolve external hosts or can’t get
its own fully qualified domain name.

Hmm, we’re using postfix not sendmail. I at first was thinking it might be
a mail problem but as I tried to explain in my message the mail repsonse
comes through fine, I can go read the response while the browser is sitting
there spinning it wheels to redisplay the results of the transaction. Its
something going on after the mail is sent, pretty sure its something to do
with MySQL as tailing the mysql log shows a query entered but its like it
never gets an answer (thus the browser says “Document contained no data”)
when something eventually times out, yet it still leaves the perl process
running and I have to kill them off manually. Yet it all runs perfectly
at home (Linux, RT 1.0.7, MySQL 3.23.32) but has problems at work with
(BSDI 3.1, RT 1.0.7, MySQL 3.22.32).

Fight Crime - SHOOT BACK !!!

Mike Hall,
Unix Admin - Rock Island Communications mikeh@rockisland.com
System Admin - riverside.org mhall@riverside.org


#4

Michael,

Not much help from me, however I can say that we have had no problems
running RT 1.0.5 through 1.0.7 on BSDI 3.1, MySQL 3.22.27 and sendmail.


#5

Not much help from me, however I can say that we have had no problems
running RT 1.0.5 through 1.0.7 on BSDI 3.1, MySQL 3.22.27 and sendmail.

Actually it is some help, at least I know it should work :slight_smile:

Its just got me going in circles, after all its just another perl program
not rocket science and should work. It works fine on my system at home
with the only difference being the OS and MySQL versions, both systems
use postfix and RT 1.0.7.

How did you handle the ‘root’ group deal, did you also just change the
Makefile to ‘wheel’ or did you create a ‘root’ group for install to work?
Any tweaks or anything in your MySQL setup?

Hmm, we’re using postfix not sendmail. I at first was thinking it might be
a mail problem but as I tried to explain in my message the mail repsonse
comes through fine, I can go read the response while the browser is sitting
there spinning it wheels to redisplay the results of the transaction. Its
something going on after the mail is sent, pretty sure its something to do
with MySQL as tailing the mysql log shows a query entered but its like it
never gets an answer (thus the browser says “Document contained no data”)
when something eventually times out, yet it still leaves the perl process
running and I have to kill them off manually. Yet it all runs perfectly
at home (Linux, RT 1.0.7, MySQL 3.23.32) but has problems at work with
(BSDI 3.1, RT 1.0.7, MySQL 3.22.32).

Jesus had no sin, Windows 98 has no shame.

Mike Hall,
Unix Admin - Rock Island Communications mikeh@rockisland.com
System Admin - riverside.org mhall@riverside.org


#6

Michael,

How did you handle the ‘root’ group deal, did you also just change the
Makefile to ‘wheel’ or did you create a ‘root’ group for install to work?
Any tweaks or anything in your MySQL setup?

It appears I no longer have the Makefile used to install it, however I can
say we don’t have a ‘root’ group and the directories are root:wheel or
rt:rt, so we must have changed the group to wheel…

MySQL was already installed and in use with other apps on the server and
no tweaks were required.


#7

At 15:50 -0800 2001.02.21, bill@daze.net wrote:

From your earlier message…

Creating a queue also always errors out when copying the templates, <<

I think we had this problem too, but it has been quite a while since we
created a new queue.

this is a problem on FreeBSD, too. must be a more generic BSDism.
has to be some kind of permissions and/or ownership problem. I’ll
make sure to take a closer look when creating another queue.

–clark