Re: [rt-users] ExternalAuth error messages in 4.0.4
Hi Kevin! Thanks for the info. Joosep On Wed, Nov 16, 2011 at 6:53 PM, Kevin Falcone wrote: > On Tue, Nov 15, 2011 at 09:47:24AM +0200, Joosep wrote: > >I'm trying to install a ExternalAuth module in the test environment > to prepare for the live > >system upgrade. Test environment is a snapshot of the live system > that i have upgraded from > >3.8.10 to 4.0.4(no problems there). > >Module installs and authentication works. Users are able to login, > but there are following > >errors in the log: > > Those look like warnings, not errors. There are some warnings > cleanups in the git repository that haven't been released yet. > > -kevin > > > RT Training Sessions (http://bestpractical.com/services/training.html) > * Barcelona, Spain — November 28 & 29, 2011 > RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011
[rt-users] ExternalAuth error messages in 4.0.4
Hi list! Environment is following: debian 6.0 x86_64 RT 4.0.4 Postgres 8.4 OpenLDAP 2.4.11.1 ExternalAuth 0.09 I'm trying to install a ExternalAuth module in the test environment to prepare for the live system upgrade. Test environment is a snapshot of the live system that i have upgraded from 3.8.10 to 4.0.4(no problems there). Module installs and authentication works. Users are able to login, but there are following errors in the log: Nov 15 09:05:04 rttest RT: RT::Authen::ExternalAuth::LDAP::GetAuth External Auth OK ( My_LDAP ): user.name(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:139) Nov 15 09:05:04 rttest RT: Couldn't enable user 37 (/opt/rt4/sbin/../lib/RT/User.pm:1066) Nov 15 09:05:04 rttest RT: Use of uninitialized value $val in concatenation (.) or string at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm line 274. (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274) Nov 15 09:05:04 rttest RT: Use of uninitialized value $message in concatenation (.) or string at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm line 274. (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274) Nov 15 09:05:04 rttest RT: User marked as ENABLED ( user.name ) per External Service (, ) (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274) Nov 15 09:05:04 rttest RT: Use of uninitialized value in string eq at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm line 236. (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:236) Nov 15 09:05:04 rttest RT: Use of uninitialized value in string eq at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm line 236. (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:236) Nov 15 09:05:04 rttest RT: Use of uninitialized value in string eq at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm line 236. (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:236) Nov 15 09:05:04 rttest RT: Use of uninitialized value in string eq at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm line 236. (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:236) Nov 15 09:05:04 rttest RT: Use of uninitialized value in string eq at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm line 236. (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:236) Nov 15 09:05:04 rttest RT: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning EmailAddress: user.n...@domain.com, ExternalAuthId: user.name, Gecos: User Name, Name: user.name, RealName: User (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536) Nov 15 09:05:04 rttest RT: Successful login for user.name from 192.168.178.13 (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:219) We have same ExternalAuth version running in live environment with RT 3.8.10 and there we see only this: Nov 15 09:27:16 rt RT: RT::Authen::ExternalAuth::LDAP::GetAuth External Auth OK ( My_LDAP ): user.name(/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:139) Nov 15 09:27:17 rt RT: Couldn't enable user 37 (/opt/rt3/bin/../lib/RT/User_Overlay.pm:1226) Nov 15 09:27:17 rt RT: User marked as ENABLED ( user.name ) per External Service (, ) (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274) Nov 15 09:27:17 rt RT: Successful login for user.name from 192.168.178.13 (/opt/rt3/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:219) The messages seem harmless, but i would rather have no error messages in the log. I have two theorys why i see these messages: * there are some perl modules missing in the 4.0.4(which?) * Our username form (firstname.lastname) is causing these errors I would be grateful if anyone could shed some light on this matter. Thanks, Joosep M RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011
Re: [rt-users] Time fields in days
Hi! Thanks for the info Kenneth i will look into it further. Joosep On Thu, May 5, 2011 at 5:43 PM, Kenneth Crocker wrote: > Joosep, > > I would think the DB changes ARE necessary. If you don't define the field > with 3 decimal positions, then it would always round up or down and you'd > gain/lose a lot of time. We didn't like the option of hours or minutes, so I > removed the top-down choice. Since we offered hours in the form of .125 > days, we felt that should be sufficient. We didn't know of ANYONE in our > organization that would project time estimates in hours or minutes. Most > projects involve many, many man-days. > > Anyway, that was our thinking. > > Kenn > > > On Thu, May 5, 2011 at 7:06 AM, Joosep wrote: > >> Thanks for the reply Kenneth, >> >> Is the database modification also necessary in order it to work, or should >> it work with just the modifications in the file >> local/html/Elements/SelectTimeUnits >> ? >> >> Implementing the code from that thread so far only seem to give the >> possibility to select days from the dropdown menu when using for example >> "time estimated" field in the ticket basics, but seem to lack the math. At >> least in RT 3.8.10. When inserting some value in hours, RT automatically >> converts the inserted value into minutes(for example inserting 2 hours >> results after save 120 minutes). When inserting for example 5 hours, after >> the save, it results in 5 minutes. >> I'm not very familiar with perl, but it seems that these rows should be >> responsible for the math: >> > % my $selected = 'minutes'; >> > % $selected = 'hours' if $minutes > 60; >> > % $selected = 'days' if $minutes > 480; >> >> But they don't seem to do it. Maybe the math has moved since then or i'm >> doing something wrong. >> I would be grateful for any pointers and hints where to look. >> >> Thanks in advance >> Joosep >> >> >
Re: [rt-users] Time fields in days
Thanks for the reply Kenneth, Is the database modification also necessary in order it to work, or should it work with just the modifications in the file local/html/Elements/SelectTimeUnits ? Implementing the code from that thread so far only seem to give the possibility to select days from the dropdown menu when using for example "time estimated" field in the ticket basics, but seem to lack the math. At least in RT 3.8.10. When inserting some value in hours, RT automatically converts the inserted value into minutes(for example inserting 2 hours results after save 120 minutes). When inserting for example 5 hours, after the save, it results in 5 minutes. I'm not very familiar with perl, but it seems that these rows should be responsible for the math: > % my $selected = 'minutes'; > % $selected = 'hours' if $minutes > 60; > % $selected = 'days' if $minutes > 480; But they don't seem to do it. Maybe the math has moved since then or i'm doing something wrong. I would be grateful for any pointers and hints where to look. Thanks in advance Joosep On Wed, May 4, 2011 at 7:38 PM, Kenneth Crocker wrote: > Joosep, > > I did that. However, I wanted to maintain the concept of 'hours', so I > changed the DataBase to contain all time fields with 3 decimal positions > (.125 = 1 hour). I changed all the displays, etc. to show that. > > Kenn > LBNL > > > On Tue, May 3, 2011 at 11:21 PM, Joosep wrote: > >> Hi list! >> >> RT version is 3.8.10 running on postgres 8.3.14 and debian 5.0. >> >> I'm trying to set RT to use unit "days" in time fields in addition to >> minutes and hours. >> I found similar thread in list archives: >> http://www.gossamer-threads.com/lists/rt/users/82265 >> >> RT version in that thread was 3.8.2. It seems that things are changed a >> little since then. >> I have found, that some of necessary code is in the file >> share/html/Elements/SelectTimeUnits. >> I have now unit "days" in the right place, but there is no relation >> between days and hours/minutes. I.e RT doesn't know how much minutes/hours 1 >> day is. >> Any idea where i can find that logic? >> If anybody knows better way to do it, i would be greatful to hear it. >> >> Thanks in advance, >> Joosep >> > >
[rt-users] Time fields in days
Hi list! RT version is 3.8.10 running on postgres 8.3.14 and debian 5.0. I'm trying to set RT to use unit "days" in time fields in addition to minutes and hours. I found similar thread in list archives: http://www.gossamer-threads.com/lists/rt/users/82265 RT version in that thread was 3.8.2. It seems that things are changed a little since then. I have found, that some of necessary code is in the file share/html/Elements/SelectTimeUnits. I have now unit "days" in the right place, but there is no relation between days and hours/minutes. I.e RT doesn't know how much minutes/hours 1 day is. Any idea where i can find that logic? If anybody knows better way to do it, i would be greatful to hear it. Thanks in advance, Joosep
Re: [rt-users] attachment encoding causes internal server error
> On Mon, Nov 15, 2010 at 11:39:42PM +0200, Joosep Meus wrote: >> Hi again! >> >> I should probably clarify that problem is related to iso-8859-1 >> special characters. Exapmle filename i used for testing was >> "öüõä.txt". Attachments, that do not contain those characters will >> not cause the problem. >> > > this is a known bug. See the story with some patches here: > http://issues.bestpractical.com/Ticket/Display.html?id=14913&user=guest&pass=guest > > Thanks alot. Patch from the link you provided fixed the problem for me. All the best, Joosep Meus
Re: [rt-users] attachment encoding causes internal server error
Hi again! I should probably clarify that problem is related to iso-8859-1 special characters. Exapmle filename i used for testing was "öüõä.txt". Attachments, that do not contain those characters will not cause the problem. All the best, Joosep MEus On 11/15/2010 11:32 PM, Joosep Meus wrote: Hi everyone! I'm using rt 3.8.8 with debian linux 5.0 and postgresql 8.3.12. When sending e-mail with an attachment to RT, i receive following error message: "Ticket could not be created due to an internal error" After some investigation i discovered, that this error occurs only, when attachment name contains iso-8859-1 letters and mail is sent using iso-5589-1 encoding. Sending the same file with mail encoding utf8 works fine. When error occurs, these messages will be logged into syslog: Nov 15 22:40:56 rt RT: Converting 'ISO-8859-1' to 'utf-8' for text/plain - Subjectless message Nov 15 22:40:56 rt RT: Guessed encoding: ascii Nov 15 22:40:56 rt RT: Guessed encoding: ascii Nov 15 22:40:56 rt RT: Converting 'ascii' to 'utf-8' for text/plain - Subjectless message Nov 15 22:40:56 rt RT: Guessed encoding: ascii Nov 15 22:40:56 rt RT: Guessed encoding: ascii Nov 15 22:40:56 rt RT: Mail from user #23 (s...@mail.address) Nov 15 22:40:56 rt RT: About to think about scrips for transaction #349 Nov 15 22:40:56 rt RT: About to think about scrips for transaction #350 Nov 15 22:40:56 rt RT: About to think about scrips for transaction #351 Nov 15 22:40:56 rt RT: About to think about scrips for transaction #352 Nov 15 22:40:56 rt RT: Attachment insert failed: ERROR: invalid byte sequence for encoding "UTF8": 0xf6fcf5e4#012HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". (/opt/rt3/bin/../lib/RT/Attachment_Overlay.pm:192) Nov 15 22:40:56 rt RT: Attachment insert failed: ERROR: invalid byte sequence for encoding "UTF8": 0xf6fcf5e4#012HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". (/opt/rt3/bin/../lib/RT/Attachment_Overlay.pm:165) Nov 15 22:40:56 rt RT: About to think about scrips for transaction #353 Nov 15 22:40:56 rt RT: About to prepare scrips for transaction #353 Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x50005f0) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: RT::Scrips=HASH(0x500d580) couldn't load ticket 34 (/opt/rt3/bin/../lib/RT/Scrips_Overlay.pm:291) Nov 15 22:40:56 rt RT: Found 5 scrips for TransactionCreate stage with applicable type(s) Create Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x4fc5008) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: HasRight called with no valid object (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322) Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x4f66bc0) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: HasRight called with no valid object (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322) Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x4be7000) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: HasRight called with no valid object (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322) Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x4f66bd8) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: HasRight called with no valid object (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322) Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x5004930) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: HasRight called with no valid object (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322) Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x5014810) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: HasRight called with no valid object (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322) Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x4f66770) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: About to commit scrips for transaction #353 Nov 15 22:40:56 rt RT: Committing scrip #11 on txn #353 of ticket # Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x501c8a8) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: HasRight called with no valid object (/opt/rt3/bin/../lib/RT/Principal_Overlay.pm:322) Nov 15 22:40:56 rt RT: Tried to load a bogus ticket id: '' Nov 15 22:40:56 rt RT: RT::Ticket=HASH(0x4ff5840) tried to load a bogus ticket: 34 Nov 15 22:40:56 rt RT: Ticket couldn't be created: (/opt/rt3/bin/../lib/RT/Ticket_Overlay.pm:679) Nov 15 22:40:56 rt RT: Ticket could not be created due to an internal error (/opt/rt3/bin/../lib/RT/Interface/Email.pm:244) There are also the "invalid byte sequence for encoding "UTF8": 0xf6fcf5e4" messages in the Postgresql log. I understand(correct me if i'm wrong) that the cause of the problem is that RT is trying to insert into UTF8 database something that is not UTF8. And the reason of that is that for some reason RT does guess' the
[rt-users] attachment encoding causes internal server error
here any way i can change this behavior? I tried to fiddle with the Set(@EmailInputEncodings, qw(utf-8 iso-8859-1 us-ascii)); option, but so far no luck. Searching google did'nt give anything useful so far. Any help would be much appreciated. all the best, Joosep Meus