Re: [rt-users] change location of attachments in RT 3.4.5?
On Thu, Oct 29, 2009 at 11:20 PM, Jesse Vincent wrote: > > RT 1.0.x was the last version of RT to store attachments on the > filesystem. We're working on an RTx for a client that _might_ end up > getting released which would let you do this for RT 3.8. But it's not > something I can put a date on. > I think I know who the client is because I used to work for them. Well, at the very least we were paying BP to implement similar functionality. :-) Drew ___ 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 a copy at http://rtbook.bestpractical.com
Re: [rt-users] Arguments to callbacks?
On Tue, Jun 16, 2009 at 10:52 PM, ravi wrote: > On Jun 16, 2009, at 5:33 PM, Kevin Falcone wrote: > > On Jun 16, 2009, at 5:19 PM, ravi wrote: > > > >> any documentation on what is passed into a Callback? I am mostly > >> Googling the Callbacks I am interested in to figure out, using > >> examples others have provided, what the arguments may be, but that > >> only works so far. I also have the RT Essentials book, but that has > >> no > >> mention of Callbacks at all! > > > > Every Callback is different. > > > > Go find the callback you're using and see what RT passes in. > > $ grep -r callback /opt/rt3/share/html > > Everything but CallbackName will be passed on in %ARGS > > > > In case you are curious: I am trying to modify the display of a custom > field value. Unfortunately, there seems to be no Callback for each > specific value in Elements/ShowCustomFields, so I may do a local copy > of that whole script to make my changes, > Ravi, We just did exactly this sort of thing for a project I've been working on. I don't remember all the details now as I'm not at home at the moment. But IIRC it involved modifying Elements/ShowCustomField (note singular form) and then doing some checks for particular CF types. I got the idea off the wiki, so that would be a good place to start. Drew -- Drew Taylor * Web development & consulting Email: d...@drewtaylor.com * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ 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 a copy at http://rtbook.bestpractical.com
Re: [rt-users] Approvals in 3.8.2
On Fri, Feb 20, 2009 at 8:43 AM, L B wrote: > Hello, > > This extension looks very interesting. Do you have an idea of the > release date ? Even a devel version for testing ? I saw that it was released now: http://search.cpan.org/~clkao/RTx-WorkflowBuilder-1.02/ Drew -- ---- Drew Taylor * Web development & consulting Email: d...@drewtaylor.com * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ 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 a copy at http://rtbook.bestpractical.com
Re: [rt-users] WebService for RT?
On Thu, Feb 19, 2009 at 4:45 PM, Jesse Vincent wrote: > > > > On Thu 19.Feb'09 at 16:50:03 +0100, Stefan Hornburg wrote: >> There is a REST interface and a corresponding Perl module (though that >> might be a bit outdated with 3.8). > > I'm using RT::Client::REST against 3.8.2 just fine. Including access to Custom Fields? IIRC the current RT::Client::REST release doesn't handle the new 3.8 style naming convention yet. Patches are in RT though... Drew -- ---- Drew Taylor * Web development & consulting Email: d...@drewtaylor.com * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ 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 a copy at http://rtbook.bestpractical.com
[rt-users] Adding custom Group Rights
Hi all, I'm in need of adding some new Rights to custom Groups. I know it can be done because there are some existing rights in our app. :-) I've searched the wiki to no avail. To be specific, this is on the Configuration > Groups > $name > Group Rights screen. Can anyone point me in the right direction? We're running a heavily customized RT 3.2.1 (yes, I know it's old!) with perl 5.8, mysql (innodb), and mod_perl 1.29. Thanks, Drew -- ---- Drew Taylor * Web development & consulting Email: [EMAIL PROTECTED] * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ 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] ATOM API summary document?
Is there a document which details the ATOM API? I can look through the components, but that is tedious to say the least. I'm trying to improve a custom app which uses the ATOM API, but not knowing the full API there is no way to know if a better way exists. :-) For instance: once method gets all the custom fields for a ticket. It returns a hash of CF.Name => Value. But to get through this it does the following steps: 1) Get number of custom fields 2) Loop from 0..$count to get the value for each CF in the Ticket 3) Get Queue ID from Ticket 4) Loop through CF IDs in #2 to get CF Name 5) return hashref This seems like a lot of extra work if there happens to be a simpler way. If not, could this be a feature request? :-) Thanks, Drew -- ---- Drew Taylor * Web development & consulting Email: [EMAIL PROTECTED] * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT and mysql 5
If you can share, how many tickets are in your database and what hardware mysql is running on? Currently we're ~250k tickets (with lots of large attachments) and 4x Xeon @3GHz w/ 2GB RAM. The upgrade will add more RAM. Thanks, Drew On 9/11/06, Jon Speck Jr. <[EMAIL PROTECTED]> wrote: I am running RT 3.6.0 with MySQL 5.0.21 and Apache 2.2.2 with no issues to date. Jon Drew Taylor wrote: > Has anyone tried running RT with mysql 5.0.x? We're currently running > 4.0.x, with an upgrade to 4.1.x coming in the near future. I'm a bit > leery of 5.0.x because of the various reports I've heard (JOIN syntax > changed, major new version, etc). -- -------- Drew Taylor * Web development & consulting Email: [EMAIL PROTECTED] * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ 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] RT and mysql 5
Has anyone tried running RT with mysql 5.0.x? We're currently running 4.0.x, with an upgrade to 4.1.x coming in the near future. I'm a bit leery of 5.0.x because of the various reports I've heard (JOIN syntax changed, major new version, etc). Thanks, Drew -- -------- Drew Taylor * Web development & consulting Email: [EMAIL PROTECTED] * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ 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] Splitting queries across mysql servers
Hi, (Now subscribed from my personal address) We're looking to scale our RT instance at $work, and make it more fault tolerant at the same time. The obvious first step is to split the DB out from the Mason servers (currently all on one box). At the same time, we want to use mysql replication to get the data onto a second DB server. In a perfect world we would have RT transparently be able to do SELECTs on both DB boxes while sending UPDATE/INSERT statements to the master DB. I know I'm not the first person to attempt this. :-) Any pointers to DBI multiplexers, tips, etc would be most appreciated. Thanks, Drew -- ---- Drew Taylor * Web development & consulting Email: [EMAIL PROTECTED] * Site implementation & hosting Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
RE: [rt-users] RT - Data Warehouse?
We also use Business Objects here at $work. Could you please send the scripts to me as well? Or even better, put them on the wiki. :-) Thanks, Drew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Torsten BrummSent: Friday, September 01, 2006 12:03 PMTo: Stephen TurnerCc: rt-users@lists.bestpractical.comSubject: Re: [rt-users] RT - Data Warehouse? Hi Stephen,yes, we have. We put all the data from RT DB to Business Objects and do the reporting there. If you like, i can sent you the scrips for thatTorsten 2006/9/1, Stephen Turner < [EMAIL PROTECTED]>: Hello,Has anyone moved data from an RT system to a data warehouse for reporting purposes? If so, would you be willing to share yourexperiences? I'm interested in the design of the warehouse datastructures, particularly how to accommodate custom fields.Thanks,SteveStephen TurnerSenior Programmer/Analyst - Client Support ServicesMIT Information Services and Technology (IS&T)___http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-usersCommunity help: http://wiki.bestpractical.comCommercial support: [EMAIL PROTECTED]Discover RT's hidden secrets with RT Essentials from O'Reilly Media.Buy a copy at http://rtbook.bestpractical.com-- MFGTorsten Brummhttp://www.torsten-brumm.de ___ 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] 3.6.0 (spreadsheet) export changed...
> -Original Message- > From: Thomas Sibley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 25, 2006 10:49 AM > To: Drew Taylor > Cc: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] 3.6.0 (spreadsheet) export changed... > > Drew Taylor wrote: > > I've been doing this a lot lately - I've personally restored 5-6 > > pages/day over the last several days. One question for the > admins: how > > do I get a wiki account and then login? I'd like to have > the changes > > recorded as being done by me (yes, I like to be accountable for my > > actions) but I can't find an obvious way. > > http://wiki.bestpractical.com/index.cgi?action=user_preferences Dang it! Why does the answer always seem obvious after publically telling the world you can't find it on your own? :-) In my defense, the "login" box doesn't jump out at me... Drew ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] 3.6.0 (spreadsheet) export changed...
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Stephen Turner > > At Monday 7/24/2006 08:18 PM, Adrian Carter wrote: > >I went to check out this little hack but noticed the wiki is > defaced at > >http://wiki.bestpractical.com/index.cgi?SpreadsheetDisplayedFields. > > > > I don't have special wiki powers - what worked for me was, > for the article, going to Revisions -> Previous -> Edit and > then hitting Save. I've been doing this a lot lately - I've personally restored 5-6 pages/day over the last several days. One question for the admins: how do I get a wiki account and then login? I'd like to have the changes recorded as being done by me (yes, I like to be accountable for my actions) but I can't find an obvious way. Drew ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] LDAP working, now the next step
Our sysadmin just created a read-only AD account. No hacking required. :-) Drew From: Jay Vlavianos [mailto:[EMAIL PROTECTED] Sent: Thursday, July 20, 2006 3:05 PMTo: Drew Taylor; [EMAIL PROTECTED]; rt-users@lists.bestpractical.comSubject: RE: [rt-users] LDAP working, now the next step Yeah, its not the mappings at all. It is the permissions for the directory. Unlike slapd or 2000 AD, 2003 requires an account that had read permission on the directory server for binding. You can either hack 2003 AD to allow anonymous access, or create a user to do it. -Jay From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew TaylorSent: Thursday, July 20, 2006 12:01 PMTo: [EMAIL PROTECTED]; rt-users@lists.bestpractical.comSubject: RE: [rt-users] LDAP working, now the next step Eric, Thanks for the note. I have Active directory LDAP working here at $work, but I don't know if it's 2000 or 2003. Good to know that MS didn't make it more difficult if you upgrade. :-) Drew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 20, 2006 2:04 PMTo: rt-users@lists.bestpractical.comCc: Drew TaylorSubject: Re: [rt-users] LDAP working, now the next step Drew: I tested against 2000 and 2003 with ldapsearch before posting those settings to http://wiki.bestpractical.com/index.cgi?LdapAttrMap. The mapping is the same for both. --Eric N. ValorInformation Technology ManagerDaimlerChrysler Research & Technology North America, Inc.[EMAIL PROTECTED]1510 Page Mill Road, Palo Alto, CA 94304CIMS 931-00-00650-845-2536: This Space Intentionally Left Blank : Jay,Please update the Wiki with the Windows 2003 AD information if youhaven't already done so. I'm curious how your mapping differs from thaton http://wiki.bestpractical.com/index.cgi?LdapSiteConfigSettings.Drew ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] LDAP working, now the next step
Eric, Thanks for the note. I have Active directory LDAP working here at $work, but I don't know if it's 2000 or 2003. Good to know that MS didn't make it more difficult if you upgrade. :-) Drew From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 20, 2006 2:04 PMTo: rt-users@lists.bestpractical.comCc: Drew TaylorSubject: Re: [rt-users] LDAP working, now the next step Drew: I tested against 2000 and 2003 with ldapsearch before posting those settings to http://wiki.bestpractical.com/index.cgi?LdapAttrMap. The mapping is the same for both. --Eric N. ValorInformation Technology ManagerDaimlerChrysler Research & Technology North America, Inc.[EMAIL PROTECTED]1510 Page Mill Road, Palo Alto, CA 94304CIMS 931-00-00650-845-2536: This Space Intentionally Left Blank : Jay,Please update the Wiki with the Windows 2003 AD information if youhaven't already done so. I'm curious how your mapping differs from thaton http://wiki.bestpractical.com/index.cgi?LdapSiteConfigSettings.Drew ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] LDAP working, now the next step
Jay, Please update the Wiki with the Windows 2003 AD information if you haven't already done so. I'm curious how your mapping differs from that on http://wiki.bestpractical.com/index.cgi?LdapSiteConfigSettings. Drew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Vlavianos Sent: Wednesday, July 19, 2006 8:53 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] LDAP working, now the next step Hurrah! I got LDAP working with Active Directory using the Mosemann implementation found on the wiki. It took some tweaking and some trial and error, but I finally got it working with a Windows 2003 AD server (which is different than 2000). If anyone is having problems getting that far, I think I can be a resource for you. NOW I have a problem. I want people to be able to create tickets without having an account, but then be able to log into the system and have those tickets associated with their account (by email). I am currently using the "Auto Create on email, then set password via Auto Respond" method, which I will need to turn off. Ideally I can have a replacement for that process that uses LDAP. Does anyone have any ideas about how I might accomplish the above? Thanks! -Jay ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] Documentation bug: %Tickets in Templates
On the Wiki page ManualApprovals, when talking about the %Tickets hash it neglects to mention that the template id (===Create-Ticket: myid) will actually be "create-myid" for Created tickets, "update-myid" for Update-Ticket, etc as opposed to just "myid". This is in RT 3.6.0. Is this a new behavior or has no-one actually used this functionality? Neither the RT book nor any wiki pages mention this little catch. :-) Once I changed my Template to use $Tickets{'create-application'} everything worked fine. In our case, we have a deep hierarchy of approvals. Master ticket is created, which creates subtickets based on Custom Fields. Then those subtickets need to be approved. This workflow is from the Workflow wiki page, and it looks like it will serve us well. I wish though that I could avoid creating a whole series of "On XXX" conditions though... We have 15 conditions I have to check ATM. For the record, this is the working template: ===Create-Ticket: application Subject: Setup Bugzilla account Parents: TOP Queue: User Change Owner: dtaylor Content: A user needs an application account setup. Please see the parent ticket for details. ENDOFCONTENT ===Create-Ticket: approval Subject:Approval needed for Bugzilla account Type: approval Depended-On-By: { $Tickets{'create-application'}->Id } Queue: ___Approvals Owner: dtaylor Content: A bugzilla ticket has been submitted. You should review and approve it, so they can finish their work. See the Master ({ $RT::WebURL }Ticket/Display?id={ $Tickets{'TOP'}->Id }) and Application ({ $RT::WebURL }Ticket/Display?id={ $Tickets{'create-application'}->Id }) tickets for more information. Thank you. ENDOFCONTENT Thanks, Drew ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
RE: [rt-users] Searching by CurrentUser with QueryBuilder
Thanks! That did the trick. Drew -Original Message- From: Todd Chapman [mailto:[EMAIL PROTECTED] Sent: Monday, July 10, 2006 11:19 PM To: Drew Taylor Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Searching by CurrentUser with QueryBuilder On Mon, Jul 10, 2006 at 05:44:59PM -0400, Drew Taylor wrote: > Hi all, > I have a fresh 3.6.0 installation we're customizing. We'd like to > create a saved search that searches for "Owner = '$RT::CurrentUser'" > (as opposed to a static username like "Owner = 'drew'"), but this > particular syntax doesn't work. Is this possible? If not, where would > I start to add this feature - we'd REALLY like to have it. :-) > Try: Owner = '__CurrentUser__' ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] Searching by CurrentUser with QueryBuilder
Hi all, I have a fresh 3.6.0 installation we're customizing. We'd like to create a saved search that searches for "Owner = '$RT::CurrentUser'" (as opposed to a static username like "Owner = 'drew'"), but this particular syntax doesn't work. Is this possible? If not, where would I start to add this feature - we'd REALLY like to have it. :-) Drew ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
[rt-users] LDAP authentication question
I'm working on a fresh 3.6 install and would like to try the LDAP authentication option. However, our corporate structure requires us to have 2 distinct Active Directory trees. Is there any way to setup authentication so it will try multiple servers? From my quick glance at the code, it seems it is not trivial. Thanks, Drew ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html