[rt-users] shredder stuck!
Hello, I am running the shredder over our database and it has been dutifully deleting the deleted tickets as requested. It has processed around 20,000 so far but is now stuck with the following output in the SQL dump files: INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','912264','3107639','912264','10','3107639'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','912264','3107640','912264','10','3107635'); INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`) VALUES('912264','1168372','10'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','912264','3107635','912264','912264','3107635'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype `,`timetaken`,`type`) VALUES('2008-09-26 23:23:48','228052',NULL,NULL,'2001691',NULL,NULL,'912264','RT::Group',NULL,NULL,NULL,'0','Create'); INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) VALUES(NULL,'RT::Ticket-Role','912264','192693',NULL,'Owner'); INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) VALUES('0','912264','912264','Group'); No other errors or warnings that I can see. Would anyone have any ideas why it is stuck? -- Cheers, David ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] AT 1.2.4b1 with RT 3.8.4 install fails Can't locate
Another way around this error is to add the sub routine to the system.pm file in the src directory before doing the make.The results are the same, but, at least you don't see the error! From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Natxo Asenjo Sent: Saturday, September 19, 2009 2:43 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] AT 1.2.4b1 with RT 3.8.4 install fails Can't locate On Fri, Sep 18, 2009 at 11:53 PM, Susan McClure smccl...@rice.edumailto:smccl...@rice.edu wrote: Hi, I am finally back to working on this... but I am now trying to install AT 1.2.4b1 on RT 3.8.5 on a RHE Linux system. I am still having the failure, after modifying the /opt/rt3/local/lib/RTx/AssetTracker/System.pm file as suggested. I still fail. Do you have any other suggestions, esp. with 3.8.5 ? I modified it after the make and before the make install but still fail with similar error: [knip] [Fri Sep 18 21:43:31 2009] [crit]: Can't locate object method ACLEquivalenceObjects via package RTx::AssetTracker::System at /opt/rt3/lib/RT/Principal_Overlay.pm line 327, DATA line 323. (/opt/rt3/local/lib/RT.pm:377) Can't locate object method ACLEquivalenceObjects via package RTx::AssetTracker::System at /opt/rt3/lib/RT/Principal_Overlay.pm line 327, DATA line 323. Creating types...make: *** [initdb] Error 255 ok, I'm sorry, I guess I was not specific enough. You do not need to re-make the installation of AT, you are done with it once you saw the error. What you need to do is just modify the System.pm file and add the new subroutine. I have here a installation instruction for debian lenny and RT 3.8.4 (but it is a source installation, so it should be not very different in RH): http://test.asenjo.nl/index.php/Installation_on_debian_lenny#Installation_Asset_Tracker I plan to document the installation for centos, when I get some free time (now it is very busy professional and personally). Let me know if it works! Natxo This e-mail message is intended only for the personal use of the recipient(s) named above. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the Hearst Service Center (cad...@hearstsc.com) immediately by email and delete the original message. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] rt 3.8.4 case sensitivity for e-mail addresses
Also, remember, RT creates users automatically, and the lowercase version of the email address doesn't match an RT user. Mike Johnson Datatel Programmer/Analyst Northern Ontario School of Medicine 955 Oliver Road Thunder Bay, ON P7B 5E1 Phone: 807.766.7331 Email: mike.john...@normed.ca Technology assistance: email nosmhelpd...@normed.ca Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat holidays: Off campus toll free 1-800-461-8777, option 8, or locally either (705)-662-7120 or (807)-766-7500 Jerrad Pierce jpie...@cambridgeenergyalliance.org 18/09/2009 1:05 pm I've had a look through the wiki and the mail archives and drawn a blank. Does anybody know if there is a way to make RT not care about the case of the mail address Check again. It's nothing to do with the email address, but rather the collation set for your MySQL tables. Note that even with a case-insensitive collation, fulltext search is always case-sensitive... :-/ ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com ( http://wiki.bestpractical.com/ ) Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ( http://rtbook.bestpractical.com/ ) ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Need to Merge Users; can't install extension
Hello all, I need to merge a few users. The Extensions page of the wiki says that RT::Extension::MergeUsers adds a Merge Users box to the User Administration page, which sounds like what I need. I've never installed an extension before. That module has no installation instructions (in fact, its POD seems b0rked). I tried to install it via CPAN.pm, but the test suite failed with Can't locate RT/Test.pm in @INC. I tried to install RT::Test, but CPAN.pm said, No objects found of any type for argument RT::Test. How should I install this extension? Thanks in advance. Eric J. Roode Senior Enterprise Developer Barrack, Rodos Bacine (215) 963-0600 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] list unprivileged users
Thank you very much. I'll use the wildcard because the people who need to list Users aren't SuperUsers. I don't have a lot of users, so the speed isn't problem, but I'm interested in your formating, because it's necessary for me to print Organization name : So this is my search : /Admin/Users/index.html?Format='__id__%2C__Name__%2C__RealName__%2C__Organization__Order=ASCOrderBy=OrganizationPage=1Rows=1UserField=NameUserOp=LIKEUserString=%25 Do you know how I can give it for the rt staff users, like a kind of saved search ? thanks Jerrad Pierce a écrit : On Fri, Sep 18, 2009 at 14:07, Lander, Scott slan...@hearstsc.com wrote: The easiest way I know of is, at the bottom of the Configuration-Users page, check the 'Include disabled users in search box, and in the query box, just put a % (sql wild card).You should get a list of everyone there! This is what Kevin said above. RTx::BecomeUser is relatively quick, and will list priveleged and unpriveleged separately, but in select fields and you must have SuperUser. If using the wildcard trick, you can get everyone on one page by tweaking the URI, and also speed things up by eliminating extraneous info/markup e.g; /Admin/Users/index.html?Format=%27__id__%2C__Name__%2C__RealName__Rows=1UserField=NameUserOp=LIKEUserString=%25 That actually loads faster on my box than a single page of the the default formatted table. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Need to Merge Users; can't install extension
I also need doc about that extention, how it works, for exemple, if I keep two users, who have both access to the same tickets, if those users can stay unprivileged... If you find some documentation, please share it ! thanks Laetib Roode, Eric a écrit : Hello all, I need to merge a few users. The Extensions page of the wiki says that RT::Extension::MergeUsers adds a Merge Users box to the User Administration page, which sounds like what I need. I've never installed an extension before. That module has no installation instructions (in fact, its POD seems b0rked). I tried to install it via CPAN.pm, but the test suite failed with Can't locate RT/Test.pm in @INC. I tried to install RT::Test, but CPAN.pm said, No objects found of any type for argument RT::Test. How should I install this extension? Thanks in advance. Eric J. Roode Senior Enterprise Developer Barrack, Rodos Bacine (215) 963–0600 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Need to Merge Users; can't install extension
On Mon, Sep 21, 2009 at 11:13:18AM -0400, Roode, Eric wrote: Hello all, I need to merge a few users. The Extensions page of the wiki says that RT::Extension::MergeUsers adds a Merge Users box to the User Administration page, which sounds like what I need. I've never installed an extension before. That module has no installation instructions (in fact, its POD seems b0rked). I tried to install it via CPAN.pm, but the test suite failed with Can't locate RT/Test.pm in @INC. I tried to install RT::Test, but CPAN.pm said, No objects found of any type for argument RT::Test. How should I install this extension? Thanks in advance. http://cpansearch.perl.org/src/FALCONE/RT-Extension-MergeUsers-0.03/README That has installation instructions If you're using a non-3.8 RT you may actually just want to install 0.02 since 0.03 has a bunch of 3.8 specific fixes (as documented in Changes) You may find that RT extensions that have tests are more easily installed by hand instead of using the CPAN shell. -kevin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Multiuser Approvals
Jeff, Perhaps creating a Custom Field that has the three individuals as possible selections. Then have a scrip that sets the value to the person that indicates approval (I have an added ticket status value for that and added an option next to Resolved in the modify ticket screen). Then have another scrip that checks how many values have been set in that Custom Field when it is modified. If there are two values there, then the ticket has been approved and you can set new statuses, etc. based on that finding. Just a thought. Kenn LBNL On 9/18/2009 5:24 PM, Jeff Scheller wrote: I am looking to implement a change control process which will require the approval from any 2 of a group of 3 individuals in order to be completed. Seems there is a bunch of scrips out there which allow multistage serial approvals but nothing which requires X number of people in a certain group to approve. The only thing I can think of doing is some kind of nested approval process where: Initial request comes in and approval ticket goes to a group containing user1, user2 and user3. If user1 approves make new approval ticket for group containing user2 and user3 If user2 approves make new approval ticker for group containing user1 and user3 If user3 approves make new approval ticket for group containing user1 and user2 If someone has a better solution or better yet a pre-written scrip that would do this it would really help. Any thoughts? *Jeffrey Scheller* ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] LDAP with AD RT:3.8.4 ExternalAuth
I am running RT 3.8.4 with the RT::Authen::ExternalAuth plugin. My Request tracker server does not appear to be accessing the AD server for login. If I run tcpdump I do not see a connection to the AD server being attempted and the local logins still work. Is there another config file I need to change? I would be grateful for any help. The RT_SiteConfig.pm Set($LogToSyslog,'debug'); # THE BASICS: Set($rtname, 'support.example.org'); Set($Organization, 'example.org'); Set($CorrespondAddress , 'bsny...@domain.com'); Set($CommentAddress , 'comment-t...@domain.com'); Set($Timezone , 'US/Mountan'); # obviously choose what suits you #LDAP Set(@Plugins,qw(RT::Authen::ExternalAuth)); Set($ExternalAuthPriority, ['My_LDAP']); Set($ExternalInfoPriority, ['My_LDAP']); Set($ExternalSettings, {'My_LDAP' = { ## GENERIC SECTION # The type of service (db/ldap/cookie) 'type' = 'ldap', # The server hosting the service 'server'= '10.x.x.x', #Ip Addy is correct ## SERVICE-SPECIFIC SECTION # If you can bind to your LDAP server anonymously you should # remove the user and pass config lines, otherwise specify them here: # # The username RT should use to connect to the LDAP server 'user' = 'AD_Info\\LDAP', 'pass'= 'pass', # # The LDAP search base 'base' = 'ou=*,dc=DCinfo,dc=local', # # ALL FILTERS MUST BE VALID LDAP FILTERS ENCASED IN PARENTHESES! # YOU **MUST** SPECIFY A filter AND A d_filter!! # # The filter to use to match RT-Users 'filter'= '(objectClass=*)', # A catch-all example filter: '(objectClass=*)' # # The filter that will only match disabled users 'd_filter' = '(objectClass=FooBarBaz))', # A catch-none example d_filter: '(objectClass=FooBarBaz)' # # Should we try to use TLS to encrypt connections? 'tls' = 0, # SSL Version to provide to Net::SSLeay *if* using SSL 'ssl_version' = 3, # What other args should I pass to Net::LDAP-new($host,@args)? 'net_ldap_args' = [version = 3 ], 'attr_match_list' = ['Name','EmailAddress'], # The mapping of RT attributes on to LDAP attributes 'attr_map' = { 'Name' = 'sAMAccountName', 'EmailAddress' = 'mail', } } } ); Set($DatabaseType, 'mysql'); # e.g. Pg or mysql Set($DatabaseUser , 'rtuser'); Set($DatabasePassword , 'password'); Set($DatabaseName , 'rt3'); # Ensure this is set to rt3! Set($WebPath , /rt); Set($WebBaseURL , http://support.example.org;); Set(@Plugins,qw(RT::FM)); 1; Syslog Sep 18 16:03:49 RequstTracker RT: FAILED LOGIN for testuser from 10.50.1.192 (/opt/rt3/share/html/autohandler:268) Sep 18 16:04:17 RequstTracker RT: You've enabled GD, but we couldn't load the module: Can't locate GD.pm in @INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/local/plugins/RT-FM/lib /opt/rt3/bin/../lib /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /opt/rt3/bin/../lib/RT/Config.pm line 365. Sep 18 16:04:17 RequstTracker RT: You've enabled GraphViz, but we couldn't load the module: Can't locate GraphViz.pm in @INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/local/plugins/RT-FM/lib /opt/rt3/bin/../lib /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /opt/rt3/bin/../lib/RT/Config.pm line 352. Sep 18 16:04:17 RequstTracker RT: RT's GnuPG libraries couldn't successfully read your configured GnuPG home directory (/opt/rt3/var/data/gpg). PGP support has been disabled Beryl Snyder IT Specialist TMC Design Corporation 4325 Del Rey BLVD Las Cruces, NM 88012 Phone: 575-382-4600 Fax: 575-523-8588 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] list unprivileged users
Do you know how I can give it for the rt staff users, like a kind of saved search ? Saved searches are for ticket builder, this is a user search. They can either create a browser bookmark, or you could add a link to it in the UI with a Tabs callback. -- Cambridge Energy Alliance: Save money. Save the planet. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Can't populating database schema - new rt3.8 installation
Hello, i can't populating database schema for a new installation of request-tracker3.8 version : 3.8.4-1 Thank for your help #rt-setup-database-3.8 --action init --skip-create Working with: Type: mysql Host: localhost Name: rtdb User: request-tracker3 DBA:request-tracker3 (No DBA) Now populating database schema. DBD::mysql::st execute failed: Can't create table 'rtdb.Attachments' (errno: 121) at /usr/share/request-tracker3.8/lib/RT/Handle.pm line 506. -- Anne Fradin Administration Systèmes et Réseaux GIPSA-lab - UMR5216 961, Rue de la Houille Blanche - BP 46 38402 Saint Martin d'Hères Tél : 04.76.82.62.56 mailto:anne.fra...@gipsa-lab.grenoble-inp.fr ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] New ticket does not get queue watcher
I have a pretty new installation of 3.8.2 here; have done very little customization to it. I have a queue called support. That queue has a user set up as a Cc: watcher, a fellow whose user id is sward. The queue also has a group set up as a Cc: watcher, overseers, which has only one member, sward. When I create a new ticket in the support queue, no e-mail goes to sward. Also, when you look at the ticket, under the People section, it lists as Current Watchers only the requestor, not sward. What can I check to figure out why sward is not being added to the Cc watchlist for new tickets in this queue? Thanks in advance. Eric J. Roode Senior Enterprise Developer Barrack, Rodos Bacine (215) 963-0600 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] LDAP with AD RT:3.8.4 ExternalAuth
Set(@Plugins,qw(RT::FM)); You need to turn on the extension by adding the RT::Authen::ExternalAuth module to that quoted array. Also, I saw this below: # The username RT should use to connect to the LDAP server 'user' = 'AD_Info\\LDAP', 'pass' = 'pass', That may or may not work. If your user is LDAP, you may actually need to use: l...@domain.yourcompany.com, and you may need to add the @domain.yourcompany.com as an auto-appended suffix so your users can log on with their basic username. -Rob On Mon, Sep 21, 2009 at 10:48 AM, Beryl N. Snyder bsny...@tmcdesign.com wrote: I am running RT 3.8.4 with the RT::Authen::ExternalAuth plugin. My Request tracker server does not appear to be accessing the AD server for login. If I run tcpdump I do not see a connection to the AD server being attempted and the local logins still work. Is there another config file I need to change? I would be grateful for any help. The RT_SiteConfig.pm Set($LogToSyslog,'debug'); # THE BASICS: Set($rtname, 'support.example.org'); Set($Organization, 'example.org'); Set($CorrespondAddress , 'bsny...@domain.com'); Set($CommentAddress , 'comment-t...@domain.com'); Set($Timezone , 'US/Mountan'); # obviously choose what suits you #LDAP Set(@Plugins,qw(RT::Authen::ExternalAuth)); Set($ExternalAuthPriority, ['My_LDAP']); Set($ExternalInfoPriority, ['My_LDAP']); Set($ExternalSettings, {'My_LDAP' = { ## GENERIC SECTION # The type of service (db/ldap/cookie) 'type' = 'ldap', # The server hosting the service 'server' = '10.x.x.x', #Ip Addy is correct ## SERVICE-SPECIFIC SECTION # If you can bind to your LDAP server anonymously you should # remove the user and pass config lines, otherwise specify them here: # # The username RT should use to connect to the LDAP server 'user' = 'AD_Info\\LDAP', 'pass' = 'pass', # # The LDAP search base 'base' = 'ou=*,dc=DCinfo,dc=local', # # ALL FILTERS MUST BE VALID LDAP FILTERS ENCASED IN PARENTHESES! # YOU **MUST** SPECIFY A filter AND A d_filter!! # # The filter to use to match RT-Users 'filter' = '(objectClass=*)', # A catch-all example filter: '(objectClass=*)' # # The filter that will only match disabled users 'd_filter' = '(objectClass=FooBarBaz))', # A catch-none example d_filter: '(objectClass=FooBarBaz)' # # Should we try to use TLS to encrypt connections? 'tls' = 0, # SSL Version to provide to Net::SSLeay *if* using SSL 'ssl_version' = 3, # What other args should I pass to Net::LDAP-new($host,@args)? 'net_ldap_args' = [ version = 3 ], 'attr_match_list' = [ 'Name','EmailAddress'], # The mapping of RT attributes on to LDAP attributes 'attr_map' = { 'Name' = 'sAMAccountName', 'EmailAddress' = 'mail', } } } ); Set($DatabaseType, 'mysql'); # e.g. Pg or mysql Set($DatabaseUser , 'rtuser'); Set($DatabasePassword , 'password'); Set($DatabaseName , 'rt3'); # Ensure this is set to rt3! Set($WebPath , /rt); Set($WebBaseURL , http://support.example.org;); Set(@Plugins,qw(RT::FM)); 1; Syslog Sep 18 16:03:49 RequstTracker RT: FAILED LOGIN for testuser from 10.50.1.192 (/opt/rt3/share/html/autohandler:268) Sep 18 16:04:17 RequstTracker RT: You've enabled GD, but we couldn't load the module: Can't locate GD.pm in @INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/local/plugins/RT-FM/lib /opt/rt3/bin/../lib /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /opt/rt3/bin/../lib/RT/Config.pm line 365. Sep 18 16:04:17 RequstTracker RT: You've enabled GraphViz, but we couldn't load the module: Can't locate GraphViz.pm in @INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/local/plugins/RT-FM/lib /opt/rt3/bin/../lib /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /opt/rt3/bin/../lib/RT/Config.pm line 352. Sep 18 16:04:17 RequstTracker RT: RT's GnuPG libraries couldn't successfully read your configured GnuPG home directory (/opt/rt3/var/data/gpg). PGP support has been disabled Beryl Snyder IT Specialist TMC Design Corporation 4325 Del Rey BLVD Las Cruces, NM 88012 Phone: 575-382-4600 Fax: 575-523-8588 ___
Re: [rt-users] Can't populating database schema - new rt3.8 installation
On Mon, Sep 21, 2009 at 06:15:13PM +0200, Anne Fradin wrote: Hello, i can't populating database schema for a new installation of request-tracker3.8 version : 3.8.4-1 Thank for your help #rt-setup-database-3.8 --action init --skip-create I'm curious, where did you see --skip-create documented as an argument? If I run your command I get a warning about --skip-create I think you want to run --action coredata --action insert --datafile etc/initialdata in order to skip DB creation, schema creation and acl creation. -kevin Working with: Type: mysql Host: localhost Name: rtdb User: request-tracker3 DBA:request-tracker3 (No DBA) Now populating database schema. DBD::mysql::st execute failed: Can't create table 'rtdb.Attachments' (errno: 121) at /usr/share/request-tracker3.8/lib/RT/Handle.pm line 506. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Need to Merge Users; can't install extension
On Monday, September 21, 2009, Kevin Falcone wrote: On Mon, Sep 21, 2009 at 11:13:18AM -0400, Roode, Eric wrote: [...] How should I install this extension? Thanks in advance. http://cpansearch.perl.org/src/FALCONE/RT-Extension-MergeUsers-0.03/READ ME That has installation instructions If you're using a non-3.8 RT you may actually just want to install 0.02 since 0.03 has a bunch of 3.8 specific fixes (as documented in Changes) You may find that RT extensions that have tests are more easily installed by hand instead of using the CPAN shell. Okay, I did that, and restarted apache, but never saw any change to the User Administration pages. However, installing the module did install a script, rt-mergeusers, in the rt3 bin directory, and I successfully used that to merge the users. Thank you! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] New ticket does not get queue watcher
Eric, Let me claify a couple things for you: 1) A /*Queue*/ 'CC' Watcher is not the same as a 'CC' /*Ticket */watcher. Having sward as the /*Queue*/ 'CC' watcher will* NOT* get him/her put onto all tickets in that queue as a /*Ticket*/ 'CC' watcher. Also, you don't need that user in both anyway. Just get your notifications set up correctly. 2) Emails do not go out automatically for Queue *OR* ticket watchers unless you have a notification scrip for the desired condition. 3) If you create a notification scrip for the Queue 'CC' Watchers, sward is going to get 2 emails exactly alike. This is because you have him a a Queue watcher twice (individually AND in a group). 4) I recommend you remove either the group or sward as the Queue 'CC' watcher. Hope this helps. Kenn LBNL On 9/21/2009 9:24 AM, Roode, Eric wrote: I have a pretty new installation of 3.8.2 here; have done very little customization to it. I have a queue called support. That queue has a user set up as a Cc: watcher, a fellow whose user id is sward. The queue also has a group set up as a Cc: watcher, overseers, which has only one member, sward. When I create a new ticket in the support queue, no e-mail goes to sward. Also, when you look at the ticket, under the People section, it lists as Current Watchers only the requestor, not sward. What can I check to figure out why sward is not being added to the Cc watchlist for new tickets in this queue? Thanks in advance. Eric J. Roode Senior Enterprise Developer Barrack, Rodos Bacine (215) 963–0600 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] New ticket does not get queue watcher
On Monday, September 21, 2009, Ken Crocker wrote: Eric, Let me claify a couple things for you: 1) A Queue 'CC' Watcher is not the same as a 'CC' Ticket watcher. Having sward as the Queue 'CC' watcher will NOT get him/her put onto all tickets in that queue as a Ticket 'CC' watcher. Also, you don't need that user in both anyway. Just get your notifications set up correctly. 2) Emails do not go out automatically for Queue OR ticket watchers unless you have a notification scrip for the desired condition. 3) If you create a notification scrip for the Queue 'CC' Watchers, sward is going to get 2 emails exactly alike. This is because you have him a a Queue watcher twice (individually AND in a group). 4) I recommend you remove either the group or sward as the Queue 'CC' watcher. Thanks for your help. I guess I am unclear on what a Queue CC Watcher is, if it doesn't mean that the user gets added to newly-created tickets in that queue as a CC Watcher. I have removed the individual user from the Queue CC Watcher list, and they are now in there solely as a member of the overseers group. What I want is for this user to get notified by e-mail every time a ticket is created in that queue, and every time a reply is made to any ticket in that queue, and every time a ticket in that queue is resolved. I had thought Queue Watcher was how to do that. But it seems that you're telling me it's not. I have not added, removed, or modified any scrips, site-wide. When I call up the support queue and click the Scrips tab, I see a list of 11 Scrips which apply to all queues, which I believe must be the default out-of-the-box setup. It includes the following: 8 On Comment Notify AdminCcs as Comment with template Admin Comment 9 On Comment Notify Other Recipients as Comment with template Correspondence 5 On Correspond Notify AdminCcs with template Admin Correspondence 7 On Correspond Notify Other Recipients with template Correspondence 6 On Correspond Notify Requestors and Ccs with template Correspondence 1 On Correspond Open Tickets with template Blank 3 On Create Autoreply To Requestors with template Autoreply 4 On Create Notify AdminCcs with template Transaction 2 On Owner Change Notify Owner with template Transaction 10 On Resolve Notify Requestors with template Resolved 11 On Transaction Extract Subject Tag with template Blank Thanks, -- Eric ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] New ticket does not get queue watcher
On Mon, Sep 21, 2009 at 02:14:20PM -0400, Roode, Eric wrote: On Monday, September 21, 2009, Ken Crocker wrote: I guess I am unclear on what a Queue CC Watcher is, if it doesn't mean that the user gets added to newly-created tickets in that queue as a CC Watcher. They will not show in the People part of the Ticket Display, but RT considers them to be a CC of that ticket for the purpose of notifications and rights distribution. I have removed the individual user from the Queue CC Watcher list, and they are now in there solely as a member of the overseers group. What I want is for this user to get notified by e-mail every time a ticket is created in that queue, and every time a reply is made to any ticket in that queue, and every time a ticket in that queue is resolved. As Kenn noted, you need to create a Scrip, your list below doesn't have anything that says On Create Notify Ccs -kevin I had thought Queue Watcher was how to do that. But it seems that you're telling me it's not. I have not added, removed, or modified any scrips, site-wide. When I call up the support queue and click the Scrips tab, I see a list of 11 Scrips which apply to all queues, which I believe must be the default out-of-the-box setup. It includes the following: 8 On Comment Notify AdminCcs as Comment with template Admin Comment 9 On Comment Notify Other Recipients as Comment with template Correspondence 5 On Correspond Notify AdminCcs with template Admin Correspondence 7 On Correspond Notify Other Recipients with template Correspondence 6 On Correspond Notify Requestors and Ccs with template Correspondence 1 On Correspond Open Tickets with template Blank 3 On Create Autoreply To Requestors with template Autoreply 4 On Create Notify AdminCcs with template Transaction 2 On Owner Change Notify Owner with template Transaction 10 On Resolve Notify Requestors with template Resolved 11 On Transaction Extract Subject Tag with template Blank Thanks, -- Eric ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] LDAP with AD RT:3.8.4 ExternalAuth
Thanks Robert, That's what I was missing. Secondly it had to be u...@domain.tdl for the LDAP to work Beryl Snyder IT Specialist TMC Design Corporation 4325 Del Rey BLVD Las Cruces, NM 88012 Phone: 575-382-4600 Fax: 575-523-8588 -Original Message- From: Robert Nesius [mailto:nes...@gmail.com] Sent: Monday, September 21, 2009 10:16 AM To: Beryl N. Snyder; rt-users@lists.bestpractical.com Subject: Re: [rt-users] LDAP with AD RT:3.8.4 ExternalAuth Set(@Plugins,qw(RT::FM)); You need to turn on the extension by adding the RT::Authen::ExternalAuth module to that quoted array. Also, I saw this below: # The username RT should use to connect to the LDAP server 'user' = 'AD_Info\\LDAP', 'pass' = 'pass', That may or may not work. If your user is LDAP, you may actually need to use: l...@domain.yourcompany.com, and you may need to add the @domain.yourcompany.com as an auto-appended suffix so your users can log on with their basic username. -Rob On Mon, Sep 21, 2009 at 10:48 AM, Beryl N. Snyder bsny...@tmcdesign.com wrote: I am running RT 3.8.4 with the RT::Authen::ExternalAuth plugin. My Request tracker server does not appear to be accessing the AD server for login. If I run tcpdump I do not see a connection to the AD server being attempted and the local logins still work. Is there another config file I need to change? I would be grateful for any help. The RT_SiteConfig.pm Set($LogToSyslog,'debug'); # THE BASICS: Set($rtname, 'support.example.org'); Set($Organization, 'example.org'); Set($CorrespondAddress , 'bsny...@domain.com'); Set($CommentAddress , 'comment-t...@domain.com'); Set($Timezone , 'US/Mountan'); # obviously choose what suits you #LDAP Set(@Plugins,qw(RT::Authen::ExternalAuth)); Set($ExternalAuthPriority, ['My_LDAP']); Set($ExternalInfoPriority, ['My_LDAP']); Set($ExternalSettings, {'My_LDAP' = { ## GENERIC SECTION # The type of service (db/ldap/cookie) 'type' = 'ldap', # The server hosting the service 'server' = '10.x.x.x', #Ip Addy is correct ## SERVICE-SPECIFIC SECTION # If you can bind to your LDAP server anonymously you should # remove the user and pass config lines, otherwise specify them here: # # The username RT should use to connect to the LDAP server 'user' = 'AD_Info\\LDAP', 'pass' = 'pass', # # The LDAP search base 'base' = 'ou=*,dc=DCinfo,dc=local', # # ALL FILTERS MUST BE VALID LDAP FILTERS ENCASED IN PARENTHESES! # YOU **MUST** SPECIFY A filter AND A d_filter!! # # The filter to use to match RT-Users 'filter' = '(objectClass=*)', # A catch-all example filter: '(objectClass=*)' # # The filter that will only match disabled users 'd_filter' = '(objectClass=FooBarBaz))', # A catch-none example d_filter: '(objectClass=FooBarBaz)' # # Should we try to use TLS to encrypt connections? 'tls' = 0, # SSL Version to provide to Net::SSLeay *if* using SSL 'ssl_version' = 3, # What other args should I pass to Net::LDAP-new($host,@args)? 'net_ldap_args' = [ version = 3 ], 'attr_match_list' = [ 'Name','EmailAddress'], # The mapping of RT attributes on to LDAP attributes 'attr_map' = { 'Name' = 'sAMAccountName', 'EmailAddress' = 'mail', } } } ); Set($DatabaseType, 'mysql'); # e.g. Pg or mysql Set($DatabaseUser , 'rtuser'); Set($DatabasePassword , 'password'); Set($DatabaseName , 'rt3'); # Ensure this is set to rt3! Set($WebPath , /rt); Set($WebBaseURL , http://support.example.org;); Set(@Plugins,qw(RT::FM)); 1; Syslog Sep 18 16:03:49 RequstTracker RT: FAILED LOGIN for testuser from 10.50.1.192 (/opt/rt3/share/html/autohandler:268) Sep 18 16:04:17 RequstTracker RT: You've enabled GD, but we couldn't load the module: Can't locate GD.pm in @INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/local/plugins/RT-FM/lib /opt/rt3/bin/../lib /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at /opt/rt3/bin/../lib/RT/Config.pm line 365. Sep 18 16:04:17 RequstTracker RT: You've enabled GraphViz, but we couldn't load the module: Can't locate GraphViz.pm in @INC (@INC contains: /opt/rt3/bin/../local/lib /opt/rt3/local/plugins/RT-FM/lib /opt/rt3/bin/../lib /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10
Re: [rt-users] New ticket does not get queue watcher
On Monday, September 21, 2009, Kevin Falcone wrote: On Mon, Sep 21, 2009 at 02:14:20PM -0400, Roode, Eric wrote: On Monday, September 21, 2009, Ken Crocker wrote: I guess I am unclear on what a Queue CC Watcher is, if it doesn't mean that the user gets added to newly-created tickets in that queue as a CC Watcher. They will not show in the People part of the Ticket Display, but RT considers them to be a CC of that ticket for the purpose of notifications and rights distribution. Ah, interesting. I figured there would be visual confirmation. I have removed the individual user from the Queue CC Watcher list, and they are now in there solely as a member of the overseers group. What I want is for this user to get notified by e-mail every time a ticket is created in that queue, and every time a reply is made to any ticket in that queue, and every time a ticket in that queue is resolved. As Kenn noted, you need to create a Scrip, your list below doesn't have anything that says On Create Notify Ccs Great, adding a couple of scrips got me what I wanted. Thank you, Kevin and Ken! -- Eric ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] How to call code in RT_SiteConfig.pm?
Hi All, I've put a small subroutine called EmailInMyDomain() into my RT_SiteConfig.pm file. How do I call it from a scrip? I get an error when I try calling it like: if ( EmailInMyDomain($email) ) { } (Undefined subroutine RT::Action::UserDefined::EmailInMyDomain ...) Appreciate any help you can give me on this. Regards, Gene ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] LDAP with AD RT:3.8.4 ExternalAuth
On 9/21/09 9:15 AM, Robert Nesius nes...@gmail.com wrote: Set(@Plugins,qw(RT::FM)); You need to turn on the extension by adding the RT::Authen::ExternalAuth module to that quoted array. Also, I saw this below: # The username RT should use to connect to the LDAP server 'user' = 'AD_Info\\LDAP', 'pass' = 'pass', That may or may not work. If your user is LDAP, you may actually need to use: l...@domain.yourcompany.com, and you may need to add the @domain.yourcompany.com as an auto-appended suffix so your users can log on with their basic username. -Rob As long as you're in a single domain forest, you don't need to specify the NetBIOS name of the domain. When in a multi-domain forest, you should use the Windows 2000 syntax (u...@domain.tld) and then make sure you're pointing RT at a domain controller for that given domain that has a trust relationship with the others in the forest. -- Gary L. Greene, Jr. IT Operations Minerva Networks, Inc. Cell: (650) 704-6633 Phone: (408) 240-1239 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Patched statdump/statcron scripts
Does anyone still have a copy of this? Dunno if you ever found it, but here's a tarball from 2006: http://www.nabble.com/Patched-statdump-statcron-scripts-td2264154.html BP wiki updated. Allen ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Can't populating database schema - new rt3.8 installation
On Mon, Sep 21, 2009 at 12:51:04PM -0400, Kevin Falcone wrote: On Mon, Sep 21, 2009 at 06:15:13PM +0200, Anne Fradin wrote: Hello, i can't populating database schema for a new installation of request-tracker3.8 version : 3.8.4-1 Thank for your help #rt-setup-database-3.8 --action init --skip-create I'm curious, where did you see --skip-create documented as an argument? If I run your command I get a warning about --skip-create I think you want to run --action coredata --action insert --datafile etc/initialdata in order to skip DB creation, schema creation and acl creation. --skip-creates is a Debian modification, designed to populate the database without DBA privileges. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Sessions Table is MyISAM - RT 3.8.4
I have done a fresh installation of RT 3.8.4, and have done no modifications of any sort to the default installation.and was preparing to do my database backup (using mysqldump),and noticed the only table that has a MyISAM engine is the 'Sessions' Table (the rest are all InnoDB as expected). My understanding is that all of these tables were to have been of the InnoDB engine type (RT's transaction-based requirements/ recommendations). 1) Is this by design, or due to an unresolved bug? 2) If this is due to a bug, what is the remedy? 3) If this is by design, what steps need to be taken when it comes to MySQL backup, as I will have a combination of InnoDB and MyISAM based tables. Note: Per MySQL documentations, InnoDB tables need to be backed up with '--single-transaction' flag of mysqldump, and MyISAM tables need to be backed up with 'lock-tables'and the two mentioned flags are mutually exclusive (http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html ). My Environment: RT 3.8.4 Mac OS X 10.5.8 MySQL 5.1.37 Apache/2.2.13 (Unix) mod_perl/2.0.4 Perl/v5.8.8 configured Thanks, Behzad___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com