Re: [rt-users] RT external auth does not working
> You have removed > > 'auth' => 1, > 'info' => 1, > > > You have no d_filter. > > Go back to the example config and read it thoroughly. Thanks for you quick reply. Let me try this _ What does Budget 2010 mean for you? Catch all the latest news, updates and analysis on MSN Budget Special http://news.in.msn.com/moneyspecial/budget2010___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Edit the login page
Hi All - Running RT 3.8.7 on Ubuntu. I had LDAP setup and I'm looking to edit the login page to be able to tell users to login with their Novell username and password. I also would like to put a link to the Novell password changer on the login screen. Does anybody know where in the file system the login page is? I can't seem to find it. Thanks! Max -- Max McGrath Asst. Network Admin/Systems Specialist Carthage College 262-552-5512 mmcgr...@carthage.edu ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] logging from scrips
Hi everyone,
the issue from subject was discussed several times, but sadly I have not
been able to find a solution that is working for me.
I have a scrip that should launch after new ticket is created.
Condition: On Create
Action:User defined
Template: My own defined template
Stage: Transaction create
Inside the user condition I have this piece of code:
$RT::Logger->info("Entering the scrip I have written");
$RT::Logger->info($self->TicketObj->Status);
$RT::Logger->info("Leaving the script I have written");
return 1;
I would expect this code to write three messages into log and send the
message using given template (the template has everything hardcoded, so
it should be ok). However no mail gets sent and nothing is in log.
This scrip should be running because in rt.log I can see:
[debug]: Found 1 scrips
(/usr/share/request-tracker3.6/lib/RT/Scrips_Overlay.pm:365)
which is changed to 0 when I disable the scrip.
I have enabled the $DevelMode, and set $LogToFile to 'debug' (I have
even tried to set $LogToSyslog to 'debug'), restarted the server, but
nothing happened. There is nothing in rt.log, syslog, apache error.log,
nowhere.
Could you please help me finding where the problem can be?
Best regards
Martin
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Infinite login cycle
As far as I know no one has changed any passwords. Mike Johnson wrote: > Hmm, > > This has caused flashbacks of something when I first inherited the RT system > at our institution > > I can't remember where it was, but the problem I had was a password that was > used somewhere in the RT system... got changed... and it was causing this > login request on each click... > > I'm trying to remember more, of where it was, and how I fixed it, but I can't > seem to remember... if I do remember anything more, I'll let you know. > > > Perhaps this might spark something enough to get your rolling though has > anyone changed any RT related passwords? > > Mike Johnson > Datatel Programmer/Analyst > Northern Ontario School of Medicine > 955 Oliver Road > Thunder Bay, ON P7B 5E1 > Phone: (807) 766-7331 > Email: mike.john...@normed.ca > Technology assistance: email nosmhelpd...@normed.ca > Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat > holidays: > Off campus toll free 1 (800) 461-8777, option 8, or locally either > (705) 662-7120 or (807) 766-7500 > > Larry Garfield 3/8/2010 1:13 PM >>> > Greetings. > > Starting earlier today, we started experiencing the same issue as > described in this message: > > http://lists.bestpractical.com/pipermail/rt-users/2010-February/063573.html > > We are able to log in successfully, but after doing so the next link we > click goes back to a login page. > > However, unlike that message we have not recently upgraded. We are > running RT 3.8.5 and have been doing so since we first installed RT. > I'm not sure then what would have triggered this issue. > > One of the replies to that email suggested removing > local/html/autohandler. I do not fully understand what that means, but > there is no such file present. And since there was no update I'm not > quite sure how it could have changed. > > Anyone have another suggestion? :-) > -- Larry Garfield Senior Architect Palantir.net 2211 N. Elston Avenue, Suite 202 Chicago IL 60614 p 773.645.4100 ext. 301 f 773.645.4105 e garfi...@palantir.net ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Rt RightsMatrix
Hi Ken, i don't think so, rtx::Rightsmatrix is a little outdate and does not support the new plugin structure of rt, you can install it the old way... torsten 2010/3/8 Ken Crocker > To list, > > In order to get Rights Matrix to work in RT, do I need to put > "RT::RightsMatrix" into the plugins list after installation? > > Thanks. > > Kenn > LBNL > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > 2010 RT Training Sessions! > San Francisco, CA, USA - Feb 22 & 23 > Dublin, Ireland - Mar 15 & 16 > Boston, MA, USA - April 5 & 6 > Washington DC, USA - Oct 25 & 26 > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- MFG Torsten Brumm http://www.brumm.me http://www.elektrofeld.de ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Infinite login cycle
As far as I know, both. It's a hosted system but we've made no changes to it recently and the web host has not told us they've made any. Kevin W. Gagel wrote: > Larry, > > When you say there were no upgrades are you referring to RT only or the > whole machine? > >>From Kevin W. Gagel > > -Original Message- > From: rt-users-boun...@lists.bestpractical.com > [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Larry > Garfield > Sent: March-08-10 10:13 AM > To: rt Users > Subject: [rt-users] Infinite login cycle > > Greetings. > > Starting earlier today, we started experiencing the same issue as > described in this message: > > http://lists.bestpractical.com/pipermail/rt-users/2010-February/063573.html > > We are able to log in successfully, but after doing so the next link we > click goes back to a login page. > > However, unlike that message we have not recently upgraded. We are > running RT 3.8.5 and have been doing so since we first installed RT. > I'm not sure then what would have triggered this issue. > > One of the replies to that email suggested removing > local/html/autohandler. I do not fully understand what that means, but > there is no such file present. And since there was no update I'm not > quite sure how it could have changed. > > Anyone have another suggestion? :-) > -- Larry Garfield Senior Architect Palantir.net 2211 N. Elston Avenue, Suite 202 Chicago IL 60614 p 773.645.4100 ext. 301 f 773.645.4105 e garfi...@palantir.net ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Change queue with a scrip before ticket creation.
On Tue, 2010-03-02 at 20:12 -0500, Jason A. Smith wrote: > > It's possible, but is more complicated. Can you describe why moving > > ticket between queues doesn't work for you? > > The ticket would end up in the correct queue, but it generates some > unnecessary email in the process when the admin watchers of the original > queue are notified about the new ticket in their queue when it is > created, when in fact it isn't meant for them, unless this can be > suppressed when the needed queue move is detected. Will a false return > from the custom action prep code prevent this? I guess I need to refer > to my RT Essentials book again, tomorrow morning since it is in my > office. > > Also, the default queue change template is just a basic change > notification, so it doesn't contain the original problem description. I > suppose with some extra logic, the original problem description could be > added to some (or maybe all) of the queue change notification emails. I updated our queue change template to include the original content from the ticket creation transaction, that part wasn't too difficult. I even got the create scrip to look at the message and identify what I need, but I am having trouble duplicating what the built-in scrip does when it executes the Notify AdminCc action. I am trying to get the scrip to not notify anyone when the ticket is automatically moved to a different queue, which is easy, but if the ticket is not moved, it should notify the AdminCcs, just like normal. What code in a Scrip will duplicate that default notify action? ~Jason -- /--\ | Jason A. Smith Email: smit...@bnl.gov | | Atlas Computing Facility, Bldg. 510MPhone: +1-631-344-4226 | | Brookhaven National Lab, P.O. Box 5000 Fax: +1-631-344-7616 | | Upton, NY 11973-5000, U.S.A. | \--/ smime.p7s Description: S/MIME cryptographic signature ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Infinite login cycle
Greetings. Starting earlier today, we started experiencing the same issue as described in this message: http://lists.bestpractical.com/pipermail/rt-users/2010-February/063573.html We are able to log in successfully, but after doing so the next link we click goes back to a login page. However, unlike that message we have not recently upgraded. We are running RT 3.8.5 and have been doing so since we first installed RT. I'm not sure then what would have triggered this issue. One of the replies to that email suggested removing local/html/autohandler. I do not fully understand what that means, but there is no such file present. And since there was no update I'm not quite sure how it could have changed. Anyone have another suggestion? :-) -- Larry Garfield Senior Architect Palantir.net 2211 N. Elston Avenue, Suite 202 Chicago IL 60614 p 773.645.4100 ext. 301 f 773.645.4105 e garfi...@palantir.net ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Rt RightsMatrix
To list, In order to get Rights Matrix to work in RT, do I need to put "RT::RightsMatrix" into the plugins list after installation? Thanks. Kenn LBNL ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Question on Reminders
Emmanuel, Thanks. Kenn. On 3/5/2010 11:38 PM, Emmanuel Lacour wrote: On Fri, Mar 05, 2010 at 01:05:27PM -0800, Ken Crocker wrote: To list, In 3.6 reminders didn't pass along with the ticket when moved to another queue. They also did not go away when the ticket (owning the reminder) was resolved. My question is, were either of these situations resolved with 3.8? I didn't see anything in the list. Thanks. Yes it was resolved with commit 605161548e455107b3c60ed8d2134b772fd04568. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 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: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] slightly unusual question regarding mail spools
So I am on my second incarnation of rt being setup on an ubuntu box and now I seem to have an interesting issue. 9.10 with some updates using a manual force command to get the tracker working gets this issue /etc/aliases has rt: "|/usr/bin/rt-mailgate --queue 'General' --action correspond --url http://localhost/"; I used cat /var/spool/mail/rt | /usr/bin/rt-mailgate --queue General --action correspond --url http://localhost/rt/ now this is on a system where just for fun I gave it maximum rights for everyone and everything (not connected to the internet of course) and not only did only the first ticket get processed but the ticket was just left there so the first email int he user for the rt instance just got processed again and again and again IIRC this is not the behavior of the system when piped manually maybe 6 months ago However when I manually delete the one message it will go onto the next again only that one message at the "top" of the spool. Also when trying to invoke this command even from root it gets a 403 forbidden only on the user "rt". Thanks in advance for the guidance :) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Rights management question
Yes thanks, CF rights start to make sence now ... Le 5 mars 2010 19:12, Ken Crocker a écrit : > Charles, > > What I think you're missing is that even though Custom Fields are *applied > * to Queues, the privileges to See/Modify/Admin them is *granted via > Groups*. That means I could apply a CF to 3 different Queues and if I > didn't grant any groups any rights to see/modify/admin that CF, then no one > would even see that CF, let alone modify it, even though it *has been > applied*. > This is a good thing. For example. I may have 3 different groups with > access to a Queue where the CF is applied. I may want one group to only see > the CF, not modify a value in it or modify it's name or available values > (given it is a "select value" type). I may want another group to actually > modify (change the "selected" value in it) it for a given ticket and have > another group of a few members Admin (add/modify values available for > selection) the CF. > Does that make any sense? I hope I've been able to help you with this. > > Kenn > LBNL > > > On 3/5/2010 9:18 AM, Charles-Noël Bouteville wrote: > > > Le 5 mars 2010 17:36, Jerrad Pierce a > écrit : > > > each custom field rights by Roles. The Roles Rights on CF can only be >> > granted in Global way? So am i missing something ? >> The fact that CFs themselves may be selectively applied to queues? > > > Yes but in in a queue ? > > For instance in queue1, the Cc can see CF1 and CF2 and the AdminCc see CF1, > CF2, CF3 and can modified only CF1. Is that Possible ? > > >> > Second >> > Can i set a filter on the right Showticket? >> > For instance, i would grant some user too see only tickets created by >> > someone who has in his mail where is match by a Regex ? >> No. Seems far outside the realm of general utility and a PITA. >> What you could do is create a scrip that checks your conditions >> and adds the individual in question as (squelched) requestor/cc >> OnCreate. > > > Ok thank > > >> Alternatively, setup you groups and queues to match this mapping >> as best as possible. > > > -- > Cambridge Energy Alliance: Save money. Save the planet. > > > -- > > ___http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > 2010 RT Training Sessions! > San Francisco, CA, USA - Feb 22 & 23 > Dublin, Ireland - Mar 15 & 16 > Boston, MA, USA - April 5 & 6 > Washington DC, USA - Oct 25 & 26 > > 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: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Rights management question
Le 5 mars 2010 18:47, Jerrad Pierce a écrit : > > For instance in queue1, the Cc can see CF1 and CF2 and the AdminCc see > CF1, > > CF2, CF3 and can modified only CF1. Is that Possible ? > Yes, as long as you want the same rights for whatever other queues > those CFs are applied to and those users can access. > Ok So Roles Rights on CF can only be set in global. that mean in "Queue right -> Cc" SeeCF -> user can see all applied CF ModCF -> user can modified all seen CF And there is no right management for the Role similar to groups that let me select rights on each CF > > -- > Cambridge Energy Alliance: Save money. Save the planet. > ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] "More about" box loads very slowly
On Mon, Mar 08, 2010 at 04:32:21PM +0300, Ruslan Zakirov wrote: > Create primary key on Users(id). Drop index Users3. As an option make > keys Users2 and Users4 unique. > Create index on CachedGroupMembers(MemberId, GroupId, Disabled) and > reversed one CachedGroupMembers(GroupId, MemberId, Disabled). It might be useful to add this information to the wiki here: http://wiki.bestpractical.com/view/DatabaseIndexes Cheers, Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford signature.asc Description: Digital signature ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] "More about" box loads very slowly
Hello, David. On Mon, Mar 8, 2010 at 3:55 PM, David X. Glover wrote: > On 8 Mar 2010, at 10:29, David X. Glover wrote: [snip] > mysql> SHOW INDEX FROM Users; > +---++--+--+--+---+-+--++--++-+ > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | > Cardinality | Sub_part | Packed | Null | Index_type | Comment | > +---++--+--+--+---+-+--++--++-+ > | Users | 1 | Users2 | 1 | Name | A | > 512 | NULL | NULL | | BTREE | | > | Users | 1 | Users3 | 1 | id | A | > 512 | NULL | NULL | YES | BTREE | | > | Users | 1 | Users3 | 2 | EmailAddress | A | > 512 | NULL | NULL | YES | BTREE | | > | Users | 1 | Users4 | 1 | EmailAddress | A | > 512 | NULL | NULL | YES | BTREE | | > +---++--+--+--+---+-+--++--++-+ Create primary key on Users(id). Drop index Users3. As an option make keys Users2 and Users4 unique. > mysql> SHOW INDEX FROM CachedGroupMembers; > +++--+--+-+---+-+--++--++-+ > | Table | Non_unique | Key_name | Seq_in_index | Column_name | > Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | > +++--+--+-+---+-+--++--++-+ > | CachedGroupMembers | 0 | PRIMARY | 1 | id | A > | 16498 | NULL | NULL | | BTREE | | > +++--+--+-+---+-+--++--++-+ Create index on CachedGroupMembers(MemberId, GroupId, Disabled) and reversed one CachedGroupMembers(GroupId, MemberId, Disabled). Instructions on dropping indexes and creating new you can find in mysql's documentation. -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] "More about" box loads very slowly
On 8 Mar 2010, at 10:29, David X. Glover wrote: > We're running RT 3.6.5* on MySQL 5.0.51a, and the "More about " box on > the ticket display page takes several seconds to load. > > I've seen other people with this problem on the list, but never a solution. > > Does anyone have any ideas about what this specific box is doing and why it's > so slow? Extra info: This is the SQL query causing the problem: SELECT DISTINCT main.* FROM Tickets main CROSS JOIN Users Users_3 JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Users_3.id ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id ) WHERE (Users_3.id = '7611') AND (main.Status != 'deleted') AND ( ( CachedGroupMembers_2.id IS NOT NULL ) AND ( main.Status = 'open' OR main.Status = 'new' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY main.Priority DESC LIMIT 10; And some more diagnostic information: (Caution, wide lines ahead.) mysql> EXPLAIN SELECT DISTINCT main.* FROM Tickets main CROSS JOIN Users Users_3 JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Users_3.id ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id ) WHERE (Users_3.id = '7611') AND (main.Status != 'deleted') AND ( ( CachedGroupMembers_2.id IS NOT NULL ) AND ( main.Status = 'open' OR main.Status = 'new' ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ORDER BY main.Priority DESC LIMIT 10; Current database: rt ++-+--+++-+-+--+---+---+ | id | select_type | table| type | possible_keys | key | key_len | ref | rows | Extra | ++-+--+++-+-+--+---+---+ | 1 | SIMPLE | Users_3 | ref| Users3 | Users3 | 5 | const| 2 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | Groups_1 | ALL| NULL | NULL| NULL| NULL | 7109 | Using where | | 1 | SIMPLE | CachedGroupMembers_2 | ALL| PRIMARY | NULL| NULL| NULL | 16484 | Using where | | 1 | SIMPLE | main | eq_ref | PRIMARY,Tickets3,Tickets4,Tickets5 | PRIMARY | 4 | rt.Groups_1.Instance | 1 | Using where | ++-+--+++-+-+--+---+---+ mysql> SHOW INDEX FROM Users; +---++--+--+--+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +---++--+--+--+---+-+--++--++-+ | Users | 1 | Users2 |1 | Name | A | 512 | NULL | NULL | | BTREE | | | Users | 1 | Users3 |1 | id | A | 512 | NULL | NULL | YES | BTREE | | | Users | 1 | Users3 |2 | EmailAddress | A | 512 | NULL | NULL | YES | BTREE | | | Users | 1 | Users4 |1 | EmailAddress | A | 512 | NULL | NULL | YES | BTREE | | +---++--+--+--+---+-+--++--++-+ mysql> SHOW INDEX FROM CachedGroupMembers; +++--+--+-+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +++--+--+-+---+-+
Re: [rt-users] "More about" box loads very slowly
Hello, It usually means missing key on CachedGroupMembers table, you need an index on (MemberId, GroupId) columns. Order of columns is important. On Mon, Mar 8, 2010 at 1:29 PM, David X. Glover wrote: > We're running RT 3.6.5* on MySQL 5.0.51a, and the "More about " box on > the ticket display page takes several seconds to load. > > I've seen other people with this problem on the list, but never a solution. > > Does anyone have any ideas about what this specific box is doing and why it's > so slow? > > Cheers. > > *Yes, we acknowledge that it's out of date and we do have plans to upgrade, > just not immediately. > -- > David X. Glover > Department of Physics > University of Oxford > http://www.physics.ox.ac.uk/ > > ___ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > 2010 RT Training Sessions! > San Francisco, CA, USA - Feb 22 & 23 > Dublin, Ireland - Mar 15 & 16 > Boston, MA, USA - April 5 & 6 > Washington DC, USA - Oct 25 & 26 > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] "More about" box loads very slowly
We're running RT 3.6.5* on MySQL 5.0.51a, and the "More about " box on the ticket display page takes several seconds to load. I've seen other people with this problem on the list, but never a solution. Does anyone have any ideas about what this specific box is doing and why it's so slow? Cheers. *Yes, we acknowledge that it's out of date and we do have plans to upgrade, just not immediately. -- David X. Glover Department of Physics University of Oxford http://www.physics.ox.ac.uk/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT external auth does not working
Praveen C wrote:
> Hi
>
> I installed RT 3.8 in debian lenny server. Installed plug-in
> "RT-Authen-ExternalAuth-0.08" but could not contact to my LDAP. Ldap
> configuration in RT_SiteConfig.pm is like this. LDAP server ad RT are
> installed in same machine
>
> Set( @Plugins, qw(RT::Authen::ExternalAuth) );
>
> Set($ExternalAuthPriority, ['My_LDAP']);
> Set($ExternalInfoPriority, ['My_LDAP']);
> Set($AutoCreateNonExternalUsers, 1);
> Set($ExternalSettings, {
> 'My_LDAP' => {
> 'type' => 'ldap',
> 'server' => 'localhost',
> 'base' => 'ou=People,dc=example,dc=com',
> 'filter' => '(objectClass=*)',
>
> 'attr_match_list' => ['Name',
> 'EmailAddress'],
>
> 'attr_map' => { 'Name' => 'uid',
> 'EmailAddress' => 'mail',
> 'RealName' => 'cn',
> 'ExternalAuthId' => 'uid',
> 'Gecos' => 'gecos',
>}
> }
> }
> );
You have removed
'auth' => 1,
'info' => 1,
You have no d_filter.
Go back to the example config and read it thoroughly.
--
Kind Regards,
__
Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com
__
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT external auth does not working
Hi
I installed RT 3.8 in debian lenny server. Installed plug-in
"RT-Authen-ExternalAuth-0.08" but could not contact to my LDAP. Ldap
configuration in RT_SiteConfig.pm is like this. LDAP server ad RT are installed
in same machine
Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($ExternalAuthPriority, ['My_LDAP']);
Set($ExternalInfoPriority, ['My_LDAP']);
Set($AutoCreateNonExternalUsers, 1);
Set($ExternalSettings, {
'My_LDAP' => {
'type' => 'ldap',
'server' => 'localhost',
'base' => 'ou=People,dc=example,dc=com',
'filter' => '(objectClass=*)',
'attr_match_list' => ['Name',
'EmailAddress'],
'attr_map' => { 'Name' => 'uid',
'EmailAddress' => 'mail',
'RealName' => 'cn',
'ExternalAuthId' => 'uid',
'Gecos' => 'gecos',
}
}
}
);
When I checked my apache error log, I am got authentication error like this
[error]: FAILED LOGIN for pravin from 10.74.99.20
(/usr/share/request-tracker3.8/lib/RT/Interface/Web.pm:424)
Hope RT should use ExternalAuth.pm for authentication. It looks like RT doesnt
use External Auth plugin.
I changed LDAP debug level to 256. But I cannot find any request coming to my
ldap server
Thanks for any support
-Praveen-
_
Fight for the top Test spot
http://sports.in.msn.com/cricket/ ___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com
2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
