RT 3.5.6 bulk update doesn't work?

Running RT 3.5.6 on Apache 2.0.55, with MySQL 4.1.16, on FreeBSD 4.11

I frequently get spam in various queues, and right now, everything
that’s “new” on my RT is spam.

So, I clicked on “Tickets” selected “Status = New” and brought up the
list of tickets.

All of them are checked.

I click “Make Status > Deleted” and click “Update”

Page refreshes. Tickets are all there. Status is new. I click “Home” and
they’re all still there. Status is still new.

I try again. This time as Root. Same thing.

Nothing is showing up in the logs. Other than the stupidly pesky:

Jan 9 08:00:23 caduceus RT: Couldn’t load from the users database.
(/sw/rt-3.5.6/lib/RT/CurrentUser.pm:146)

(which shows up when I first go to my RT instance before I log in.)

Editing tickets one at a time works… :-\

Anyway… any ideas here? :-/

Best,
–Glenn
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
~Benjamin Franklin, Historical Review of Pennsylvania, 1759

Figured out what was going on.

MySQL needed mysql_fix_privilege_tables run–now bulk update works fine.
(There are times when I wish portupgrade would gather pkg-messages and
email them concisely to root… :-\ )

Hope this helps someone…

Best,
–Glenn

“They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety.”
~Benjamin Franklin, Historical Review of Pennsylvania, 1759

Hi

I run postfix on a black-box mailserver (i.e., no user login accounts,
just postfix/imap accounts). All mail is filtered by spamassassin.

I have a public email address for enquiries to our lab which goes into
an RT queue. Because it’s public, it gets spammed. :slight_smile:

I’m looking for a method whereby I can redirect mails coming into the RT
queues which have been tagged by SA as spam either to a specific RT
queue or to an imap mailbox.

I’d prefer a solution which doesn’t require a user account or procmail
(because I assume, perhaps wrongly, that you need a login account to run
procmail).

Advice and help appreciated. Deleting up to 50 spam emails after being
blitzed on the RT queue is no longer fun :frowning:

I have the RT book on order (should come by end of week), so feel free
to point me at that if it has some solutions.

Many thanks,
Pete Phillips
Surgical Materials Testing Lab.

Hi

I run postfix on a black-box mailserver (i.e., no
user login accounts,
just postfix/imap accounts). All mail is filtered by
spamassassin.

I have a public email address for enquiries to our
lab which goes into
an RT queue. Because it’s public, it gets spammed.
:slight_smile:

I’m looking for a method whereby I can redirect
mails coming into the RT
queues which have been tagged by SA as spam either
to a specific RT
queue or to an imap mailbox.

I’d prefer a solution which doesn’t require a user
account or procmail
(because I assume, perhaps wrongly, that you need a
login account to run
procmail).

Advice and help appreciated. Deleting up to 50 spam
emails after being
blitzed on the RT queue is no longer fun :frowning:

I have the RT book on order (should come by end of
week), so feel free
to point me at that if it has some solutions.

Many thanks,
Pete Phillips
Surgical Materials Testing Lab.

I wrote a perl spam filter a while ago which is
multi-purpose. Basically, it sits between sendmail
and RT. In the /etc/alises, rather than pointing at
the RT queue, mail goes through my filter. If certain
keywords are matched, the email is dropped (or
redirected to another queue-- why not?). If no match,
it goes into the usual queue.
So, I’m sure SA adds some tags which my filter could
key off of, and redirect accordingly.

If you’d like a copy, let me know.

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

On the marvelous Mon, 16 Jan 2006, rt-users-request@lists.bestpractical.com

I wrote a perl spam filter a while ago which is
multi-purpose. Basically, it sits between sendmail
and RT. In the /etc/alises, rather than pointing at
the RT queue, mail goes through my filter. If certain
keywords are matched, the email is dropped (or
redirected to another queue-- why not?). If no match,

Sure. We use our own queue to put spam into and mark them as ‘deleted’.

it goes into the usual queue.
So, I’m sure SA adds some tags which my filter could
key off of, and redirect accordingly.

If you’d like a copy, let me know.

Have a look at spam-handling in this document:
http://www.usit.uio.no/it/rt/modifications.html

Tomas A. P. Olaj, email: tomas.olaj@usit.uio.no, web: folk.uio.no/tomaso
University of Oslo / USIT (Center for Information Technology Services)
System- and Application Management / Applications Management Group