Re: [rt-users] Can somebody help/tell me: how i can conf. Exim4 to work with RT?
On Sunday 01 July 2007 08:10, Rafał Kamiński wrote:
> Can somebody tell me how i can configure Exim4 to work with
> Request-Tracker version 3.6? I want to send email to [EMAIL PROTECTED]
> and it could be deliver to helpdesk queue.
>
> I read wiki and some wpage, but i can find good tutorial to do this.
>
> Thanks for help.
What I've done isn't officially supported by the RT team, but rather than
having a static aliases list for the RT correspond and comment addresses, I
have Exim4 do a direct MySQL query of the RT queues, and route appropriately.
This works great if your Exim4 installation is handling relatively light (a few
thousand messages an hour, rather than tens of thousands) load, but may not
scale up to a large "carrier grade" installation without some tweaking.
Let me know if this is of interest, and I'll be glad to share my
config file fragments. The only caveat I need to offer is that my life is
extremely busy right now, so I don't have time available to help much with
troubleshooting. I'm not trying to be mean, just realistic about my current
project workload for the job that pays the rent. :-)
Scott
--
------
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Mysql problems with our RT system
On Wednesday 23 May 2007 10:58, Carlos Randolph wrote:
> I've gone into MySQL and did the whole "OLD_PASSWORD" thing for the RT_USER
> account but we still get the same thing. I'm checked to make sure the the
> Perl modules are all up to date and they are. I'm not sure what else I
> should look at so any help would be appreciated.
Did you enable old password support in your my.cnf (or equivalent) config
file? I believe you can't do it on an account-by-account basis unless it's
also enabled at the global level in the server config.
Kind regards,
Scott
--
--
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Mysql problems with our RT system
On Wednesday 23 May 2007 10:58, Carlos Randolph wrote:
> /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 106
> [Wed May 23 09:49:21 2007] [error] Connect Failed Client does not support
> authentication protocol requested by server; consider upgrading MySQL
> client\n at /opt/rt3/lib/RT.pm line 205\n
Second question: 5.8.3 is a fairly old version of Perl. Did you check to ensure
that Perl isn't somehow grabbing an older version of DBI instead of a newer
one? Maybe you have DBI installed two different places under /usr/lib/perl5/*.
Just a thought.
Scott
--
------
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Need to trigger scrip on ticket moved *out* of queue
On Tuesday 22 May 2007 10:03, Helmuth Ramirez wrote:
> Description: QueueTransfer
> Condition: On Queue Change
> Action: Notify Other Recipients
> Template: New Ticket in Queue
> Stage: Transaction Create
>
> The template is a simple message we created letting the helpdesk staff a
> new ticket is sitting out there. So when a user's queue changes into
> ours, the distribution list gets notified. Here is what it looks like:
Thanks for the template example. This will be helpful, because I can use
it to make a really terse message for our pager.
Unfortunately, your condition is the same as what I have now, which is that
it triggers when the ticket moves into the queue. I need to trigger when
the ticket moves out of the queue.
Scott
--
------
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Need to trigger scrip on ticket moved *out* of queue
Good morning!
We are trying to set up a scrip that will notify a pager email address when
a ticket is moved *out of* one particular queue, regardless of the destination
queue.
Ordinarily, we could put this on the global scrips, but we only want it to
affect one queue. Since the messages will go to a pager, we don't want a page
every time anyone moves any ticket anywhere. :-)
The initial thought was to use the "On Queue Change" condition, but it appears
that fires at the destination queue rather than at the source queue. I was
able to get our scrip to work when we move a ticket *into* the queue, but not
when something moves out. As with global, we can't just put this scrip on all
the other queues, because then we'll be bombarded with unwanted notifications.
Here's what I have now, for testing:
Description: Notify pager when ticket moved out
Condition: On Queue Change
Action: Notify AdminCCs
Template:Global template: Transaction
Stage: Transaction Create
Custom conditions/actions: none
We'll probably change the action to a custom action once we get the triggering
right. For now, I just want to validate that a known-working action is fired
when the event of interest occurs.
Do I need to go to a custom condition for this? If so, what determines when
my conditional expression is evaluated?
Thanks for any advice.
Scott
--
--
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 4
On Friday 04 May 2007 10:32, Maloney, Michael wrote:
> 2. Rights Management - I have "the book" (RT Essentials), and sometimes
> still confused (lots of trial and error).
+1 on this. It would be great to have something like RTx::RightsMatrix in
core RT.
> 3. Active Directory interface/native integration - This is a biggie.
> NOBODY want's / needs an extra user ID / password combo to remember.
-1 on Active Directory integration; +1 on Kerberos integration that *also*
works with AD. Please don't go down the platform-specific road; support the
open standard instead.
Kind regards,
Scott
--
------
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Errors initializing database in RT 3.6.1 [SOLVED]
On Wednesday 28 March 2007 13:22, Ruslan Zakirov wrote:
> In 3.6 as well as in 3.4 there is no way to init database step by
> step, but only with "rt-setup-database-3.6 --action init ..." as init
> action runs additional steps which setup core objects.
>
> On 3/28/07, Scott Courtney <[EMAIL PROTECTED]> wrote:
> [...]
> > Running "rt-setup-database-3.6 --action schema .." works just fine, and
> > creates the schema with no errors.
> >
> > However, running "rt-setup-database-3.6 --action insert --datafile \
> > /etc/request-tracker3.6/initialdata" fails with multiple error messages,
Bingo! Thanks, Ruslan.
My problem was that I needed to *not* pre-create the empty database, but rather
to let rt-setup-database3.6 script do it for me. I had thought I needed to
pre-create the empty DB so that the RT user account would be able to access it,
but the script takes care of this just fine.
I must have done it the right way on my previous installations. Go figure.
In any case, this solved my problem, and I'm up and running. Thanks very much
for the quick response!
Scott
--
--
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RAM
On Wednesday 28 March 2007 11:25, Firas Batal (QA/EMC) wrote:
> I have RT 3.2.1 running with MySQL 4.0.21. I use MYSQL with RT, and I
> have just created a ticket that contains a .zip attachment with a size
> of 11MB. I wonder if one could guide me through the following: I know
> that MYSQL need lots of RAM to breathe properly. But, where is the file
> kept? Is in stored in records in RAM or its stored on the hard drive
> with a pointer of the location of the file stored in RAM?
The backing store for BLOB fields in MySQL is within the table space, which
translates physically to a file on the hard drive (but it's not "one file
per attachment", rather all the attachments go into the database table file).
The exact way in which they're stored depends on which MySQL engine your
table uses (InnoDB, MyISAM, etc.).
Depending on how Perl handles HTTP POST requests, and possibly depending on
whether you are running RT in CGI mode or with mod_perl, the uploaded file
*may* be temporarily RAM-resident during the upload process, before it is
committed to the database. I'm not a Perl wiz, so I'll defer to someone with
more expertise on that question.
By the way, there is a special MySQL engine (at least in MySQL 5...not sure
if it existed back at 4.0.x or not) that stores database records in RAM for
very fast -- but volatile! -- temporary tables. That feature is used in
very specialized situations, and isn't normally relevant for RT. I mention it
here for completeness only. You are almost certainly NOT using this, because
anything in RAM vanishes if the system is rebooted.
Hope this helps.
Scott
--
------
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Errors initializing database in RT 3.6.1
Greetings!
I searched the list archives and Google, but haven't seen any reports of this
problem by anyone else. I'm convinced that it's "pilot error" on my part, not
an RT bug, but I still need to ask for some help in solving it.
I'm doing a fresh install of RT 3.6.1 on a Debian Etch system, with MySQL 5.x
as the backing store. I have successfully installed RT 3.4.4 a number of
times, so I'm familiar with the basic processes, but this is my first exposure
to 3.6.x.
I've created a database "rt3" and an RT user ID of "rt" for that database. I
verified that user "rt" has all privileges on the "rt3" database and can login
with its assigned password from the MySQL command prompt.
Running "rt-setup-database-3.6 --action schema .." works just fine, and
creates the schema with no errors.
However, running "rt-setup-database-3.6 --action insert --datafile \
/etc/request-tracker3.6/initialdata" fails with multiple error messages, to
wit:
Creating Superuser ACL...[Wed Mar 28 13:05:22 2007] [err]: System error. right
not granted. (/usr/share/request-tracker3.6/lib/RT/ACE_Overlay.pm:753)
done.
Creating groups...1.2.3.4.5.6.7.done.
Creating users...[Wed Mar 28 13:05:22 2007] [err]: Couldn't load from the
users database. (/usr/share/request-tracker3.6/lib/RT/CurrentUser.pm:145)
(Error: No permission to create users)0.[Wed Mar 28 13:05:22 2007] [err]:
Couldn't load from the users database.
(/usr/share/request-tracker3.6/lib/RT/CurrentUser.pm:145)
(Error: No permission to create users)0.done.
Creating queues...[Wed Mar 28 13:05:22 2007] [err]: Couldn't load from the
users database. (/usr/share/request-tracker3.6/lib/RT/CurrentUser.pm:145)
(Error: No permission to create queues)0.[Wed Mar 28 13:05:22 2007] [err]:
Couldn't load from the users database.
(/usr/share/request-tracker3.6/lib/RT/CurrentUser.pm:145)
(Error: No permission to create queues)0.done.
Creating ACL...[Wed Mar 28 13:05:22 2007] [crit]: 1
(/usr/share/request-tracker3.6/lib/RT/ACE_Overlay.pm:907)
[Wed Mar 28 13:05:22 2007] [crit]: Can't load a principal for id
(/usr/share/request-tracker3.6/lib/RT/ACE_Overlay.pm:908)
Principal not found..[Wed Mar 28 13:05:22 2007] [crit]: 1
(/usr/share/request-tracker3.6/lib/RT/ACE_Overlay.pm:907)
[Wed Mar 28 13:05:22 2007] [crit]: Can't load a principal for id
(/usr/share/request-tracker3.6/lib/RT/ACE_Overlay.pm:908)
Principal not found..done.
And so on. It just goes downhill from there, though I'm fairly convinced
that the first error is the indirect cause of most of the others and that
if I can fix it, I'll have fixed the rest.
I've looked at the Perl code a bit, but to be honest I'm a Java guy and not
all that literate in Perl.
Is this thing failing because of a MySQL command not executing, and if so, is
there a way for me to tell Perl to show me all the MySQL commands as it runs
them? I'm enough of a MySQL wiz that if I can see what's failing there, I can
fix it on my own.
Or am I doing something wrong with my rt-setup-database-3.6 command?
I looked at the ACL command, and that seems redundant to what I've already
granted from the MySQL command prompt.
Any help would be appreciated. This is on a new, not-yet-in-production server,
rather than an upgrade, so dropping and recreating the database is no problem
at all. (In fact, I've already done it a few times trying different things to
fix the problem.)
Thanks for any advice.
Kind regards,
Scott
--
--
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] QueryBuilder::Tree error
On Wednesday 17 May 2006 03:53, Pedro Ferreira wrote:
> no way, it doesn't work!
> I removed Tree::Simple and Scalar::Util
> I re-installed it using perl CPAN
>
> I always get the error:
>
> Can't locate object method "new" via package
> "RT::Interface::Web::QueryBuilder::Tree" at
> /opt/rt3/share/html/Search/Build.html line 288.
>
> and
>
> Undefined subroutine &Scalar::Util::weaken called at
> /opt/rt3/lib/RT/Action/Generic.pm line 108.
Did you remember to rebuild mod_perl?
Scott
--
------
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
Re: [rt-users] QueryBuilder::Tree error
On Tuesday 16 May 2006 11:26, Pedro Ferreira wrote:
> Thanks for your help!
> I tryed to update Tree::Simple and I was getting an
> error so I re-installed perl CPAN, Scalar::Util and
> Tree::Simple, this worked without any errors.
Tree::Simple seems to be the key to the problem, but I found that I had to
physically delete it from the /usr/lib/perl directory tree and then use
CPAN to reinstalling it. I think once you have a version of that module which
doesn't require weak references, RT will install and run cleanly.
> So you say that now if I re-install everything it
> should work... ok, going to try it, after I'll let you
> know if it worked...
Good luck!
--
--
Scott Courtney | "I don't mind Microsoft making money. I mind them
[EMAIL PROTECTED] | having a bad operating system."-- Linus
Torvalds
http://4th.com/| ("The Rebel Code," NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
