[rt-users] Encoding of subject line in outgoing messages
Hello list, I just installed RT 4.0.4 on Debian Squeeze with mySQL. If I create a ticket in the web interface with french special characters like é à in the subject, the subject line of the outgoing mail for the requestor is not OK. Here is the mail header : Subject: =?us-ascii?Q?=3D=3FUTF-8=3FB=3FW3NlZmFuZXQgIzE2XSBBdXRvUmVwbH?= =?us-ascii?Q?k6IENyw6nDqSBkYW5zIFJUIGF2ZWM=3D=3F=3D?= Seems to be utf-8 surrounded by us-ascii !? EmailOutputEncoding is set to 'utf-8' ( that was the default config ). Where does this us-ascii come from ? Everything shows OK in the web interface. No problem with the special characters in the description of issue. The outgoing emails are handeled by mailx. No problem with special characters when using mailx from the console. Stephane RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Encoding of subject line in outgoing messages - not RT fault
Hello again, Discovered the option testfile for MailCommand : the saved file has subject OK , so RT itself is OK. Have to check mailx.. or try something else. Sorry for the noise. Stephane. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] any simple way to access custom transaction fields?
Hi, I have custom transaction fields for tickets but I can't see any of values of them while using rt cli command: rt show ticket id/history How I could easily access these fields, (Perl API would be my last option)? I would like to generate some reports based on these values.. -- Thanks Marius RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] External Authentication with LDAP menssager erro!
Hi,
This file only contains an example, this config isn't used for RT:
/opt/rt4/local/plugins/RT-Authen-ExternalAuth/etc/RT_Siteconfig
The content however can be included in this file:
/opt/rt4/etc/RT_Siteconfig
In there you'll have to make sure that everything is configured for your
situation.
Adding this line to your RT_SiteConfig will help finding problems, might
help a bit:
Set($LogToSyslog, debug);
And, last but not least. Make sure you've loaded the plugin in your
RT_SiteConfig:
# How we have the plugins set, ExternalAuth at the end.
Set(@Plugins, (qw(RT::Extension::SLA RT::Extension::HistoryFilter
RT::Extension::ResetPassword RT::Extension::MergeUsers
RT::Authen::ExternalAuth)));
Hope this helps a bit, otherwise you'll have to provide us with more info
on what your trying to do + what your current RT_SiteConfig.pm looks like.
(and possibly debug info if available)
-- Bart
Op 6 december 2011 13:15 schreef Arlon Sousa arlon.so...@ispm.com.br het
volgende:
After the configuration / opt/rt4/etc/RT_Siteconfig and /
opt/rt4/local/plugins/RT-Authen-ExternalAuth/etc/RT_Siteconfig he show me
this Feedback below.
** **
Set up where I can be wrong or WHAT?
** **
** **
%# BEGIN BPS TAGGED BLOCK {{{ %# %# COPYRIGHT: %# %# This software is
Copyright (c) 1996-2011 Best Practical Solutions, LLC %# %# %# (Except
where explicitly superseded by other copyright notices) %# %# %# LICENSE:
%# %# This work is made available to you under the terms of Version 2 of %#
the GNU General Public License. A copy of that license should have %# been
provided with this software, but in any event can be snarfed %# from
www.gnu.org. %# %# This work is distributed in the hope that it will be
useful, but %# WITHOUT ANY WARRANTY; without even the implied warranty of
%# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU %#
General Public License for more details. %# %# You should have received a
copy of the GNU General Public License %# along with this program; if not,
write to the Free Software %# Foundation, Inc., 51 Franklin Street, Fifth
Floor, Boston, MA %# 02110-1301 or visit their web page on the internet at
%# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html. %# %# %#
CONTRIBUTION SUBMISSION POLICY: %# %# (The following paragraph is not
intended to limit the rights granted %# to you to modify and distribute
this software under the terms of %# the GNU General Public License and is
only of importance to you if %# you choose to contribute your changes and
enhancements to the %# community by submitting them to Best Practical
Solutions, LLC.) %# %# By intentionally submitting any modifications,
corrections or %# derivatives to this work, or any other work intended for
use with %# Request Tracker, to Best Practical Solutions, LLC, you confirm
that %# you are the copyright holder for those contributions and you grant
%# Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable, %#
royalty-free, perpetual, license to use, copy, create derivative %# works
based on those contributions, and sublicense and distribute %# those
contributions and any derivatives thereof. %# %# END BPS TAGGED BLOCK }}}
%init my ($good, $msg) =
RT::Interface::Web::AttemptPasswordAuthentication(\%ARGS); $ARGS{'actions'}
= [$msg] if not $good and $msg; /Elements/Login, %ARGS
** **
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
[rt-users] Upgrade RT and AT and now can not create assets
I have a system that we upgraded from RT 3.6.7 to 3.8.8 back in Aug.
I did a fresh install of RT. Then restored the database. Then
one-by-one added back in any customizations, plugins, etc.
We where using Asset Tracker on our 3.6.7 install (so the data was
restored when the DB was restored). I have installed
rt-extension-assettracker-2.0.0b2-0-g2b51b9a.tar.gz
We can see, search, and even edit assets without any problem. The
(only?) problem comes when I try to create new assets. When I try to
create new assess, error shows in web browser:
Can't call method HasRight on an undefined value
at /usr/share/request-tracker3.8/lib/RT/User_Overlay.pm line 1357.
When I did the install of AT, I was able to do the first 3 steps no
problem:
$ RTHOME=/path/to/rt perl Makefile.PL
$ make
$ make install
When I would run 'make initdb' I would get an error:
Now populating database schema.
DBD::Pg::st execute failed: ERROR: relation at_types already exists
at /usr/share/request-tracker3.8/lib/RT/Handle.pm line 506. ...returned
with error: 65280 make: *** [initdb] Error 255
I have attached a segment of my syslog output. What is shown is Right
after hitting the 'submit' button when trying to create an asset.
Any help fixing this so we can create new assets again would be greatly
appreciated.
--
http://www.wikiak.org
#
Associate yourself with men of good quality if you esteem
your own reputation; for 'tis better to be alone then in bad
company.- George Washington, Rules of Civility
Dec 5 18:46:34 outrigger RT: DBD::Pg::st execute failed: ERROR: relation
at_scrips does not exist LINE 1: SELECT DISTINCT main.* FROM AT_Scrips main
JOIN ScripConditi... ^ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Dec 5 18:46:34 outrigger RT: RT::Handle=HASH(0xbbd13620) couldn't execute the
query 'SELECT DISTINCT main.* FROM AT_Scrips main JOIN ScripConditions
ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE
(main.AssetType = '9' OR main.AssetType = '0') AND
(ScripConditions_1.ApplicableTransTypes LIKE '%Create%' OR
ScripConditions_1.ApplicableTransTypes LIKE '%Any%') AND (main.Stage =
'TransactionCreate') ORDER BY main.Description ASC ' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xbbd13620)',
'SELECT DISTINCT main.* FROM AT_Scrips main JOIN ScripConditio...') called at
/usr/share/perl5/DBIx/SearchBuilder.pm line 236
^IDBIx::SearchBuilder::_DoSearch('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/request-tracker3.8/lib/RT/SearchBuilder.pm line 378
^IRT::SearchBuilder::_DoSearch('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/local/share/request-tracker
3.8/plugins/RTx-AssetTracker/lib/RTx/Asse
Dec 5 18:46:34 outrigger RT: DBD::Pg::st execute failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Dec 5 18:46:34 outrigger RT: RT::Handle=HASH(0xbbd13620) couldn't execute the
query 'SELECT COUNT(DISTINCT main.id) FROM AT_Scrips main JOIN ScripConditions
ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE
(main.AssetType = '9' OR main.AssetType = '0') AND
(ScripConditions_1.ApplicableTransTypes LIKE '%Create%' OR
ScripConditions_1.ApplicableTransTypes LIKE '%Any%') AND (main.Stage =
'TransactionCreate') ' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line
522 ^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xbbd13620)',
'SELECT COUNT(DISTINCT main.id) FROM AT_Scrips main JOIN Scrip...') called at
/usr/share/perl5/DBIx/SearchBuilder.pm line 292
^IDBIx::SearchBuilder::_DoCount('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/request-tracker3.8/lib/RT/SearchBuilder.pm line 389
^IRT::SearchBuilder::_DoCount('RTx::AssetTracker::Scrips=HASH(0xbbe24a80)')
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 1392 ^IDBIx::
SearchBuilder::Count('RTx::AssetTracker::
Dec 5 18:46:34 outrigger RT: DBD::Pg::st execute failed: ERROR: current
transaction is aborted, commands ignored until end of transaction block at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509)
Dec 5 18:46:34 outrigger RT: RT::Handle=HASH(0xbbd13620) couldn't execute the
query 'SELECT DISTINCT main.* FROM AT_Scrips main JOIN ScripConditions
ScripConditions_1 ON ( ScripConditions_1.id = main.ScripCondition ) WHERE
(main.AssetType = '9' OR main.AssetType = '0') AND
(ScripConditions_1.ApplicableTransTypes LIKE '%Create%' OR
ScripConditions_1.ApplicableTransTypes LIKE '%Any%') AND (main.Stage =
'TransactionCreate') ORDER BY
Re: [rt-users] Encoding of subject line in outgoing messages
On 12/06/2011 03:17 AM, Stéphane Brot wrote: If I create a ticketin the web interface with french special characters like é àin the subject, the subject line of the outgoing mail for the requestorisnot OK. Here is the mail header : Subject: =?us-ascii?Q?=3D=3FUTF-8=3FB=3FW3NlZmFuZXQgIzE2XSBBdXRvUmVwbH?= =?us-ascii?Q?k6IENyw6nDqSBkYW5zIFJUIGF2ZWM=3D=3F=3D?= Seems tobe utf-8 surrounded by us-ascii !? This is a correct encoding of Subject lines according to mail standards. Is it actually causing problems in your mail client? Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Encoding of subject line in outgoing messages
On 12/06/2011 09:56 AM, Thomas Sibley wrote: On 12/06/2011 03:17 AM, Stéphane Brot wrote: If I create a ticketin the web interface with french special characters like é àin the subject, the subject line of the outgoing mail for the requestorisnot OK. Here is the mail header : Subject: =?us-ascii?Q?=3D=3FUTF-8=3FB=3FW3NlZmFuZXQgIzE2XSBBdXRvUmVwbH?= =?us-ascii?Q?k6IENyw6nDqSBkYW5zIFJUIGF2ZWM=3D=3F=3D?= Seems tobe utf-8 surrounded by us-ascii !? This is a correct encoding of Subject lines according to mail standards. Is it actually causing problems in your mail client? Actually, it is a little weird since it's doubly MIME header encoded (as I just noticed). You've said it appears to be mailx, so I'll clam up now. ;) Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RES: Encoding of subject line in outgoing messages
You've configured ExternalAuth wrong. Please don't send mail directly to me. Send mail to the list. On 12/06/2011 10:51 AM, Arlon Sousa wrote: Now show me this feedback. I installed all the modules required install_driver(DBI_DRIVER) failed: Can't locate DBD/DBI_DRIVER.pm in @INC (@INC contains: /opt/rt4/sbin/../local/lib /opt/rt4/local/plugins/RT-Extension-SLA/lib /opt/rt4/local/plugins/RT-Extension-HistoryFilter/lib /opt/rt4/local/plugins/RT-Extension-ResetPassword/lib /opt/rt4/local/plugins/RT-Extension-MergeUsers/lib /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib /opt/rt4/sbin/../lib /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 . /etc/httpd) at (eval 231) line 3. Stack: [(eval 231):3] [/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBI.pm:646] [/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:446] [/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/D BI.pm:218] [/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:356] [/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:106] [/opt/rt4/local/plugins/RT-Authen-ExternalAuth/html/Elements/DoAuth:10] [/opt/rt4/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Session:2] [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:236] [/opt/rt4/share/html/autohandler:53] Perhaps the DBD::DBI_DRIVER perl module hasn't been fully installed, or perhaps the capitalisation of 'DBI_DRIVER' isn't right. Available drivers: DBM, ExampleP, File, Gofer, LDAP, Pg, Proxy, Sponge, mysql. at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 446 Arlon Sousa +55 21 2494 9110 / +55 21 3172 9673 / +55 21 7801-9264 arlon.so...@ispm.com.br Avenida das Américas, 700 | Bloco 3| cj.218 Barra da Tijuca | 22640-100 Rio de Janeiro/RJ | Brasil www.ispm.com.br “Esta mensagem, incluindo seus anexos, pode conter informações privilegiadas e/ou de caráter confidencial, não podendo ser retransmitida sem autorização do remetente. Se você não é o destinatário ou pessoa autorizada a recebê-la, por favor, nos informe respondendo imediatamente a este e-mail e em seguida apague-a. Obrigado. ISPM” RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Superscript?
I didn't get any responses but I stumbled upon the CKEditor config file in /opt/rt4/share/html/NoAuth/RichText/ckeditor/config.js: I added Subscript and Superscript to the config.toolbar_Full section: config.toolbar_Full = [ ['Cut','Copy','Paste','PasteText','PasteFromWord','Subscript','Superscript'], ['Undo','Redo','-','-','SelectAll','RemoveFormat'], ['Table','HorizontalRule','SpecialChar'], '/', ['Bold','Italic','Underline','Strike'], ['NumberedList','BulletedList','-','Outdent','Indent'], ['JustifyLeft','JustifyCenter','JustifyRight','JustifyBlock'], '/', ['Format','Font','FontSize'], ['TextColor'], ['Link'] ]; Hope this helps someone in the future. http://xkcd.com/979/ -Patrick From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Patrick Fish Sent: Thursday, December 01, 2011 1:23 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Superscript? Hello, Is it possible to enable superscript in the RT WYSIWYG (CKEditor?) editor? Thanks, Patrick RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Looping through transactionobj
I have a scrip that checks to see if the value of certain customfield value has
changed. If so, it sets the value of a different custom field.
I want to expand it to check if the value of another customfield has changed
and if so, set the value of a 4th custom field.
So:
If CF1 changed, set CF2 to hi
and/or
If CF3 changed, set CF4 to bye
The scrip works fine if either CF1 or CF3 is changed, but if BOTH are changed,
it's only setting CF4.
I suspect I'm only catching the highest CF ID number - the last in the set. I
have some other CF's on the ticket that have ID's higher than CF1, but lower
than CF3 (just the way they got added into the system) and the same thing
happens if I change the value of one of them and CF1 - CF2 doesn't get changed,
but CF3/CF4 works.
How do I loop through the TransactionObj to make sure I pick up all the
changes? I can sort out the non-CF1/3 changes with an IF, but I can't figure
out how to get my while statement right...
I've tried this:
my $trans = $self-TransactionObj;
while (my $customtrans = $trans-Next){ ... }
and
while (my $customtrans = $trans-Next()){ ... }
But I get:
RT: Scrip 27 Prepare failed: RT::Transaction::Next Unimplemented in
RT::Action::UserDefined.
I've tried:
my $cffields = $self-TransactionObj -CustomField;
Got:
RT: Scrip 27 Prepare failed: RT::Transaction::CustomField Unimplemented in
RT::Action::UserDefined.
Tried:
my $cffields = $trans-Field;
while (my $customtrans = $ cffields -Next()){ ... }
Got:
Scrip 27 Prepare failed: Can't call method Next without a package or object
reference at (eval 3099) line 24
Thanks,
Brent
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 6, 2012
