[rt-users] Multiple Validation for Customfield
Hi, I want to have a Customfields with the Digits-Validation and I also want it to be mandatory. Is there a way to combine multiple Validations? Thanks for your help, vinz -- View this message in context: http://requesttracker.8502.n7.nabble.com/Multiple-Validation-for-Customfield-tp59604.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] ...lib/RT/I18N/cs.pm is tainted. not loading...
I found the problem with the tainted I18N/*.pm errors. It seems
I18N.pm does a path element check but doesn't know about AFS's @sys path
elements so doesn't allow for @ in names. This is the very minor change
I made to enable that. I don't know if this is going to cause problems
elsewhere, can anyone verify this for me?
: || nomad@silverfox as60-amd64-4.2.9 [77] ; diff -c lib/RT/I18N.pm
lib/RT/I18N.pm.orig
*** lib/RT/I18N.pm 2015-02-18 09:27:14.395298000 -0800
--- lib/RT/I18N.pm.orig 2015-02-18 09:26:23.718504000 -0800
***
*** 101,107
# Load language-specific functions
foreach my $file ( File::Glob::bsd_glob(substr(__FILE__, 0, -3) .
/*.pm) ) {
! unless ( $file =~ /^([-\w\s\.\/\\\@~:]+)$/ ) {
warn($file is tainted. not loading);
next;
}
--- 101,107
# Load language-specific functions
foreach my $file ( File::Glob::bsd_glob(substr(__FILE__, 0, -3) .
/*.pm) ) {
! unless ( $file =~ /^([-\w\s\.\/\\~:]+)$/ ) {
warn($file is tainted. not loading);
next;
}
Sadly, this doesn't solve the problem with rt-fulltext-indexer --all
thinking an indexer is already running (nor does it solve my previously
posted problems with the bodies of articles not being filled in when the
article is first created).
nomad
On 2/17/15 09:29 , Lee Damon wrote:
tl;dr: I'm attempting to upgrade from RT 3.6.4 to RT 4.2.9. After
running make upgrade-database I get the following errors to pretty much
every command:
[6313] [Tue Feb 17 17:00:00 2015] [warning]:
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N/cs.pm
is tainted. not loading at
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm line
105.
(/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm:105)
[6313] [Tue Feb 17 17:00:00 2015] [warning]:
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N/de.pm
is tainted. not loading at
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm line
105.
(/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm:105)
[6313] [Tue Feb 17 17:00:00 2015] [warning]:
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N/fr.pm
is tainted. not loading at
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm line
105.
(/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm:105)
[6313] [Tue Feb 17 17:00:00 2015] [warning]:
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N/i_default.pm
is tainted. not loading at
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm line
105.
(/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm:105)
[6313] [Tue Feb 17 17:00:00 2015] [warning]:
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N/ru.pm
is tainted. not loading at
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm line
105.
(/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/I18N.pm:105)
After that error message is presented I am unable to run
rt-fulltext-indexer --all because it claims an indexer is already running.
Long form:
I'm using the following command to copy the existing database from the
production server to the test server:
pg_dump -U apache rt3 rt3.sql
I then copy rt3.sql to the test server and do the following steps to
upgrade:
# delete old database on chum:
sudo -u postgres psql
drop database rt4;
\q
# create empty database
sudo rm -rf /var/pkgs/rt/var/*/*
sudo /usr/nikola/pkgs/rt/sbin/rt-setup-database --action create,acl
(I note that when I run rt-setup-database I get the following warnings:
[3943] [Tue Feb 17 16:44:34 2015] [warning]: DBD::Pg::st execute failed:
ERROR: relation attachments_id_seq does not exist at
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/Handle.pm
line 452, STDIN line 1.
(/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/Handle.pm:452)
[3943] [Tue Feb 17 16:44:34 2015] [critical]: DBD::Pg::st execute
failed: ERROR: relation attachments_id_seq does not exist at
/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT/Handle.pm
line 452, STDIN line 1.
(/afs/ee.washington.edu/nikola/.@sys/pkgs/rt/.4.2.9/sbin/../lib/RT.pm:388)
but as they are warnings I hope they're not fatal.)
Proceeding:
#import database on chum:
sudo -u postgres psql rt4 /s0/nomad/rt3.sql
# verify that the database is rt4
psql --list --username=apache
# upgrade from 3.x to 4.x
sudo /etc/init.d/httpd stop
cd /s0/nomad/as60-amd64-rt-4.2.9
sudo make upgrade-database
upgrade to 3.9.8
sudo /usr/nikola/pkgs/perl/.5.20.0/bin/perl
/usr/nikola/pkgs/rt/etc/upgrade/upgrade-articles
sudo make upgrade-database
upgrade from 3.9.8 to latest
cd /usr/nikola/pkgs/rt
sudo
[rt-users] Notify when ticket transferred into queue
Hello -- I'm trying to figure out how to notify members of a queue when a ticket is transferred into their queue. I've tried using On Queue Change Notify AdminCcs but that sends notification to the AdminCcs of the queue the ticket is being transfered FROM. I need to notify AminCcs of the queue the ticket is being transferred INTO. Any suggestions appreciated. Thank you. Bryn Kanar University of California, Santa Cruz
[rt-users] ExternalAuth to active directory over SSL
Hello,
I'm using a fresh install of RT 4.0.19 on Ubuntu 14.04 AMD64, using .deb
packages.
I'm trying to make ExternalAuth work with LDAP over SSL (Active
Directory on 2008 R2 x64), we an internal CA managed under Windows 2008
R2 x64.
I added the CA cert in /etc/ssl/certs/srv2.lan.domain.com_ca.pem.
I followed a previous discussion on this matter here :
http://lists.bestpractical.com/pipermail/rt-users/2012-March/075690.html
I'm facing the same issue.
$ openssl s_client -connect srv2.lan.domain.com:636 -CApath /etc/ssl/certs
Return Verify return code: 21 (unable to verify the first certificate)
$ openssl verify -CAfile /etc/ssl/certs/srv2.lan.domain.com_ca.pem
/etc/ssl/certs/srv2.lan.domain.com_cert.pem
/etc/ssl/certs/srv2.lan.domain.com_cert.pem: OK
Running LDP.exe on the domain controllers running in SSL mode works fine.
RT's log gives the following :
RT::Authen::ExternalAuth::LDAP::_GetBoundLdapObj Can't bind:
LDAP_OPERATIONS_ERROR 1
An ldapsearch gives me this (snipped hex code) :
ldap_initialize( ldaps://srv2.lan.domain.com:636/??base )
tls_write: want=117, written=117
tls_read: want=3422, got=1443
tls_read: want=1979, got=1448
tls_read: want=531, got=531
tls_write: want=12, written=12
tls_write: want=267, written=267
tls_write: want=6, written=6
tls_write: want=117, written=117
tls_read: want=5, got=5
tls_read: want=1, got=1
tls_read: want=5, got=5
tls_read: want=80, got=80
TLS: can't connect: (unknown error code).
ldap_sasl_bind(SIMPLE): Can't contact LDAP server (-1)
Here's my configuration :
'AD_LAN' = {
'type' = 'ldap',
'server'= 'srv2.lan.domain.com',
'user' =
'CN=r2-d2,CN=Users,DC=lan,DC=domain,DC=com',
'pass' = 'XXX',
'base' =
'CN=Utilisateurs,DC=lan,DC=domain,DC=com',
'filter'=
'((objectClass=organizationalPerson)(mail=*))',
'd_filter' =
'(userAccountControl:1.2.840.113556.1.4.803:=2)',
'group' = '',
'group_attr'= '',
'tls' = 0,
'ssl_version' = 3,
'net_ldap_args' = [ version = 3, port =
636, debug = 8 ],
'attr_match_list' = [
'Name',
'EmailAddress',
],
'attr_map' = {
'Name' = 'sAMAccountName',
'EmailAddress' = 'mail',
'Organization' = 'physicalDeliveryOfficeName',
'RealName' = 'cn',
'ExternalAuthId' = 'sAMAccountName',
'Gecos' = 'sAMAccountName',
'WorkPhone' = 'telephoneNumber',
'Address1' = 'streetAddress',
'City' = 'l',
'State' = 'st',
'Zip' = 'postalCode',
'Country' = 'co'
},
},
Setting tls to 1 give me his different error :
RT::Authen::ExternalAuth::LDAP::_GetBoundLdapObj Can't bind:
LDAP_SERVER_DOWN 81
Regards,
--
Guillaume Hilt
