Re: [rt-users] Problem with HTML tags appearing in correspondence
642 1 Good morning, we also have this problem, that since 4.2.1 we have html tags in some (not in all, but I have no idea why sometimes and sometimes not ..) replies. So, I opened a ticket in testqueue: -cut - Subject: 1 MIME-Version: 1.0 X-Mailer: MIME-tools 5.504 (Entity 5.504) Content-Disposition: inline X-RT-Interface: Web Message-ID: rt-4.2.1-2146-1387269743-1411.0-...@test.skm-skyline.de Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: binary X-RT-Original-Encoding: utf-8 Content-Length: 19 222 -cut - And then I do a reply via webinterface, now we have html tags in reply -cut - MIME-Version: 1.0 In-Reply-To: rt-4.2.1-2146-1387269743-1411.0-...@test.skm-skyline.de X-Mailer: MIME-tools 5.504 (Entity 5.504) Content-Disposition: inline X-RT-Interface: Web References: rt-4.2.1-2146-1387269743-1411.0-...@test.skm-skyline.de rt-ticket-...@test.skm-skyline.de Content-Type: text/plain; charset=utf-8 Message-ID: rt-4.2.1-4704-1387269993-1445.642-...@test.skm-skyline.de Content-Transfer-Encoding: binary X-RT-Original-Encoding: utf-8 RT-Send-CC: Content-Length: 150 On Tue Dec 17 09:42:23 2013, mpolenske wrote:br / gt; 222br / br / --nbsp;br / Viele Gruuml;szlig;ebr / Michael Polenske -cut - From my point of view the headers seem to be identical ... Attached a screenshot how it look like in webinterface Cheers - Michael -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Freitag, 13. Dezember 2013 17:10 To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Problem with HTML tags appearing in correspondence Having attempted to Reply using the Rich Text Editor on a clean RT 4.2.1 install, I cannot replicate this at all. Since you see literal HTML tags being recorded in ticket history, this points to something broken in your use of the RichText editor. Can one of the reporters please provide show a test correspondence with the problem with Show Full Headers, and then with Download with headers for each of the pieces. Thanks -kevin On Thu, Dec 12, 2013 at 06:45:10AM +0800, Lai Zit Seng wrote: I seem to be experiencing the same problem as mentioned in: [4]http://requesttracker.8502.n7.nabble.com/RT-4-2-1-Weird-issue-with-HT ML-comments-correspondense-RT-always-registers-plain-text-with-HTML-tags -td56005.html I don't have custom templates. The HTML tags are only appearing when replying through the web interface. Disabling the Rich Text Editor avoids this problem. Hope this can be fixed? Regards, 2013_12_17_09_53_49_642_1.png
[rt-users] SOLVED Re: No mailgate tickets on new 4.18 install
I had a Linux expert have a look - there were a couple of directories missing and a couple of other small conf issues. All working now, thanks. -- View this message in context: http://requesttracker.8502.n7.nabble.com/No-mailgate-tickets-on-new-4-18-install-tp56000p56063.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] How to create a new condition through the web gui
Hi! I'm wondering how to create a new condition, spesifically I want to set up a new condition OnCreateFromEmail, as specified here: http://requesttracker.wikia.com/wiki/OnCreateFromEmail . I found the instructions here: http://requesttracker.wikia.com/wiki/WriteCustomCondition , but that doesn't mention how to actually add the scrip. So my question is basically how I add the new condition? - Marius
[rt-users] RTIR for RT 4.2.x
I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. When can we expect to see a release of RTIR compatible with the currently version of RT? Thanks.
Re: [rt-users] Reply text box slow to load
Hi! I have exactly the same problem. I've investigated the loading of the page with the WYSIWYG-editor and got the following results: http://s22.postimg.org/wqo1j42r5/wysiwyg.png Maybe this will help debugging this further? After the initial load the future loads of that js will be cached and therefore much slower. And after the cache expiry (typically the next workday) you have to wait for another 30 seconds to get the WYSIWYG editor back up again. - Marius
[rt-users] any page showing a user drop down in a ticket is loading slow
Hello, I just updated from 4.0.10 to 4.2.1 and it seems to be working well except when I am in a ticket, any page that shows a user drop down, ie display and people load incredible slowly. I enabled slow query logging and below are the two queries that appear to be causing the problem. I appreciate any help in resolving this. 10 second load times is rough. Please let me know what further information is needed. Thanks! //adam # Time: 131217 14:42:38 # User@Host: rt_user[rt_user] @ ticket.cs.pitt.edu [136.142.23.83] # Query_time: 9 Lock_time: 0 Rows_sent: 5 Rows_examined: 175403 SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_3 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN CachedGroupMembers CachedGroupMembers_4 ON ( CachedGroupMembers_4.MemberId = Principals_1.id ) WHERE ((ACL_3.ObjectType = 'RT::Queue' AND ACL_3.ObjectId = 3) OR (ACL_3.ObjectType = 'RT::System') OR (ACL_3.ObjectType = 'RT::Queue' AND ACL_3.ObjectId = 3) OR (ACL_3.ObjectType = 'RT::System')) AND (ACL_3.PrincipalId = CachedGroupMembers_4.GroupId) AND (ACL_3.PrincipalType = 'Group') AND (ACL_3.RightName = 'OwnTicket' OR ACL_3.RightName = 'SuperUser') AND (CachedGroupMembers_2.Disabled = '0') AND (CachedGroupMembers_2.GroupId = '4') AND (CachedGroupMembers_4.Disabled = '0') AND (Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'User') AND (Principals_1.id != '1') ORDER BY main.Name ASC; # Time: 131217 14:42:48 # User@Host: rt_user[rt_user] @ ticket.cs.pitt.edu [136.142.23.83] # Query_time: 8 Lock_time: 0 Rows_sent: 5 Rows_examined: 175403 SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_3 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN CachedGroupMembers CachedGroupMembers_4 ON ( CachedGroupMembers_4.MemberId = Principals_1.id ) WHERE ((ACL_3.ObjectType = 'RT::Ticket' AND ACL_3.ObjectId = 35402) OR (ACL_3.ObjectType = 'RT::Queue' AND ACL_3.ObjectId = 3) OR (ACL_3.ObjectType = 'RT::System') OR (ACL_3.ObjectType = 'RT::Ticket' AND ACL_3.ObjectId = 35402) OR (ACL_3.ObjectType = 'RT::Queue' AND ACL_3.ObjectId = 3) OR (ACL_3.ObjectType = 'RT::System')) AND (ACL_3.PrincipalId = CachedGroupMembers_4.GroupId) AND (ACL_3.PrincipalType = 'Group') AND (ACL_3.RightName = 'OwnTicket' OR ACL_3.RightName = 'SuperUser') AND (CachedGroupMembers_2.Disabled = '0') AND (CachedGroupMembers_2.GroupId = '4') AND (CachedGroupMembers_4.Disabled = '0') AND (Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'User') AND (Principals_1.id != '1') ORDER BY main.Name ASC;
Re: [rt-users] RTIR for RT 4.2.x
On Tue, Dec 17, 2013 at 03:36:30PM +, Alex Young wrote: I'm assuming that the current 3.0 version of RTIR isn't compatible with RT 4.2.x at the moment. As answered a few times on the RTIR mailing list, it is not. When can we expect to see a release of RTIR compatible with the currently version of RT? When it's ready. -kevin pgp0nRhnJg6tQ.pgp Description: PGP signature
Re: [rt-users] Reply text box slow to load
On Tue, Dec 17, 2013 at 03:53:36PM +, Marius Flage wrote: I have exactly the same problem. I've investigated the loading of the page with the WYSIWYG-editor and got the following results: [1]http://s22.postimg.org/wqo1j42r5/wysiwyg.png Maybe this will help debugging this further? After the initial load the future loads of that js will be cached and therefore much slower. And after the cache expiry (typically the next workday) you have to wait for another 30 seconds to get the WYSIWYG editor back up again. While this confirms that something is taking a long time to load, the consistent 15 seconds on each request is quite odd, especially since larger files take mere milliseconds to download. Are you using JSMin? How is your RT configured, etc, etc. If you can replicate these timings on issues.bestpractical.com it would be interesting. -kevin pgpiJNRKqn77q.pgp Description: PGP signature
Re: [rt-users] How to create a new condition through the web gui
On Tue, Dec 17, 2013 at 03:56:19PM +0100, Marius Flage wrote: I'm wondering how to create a new condition, spesifically I want to set up a new condition OnCreateFromEmail, as specified here: http://requesttracker.wikia.com/wiki/OnCreateFromEmail . I found the instructions here: http://requesttracker.wikia.com/wiki/WriteCustomCondition , but that doesn't mention how to actually add the scrip. So my question is basically how I add the new condition? You may find it easier to use the new extension we blogged about, instead of User Defined scrips/actions http://blog.bestpractical.com/2013/12/new-web-ui-for-rt-actions-and-conditions.html -kevin pgpLrZyaNYiov.pgp Description: PGP signature
Re: [rt-users] any page showing a user drop down in a ticket is loading slow
On 17 December 2013 11:53, Adam Hobaugh a...@cs.pitt.edu wrote: Hello, I just updated from 4.0.10 to 4.2.1 and it seems to be working well except when I am in a ticket, any page that shows a user drop down, ie display and people load incredible slowly. I enabled slow query logging and below are the two queries that appear to be causing the problem. I appreciate any help in resolving this. 10 second load times is rough. Please let me know what further information is needed. Hi Adam, I’m not sure if this applies but we had this issue and it was an RT ACL issue. I remember that it was an issue with granting or not-granting rights to special groups Everyone or “Unprivileged” but the details of which I cannot recall exactly. I do remember there were large ACL joins in the database whenever we would try to load pages with these drop downs just like you’ve described in your post. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932
[rt-users] Chart and Show Results not showing correct query
Hello, I have been using the Chart option in RT 3.8. When I click on Show Results a different query is shown e.g. the most recent other saved query. Also, it would be useful if the Total result in the table on the Chart executed the full query. See attached chart. Related to the above is the ability to edit the query than creates a chart. I get inconsistent results so it looks like the query linked to a saved Chart might be a clone of the query run when the Chart is saved. thanks Richard RT_ToldMonthly.png Description: Binary data
Re: [rt-users] any page showing a user drop down in a ticket is loading slow
On 17 December 2013 13:19, Adam Hobaugh a...@cs.pitt.edu wrote: Hi Adam, I’m not sure if this applies but we had this issue and it was an RT ACL issue. I remember that it was an issue with granting or not-granting rights to special groups Everyone or “Unprivileged” but the details of which I cannot recall exactly. I do remember there were large ACL joins in the database whenever we would try to load pages with these drop downs just like you’ve described in your post. Hello Landon, I removed the rights from Everyone and we had nothing on Unprivileged and I still see the issue. Thanks for the suggestion though. Maybe you need to go the other way with it and grant something? Maybe you need to grant some simple rights for showing users or something to Privileged. I just checked ours and I have “Privileged” under “General Rights” allowed to View custom field values” configured in each queue. In the Global - Group Rights the View custom fields” is not granted. I wish I could remember the details of what solved it for us. I do remember some things were changed which caused the issue and then had to be rolled back. I just don’t recall what was changed that caused it. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932
Re: [rt-users] any page showing a user drop down in a ticket is loading slow
On 17 December 2013 13:19, Adam Hobaugh a...@cs.pitt.edu wrote: Hi Adam, I’m not sure if this applies but we had this issue and it was an RT ACL issue. I remember that it was an issue with granting or not-granting rights to special groups Everyone or “Unprivileged” but the details of which I cannot recall exactly. I do remember there were large ACL joins in the database whenever we would try to load pages with these drop downs just like you’ve described in your post. Hello Landon, I removed the rights from Everyone and we had nothing on Unprivileged and I still see the issue. Thanks for the suggestion though. Maybe you need to go the other way with it and grant something? Maybe you need to grant some simple rights for showing users or something to Privileged. I just checked ours and I have “Privileged” under “General Rights” allowed to View custom field values” configured in each queue. In the Global - Group Rights the View custom fields” is not granted. I wish I could remember the details of what solved it for us. I do remember some things were changed which caused the issue and then had to be rolled back. I just don’t recall what was changed that caused it. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932
Re: [rt-users] How to create a new condition through the web gui
Den 17.12.2013 20:19, skrev Kevin Falcone: You may find it easier to use the new extension we blogged about, instead of User Defined scrips/actions http://blog.bestpractical.com/2013/12/new-web-ui-for-rt-actions-and-conditions.html -kevin Hi! This extension looks very nice and shiny and I just added it to my RT, but I still have no idea how to use it :) And especially not for my example. The example I found uses raw perl code that returns 0/1 depending on some variables, but recreating this using just the five text input fields provided by the extension seems impossible.. ? What should I enter for Condition Module, Parameters to Pass and Applicable Transaction Types? The Perl snippet seems to first check TransactionObj if the transaction type is Create, if not it'll return 0. Then it will check if it's the first transaction and finally it'll check for a header Received. Replicating this in 5 text input fields seems impossible :) - Marius
[rt-users] ExecuteCode by Queue AdminCc groups on RT::System
Hello, My production system contains a few ACL's that do not dump correctly using rt-dump-metadata. They end up multiple times in our dump as: { Right : ExecuteCode, GroupDomain : RT::System-Role, GroupType : AdminCc }, (In JSON for readability) These are in reality applied to the AdminCC group principal of queues. What is the bug here? Is it that I should be able to see such a right in the Global rights page, or should the right not have been granted since the upgrade step (3.9.1 iirc)? (It is a bit of a weird delegation of rights, but a few of our AdminCc groups have indeed the right to edit templates). Thanks, Kai signature.asc Description: OpenPGP digital signature
Re: [rt-users] RES: RE: RES: Sphinx fulltext index v4.0.4
Hi, didn't get a response there. Is there a way to solve this? Possibly through debugging RT4 to see how its actually trying to connect to searchd instead of how the config looks like it should? Regards On 04/12/2013 13:45, m...@fv-berlin.de wrote: On Jan 5 09:55:28 EST 2012, Luciano Ernesto da Silva wrote: Hi, did you ever receive an answer to your problem because I am encountering the same thing (searchd running on 0.0.0.0:3312 but RT reporting it cant connect to it / resolve localhost). Additionally to what you already posted, I made sure /etc/hosts connects 127.0.0.1 to localhost and commented out the ::1 line because I suspected RT4 might not be IPv6-aware, but that didnt help. KR Hello, This is my configuration on sphinx.conf, seems that even I change the name of sql_host, RT still says : failed to resolve searchd host (name=localhost). Seems that RT isn't looking to the right connection. Luciano vi /etc/sphinxsearch/sphinx.conf source rt { type= mysql sql_host= localhost sql_db = rt4 sql_user= rt4 sql_pass= secret sql_query_pre = SET NAMES utf8 sql_query = \ SELECT a.id, a.content FROM Attachments a \ JOIN Transactions txn ON a.TransactionId = txn.id AND txn.ObjectType = 'RT::Ticket' \ JOIN Tickets t ON txn.ObjectId = t.id \ WHERE a.ContentType = 'text/plain' AND t.Status != 'deleted' sql_query_info = SELECT * FROM Attachments WHERE id=$id } index rt { source = rt path= /opt/rt4/var/sphinx/index docinfo = extern charset_type= utf-8 } indexer { mem_limit = 32M } searchd { port= 3312 log = /opt/rt4/var/sphinx/searchd.log query_log = /opt/rt4/var/sphinx/query.log read_timeout= 5 max_children= 30 pid_file= /opt/rt4/var/sphinx/searchd.pid max_matches = 1 seamless_rotate = 1 preopen_indexes = 1 unlink_old = 1 compat_sphinxql_magics = 0 } Sphinx is running OK: netstat -ntlp | grep searchd tcp0 0 0.0.0.0:33120.0.0.0:* LISTEN 10762/searchd ps -eaf |grep searchd root 10762 1 0 09:17 pts/000:00:00 searchd The table AttachmentsIndex seems OK: mysql show create table AttachmentsIndex; +--+ ---+ | Table| Create Table | +--+ ---+ | AttachmentsIndex | CREATE TABLE `AttachmentsIndex` ( `id` int(10) unsigned NOT NULL, `weight` int(11) NOT NULL, `query` varchar(3072) NOT NULL, KEY `query` (`query`(1024)) ) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:3312/rt' | +--+ ---+ 1 row in set (0.00 sec) -Mensagem original- De: Poulter, Dale [mailto:dale.poulter at Vanderbilt.Edu] Enviada em: quinta-feira, 5 de janeiro de 2012 10:50 Para: Luciano Ernesto da Silva; rt-users at lists.bestpractical.com Assunto: RE: [rt-users] RES: Sphinx fulltext index v4.0.4 Sounds like it cannot connect to the sphinx server. Can you confirm that sphinx is running (ps -eaf |grep searchd ) and that it is running on the port specified in the attachmentsindex create statement (mysql show create table AttachmentsIndex; )? I believe the default port is 9312 but the documents at http://blog.bestpractical.com/2011/06/full-text-searching.html indicate that the port is 3312. -Original Message- From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Luciano Ernesto da Silva Sent: Thursday, January 05, 2012 5:24 AM To: rt-users at lists.bestpractical.com Subject: [rt-users] RES: Sphinx fulltext index v4.0.4 Hello, I installed everything as described here by Dale/ documentation from docs/full_text_indexing.podc , documentarion by sphinxsearch but i got this error: RT: DBD::mysql::st execute failed: Unable to connect to foreign data source: failed to resolve searchd host (name=localhost) at
Re: [rt-users] RES: RE: RES: Sphinx fulltext index v4.0.4
On Tue, 2013-12-17 at 23:11 +0100, m...@fv-berlin.de wrote: didn't get a response there. Is there a way to solve this? Possibly through debugging RT4 to see how its actually trying to connect to searchd instead of how the config looks like it should? This lies firmly in the domain of having to debug MySQL and the SphinxSE plugin, and not in debugging RT itself. From recent testing locally, using 127.0.0.1 instead of localhost works acceptably. Future versions of RT may default to 127.0.0.1 instead of localhost in the Sphinx connection parameters -- though I would be much more comfortable making that change if the underlying reason for the 'localhost' failure were clear. Unfortunately, debugging mysql is rather complex. You can drop and re-create your SphinxSE table by running 'DROP TABLE AttachmentsIndex' at a mysql prompt, re-running rt-setup-fulltext-index, and providing sphinx://127.0.0.1:3312/rt as the URL of the Sphinx server. - Alex
[rt-users] installing rt tracker with a screen reader
Hi. A it student. And using this software. And using the jaws for windows screen reader from http://www.freedomscientific.com Now. How do I install this software and then configure. Using windows 7 pro 32 bit, firefox 25, and internet explorer 11. Marvin.
[rt-users] rt 4.2.1 error: Internal Server Error
All, Any one can help me to find the issues here. RH6 Oracle as DB fastcgi Can't locate RT_Config.pm in @INC (@INC contains: /opt/rt4/local/etc /opt/rt4/etc /opt/rt4/sbin/../local/lib /opt/rt4/sbin/../lib /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /opt/rt4/sbin/../lib/RT/Config.pm line 1063. [Wed Dec 18 02:05:41 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi (pid 31300) terminated by calling exit with status '255' [Wed Dec 18 02:05:41 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:42 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:45 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:48 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:51 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:54 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:05:57 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds [Wed Dec 18 02:06:00 2013] [error] [client 128.122.120.154] FastCGI: comm with (dynamic) server /opt/rt4/sbin/rt-server.fcgi aborted: (first read) idle timeout (30 sec) [Wed Dec 18 02:06:00 2013] [error] [client 128.122.120.154] FastCGI: incomplete headers (0 bytes) received from server /opt/rt4/sbin/rt-server.fcgi [Wed Dec 18 02:06:00 2013] [warn] FastCGI: (dynamic) server /opt/rt4/sbin/rt-server.fcgi has failed to remain running for 30 seconds given 3 attempts, its restart interval has been backed off to 600 seconds