Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Michael Mollard
Mike,
As part of my troubleshooting process, I have tried to wipe my rt installation 
and restart (I'm testing on a local VM, so not a  big deal).
I have deleted my <$RT_HOME> (/srv/www/vhosts/rt.mbc.qld.edu.au/*).  Is that 
enough to reinstall from scratch or are there other things which should be 
'tidied up'?

My Reinstall Process:
-installed rt3.8.1 as per instructions
-make initialize-database
-restarted apache2

(tested login as root/password, all works ok)

-Installed RT-Authen-ExternalAuth-0.06_02
-restarted apache
(left my RT_SiteConfig.pm unmodified to test 'local only' root/password again - 
still works fine)
Modified my RT_SiteConif.pm file with :

Set( @Plugins,(qw(RT::Authen::ExternalAuth)));

Set($ExternalAuthPriority,  [ 'My_LDAP' ] );
Set($ExternalInfoPriority,  [ 'My_LDAP' ] );
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers,0);
Set($ExternalSettings,  {   'My_LDAP'   =>  {   
'type'  
=>  'ldap',
'auth'  
=>  1,
'info'  
=>  1,
'server'
=>  'ldap.mbc.qld.edu.au',
#'user' 
=>  'cn=ldaphelpdesk,ou=ldap,ou=lab,o=mbc',
#'pass' 
=>  '',
'base'  
=>  'ou=lab,o=mbc',
'filter'
=>  '(objectClass=Person)',
#'d_filter' 
 =>  '(FILTER_STRING)',
'tls'   
=>  0,
'net_ldap_args' 
=> [version =>  3   ],
'group' 
=>  'cn=GRP_Staff,ou=lab,o=mbc',
'group_attr'
=>  'groupMembership',
'attr_match_list'   
=> ['Name',

'EmailAddress' 

],
'attr_map'  
=>  {   'Name' => 'cn',

'EmailAddress' => 'mail',

'Organization' => 'l',

'RealName' => 'cn',

'ExternalAuthId' => 'cn',

#'Gecos' => 'sAMAccountName',

'WorkPhone' => 'telephoneNumber',

'Address1' => 'streetAddress',

'City' => 'l',

'State' => 'st',

'Zip' => 'postalCode',

'Country' => 'co'

}
}
}
);

-restarted apache
-tested root/password (which should work as a local account)
I get this error in the browser:
RT::User::UpdateFromExternal Unimplemented in HTML::Mason::Commands. 
(/srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth/html/Callbacks/ExternalAuth/autohandler/Auth
 line 73)

If I go to http://rt.mbc.qld.edu.au (my default rt home), I go straight to the 
dashboard, already logged in as root.  
 
If I logout and try and login as a valid ldap user (bogust/bogust - see log 
below) I get this error in the browser:
Can't call method "Disabled" on an undefined value at 
/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/User_Overlay.pm line 971.
(If I go to http://rt.mbc.qld.edu.au ( http://rt.mbc.qld.edu.au/ ) (my default 
rt home), I get the login screen)


 
This i

Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Kevin Falcone

On Oct 22, 2008, at 5:20 PM, Michael Mollard wrote:

> Before I installed v .06 I 'rm-Rf /srv/www/vhosts/rt.mbc.qld.edu.au/ 
> local/plugins/RT-Authen-ExternalAuth', then did a full install of  
> the module.
> But just to be certain, I removed the 2 files you mentioned, and  
> then did a complete re-install of the RT-Authen-ExternalAuth module.

The bug was it installed into plugins AND local rather than just  
plugins/

> Same error in rt.log file.
> Same error in browser, except different line number:
> Can't call method "Disabled" on an undefined value at /srv/www/ 
> vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/User_Overlay.pm line 971.

That is new and exciting.
Try turning on LogStackTraces in your config so we can see what is  
calling IsPassword
incorrectly.

-kevin

 Kevin Falcone <[EMAIL PROTECTED]> 23/10/2008 9:46 am >>>
>
> On Oct 22, 2008, at 4:10 PM, Michael Mollard wrote:
>
>> Thanks for the assistance.
>> I have downloaded and installed the latest version of RT-Authen-
>> ExternalAuth-0.06_02, with RT 3.8.1(latest)
>> I seem to have gotten a step further, but still have some issues.
>>
>> When I try and authenticate with an ldap account, my browser reports:
>> "Can't call method "Disabled" on an undefined value at /srv/www/
>> vhosts/rt.mbc.qld.edu.au/bin/../local/lib/RT/User_Vendor.pm line
>> 351, line 273."
>
> I assume you previously installed 0.05?
> You should go delete /srv/www/vhosts/rt.mbc.qld.au/local/lib/RT/
> User_vendor.pm and RT/Authen/ExternalAuth.pm
>
> 0.05 had a bug where .pm files were being double installed
>
> 0.06_02 contains a patch for this bug
>
> -kevin
>
>>
>>
>> and my ./var/log/rt.log says:
>> [Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn't,
>> as you didn't specify an object type and id (/srv/www/vhosts/
>> rt.mbc.qld.edu.au/bin/../lib/RT/Record.pm:1439)
>> [Thu Oct 23 00:11:07 2008] [error]: Couldn't get principal for not
>> loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/
>> User_Overlay.pm:1113)
>>
>> It seems to be connectiong to my ldap, (which was more than it was
>> doing) but fails soon after.  Am I missing something?
>>
>> Here is my RT_Siteconfig.pm
>>
>> Set( $rtname, 'mbc.qld.edu.au');
>> Set($LogToSyslog, 'debug');
>> Set($LogToScreen, 'debug');
>> Set($LogToFile  , 'debug');
>> Set($LogDir, 'var/log');
>> Set($LogToFileNamed , "rt.log");#log to rt.log
>>
>> #Set(@Plugins,(qw(Extension::QuickDelete)));
>> Set( @Plugins, qw(RT::Authen::ExternalAuth) );
>> Set($ExternalAuthPriority,  [ 'My_LDAP' ] );
>> Set($ExternalInfoPriority,  [ 'My_LDAP' ] );
>> Set($ExternalServiceUsesSSLorTLS,0);
>> Set($AutoCreateNonExternalUsers,0);
>> Set($ExternalSettings,  {   'My_LDAP'   =>  {
>>
>> 'type'  =>  'ldap',
>>
>> 'auth'  =>  1,
>>
>> 'info'  =>  1,
>>
>> 'server'=>  'ldap.mbc.qld.edu.au',
>>
>> #'user' =>  'ldaphelpdesk',
>>
>> #'pass' =>  'rt_ldap_password',
>>
>> 'base'  =>  'ou=lab,o=mbc',
>>
>> 'filter'=>  '(objectClass=inetOrgPerson)',
>>
>> #'d_filter'  =>  '(FILTER_STRING)',
>>
>> 'tls'   =>  0,
>>
>> 'net_ldap_args' => [version =>  3   ],
>>
>> 'group' =>  'cn=GRP_Staff,ou=lab,o=mbc',
>>
>> 'group_attr'=>  'groupMembership',
>>
>> 'attr_match_list'   => ['Name',
>>  
>>  'EmailAddress
>> ',
>>  
>>  #'RealName
>> ',
>>  
>>  #'WorkPhone
>> ',
>>  
>>  #'Address2
>> '
>>  
>> ],
>>
>> 'attr_map'  =>  {   'Name' => 'cn',
>>  
>>  'EmailAddress
>> ' => 'mail',
>>  
>>  'Organization
>> ' => 'l',
>>  
>>  'RealName
>> ' => 'cn',
>>  
>>  #'ExternalAuthId
>> ' => 'sAMAccountName',
>>  
>>  #'Gecos
>> ' => 'sAMAccountName',
>>  
>>  'WorkPhone
>> ' => 'telephoneNumber',
>>  
>>  'Address1
>

Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Michael Mollard
Before I installed v .06 I 'rm-Rf 
/srv/www/vhosts/rt.mbc.qld.edu.au/local/plugins/RT-Authen-ExternalAuth', then 
did a full install of the module.

But just to be certain, I removed the 2 files you mentioned, and then did a 
complete re-install of the RT-Authen-ExternalAuth module.

Same error in rt.log file.
Same error in browser, except different line number:
Can't call method "Disabled" on an undefined value at 
/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/User_Overlay.pm line 971.

Thanks for all the prompt assistance.

Michael.


Michael Mollard
Network Administrator
Moreton Bay College
[EMAIL PROTECTED]
http://www.mbc.qld.edu.au
Ph: (Direct) 07 3907 5712 / (Mob) 0417 631 801 
Fax: 07 3390 8919 ( http://www.mbc.qld.edu.au )


>>> Kevin Falcone <[EMAIL PROTECTED]> 23/10/2008 9:46 am >>>

On Oct 22, 2008, at 4:10 PM, Michael Mollard wrote:

> Thanks for the assistance.
> I have downloaded and installed the latest version of RT-Authen- 
> ExternalAuth-0.06_02, with RT 3.8.1(latest)
> I seem to have gotten a step further, but still have some issues.
>
> When I try and authenticate with an ldap account, my browser reports:
> "Can't call method "Disabled" on an undefined value at /srv/www/ 
> vhosts/rt.mbc.qld.edu.au/bin/../local/lib/RT/User_Vendor.pm line  
> 351, line 273."

I assume you previously installed 0.05?
You should go delete /srv/www/vhosts/rt.mbc.qld.au/local/lib/RT/ 
User_vendor.pm and RT/Authen/ExternalAuth.pm

0.05 had a bug where .pm files were being double installed

0.06_02 contains a patch for this bug

-kevin

>
>
> and my ./var/log/rt.log says:
> [Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn't,  
> as you didn't specify an object type and id (/srv/www/vhosts/ 
> rt.mbc.qld.edu.au/bin/../lib/RT/Record.pm:1439)
> [Thu Oct 23 00:11:07 2008] [error]: Couldn't get principal for not  
> loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/ 
> User_Overlay.pm:1113)
>
> It seems to be connectiong to my ldap, (which was more than it was  
> doing) but fails soon after.  Am I missing something?
>
> Here is my RT_Siteconfig.pm
>
> Set( $rtname, 'mbc.qld.edu.au');
> Set($LogToSyslog, 'debug');
> Set($LogToScreen, 'debug');
> Set($LogToFile  , 'debug');
> Set($LogDir, 'var/log');
> Set($LogToFileNamed , "rt.log");#log to rt.log
>
> #Set(@Plugins,(qw(Extension::QuickDelete)));
> Set( @Plugins, qw(RT::Authen::ExternalAuth) );
> Set($ExternalAuthPriority,  [ 'My_LDAP' ] );
> Set($ExternalInfoPriority,  [ 'My_LDAP' ] );
> Set($ExternalServiceUsesSSLorTLS,0);
> Set($AutoCreateNonExternalUsers,0);
> Set($ExternalSettings,  {   'My_LDAP'   =>  {
> 
> 'type'  =>  'ldap',
> 
> 'auth'  =>  1,
> 
> 'info'  =>  1,
> 
> 'server'=>  'ldap.mbc.qld.edu.au',
> 
> #'user' =>  'ldaphelpdesk',
> 
> #'pass' =>  'rt_ldap_password',
> 
> 'base'  =>  'ou=lab,o=mbc',
> 
> 'filter'=>  '(objectClass=inetOrgPerson)',
> 
> #'d_filter'  =>  '(FILTER_STRING)',
> 
> 'tls'   =>  0,
> 
> 'net_ldap_args' => [version =>  3   ],
> 
> 'group' =>  'cn=GRP_Staff,ou=lab,o=mbc',
> 
> 'group_attr'=>  'groupMembership',
> 
> 'attr_match_list'   => ['Name',
>   
>  'EmailAddress 
> ',
>   
>  #'RealName 
> ',
>   
>  #'WorkPhone 
> ',
>   
>  #'Address2 
> '
>   
> ],
> 
> 'attr_map'  =>  {   'Name' => 'cn',
>   
>  'EmailAddress 
> ' => 'mail',
>

[rt-users] preventing correspondance for some queues

2008-10-22 Thread mcr

I have some queues that I have created that will get tickets opened
to deal with.  I am pointing cron and other daemons' warnings
at these queues.  I don't want any response.

This action is stock scrip#27.
It appears that the only way to disable this for the 2 queues
involves is to remove it for all queues, and then add it to all other
queues.

Or is there another way?

-- 
Michael Richardson <[EMAIL PROTECTED]>
Director -- Consumer Desktop Development, Simtone Corporation, Ottawa, Canada
Personal: http://www.sandelman.ca/mcr/ 

SIMtone Corporation fundamentally transforms computing into simple,
secure, and very low-cost network-provisioned services pervasively
accessible by everyone.  Learn more at www.simtone.net and www.SIMtoneVDU.com 




___
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


Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Kevin Falcone

On Oct 22, 2008, at 4:47 PM, Eli Altman wrote:

> This sounds like you need the User_Vendor patch.. I know it's been  
> known to work with earlier versions of the ExternalAuth, but is it  
> still needed for the newest version?
>
> http://www.gossamer-threads.com/lists/rt/users/77139?search_string=ldap%25
>
> I imagine Mike will be back with words of advice, but may as well  
> make a backup and give this a shot.

For the archives:

This patch has been applied to 0.06_02 but if you have an old version  
laying around
in local/ you may need to delete it.

I'm checking in an update to the README which will be in the next  
release

-kevin

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> ] On Behalf Of Michael Mollard
> Sent: Wednesday, October 22, 2008 4:10 PM
> To: [EMAIL PROTECTED]; RT Users
> Subject: Re: [rt-users] Ldap Authentication setup question
>
> Thanks for the assistance.
> I have downloaded and installed the latest version of RT-Authen- 
> ExternalAuth-0.06_02, with RT 3.8.1(latest)
> I seem to have gotten a step further, but still have some issues.
>
> When I try and authenticate with an ldap account, my browser reports:
> "Can't call method "Disabled" on an undefined value at /srv/www/ 
> vhosts/rt.mbc.qld.edu.au/bin/../local/lib/RT/User_Vendor.pm line  
> 351, line 273."
>
> and my ./var/log/rt.log says:
> [Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn't,  
> as you didn't specify an object type and id (/srv/www/vhosts/ 
> rt.mbc.qld.edu.au/bin/../lib/RT/Record.pm:1439)
> [Thu Oct 23 00:11:07 2008] [error]: Couldn't get principal for not  
> loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/ 
> User_Overlay.pm:1113)
>
> It seems to be connectiong to my ldap, (which was more than it was  
> doing) but fails soon after.  Am I missing something?
>
> Here is my RT_Siteconfig.pm
>
> Set( $rtname, 'mbc.qld.edu.au');
> Set($LogToSyslog, 'debug');
> Set($LogToScreen, 'debug');
> Set($LogToFile  , 'debug');
> Set($LogDir, 'var/log');
> Set($LogToFileNamed , "rt.log");#log to rt.log
>
> #Set(@Plugins,(qw(Extension::QuickDelete)));
> Set( @Plugins, qw(RT::Authen::ExternalAuth) );
> Set($ExternalAuthPriority,  [ 'My_LDAP' ] );
> Set($ExternalInfoPriority,  [ 'My_LDAP' ] );
> Set($ExternalServiceUsesSSLorTLS,0);
> Set($AutoCreateNonExternalUsers,0);
> Set($ExternalSettings,  {   'My_LDAP'   =>  {
> 
> 'type'  =>  'ldap',
> 
> 'auth'  =>  1,
> 
> 'info'  =>  1,
> 
> 'server'=>  'ldap.mbc.qld.edu.au',
> 
> #'user' =>  'ldaphelpdesk',
> 
> #'pass' =>  'rt_ldap_password',
> 
> 'base'  =>  'ou=lab,o=mbc',
> 
> 'filter'=>  '(objectClass=inetOrgPerson)',
> 
> #'d_filter'  =>  '(FILTER_STRING)',
> 
> 'tls'   =>  0,
> 
> 'net_ldap_args' => [version =>  3   ],
> 
> 'group' =>  'cn=GRP_Staff,ou=lab,o=mbc',
> 
> 'group_attr'=>  'groupMembership',
> 
> 'attr_match_list'   => ['Name',
>   
>  'EmailAddress 
> ',
>   
>  #'RealName 
> ',
>   
>  #'WorkPhone 
> ',
>   
>  #'Address2 
> '
>   
> ],
> 
> 'attr_map'  =>  {   'Name' => 'cn',
>   
>  'EmailAddress 
> ' => 'mail',
>   
>  'Organization 
> ' => 'l',
>   
>  'RealName 
> ' => 'cn',

Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Eli Altman
This sounds like you need the User_Vendor patch.. I know it's been known to 
work with earlier versions of the ExternalAuth, but is it still needed for the 
newest version?

http://www.gossamer-threads.com/lists/rt/users/77139?search_string=ldap%25

I imagine Mike will be back with words of advice, but may as well make a backup 
and give this a shot.


Elias

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Mollard
Sent: Wednesday, October 22, 2008 4:10 PM
To: [EMAIL PROTECTED]; RT Users
Subject: Re: [rt-users] Ldap Authentication setup question

Thanks for the assistance.
I have downloaded and installed the latest version of 
RT-Authen-ExternalAuth-0.06_02, with RT 3.8.1(latest)
I seem to have gotten a step further, but still have some issues.

When I try and authenticate with an ldap account, my browser reports:
"Can't call method "Disabled" on an undefined value at 
/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../local/lib/RT/User_Vendor.pm line 351, 
line 273."

and my ./var/log/rt.log says:
[Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn't, as you 
didn't specify an object type and id 
(/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/Record.pm:1439)
[Thu Oct 23 00:11:07 2008] [error]: Couldn't get principal for not loaded 
object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/User_Overlay.pm:1113)

It seems to be connectiong to my ldap, (which was more than it was doing) but 
fails soon after.  Am I missing something?

Here is my RT_Siteconfig.pm

Set( $rtname, 'mbc.qld.edu.au');
Set($LogToSyslog, 'debug');
Set($LogToScreen, 'debug');
Set($LogToFile  , 'debug');
Set($LogDir, 'var/log');
Set($LogToFileNamed , "rt.log");#log to rt.log

#Set(@Plugins,(qw(Extension::QuickDelete)));
Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($ExternalAuthPriority,  [ 'My_LDAP' ] );
Set($ExternalInfoPriority,  [ 'My_LDAP' ] );
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers,0);
Set($ExternalSettings,  {   'My_LDAP'   =>  {
'type'  
=>  'ldap',
'auth'  
=>  1,
'info'  
=>  1,
'server'
=>  'ldap.mbc.qld.edu.au',
#'user' 
=>  'ldaphelpdesk',
#'pass' 
=>  'rt_ldap_password',
'base'  
=>  'ou=lab,o=mbc',
'filter'
=>  '(objectClass=inetOrgPerson)',
#'d_filter' 
 =>  '(FILTER_STRING)',
'tls'   
=>  0,
'net_ldap_args' 
=> [version =>  3   ],
'group' 
=>  'cn=GRP_Staff,ou=lab,o=mbc',
'group_attr'
=>  'groupMembership',
'attr_match_list'   
=> ['Name',

'EmailAddress',

#'RealName',

#'WorkPhone',

#'Address2'

   ],
'attr_map'  
=>  {   'Name' => 'cn',

'EmailAddress' => 'mail',

'Organization' => 'l',

'RealName' => 'cn',

#'ExternalAuthId' => 'sAMAccountName',

#'Gecos' => 'sAMAccountName',

'WorkPhone' => 'telephoneNumber',

'Address1' => 's

Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Kevin Falcone

On Oct 22, 2008, at 4:10 PM, Michael Mollard wrote:

> Thanks for the assistance.
> I have downloaded and installed the latest version of RT-Authen- 
> ExternalAuth-0.06_02, with RT 3.8.1(latest)
> I seem to have gotten a step further, but still have some issues.
>
> When I try and authenticate with an ldap account, my browser reports:
> "Can't call method "Disabled" on an undefined value at /srv/www/ 
> vhosts/rt.mbc.qld.edu.au/bin/../local/lib/RT/User_Vendor.pm line  
> 351, line 273."

I assume you previously installed 0.05?
You should go delete /srv/www/vhosts/rt.mbc.qld.au/local/lib/RT/ 
User_vendor.pm and RT/Authen/ExternalAuth.pm

0.05 had a bug where .pm files were being double installed

0.06_02 contains a patch for this bug

-kevin

>
>
> and my ./var/log/rt.log says:
> [Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn't,  
> as you didn't specify an object type and id (/srv/www/vhosts/ 
> rt.mbc.qld.edu.au/bin/../lib/RT/Record.pm:1439)
> [Thu Oct 23 00:11:07 2008] [error]: Couldn't get principal for not  
> loaded object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/ 
> User_Overlay.pm:1113)
>
> It seems to be connectiong to my ldap, (which was more than it was  
> doing) but fails soon after.  Am I missing something?
>
> Here is my RT_Siteconfig.pm
>
> Set( $rtname, 'mbc.qld.edu.au');
> Set($LogToSyslog, 'debug');
> Set($LogToScreen, 'debug');
> Set($LogToFile  , 'debug');
> Set($LogDir, 'var/log');
> Set($LogToFileNamed , "rt.log");#log to rt.log
>
> #Set(@Plugins,(qw(Extension::QuickDelete)));
> Set( @Plugins, qw(RT::Authen::ExternalAuth) );
> Set($ExternalAuthPriority,  [ 'My_LDAP' ] );
> Set($ExternalInfoPriority,  [ 'My_LDAP' ] );
> Set($ExternalServiceUsesSSLorTLS,0);
> Set($AutoCreateNonExternalUsers,0);
> Set($ExternalSettings,  {   'My_LDAP'   =>  {
> 
> 'type'  =>  'ldap',
> 
> 'auth'  =>  1,
> 
> 'info'  =>  1,
> 
> 'server'=>  'ldap.mbc.qld.edu.au',
> 
> #'user' =>  'ldaphelpdesk',
> 
> #'pass' =>  'rt_ldap_password',
> 
> 'base'  =>  'ou=lab,o=mbc',
> 
> 'filter'=>  '(objectClass=inetOrgPerson)',
> 
> #'d_filter'  =>  '(FILTER_STRING)',
> 
> 'tls'   =>  0,
> 
> 'net_ldap_args' => [version =>  3   ],
> 
> 'group' =>  'cn=GRP_Staff,ou=lab,o=mbc',
> 
> 'group_attr'=>  'groupMembership',
> 
> 'attr_match_list'   => ['Name',
>   
>  'EmailAddress 
> ',
>   
>  #'RealName 
> ',
>   
>  #'WorkPhone 
> ',
>   
>  #'Address2 
> '
>   
> ],
> 
> 'attr_map'  =>  {   'Name' => 'cn',
>   
>  'EmailAddress 
> ' => 'mail',
>   
>  'Organization 
> ' => 'l',
>   
>  'RealName 
> ' => 'cn',
>   
>  #'ExternalAuthId 
> ' => 'sAMAccountName',
>   
>  #'Gecos 
> ' => 'sAMAccountName',
>   
>  'WorkPhone 
> ' => 'telephoneNumber',
>   
>  'Address1 
> ' => 'streetAddress',
> 

Re: [rt-users] RT scrip question

2008-10-22 Thread Kenneth Crocker
Ruslan,


Thanks. That did it.

Kenn
LBNL

On 10/21/2008 8:31 PM, Ruslan Zakirov wrote:
> Condition: On Create
> Action Code:
> 
> $self->TicketObj->Owner - returns owner id
> $self->TicketObj->OwnerObj - returns owner as RT::User object
> 
> On Wed, Oct 22, 2008 at 12:58 AM, Kenneth Crocker <[EMAIL PROTECTED]> wrote:
>> To list,
>>
>>
>>I am trying to capture the ticket owner as the ticket is created (via
>> Web) and I'm not sure of how to code that. I know how to ensure that I'm
>> checking a WebUI transaction and the transaction creator, but don't know
>> how to get the ticket owner on creation. Help?? Thanks.
>>
>>
>> Kenn
>> LBNL
>>
>> ___
>> 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
>>
> 
> 
> 

___
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


Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Michael Mollard
Thanks for the assistance.
I have downloaded and installed the latest version of 
RT-Authen-ExternalAuth-0.06_02, with RT 3.8.1(latest)
I seem to have gotten a step further, but still have some issues.

When I try and authenticate with an ldap account, my browser reports:
"Can't call method "Disabled" on an undefined value at 
/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../local/lib/RT/User_Vendor.pm line 351, 
line 273."

and my ./var/log/rt.log says:
[Thu Oct 23 00:11:07 2008] [warning]: Transaction->Create couldn't, as you 
didn't specify an object type and id 
(/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/Record.pm:1439)
[Thu Oct 23 00:11:07 2008] [error]: Couldn't get principal for not loaded 
object (/srv/www/vhosts/rt.mbc.qld.edu.au/bin/../lib/RT/User_Overlay.pm:1113)

It seems to be connectiong to my ldap, (which was more than it was doing) but 
fails soon after.  Am I missing something?

Here is my RT_Siteconfig.pm

Set( $rtname, 'mbc.qld.edu.au');
Set($LogToSyslog, 'debug');
Set($LogToScreen, 'debug');
Set($LogToFile  , 'debug');
Set($LogDir, 'var/log');
Set($LogToFileNamed , "rt.log");#log to rt.log

#Set(@Plugins,(qw(Extension::QuickDelete)));
Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($ExternalAuthPriority,  [ 'My_LDAP' ] );
Set($ExternalInfoPriority,  [ 'My_LDAP' ] );
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers,0);
Set($ExternalSettings,  {   'My_LDAP'   =>  {
'type'  
=>  'ldap',
'auth'  
=>  1,
'info'  
=>  1,
'server'
=>  'ldap.mbc.qld.edu.au',
#'user' 
=>  'ldaphelpdesk',
#'pass' 
=>  'rt_ldap_password',
'base'  
=>  'ou=lab,o=mbc',
'filter'
=>  '(objectClass=inetOrgPerson)',
#'d_filter' 
 =>  '(FILTER_STRING)',
'tls'   
=>  0,
'net_ldap_args' 
=> [version =>  3   ],
'group' 
=>  'cn=GRP_Staff,ou=lab,o=mbc',
'group_attr'
=>  'groupMembership',
'attr_match_list'   
=> ['Name',

'EmailAddress',

#'RealName',

#'WorkPhone',

#'Address2'

   ],
'attr_map'  
=>  {   'Name' => 'cn',

'EmailAddress' => 'mail',

'Organization' => 'l',

'RealName' => 'cn',

#'ExternalAuthId' => 'sAMAccountName',

#'Gecos' => 'sAMAccountName',

'WorkPhone' => 'telephoneNumber',

'Address1' => 'streetAddress',

'City' => 'l',

'State' => 'st',

'Zip' => 'postalCode',

'Country' => 'co'

}
   

Re: [rt-users] RT interface not working

2008-10-22 Thread Percynski, Fred
I was able to fix this problem on my RT.
FWIW if anyone else is still having a problem:
When I tried to use the CLI /opt/rt3/bin/rt it kept giving me errors
related to the Util.pm file.
I deleted the file
/usr/lib/perl5/5.8.8/i386-linux-thread-multi/Scalar/Util.pm, then
downloaded Scalar::Util and manually installed it.
Restarted httpd and now everything is back to normal.-
The information contained in this message is privileged and confidential. It is 
intended only for the recipient or entity listed above. If the reader of this 
message is not the intended recipient, you are hereby notified that any 
dissemination, distribution, or copying of this message is strictly prohibited. 
If you have received this message in error, please notify the sender 
immediately by replying to the message and promptly deleting it from your 
computer. Thank you. Health Data Management Solutions.

___
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


Re: [rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes intoinfinite loop.

2008-10-22 Thread Golemon, Buck
Good call. Upgrading mysql from 4 to 5 fixed all the below issues. 


--Buck

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Ruslan Zakirov
Sent: Tuesday, October 21, 2008 9:42 PM
To: Golemon, Buck
Cc: RT Users List; Descamps, Gilles-Eric; Lee, Mark (SV)
Subject: Re: [rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes
intoinfinite loop.

The log says that mysql closed connection without any reason. Such
errors happen when mysql has a bug, mysql client libraries has a bug
or DBD::mysql perl module or DBI perl module. Provide versions of
these libraries.

You should start from DBD::mysql and DBI. Install newer DBI which is
tested much. Play with different versions of DBD::mysql close to the
latest. Always run tests before installing these modules and report
errors using http://rt.cpan.org.

On Wed, Oct 15, 2008 at 3:25 AM, Golemon, Buck <[EMAIL PROTECTED]>
wrote:
> Did I ask the question the wrong way?
> At this point, any ideas are appreciated.
>
> Has anyone successfully upgraded their database from <=3.2.2 to 3.8.1?
>
> --Buck
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
Golemon,
> Buck
> Sent: Monday, October 13, 2008 6:38 PM
> To: RT Users List
> Cc: Descamps, Gilles-Eric; Lee, Mark (SV)
> Subject: [rt-users] RT Upgrade 3.2.2 -> 3.8.1: HTML::Mason goes
> intoinfinite loop.
>
> The installation works just find with a pristine database, but when I
> copy over my old database and follow the instructions at
> UPGRADING.mysql, I get this error: (see attached). This went on for
two
> million lines before I stopped the server. It finally gets into a
> three-line loop like this: (again, see attached).
>
>
>
> I got some errors from schema.mysql-4.0-4.1.pl like this:
> # perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 rt_user rt_pass >
> sql.queries
> Use of uninitialized value in numeric gt (>) at
> etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
> Use of uninitialized value in numeric gt (>) at
> etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
> Use of uninitialized value in numeric gt (>) at
> etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
> Use of uninitialized value in numeric gt (>) at
> etc/upgrade/schema.mysql-4.0-4.1.pl line 310.
>
>
> I had to replace all the occurrences (three total) of 'BLOB CHARACTER
> SET utf8' with just 'BLOB', since BLOB doesn't have a character set,
and
> this is a syntax error in mysql.
>
>
> I also dropped and recreated the sessions table because it was
> corrupted. I did it like this:
> drop table sessions;
> CREATE TABLE `sessions` (
>  `id` varchar(32) NOT NULL default '',
>  `a_session` longblob NOT NULL,
>  `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update
> CURRENT_TIMESTAMP,
>  PRIMARY KEY  (`id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>
>
> Thanks in advance,
> --Buck
>
> ___
> 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
>



-- 
Best regards, Ruslan.


___
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] Version 3.8.1 upgrade - UPGRADING.mysql file clarification

2008-10-22 Thread Todd Herr
Hello.

I'm still in the planning stages of an upgrade from 3.6.0, with MySQL 
5.0.22, to 3.8.1, and I'm a bit confused by contents of the 
UPGRADING.mysql file.

The file includes the line:

If you're upgrading RT from versions prior to 3.8.0 then you MUST follow
instructions below.

but those instructions all seem to speak to an upgrade of MySQL from 4.0 
to 4.1, and I'm already running MySQL 5.0.22:


1) Backup RT database. It's really good to test that you can restore from
this backup.

2) Follow instructions in the README file to the step 7).

3) Apply changes described in the seven step, but only up to version 3.8.0.

4) Apply mysql 4.0->4.1 schema changes. RT tarball has script
etc/upgrade/schema.mysql-4.0-4.1.pl that generates SQL queries to 
upgrade schema
  of
the DB. Run it:

 perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries

5) Check sanity of sql queries yourself or consult with your DBA

6) Apply queries. Note that this step can take a while. May require 
additional
space on your hard drive comparable with size of your tables.

 mysql -u root -p rt3 < sql.queries


So, my question is, do I have to follow the instructions in the 
UPGRADING.mysql file, given that I'm already running MySQL 5.0.22?

-- 
Todd Herr

___
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


Re: [rt-users] Display the name of the Requestor in the Reply/Comment composition screen somehow?

2008-10-22 Thread Toby Darling
Hi Rainer

> one thing that new users esp. seem to be missing is the possibility to
> display the name of the requestor on the screen where you compose the mail.
> Sometimes, our staff creates tickets on customer's behalf, sometimes not.
> So, you've got to watch when you type a "reply" and when it's just a
> "comment".

I don't know which version of RT you're using, but with 3.6.1 I've done 
this. Using your local copy of .../html/Ticket/Update.html add

  %# If we're replying, show who the requestors are.
  % if ( ! $ARGS{'UpdateType'} && $ResponseDefault ) {
  <% $TicketObj->RequestorAddresses() %>
  % }

after the '' of the $CanComment/$CanRespond block.

There's a drawback - it's not dynamic, if they change the Reply type to 
Correspond, the requestors are still listed, and if they start as 
Comment and change it to Reply, they're not listed.

Cheers
Toby


LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform [EMAIL PROTECTED] and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.
___
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] Display the name of the Requestor in the Reply/Comment composition screen somehow?

2008-10-22 Thread Rainer Duffner
Hi,

one thing that new users esp. seem to be missing is the possibility to
display the name of the requestor on the screen where you compose the mail.
Sometimes, our staff creates tickets on customer's behalf, sometimes not.
So, you've got to watch when you type a "reply" and when it's just a
"comment".

Can this be done relatively easily?

Searching the wiki didn't give any obvious candidates...



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


Re: [rt-users] Ldap Authentication setup question

2008-10-22 Thread Mike Peachey
Michael Mollard wrote:
> Hi all,
> I'm an RT newbie, so be gentle with me.
> 
> I have setup a functioning RT system (on SLES10sp2)

What version of RT?

> I have installed the RT::Authen::ExternalAuth 0.5.  This creates a 
> <$RT_HOME>/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm
> I have edited that file with the correct site-specific ldap stuff.  
> 
> Now, what do I need to add to my <$RT_Home>/etc/RT_SiteConfig.pm to activate 
> the LDAP stuff?  Are there any other changes needed?

The file
$RTHOME/local/plugins/RT-Authen-ExternalAuth/etc/RT_SiteConfig.pm is not
part of the installation, it simply contains examples for you to paste
into your $RTHOME/etc/RT_SiteConfig.pm file.

You can alternatively choose to put a line in your RT_SiteConfig to
"include" the example file instead of just copying the lines out of it.

> The wiki articles (http://wiki.bestpractical.com/view/ExternalAuth) are 
> helpful to a point, but the Post-Install section (which is apparently the 
> crux of the setup) is too vague for an RT newbie.

I've just read it again and the instructions seem fairly clear. If you
can advise what is confusing to you, perhaps we can make it better.

If you are using RT 3.8.x then I recommend using this ExternalAuth
0.06_002 instead of 0.05 as it is a pre-release candidate for RT3.8
compatibility. 0.05 was written before 3.8 came out and so requires
tweaking before it will work properly with 3.8 and later.

You can get it here:
http://www.cpan.org/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0.06_02.tar.gz

-- 
Kind Regards,

__

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England
http://www.jennic.com
__
___
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


Re: [rt-users] Requestors recieving blank email after replying

2008-10-22 Thread Darren Azman
Using mysql

Darren Azman
Director of Business Development
stickK.com, LLC
tel: (866) 5-stickK ex.106
fax: (347) 584-1818


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zakirov
Sent: Wednesday, October 22, 2008 2:48 AM
To: Darren Azman
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Requestors recieving blank email after replying

Are you using Oracle DB?

On Wed, Oct 22, 2008 at 9:01 AM, Darren Azman <[EMAIL PROTECTED]> wrote:
> Thanks for the response.
>
> Blank emails means that as soon as the user sends a response to our email, 
> the user gets an auto-reply that has the same subject but a blank body other 
> than the previous correspondence. It's just an unnecessary email the user 
> receives each time they reply.
>
> I'm not sure what you mean by the "NotifyActor" option.
>
> Any additional thoughts?  Thanks.
>
> Darren Azman
> Director of Business Development
> stickK.com, LLC
> tel: (866) 5-stickK ex.106
> fax: (347) 584-1818
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ruslan Zakirov
> Sent: Tuesday, October 21, 2008 11:57 PM
> To: Darren Azman
> Cc: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] Requestors recieving blank email after replying
>
> On Wed, Oct 22, 2008 at 1:56 AM, Darren Azman <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>>
>>
>> We are having some trouble with using RT.  Here is what is happening:
>>
>>
>>
>> 1. Customer sends in email
>>
>> 2. Customer receives auto-reply from us
>>
>> 3. We reply to customer
>>
>> 4. Customer replies to our email
>>
>> 5. Immediately after customer replies to our email, they receive a blank
>> email from us with previous correspondence
>
> I don't understand what is "a blank email with previous
> correspondence". Can you describe it more?
>
>> There are 6 scrips we use (3 global and 3 queue specific)
>
> As I understand requestor is not an AdminCc of a queue or ticket, so
> most of scrips can be eliminated from the picture:
>
>> Scrip 3
>>
>> Condition: On Correspond
>> Action: Open Tickets
>> Template: Global template: Blank
>> Stage: TransactionCreate
>>
>> Scrip 5
>>
>> Condition: On Create
>> Action: Autoreply to Requestors
>> Template: Auto Reply
>> Stage: TransactionCreate
>>
>> Scrip 6
>>
>> Condition: On Correspond
>> Action: Notify Requestors
>> Template: Correspondence
>> Stage: TransactionCreate
>
> If NotifyActor option is set to true then requestor is notified with
> his own email back.
>
>> Please let me know if more info. is necessary.
>>
>>
>>
>> Thanks!!!
>>
>>
>>
>>
>>
>> Darren Azman
>>
>> Director of Business Development
>>
>> stickK.com, LLC
>>
>> tel: (866) 5-stickK ex.106
>>
>> fax: (347) 584-1818
>>
>>
>>
>>
>>
>> ___
>> 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
>>
>
>
>
> --
> Best regards, Ruslan.
>
>



-- 
Best regards, Ruslan.

___
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


Re: [rt-users] set Due depending on Created

2008-10-22 Thread Ruslan Zakirov
my $created = $self->TicketObj->CreatedObj;
$created->Add...;
my ($status, $msg) = $self->TicketObj->SetDue( $created->ISO );
$RT::Logger->error("Couldn't set due date: $msg") unless $status;

On Wed, Oct 22, 2008 at 5:46 PM, Violetta Wawryk
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> yes I am doing that already, but they add the days to the current date and
> not the Created date. Does anyone actually know how I can tell the perlthing
> to use the created date and not the current date. That would be very
> helpful.
>
> Thanks.
>
> Violetta
>
> Ruslan Zakirov schrieb:
>>
>> Look into RT::Date class - lib/RT/Date.pm there are several simple
>> methods to add time to the date.
>
> --
> Vorstand/Board of Management:
> Dr. Bernd Finkbeiner, Dr. Florian Geyer,
> Dr. Roland Niemeier, Dr. Arno Steitz, Dr. Ingrid Zech
> Vorsitzender des Aufsichtsrats/
> Chairman of the Supervisory Board:
> Prof. Dr. Hanns Ruder
> Sitz/Registered Office: Tuebingen
> Registergericht/Registration Court: Stuttgart
> Registernummer/Commercial Register No.: HRB 382196
>



-- 
Best regards, Ruslan.
___
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


Re: [rt-users] set Due depending on Created

2008-10-22 Thread Violetta Wawryk

Hi,

yes I am doing that already, but they add the days to the current date 
and not the Created date. Does anyone actually know how I can tell the 
perlthing to use the created date and not the current date. That would 
be very helpful.

Thanks.

Violetta

Ruslan Zakirov schrieb:
> Look into RT::Date class - lib/RT/Date.pm there are several simple
> methods to add time to the date.
-- 
Vorstand/Board of Management:
Dr. Bernd Finkbeiner, Dr. Florian Geyer,
Dr. Roland Niemeier, Dr. Arno Steitz, Dr. Ingrid Zech
Vorsitzender des Aufsichtsrats/
Chairman of the Supervisory Board:
Prof. Dr. Hanns Ruder
Sitz/Registered Office: Tuebingen
Registergericht/Registration Court: Stuttgart
Registernummer/Commercial Register No.: HRB 382196 

___
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] Using ENTRYAGGREGATOR

2008-10-22 Thread Roy El-Hames
Hi;

(rt-3.6.3/apache2/mysql5/DBix 1.49)

We have our table within RT called Circuits and using factory I created 
Circuit.pm and Circuits.pm then added Circuits_Overlay.pm for the 
various functions.
Selecting with $self->Limit( FIELD => 'x', VALUE => "$y" ); works fine 
however I am not having any luck selecting when using ENTRYAGGREGATOR => 
'OR'
example: (from a function in my Circuits_Overlay.pm)
$self->Limit (
FIELD => 'DistributionRouter',
   VALUE => $icon,
   OPERATOR => 'LIKE',
ENTRYAGGREGATOR => 'OR',
);
$self->Limit (
FIELD => 'AEndPop',
VALUE => $icon,
OPERATOR => 'LIKE',
 ENTRYAGGREGATOR => 'OR',
);
my $records = $self->RT::SearchBuilder::BuildSelectQuery();
returning either $records or $self gives nothing  ..Tailing 
rt.log i see $self is referenced correctly , but the sql statement 
defaulting to AND
   from rt.log:
   'subclauses' => {
   'generic_restrictions' => 
'(main.DistributionRouter LIKE \'%xyz%\') AND (main.AEndPop LIKE \'%xyz%\')'
   },

   How can i force the condition to 'OR', I looked through all the 
modules within RT and I could n't figure out how to define a default 
ENTRYAGGREGATOR ;
   #By the way commenting out the second limit statement  I get 
results back so the function is correct with the exception of the OR clause.
Any help would be appreciated;

Regards;
Roy

___
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


Re: [rt-users] RT-Extension-CommandByMail

2008-10-22 Thread Monti gmail
Amazing, you are right. the break line did the difference. thanks a lot
mate!
Works like a charm

Motti.

On Wed, Oct 22, 2008 at 1:03 AM, Eli Altman <[EMAIL PROTECTED]> wrote:

>  I know if you are sending RT mail and expect CommandByMail to pick up
> commands, you need a blank line between the actual email header and your
> commands.  I would check the headers in the ticket history to see if
> that's what's up.  Have you tried sending via an email client instead of
> command line?
>
>
>
> Elias
>
>
>
> *From:* [EMAIL PROTECTED] [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Monti gmail
> *Sent:* Tuesday, October 21, 2008 2:13 PM
> *To:* rt-users@lists.bestpractical.com
> *Subject:* Re: [rt-users] RT-Extension-CommandByMail
>
>
>
> Guys, any one familiar with this extension?
>
> I have RT 3.8.1 and installed RT-Extension-CommandByMail-0.
>
> 06 according to the manual with the required configuration.
> when I test it there is no error, the ticket is open and discards the
> fields I used as described RT-Extension-CommandByMail manual...
>
> I run the command:/opt/rt3/bin/RT-Extension-CommandByMail --queue myqueue
> --action correspond --url http://myrtserver
> from: [EMAIL PROTECTED]
> Subject: one more
> DependsOn: 62
> Owner: monti
>
> some text goes here
> ^D
>
> but the ticket is created without the "DependsOn" and "Owner" fields.
>
> how do I debug this?
>
>
>
>
>
> On Mon, Oct 20, 2008 at 11:42 AM, Monti gmail <[EMAIL PROTECTED]>
> wrote:
>
> Thanks, that helped. I don't have this error no more, but still I can't get
> RT-Extension-CommandByMail-0.06 to work.
> I have RT 3.8.1 and installed RT-Extension-CommandByMail-0.06 according to
> the manual with the required configuration.
> when I test it there is no error, the ticket is open and discrds the fields
> I used as described RT-Extension-CommandByMail manual...
>
> I run the command:/opt/rt3/bin/RT-Extension-CommandByMail --queue myqueue
> --action correspond --url http://myrtserver
> from: [EMAIL PROTECTED]
> Subject: one more
> DependsOn: 62
> Owner: monti
>
> some text goes here
> ^D
>
> but the ticket is created without the "DependsOn" and "Owner" fields.
>
> how do I debug this?
>
>
>
>  On Sun, Oct 19, 2008 at 8:37 PM, Joop van de Wege <
> [EMAIL PROTECTED]> wrote:
>
> Monti gmail wrote:
>
> Hi,
>
> I am trying to install RT-Extension-CommandByMail Extention and it does not
> work well.
>
> When I restart the webserver I get this error:
>
> Sun Oct 19 20:23:25 2008]* [error] Can't locate
> RT/Extension/CommandByMail.pm in @INC (@INC contains:*
> /opt/rt3/bin/../local/lib /opt/rt3/bin/../lib
> /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7
> /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5
> /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.7
> /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5
> /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi
> /usr/lib/perl5/5.8.8 . /etc/httpd) at /opt/rt3/bin/../lib/RT.pm line
> 595.\nCompilation failed in require at (eval 2) line 1.\n
>
>
> Any ideas?
>
> Yes, install rt-3.8.1 because it has a fix for the plugin paths which are
> broken in 3.8.0. See also the release notes for 3.8.1 which contain more
> info on other important things fixed in that version.
>
> Greetings,
>
> Joop
>
>
>
>
>
___
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