Re: [rt-users] RT Query Logging

2009-07-03 Thread Varun
Hi Joop Thanks for your reply. I will let you know all this by concerning with my DBA. Thanks & Regards Varun Vyas -Original Message- From: Joop van de Wege [mailto:joopvandew...@mococo.nl] Sent: Saturday, July 04, 2009 11:55 AM To: Varun Vyas; rt-users@lists.bestpractical.com Subject:

Re: [rt-users] RT Query Logging

2009-07-03 Thread Joop van de Wege
Varun Vyas wrote: > Hello All > > Can anyone can tell me how i can log my queries that hits my database in > RT.log. I am using oracle 9i and RT 3.6.3 we have a performance issue as I saw that it is now working for you, query logging that is. > our RT is very slow and takes 15-20 seconds for da

Re: [rt-users] Query Logging

2009-07-03 Thread Varun
Hi Ruslan Thanks a lot for the giving me exact usage. And I will definitely made changes as suggested by you and will let you know Thanks & Regards -Original Message- From: Ruslan Zakirov [mailto:ruslan.zaki...@gmail.com] Sent: Friday, July 03, 2009 7:38 PM To: Varun Cc: rt-users@lists

Re: [rt-users] Reqest Tracker CentOS 5.3 setup

2009-07-03 Thread ty chan
Hi Bill, rt.abc.com/rt is working for me. note: eveytime i change something on the apache, i did restart the service. regards, chanty From: William Graboyes To: ty chan Cc: jmose...@corp.xanadoo.com; rt-users@lists.bestpractical.com; rt-users-boun...@lists.

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Natxo Asenjo
On Fri, Jul 3, 2009 at 10:43 PM, Gary Greene wrote: > On 7/3/09 1:15 PM, "Natxo Asenjo" wrote: [knip] >>> Your filter is incomplete. Are you using AD or OpenLDAP? >> >> openldap. So any tips about how the filter should look like? >> > You'll likely want to do something like this: > > (&(objectC

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Gary Greene
On 7/3/09 1:15 PM, "Natxo Asenjo" wrote: > On Fri, Jul 3, 2009 at 9:51 PM, Gary Greene > wrote: >> On 7/3/09 11:30 AM, "Natxo Asenjo" wrote: > >>> The settings in RT_SiteConfig.pm are: >>> >>> Set($LDAPHost,'host.domain.tld'); >>> Set($LDAPUser, 'cn=user,dc=domain,dc=tld'); >>> Set($LDAPPasswo

[rt-users] Error: Loaded object has different id at /opt/rt3/bin/../lib/RT/Shredder.pm line 362, line 323.

2009-07-03 Thread Kevin Gagel
My custom fields are not showing up in my dashboard. I suspect that changing the organization name has something to do with it. I just tried to see if shredder could locate one of my missing custom fields and got this error: Loaded object has different id at /opt/rt3/bin/../lib/RT/Shredder.pm lin

Re: [rt-users] Custom Search

2009-07-03 Thread William Graboyes
Hello Bahsir, (Owner = 'userB' OR Owner = 'userA') AND (Status = 'Resolved) Pop that into your advanced tab, hit apply, and you are good to go. Thanks, Bill G. On Fri, Jul 3, 2009 at 3:42 AM, Bashir Jahed wrote: > Hi Everone, > > > > I want to do a search based on the following: > > Tickets

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Natxo Asenjo
On Fri, Jul 3, 2009 at 9:51 PM, Gary Greene wrote: > On 7/3/09 11:30 AM, "Natxo Asenjo" wrote: >> The settings in RT_SiteConfig.pm are: >> >> Set($LDAPHost,'host.domain.tld'); >> Set($LDAPUser, 'cn=user,dc=domain,dc=tld'); >> Set($LDAPPassword, 'password'); >> Set($LDAPBase, 'ou=users,dc=domain,d

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Gary Greene
On 7/3/09 1:06 PM, "Kevin Gagel" wrote: > --- Original message --- >> >I've successfully used RT::Extension::LDAPImport to bring users in, and then >> >use RT::Authen::ExternalAuth for passwords. > > Is that the only way? > > Kevin W. Gagel > Network Administrator > Local 5448 > My blog: > http

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Kevin Gagel
--- Original message --- >I've successfully used RT::Extension::LDAPImport to bring users in, and then >use RT::Authen::ExternalAuth for passwords. Is that the only way? Kevin W. Gagel Network Administrator Local 5448 My blog: http://mail.cnc.bc.ca/blogs/gagel My shared files: http://mail.cnc.bc

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Gary Greene
On 7/3/09 11:30 AM, "Natxo Asenjo" wrote: > hi, > > I found this: > > http://www.cpan.org/modules/by-module/RT/RT-Extension-LDAPImport-0.06.tar.gz > > and installed it according to the instructions in the README. My RT > installation is also vanilla 3.8.3, so everything is in /opt/rt3 > > The

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Gary Greene
On 7/3/09 5:52 AM, "Natxo Asenjo" wrote: > hi, > > yesterday I got RT::Authen::ExternalAuth working (v.0.0.8 I think, the > latest) with rt 3.8.4 and an openldap server. All according to the > README and wiki instructions, thanks for the great extension. > > I was wondering if there is a way to

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Natxo Asenjo
hi, I found this: http://www.cpan.org/modules/by-module/RT/RT-Extension-LDAPImport-0.06.tar.gz and installed it according to the instructions in the README. My RT installation is also vanilla 3.8.3, so everything is in /opt/rt3 The settings in RT_SiteConfig.pm are: Set($LDAPHost,'host.domain.t

[rt-users] RTFM rights Question

2009-07-03 Thread Hossein Rafighi
Hi All, I have rt-3.8.4 and rtfm-2.4.2 installed on a linux system. When an unprivileged users does a search for an article s/he sees them, but when these articles are clicked on, they don't see the link for the content of any article. My privileged users don't have this problem! They can sear

Re: [rt-users] RT can't create user from a reply email - We're using LDAP...

2009-07-03 Thread Kevin Gagel
Resending as no response yet... --- Original message --- Subject: RT can't create user from a reply email - We're using LDAP... From: Kevin Gagel To: Date: 25/06/2009 2:45 PM How do I get RT configured to allow a reply message to auto create the user? Currently I have the ldap configuration

Re: [rt-users] reply address from RT

2009-07-03 Thread Bill Cole
testwreq wreq wrote, On 6/26/09 11:23 AM: > I have the new install of RT. When a new ticket is created, we get a > response from RT which has a reply-to field set as 'fds...@ ; can > anyone tell where this setting is comming from? > In the RT_SiteConfig file we have set the correspondAddress as

Re: [rt-users] Upgrade only the DB schema

2009-07-03 Thread Bill Cole
dmatton wrote, On 6/26/09 9:36 AM: > Hello everybody, > > I've got RT 3.6.6 in production and I would like to upgrade only the DB > schema to 3.8.4. Is it possible ? No. Of course it is *possible* in the most narrowly pedantic sense. You can make the schema changes without installing the new RT

Re: [rt-users] CustomField questions

2009-07-03 Thread Ruslan Zakirov
On Thu, Jul 2, 2009 at 9:19 PM, Duncan Hutty wrote: > RT-3.8.4: > 1) Can I specify a custom field that is merely a checkbox? RT-Extension-CustomField-Checkbox, on the cpan will be soon. Or fetch it from github. > > 2) Can I provide a default value for such a custom field? Or would I > need to wri

Re: [rt-users] rt 3.8.2 / mail loop by out-of-office reply

2009-07-03 Thread Odhiambo ワシントン
On Fri, Jul 3, 2009 at 5:45 PM, Ruslan Zakirov wrote: > Shot the user with a shotgun :) > > I think "out of office" reply creates a new ticket each time cuz > subject has no ticket number. May be it's possible lower number of > loops with some set of conditions on "Autoreply to requestors on > cre

[rt-users] merge ticket on Resolve

2009-07-03 Thread rmp dmd
Hi, Thanks for the numerous response and I was able to have a scrip that merges RECOVERY alerts from nagios with PROBLEM tickets. I need help again for minor modifications.I prefer to merge PROBLEM open tickets to the RECOVERY alert ID. Here's how the scrip goes: An alert, ** PROBLEM alert - TES

Re: [rt-users] Locking up Custom Fields

2009-07-03 Thread Ruslan Zakirov
I don't know about JS or any other previous work on this. However, we thought about adding ModifyCustomFieldOnCreate right. If you write a patch, we can include it into the core. On Fri, Jul 3, 2009 at 6:32 PM, Mario Gomide wrote: > Hello list!!! > > I have an RT 3.6.1 installation, and RT works f

[rt-users] Locking up Custom Fields

2009-07-03 Thread Mario Gomide
Hello list!!! I have an RT 3.6.1 installation, and RT works fine for me. I was hopping someone could help me out on this one: I have a couple of Custom Fields that must be filled up on the ticket creation BUT after that, they MUST NOT be changed! In other words, these specific CF must become re

Re: [rt-users] rt 3.8.2 / mail loop by out-of-office reply

2009-07-03 Thread Ruslan Zakirov
Shot the user with a shotgun :) I think "out of office" reply creates a new ticket each time cuz subject has no ticket number. May be it's possible lower number of loops with some set of conditions on "Autoreply to requestors on create" scrip, for exampl: * matches I'm out of the office * "small"

Re: [rt-users] User/Group rights to see group members and user details

2009-07-03 Thread Ruslan Zakirov
Your question is foggy, cuz there is no user's group as user can be user member of many groups. It's not clear if people in support group should see something special or requestors should see something. It's not clear about which page you're talking. On Fri, Jul 3, 2009 at 4:49 PM, Boris Jordanov

Re: [rt-users] Query Logging

2009-07-03 Thread Ruslan Zakirov
Correct usage is Set($StatementLog,"debug"); or Set($StatementLog,"error"); You have to restart server. On Fri, Jul 3, 2009 at 4:20 PM, Varun wrote: > Hello All > > I have already post one question about how I can trace my query or put show > my queries in log generated by RT. Though I have made

Re: [rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Mike Peachey
Fri 03 Jul 2009 13:52:27 GMT Natxo Asenjo wrote: > hi, > > yesterday I got RT::Authen::ExternalAuth working (v.0.0.8 I think, the > latest) with rt 3.8.4 and an openldap server. All according to the > README and wiki instructions, thanks for the great extension. > > I was wondering if there is a

[rt-users] 500 Error

2009-07-03 Thread Varun
Hi Steven You internal server error is may be due to the Fastcgi script idle timeout . Because when your queries takes longer than the idle timeout. Fastcgi script gives up and reports and internal server error and logs in apache logs as incomplete header received from server as it has not got

Re: [rt-users] Reqest Tracker CentOS 5.3 setup

2009-07-03 Thread jmoseley
Perhaps you didn't reload apache? With the script alias you have below, http://172.16.0.1/rt should not be working. Look at the apache error logs - that will give some clues as to what's going on. James Moseley ty chan wrote: Hi Moseley, Here is my configuration on httpd.conf. Serve

[rt-users] import ldap users in RT with RT::Authen::ExternalAuth

2009-07-03 Thread Natxo Asenjo
hi, yesterday I got RT::Authen::ExternalAuth working (v.0.0.8 I think, the latest) with rt 3.8.4 and an openldap server. All according to the README and wiki instructions, thanks for the great extension. I was wondering if there is a way to import the users from the ldap server into the rt databa

Re: [rt-users] User/Group rights to see group members and user details

2009-07-03 Thread Boris Jordanov
Nothing? No one? :) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy

[rt-users] Query Logging

2009-07-03 Thread Varun
Hello All I have already post one question about how I can trace my query or put show my queries in log generated by RT. Though I have made some changes which as suggested by Raed. But still I am not been able to log my query in rt.log . Can any one suggest me what I have been missing. I have alre

[rt-users] rt 3.8.2 / mail loop by out-of-office reply

2009-07-03 Thread Bernhard Hansbauer
hi, it's not for the first time we encounter a mail loop caused by an erroneous configuration of a user, and we receive hundreds of auto replies. rt does not recognize them as mail loop, thus we can only break it by blocking the sender's mail address. is there any other way to interrupt such

[rt-users] Custom Search

2009-07-03 Thread Bashir Jahed
Hi Everone, I want to do a search based on the following: Tickets resolved by userA and userB and userC where tickets status is resolved and ticket was created after 2009-06-01 I am able to search for one user at a time, if I do userA and UserB it searches tickets that are owned by userA a

Re: [rt-users] RT-Authen-ExternalAuth-0.08 , privileged user if in group otherwise unprivileged

2009-07-03 Thread Mike Peachey
Thu 02 Jul 2009 21:54:03 GMT Michael Ellis wrote: > Hi, > > RT newbie here. > > I've got RT-Authen-ExternalAuth-0.08 set up and working against our > eDirectory. What I'd like to do now, is have users created in RT as > privileged if they are members of a specific group in the directory, and >

[rt-users] Inter-RT dependencies

2009-07-03 Thread Tom Lanyon
Hi list, RT::URI *appears* to have all the bits to do external links - is anyone here doing any linking (eg. dependencies) between different RT instances or know if it works at all? Regards, Tom ___ http://lists.bestpractical.com/cgi-bin/mailman/l

Re: [rt-users] Reqest Tracker CentOS 5.3 setup

2009-07-03 Thread William Graboyes
Hi Chanty, I shouldn't be doing this at the time of night it is currently... Disregard my ScriptAlias comment... and I have another question... Have you tried hitting rt.abc.com/rt ? Since it seems to work when you hit the server by IP. On Thu, Jul 2, 2009 at 11:51 PM, William Graboyes < willi