Re: [rt-users] Question about RT CLI custom field / web-interface
On Wed, 2006-08-23 at 19:11 -0500, Carl Davis wrote: On Tue, 22 Aug 2006 09:54:41 -0700 Joshua Colson [EMAIL PROTECTED] wrote: On Tue, 2006-08-22 at 07:08 -0500, [EMAIL PROTECTED] wrote: Can you elaborate on this. I can't seem to figure out how to display my custom fields via the cli. I am using rt 0.02 which came with rt-3.6.1 Carl Assuming you have a custom field called 'Training' associated with ticket number 45367, you could do the following: [EMAIL PROTECTED]: rt show -f CF-Training,Subject,Priority ticket/45367 id: ticket/45367 CF-Training: Yes Subject: Whatever the subject is currently set to Priority: 10 I'm not certain why that isn't working. The equivalent query on my system works. Have you modified the code base at all? ___ 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] Question about RT CLI custom field / web-interface
On Wed, 2006-08-23 at 19:11 -0500, Carl Davis wrote: Thanks for the info. What if I have a custom filed that has a white space in it? I'm not certain what you would have to do, but one thing I'm pretty sure of is that you'll need to modify the CustomField modules to accept white space in the name (and then escape/quote the white space in your shell). HTH -- Joshua Colson [EMAIL PROTECTED] ___ 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] Question about RT CLI custom field / web-interface
On Tue, 2006-08-22 at 07:08 -0500, [EMAIL PROTECTED] wrote: Can you elaborate on this. I can't seem to figure out how to display my custom fields via the cli. I am using rt 0.02 which came with rt-3.6.1 Carl Assuming you have a custom field called 'Training' associated with ticket number 45367, you could do the following: [EMAIL PROTECTED]: rt show -f CF-Training,Subject,Priority ticket/45367 id: ticket/45367 CF-Training: Yes Subject: Whatever the subject is currently set to Priority: 10 The confusing thing about the rt CLI tool in regard to custom fields is that searching requires a syntax like 'CF.{Training}' and showing uses the 'CF-Training' form. HTH -- Joshua Colson [EMAIL PROTECTED] ___ 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] owners
On Thu, 2006-08-03 at 21:29 +0100, Robert Pawlowicz wrote: When I create a new ticket, the owner drop down list only displays 'nobody'. Therefore when a ticket is create, I am always force to 'Take' the ticket later. However, this is a pain when it comes to updating the people section as because there is no other people in the owner drop down, the system changes the owner back to nobody. Do you have the OwnTicket right or are you just a SuperUser? -- Joshua Colson [EMAIL PROTECTED] ___ 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] One Apache, two RT databases, on a single host
On Wed, 2006-08-02 at 09:39 -0700, Mike Friedman wrote: Would this work and accomplish what I want? Or am I overlooking something? Yes. What you are trying to do is possible. See: http://wiki.bestpractical.com/index.cgi?MultipleInstances I have the same setup on a test machine so if you have problems I can probably help you. -- Joshua Colson [EMAIL PROTECTED] ___ 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 Approvals
On Wed, 2006-08-02 at 16:06 -0400, Tim Casada wrote: I also enabled and renamed the ___Approvals queue to Approvals. What I believe to now be my problem is actually with permissions. To whom do I have to give what permissions to actually create the tickets in the Approval queue and view them? RT expects the approvals Queue to be named with the leading underscores. You should have the Queue set to '___Approvals' in the template and the approvals queue should be renamed back to what it originally was. I'm not certain what else you'll need to do as I haven't taken advantage of the feature yet but I'm pretty certain you'll need to revert your changes. HTH -- Joshua Colson [EMAIL PROTECTED] ___ 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] Does DBIx::SearchBuilder support nested objects?
I apologize if this is the wrong list for SearchBuilder questions. If so and you know where this should go to, please point me in the right direction. Suppose I have a DB schema like the following: ### Table: [car] [id] [year] [make][model] [trim] [wheel_type] [1] [2006] [Zastava] [Yugo] [55] [1] Table: [wheels] [id] [year] [make] [size] [1] [2006] [cheap] [14] ### Where [wheel_type] in the [car] table is just a foreign key to the [id] column of the [wheels] table. Does SB automatically generate the nested wheel_type object as a property of the car object, or does that generation happen manually? Thanks. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Custom Field Select Multiple bug?
On Tue, 2006-08-01 at 22:54 -0400, Mathew Snyder wrote: Running v3.6. We have a custom field with close to 100 items in it. They are all listed alphabetically so whenever a new item needs to be added, it gets added in the middle. This requires a complete reordering of the sort field for the entire list. For instance suppose we have item 1 and 2 already in the list. We add item 3 between 1 and 2 and make it 2. When we save the changes we now have two items labeled 2 and have to manually reorder them all the way down to the bottom. Tedious at best, obnoxious at worst. The sort order numbers do not have to be sequential. Try setting the sort order to a different stepping, such as 5, 10, 15, 20, etc. Then you can easily insert new records in between. HTH -- Joshua Colson [EMAIL PROTECTED] VoidGate InterNetworks ___ 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] Command line link tree
Does anyone know if there is a way to build a hierarchy of tickets via the CLI based on links. Similar to what you see in the [Links] section of the ticket display with the exception of displaying multiple parent tickets at once. I know that I can do something like: rt ls -i Queue='General' AND CF.{Type} = 'Parent'} | \ sed '[EMAIL PROTECTED]@/links@;' | rt show - which provides me with close to what I want but I would like some of the main ticket fields (such as Subject, Owner, etc) included in the output. Thanks. -- Joshua Colson [EMAIL PROTECTED] ___ 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] What's the *Maximum* password length in RT?
On Mon, 2006-06-26 at 12:09 -0700, Philip Kime wrote: Strange question I know but the SOX people are asking - they've asked for the minimum length (which is configurable). Now they want to know the maximum (!). Anybody have an idea? By default it is 40 characters. -- Joshua Colson [EMAIL PROTECTED] ___ 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] RT 3.6.0 Custom Field Validation
On Thu, 2006-06-22 at 15:41 -0400, Todd Chapman wrote: I agree. Lots of extensions could be made for different types of validation. Looking at the RT code, I'm surprised there is no Callback for adding new ones. I'm sure Jesse would take a patch for that. You could just edit html/Admin/CustomFields/Modify.html and add them in to the Validation section. It isn't ideal, but it may help. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Custom Fields query vs. CLI edit syntax inconsistencies
On Thu, 2006-06-22 at 12:31 -0700, Philip Kime wrote: I'm not sure that's necessarily a bad thing - the REST syntax for CF editing is nice and simple for scripting - the curly brackets would make things more complicated to parse and generally use. When I was deciding on a format for displaying CFs for the AT REST code, I automatically chose CF_ (changed to CF- now to match RT 3.6.0) because it's easy to parse in the REST code and easy to edit in the CLI. All that shell escaping for curly brackets when you're scripting would make the REST interface less convenient to use ... What if the CLI supported both versions of the syntax? Would that make the REST code more difficult to maintain? I agree that the lack of curly brackets makes scripting cleaner but I spend a few hours hitting my head against the wall to discover that difference (in the beginning). Maybe this should be moved to the -devel list. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Sorting search results RSS feed?
RT 3.6 MySQL 4.1.13 Apache 2.0.54 ModPerl 2.0.1 Does the search results RSS feed support sorting (ORDER BY) of results? I'm able to sort the result on the web interface but the sorting doesn't transfer to the RSS feed. Am I just doing something wrong or is this missing functionality? Thanks. -- Joshua Colson [EMAIL PROTECTED] ___ 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] RT CLI comment problem
On Thu, 2006-06-15 at 07:38 -0400, Jason A. Diegmueller wrote: Mathew-- For the time being, modify lib/RT.pm. Change the following line: $VERSION = '3.6.0rc3'; to $VERSION = '3.6.0'; Bosses can't fault you for running pre-release software now! -jd Just in time for Jesse to steal your thunder. :) ___ 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.0rc3/mysql: reinserting image attachments into the DB?
On Thu, 2006-06-08 at 12:43 -0600, Ole Craig wrote: Interesting. Before I'd read your message, I tried the following: mysql update Attachments set Content=LOAD_FILE('/tmp/Outlook.jpg') where id=323; ...which seems to have achieved the desired results at least as far as that particular attachment is concerned. (I.e. it now displays correctly in the ticket.) I noticed (belatedly) that the type for Attachments.Content is longtext -- does mysql have an autoconversion feature for binary data that happens to DTRT? Or is RT robust enough to handle the fact that the DB object is not base64? I don't see any errors in the RT log pertaining to this... That surprises me. I'm certainly not a MySQL expert, but I find it incredibly surprising that loading binary data into a text field works on-the-fly. However, if MySQL does to on-the-fly conversion, it would make sense that it chooses base64. As far as I know, RT relies on the data in the DB being valid (that is, it does not attempt to auto-convert it). I'm glad you got it fixed, no matter what worked for you. -- Joshua Colson [EMAIL PROTECTED] ___ 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.0rc3/mysql: reinserting image attachments into the DB?
My question: I still have all the emails from which those image attachments were culled. Does anyone have a suggestion for how to reinsert the uncorrupted images into the database in place of the useless blobs currently residing there? (I'm no DBA at the best of times, and I've never needed to work with non-textual data in mysql before; I'm feeling a bit lost...) RT does not store attachments as BLOBs. All binary attachments are converted to base64 encoding before insertion into the database. What you want to do should be possible, but it will likely require a fair amount of work to accomplish. You say that you aren't a DBA, but if you can run some sql updates, you can fix your problem. First, you'll need to extract all the images from your emails, then you'll have to figure out which image goes with which ticket. This will be the hard part. The following SQL run from the mysql command line tool should help pull the relevant information together. select a.id as Attachments.id, a.Filename as Attachments.Filename, tr.id as Transactions.id, t.id as Tickets.id, t.Subject as Tickets.Subject FROM Attachments a, Transactions tr, Tickets t WHERE a.ContentType 'text/plain' and a.Filename is not NULL and a.TransactionId = tr.id and tr.ObjectType = 'RT::Ticket' and tr.ObjectId = t.id; With that information in hand, you should be able to cross reference the images you've extracted from the emails to the tickets/transactions/attachments records in the database. Then, you'll need to use some external utility such as perls MIME::Base64 module to convert the images to base64 format. Then simply update the record with the new data. I hope I explained that clearly enough to get you where you would like to be. Good luck, and make sure you back the system up before doing anything that I've suggested! I should also mention that I have not tested any of this, but it should all work, in theory. -- Joshua Colson [EMAIL PROTECTED] ___ 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] custom fields w. Mailgate in RT 3.6.0rc2
On Wed, 2006-05-31 at 21:27 -0400, Joe Auty wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'll take a look at the Perl module, but I also want to make sure I'm seeing the Wiki entry you are thinking of... Is this it? http://wiki.bestpractical.com/index.cgi?UseRtTool No. Although that may be another way to accomplish what you want. I was thinking more like this one: http://wiki.bestpractical.com/index.cgi?SetTicketPropertiesViaMail Anyone care to clarify what the status is here, and what I need to look into? I'm running the 3.6 rc, working off of the information Jesse provided to the list. I'm currently using RT 3.6 command line tool to set/update custom fields. Something like this works: rt create -t ticket set queue='QueueName' set status='open' set \ requestor=$USER set owner=$USER add \ CF-CustomFieldName='CustomFieldValue' My recommendation (without any real basis) is that you should lean toward using Jesse's extension as it is the most likely to be *The Right Way* in the future. HTH -- Joshua Colson [EMAIL PROTECTED] VoidGate InterNetworks ___ 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] Confused by Custom field rights
On Tue, 2006-05-30 at 13:01 -0700, Philip Kime wrote: RT 3.4.5/AT 1.2.3 Any ideas appreciated. I tried assigning ModifyCustomField to the Requestor Role only so they don't get the right on assets but this seems to not work - I can't modify any ticket custom fields any more and it only works again when I put the right back on the global Privileged group. Create a group for each set of users (if you haven't already) and assign the ModifyCustomField right for each individual custom field to the group. Use RTx::RightsMatrix to make it easier. HTH -- Joshua Colson [EMAIL PROTECTED] ___ 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] Change owner on Q change
On Thu, 2006-05-25 at 16:06 -0700, Kenneth Crocker wrote: To all, I hope this gets in, I've tried before and I do not get recognised. I have been trying to create a scrip to cause the owner to change to nobody when the Queue is changed. I have also created a new status that I use as a condition. The following is the code: # --- This code sets the owner to nobody for the new queue- # $RT::Logger-debug(trying to set owner); #my ($code, $msg) = $self-TicketObj-SetOwner(10, 'Force'); $self-TicketObj-_Set(Field = 'Owner', Value = 10); #$RT::Logger-debug(set owner: $code: $msg); #--# I'm certainly not an RT expert but I see a couple of problems off hand: # $RT::Logger-debug(trying to set owner); my $nobody = RT::User-new($RT::SystemUser); $nobody-Load(10); $self-TicketObj-SetOwner($nobody); # By convention, method names that start with _ are private and should # not be called directly. # That code is completely untested, but it may get you going in the right direction. -- Joshua Colson [EMAIL PROTECTED] ___ 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] First Impressions of RT V3.6.0rc2
On Wed, 2006-05-24 at 11:16 -0500, Duncan Shannon wrote: Logging in, frankly I like the user interface to 3.4.4 better, I think the lack of shading and borders causes a lot more eye strain, especially on an Does anyone have any screen shots of the new interface handy? Im quite excited to see it. I setup a quick an dirty demo instance of RT 3.6.0rc2/SQLite/Standalone_HTTPD available at http://demo.request-tracker.org:8080/ I'll leave it up for a few days if anyone wants to see what the new version looks like. Be warned however, it is very slow (my system, not RT). Login is 'guest' with 'rt36guest' Enjoy -- Joshua Colson [EMAIL PROTECTED] ___ 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] MySQL Import Question
On Tue, 2006-05-16 at 23:15 -0400, Mathew Snyder wrote: If I import the OLD old data can I import the NEW old data next to it or will it overwrite the OLD old data? If I can do this, how do I go about it? No. The tickets (and other objects) are assigned ID numbers in the database. These numbers start at 1 (or sometimes zero) and increment up as new objects are added. So, aside from the differences in the database schema between versions, in both you OLD old system and your NEW old system, you've got objects with IDs of 1,2,3,etc. and if you try to merge the systems, you'll have numerous conflicts. That being said, it can be done, it would just take quite a bit of manual intervention. Good luck. -- Joshua Colson [EMAIL PROTECTED] ___ 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] status of Steal Ticket feature?
On Wed, 2006-05-17 at 17:16 -0400, Joe Auty wrote: Hello, I've set my users with global superuser permissions, but for some reason this wasn't enough to own a ticket. I set them with own permissions, and now they can be assigned tickets. I can confirm this also. I have a SuperUser (using RT 3.6) who is unable to take ownership of a ticket. If I assign the OwnTicket right to the user then it works. I just hadn't gotten around to digging deeper for (what I'm assuming is) a bug. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Re: [3.6][FIX] Searches by custom fields
On Thu, 2006-05-11 at 08:34 -0700, Joshua Colson wrote: On Thu, 2006-05-11 at 11:53 +0400, Ruslan Zakirov wrote: Hello. I've commited fixes several fixes into 3.5 branch that should fix issues with searches by CFs. Please test it with your test cases and report back. I've been trying (as time permits) to isolate this custom field search issue. As I stated before, I've tried the latest SVN and RC2 with no luck. However, I migrated my 3.6.0pre1 instance to use Apache2/Mod_Perl2/MySQL4.1 and now the problem is gone. I did a recursive diff on the respective installations and they show that there are no differences in the code (with the exception of 'use lib' paths, etc) between the two installations. This leads me to believe that there is a problem somewhere in SearchBuilder in the abstraction differences in database types. Rangarajan's problem is on an Oracle system, my problem was with SQLite, and it seems to work flawlessly on MySQL. If I get the chance, I'm going to try to dig deeper into the problem. I just wanted to put the info that I had out so that others could think about it also. Thanks. -- Joshua Colson [EMAIL PROTECTED] iNation, LLC ___ 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] Re: [3.6][FIX] Searches by custom fields
On Fri, 2006-05-12 at 18:18 +0400, Ruslan Zakirov wrote: DBIx::SearchBuilder 1.39 and greater should fix this issue. Don't forget to run `make testdeps` on updates from SVN too :) I've upgraded DBIx::SearchBuilder to 1.43 from CPAN and the problem remains. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Re: [3.6][FIX] Searches by custom fields
On Thu, 2006-05-11 at 11:53 +0400, Ruslan Zakirov wrote: Hello. I've commited fixes several fixes into 3.5 branch that should fix issues with searches by CFs. Please test it with your test cases and report back. I've downloaded the current release of 3.5-TESTING (5204), built it and copied the database from my other RT instance to it. I still get zero results. I've verified that the custom fields are still populated on the test instance. Is there any information that I can provide that would help? Is anyone able to successfully search custom fields in 3.6, or is it likely that Rangarajan and I have just mis-configured something? Thanks for the help. -- Joshua Colson [EMAIL PROTECTED] ___ 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] basic info about localisation (I want to translate RT to Greek)
On Thu, 2006-05-11 at 13:52 +0300, Nick Demou wrote: I've spent some time with RT and I liked it :-). So now I am willing to begin translating most texts to my language (Greek) so that other people can feel more comfortable with the web interface and the automated emails. I would be gratefull if you could you give me some pointers to related information. If you're planning on doing any modifications to RT, I highly recommend you purchase the RT Essentials book from O'Reilly (http://rtbook.bestpractical.com/). To get you started though, look into Locale::Maketext (http://search.cpan.org/~petdance/Locale-Maketext-1.10/lib/Locale/Maketext.pod) and Locale::Maketext::Lexicon (http://search.cpan.org/~autrijus/Locale-Maketext-Lexicon-0.61/lib/Locale/Maketext/Lexicon.pm) which is what RT uses internally. There are also two subs that RT uses (defined in RT::Base), loc() and loc_fuzzy()... perldoc RT::Base I hope that helps. I really do recommend you get the RT Essentials book... I thought that I could read the code and just figure it out (which I probably could have) but the book makes that process much easier and less error prone. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Re: [3.6][FIX] Searches by custom fields
On Thu, 2006-05-11 at 13:08 -0400, Rangarajan Radhakrishnan wrote: Will it be possible for you to put a debug statement in DBIx::SearchBuilder as part of DoQuery that prints out the QueryString. Details in this thread: http://lists.bestpractical.com/pipermail/rt-users/2006-May/039168.html http://lists.bestpractical.com/pipermail/rt-users/2006-May/039185.html At least in the 3.6 version, RT now supports the following in the RT_SiteConfig to log SQL queries: Set($StatementLog, 'LogLevel'); ... for example: SNIP Set($StatementLog, 'debug'); /SNIP will log all SQL statements when logging is enabled. I'll turn on logging and paste them. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Re: [3.6][FIX] Searches by custom fields
On Thu, 2006-05-11 at 10:37 -0700, Joshua Colson wrote: At least in the 3.6 version, RT now supports the following in the RT_SiteConfig to log SQL queries: Set($StatementLog, 'LogLevel'); ... for example: SNIP Set($StatementLog, 'debug'); /SNIP will log all SQL statements when logging is enabled. ... this should say when *debug* logging is enabled. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Delete message with /Returned mail/ in the subject line on arrival
On Fri, 2006-05-05 at 17:06 -0400, Romeo Theriault wrote: Thanks for the tip about the regex. I have a quick question about that though. To match the words Returned mail wouldn't I have to use a \s to match the space that is between the word Returned and the word mail? or does RT use a modified version of regex? Literal spaces are valid within a regular expression. However, they only match the literal space (as you would expect) rather then all whitespace characters as the \s does. -- Joshua Colson [EMAIL PROTECTED] ___ 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] possible permissions (ModifyTicket) bug in 3.4.5?
On Wed, 2006-04-26 at 14:16 -0400, Claude M. Schrader wrote: Hello, We have been removing all global permissions from the Privileged user group on our RT install, to let some important customers have access to their own support queue. In doing this, we seem to have stumbled on what appears to be a bug with the ModifyTicket setting. The user is able to search for email addresses through the People area of a ticket, and return a list of every email address known to rt. I don't think this is a bug, more like a feature. RT makes the assumption that Privileged users are just that, privileged. What it seems you're attempting to do (setup mini-instances using queues) is not how RT is designed to operate (to my understanding). However, that being said, you should be able to add your own custom Rights to handle your situation. There may even be somebody who has done it already. -- Joshua Colson [EMAIL PROTECTED] ___ 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] (SOLVED) Mason attempting to parse image files
On Mon, 2006-04-24 at 17:10 +0400, Ruslan Zakirov wrote: Isn't there an autohanler in that directory that does this for you? In fact, there is. I'm shooting for the award for most stupid human mistakes on a mailing list in a week. }8-/ I was adding the content into local/html/NoAuth/images but I didn't copy over the autohandler. Hm, does it mean that if you create local/html/NoAuth/images/xxx.gif (without copy of autohandler) then RT doesn't run autohandler from share/html? If so then it sounds like bug in HTML::Mason. Yes. It does not automatically use the autohandler in the distribution html/NoAuth/images directory. So the autohandler should work like the rest of the overlays? If so, I'll subscribe/post this problem to the HTML::Mason list. -- Best regards, Ruslan. -- Joshua Colson [EMAIL PROTECTED] ___ 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] Mason attempting to parse image files
I'm running rt 3.6.0pre1 using sqlite and standalone_httpd in a test environment. I'm trying to update the logo by following the instructions at http://wiki.bestpractical.com/index.cgi?ChangeLogo which works but the image that I'm attempting to use is unable to load in the WebUI. It seems that the standalone_httpd is allowing Mason to process the image file(s) in /NoAuth/images/ and the image that I want to use has the string '%' or '' in it somewhere. I've looked on the Mason website and found instructions for preventing Mason from attempting to parse image files but they are specific to using Apache. Is there a way to do the same with the standalone_httpd? Thanks -- Joshua Colson [EMAIL PROTECTED] ___ 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] (SOLVED) Mason attempting to parse image files
On Fri, 2006-04-21 at 19:50 -0400, Jesse Vincent wrote: On Fri, Apr 21, 2006 at 04:44:08PM -0700, Joshua Colson wrote: I'm running rt 3.6.0pre1 using sqlite and standalone_httpd in a test environment. I'm trying to update the logo by following the instructions at http://wiki.bestpractical.com/index.cgi?ChangeLogo which works but the image that I'm attempting to use is unable to load in the WebUI. It seems that the standalone_httpd is allowing Mason to process the image file(s) in /NoAuth/images/ and the image that I want to use has the string '%' or '' in it somewhere. I've looked on the Mason website and found instructions for preventing Mason from attempting to parse image files but they are specific to using Apache. Is there a way to do the same with the standalone_httpd? Isn't there an autohanler in that directory that does this for you? In fact, there is. I'm shooting for the award for most stupid human mistakes on a mailing list in a week. }8-/ I was adding the content into local/html/NoAuth/images but I didn't copy over the autohandler. Thanks Jesse. -- Joshua Colson [EMAIL PROTECTED] VoidGate InterNetworks ___ 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] RT organization
On Tue, 2006-04-11 at 12:17 -0700, Sherman Boyd wrote: Hi, I've installed RT and have been playing around with it and am ready to implement. I'm a small computer consultant shop, and my clients are small to medium sized businesses (10-50 employees). I'd like to have the flexibility to either assign one user and password for the whole organization, or multiple users per company. When there is more than one user, I want them to be able to view the entire history for that organization. My first idea was to give each company a different queue, and give each company a group. Add each member of the company to the group and set the permission on the queue so that group could view it. But it appears I can't add non-privileged users to a group. Non privileged users can only see their own tickets, so it shouldn't matter that you cannot assign them to a group. ___ 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