Re: [rt-users] cannot get result of search Chinese character - centos 5.4
kevin, a. search from RT as "http://domain/Search/Simple.html?q=中文";, RT got: Found 0 tickets b. search database using SQL as "SELECT * FROM `rt4`.`Tickets` WHERE ( `Subject` LIKE '%中文%' )", database got: Showing rows 0 - 0 (1 total, Query took 0.0003 sec) Does it mean that we can search Chinese character from sql query, but can not from RT web page? -- LiuJia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] opensource report generator
Does anyone use any opensource generator to generate reports from RT? Any existing template I could take a look please? Thomas Lau Technology Analyst Principle One Limited 27/F Kinwick Centre, 32 Hollywood Road, Central, Hong Kong T +852 3555 2217 F +852 3555 Hong Kong . Singapore . Tokyo RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] rt 4.0.4 (and possibly others) autocomplete custom field showing values from all other custom fields for non super user accounts?
Hello, I opened a bug for the issue I described below, but no one else has confirmed that their install is behaving the same way. If someone out there with a test install of rt 4.0.x (preferably 4.0.4) could try the steps outlined below I would really appreciate it. It seems to occur in both of my environments but I wanted to rule out my own issues ;). Ok - From a clean rt 4.0.4 1. Log in as Root account 2. Create Queue1 3. Create CustomField1 as Type "Select one value" with Render Type "Dropdown" 4. Add values to CustomField1 "CF1Value1", "CF1Value2","CF1Value3", "CF1Value4" 5. Create CustomField2 as Type "Select one value" with Render Type "Dropdown" 6. Add values to CustomField2 "CF2Value1", "CF2Value2","CF2Value3", "CF2Value4" 7. Create CustomField3 as Type "Enter one value with Autocompletion" with Render Type "Dropdown" 8. Add values to CustomField3 "CF3Value1", "CF3Value2","CF3Value3", "CF3Value4" 9. Assign all of these fields to Queue1 10. Create a Group called Group1 11. Grant Group1 all permissions to Queue1 on General Rights and Rights for Staff tab 12. Create a user named User1 13. Add User1 to Group1 14. Create a new ticket in Queue1 as the ROOT account and go to Field CustomField3, Type 'C' and you should get only "CF3Value1", "CF3Value2","CF3Value3", "CF3Value4" 15. Log out, Log back in as User1 and Create a new record in Queue1. In CustomField3 Type 'C' and you will see values "CF1Value1", "CF1Value2","CF1Value3", "CF1Value4" "CF2Value1", "CF2Value2","CF2Value3", "CF2Value4" "CF3Value1", "CF3Value2","CF3Value3", "CF3Value4" Which are values from *all *of the custom fields, not just the autocomplete values specified in CustomField3. I am not sure how that could happen no matter how wacky I made permissions are unless it is a bug. 16. Log out from User1 17. Log Back into the system as ROOT and grant User1 "Do Anything and Everything" under Tools - Configuration - Global - User Rights - Rights for administrators. Log out. 18. Log Back into the system as User1 and create a new ticket in Queue1. Go to CustomField3 and type 'C'. You will now have the correct values for the autocomplete field. On Mon, Dec 12, 2011 at 2:21 PM, Jim Lesinski wrote: > Hello, > > Can someone check to see if an Autocomplete custom field shows values from > other custom fields in their RT 4.0.4 installation for non admin users? (By > non admin I mean the user does not have "Anything and Everything" > permission in the system.) > > When I am logged in as a non admin account and type in an autocomplete > field I seem to get all values from all custom fields that meet the text > criteria. If I grant this same user account "Anything and Everything" > permission, the correct values are then populated in the autocomplete > field. I have tested this on 2 different systems and I get the same results > from both. Basically it seems like the dataset returned for the super user > account is different than a non super user account. > > Can anyone else recreate this or verify that they have the same or > different results? > > Thanks, > Jim > > > > RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] User with no WatchAsAdminCc right was added as AdminCc
On Mon, Dec 19, 2011 at 07:10:36PM +0100, Gerard FENELON wrote: > Thanks Kevin > > Is there a way to prevent this behaviour ? > Sometimes I end up with Customers in AdminCc of tickets ... User education/training. Otherwise you have to write a Scrip that takes unprivileged users off of tickets (or otherwise modify RT to prevent it). It's quite useful to be able to add someone random as an AdminCc, to grant temporary visibility into 1 ticket in a Queue they would never normally have access to. -kevin > On 2011-12-19 19:01, Kevin Falcone wrote: > >On Fri, Dec 16, 2011 at 05:24:41PM +0100, Gerard FENELON wrote: > >>Hi > >> > >>One of my privileged users A was able to add another user B as AdminCc > >>even though that second User B does not have the WatchAsAdminCc right > >> as far as I can make > >>out. > >That right only affects your ability to add yourself as an AdminCc > >User A has ModifyTicket, they can add anyone they want as an AdminCc. > > > >-kevin > > > >>User B is not privileged. > >>User B does not have any rights for that Queue in > >> Admin/Queues/UserRights.html > >> > >>User B belongs to only one group C directly. > >>Group C is not included in any other. > >>Group C does not have any rights in Admin/Groups/GroupRights.html > >>Group C does not have any rights for that Queue in > >> Admin/Queues/GroupRights.html > >> > >>The WatchAsAdminCc right on that queue is only given to User-defined > >> groups to which User B > >>does not belong either directly or indirectly. > >> > >>If I look at the RightsMatrix for User B, he does not have > >> WatchAsAdminCc right on any queue. > >>If I look at the RightsMatrix for Group C, it does not have > >> WatchAsAdminCc right on any queue. > >> > >>User A has the following rights on that queue C > >> > >> * CommentOnTicket > >> * CreateTicket > >> * ModifyTicket > >> * OwnTicket > >> * ReplyToTicket > >> * SeeQueue > >> * ShowACL > >> * ShowOutgoingEmail > >> * ShowTicket > >> * ShowTicketComments > >> * StealTicket > >> * TakeTicket > >> * Watch > >> * WatchAsAdminCc > >> > >>Any ideas where I might have messed up ? > >>Gerard > > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston March 5 & 6, 2012 pgp75CKRV04US.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] cannot get result of search Chinese character - centos 5.4
On Tue, Dec 20, 2011 at 01:30:53AM +0800, nectar wrote: > Sir, > > Installed RT4.0.4 on CentOS 5.4 box, make new database from RT or > restore mysql file, everything looks well. But cannot get result of > search Chinese character. > > For example, if ticket subject is "Best Practical 公司", then we can > search "Best" or "Practical" to list this ticket, but "公司" get no > result. > > I tried to install old version of FCGI(from 0.74 to 0.68), but still > the same issue. > > refer: Centos 5.4 + FCGI + Unicode in messages = Failure - > http://www.gossamer-threads.com/lists/rt/users/92359 Were you getting Wide character in the logs? Downgrading FCGI is unlikely to do anything other than cause problems with RT4.0.4 What is the actual query being run, against what raw Subject field from the database that you expect to match on? -kevin pgpsvpyZXQeHi.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] User with no WatchAsAdminCc right was added as AdminCc
Thanks Kevin Is there a way to prevent this behaviour ? Sometimes I end up with Customers in AdminCc of tickets ... Gerard On 2011-12-19 19:01, Kevin Falcone wrote: On Fri, Dec 16, 2011 at 05:24:41PM +0100, Gerard FENELON wrote: Hi One of my privileged users A was able to add another user B as AdminCc even though that second User B does not have the WatchAsAdminCc right as far as I can make out. That right only affects your ability to add yourself as an AdminCc User A has ModifyTicket, they can add anyone they want as an AdminCc. -kevin User B is not privileged. User B does not have any rights for that Queue in Admin/Queues/UserRights.html User B belongs to only one group C directly. Group C is not included in any other. Group C does not have any rights in Admin/Groups/GroupRights.html Group C does not have any rights for that Queue in Admin/Queues/GroupRights.html The WatchAsAdminCc right on that queue is only given to User-defined groups to which User B does not belong either directly or indirectly. If I look at the RightsMatrix for User B, he does not have WatchAsAdminCc right on any queue. If I look at the RightsMatrix for Group C, it does not have WatchAsAdminCc right on any queue. User A has the following rights on that queue C * CommentOnTicket * CreateTicket * ModifyTicket * OwnTicket * ReplyToTicket * SeeQueue * ShowACL * ShowOutgoingEmail * ShowTicket * ShowTicketComments * StealTicket * TakeTicket * Watch * WatchAsAdminCc Any ideas where I might have messed up ? Gerard RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] why my rt4 loop create new ticket or reply ticket from the same email
On Tue, Dec 20, 2011 at 01:02:02AM +0800, nectar wrote: > Christonph, > > Thanks for you reply. But I do not know how to test, tried to test > rt-mailgate, get blow information. > > # echo tr-lai |/opt/rt4/bin/rt-mailgate --queue sales --action tr-lai is not a valid mail message, so this will never work. You must write a simple valid email to test with using cat or < From: y...@email.com Subject: test body -kevin > correspond --url https://domain/rt --debug > /opt/rt4/bin/rt-mailgate: temp file is '/tmp/SjjXGauJZ7/SzAAaaBYHJ' > /opt/rt4/bin/rt-mailgate: connecting to > https://domain/rt/REST/1.0/NoAuth/mail-gateway > An Error Occurred > = > > 500 read failed: > > /opt/rt4/bin/rt-mailgate: undefined server error > > -- > LiuJia > > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston March 5 & 6, 2012 pgpqgFHV1BvnX.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] User with no WatchAsAdminCc right was added as AdminCc
On Fri, Dec 16, 2011 at 05:24:41PM +0100, Gerard FENELON wrote: >Hi > >One of my privileged users A was able to add another user B as AdminCc >even though that second User B does not have the WatchAsAdminCc right as > far as I can make >out. That right only affects your ability to add yourself as an AdminCc User A has ModifyTicket, they can add anyone they want as an AdminCc. -kevin >User B is not privileged. >User B does not have any rights for that Queue in > Admin/Queues/UserRights.html > >User B belongs to only one group C directly. >Group C is not included in any other. >Group C does not have any rights in Admin/Groups/GroupRights.html >Group C does not have any rights for that Queue in > Admin/Queues/GroupRights.html > >The WatchAsAdminCc right on that queue is only given to User-defined > groups to which User B >does not belong either directly or indirectly. > >If I look at the RightsMatrix for User B, he does not have WatchAsAdminCc > right on any queue. >If I look at the RightsMatrix for Group C, it does not have WatchAsAdminCc > right on any queue. > >User A has the following rights on that queue C > > * CommentOnTicket > * CreateTicket > * ModifyTicket > * OwnTicket > * ReplyToTicket > * SeeQueue > * ShowACL > * ShowOutgoingEmail > * ShowTicket > * ShowTicketComments > * StealTicket > * TakeTicket > * Watch > * WatchAsAdminCc > >Any ideas where I might have messed up ? > >Gerard > > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston ? March 5 & 6, 2012 pgpX54aHQ3m0D.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Cosmetic Bug in RT 4.0.4: "Date and Time" partially visible
On Fri, Dec 16, 2011 at 08:24:17AM -0800, 20/20 Lab wrote: >I was also able to reproduce this in Firefox 8, on an XP machine, running > 4.0.3. Tho I cant >say I've ever noticed it before. > >On 12/16/2011 12:01 AM, Stefan Vollmar wrote: > > Hi, > > we have found a bug in RT (4.0.4) related to the "Date and Time"-picker > used to create reminders. To reproduce this bug, select a ticket and > then click into the "Due" text box in the "Reminders" widget of the > ticket overview. Next, select a date. If your browser window is not wide > enough, the time selection ui will be cut off at the windows edge. We > found this behavior using both Chromium and Firefox on Linux (see > screenshots). It is probably present in other browsers as well. I believe there are two branches open about this, neither of which is a great fix which is why we haven't merged anything down yet. $ git br -a | grep 4.0 | grep time remotes/origin/4.0/datetimepicker-ui remotes/origin/4.0/time-picker-overflow-fix -kevin pgpXi5B4Vyc0l.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] possible RT 4.0.4 attachment bug
On Fri, Dec 16, 2011 at 08:24:02AM -0500, mja...@guesswho.com wrote: >This may be a bug in the way attachments are handled in 4.0.4. > >We recently spun up a new instance of RT 4.0.2, then upgraded to 4.0.4. > Running on Centos 5.7 >using MySQL. Yesterday we were at ticket #53. A user sent an email last > night with an >attachment containing sql statements (a database backup). His ticket id is > #63. > >There aren't any intervening tickets. When I use the quick search for > example, and try to >load a ticket between 53-63, I get an error: > >RT Error Could not load ticket 57 (for example) > >The only thing I can think of is that some of the statements in the > attachment were acted on. >Is this possible? What's in your RT logs? -kevin pgpVKQH9eYBZZ.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] cannot get result of search Chinese character - centos 5.4
Sir, Installed RT4.0.4 on CentOS 5.4 box, make new database from RT or restore mysql file, everything looks well. But cannot get result of search Chinese character. For example, if ticket subject is "Best Practical 公司", then we can search "Best" or "Practical" to list this ticket, but "公司" get no result. I tried to install old version of FCGI(from 0.74 to 0.68), but still the same issue. refer: Centos 5.4 + FCGI + Unicode in messages = Failure - http://www.gossamer-threads.com/lists/rt/users/92359 Do you have advise? Thanks, -- Jia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Solved : Re: Error running rt-validator
Curse my over-exuberance. I forgot step 6b in the readme. Obviously Validator is going to fail if the DB schema is off, and other assorted dumbs. Many thanks to Kevin's swift and accurate catch of it on the chat-room! RTFM. Always RTFM. Thanks! A On 11-12-19 10:39 AM, Arnon Clark wrote: Hey folks, I'm trying to run validator and am running into the following error : Executing query: SELECT m.id, g.id, g.Instance FROM Groups g JOIN ACL m ON g.id = m.LastUpdatedBy WHERE g.Domain = ? AND g.Type = ? [Mon Dec 19 15:38:54 2011] [warning]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (./sbin/rt-validator:1078) [Mon Dec 19 15:38:54 2011] [crit]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (/home/arnon/rt-4.0.4/sbin/../lib/RT.pm:341) DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. Circumstances : I've got a clean install of 4.0.4, bringing in a DB from 3.8.7 I import the mysql dump I made, run the vulnerable passwords, shrink-transactions and shrink cgm scripts, but when I check with validator, I get that error. Any suggestions? Regards, and thanks Arnon RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Error running rt-validator
>Circumstances : >I've got a clean install of 4.0.4, bringing in a DB from 3.8.7 >I import the mysql dump I made, run the vulnerable passwords, >shrink-transactions and shrink cgm scripts, but >when I check with validator, >I get that error. Any suggestions? Did you run the DB upgrade scripts? RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] why my rt4 loop create new ticket or reply ticket from the same email
Christonph, Thanks for you reply. But I do not know how to test, tried to test rt-mailgate, get blow information. # echo tr-lai |/opt/rt4/bin/rt-mailgate --queue sales --action correspond --url https://domain/rt --debug /opt/rt4/bin/rt-mailgate: temp file is '/tmp/SjjXGauJZ7/SzAAaaBYHJ' /opt/rt4/bin/rt-mailgate: connecting to https://domain/rt/REST/1.0/NoAuth/mail-gateway An Error Occurred = 500 read failed: /opt/rt4/bin/rt-mailgate: undefined server error -- LiuJia RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Error running rt-validator
Hey folks, I'm trying to run validator and am running into the following error : Executing query: SELECT m.id, g.id, g.Instance FROM Groups g JOIN ACL m ON g.id = m.LastUpdatedBy WHERE g.Domain = ? AND g.Type = ? [Mon Dec 19 15:38:54 2011] [warning]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (./sbin/rt-validator:1078) [Mon Dec 19 15:38:54 2011] [crit]: DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. (/home/arnon/rt-4.0.4/sbin/../lib/RT.pm:341) DBD::mysql::st execute failed: Unknown column 'm.LastUpdatedBy' in 'on clause' at ./sbin/rt-validator line 1078. Circumstances : I've got a clean install of 4.0.4, bringing in a DB from 3.8.7 I import the mysql dump I made, run the vulnerable passwords, shrink-transactions and shrink cgm scripts, but when I check with validator, I get that error. Any suggestions? Regards, and thanks Arnon RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] RT 4.04 and Articles
On 12/16/2011 10:57 AM, Joe Kirby wrote: > Our organization has not used RTFM at all and when I begin to explore > Articles within RT 4.04 I see a couple of things that I think may be our > lack of experience with this aspect. > > 1. There does not seem to be a way for me to add any Content since it is > always just a header and no box for entry > > 2. When I try to extract an article from and existing ticket I get all > the History with an apparent option to select which comments or replies > I am interested in however there is nothing in the drop down menu for > selecting so I can only add all history by hitting Create at the bottom > of the screen > > > Is there a good doc area for Articles that I may use to assist me in RT > 4.04 setup? docs/customizing/articles_introduction.pod Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] why my rt4 loop create new ticket or reply ticket from the same email
On Sat, 17 Dec 2011, nectar wrote: > create ticket#5 or other new tickets with the same email content. More ... > I tried to check RT configure, postfix configure and apache configure > files. Still can not find solution. Do you have advise? I had such behavior, when my MTA (in my case exim, not postfix) always believed the delivery had failed and retried forever. So try to find out, which returncode comes from rt's mailgate, and which returncodes postfix does accept as 'correctly delivered'. Stucki -- Christoph von Stuckrad * * |nickname |Mail \ Freie Universitaet Berlin |/_*|'stucki' |Tel(Mo.,Mi.):+49 30 838-75 459| Mathematik & Informatik EDV |\ *|if online| (Di,Do,Fr):+49 30 77 39 6600| Takustr. 9 / 14195 Berlin * * |on IRCnet|Fax(home): +49 30 77 39 6601/ RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012