Re: [rt-users] ICAL-Error Message
could someone help me out? best regards john s. -- View this message in context: http://old.nabble.com/ICAL-Error-tp32421407p32493068.html Sent from the Request Tracker - User mailing list archive at Nabble.com. 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
[rt-users] RT4.0.1 ExternalAuth and SSO
Hi all,
my RT installation is just a little step away from being absolutely perfect.
I'm currently trying to get a single sign-on behavior for all users in our
network.
Until now, ExternalAuth is working fine, all users can log in with their
credentials, they are recognized in our AD. My problem now is the SSO
config. I have no idea what I have to set in the RT_SiteConfig.pm.
As far as now my config looks like this:
# An example SSO cookie service
'My_SSO_Cookie' = { # # The type of
service (db/ldap/cookie)
'type'
= 'cookie',
'name'
= '', (commented out)
'u_table'
= 'Users',
# The username field
in the users table
'u_field'
= 'Name',
'u_match_key'
= 'id',
This is the part where I don't know what to write in:
# The cookies table
'c_table'
= 'login_cookie',
# The field that
stores cookie values
'c_field'
= 'loginCookieValue',
# The field in the
cookies table that uniquely identifies a user
# and also exists in
the users table
'c_match_key'
= 'loginCookieUserID',
# The DB service in
this configuration to use to lookup the cookie information
'db_service_name'
= 'My_MySQL'
}
}
So now my question is: Where can I find out how the table, field and the
match key of the cookie is called? Or is this a misunderstanding from my
side?
Do I have to make a cookie by myself? I think I can use the cookie I get
when visiting the RT interface, don't I?
The log file says that ExternalAuth is able to find the cookie, but then it
fails to authenticate (No user was authenticated by browser cookie. SSO
failed and no user to test with.). I think this comes from the wrong config
so that ExternalAuth tries to read but fails because of the wrong table name
and/or field and match key.
If I look at the cookie, it only contains a hash value. Maybe there is also
something wrong with the cookie itself.
Thanks in advance for your help!
PS: Another (small, compared to the problem above) problem: Is the value for
'd_field' that has to be specified for ExternalAuth to connect to the MySQL
database of RT4.0.1 still there? I had trouble to find it and thus I
commented it out. It still works, but it would be nice to know how it is
called now. Thank you. :)
--
View this message in context:
http://old.nabble.com/RT4.0.1-ExternalAuth-and-SSO-tp32478912p32478912.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.
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] Where can I find the RT password reset extension for RT 3.8?
Entering /opt/rt4 made it pass the installation: # cpan -i RT::Extension::ResetPassword CPAN: Storable loaded ok (v2.30) Reading '/root/.cpan/Metadata' Database was generated on Wed, 14 Sep 2011 10:27:35 GMT Running install for module 'RT::Extension::ResetPassword' Running make for F/FA/FALCONE/RT-Extension-ResetPassword-0.03.tar.gz CPAN: Digest::SHA loaded ok (v5.62) CPAN: Compress::Zlib loaded ok (v2.037) Checksum for /root/.cpan/sources/authors/id/F/FA/FALCONE/RT-Extension-ResetPassword-0.03.tar.gz ok CPAN: Archive::Tar loaded ok (v1.76) RT-Extension-ResetPassword-0.03/ RT-Extension-ResetPassword-0.03/html/ RT-Extension-ResetPassword-0.03/html/Callbacks/ RT-Extension-ResetPassword-0.03/html/Callbacks/RT-Extension-ResetPassword/ RT-Extension-ResetPassword-0.03/html/Callbacks/RT-Extension-ResetPassword/Elements/ RT-Extension-ResetPassword-0.03/html/Callbacks/RT-Extension-ResetPassword/Elements/Login/ RT-Extension-ResetPassword-0.03/html/Callbacks/RT-Extension-ResetPassword/Elements/Login/Default RT-Extension-ResetPassword-0.03/html/NoAuth/ RT-Extension-ResetPassword-0.03/html/NoAuth/ResetPassword/ RT-Extension-ResetPassword-0.03/html/NoAuth/ResetPassword/Request.html RT-Extension-ResetPassword-0.03/html/NoAuth/ResetPassword/Reset/ RT-Extension-ResetPassword-0.03/html/NoAuth/ResetPassword/Reset/dhandler RT-Extension-ResetPassword-0.03/inc/ RT-Extension-ResetPassword-0.03/inc/Module/ RT-Extension-ResetPassword-0.03/inc/Module/Install/ RT-Extension-ResetPassword-0.03/inc/Module/Install/Base.pm RT-Extension-ResetPassword-0.03/inc/Module/Install/Can.pm RT-Extension-ResetPassword-0.03/inc/Module/Install/Fetch.pm RT-Extension-ResetPassword-0.03/inc/Module/Install/Makefile.pm RT-Extension-ResetPassword-0.03/inc/Module/Install/Metadata.pm RT-Extension-ResetPassword-0.03/inc/Module/Install/RTx.pm RT-Extension-ResetPassword-0.03/inc/Module/Install/Win32.pm RT-Extension-ResetPassword-0.03/inc/Module/Install/WriteAll.pm RT-Extension-ResetPassword-0.03/inc/Module/Install.pm RT-Extension-ResetPassword-0.03/lib/ RT-Extension-ResetPassword-0.03/lib/RT/ RT-Extension-ResetPassword-0.03/lib/RT/Extension/ RT-Extension-ResetPassword-0.03/lib/RT/Extension/ResetPassword.pm RT-Extension-ResetPassword-0.03/Makefile.PL RT-Extension-ResetPassword-0.03/MANIFEST RT-Extension-ResetPassword-0.03/META.yml RT-Extension-ResetPassword-0.03/README CPAN: File::Temp loaded ok (v0.22) CPAN: Parse::CPAN::Meta loaded ok (v1.4401) CPAN: CPAN::Meta loaded ok (v2.112150) CPAN: Module::CoreList loaded ok (v2.55) CPAN.pm: Building F/FA/FALCONE/RT-Extension-ResetPassword-0.03.tar.gz Cannot determine perl version info from lib/RT/Extension/ResetPassword.pm Cannot determine author info from lib/RT/Extension/ResetPassword.pm Cannot determine license info from lib/RT/Extension/ResetPassword.pm Cannot find the location of RT.pm that defines $RT::LocalPath in: inc /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /opt/rt3/lib /opt/lib/rt3 /opt/lib /usr/local/rt3/lib /usr/local/lib/rt3 /usr/local/lib /home/rt3/lib /home/lib/rt3 /home/lib /usr/rt3/lib /usr/lib/rt3 /usr/lib /sw/rt3/lib /sw/lib/rt3 /sw/lib *Path to your RT.pm: /opt/rt4 * Using RT configuration from /opt/rt4/lib/RT.pm: ./html = /opt/rt4/local/plugins/RT-Extension-ResetPassword/html ./lib = /opt/rt4/local/plugins/RT-Extension-ResetPassword/lib Checking if your kit is complete... Looks good Writing Makefile for RT::Extension::ResetPassword Writing MYMETA.yml and MYMETA.json cp lib/RT/Extension/ResetPassword.pm blib/lib/RT/Extension/ResetPassword.pm FALCONE/RT-Extension-ResetPassword-0.03.tar.gz /usr/bin/make -- OK CPAN: YAML loaded ok (v0.73) Running make test No tests defined for RT::Extension::ResetPassword extension. FALCONE/RT-Extension-ResetPassword-0.03.tar.gz /usr/bin/make test -- OK Running make install Prepending /root/.cpan/build/RT-Extension-ResetPassword-0.03-yliH6I/blib/arch /root/.cpan/build/RT-Extension-ResetPassword-0.03-yliH6I/blib/lib to PERL5LIB for 'install' Installing /opt/rt4/local/plugins/RT-Extension-ResetPassword/lib/RT/Extension/ResetPassword.pm Appending installation info to /opt/rt4/local/plugins/RT-Extension-ResetPassword/lib/perllocal.pod Installing /opt/rt4/local/plugins/RT-Extension-ResetPassword/html/Callbacks/RT-Extension-ResetPassword/Elements/Login/Default Installing /opt/rt4/local/plugins/RT-Extension-ResetPassword/html/NoAuth/ResetPassword/Request.html Installing /opt/rt4/local/plugins/RT-Extension-ResetPassword/html/NoAuth/ResetPassword/Reset/dhandler FALCONE/RT-Extension-ResetPassword-0.03.tar.gz /usr/bin/make install -- OK After this I've enabled the plugin: Set(@Plugins, (qw(RT::Extension::SLA RT::Extension::HistoryFilter RT::Extension::ResetPassword))); Restarted the service and did some testing. The plugin seems
Re: [rt-users] RT4.0.1 ExternalAuth and SSO
On 09/19/2011 04:51 AM, declaya wrote: Hi all, my RT installation is just a little step away from being absolutely perfect. I'm currently trying to get a single sign-on behavior for all users in our network. Until now, ExternalAuth is working fine, all users can log in with their credentials, they are recognized in our AD. My problem now is the SSO config. I have no idea what I have to set in the RT_SiteConfig.pm. As far as now my config looks like this: For AD SSO, you very likely want to use mod_auth_krb or similar commercial products to do the authentication at the Apache level. RT can then trust Apache's auth with the right configuration, and you won't really need ExternalAuth anymore since RT has the WebExternalAuth settings. Thomas 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] Implementing LDAP Authentication in RT 4.0.2
So I had a typo causing the timeout, but I am still unable to get LDAP
authentication to work. I am sure it is a configuration issue, as I can login
with the mysql db root account just fine. I can't find detailed documentation
on what each of the arguments takes, so I am posting my config back here for
some assistance. I am also receiving in the apache logs
syntax error at [RTHOME]/etc/RT_SiteConfig.pm line xx, near }
Missing right curly or square bracket at ...
Everything is open and closed below, correct? I thought this was odd...
Is there any way possible for me to see a debugging log of RT trying (or not
trying) to talk to our AD server?
Set($ExternalAuthPriority, [ 'My_LDAP' ]);
Set($ExternalInfoPriority, [ 'My_LDAP' ]);
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers,0);
Set($ExternalSettings, { 'My_LDAP' = {
'type' = 'ldap',
'server'= '..hibbett.com',
#temporarily commented this out
#'user' = '',
#'pass' = '',
'base' =
'ou=,dc=,dc=hibbett,dc=com',
'filter'= '(objectClass=*)',
'd_filter' = '(objectClass=NoOneAtALL)',
#not using tls or ssl
#'tls' = 0,
#'ssl_version' = 3,
#I don't know what the ldap args should be...is this in the
net::ldap perl module?
#'net_ldap_args' = [version = 3 ],
'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'
}
}
);
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Izz Abdullah
Sent: Friday, September 16, 2011 11:18 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Implementing LDAP Authentication in RT 4.0.2
I hate to do this...but now, it is timing out with communication to fast CGI. I
can only see this in apache logs, I can't see anything in RT logs (they are not
being created). How can I turn debugging off so that I can see what else is
going on? Why would the changes in authentication affect FCGI?
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Izz Abdullah
Sent: Friday, September 16, 2011 11:08 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Implementing LDAP Authentication in RT 4.0.2
Ok...so I found the missing opening braces. I truly appreciate your help
Kevin! When staring at code for so long, it needs another set of eyes. ;)
I changed it, and have refreshed the login page, it's been in the 'waiting for
servername' for quite some time now. I can deal with that as it is probably
a query to LDAP caching out (correct me if I am wrong, as I would like to have
an overview of the inner-workings some time). I'll look through the code to
see exactly what it does when I have the time, for now I just need to get it to
work, just once will be nice for the boss. =)
Thanks again!
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Friday, September 16, 2011 10:44 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Implementing LDAP Authentication in RT 4.0.2
On Fri, Sep 16, 2011 at 10:37:58AM -0500, Izz Abdullah wrote:
The comma is no longer there. The only thing I stripped was only using LDAP
as an external source, the mysql db resides locally and is defined elsewhere
within RT_SiteConfig, and within LDAP itself, I only removed the two GROUP
mappings.
Go compare your line
Set($ExternalSettings, 'My_LDAP' = {
to the version in the example siteconfig
You're missing an important character (and an important closing character).
-kevin
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
Re: [rt-users] Custom Field Order issue
On Sat, Sep 17, 2011 at 01:13:06PM -0400, Joe Kirby wrote: I have 2 cf's on a screen and I cannot get the screens to recognize the order I want even though it would appear I have it setup right when I am in the queue admin screen under Custom Fields Any ideas. The newer one is desired to show ahead of the old one as I have then linked via the category option Joe - I don't remember what version you're running, but that sounds like a bug we fixed for non-mysql databases around the middle of the 3.8 series. -kevin pgpl7oBlnmNMn.pgp Description: PGP signature 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] Where can I find the RT password reset extension for RT 3.8?
On Mon, Sep 19, 2011 at 11:14:54AM +0200, Bart wrote: The plugin seems to work just fine under RT4 (I'm running 4.0.2 in our testing environment). The only problem I noticed was when you have multiple e-mail addressees with a user (comma separated). It then expects the entire string to be entered as an e-mail address (obviously nobody will be able to do this lol). This is something we only have for our testing environment, in the real environment we won't be having multiple e-mail addresses with a user. So you know, multiple comma addressed emails being allowed on Users is a bug. It'll only work some of the time in some places in RT and I fully expect a future version of RT to apply much stricter validation to that field since it causes frustrating bugs when garbage gets into it. -kevin pgpvNiX9fOH8d.pgp Description: PGP signature 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
[rt-users] Custom Field Order issue
Field Order issue Message-ID: 20110919135813.gm1...@jibsheet.com Content-Type: text/plain; charset=us-ascii On Sat, Sep 17, 2011 at 01:13:06PM -0400, Joe Kirby wrote: I have 2 cf's on a screen and I cannot get the screens to recognize the order I want even though it would appear I have it setup right when I am in the queue admin screen under Custom Fields Any ideas. The newer one is desired to show ahead of the old one as I have then linked via the category option Joe - I don't remember what version you're running, but that sounds like a bug we fixed for non-mysql databases around the middle of the 3.8 series. -kevin -- next part -- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 195 bytes Desc: not available URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20110919/16ebbcf5/attachment.pgp -- 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 RT-Users mailing list RT-Users@lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users End of RT-Users Digest, Vol 90, Issue 59 -- -- Joe Kirby , Assistant Vice President, Business Systems Division of Information Technology (DoIT) Support Response - http://www.umbc.edu/oit Administration 627 Office - 410-455-3020 Email - ki...@umbc.edu 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] RT4.0.1 ExternalAuth and SSO
On Mon, Sep 19, 2011 at 01:51:45AM -0700, declaya wrote: Until now, ExternalAuth is working fine, all users can log in with their credentials, they are recognized in our AD. My problem now is the SSO config. I have no idea what I have to set in the RT_SiteConfig.pm. As far as now my config looks like this: I think you've misunderstood what SSO RT-Authen-ExternalAuth supports. So now my question is: Where can I find out how the table, field and the match key of the cookie is called? Or is this a misunderstanding from my side? Do I have to make a cookie by myself? I think I can use the cookie I get when visiting the RT interface, don't I? This module supports doing SSO using cookies that you're setting from another application. It is telling RT how to reach into the remote database to confirm the cookie it receives. If you want AD SPNEGO SSO, you want mod_auth_kerb or one of the related web server extensions. -kevin pgpD3BZMt6jAi.pgp Description: PGP signature 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
[rt-users] RT not reading RT_SiteConfig
Ok, so I made a mess. I was trying to 'clean-up' the look of the RT_SiteConfig file by removing all the heads, cuts, etc. and it quit reading the file and defaulted to the RT_Config file. So I started over, I copied over the RT_Config file to RT_SiteConfig.pm and left all the head comments, etc and made the setting changes. It is STILL not reading the RT_SiteConfig file, it is still defaulting to the RT_Config file. My gosh, all of this in trying to get LDAP to work, which is extremely important at this point. RT4.0.2 on Ubuntu Server 11.04 (Natty). Is there some way to reinitialize without running make install and possibly ruining my server? Please help... :( 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] RT not reading RT_SiteConfig
It was an owner issue, the group:owner had become all root, not including the apache service. Whew...Any assistance on the LDAP? From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Izz Abdullah Sent: Monday, September 19, 2011 10:23 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RT not reading RT_SiteConfig Ok, so I made a mess. I was trying to 'clean-up' the look of the RT_SiteConfig file by removing all the heads, cuts, etc. and it quit reading the file and defaulted to the RT_Config file. So I started over, I copied over the RT_Config file to RT_SiteConfig.pm and left all the head comments, etc and made the setting changes. It is STILL not reading the RT_SiteConfig file, it is still defaulting to the RT_Config file. My gosh, all of this in trying to get LDAP to work, which is extremely important at this point. RT4.0.2 on Ubuntu Server 11.04 (Natty). Is there some way to reinitialize without running make install and possibly ruining my server? Please help... :( 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] Updating RT_SiteConfig in RT4.0.2
Probably filing a bug against request-tracker4 in launchpad would be a good way to start. Anyone want to join in: https://bugs.launchpad.net/ubuntu/+source/request-tracker4/+bug/854041 Allen 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] Where can I find the RT password reset extension for RT 3.8?
2011/9/19 Kevin Falcone falc...@bestpractical.com On Mon, Sep 19, 2011 at 11:14:54AM +0200, Bart wrote: The plugin seems to work just fine under RT4 (I'm running 4.0.2 in our testing environment). The only problem I noticed was when you have multiple e-mail addressees with a user (comma separated). It then expects the entire string to be entered as an e-mail address (obviously nobody will be able to do this lol). This is something we only have for our testing environment, in the real environment we won't be having multiple e-mail addresses with a user. So you know, multiple comma addressed emails being allowed on Users is a bug. It'll only work some of the time in some places in RT and I fully expect a future version of RT to apply much stricter validation to that field since it causes frustrating bugs when garbage gets into it. -kevin Fair enough. Are there any plans for adding multiple e-mail addresses to a user account? (having 1 primary address and a few secondary addresses for the purpose of recognising users and registering tickets to the same requestor) -- Bart 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] RT3.8 - RT4 Callback changes - Elements/Tabs/Default
Thank you, everyone. Looks like the correct file location for me to make new global top menu items is: /opt/rt4/local/html/Callbacks/Default/Elements/Tabs/Privileged I added one to the Tickets menu by substituting 'search' for 'tools' in Mark's example code. Allen 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] RT 4.0.2 postgresql fulltext - error doing initial indexing
On Mon, 2011-09-19 at 13:24 +1000, fab junkmail wrote:
2011-09-19 02:08:28 UTC ERROR: string is too long for tsvector
(3831236 bytes, max 1048575 bytes)
2011-09-19 02:08:28 UTC STATEMENT: UPDATE Attachments SET
ContentIndex = to_tsvector($1) WHERE id = $2
I think it is getting to a ticket that has too many unique words so it
can't index it and it critically fails and stops indexing any further.
You are correct that this is because the content of one of the
attachments contains too many unique words (after removing stopwords and
doing stemming). This is symptomatic of a pathological case -- for
example, the entirety of A Tale of Two Cities (775K) creates a 121K
tsvector and the entire corpus of the King James Bible (4.3M) creates a
160K tsvector. In contrast, the contents of my /usr/share/dict/words
(916K) produces a 524K tsvector, because there is so little word
repetition.
Knowing what text/plain or text/html corpus you have in your database
which is blowing so significantly past this limit (generating a 3.8M
tsvector is impressive) would be interesting. I suspect the data in
question is not actually textual data. If you re-run
rt-fulltext-indexer with --debug, the last attachment number it prints
will tell you which attachment if the problematic one.
I would appreciate some advice on how I can proceed with getting the
rest of my data indexed. I think any of the following would be
suitable but I don't know how to implement them (I am not a coder or a
dba) and could use some help. Options:
- modify the rt-fulltext-indexer script to truncate strings that are
too long for tsvector. or
As pointed out above, long corpuses can generate perfectly reasonably
sized tsvectors. Truncating your input strings before indexing will
yield false negatives in perfectly reasonable text; as such, the change
from the wiki will not be taken into core.
- modify the rt-fulltext-indexer script to skip tickets that have that
issue and continue indexing other tickets. or
rt-fulltext-indexer currently iterates every attachment content and
updates the tsvector one at a time; as such, modifying it to trap the
update with an eval {} block and continue for particular error cases
should be completely feasible.
- find out which ticket is causing the problem (hopefully only one)
and maybe I can delete it before running the rt-fulltext-indexer
script. or
As I noted above, I suspect the row in question is not actually textual
data, despite being marked text/plain. As I noted above, running with
--debug may shed some light on the contents which are at issue.
- Alex
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] Where can I find the RT password reset extension for RT 3.8?
On Mon, Sep 19, 2011 at 07:45:35PM +0200, Bart wrote: 2011/9/19 Kevin Falcone falc...@bestpractical.com On Mon, Sep 19, 2011 at 11:14:54AM +0200, Bart wrote: The plugin seems to work just fine under RT4 (I'm running 4.0.2 in our testing environment). The only problem I noticed was when you have multiple e-mail addressees with a user (comma separated). It then expects the entire string to be entered as an e-mail address (obviously nobody will be able to do this lol). This is something we only have for our testing environment, in the real environment we won't be having multiple e-mail addresses with a user. So you know, multiple comma addressed emails being allowed on Users is a bug. It'll only work some of the time in some places in RT and I fully expect a future version of RT to apply much stricter validation to that field since it causes frustrating bugs when garbage gets into it. Fair enough. Are there any plans for adding multiple e-mail addresses to a user account? (having 1 primary address and a few secondary addresses for the purpose of recognising users and registering tickets to the same requestor) The current way to have this is RT-Extension-MergeUsers. We'd like the feature too, but it's complex because of the amount of internals that rely on LoadByEmail -kevin pgpHFKtp3tU5Y.pgp Description: PGP signature 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
[rt-users] Problem extension: RT::Extension::SpawnLinkedTicketInQueue
I've installed (via cpan) RT::Extension::SpawnLinkedTicketInQueue version 0.05 on RT 4.0.2 and I'm unable to see the added link controls. I've added the extension to the RT_SiteConfig file, flushed the mason cache and restarted my webserver (the extension is listed in the configuration.html), but I'm not sure how to proceed from here. Any assistance would be greatly appreciated. Ian R. 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] RT 4.0.2 postgresql fulltext - error doing initial indexing
Hi Alex,
Thank you very much for your responses. Notes inline.
On Tue, Sep 20, 2011 at 4:37 AM, Alex Vandiver ale...@bestpractical.com wrote:
On Mon, 2011-09-19 at 13:24 +1000, fab junkmail wrote:
2011-09-19 02:08:28 UTC ERROR: string is too long for tsvector
(3831236 bytes, max 1048575 bytes)
2011-09-19 02:08:28 UTC STATEMENT: UPDATE Attachments SET
ContentIndex = to_tsvector($1) WHERE id = $2
I think it is getting to a ticket that has too many unique words so it
can't index it and it critically fails and stops indexing any further.
You are correct that this is because the content of one of the
attachments contains too many unique words (after removing stopwords and
doing stemming). This is symptomatic of a pathological case -- for
example, the entirety of A Tale of Two Cities (775K) creates a 121K
tsvector and the entire corpus of the King James Bible (4.3M) creates a
160K tsvector. In contrast, the contents of my /usr/share/dict/words
(916K) produces a 524K tsvector, because there is so little word
repetition.
Knowing what text/plain or text/html corpus you have in your database
which is blowing so significantly past this limit (generating a 3.8M
tsvector is impressive) would be interesting. I suspect the data in
question is not actually textual data. If you re-run
rt-fulltext-indexer with --debug, the last attachment number it prints
will tell you which attachment if the problematic one.
I used the --debug option and was able to find the ticket that caused
the problem. The ticket has a 12MB, 125000 line .txt attachment that
is a file system file listing with full paths. Eg:
...
.//Accounts/Backup/New Folder
.//Accounts/Backup/PRM0124.ZIP
.//Accounts/Backup/PRM0206.ZIP
.//Accounts/Backup/PRM0207.ZIP
.//Accounts/Backup/PRM0214.1.ZIP
...
So in many cases it would have counted the whole line as a unique
word. That explains how the tsvector for this attachment got to over
3MB.
I would appreciate some advice on how I can proceed with getting the
rest of my data indexed. I think any of the following would be
suitable but I don't know how to implement them (I am not a coder or a
dba) and could use some help. Options:
- modify the rt-fulltext-indexer script to truncate strings that are
too long for tsvector. or
As pointed out above, long corpuses can generate perfectly reasonably
sized tsvectors. Truncating your input strings before indexing will
yield false negatives in perfectly reasonable text; as such, the change
from the wiki will not be taken into core.
- modify the rt-fulltext-indexer script to skip tickets that have that
issue and continue indexing other tickets. or
rt-fulltext-indexer currently iterates every attachment content and
updates the tsvector one at a time; as such, modifying it to trap the
update with an eval {} block and continue for particular error cases
should be completely feasible.
- find out which ticket is causing the problem (hopefully only one)
and maybe I can delete it before running the rt-fulltext-indexer
script. or
As I noted above, I suspect the row in question is not actually textual
data, despite being marked text/plain. As I noted above, running with
--debug may shed some light on the contents which are at issue.
- Alex
I have deleted (using shredder) the problem ticket and I am re-running
/opt/rt4/sbin/rt-fulltext-indexer-mod --all. It has been running for
a few minutes now so looks like it has got past the problem and is
working. If it has another problem I now know how to work around it.
Thanks very much for your help Alex.
Regards,
Anthony
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
[rt-users] How do I install RT 4 on Windows?
Good afternoon, I've found some installers on the Internet for RT 3, but none for RT 4. I'd like to setup RT4 on Windows with XAMPP. (I'm currently attempting to set it up through Cygwin) How do I install RT 4 on Windows? Thanks for all suggestions, Alec Taylor 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] RT4.0.1 ExternalAuth and SSO
Thank you for the quick response! Ah, this explains a lot. No wonder why SSO was not working. I'm going to use mod_auth_kerb for apache, since this does exactly what I want to achieve. Again, thank you for giving me hints and have a nice day! -- View this message in context: http://old.nabble.com/RT4.0.1-ExternalAuth-and-SSO-tp32478912p32500288.html Sent from the Request Tracker - User mailing list archive at Nabble.com. 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
