[rt-users] Search tickets which refers to an asset? (RT 4.4.1)
Hi all, I'm wondering if there's a possibility to search all tickets refering to one or more assets. A ticket search string like RefersTo = 'a:%' does not work. Any ideas? Best regards Daniel smime.p7s Description: S/MIME cryptographic signature - RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017
Re: [rt-users] Can't login to RT using Active Directory
Hi,
> I'm 100% sure i am using the correct password, i even tried other test
> accounts i have and know they can authenticate against AD just fine.
try ldapsearch to connect to your AD like
ldapsearch -x -H ldap://192.168.100.5:389 -D MYUSER -w MYPASS -b
"dc=yourdomain,dc=com" "cn=Administrator"
Best regards
Daniel
> -Original Message-
> From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of
> fleon
> Sent: Wednesday, September 14, 2016 4:25 PM
> To: rt-users@lists.bestpractical.com
> Subject: [rt-users] Can't login to RT using Active Directory
>
> I have been able to use Active Directory as authentication with the
> ExternalAuth plugin, both before and after it was integrated in RT 4.4.
>
> But today it isn't allowing anyone in, and this is shown in the error logs:
>
> [8629] [Wed Sep 14 15:28:49 2016] [error]: FAILED LOGIN for fleon from
> 192.168.3.57 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:826)
> [8629] [Wed Sep 14 15:29:31 2016] [critical]:
> RT::Authen::ExternalAuth::LDAP::_GetBoundLdapObj Can't bind:
> LDAP_INVALID_CREDENTIALS 49
> (/opt/rt4/sbin/../lib/RT/Authen/ExternalAuth/LDAP.pm:678)
>
> I'm 100% sure i am using the correct password, i even tried other test
> accounts i have and know they can authenticate against AD just fine.
>
> I am also sure nothing has changed on AD itself or in RT's configuration,
> however this is my current ExternalAuth configuration:
> Set($ExternalAuth, 1);
> Set($ExternalAuthPriority, [ 'My_LDAP']);
> Set($ExternalInfoPriority, [ 'My_LDAP']);
> Set($ExternalServiceUsesSSLorTLS,0);
> Set($AutoCreateNonExternalUsers,1);
> Set($UserAutocreateDefaultsOnLogin, {Privileged => 0 });
>
> Set($ExternalSettings,
> {
> 'My_LDAP' => {
> 'type' => 'ldap',
> 'server'=> '192.168.100.5',
> 'user' => 'MYUSER',
> 'pass'=> 'MYPASS',
> 'base' => 'dc=mycompany,dc=com',
> 'filter'=> '(objectClass=person)',
> 'd_filter' => '(objectClass=FooBarBaz)',
> 'tls' => 0,
> 'ssl_version' => 3,
> 'net_ldap_args' => [version => 3 ],
> 'attr_match_list' => ['Name',
> 'EmailAddress'
> ],
> 'attr_map' => { 'Name' => 'sAMAccountName',
> 'EmailAddress' => 'mail',
> 'Organization' => 'physicalDeliveryOfficeName',
> 'RealName' => 'displayName',
> 'Gecos' => 'sAMAccountName',
> 'WorkPhone' => 'telephoneNumber',
> 'Address1' => 'description',
> 'City' => 'l',
> 'State' => 'st',
>'Zip' => 'postalCode',
>'Country' => 'co'
>}
>}
> }
> );
>
> I am using debian 8 jessie with RT 4.4.1. Thanks
>
>
>
>
>
>
>
>
> --
> View this message in context:
> http://requesttracker.8502.n7.nabble.com/Can-t-login-to-RT-using-Active-
> Directory-tp62539.html
> Sent from the Request Tracker - User mailing list archive at Nabble.com.
> -
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Boston - October 24-26
> * Los Angeles - Q1 2017
smime.p7s
Description: S/MIME cryptographic signature
-
RT 4.4 and RTIR training sessions, and a new workshop day!
https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017
Re: [rt-users] Hide "Bulk Update" from menu
Hi Matt, thanks for your help. In the previous E-Mail (the enter-key was faster than me!) you found my implementation of hiding the "Bulk Update" menu dependent of the membership. Best regards Danny smime.p7s Description: S/MIME cryptographic signature
[rt-users] Hide "Bulk Update" from menu
Hi everybody, is there a possibility to hide the "Bulk Update" menu from every privileged user who is not member of a "Bulk-Update"-Group? I cannot find a corresponding Callback in share/html/Elements/Tabs nor ./share/html/Search/Results.html to change the menu hiding "Bulk Update". Thanks for any hint helping me to implement this small feature. Best regards Danny smime.p7s Description: S/MIME cryptographic signature
[rt-users] Tooltips for customfields?
Hi, did somebody implements a RT customization to show tooltips related to custom fields? The tooltip could be the description of the custom field. I'm don't know how to implement this feature... Some hints? Best regards Danny smime.p7s Description: S/MIME cryptographic signature
[rt-users] "rt-fulltext-indexer is already running" problem on solaris (flock)
Hi everybody,
we setup a new rt 4.2.12 system and tried to follow the instructions for
the native mysql full text search [1], but I failed always with the following
command:
/opt/rt4/sbin/rt-fulltext-indexer
/opt/rt4/sbin/rt-fulltext-indexer is already running; aborting
silently, as requested (/opt/rt4/sbin/rt-fulltext-indexer:93)
The code [2] does not work for our solaris [3]. It's because perl@solaris
handle 'flock' in an unusual way [5] (you can ask google...)
So, after unsuccessfully trying to fix solaris/perl,
we patched rt-fulltext-indexer [4]. Now the fulltext search works fine.
Maybe somebody will help this information in the future.
best regards
Danny
[1]
https://www.bestpractical.com/docs/rt/4.2.12/full_text_indexing.html#Native-MySQL
[2] rt-fulltext-indexer:91
if ( !flock main::DATA, LOCK_EX | LOCK_NB ) {
[3] SunOS z-rt4app-a 5.11 11.2 sun4v sparc sun4v
[4] patch
root@z-rt4app-a: # diff rt-fulltext-indexer.org.20151202
rt-fulltext-indexer
91c91,93
< if ( !flock main::DATA, LOCK_EX | LOCK_NB ) {
---
> open SELF, "+> /tmp/rt-fulltext-indexer.lock" or die ;
> unless (flock SELF, LOCK_EX | LOCK_NB) {
> #if ( !flock main::DATA, LOCK_EX | LOCK_NB ) {
[5] http://www.perlmonks.org/bare/?node_id=256020
http://www.nntp.perl.org/group/perl.perl5.porters/2006/01/msg108851.html
best regards
Danny
smime.p7s
Description: S/MIME cryptographic signature
Re: [rt-users] Trouble/Error with Web deployment httpd/apache/mod_fcgid
Please check this Link: Perl Modules installed in the wrong place https://www.centos.org/forums/viewtopic.php?f=48=49865 Maybe it's your issue .. regards Danny > -Original Message- > From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of > Daniel Schwager > Sent: Monday, November 23, 2015 7:32 PM > To: 'dwdixon'; 'rt-users@lists.bestpractical.com' > Subject: Re: [rt-users] Trouble/Error with Web deployment > httpd/apache/mod_fcgid > > > It appears mine is located here: > > > > > > /root/perl5/lib/perl5/UNIVERSAL > > /root/perl5/lib/perl5/UNIVERSAL/require.pm > > > Hmm - root's home it's not a common location for perl modules (-: > > This is the problem - try to reinstall the UNIVERSAL > > perl -MCPAN -e 'install "UNIVERSAL"' > > regards > Danny smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] Trouble/Error with Web deployment httpd/apache/mod_fcgid
> It appears mine is located here: > > > /root/perl5/lib/perl5/UNIVERSAL > /root/perl5/lib/perl5/UNIVERSAL/require.pm > Hmm - root's home it's not a common location for perl modules (-: This is the problem - try to reinstall the UNIVERSAL perl -MCPAN -e 'install "UNIVERSAL"' regards Danny smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] Trouble/Error with Web deployment httpd/apache/mod_fcgid
Hi, maybe you will try to use a separate perl installation? https://www.bestpractical.com/docs/rt/4.2.12/rt_perl.html # http://www.cpan.org/src/README.html mkdir -p /opt/perl-5.18.4/src cd /opt/perl-5.18.4/src wget http://www.cpan.org/src/5.0/perl-5.18.4.tar.bz2 tar -xjf perl-5.18.4.tar.bz2 cd perl-5.18.4 CFLAGS='-m64 -mtune=nocona' ./Configure -Dprefix=/opt/perl-5.18.4 -Dusethreads -des -Accflags=-fPIC make -j8 install ln -sf /opt/perl-5.18.4/ /opt/perl emacs -nw /etc/profile # perl PATH=/opt/perl/bin:$PATH export PATH # Vereinfachungen # Installieren von perl modulen OHNE dauerndes "yes" ... # http://stackoverflow.com/questions/898782/how-do-i-tell-cpan-to-install-all-dependencies # z.B. durch PERL_MM_USE_DEFAULT=1 perl -MCPAN -e 'install XML::LibXML' # oder cpanm: curl -L http://cpanmin.us | /opt/perl/bin/perl - --sudo App::cpanminus export RT_FIX_DEPS_CMD=/opt/perl/bin/cpanm ... go on with the RT installation. best regards Danny P.S.: mod_perl could be a problem - maybe you should use fastcgi instead. > -Original Message- > From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of > dwdixon > Sent: Monday, November 23, 2015 5:07 PM > To: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] Trouble/Error with Web deployment > httpd/apache/mod_fcgid > > Hi GeraldI can confirm I am also running this on CentOS 7maybe that > was a mistake or maybe someone can help us out with getting this > resolved...I certainly hope the latter is the case! Thanks in advance to > anyone who can help us out here... > > > > -- > View this message in context: > http://requesttracker.8502.n7.nabble.com/Trouble-Error-with-Web- > deployment-httpd-apache-mod-fcgid-tp60979p60981.html > Sent from the Request Tracker - User mailing list archive at Nabble.com. smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] Trouble/Error with Web deployment httpd/apache/mod_fcgid
> I should also add I'm not a perl expert either, but from what I understand I > am using fastcgi am I not? I don't know how you connect your apache httpd to rt (-; If you use fastcgi, there's no need for mod_perl. > This all seems a lot more complex than I was > hoping, I greatly appreciate the suggestions and help but I don't know that > I want use a totally separate perl installation unless absolutely > necessary... I think, a separate perl installation dedicated(!) for RT is the best way to install RT. Why? Because the RT installer bypass the rpm package system installing some other perl modules. This could bother you later ... > > What made you suggest that mod_perl is the problem and how can I test that > out? Did you execute make testdeps in your rt installation directory? Is it clean? Danny smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] Trouble/Error with Web deployment httpd/apache/mod_fcgid
> According to the testdeps output it's saying I only need Perl >= 5.10.1, but > I also wanted to add that all the dependencies are report as found: > > *** > perl: > *>=5.10.1(5.16.3) ...found* > > ..SNIP > > *UNIVERSAL::require ...found* > > *All dependencies have been found.* > ** OK - could you check (find) where the "UNIVERSAL/require.pm" is inside your perl tree? E.g. (from my system - seprate perl installation) ./lib/perl5/site_perl/5.20.3/UNIVERSAL ./lib/perl5/site_perl/5.20.3/UNIVERSAL/require.pm Should be (or not ;-) somewhere in the pathes below: Can't locate UNIVERSAL/require.pm in @INC (@INC contains: /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.pm line 60. BEGIN failed--compilation aborted at /opt/rt4/sbin/../lib/RT.pm line 60. Compilation failed in require at /opt/rt4/sbin/rt-server.fcgi line 86. regards Danny smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] Trouble/Error with Web deployment httpd/apache/mod_fcgid
> Perl::Build might simplify some of these steps - > https://metacpan.org/pod/Perl::Build Cool! - didn't know this way.. Thx Danny smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] What's huge RT/Mysql
Hi JAS, > For normal usage it works fast. The number of tickets is only a problem for > searching. Here we still use sphinx and searching is quite slow. .. > Going to try mysql builtin fulltext next (that won't fix session problem but > has potential to be faster). Currently, we are going to setup a system with sphinx & mysql 5.6 because of the sphinx-fulltext search feature. So, do you think mysql-5.7 with enabled mysql-fulltext feature is faster? Can RT use the builtin mysql fulltext search by default without any changes? Best regards Danny smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] Prevent users from making Comments on tickets
Hi, You might be able to swap out ModifyTicket and use some finer-grained rights in its place, depending on what modifications end users actually need to make. what are the equivalent (separate) rights for ModifyTicket? regards Danny From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Peters Sent: Friday, February 13, 2015 1:11 AM To: Cena, Stephen (ext. 300) Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Prevent users from making Comments on tickets I believe that a user will unconditionally have commenting ability if they also have the ModifyTicket right, regardless of the state of their CommentOnTicket right. You might be able to swap out ModifyTicket and use some finer-grained rights in its place, depending on what modifications end users actually need to make. On 13 February 2015 at 04:06, Cena, Stephen (ext. 300) s...@qvii.commailto:s...@qvii.com wrote: I'm in the process of locking down end-user permissions in our RT install. We want it set up so that users can only do Reply, and Admins can use Comment and Reply. At present, my end user can't see a Comment in a ticket, or an attachment made with a Comment. However, if the user emails the Comment address or uses the Comment in the Action drop-down in the ticket the entry gets made. The proper visibility of the resulting Comment is correct. AFAIK, there are no global permissions for anything (I'm doing it al at the queue level for each queue). smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] Help in debugging
Hi, we have the same problem here - lot's of plugins and scripts - and some eval-message like Jan 26 10:49:10 artee3 RT4: [23122] Use of uninitialized value in string eq at (eval 3414) line 23. Jan 26 10:49:11 artee3 RT4: [23122] Use of uninitialized value in string eq at (eval 3487) line 23. Jan 28 04:12:46 artee3 RT4: [24654] Use of uninitialized value in concatenation (.) or string at template line 32. Jan 28 04:13:55 artee3 RT4: [24654] Use of uninitialized value in string eq at (eval 2005) line 23. ... and I don't know how to find out who produces these problems ... Any hints for debugging? regards Danny From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Guadagnino Cristiano Sent: Wednesday, January 28, 2015 11:09 AM To: Alex Peters Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Help in debugging Thank you Alex. At last, I found the culprit via brute force (i.e. I examined all my scrips). Cris Da: Alex Peters a...@peters.netmailto:a...@peters.net Inviato: Tue Jan 27 2015 20:46:22 GMT+0100 (CET) A: Guadagnino Cristiano guadagnino.cristi...@creval.itmailto:guadagnino.cristi...@creval.it Cc: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com Oggetto: Re: [rt-users] Help in debugging I'd probably try to discover more by enabling debug logging first. I think in my case, eval-related things are usually to do with scrips or templates. I don't think any of mine are 829 lines long though, as your warning suggests. On 28 Jan 2015 2:47 am, Guadagnino Cristiano guadagnino.cristi...@creval.itmailto:guadagnino.cristi...@creval.it wrote: Hi all, if I have a row like this in the log: [26226] [Tue Jan 27 15:20:19 2015] [warning]: Use of uninitialized value in string eq at (eval 829) line 1. ((eval 829):1) how do I know which is the object involved? Thank you in advance. Cris smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] CurrentUserEmail in search - better way instead copying Tickets_Local.pm
Hi Kevin, Does Requestor = '__CurrentUser__' not work? Oh - yes, this works!! I didn't know about this Requestor keyword. Great! Thank! I tried to just copy _parser() method - but perl cannot find variables from the base class Tickets.pm like FIELD_METADATA or %dispatch .. I suspect you failed to add package RT::Tickets; to the top of your Tickets_Local.pm (those variables are marked our so should be fine to use). I added package RT::Tickets - but doesn't matter. I will use your suggested solution! Thanks Danny smime.p7s Description: S/MIME cryptographic signature
[rt-users] CurrentUserEmail in search - better way instead copying Tickets_Local.pm
Hi, I would like to create a search finding all my requested tickets without using my hard-coded email-adr. Therefore, I overlayed Tickets.pm with Tickets_Local.pm, removing the use ... and adding one line of code like described in http://requesttracker.wikia.com/wiki/CurrentUserEmail. /opt/rt4/local/lib/RT/Tickets_Local.pm:2978 + $value = $self-CurrentUser-EmailAddress if $value eq '__CurrentUserEmail__'; Now, it's possible execute a search-query like Requestor.EmailAddress = '__CurrentUserEmail__' AND Status = 'open' Question: Is there a way not to copy the whole Tickets.pm but just the relevant code snippet using callbacks/overaying/ I tried to just copy _parser() method - but perl cannot find variables from the base class Tickets.pm like FIELD_METADATA or %dispatch .. Is there a smoother way to implement this feature? regards Danny smime.p7s Description: S/MIME cryptographic signature
[rt-users] Grant right to a special CF dependet on a specific queue ?
Hi, in short: Is it possible to grant SeeCustomField-rights for one CF dependent on a queue ? Long: We have some (external, customer) privileged users working with their queue. Also, we have a ticket CF named Summary. In their queue, the users are able to see/modify this CF. Beside of this, our privileged user can also create tickets in other internal queues. I grant them the ShowTicket-right. Fine. But they have also access/see the Summary-CF from tickets located in our internal queue - this is not fine. Is it possible (for CF Summary) to - grant SeeCustomField-right to our privileged users concerning tickets located in their queue but - not grant SeeCustomField-right to tickets located in other queues? regards Danny smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] RT-Extension-RepeatTicket - find all tickets with Recurrence enabled?
Hi all,
Is there a way to create a search-query to find all the enabled recurring
tickets?
after investigating the original rt-repeat-ticket perl script, I developed my
own list implementation (1).
best regards
Danny
(1) rt-repeat-ticket
#!/opt/perl-5.18.4/bin/perl
use strict;
use warnings;
BEGIN {
use lib qw(/opt/rt4/local/lib /opt/rt4/lib);
use RT;
RT::LoadConfig;
RT::Init;
}
use RT::Attributes;
use RT::Ticket;
use RT::User;
__PACKAGE__-run(@ARGV) unless caller;
sub run{
my $attrs = RT::Attributes-new( RT-SystemUser );
$attrs-Limit( FIELD = 'Name', VALUE = 'RepeatTicketSettings' );
my $ticket = RT::Ticket-new( RT-SystemUser );
while ( my $attr = $attrs-Next ) {
next unless $attr-Content-{'repeat-enabled'};
next unless $attr-Content-{'repeat-type'};
next unless $attr-ObjectType eq RT::Ticket;
if (!defined $ticket-Load($attr-ObjectId)) {
$RT::Logger-error(Can't load ticket . $attr-ObjectId);
next;
}
print '#' . $attr-ObjectId . ' ' . $ticket-Subject
. ' (' . $ticket-OwnerObj-FriendlyName . '): '
. $attr-Content-{'repeat-type'} . \n;
}
return;
}
1;
__END__
smime.p7s
Description: S/MIME cryptographic signature
[rt-users] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed.
Hi, Just a small not for other admins: If you lock a ticket with RT-Extension-TicketLocking-0.12, the lock show like (1) for other users. You can fix this by copy ShowLock to your local area mkdir -p /opt/rt4/local/html/Elements cp -local/plugins/RT-Extension-TicketLocking/html/Elements/ShowLock /opt/rt4/local/html/Elements and change it like /opt/rt4/local/html/Elements/ShowLock:45 - |/l, $TicketLabel, $u_str, $ago [_1] has been locked by [_2] for [_3]/. + %$TicketLabel% has been locked by %$u_str |n% for %$ago%. regards Danny (1) Lock for other users [cid:image001.png@01D0331E.A2BFD220] smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed.
Hi Alex, thanks for this fix. Works fine now. regards Danny -Original Message- From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Alex Vandiver Sent: Tuesday, January 20, 2015 2:30 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 18 Jan 2015 12:07:42 + Daniel Schwager daniel.schwa...@dtnet.de wrote: Just a small not for other admins: If you lock a ticket with RT-Extension-TicketLocking-0.12, the lock show like (1) for other users. I've released version 1.00 of RT::Extension::TicketLocking which addresses this. - Alex -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (GNU/Linux) iEYEARECAAYFAlS9r6QACgkQMflWJZZAbqCz/ACeLtj/pcI4zeumYrYu9ZRCS1w6 k4QAoLISsFabVLTHIru9D2v2hBpqKh8O =+OpU -END PGP SIGNATURE- smime.p7s Description: S/MIME cryptographic signature
[rt-users] Modify.html - custom fields in 2 or 3 columns? (EditCustomFieldsSingleColumn)
Hi, we have many custom fields. Is it possible inside Modify.html to have more than one CF per row? In RT 4.2.6 html/Ticket/Modify.html shows all custom fields (grouped or not grouped) below each other. Is there a way to have not only one custom field in each row but maybe 2 or 3 ? I walk through the code - if I make the change (2), 2 columns appears in the Modify.html page. Is there may be a better way? I think my hack is not a good solutiion. The config setting EditCustomFieldsSingleColumn has no effect in Modify.html? Tried to set it to 0,1,2 and 'undef'. regards Danny (1) html/Elements/EditCustomFields:104 (RT 4.2.6) - adding $AsTable=0; (Called from html/Ticket/Modify.html) $CustomFields-GotoFirstItem; + $AsTable=0; $AsTable ||= $InTable; my $FIELD = $AsTable ? 'tr' : 'div'; my $CELL = $AsTable ? 'td' : 'div'; smime.p7s Description: S/MIME cryptographic signature
[rt-users] RT-Extension-RepeatTicket - find all tickets with Recurrence enabled?
Hi,
we installed the RT-Extension-RepeatTicket (1) which create recurring tickets -
looks fine (-:
Is there a way to create a search-query to find all the enabled recurring
tickets?
The docu (2) said only
To help you find this initial ticket, which may have been resolved long
ago, a custom field is created on each ticket
in the recurrence with link called Original Ticket.
In the code (3), I found an object
$ticket-Attributes-Named('RepeatTicketSettings');
which has a member
$args{'repeat-enabled'}
telling me about the state.
I'm interesting in all enabled recurring tickets which will be able to create
new childs by running bin/rt-repeat-ticket.
Is there a query or a 5-line-perl-code showing me this information
regards
Danny
(1) http://search.cpan.org/~alexmv/RT-Extension-RepeatTicket-1.00/
(2) http://cpansearch.perl.org/src/ALEXMV/RT-Extension-RepeatTicket-1.00/README
(3)
http://cpansearch.perl.org/src/ALEXMV/RT-Extension-RepeatTicket-1.00/lib/RT/Extension/RepeatTicket.pm
smime.p7s
Description: S/MIME cryptographic signature
[rt-users] Adding (by default) custom field to the simple search
Hi,
I updated to 4.2.6 (from 3.8.8) in our lab - look fine. Now, I'm going to add
some small customizations.
E.g. the simple Search (the search field in the web-ui on the top right) should
also search for a custom field.
Therefore, I added an overlay /opt/rt4/local/lib/RT/Search/Simple_Local.pm with
the content (1) - but it does not work.
It the file is parsed from RT, but the methods are not be called.
Is there something I missed ?
regards
Danny
(1) /opt/rt4/local/lib/RT/Search/Simple_Local.pm
# $_[0] is $self
# $_[1] is escaped value without surrounding single quotes
# $_[2] is a boolean of was quoted by the user?
# ensure this is false before you do smart matching like $_[1] eq me
# $_[3] is escaped subkey, if any (see HandleCf)
sub HandleDefault {
$RT::Logger-debug(dts-HandleDefault);
my $fts = RT-Config-Get('FullTextSearch');
if ($fts-{Enable} and $fts-{Indexed}) {
return default = (Subject LIKE '$_[1]' OR Content LIKE '$_[1]' OR
'CF.{CF-Customer}' LIKE '$_[1]');
} else {
return default = (Subject LIKE '$_[1]' OR 'CF.{CF-Customer}' LIKE
'$_[1]' );
}
}
sub HandleSubject {
$RT::Logger-debug(dts-HandleSubject);
return subject = (Subject LIKE '$_[1]' OR 'CF.{CF-Customer}' LIKE
'$_[1]');
}
1;
smime.p7s
Description: S/MIME cryptographic signature
Re: [rt-users] Adding (by default) custom field to the simple search
Chris, thank you very much! Now, it work's like a charm! Best regards Danny -Original Message- From: Christian Loos [mailto:cl...@netcologne.de] Sent: Thursday, January 15, 2015 4:32 PM To: Daniel Schwager; 'rt-users@lists.bestpractical.com' Subject: Re: Adding (by default) custom field to the simple search Hi, add on top of the file this lines: package RT::Search::Simple; use strict; use warnings; no warnings 'redefine'; smime.p7s Description: S/MIME cryptographic signature
Re: [rt-users] rt3.8.17 / 4.2.6 / nginx and document-root '/rt'
Hi all,
thanks for this information - there's the fix - important
lines are location and rewrite - see (1).
I updated to rt 4.2.6 - now, the combination of rt / nginx / fastcgi /
document-root '/rt' does not work again.
My goal is to map a RT with nginx to a URL like http://www.domain.de:8080/rt;
(instead of http://www.domain.de:8080;)
Tonight, I played around and found the following working setup:
/etc/nginx/conf.d/rt4.conf
server {
listen 8080;
server_name host.domain.de;
root /tmp;
# /opt/rt4/etc/RT_SiteConfig.pm
# Set($WebDomain, host.domain.de);
# Set($WebPort , 8080);
# Set($WebPath , /rt);
# Set(@ReferrerWhitelist, qw(extranet.domain.de:443 host.domain.de:8080
));
#
#
#
location / {
### original /etc/nginx/fastcgi_params - debian 7.x
# include /etc/nginx/fastcgi_params;
fastcgi_param QUERY_STRING$query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE$content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SCRIPT_FILENAME $request_filename;
fastcgi_param SCRIPT_NAME $fastcgi_script_name;
fastcgi_param REQUEST_URI $request_uri;
fastcgi_param DOCUMENT_URI$document_uri;
fastcgi_param DOCUMENT_ROOT $document_root;
fastcgi_param SERVER_PROTOCOL $server_protocol;
fastcgi_param GATEWAY_INTERFACE CGI/1.1;
fastcgi_param SERVER_SOFTWARE nginx/$nginx_version;
fastcgi_param REMOTE_ADDR $remote_addr;
fastcgi_param REMOTE_PORT $remote_port;
fastcgi_param SERVER_ADDR $server_addr;
fastcgi_param SERVER_PORT $server_port;
fastcgi_param SERVER_NAME $server_name;
fastcgi_param HTTPS $https;
# PHP only, required if PHP was built with
--enable-force-cgi-redirect
fastcgi_param REDIRECT_STATUS 200;
### /original /etc/nginx/fastcgi_params
fastcgi_pass unix:/opt/rt4/var/fastcgi.sock;
fastcgi_param SCRIPT_NAME /rt;
fastcgi_param PATH_INFO $uri;
}
}
rt-server.fcgi was called like this:
/opt/rt4/sbin/rt-server.fcgi --pidfile=/opt/rt4/var/fastcgi.pid
--socket=/opt/rt4/var/fastcgi.sock 2 /dev/null
Maybe, I can help other admins in the future not to spend that much time
[rt-users] rt3.8.17 / nginx and document-root
Hi,
because nginx ist about 20-30% faster than apache2, we tries to move to nginx.
Our URL is http://server-url/rt
so WebPath insode RT_SiteConfig.pm is set to /rt.
Our current nginx config (1) works fine (but only in the document root
http://server-url, but not with http://server-url/rt)
I'm not familiar with nginx and spent now about 4 hours trying to configure
rt3+nginx to use http://server-url/rt as the base-url - but I was not able to
manage it.
Maybe somebody show me how to configure RT/ngnix for a non-root URL ?
regards
Danny
(1) /etc/nginx/conf.d/rt3.conf
server {
listen 80;
server_name artee2.domain.de;
root /opt/rt3/share/html;
index index.html index.htm;
location / {
fastcgi_pass unix:/opt/rt3/var/fastcgi.sock;
include/etc/nginx/fastcgi_params;
fastcgi_param QUERY_STRING $query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SCRIPT_NAME ;
fastcgi_param PATH_INFO $uri;
}
}
Viele Gruesse
Daniel Schwager
---
DT Netsolution GmbH - Taläckerstr. 30-D-70437 Stuttgart
Geschäftsführer: Daniel Schwager, Stefan Hörz - HRB Stuttgart 19870
Tel: +49-711-849910-32, Fax: -932 - Mailto:daniel.schwa...@dtnet.de
smime.p7s
Description: S/MIME cryptographic signature
Re: [rt-users] rt3.8.17 / nginx and document-root
Hi Torsten,
thanks for this information - there's the fix - important
lines are location and rewrite - see (1).
Works now like a charme (-:
Thx
Danny
(1) nginx / non-root configuration (http://artee2.domain.de/rt)
server {
listen 80;
server_name artee2.domain.de;
root /tmp;
location ^~ /rt/ {
fastcgi_pass unix:/opt/rt3/var/fastcgi.sock;
rewrite ^/rt(/.*)$ $1 break;
include /etc/nginx/fastcgi_params;
fastcgi_param QUERY_STRING $query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SCRIPT_NAME ;
fastcgi_param PATH_INFO $uri;
}
}
-Original Message-
From: Torsten Brumm [mailto:tbr...@mac.com]
Sent: Wednesday, December 24, 2014 5:22 PM
To: Daniel Schwager
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] rt3.8.17 / nginx and document-root
Search github for rt-extension-nginx as good starting point.
Von meinem iPhone gesendet
Am 24.12.2014 um 14:21 schrieb Daniel Schwager daniel.schwa...@dtnet.de:
Hi,
because nginx ist about 20-30% faster than apache2, we tries to move to
nginx. Our URL is http://server-
url/rt
so WebPath insode RT_SiteConfig.pm is set to /rt.
Our current nginx config (1) works fine (but only in the document root
http://server-url, but not with
http://server-url/rt)
I'm not familiar with nginx and spent now about 4 hours trying to configure
rt3+nginx to use http://server-
url/rt as the base-url - but I was not able to manage it.
Maybe somebody show me how to configure RT/ngnix for a non-root URL ?
regards
Danny
(1) /etc/nginx/conf.d/rt3.conf
server {
listen 80;
server_name artee2.domain.de;
root /opt/rt3/share/html;
index index.html index.htm;
location / {
fastcgi_pass unix:/opt/rt3/var/fastcgi.sock;
include/etc/nginx/fastcgi_params;
fastcgi_param QUERY_STRING $query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SCRIPT_NAME ;
fastcgi_param PATH_INFO $uri;
}
}
Viele Gruesse
Daniel Schwager
---
DT Netsolution GmbH - Taläckerstr. 30-D-70437 Stuttgart
Geschäftsführer: Daniel Schwager, Stefan Hörz - HRB Stuttgart 19870
Tel: +49-711-849910-32, Fax: -932 - Mailto:daniel.schwa...@dtnet.de
smime.p7s
Description: S/MIME cryptographic signature
[rt-users] Everyone from the same requestors email-domain should be able to reply to a ticket ?
Good evening everybody, We set the global rights for Requestor and CC to reply to a ticket. Because we are using RT3 in the B2B environment, we often faced to the situation, the another employee from the some company than the requestor (therefore, with the same email-domain) reply additionally to this ticket. Of course, this email will not recorded because of lack of permissions. I would not like to set the global right Everyone is allowed to reply! Question: Is there a way to allow senders from the SAME email-domain like the Requestor to reply to a ticket ? Kind regards Danny RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 27, 2011 * San Francisco, CA, USA October 18 19, 2011 * Washington DC, USA October 31 November 1, 2011 * Melbourne VIC, Australia November 28 29, 2011 * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Blank in default preference / search options ?
It's a wrong path. Correct path is: /opt/rt3/local/html/Callbacks/MyCallbacks/Search/Elements/BuildFormatString/SetFieldsOnce yes - sorry about this )-: You are right. A reference to array is passed, so you should use reference: ... That's it. Not tested. Great, the following works like a charm: %INIT push @$Fields, 'NBSP'; /%INIT %ARGS $Fields = [] /%ARGS Now, a I can insert a 'NBSP' which will be displayed as a Blank. Best regards Danny
[rt-users] CommandByMail + SLA, set CF SLA using email does not work
Hi,
we are using the current version 0.03 of
http://search.cpan.org/~ruz/RT-Extension-SLA/
in a productive environment - works great - very
good work.
Also, we are using RT-Extension-CommandByMail to
set e.g. the SLA by email (AddCF.{SLA}:Task-low),
but this does not work.
The logfile tells me about the correct
parsing from CommandByMail:
[Mon May 30 16:08:45 2011] [debug]: Got command
addcustomfield{sla} = Task-low
(/opt/rt3/local/plugins/RT-Extension-CommandByMail/lib/RT/Interface/Emai
l/Filter/TakeAction.pm:213)
But the Condition/SLA_RequireDefault.pm told me (I checked this by
adding some debug info)
no SLA is set - and of course, set's the default one.
Independent of email-configure SLA using CommandByMail, the
CommandByMail works fine.
How can I go on tracking down the problem ?
Kind regards
Danny
[rt-users] Blank in default preference / search options ?
Hi, is there a way to add a BLANK to the default search options (rt/Prefs/SearchOptions.html) ? Currently, NEWLINE is available, but no BLANK. In the normal (advanced) search (not the default one), it's possible to add '', to the Format-Field - works fine. But I don't know how to change the default Format. Kind regards Danny
Re: [rt-users] CommandByMail + SLA, set CF SLA using email does not work
Hi,
Also, we are using RT-Extension-CommandByMail to
set e.g. the SLA by email (AddCF.{SLA}:Task-low),
but this does not work.
Try to use TransactionBatch stage for the SLA scrip that sets default value.
no, this does not work either.
regards
Danny
Re: [rt-users] CommandByMail + SLA, set CF SLA using email does not work
Is it possible that you have several custom fields named SLA? Check database. SELECT * FROM `CustomFields` WHERE `Name` LIKE 'SLA' LIMIT 0 , 30 -- 1 record found No, only one SLA CF-field. Danny
Re: [rt-users] Blank in default preference / search options ?
Default formats can be set in the config.
I would like to give the user the possibility
to add a BLANK to this user default search,
so the new BLANK should appear in the selection
box
Search Preferences / Search options / Display Columns / Add Columns:
I found the available elements setup in
share/html/Search/Elements/BuildFormatString
Is this the right place ?
My DefaultSearchResultFormat looks like:
Set ($DefaultSearchResultFormat, qq{
'BA
HREF=$RT::WebPath/Ticket/Display.html?id=__idid__/a/B/TITLE:#',
'BA
HREF=$RT::WebPath/Ticket/Display.html?id=__idSubject__/a/B/TITLE:Subject',
Status,
QueueName,
OwnerName,
Priority,
QuickDelete,
'__NEWLINE__',
'',
'small__Requestors__/small',
'small__CreatedRelative__/small',
'small__ToldRelative__/small',
'small__LastUpdatedRelative__/small',
'small__TimeLeft__/small'});
regards
Danny
Re: [rt-users] Blank in default preference / search options ?
I would like to give the user the possibility to add a BLANK to this user default search, so the new BLANK should appear in the selection box Search Preferences / Search options / Display Columns / Add Columns: I found the available elements setup in share/html/Search/Elements/BuildFormatString Also, try NBSP (like NEWLINE). It should work similar or exactly like what you want. Great ! Thx a lot - works fine now: # Add local copy of BuildFormatString cp -av share/html/Search/Elements/BuildFormatString \ local/html/Search/Elements/BuildFormatString # Add NBSP local/html/Search/Elements/BuildFormatString: NEWLINE +NBSP ); # loc_qw ** Advanced (-: One additional question - could this be done by using a callback ? I saw a callback directly after the definition of the fields ... $m-callback( CallbackOnce = 1, CallbackName = 'SetFieldsOnce', Fields = \@fields ); I tried to create a callback - but it does not work (sorry, I never used Callbacks). May you can give me a small hint ? cat /opt/rt3/local/html/Callbacks/MyCallbacks/Prefs/SearchOptions.html/SetFieldsOnce %init push @fields, NBSP; RT::Logger-debug(SetFieldsOnce.1: \n); /%init %args @fields = undef /%args Kind regards Danny
Re: [rt-users] command by mail
Hi, did you add it to your Plugins ? Set(@Plugins, qw( RT::Extension::CommandByMail and also to the Mailplungins - in the right order like Set(@MailPlugins, qw(Auth::MailFrom Filter::TakeAction) ); kind regards Danny
[rt-users] Scrip condition, On XxxxCustomFieldChanged
Hi, is there a change to get the custom field id by the CF name ? my $fieldId = $self-TransactionObj-getCustomFieldIdByName(CF-Summary); I would like to replace the field number with the name to make the code more robust. -- scrip ### Trigger if custom value changed return undef unless ( $self-TransactionObj-Type =~ /CustomField/i ); # Field 29: CF-Summary # my $fieldId = $self-TransactionObj- getCustomFieldIdByName (CF-Summary); my $fieldId = 29; return undef unless ( $self-TransactionObj-Field == $fieldId ); -- /scrip Kind regards Danny
Re: [rt-users] Scrip condition, On XxxxCustomFieldChanged
Hi Ruslan, my $cf_obj = $self-TicketObj-LoadCustomFieldByIdentifier(Summary); works perfectly - thanks very much !! best regards Danny
[rt-users] Save seaarch with type='Reminder' not possible ?
Hi, I try to save my over-due-reminder search (configured in the 'advance search page'): Owner = '__CurrentUser__' AND Due = 'now' AND Due 0 AND type = 'Reminder' AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) but it's not possible, because I cannot jump back to the Edit-Search for saving. If I remove the AND type = 'Reminder' part, it's possible to jump back the editpage, where Save-button is available. How can I save my query ? We use RT3.8.8. kind regards Danny
[rt-users] dumpfile-to-rt-3.0, incremental import failed
Hi,
we would like to update from rt 2.0.11 to 3.8.8.
Using dumpfile-to-rt-3.0, a full export/import works fine.
The incremental import ended with the following error:
t-57701: ww[Mon Mar 7 14:26:48 2011] [crit]:
Couldn't set EffectiveId: That is already the current value
(/opt/rt3/lib/RT/Ticket_Overlay.pm:504)
Couldn't create TICKET: Ticket could not be created due to an internal
error$VAR1 = {
'Status' = 'stalled',
'Queue' = 'support',
'Started' = '2011-03-01 17:25:31',
'Starts' = '1970-01-01 00:00:00',
'_RecordTransaction' = '0',
'id' = '57701',
'LastUpdated' = '2011-03-01 17:25:31',
'Requestor' = [
'36060'
],
'Cc' = [
'24054'
],
'Subject' = 'x',
'Creator' = '36060',
'Owner' = '65444',
'EffectiveId' = '57701',
'LastUpdatedBy' = '57822',
'Created' = '2010-12-10 18:47:09',
'Due' = '2010-12-10 18:47:09'
};
[Mon Mar 7 14:26:48 2011] [crit]: Died at /usr/bin/dumpfile-to-rt-3.0
line 716. (/opt/rt3/lib/RT.pm:382)
Died at /usr/bin/dumpfile-to-rt-3.0 line 716.
** Code around /opt/rt3/lib/RT.pm:382 looks like
#Set the ticket's effective ID now that we've created it.
my ( $val, $msg ) = $self-__Set(
Field = 'EffectiveId',
Value = ( $args{'EffectiveId'} || $id )
);
unless ( $val ) {
$RT::Logger-crit(Couldn't set EffectiveId: $msg);
$RT::Handle-Rollback;
return ( 0, 0,
$self-loc(Ticket could not be created due to an internal
error)
);
}
I found a thread concerning this issue
http://www.gossamer-threads.com/lists/rt/users/89660?search_string=%20Co
uldn't%20set%20EffectiveId:%20That%20is%20already%20the%20current%20valu
e;#89660
but the solution was told to the community.
Is there a way to fix this problem with the incremental import ?
Kind regards
Danny
[rt-users] Sample for RTFM::Extension::ArticleTemplates using inside a template ?
Hi,
we added our company signature (queue based) to
3 (Correspondence, Autoreply and Resolve) templates.
Is it possible to move the 3 times duplicated signature code to
a RTFM article and include this article in my templates, like
{ $Transaction-GetRTFMArticle(3) }
So, the maintenance will be easier...
I installed the RTFM::Extension::ArticleTemplates but cannot find
any sample how to use it ..
kind regards
Danny
** Correspondence-templates:
RT-Attach-Message: yes
{$Transaction-Content()}
{
# Do some checks if the template is used from the webui or triggered
# by email. If WebUI, append the signature:
. $Transaction-CreatorObj-RealName .
Tel. . $Transaction-CreatorObj-WorkPhone .
Company Name,
;
}
Kind regards
Danny
[rt-users] MessageBoxIncludeSignature not work ?
Hi,
If i set MessageBoxIncludeSignature to 0, the signature
will still displayed while reply (respond action) to a ticket.
This is because rt-3.8.8/share/html/Ticket/Update.html
is written to ignore the config variable while processing
any Respond action.
** rt-3.8.8/share/html/Ticket/Update.html
...
% my $IncludeSignature = 1;
% $IncludeSignature = 0 if $Action ne 'Respond'
!RT-Config-Get('MessageBoxIncludeSignatureOnComment');
/Elements/MessageBox, Name=UpdateContent, IncludeSignature =
$IncludeSignature, %ARGS
...
Is this a Bug ? I thought MessageBoxIncludeSignature and
MessageBoxIncludeSignatureOnComment relates to correspondence/comments
updates.
Kind regards
Danny
Re: [rt-users] Sample for RTFM::Extension::ArticleTemplates using inside a template ?
It does not let you dynamically load an article from a Template, you
could do that without the extension just by writing code in normal RT
Templates.
Sure. But I would not like to repeat myself in 3 templates (3 times the
same
signature/code in 3 templates) - for one queue.
I would like to move / refactor this code out of the templates to one
place,
a RTFM article. Then, just source the text from the signature-article
to
the template.
Something like this:
my $rtfm = RT::FM::Article-new($Ticket-CurrentUser);
my ($id,$msg) = $rtfm-Load(Signature1);
if (!id) { $RT::Logger-debug(failed ..); } else { HOWTO print a CF
xxx from the loaded article ?; }
kind regards
Danny
Re: [rt-users] Sample for RTFM::Extension::ArticleTemplates using inside a template ?
my $rtfm = RT::FM::Article-new($Ticket-CurrentUser);
my ($id,$msg) = $rtfm-Load(Signature1);
if (!id) { $RT::Logger-debug(failed ..); } else { HOWTO print a
CF
xxx from the loaded article ?; }
Sure, that was my suggestion
You don't need RTFM::Extension::ArticleTEmplate in order to load an
Article from a normal RT article
Ups - got it. Sorry for my misunderstanding. How can I access my
defined CF inside the RTFM ? Like $rtfm-GetCustomerField(text) ?
- Danny
Re: [rt-users] OnCreateSetLanguage dependent on the Email To addr
The list server mixed up my example, therefore again: Example: Sending an email to a) support [at] example dot COM : set English to the requestor language, b) support [at] example dot DE : set German to the requestor language. regards Danny
[rt-users] OnCreateSetLanguage dependent on the Email To addr
Hi,
We would like to answer ticket in ONE
queue called support using different languages.
The language depends on the language of the requestor.
If the requestor has no language set, we have to set
the language automatically (scrip) dependent on the
To-email-addr used for creating the ticket.
Example: Sending an email to
a) supp...@example.com set English to the requestor language,
b) supp...@example.de set German to the requestor language.
The Correspondence-Template checks the language of the requestor
and changes the language for the signature dynamically.
Scrip name: OnCreateSetLanguage
Precondition: ticket.isReceivedByEmail() !requestor.isSetLanguage()
Action: requestor.setLanguage(depend on To-emailaddr)
** Precondition:
# isReceivedByEmail()
my $inMessage = $self-TransactionObj-Attachments-First;
return 0 if ( !$inMessage ); # if no message attachment - assume web UI
return 0 if ( !$inMessage-GetHeader('Received') ); # exit if not email
message
# !requestor.isSetLanguage()
..
Can somebody help me to create the Precondition and Action ? Currently I
stuck... )-:
Kind regards
Danny
Re: [rt-users] dumpfile-to-rt-3.0 failed (2.0.14 - 3.8.8)
Hi,
a) I started the import now by erasing the predefined database:
/opt/rt3/sbin/rt-setup-database --action drop --dba root
--dba-password xx
/opt/rt3/sbin/rt-setup-database --action create --dba root
--dba-password xx
/opt/rt3/sbin/rt-setup-database --action schema --dba root
--dba-password xx
/opt/rt3/sbin/rt-setup-database --action acl --dba root
--dba-password xx
/opt/rt3/sbin/rt-setup-database --action coredata --dba root
--dba-password xx
This helps me to track down other issues e.g. the imported tickets has
no assigned owner.
May this could be a small note in your dumpfile-to-rt-3.0-README .
b) Links
This reads like you had trouble rewriting your Links, often this is
because your Organization is invalid or because you changed it from
rt2 to rt3.
OK - this is correct - we changed the name back to the old version,
but warnings concerning the ticket import are still available.
Any additional hints ?
Importing links
l[Tue Feb 15 20:12:28 2011] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/bin/dumpfile-to-rt-3.0 line 434.
(/usr/bin/dumpfile-to-rt-3.0:434)
[Tue Feb 15 20:12:28 2011] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/bin/dumpfile-to-rt-3.0 line 440.
(/usr/bin/dumpfile-to-rt-3.0:440)
..
Skipping link creation (21 4 MemberOf) because duplicate of 2 detected
Skipping link creation (30 30 MergedInto) because duplicate of 9
detected
What are exactly the Links ? So, may they are not important for the
migration ?
c) Import of tickets
Concerning the normal ticket import, I got this kind of warning for each
ticket:
t-35437: [Tue Feb 15 20:09:42 2011] [warning]: Use of uninitialized
value in hash element at /usr/bin/dumpfile-to-rt-3.0 line 667.
(/usr/bin/dumpfile-to-rt-3.0:667)
line 667: $ticket-{'Owner'} = $user_map-{
$ticket-{'Owner'} };
wta[Tue Feb 15 20:09:42 2011] [warning]: Use of uninitialized value in
string eq at /usr/bin/dumpfile-to-rt-3.0 line 891.
(/usr/bin/dumpfile-to-rt-3.0:891)
line: 891:if ( $content_type =~
qr{(text/|message/rfc822)}i )
[Tue Feb 15 20:09:42 2011] [warning]: Use of uninitialized value in
length at /opt/rt3/lib/RT/Record.pm line 753.
(/opt/rt3/lib/RT/Record.pm:753)
line: 753 #if the attachment is larger than the
maximum size
if ( ($MaxSize) and ( $MaxSize
length($Body) ) ) {
[Tue Feb 15 20:09:42 2011] [warning]: Use of uninitialized value in
string eq at /usr/bin/dumpfile-to-rt-3.0 line 970.
(/usr/bin/dumpfile-to-rt-3.0:970)
aat
line 970:if ($a-{ContentEncoding} eq
'base64'
c) Scrips
The Scrip part is likely because you had custom templates that won't
work on rt3 since the APIs changed and you'll need to recreate them.
Ok - np.
Kind regards
Danny
[rt-users] dumpfile-to-rt-3.0 failed (2.0.14 - 3.8.8)
Dear list members, we would like to convert our 9 year old rt2 (2.0.14 from 02/2002) to the current rt3 3.8.8. Therefore, - I downloaded your migration tool from https://github.com/bestpractical/rt2-to-rt3 and - created a dump directory using rt-2.0-to-dumpfile and - tried to import the dump using dumpfile-to-rt-3.0 to the new RT3 mysql-db but I get the following errors ... [Fri Feb 11 23:14:14 2011] [warning]: Use of uninitialized value in string eq at /usr/bin/dumpfile-to-rt-3.0 line 891. (/usr/bin/dumpfile-to-rt-3.0:891) [Fri Feb 11 23:14:14 2011] [warning]: Use of uninitialized value in length at /opt/rt3/lib/RT/Record.pm line 753. (/opt/rt3/lib/RT/Record.pm:753) [Fri Feb 11 23:14:14 2011] [warning]: Use of uninitialized value in string eq at /usr/bin/dumpfile-to-rt-3.0 line 970. (/usr/bin/dumpfile-to-rt-3.0:970) aattta[Fri Feb 11 23:14:14 2011] [warning]: Use of uninitialized value in string eq at /usr/bin/dumpfile-to-rt-3.0 line 891. (/usr/bin/dumpfile-to-rt-3.0:891) [Fri Feb 11 23:14:14 2011] [warning]: Use of uninitialized value in length at /opt/rt3/lib/RT/Record.pm line 753. (/opt/rt3/lib/RT/Record.pm:753) Importing links l[Fri Feb 11 23:14:27 2011] [warning]: Use of uninitialized value in concatenation (.) or string at /usr/bin/dumpfile-to-rt-3.0 line 434. (/usr/bin/dumpfile-to-rt-3.\ 0:434) [Fri Feb 11 23:14:27 2011] [warning]: Use of uninitialized value in concatenation (.) or string at /usr/bin/dumpfile-to-rt-3.0 line 440. (/usr/bin/dumpfile-to-rt-3.0\ :440) .. Could not create scrip: On Correspond Notify Requestors And Ccs with template Correspondence_ DT N_deutsch in queue #5 - may be due to a non-standard template, condition or action Could not create scrip: On Comment Notify Owner As Comment with template Admin Comment_ DT N_deutsch in queue #5 - may be due to a non-standard template, condition or action .. So, only the tickets NOT assigned to any queue where merged. All ticked assigned to a queue are missing. Could somebody help me to track down this slight migration problem ? Kind regards Danny
Re: [rt-users] dumpfile-to-rt-3.0 failed (2.0.14 - 3.8.8)
- I downloaded your migration tool from https://github.com/bestpractical/rt2-to-rt3 and - created a dump directory using rt-2.0-to-dumpfile and - tried to import the dump using dumpfile-to-rt-3.0 to the new RT3 mysql-db but I get the following errors ... ... So, only the tickets NOT assigned to any queue where merged. All ticked assigned to a queue are missing. Small correction - it seems that all the tickets are imported Are the errors/warning a problem ? May the import was not done 100% ? Kind regards Danny
[rt-users] Upgrade Database from RT2.0.11 - RT3.6.3
Hi, how can i upgrade from 2.0.11 to the current version of RT (3.6.2) without loosing all my data in the mysql-database ? Is there a way to convert the mysql-database (including 10k tickets) from RT2.0.11 to RT-database 3.6.3 ? Thanks for help Danny DT Netsolution GmbH - Talaeckerstr. 30 - D-70437 Stuttgart Tel: +49-711-849910-32 Fax: +49-711-849910-932 WEB: http://www.dtnet.de/email: [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
