Re: [rt-users] 0 tickets found when using custom fields
I extracted query which RT sends to database server.
Query 'CF.{Approval}' LIKE '1. Pending' which is in RT current search
field.
2008/3/5, Kenneth Crocker [EMAIL PROTECTED]:
Arkadiusz,
Is this query you are writing in RT/Ticket SQL or native SQL? I
use RT
query with custom fields all the time for reporting and have no problem
at all. I also use native SQL for other queries on our Oracle DataBase.
Using native SQL against the DataBase, however, requires some finesse
when trying to get certain data. For example, to get the value of a CF
that is applied to tickets in a queue I could use the Ticket ID to go to
the OBJECTCUSTOMFIELDVALUES, make sure it is a ticket CF and not
disabled and use the CONTENT from OBJECTCUSTOMFIELDVALUES with any other
Ticket data for my report. I don't see a need for all those joins. But
hey, that's just me. Hope this helps.
Kenn
LBNL
On 3/5/2008 12:45 AM, Arkadiusz Jakubas wrote:
It this some kind of bug ?
2008/2/14, Arkadiusz Jakubas [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]:
I extracted sql query ( 'CF.{Approval}' LIKE '1. Pending' ) :
SELECT COUNT(DISTINCT main.id http://main.id) FROM (((Tickets
main LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON
((ObjectCustomFields_1.ObjectId = '0')) AND(
ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN CustomFields
CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFields_1.CustomField)) LEFT JOIN
ObjectCustomFieldValues ObjectCustomFieldValues_3 ON
((ObjectCustomFieldValues_3.ObjectId = main.id http://main.id))
AND( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id)
AND( (ObjectCustomFieldValues_3.Disabled = '0')) AND(
(ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket'))) WHERE
((CustomFields_2.Name = 'Approval')) AND ((main.EffectiveId =
main.id http://main.id)) AND ((main.Status != 'deleted')) AND
((main.Type = 'ticket')) AND ( ( (ObjectCustomFieldValues_3.Content
LIKE '%1. Pending%') ) )
result :
+-+
| COUNT(DISTINCT main.id http://main.id) |
+-+
| 0 |
+-+
Then i modified query a little removed:
(ObjectCustomFieldValues_3.Content LIKE '%1. Pending%')
and
(CustomFields_2.Name = 'Approval'))
changed from:
SELECT COUNT(DISTINCT main.id http://main.id)
to
SELECT *
query:
SELECT * FROM (((Tickets main LEFT JOIN ObjectCustomFields
ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId = '0'))
AND( ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN
CustomFields CustomFields_2 ON ( CustomFields_2.id =
ObjectCustomFields_1.CustomField)) LEFT JOIN
ObjectCustomFieldValues ObjectCustomFieldValues_3 ON
((ObjectCustomFieldValues_3.ObjectId = main.id http://main.id))
AND( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id)
AND( (ObjectCustomFieldValues_3.Disabled = '0')) AND(
(ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket'))) WHERE
((main.EffectiveId = main.id http://main.id)) AND ((main.Status !=
'deleted')) AND ((main.Type = 'ticket')) order by main.LastUpdated
desc limit 100 ;
some result:
| id| EffectiveId | Queue | Type | IssueStatement | Resolution
| Owner | Subject | InitialPriority |
FinalPriority | Priority | TimeEstimated | TimeWorked | Status |
TimeLeft | Told| Starts |
Started | Due | Resolved|
LastUpdatedBy | LastUpdated | Creator | Created
| Disabled | id | CustomField | ObjectId | SortOrder | Creator |
Created | LastUpdatedBy | LastUpdated | id | Name | Type |
Description | SortOrder | Creator | Created | LastUpdatedBy |
LastUpdated | Disabled | LookupType | Repeated | Pattern | MaxValues
| id | ObjectId | CustomField | Content | Creator | Created |
LastUpdatedBy | LastUpdated | ObjectType | LargeContent |
ContentType | ContentEncoding | SortOrder | Disabled |
[rt-users] SOT: high performance web cache for RT
I found a very interesting software project, which boost my RT test instance. http://varnish.projects.linpro.no/ due to the nature of cache systems it is not working with https traffic, but nevertheless It could be helpful for a lot of environments. And I will try a combined solution with pound and varnish, may this will work. regards sven ___ 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] Apache user environment
most probably it's a problem with permissions on those dirs
On Thu, Mar 6, 2008 at 2:44 PM, Musolino, Peter
[EMAIL PROTECTED] wrote:
Apologies if this has been asked before, and its more an environment problem
as it pertains to RT.
After installing all requisite perl modules, rpms, etc, making install,
configuring files, I am having issues with apache keeping mason_handler.fcgi
running. It crashes out as it cannot locate Locale::Maketext::Lexicon with
the Can't locate Locale/Maketext/Lexicon.pm in @INC (@INC contains: ……
I installed all the modules from CPAN which placed most of them in
/usr/lib/perl5/site_perl. I copied the Lexicon module as well as the other
requisite modules in Locale/Maketext to /usr/lib/perl5/5.8.5/ which quelled
that error, but then it could not find DBIx::SearchBuilder. I tried the
same trick with copying it down a level, but this did not soothe the savage
beast.
Upon looking at the issue, I noticed that running it as root or some other
user, that I had no compilation errors:
root # perl
use Locale::Maketext::Lexicon;
However, running it as apache:
root# sudo -u apache perl
use Locale::Maketext::Lexicon;
Can't locate Locale/Maketext/Lexicon.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.
The apache user seems to have the proper perl include paths, pointing out
the designated location of the aforementioned cpan installation point:
root # sudo -u apache perl
foreach $i (@INC) {
print $i;
print \n;
}
/usr/lib/perl5/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
|--- /usr/lib/perl5/site_perl/5.8.5 ---|
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl
Has anyone had this type of problem before?
Thanks in advance for any help
Regards,
Peter Musolino
[EMAIL PROTECTED]
This e-mail message is intended only for the named recipient(s) above. It
may contain confidential information. If you are not the intended recipient,
you are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail and
any attachment(s) is strictly prohibited. D.B. Zwirn Co., L.P. reserves
the right to archive
and monitor all e-mail communications through its networks. If you have
received this e-mail in error, please immediately notify the sender by
replying to this e-mail and
delete the message and any attachment(s) from your system. Thank you.
___
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] Mandatory/Required custom field
Torsten Brumm wrote: Hi Kenneth, thats true, i forgot i added someting from the wiki, the ability to change the cf's during each reply, comment. Without this, a user wouldn't touch the cf during this, thats correct. OK, so last open issue should be the resolve part, here rt must check if the field is set or not. The situation with this is a little confusing, but I still have unexplainable behaviour with custom field mandating. Privileged users are not allowed to create a ticket via the web ui without specifying a value for the mandatory ticket custom fields. UNprivileged users ARE allowed to create a ticket without selecting/specifying a value! I have no idea why! Any ideas? I would help by showing my rights matrix, but I cant get RT-RightsMatrix installed and I can't get any help installing it :/ -- 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] merged tickets hanging browser for a long time
Hi, A user reported that one of their tickets was hanging their browser, and sure enough when I tried, it took a very long time to load, and when it did it was rendered badly. I checked the logs and the following was repeated many 100s of times; [Thu Mar 6 11:23:29 2008] [debug]: We found a merged ticket.557/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) [Thu Mar 6 11:23:31 2008] [debug]: We found a merged ticket.557/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) [Thu Mar 6 11:23:59 2008] [debug]: We found a merged ticket.568/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) [Thu Mar 6 11:24:00 2008] [debug]: We found a merged ticket.568/567 (/opt/rt3/lib/RT/Ticket_Overlay.pm:273) Any ideas how I can unjam that ticket? Thanks, Tom ___ 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] Apache user environment
Apologies if this has been asked before, and its more an environment
problem as it pertains to RT.
After installing all requisite perl modules, rpms, etc, making install,
configuring files, I am having issues with apache keeping
mason_handler.fcgi running. It crashes out as it cannot locate
Locale::Maketext::Lexicon with the Can't locate
Locale/Maketext/Lexicon.pm in @INC (@INC contains: ..
I installed all the modules from CPAN which placed most of them in
/usr/lib/perl5/site_perl. I copied the Lexicon module as well as the
other requisite modules in Locale/Maketext to /usr/lib/perl5/5.8.5/
which quelled that error, but then it could not find
DBIx::SearchBuilder. I tried the same trick with copying it down a
level, but this did not soothe the savage beast.
Upon looking at the issue, I noticed that running it as root or some
other user, that I had no compilation errors:
root # perl
use Locale::Maketext::Lexicon;
However, running it as apache:
root# sudo -u apache perl
use Locale::Maketext::Lexicon;
Can't locate Locale/Maketext/Lexicon.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl .) at - line 1.
BEGIN failed--compilation aborted at - line 1.
The apache user seems to have the proper perl include paths, pointing
out the designated location of the aforementioned cpan installation
point:
root # sudo -u apache perl
foreach $i (@INC) {
print $i;
print \n;
}
/usr/lib/perl5/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
|--- /usr/lib/perl5/site_perl/5.8.5 ---|
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl
Has anyone had this type of problem before?
Thanks in advance for any help
Regards,
Peter Musolino
[EMAIL PROTECTED]
This e-mail message is intended only for the named recipient(s) above. It may
contain confidential information. If you are not the intended recipient, you
are hereby noti
fied that any use, dissemination, distribution or copying of this e-mail and
any attachment(s) is strictly prohibited. D.B. Zwirn Co., L.P. reserves the
right to archive
and monitor all e-mail communications through its networks. If you have
received this e-mail in error, please immediately notify the sender by replying
to this e-mail and
delete the message and any attachment(s) from your system. Thank you.
___
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] testing ability to post
Hasn't been working lately. -- Keep up with me and what I'm up to: http://theillien.blogspot.com ___ 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] SOT: high performance web cache for RT
Sven Sternberger wrote: I found a very interesting software project, which boost my RT test instance. http://varnish.projects.linpro.no/ due to the nature of cache systems it is not working with https traffic, but nevertheless It could be helpful for a lot of environments. And I will try a combined solution with pound and varnish, may this will work. We use exactly this with RT. In order to get HTTPS capability we are using pound to do the SSL decryption stuff -- works a treat. Alternatively you could use stunnel as a replacement for pound, but we haven't actually tried that. varnish is highly recommended. Cheers, Matthew -- Dr Matthew SeamanThe Bunker, Ash Radar Station PGP: 0x60AE908C on servers Marshborough Rd Tel: +44 1304 814890 Sandwich Fax: +44 1304 814899 Kent, CT13 0PL, UK signature.asc Description: OpenPGP digital signature ___ 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] On Queue Change, what queue scrip acts?
At Wednesday 3/5/2008 11:05 PM, lgrella wrote: I am trying to set up scrips for my queues so that when a queue is changed, the owner in the new queue is set to a default queue owner for that new queue. It is not working. I have some questions about when the scrips are runWhen the onQueueChange scrip is run, is it run from the old queue's scrip or the new queue's scrip? I am writing it as if it is run in the new queue - i.e it was in queue A and now it switches to queue B. I want the scrip to run in queue B that will change it to a default owner for queue B. Does this make sense? The code I use is the same code I used to set a default owner on create, but commented out a few lines. This is the code that I have in the custom action clean up code for the new queue (queue B): The scrip fires on the new queue, so you're on the right track. Did you remember to set the action to 'User defined'? Do you see anything in the RT log from your debug statements? Steve ___ 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] On Queue Change, what queue scrip acts?
At Thursday 3/6/2008 10:20 AM, Laura Grella wrote: Thank you so much for your reply. It actually works, but the way I was testing it was making me think it didn't. If the ticket changed to a queue where the owner had rights in the new queue also, it didn't change the owner to the default. At first I thought it needed to always change to the default, but it is ok if it works this way. How do I check the RT log? I have not used any debug statements, but this would come in handy in the future. Thanks, Laura Hello Laura, Glad it's working - I should have said logging statements, rather then debug statements. Lines like this should show up in the RT log, depending on config settings: $RT::Logger-info(Auto assigning ticket #. $self-TicketObj-id . to user $MyUser ); The RT log by default is in $RTHOME/var/log Steve ___ 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] SOT: high performance web cache for RT
Interesting. Do you run it on the same system as RT or would it not be as effective that way? On 3/6/08, Sven Sternberger [EMAIL PROTECTED] wrote: I found a very interesting software project, which boost my RT test instance. http://varnish.projects.linpro.no/ due to the nature of cache systems it is not working with https traffic, but nevertheless It could be helpful for a lot of environments. And I will try a combined solution with pound and varnish, may this will work. regards sven ___ 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 ___ 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] SOT: high performance web cache for RT
On 3/6/2008 7:26 AM, Sven Sternberger wrote: I found a very interesting software project, which boost my RT test instance. http://varnish.projects.linpro.no/ due to the nature of cache systems it is not working with https traffic, but nevertheless It could be helpful for a lot of environments. And I will try a combined solution with pound and varnish, may this will work. How can a caching proxy help on a site with dynamic content (e.g. RT)? -- Regards, joe Joe Casadonte [EMAIL PROTECTED] == == == The statements and opinions expressed here are my own and do not == == necessarily represent those of Oracle Corporation. == == == ___ 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] On Queue Change, what queue scrip acts?
Thanks! Stephen Turner wrote: At Thursday 3/6/2008 10:20 AM, Laura Grella wrote: Thank you so much for your reply. It actually works, but the way I was testing it was making me think it didn't. If the ticket changed to a queue where the owner had rights in the new queue also, it didn't change the owner to the default. At first I thought it needed to always change to the default, but it is ok if it works this way. How do I check the RT log? I have not used any debug statements, but this would come in handy in the future. Thanks, Laura Hello Laura, Glad it's working - I should have said logging statements, rather then debug statements. Lines like this should show up in the RT log, depending on config settings: $RT::Logger-info(Auto assigning ticket #. $self-TicketObj-id . to user $MyUser ); The RT log by default is in $RTHOME/var/log Steve ___ 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 -- View this message in context: http://www.nabble.com/On-Queue-Change%2C-what-scrip-acts-in-which-queue---old-or-new--tp15866097p15877184.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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] SOT: high performance web cache for RT
Hi sven, Did you have any test results? I'm with joe, a caching proxy wont help, but i'm not a proxy pro ;-) Torsten Kühne + Nagel (AG Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Alfred Manke, Thorsten Meincke, Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: Sven Sternberger [EMAIL PROTECTED] CC: rt-users@lists.bestpractical.com RT-Users@lists.bestpractical.com Sent: Thu Mar 06 17:10:21 2008 Subject: Re: [rt-users] SOT: high performance web cache for RT On 3/6/2008 7:26 AM, Sven Sternberger wrote: I found a very interesting software project, which boost my RT test instance. http://varnish.projects.linpro.no/ due to the nature of cache systems it is not working with https traffic, but nevertheless It could be helpful for a lot of environments. And I will try a combined solution with pound and varnish, may this will work. How can a caching proxy help on a site with dynamic content (e.g. RT)? -- Regards, joe Joe Casadonte [EMAIL PROTECTED] == == == The statements and opinions expressed here are my own and do not == == necessarily represent those of Oracle Corporation. == == == ___ 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 ___ 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] Re move fields (adminCC) from Form?
Thanks! Joe Casadonte-2 wrote: On 3/6/2008 10:24 AM, lgrella wrote: Is there any way to remove fields (specifically adminCC or CC) fields from the form to create new tickets? Go into Ticket/Create.html and comment them out. See the CleanlyCustomizeRT wiki entry for a good starting place on how to best do this. -- Regards, joe Joe Casadonte [EMAIL PROTECTED] == == == The statements and opinions expressed here are my own and do not == == necessarily represent those of Oracle Corporation. == == == ___ 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 -- View this message in context: http://www.nabble.com/Remove-fields-%28adminCC%29-from-Form--tp15874288p15877650.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ 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] Emailing tickets search result
Not yet, nope. On Mar 5, 2008, at 2:46 AM, Eynat Nir Mishor wrote: Hi Jesse, Was this feature published? Thanks, Eynat -Original Message- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: Monday, 11 February 2008 12:27 PM To: Eynat Nir Mishor Cc: 'Todd Chapman'; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Emailing tickets search result On Mon, Feb 11, 2008 at 11:05:00AM +0200, Eynat Nir Mishor wrote: That's my fallback. But I prefer a self-containing email rather than a link. We have something kind of cool along these lines that we're working to get opensourced. I'm hopeful that it will happen this week. Eynat -Original Message- From: Todd Chapman [mailto:[EMAIL PROTECTED] Sent: Monday, 11 February 2008 5:12 AM To: Eynat Nir Mishor Cc: Toby Darling; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Emailing tickets search result Why don't you just email a link to a search so that it runs when clicked? On 2/7/08, Eynat Nir Mishor [EMAIL PROTECTED] wrote: Thanks - it does the job, but it has two drawbacks: 1. It produces very simple textual output. I would like to send a richer HTML output similar to how search results appear in RT. 2. It is hard to customize. I would like to use a template mechanism for easy customization that my occur later in time. Eynat -Original Message- From: Toby Darling [mailto:[EMAIL PROTECTED] Sent: Wednesday, 06 February 2008 7:24 PM To: Eynat Nir Mishor Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Emailing tickets search result Hi Example for usage: every night email the manager a list of all tickets that were created in the past day and how they divide by current status. Simple command line: for s in open new resolved; do echo === $s ===; rt list -s created = 'today' AND status = '$s'; done | mail ... LEGAL NOTICE Unless expressly stated otherwise, information contained in this message is confidential. If this message is not intended for you, please inform [EMAIL PROTECTED] and delete the message. The Cambridge Crystallographic Data Centre is a company Limited by Guarantee and a Registered Charity. Registered in England No. 2155347 Registered Charity No. 800579 Registered office 12 Union Road, Cambridge CB2 1EZ. ___ 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 ___ 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 -- PGP.sig Description: This is a digitally signed message part ___ 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] ldap auth succeeds but autocreate fails
Hi,
i'm trying to set up rt to auto-create ldap authenticated users.
authentication from ldap works, all user attributes are mapped correctly
but new user creation fails. i've followed the guide in wiki.
here is my rt ldap configuration:
Set($AuthMethods, ['LDAP', 'Internal']);
Set($LdapExternalAuth, 1);
Set($LdapExternalInfo, 1);
Set($LdapAutoCreateNonLdapUsers, 1);
Set($LdapAttrMap, {'Name' = 'uid',
'EmailAddress' = 'mail',
'RealName' = 'cn',
'ExternalContactInfoId' = 'dn',
'ExternalAuthId' = 'uid',
'Gecos' = 'gecos',
'Comments' = 'gidNumber',
'id' = 'uidNumber'
}
);
Set($LdapRTAttrMatchList, ['ExternalContactInfoId', 'Name',
'EmailAddress', 'RealName']
);
Set($LdapEmailAttrMatchList, ['mail', 'mailRoutingAddress',
'mailAlternateAddress']
);
Set($LdapEmailAttrMatchPrefix, [''] );
Set($LdapServer, 'void');
Set($LdapBase, 'ou=people,dc=ceid,dc=upatras,dc=gr');
Set($LdapFilter, '(objectclass=*)');
Set($LdapDisableFilter, '(employmentStatus=Terminated)');
Set($LdapTLS, 1);
Set($LdapSSLVersion, 3);
a sample ldap user request
# ldapsearch -vx -h void -b dc=ceid, dc=upatras, dc=gr
(uid=voulgaris)
ldap_initialize( ldap://void )
filter: (uid=voulgaris)
requesting: All userApplication attributes
# extended LDIF
#
# LDAPv3
# base dc=ceid, dc=upatras, dc=gr with scope subtree
# filter: (uid=voulgaris)
# requesting: ALL
#
# voulgaris, people, ceid.upatras.gr
dn: uid=voulgaris,ou=people,dc=ceid,dc=upatras,dc=gr
uid: voulgaris
cn: Kon/nos Voulgaris
sn: Voulgaris
uidNumber: 3866
gidNumber: 2005
gecos: Kon/nos Voulgaris
objectClass: inetOrgPerson
objectClass: posixAccount
objectClass: top
objectClass: shadowAccount
objectClass: radiusprofile
loginShell: /bin/bash
mail: [EMAIL PROTECTED]
shadowMin: -1
shadowMax: 9
shadowWarning: -1
shadowInactive: -1
shadowExpire: -1
shadowFlag: -1
dialupAccess: yes
homeDirectory: /home/voulgaris
shadowLastChange: 13805
userPassword: {not shown}
# search result
search: 2
result: 0 Success
# numResponses: 2
# numEntries: 1
and my rt log entries.
[Thu Mar 6 15:26:05 2008] [warning]: Use of uninitialized value in
numeric eq (==) at /usr/share/request-tracker3.6/lib/RT/User_Overlay.pm
line 1787. (/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:1787)
[Thu Mar 6 15:26:05 2008] [warning]: Use of uninitialized value in
numeric eq (==) at /usr/share/request-tracker3.6/lib/RT/User_Overlay.pm
line 1787. (/usr/share/request-tracker3.6/lib/RT/User_Overlay.pm:1787)
#this maybe the root of the problem.
[Thu Mar 6 15:26:05 2008] [warning]: Transaction-Create couldn't, as
you didn't specify an object type and id
(/usr/share/request-tracker3.6/lib/RT/Record.pm:1466)
#ldap authentication succeeds
[Thu Mar 6 15:26:05 2008] [info]: RT::User::IsLDAPPassword AUTH OK:
voulgaris (uid=voulgaris,ou=people,dc=ceid,dc=upatras,dc=gr)
(/usr/share/request-tracker3.6/lib/RT/User_Local.pm:224)
#attributes map correctly
[Thu Mar 6 15:26:05 2008] [info]: RT::User::LookupExternalUserInfo :
ou=people,dc=ceid,dc=upatras,dc=gr uid=voulgaris = Comments: 2005,
EmailAddress: [EMAIL PROTECTED], ExternalAuthId: voulgaris,
ExternalContactInfoId: uid=voulgaris,ou=people,dc=ceid,dc=upatras,dc=gr,
Gecos: Kon/nos Voulgaris, Name: voulgaris, RealName: Kon/nos Voulgaris,
id: 3866 (/usr/share/request-tracker3.6/lib/RT/User_Local.pm:569)
[Thu Mar 6 15:26:05 2008] [info]: RT::User::LookupExternalUserInfo :
ou=people,dc=ceid,dc=upatras,dc=gr [EMAIL PROTECTED] =
Comments: 2005, EmailAddress: [EMAIL PROTECTED], ExternalAuthId:
voulgaris, ExternalContactInfoId:
uid=voulgaris,ou=people,dc=ceid,dc=upatras,dc=gr, Gecos: Kon/nos
Voulgaris, Name: voulgaris, RealName: Kon/nos Voulgaris, id: 3866
(/usr/share/request-tracker3.6/lib/RT/User_Local.pm:569)
[Thu Mar 6 15:26:05 2008] [info]: RT::User::CanonicalizeEmailAddress
[EMAIL PROTECTED] = [EMAIL PROTECTED]
(/usr/share/request-tracker3.6/lib/RT/User_Local.pm:347)
[Thu Mar 6 15:26:05 2008] [info]: RT::User::CanonicalizeUserInfo
returning Comments: 2005, Disabled: 0, EmailAddress:
[EMAIL PROTECTED], ExternalAuthId: voulgaris,
ExternalContactInfoId: uid=voulgaris,ou=people,dc=ceid,dc=upatras,dc=gr,
Gecos: Kon/nos Voulgaris, Name: voulgaris, Privileged: 0, RealName:
Kon/nos Voulgaris, id: 3866
(/usr/share/request-tracker3.6/lib/RT/User_Local.pm:413)
[Thu Mar 6 15:26:05 2008] [info]: RT::User::LookupExternalUserInfo :
ou=people,dc=ceid,dc=upatras,dc=gr [EMAIL PROTECTED] =
Comments: 2005, EmailAddress: [EMAIL PROTECTED], ExternalAuthId:
voulgaris, ExternalContactInfoId:
uid=voulgaris,ou=people,dc=ceid,dc=upatras,dc=gr, Gecos: Kon/nos
Voulgaris, Name: voulgaris, RealName: Kon/nos Voulgaris, id: 3866
(/usr/share/request-tracker3.6/lib/RT/User_Local.pm:569)
[Thu Mar 6 15:26:05 2008] [info]: RT::User::CanonicalizeEmailAddress
[EMAIL PROTECTED] = [EMAIL PROTECTED]
[rt-users] DBD::mysql issue
I'm having issue compiling rt 3.6.4, below is the error message. I've searched via google and implemented some of those recommendations but still no avail. I'm running Solaris 10 sparc, perl 5.8.8 from sunfreeware (and attempted to use the Sun's perl 5.8.4), mysql 64-bit, 32-bit (pkg and manually compile). Additionally, I installed gcc, libtool, libiconv, binutils, make, etc. from sunfreeware. Furthermore, I attempted to install DBD::mysql via perl CPAN and the same error message. I think this is the last hurdle I need to get over to compile rt. Any suggestions are greatly appreciated, thank you. Regards, Mike error message Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/usr/sfw/lib:/usr/lib /usr/local/bin/perl myld gcc -G -L/usr/local/lib -L/opt/gnu/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so\ -R/usr/sfw/lib -R/usr/sfw/lib/mysql -L/usr/sfw/lib -L/usr/sfw/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm \ gcc: dbdimp.o: No such file or directory gcc: mysql.o: No such file or directory *** Error code 1 make: Fatal error: Command failed for target `blib/arch/auto/DBD/mysql/mysql.so' /usr/ccs/bin/make -- NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible SOMETHING WAS MISSING! /error message Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ 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] CreateChildTicket
Has anyone implemented this successfully? -- Keep up with my goings on at http://theillien.blogspot.com ___ 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] history of tickets?
Hi Kevin, Thanks for doing the legwork on this! Does overriding these files work the same as creating a local copy of a .pm file (ShowRequestor_Local) or is there some other way to do it without modifying the original file? It seems to me that I tried this some time ago with another file and it didn't work. Thanks, Gene At 08:54 AM 3/5/2008, Kevin Falcone wrote: On Mar 5, 2008, at 11:30 AM, Greg Evans wrote: Any ideas on how to make this behave the way that I would like it to? Even pointing me to a path/to/filename maybe? You can change this by overriding html/Ticket/Elements/ShowRequestor The FromSQL call controls the Status -kevin ___ 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 -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ 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
