[rt-users] Audit log
Hi sis any one know hot to take a audit report with login information (successfully and unsuccessfully), user rights and changes to user rights etc Thanks and Best Regards -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
Re: [rt-users] Changing email address of admin and users
On Fri, Jun 07, 2013 at 02:40:11PM -0400, john boris wrote: I understand that but I looked and I don't have 42 scrips. How do I know which scrip that is? Just asking. I wil go through one by one and see which one lost the semicolon. What do you see when you run Select * from Scrips where id = 42; Also - you didn't lose a semicolon, you spelled return as Return. -kevin pgpPpJ833KcIf.pgp Description: PGP signature -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
Re: [rt-users] Errors after upgrade from 3.6.5 to 4.0.13
On Mon, Jun 10, 2013 at 05:38:06PM +0200, Jonny Schulz wrote: [Mon Jun 10 14:34:33 2013] [error]: The 'message' parameter (Unknown field 'QueueObj' in ' Owner = 'Nobody' AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) AND QueueObj.HideOnPage = '0' ' at /opt/rt4/sbin/../lib/RT/Tickets_SQL.pm line 197. Stack: [/opt/rt4/sbin/../lib/RT/Tickets_SQL.pm:197] [/opt/rt4/sbin/../lib/RT/SQL.pm:177] [/opt/rt4/sbin/../lib/RT/Tickets_SQL.pm:237] [/opt/rt4/sbin/../lib/RT/Tickets_SQL.pm:293] [/opt/rt4/share/html/Elements/CollectionList:51] [/opt/rt4/share/html/Elements/ShowSearch:54] [/opt/rt4/share/html/Widgets/TitleBox:56] [/opt/rt4/share/html/Elements/ShowSearch:55] [/opt/rt4/share/html/Elements/MyRT:97] [/opt/rt4/share/html/index.html:78] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:635] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:335] [/opt/rt4/share/html/autohandler:53] It's possible to serve all other sites, only the Homepage returns this error. Did you have a bunch of 3.6 customizations and did you port them? HideOnPage isn't a core Queue field and QueueObj isn't valid TicketSQL. If HideOnPage was a standard field, then Queue.HideOnPage = 0 would work. I'd start by comparing your Queues database table to the standard schema and looking for missed customizations. https://github.com/bestpractical/rt/blob/stable/etc/schema.mysql#L21 -kevin pgpnlP7EaOiFp.pgp Description: PGP signature -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
Re: [rt-users] RES: Is it possible to specify a different user with RT CLI ?
Le 07/06/2013 18:36, Kevin Falcone a écrit : While the REST interface (which is what the command line client uses) does not allow you to impersonate a user without knowing passwords or cookies, you can use RT's core perl API to load any user and record actions as that user. Thanks for your answer Kevin. In fact, I tried with cookies and it doesn't work either (setting the transaction creator with a Creator: field). So I will have to do it the hard way (hopefully I code in perl but I didn't want to install the whole request-tracker just for the libs on this machine which is only a frontend). -- Jean-Christophe Boggio -o) rt-us...@thefreecat.org /\\ Independant Consultant and Developer_\_V -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
Re: [rt-users] Errors after upgrade from 3.6.5 to 4.0.13
Hi Kevin, yes, you are right. There are tons of customizations. The rt version was installed from the company Netways with lots of modification. :( Thank you for your help. Jonny Am 06/10/2013 05:47 PM, schrieb Kevin Falcone: On Mon, Jun 10, 2013 at 05:38:06PM +0200, Jonny Schulz wrote: [Mon Jun 10 14:34:33 2013] [error]: The 'message' parameter (Unknown field 'QueueObj' in ' Owner = 'Nobody' AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) AND QueueObj.HideOnPage = '0' ' at /opt/rt4/sbin/../lib/RT/Tickets_SQL.pm line 197. Stack: [/opt/rt4/sbin/../lib/RT/Tickets_SQL.pm:197] [/opt/rt4/sbin/../lib/RT/SQL.pm:177] [/opt/rt4/sbin/../lib/RT/Tickets_SQL.pm:237] [/opt/rt4/sbin/../lib/RT/Tickets_SQL.pm:293] [/opt/rt4/share/html/Elements/CollectionList:51] [/opt/rt4/share/html/Elements/ShowSearch:54] [/opt/rt4/share/html/Widgets/TitleBox:56] [/opt/rt4/share/html/Elements/ShowSearch:55] [/opt/rt4/share/html/Elements/MyRT:97] [/opt/rt4/share/html/index.html:78] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:635] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:335] [/opt/rt4/share/html/autohandler:53] It's possible to serve all other sites, only the Homepage returns this error. Did you have a bunch of 3.6 customizations and did you port them? HideOnPage isn't a core Queue field and QueueObj isn't valid TicketSQL. If HideOnPage was a standard field, then Queue.HideOnPage = 0 would work. I'd start by comparing your Queues database table to the standard schema and looking for missed customizations. https://github.com/bestpractical/rt/blob/stable/etc/schema.mysql#L21 -kevin Mit freundlichen Grüßen -- Jonny Schulz Operations Specialist OnVista Media GmbH Sophienstr. 3 D-51149 Köln T +49 2203 9146-129 F +49 2203 180640 E jonny.sch...@onvista.de www.onvista-group.de Handelsregister beim Amtsgericht Köln HRB 37240 Geschäftsführer: Lars Merle -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
Re: [rt-users] For RTIR are scrips ran before plugins? (namely lib/RT/Action/RTIR_FindIP.pm)
On 6 June 2013 15:36, Landon landonstew...@gmail.com wrote: On 6 June 2013 13:23, Ruslan Zakirov r...@bestpractical.com wrote: yes, use SQL to check: select Description from Scrips order by Description; [RTIR] prefix is also accounted, so you have to know where DB places it while sorting. Thank you that makes sense. I still have a bit of an issue with the order of things. If I use On Create as the condition the scrip fires earlier than the order by Description and there are no IP addresses in the custom field at that point. If I use a User Defined condition the IP address custom field is already populated by that time. The problem with using a User Defined condition is that it has the potential to fire more than once if I base it on something to do with the ticket that might happen more than once in the ticket's life. I only want to do this process once on the original content of the ticket so On Create makes the most sense. Any idea how I can get a condition that that will only fire once per ticket on creation or otherwise but going by the order of scrips that indicated by the SQL query? If anyone has any information on this I would appreciate it. Basically I'm looking for a condition that *only* fires once per ticket creation but late enough in the ticket creation process that all the custom fields have already been updated by RTIR built-in scrips (ie. ticket already commited to database?). -- Landon Stewart landonstew...@gmail.com -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
[rt-users] Auto creating user email addresses from CAS authenticated RT SelfService
Hello, I am currently migrating from RT 3.4.5-2 (2006) on Fedora Core 4 to RT 4.0.8 on Centos 6.2. The reasons are many, including aging platform, move to virtualization etc. The new RT, like the old one, does external authentication through CAS (Central Authentication Service). Basically users always initiate a support request through the RT SelfServe website by authenticating with single sign-on credentails (username, password). The system generates a new user the first time the user logs in populates the Identity Username and Unix login Username from their login credentials. On the old system, loggin in for the first time also autogenerates an email by concatenating the Identity with the email domain suffix (@mydomain.com). So for example, person with ID newuser, logs in for the first time, and their Email field is populated with newu...@mydomain.com, and nothing needs to be done from my end. For some reason, it does not do this on the new system. I seem to recall some 7 years ago adding a hack to set this autocreation of the email field using the username. I have searched but can't find anything and searched through the code to see where/how it was implemented, but I am at a loss. Does anyone know how this is done in RT 4.x? Other than putting it in manually, I haven't been able to figure out how to do this. Thanks in advance. -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
Re: [rt-users] Auto creating user email addresses from CAS authenticated RT SelfService
OK ... I solved the problem. After some looking around and re-examining my old code, I found for RT 4.0.8, go to /lib in your rt directory (eg /var/rt or /usr/local/rt) so for me I edited in /usr/local/rt/lib/RT/Interface/Web.pm find ### Start Code Fragment sub WebExternalAutoInfo { my $user = shift; my %user_info; # default to making Privileged users, even if they specify # some other default Attributes if ( !$RT::AutoCreate || ( ref($RT::AutoCreate) not exists $RT::AutoCreate-{Privileged} ) ) { $user_info{'Privileged'} = 1; } ## End Code Fragment and add the line $user_info{'EmailAddress'} = $user\@mycompany.com; ### Start Code Fragment sub WebExternalAutoInfo { my $user = shift; my %user_info; $user_info{'EmailAddress'} = $user\@mycompany.com; # default to making Privileged users, even if they specify # some other default Attributes if ( !$RT::AutoCreate || ( ref($RT::AutoCreate) not exists $RT::AutoCreate-{Privileged} ) ) { $user_info{'Privileged'} = 1; } ## End Code Fragment You may (?) also have to add $user_info{'Privileged'} = 0; along with $user_info{'EmailAddress'} = $user\@mycompany.com; if you want your newly-created user to be Unpriviliged, which is standard for RT SelfServe. I'm not sure what happens when you ask to autocreate priviliged (internal) users ... I believe in the case of RT_SiteConfig.pm to enable external authentication (like CAS or LDAP): Set($WebExternalAuth , '1'); Set($WebFallbackToInternalAuth , '1'); Set($WebExternalGecos , undef); Set($WebExternalAuto , '1'); And now for each new user, the field 'EmailAddress'is populated with $u...@mycompany.com Have fun with it, people! Duncan. - Original Message - Hello, I am currently migrating from RT 3.4.5-2 (2006) on Fedora Core 4 to RT 4.0.8 on Centos 6.2. The reasons are many, including aging platform, move to virtualization etc. The new RT, like the old one, does external authentication through CAS (Central Authentication Service). Basically users always initiate a support request through the RT SelfServe website by authenticating with single sign-on credentails (username, password). The system generates a new user the first time the user logs in populates the Identity Username and Unix login Username from their login credentials. On the old system, loggin in for the first time also autogenerates an email by concatenating the Identity with the email domain suffix (@mydomain.com). So for example, person with ID newuser, logs in for the first time, and their Email field is populated with newu...@mydomain.com, and nothing needs to be done from my end. For some reason, it does not do this on the new system. I seem to recall some 7 years ago adding a hack to set this autocreation of the email field using the username. I have searched but can't find anything and searched through the code to see where/how it was implemented, but I am at a loss. Does anyone know how this is done in RT 4.x? Other than putting it in manually, I haven't been able to figure out how to do this. Thanks in advance. -- Regards, Duncan. --- Duncan Napier duncan_nap...@sfu.ca http://www.sfu.ca/~dgnapier/ IT Instrumentation Consultant Dept of Molecular Biology and Biochemistry Simon Fraser University It takes ten years to become good at being a kid. Then another ten years to become good at not being a kid - Larry Wall. -- RT Training in Seattle, June 19-20: http://bestpractical.com/training