Re: [rt-users] rhel4 cpan problem
perl -MCPAN -e 'install Module::Signature' will run,.2006/10/26, Justin Zygmont [EMAIL PROTECTED]: I don;t remember running into this before, I am just using update3, soit should be fine..# perl -MCPAN -e 'i Module::Signature'Can't locate object method i via package Module::Signature at -e line 1. is there a reason for this?I can't seem to install Module::Buildwithout it.Thanks,___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-usersCommunity help: http://wiki.bestpractical.comCommercial support: [EMAIL PROTECTED]Discover RT's hidden secrets with RT Essentials from O'Reilly Media.Buy a copy at http://rtbook.bestpractical.com -- MFGTorsten Brummhttp://www.torsten-brumm.de ___ 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] Users, groups and queries
Hi All! I create a user named jimmo. I then click configuration- users-select users. I have a list of Privileged users but this user does not appear. Digging through the documentation I discovered that that Privileged users means that the person is not only allowed to create tickets but actually use the product. It seems that the only way to get access to a non-priviledged user is to search for it. When I try to search without any criterial, I get the list of Privileged users. Is there any way to get a list of all users? When assigning group membership, the only way you can do it is through the group. That is, if you have 10 groups and you create a new employee (Privileged user) you must go through all 10 group individually to assign this user to all of the groups. Is that correct? Is there any way of assigning all rights on a particular queue to a specific group? Is there any way of assigning blocks of rights (other than selecting them individually) For example, it does not seem logically to me that someone can be the owner of call without being able to modify it. So I would like to be able to allow a user to assign a block like administer ticket, which would allow me to do thing to the ticket. I assigned a ticket to a particular user and now want to assign it to a different user. However, I get the message You can only reassign tickets that you own or that are unowned. This is assigned to the queue Network and members of the Network group have rights to Steal and Take the ticket. In fact, the group has all rights to the queue. I am doing this as the root user, so my assumption would be that by default this user has the right to do everything. In any event, the root user has all rights to this queue. I have tried to assign the ticket to both root and a different user with the same results. I googled on this error and found many others with the same problem (mostly older version). One refences pointed me to the TicketOwnershipPermissions page on the RTWiki. Reading through the page seems to indicate that I should be able to re-assign the call, but still I cannot. When I click on either Tickets, New Query or Query Builder, I am brought to what appears to be the exact same screen. This does not seem logical to me. Why would there be three links, one right after the other that brings you to the same screen? Regards, Jim Mohr -- --- Be more concerned with your character than with your reputation. Your character is what you really are while your reputation is merely what others think you are. -- John Wooden --- Be sure to visit the Linux Tutorial: http://www.linux-tutorial.info --- NOTE: All messages sent to me in response to my posts to newsgroups, forums or mailing-lists are subject to reposting. ___ 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] Users, groups and queries
Try Rights Matrix, an extension of RT which aims to facilitate managing rights. You can install it as a module CPAN from http://search.cpan.org/~htchapman/RTx-RightsMatrix-0.03.00/lib/RTx/RightsMat rix.pm Best regards Marouane HIMDI group -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de James Mohr Envoyé : jeudi 26 octobre 2006 11:07 À : rt-users@lists.bestpractical.com Objet : [rt-users] Users, groups and queries Hi All! I create a user named jimmo. I then click configuration- users-select users. I have a list of Privileged users but this user does not appear. Digging through the documentation I discovered that that Privileged users means that the person is not only allowed to create tickets but actually use the product. It seems that the only way to get access to a non-priviledged user is to search for it. When I try to search without any criterial, I get the list of Privileged users. Is there any way to get a list of all users? When assigning group membership, the only way you can do it is through the group. That is, if you have 10 groups and you create a new employee (Privileged user) you must go through all 10 group individually to assign this user to all of the groups. Is that correct? Is there any way of assigning all rights on a particular queue to a specific group? Is there any way of assigning blocks of rights (other than selecting them individually) For example, it does not seem logically to me that someone can be the owner of call without being able to modify it. So I would like to be able to allow a user to assign a block like administer ticket, which would allow me to do thing to the ticket. I assigned a ticket to a particular user and now want to assign it to a different user. However, I get the message You can only reassign tickets that you own or that are unowned. This is assigned to the queue Network and members of the Network group have rights to Steal and Take the ticket. In fact, the group has all rights to the queue. I am doing this as the root user, so my assumption would be that by default this user has the right to do everything. In any event, the root user has all rights to this queue. I have tried to assign the ticket to both root and a different user with the same results. I googled on this error and found many others with the same problem (mostly older version). One refences pointed me to the TicketOwnershipPermissions page on the RTWiki. Reading through the page seems to indicate that I should be able to re-assign the call, but still I cannot. When I click on either Tickets, New Query or Query Builder, I am brought to what appears to be the exact same screen. This does not seem logical to me. Why would there be three links, one right after the other that brings you to the same screen? Regards, Jim Mohr -- --- Be more concerned with your character than with your reputation. Your character is what you really are while your reputation is merely what others think you are. -- John Wooden --- Be sure to visit the Linux Tutorial: http://www.linux-tutorial.info --- NOTE: All messages sent to me in response to my posts to newsgroups, forums or mailing-lists are subject to reposting. ___ 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
[rt-users] content search is a problem
Hi; the system is rt-3.6.1, mysql Distrib 5.1.12-beta, apach2 and mod_perl 2,dbix 1.45 the hardware web server intel 3.2 G processor 4G memory and 1 db server athlon 2 dual core 2.2 G proc and 16 G memory The system is optimised, and all functionality is fairly quick and smooth with the exception of content searches, a query like : SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.ObjectType = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ((main.Created '2006-07-14 23:00:00') AND (main.Queue != '132') AND (main.Status != 'rejected') AND (main.id '178000') AND ( (main.Subject LIKE '%my text%') OR ( (Attachments_2.Content LIKE '%mytext%') AND (Attachments_2.TransactionId = Transactions_1.id) AND (main.id = Transactions_1.ObjectId) ) ) ) just hangs and not return anything and in the process effect the performance for other users an explain of the query : -+ | id | select_type | table | type | possible_keys| key | key_len | ref | rows| Extra| ++-++---+--+---+-+---+-+--+ | 1 | SIMPLE | main | range | PRIMARY,Tickets1,Tickets3,Tickets4,Tickets5,Tickets6 | PRIMARY | 4 | NULL | 83328 | Using where | | 1 | SIMPLE | Transactions_1 | ref | PRIMARY,Transactions1,Transactions2 | Transactions1 | 66 | const | 1894666 | Using where; Using index | | 1 | SIMPLE | Attachments_2 | ALL | Attachments2 | NULL | NULL| NULL | 7134357 | Using where | I am not sure what can be done to improve this, we have 23 tickets and the attachments table have 1774299 rows and 5G in size, we partitioned the atatchments table into 10 row segments , which improved everything else but I feel slows the content searching, has anyone got any ideas?? any help will truly 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
[rt-users] Problem with 3.4.6 install on Ubuntu 6.06 - UNIVERSAL:rewuire
Although the installer told me all dependencies were satisfied, RT wouldnt work until I installed UNIVERSAL::require All seems find now. (Also see http://www.gossamer-threads.com/lists/rt/users/60767?do=post_view_threaded) Jason ___ 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] Problems with Ubuntu 6.06 repository install of RT - FIXED
I was having various miscellaneous problems with RT after doing an apt-get install. The errors were intermittent and seemed to be related to PERL modules. I installed from source, and the problems have gone away. Appears to be a problem with the install in the repository. ___ 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] Problem with 3.4.6 install on Ubuntu 6.06 - UNIVERSAL:rewuire
On Thursday 26 October 2006 12:16, Jason Doller wrote: Although the installer told me all dependencies were satisfied, RT wouldnt work until I installed UNIVERSAL::require All seems find now. (Also see http://www.gossamer-threads.com/lists/rt/users/60767?do=post_view_threaded) Jason Do we dare use the B word? Jim Mohr -- --- Be more concerned with your character than with your reputation. Your character is what you really are while your reputation is merely what others think you are. -- John Wooden --- Be sure to visit the Linux Tutorial: http://www.linux-tutorial.info --- NOTE: All messages sent to me in response to my posts to newsgroups, forums or mailing-lists are subject to reposting. ___ 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] Read only db for select (cluster on the cheap)
Hi;
RT 3.6.1 and and a pair of mysql 5 servers
I 've setup my system so it talks to a replicated db pair, where the
slave for read only operations, now most of my select actions
(Mytickets, MyRequests, Results.html) uses the slave server , so normal
ticketing operations are not effected by long searches, I am putting the
changes below to you smart people to see if anyone can spot something I
missed that may cause problems down the line , I would appreciate any ideas.
I have made the following changes:
in RT_SiteConfig added the following variables:
# {{{ Read Only Database Configuration
Set($RO_DatabaseHost , 'slave db');
#The name of the database user (inside the database)
Set($RO_DatabaseUser , 'rt user');
# Password the DatabaseUser should use to access the database
Set($RO_DatabasePassword , 'rt password');
# The name of the RT's database on your database server
Set($RO_DatabaseName , 'rt3');
Changed in SearchBuilder.pm, the _Init function to :
# {{{ sub _Init
sub _Init {
my $self = shift;
$RT::Logger-err(Getting to SearchBuilder.pm);
$self-{'user'} = shift;
my $ro_db = shift;
unless(defined($self-CurrentUser)) {
use Carp;
Carp::confess($self was created without a CurrentUser);
$RT::Logger-err($self was created without a CurrentUser);
return(0);
}
#CHANGE = USED FOR 2nd DB FOR SEARCH ELEMENTS
if ($ro_db) {
$RT::Logger-err(Getting to SearchBuilder.pm and highlted ro_db);
my $handle = DBIx::SearchBuilder::Handle-new();
$handle-Connect( 'Driver' = mysql,
'Database' = $RT::RO_DatabaseName,
'Host' = $RT::RO_DatabaseHost,
'User' = $RT::RO_DatabaseUser,
'Password' = $RT::RO_DatabasePassword);
$self-SUPER::_Init( 'Handle' = $handle);
# Setup al;ternate DB handle in config and use tha tisntead
} else {
$self-SUPER::_Init( 'Handle' = $RT::Handle);
}
## END CHANGE
}
# }}}
And applied changes to where ever there are read only operations (ie
MyTickets as example ) changing :
$MyTickets = new RT::Tickets ($session{'CurrentUser'});
to:
$MyTickets = RT::Tickets-new($session{'CurrentUser'},+ro);
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
[rt-users] Re: RT LDAP
On 10/23/06, Kyle Gordon [EMAIL PROTECTED] wrote: Hey Jim, Great work on the LDAP overlay for RT :-) Ive gotten it talking to eDirectory nicely now. Just two things though... :-p The documentation up on wiki.bestpractical.com suggests use the Set($foo, 'bar') style, yet I could only get it to work with $foo='bar'; style directives. Dunno if this is intended or not :-) Hmm. Works for me with RT 3.5.x and 3.6.x with Set(...) syntax. What version of RT are you using? Also, I'm trying to get it to recursively search our directory for the username that is entered. This is all well and good if I give it an OU to search in along with the organisation. However, if I leave the OU out and try to get it to search the entire organisation from the ground up, it fails. Any thoughts on this? I have users from several parts of the NHS in the facility here, and only about 75% of them are in the OU for the facility. It makes it a little troublesome to roll out a fantastic new ticketing system when some of them can't access it (although I'd prefer if they couldn't log any problems at all :-) Hmmm. I'm not an LDAP expert, so I've copied this to the list in hopes we'll hear from one. My first instinct is to be sure the limitation isn't on the directory server's part (e.g. they've limited the depth of a search to avoid lots of full-depth searches) but that's probably not right. --j -- Jim Meyer, Geek at Large[EMAIL PROTECTED] ___ 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] rhel4 cpan problem
# perl -MCPAN -e 'install Module::Signature' Can't locate object method install via package Module::Signature at -e line 1. Torsten Brumm wrote: perl -MCPAN -e 'install Module::Signature' will run,. 2006/10/26, Justin Zygmont [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: I don;t remember running into this before, I am just using update3, so it should be fine.. # perl -MCPAN -e 'i Module::Signature' Can't locate object method i via package Module::Signature at -e line 1. is there a reason for this? I can't seem to install Module::Build without it. Thanks, ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- MFG Torsten Brumm http://www.torsten-brumm.de ___ 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] Read only db for select (cluster on the cheap)
Not sure what you mean;I did not need to touch RT::Record .. do you mean
2 handles same db .. It'll have little or no benefit??
I understand what you mean about the speed of replication, in our case
its set to near enough real time, however with Create.html a/Update.html
and also Display.html I kept them reading from RW db in case of any
delay in replication, so basically anything that require to see the
changes immediately it will read from RW db.
Roy
Dmitri Tikhonov wrote:
This is an interesting approach. I was wondering if it would be
possible to do something like that without having to change higher-level
code.
For example (assuming we have two DB handles), all Set* operations would
use RW handle, while all Load* operations would use RO handle. I
haven't investigated this yet, but if we are lucky, all these changes
may be inside RT::Record (or directly in DBIx::SearchBuilder::Record).
Of course, there's also the question of how fast replication actually
happens...
Thoughts?
- Dmitri.
On Thu, 2006-10-26 at 16:45 +0100, Roy El-Hames wrote:
Hi;
RT 3.6.1 and and a pair of mysql 5 servers
I 've setup my system so it talks to a replicated db pair, where the
slave for read only operations, now most of my select actions
(Mytickets, MyRequests, Results.html) uses the slave server , so normal
ticketing operations are not effected by long searches, I am putting the
changes below to you smart people to see if anyone can spot something I
missed that may cause problems down the line , I would appreciate any ideas.
I have made the following changes:
in RT_SiteConfig added the following variables:
# {{{ Read Only Database Configuration
Set($RO_DatabaseHost , 'slave db');
#The name of the database user (inside the database)
Set($RO_DatabaseUser , 'rt user');
# Password the DatabaseUser should use to access the database
Set($RO_DatabasePassword , 'rt password');
# The name of the RT's database on your database server
Set($RO_DatabaseName , 'rt3');
Changed in SearchBuilder.pm, the _Init function to :
# {{{ sub _Init
sub _Init {
my $self = shift;
$RT::Logger-err(Getting to SearchBuilder.pm);
$self-{'user'} = shift;
my $ro_db = shift;
unless(defined($self-CurrentUser)) {
use Carp;
Carp::confess($self was created without a CurrentUser);
$RT::Logger-err($self was created without a CurrentUser);
return(0);
}
#CHANGE = USED FOR 2nd DB FOR SEARCH ELEMENTS
if ($ro_db) {
$RT::Logger-err(Getting to SearchBuilder.pm and highlted ro_db);
my $handle = DBIx::SearchBuilder::Handle-new();
$handle-Connect( 'Driver' = mysql,
'Database' = $RT::RO_DatabaseName,
'Host' = $RT::RO_DatabaseHost,
'User' = $RT::RO_DatabaseUser,
'Password' = $RT::RO_DatabasePassword);
$self-SUPER::_Init( 'Handle' = $handle);
# Setup al;ternate DB handle in config and use tha tisntead
} else {
$self-SUPER::_Init( 'Handle' = $RT::Handle);
}
## END CHANGE
}
# }}}
And applied changes to where ever there are read only operations (ie
MyTickets as example ) changing :
$MyTickets = new RT::Tickets ($session{'CurrentUser'});
to:
$MyTickets = RT::Tickets-new($session{'CurrentUser'},+ro);
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
___
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] Read only db for select (cluster on the cheap)
On Thu, 2006-10-26 at 17:20 +0100, Roy El-Hames wrote: Not sure what you mean;I did not need to touch RT::Record .. do you mean 2 handles same db .. It'll have little or no benefit?? No, different databases. Two databases, two handles -- one read-write, the other read-only. I understand what you mean about the speed of replication, in our case its set to near enough real time, however with Create.html a/Update.html and also Display.html I kept them reading from RW db in case of any delay in replication, so basically anything that require to see the changes immediately it will read from RW db. Yes, that's what I was wondering -- would it be OK to read from the read-only slave right after updating read-write master? If not, what are the cases, and can we abstract it in such manner that GUI code does not have to be modified? - Dmitri. ___ 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] Read only db for select (cluster on the cheap)
Ahh I see what you mean; Did n't look into that? but possibly a question here is whats a better approach? in changing from the GUI you get flexibility deciding which element read from which DB,apart from the replication issues it may also be extended to a third/forth db instances where certain Elements may call non RT related tables ?? Roy Yes, that's what I was wondering -- would it be OK to read from the read-only slave right after updating read-write master? If not, what are the cases, and can we abstract it in such manner that GUI code does not have to be modified? - Dmitri. ___ 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] RT Spam Looping
Hi all, please, A spammer send us a message with a big number of cc:, more than 100. Then our RT has identified it as a new ticket and all cc: as requestors. Resuming, all of them are receiving messages from us, causing server overload and other problems. Then I 've removed this ticket but a lot of error messages or unknow users message came and reopen ticket again. Could someone help me? Thanks, Eder Miranda ___ 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] slow full-content searches
RT 3.4.5, 4.1.18, ~80,000 tickets Searching across ~30 queues with ~80,000 tickets total: Fastcgi timeout is set to 120 seconds, which this query and many other full-text queries surpass. # Time: 061026 14:09:35 # [EMAIL PROTECTED]: rt_user[rt_user] @ localhost [] # Query_time: 156 Lock_time: 0 Rows_sent: 6 Rows_examined: 1285438 SELECT DISTINCT main.* FROM Tickets main , Transactions Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.ObjectType = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (Attachments_2.Content LIKE '%different results%')AND(Attachments_2.TransactionId = Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) ) ORDER BY main.id ASC; Explain: mysql explain SELECT DISTINCT main.* FROM Tickets main , Transactions Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.ObjectType = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (Attachments_2.Content LIKE '%different results%')AND(Attachments_2.TransactionId = Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) ) ORDER BY main.id ASC; ++-++--+---+---+-+---+---+--+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-++--+---+---+-+---+---+--+ | 1 | SIMPLE | main | ALL | PRIMARY,Tickets4,Tickets5 | NULL |NULL | NULL | 76267 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | Transactions_1 | ref | PRIMARY,Transactions1 | Transactions1 | 68 | const,rt3.main.id | 3 | Using where; Using index; Distinct | | 1 | SIMPLE | Attachments_2 | ref | Attachments2 | Attachments2 | 4 | rt3.Transactions_1.id | 1 | Using where; Distinct| ++-++--+---+---+-+---+---+--+ 3 rows in set (0.00 sec) ___ 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] Problem configuring LDAP with AD
I'm not an expert in AD or LDAP, but ou=ActiveUsers,dc=domain,dc=local doesn't look right to me. I don't see ActiveUsers in either my 2k or 2k3 domain controllers' schemas. Also, I think your base should be cn=,dc=,dc= format not ou=,dc=,dc=. Can you run ldapsearch on your RT box? The output from ldapsearch -x -h server -b cn=Users,dc=domain,dc=com|net|etc -D ldapbinduser -w password sAMAccountName=domainuser would be helpful. -- Eric N. Valor Information Technology Manager DaimlerChrysler Research Technology North America, Inc. [EMAIL PROTECTED] 1510 Page Mill Road, Palo Alto, CA 94304 CIMS 931-00-00 650-845-2536 : This Space Intentionally Left Blank : Andrew Hodgson [EMAIL PROTECTED] 10/24/2006 11:58 AM To rt-users@lists.bestpractical.com cc [EMAIL PROTECTED] Subject Re: [rt-users] Problem configuring LDAP with AD [EMAIL PROTECTED] wrote: AFAIK, inetOrgPerson doesn't exist in Active Directory. I've changed it to user, which is one of the choices I can see in ADSIEdit (the others are organizationalPerson, top, person.) Use the LDAPAttrMap I posted to the Wiki at http://wiki.bestpractical.com/index.cgi?LdapAttrMap I have done, thank you for the page. I used this page when I set up the LDAP overlay originally. In your RT_SiteConfig.pm make sure you have the correct MatchList and base: Check. My base is an OU (ou=ActiveUsers,dc=domain,dc=local). # A list of RT attrs which can uniquely identify a user, # # ordered from most to least preferred. Set($LdapRTAttrMatchList, ['Name', 'ExternalContactInfoId', 'EmailAddress', 'RealName', 'WorkPhone', 'Address1'] The final entry was set to Address2, so I've changed it to 1. snip...all in check I've doubled checked the configuration and I still get the LDAP_OPERATIONS_ERROR 1. I've tried it with different credentials, and different settings for objectClass, but as far as I can see there's no effect. Any further help appreciated, Andrew ___ 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] re:A reminder creates a ticket and sends email to queue watchers???
I've experienced this behaviour as well. Is this what a reminder is supposed to do, and if so, does anyone know the reasoning behind it? Taan ___ 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] re:A reminder creates a ticket and sends email to queue watchers???
More strange behaviour: The Ticket that is automatically created contains a refers to link to the ticket that created it, however that ticket doesn't contain a referred to by link. Also, I can't find the automatically created ticket by doing a search on its ID (status new), but if I type http://rt.cryologic.com/rt/Ticket/Display.html?id=274 the ticket is displayed. Seems a bit weird. Taan ___ 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
