Re: [rt-users] MySQL error on 3.6.6

[Jay Kline]

That was it. I backported the package from debian testing to stable,
and naively assumed that the right dependencies were defined in the
package; they are not.

Thanks,

Jay

On Fri, May 9, 2008 at 3:13 PM, Ruslan Zakirov <[EMAIL PROTECTED]> wrote:
> Begin with README step number 3 - `make testdeps`.
>
> On Fri, May 9, 2008 at 11:59 PM, Jay Kline <[EMAIL PROTECTED]> wrote:
>> Ive noticed an error in my RT log about a failed MySQL statement.  This
>> only shows up when I view a ticket (eg /rt/Ticket/Display.html?id=42)
>> but not all tickets.  It seems to only happen for certain requesters.
___
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

[rt-users] MySQL error on 3.6.6

[Jay Kline]

Ive noticed an error in my RT log about a failed MySQL statement.  This
only shows up when I view a ticket (eg /rt/Ticket/Display.html?id=42)
but not all tickets.  It seems to only happen for certain requesters. 
The query in question is:

SELECT DISTINCT main.* FROM ((Tickets main JOIN Groups Groups_1 ON
((Groups_1.Domain = 'RT::Ticket-Role')) AND ( (Groups_1.Type =
'Requestor')) AND ( Groups_1.Instance = main.id)) LEFT JOIN
CachedGroupMembers CachedGroupMembers_2 ON (
CachedGroupMembers_2.GroupId = Groups_1.id) AND (
(CachedGroupMembers_2.MemberId = Users_3.id))) , Users Users_3 WHERE
((Users_3.id = '54')) AND ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
(CachedGroupMembers_2.id IS NOT NULL) ) AND ( (main.Status = 'open') OR
(main.Status = 'new') ) ) ORDER BY main.Priority DESC LIMIT 10;

The error is:

Unknown column 'Users_3.id' in 'on clause'

My SQL isnt quite good enough to understand all the join's in that
statement.  Any ideas where to begin on this one?

Thanks,

Jay


Full output from the logs follows (beware linewrapping)

[Fri May  9 18:03:06 2008] [warning]: DBD::mysql::st execute failed:
Unknown column 'Users_3.id' in 'on clause' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:505)
[Fri May  9 18:03:06 2008] [warning]: RT::Handle=HASH(0x9766528)
couldn't execute the query 'SELECT DISTINCT main.* FROM ((Tickets main 
JOIN Groups Groups_1  ON ((Groups_1.Domain = 'RT::Ticket-Role')) AND (
(Groups_1.Type = 'Requestor')) AND (  Groups_1.Instance = main.id)) 
LEFT JOIN CachedGroupMembers CachedGroupMembers_2  ON (
CachedGroupMembers_2.GroupId = Groups_1.id) AND (
(CachedGroupMembers_2.MemberId = Users_3.id))) , Users Users_3  WHERE
((Users_3.id = '54')) AND ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
(CachedGroupMembers_2.id IS NOT NULL) )  AND  ( (main.Status = 'open')
OR (main.Status = 'new') ) )  ORDER BY main.Priority DESC  LIMIT 10' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
   
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9766528)',
'SELECT DISTINCT main.* FROM ((Tickets main  JOIN Groups Group...')
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 231
DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0xa7e26c0)') called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 491
DBIx::SearchBuilder::Next('RT::Tickets=HASH(0xa7e26c0)') called at
/usr/share/request-tracker3.6/lib/RT/Tickets_Overlay.pm line 2670
RT::Tickets::Next('RT::Tickets=HASH(0xa7e26c0)') called at
/usr/share/request-tracker3.6/html/Ticket/Elements/ShowRequestor line 74
HTML::Mason::Commands::__ANON__() called at
/usr/share/perl5/HTML/Mason/Request.pm line 1329
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1329
   
HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xa696494)')
called at /usr/share/request-tracker3.6/html/Widgets/TitleBox line 51
HTML::Mason::Commands::__ANON__('title_href',
'/rt/Admin/Users/Modify.html?id=54', 'title', 'More about
[EMAIL PROTECTED]') called at /usr/share/perl5/HTML/Mason/Component.pm
line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa5d4e14)',
'title_href', '/rt/Admin/Users/Modify.html?id=54', 'title', 'More about
[EMAIL PROTECTED]') called at /usr/share/perl5/HTML/Mason/Request.pm
line 1256
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title_href',
'/rt/Admin/Users/Modify.html?id=54', 'title', 'More about
[EMAIL PROTECTED]') called at
/usr/share/request-tracker3.6/html/Ticket/Elements/ShowRequestor line 83
HTML::Mason::Commands::__ANON__('Ticket',
'RT::Ticket=HASH(0xa70b294)') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa7d61d4)',
'Ticket', 'RT::Ticket=HASH(0xa70b294)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1256
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0xa70b294)') called at
/usr/share/request-tracker3.6/html/Ticket/Elements/ShowSummary line 72
HTML::Mason::Commands::__ANON__('Ticket',
'RT::Ticket=HASH(0xa70b294)', 'Attachments',
'RT::Attachments=HASH(0xa762bdc)') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa79959c)',
'Ticket', 'RT::Ticket=HASH(0xa70b294)', 'Attachments',
'RT::Attachments=HASH(0xa762bdc)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1256
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0xa70b294)', 'Attachments',
'RT::Attachments=HASH(0xa762bdc)') called at
/usr/share/request-track

Re: [rt-users] S/MIME

[Jay Kline]

Jesse Vincent wrote:
>
> On Apr 23, 2008, at 5:12 PM, Jay Kline wrote:
>> Our organization makes heavy use of S/MIME for signatures and encryption
>> of email, and we would like RT to indicate if a message is signed, and
>> has a valid signature.  I saw a few mentions of it in the archives, but
>> most are old or inconclusive.
>
> We did a full integration for a client, but haven't found the cycles
> to polish it for release just yet :/
>

Would you be willing to share the patch, even if it dosnt get included
in the release? It surely would be helpful :-)

>
>> Related to this, we use these certs for client auth in web browers, has
>> anyone configured RT to use client certs for auth instead of cookies, or
>> HTTP auth?
>>
> RT has support for HTTP auth (say, using apache's support for certs)
> as a flag in the config file.
>

Yep, unfortunately this makes for  really ugly usernames, as Apache sets
the username to the full DN of the cert, we would ideally like to just
use the CN, or map it to another name entirely (like the email address). 

If its not really been done, Ill probably implement something using the
Cookie based external auth that is already out there.

Jay
___
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

[rt-users] S/MIME

[Jay Kline]

Our organization makes heavy use of S/MIME for signatures and encryption
of email, and we would like RT to indicate if a message is signed, and
has a valid signature.  I saw a few mentions of it in the archives, but
most are old or inconclusive.

Related to this, we use these certs for client auth in web browers, has
anyone configured RT to use client certs for auth instead of cookies, or
HTTP auth?

Jay

___
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