Re: [rt-users] Migrating from RT MySQL to PostgreSQL
- Original Message - From: Emmanuel Lacour elac...@easter-eggs.com To: rt-users@lists.bestpractical.com Sent: Friday, 27 November, 2009 3:22:53 AM Subject: Re: [rt-users] Migrating from RT MySQL to PostgreSQL On Thu, Nov 26, 2009 at 05:07:20PM +0100, Nehmer Torben wrote: Hello together, has anybody ever migrated RT from MySQL to PostgreSQL? Are there any scripts available to accomplish this? you can start here: http://wiki.bestpractical.com/view/MySQLToPg :) I did it with a slightly modified script to handle some encoding problems we had with our MySQL DB. - Original Message End - We have been trying to do this using this page, but we have never managed to get the binary attachments across successfully. If you have any luck with this, we are definitely interested in hearing about it. 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] shredder error
I thought this was the case; in which case I am still no closer to working out why it is crashing for me. Does anyone have any suggestions as to how I can get to the bottom of this? Couldn't wipeout object: Can't call method new on an undefined value at /opt/httpd/rt3/sbin/../lib/RT/Transaction_Overlay.pm line 1031, STDIN line 1. Cheers, David - Original Message - From: Ken Crocker kfcroc...@lbl.gov To: Howard Jones ho...@thingy.com Cc: rt-users@lists.bestpractical.com Sent: Friday, 16 October, 2009 3:14:26 AM GMT +10:00 Brisbane Subject: Re: [rt-users] shredder error Howard, I thought the replace-relations was for links to other tickets. If it offers an opportunity to enter a replacement User ID, then I'm sure it's OK. Kenn LBNL On 10/15/2009 9:01 AM, Howard Jones wrote: On 15/10/2009 16:41, Ken Crocker wrote: Some users may be referred to by transaction history of a ticket because they sent in corresponance or were the original requestor or owner. Those kind of relationships shouldn't be deleted because it will cause an error in yoiur history display. Isn't that what replace_relations is supposed to fix? Regards, Howard ___ 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 -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : david.hob...@mionegroup.com Website: www.mionegroup.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] shredder stuck!
OK, I finally worked this out myself. Note to self. --force stops error
messages appearing as well as other output.
The issue was in the dependency setting for the shredder, we had some tickets
with more than 1,000 dependencies (due to a couple of mail loops in the past)
and it just stops when it hits that number. I upped ours to 10,000 in the
RT_SiteConfig.pm file:
Set( $DependenciesLimit, 1 );
Cheers,
David
- Original Message -
From: David Hobley david.hob...@mionegroup.com
To: rt-users rt-users@lists.bestpractical.com
Sent: Monday, 21 September, 2009 3:57:21 PM GMT +10:00 Brisbane
Subject: [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
[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] 3.8.2 - HTML viewing issue
I have received no answers to this one. Is there any more information I need to provide? Where can I raise a bug report? Cheers, David - Original Message - From: David Hobley david.hob...@mionegroup.com To: rt-users rt-users@lists.bestpractical.com Sent: Thursday, May 21, 2009 8:56:12 AM GMT +10:00 Brisbane Subject: [rt-users] 3.8.2 - HTML viewing issue Hello, We just upgraded to 3.8.2 and since then when we receive our fax notifications, the HTML rendering is a little off. I have attached two files, the message and a screenshot showing the problem. Is this a bug? Or do I have something misconfigured here? -- 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 ___ 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] 3.8.2 - HTML viewing issue
Hello, We just upgraded to 3.8.2 and since then when we receive our fax notifications, the HTML rendering is a little off. I have attached two files, the message and a screenshot showing the problem. Is this a bug? Or do I have something misconfigured here? -- Cheers, David attachment: efaxbug.gifContent-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-RT-Original-Encoding: utf-8 Content-Length: 3576 Fax Message [Caller-ID: xxx-xxx-] You have received a 1 page fax at 2009-05-16 13:15:30 EST. * The reference number for this fax is tok1_did1-some-very-big-number. View this fax using your PDF reader. Please visit www.eFax.com/en/efax/twa/page/help if you have any questions regarding this message or your service. Thank you for using the eFax service! Home   Contact   Login © 2008 j2 Global Communications, Inc. All rights reserved. eFax® is a registered trademark of j2 Global Communications, Inc. This account is subject to the terms listed in the eFax® Customer Agreement. ___ 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-External-Auth debugging?
- Original Message - From: Mike Peachey mike.peac...@jennic.com To: David Hobley david.hob...@mionegroup.com Cc: Ruslan Zakirov ruslan.zaki...@gmail.com, rt-users@lists.bestpractical.com Sent: Tuesday, May 12, 2009 10:56:19 PM GMT +10:00 Brisbane Subject: Re: [rt-users] RT-External-Auth debugging? Tue 12 May 2009 13:49:03 GMT David Hobley wrote: I have the following in my RT_SiteConfig.pm, so I thought I had it all configured: # Set up any Plugins Set(@Plugins, qw(Extension::QuickDelete)); Set(@Plugins, qw(RT::Authen::ExternalAuth)); Set(@Plugins, qw(RT::FM)); You are overriding the @Plugins array twice. Replace these three lines with: Set(@Plugins, qw(Extension::QuickDelete RT::Authen::ExternalAuth RT::FM)); That fixed it - thanks Mike ( Ruslan) appreciate your responses. 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
[rt-users] RT-External-Auth debugging?
All, I am trying to integrate RT::Authen:: ExternalAuth to my RT instance and it is not letting me log in. I have configured debugging in my RT_SiteConfig.pm: Set($LogToFile, 'debug'); Set($LogDir, '/var/log/rt'); but the only message I get indicating problems is a FAILED LOGIN error in the rt.log. How should I go about getting more detailed logging happening? -- 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] RT-External-Auth debugging?
Ruslan,
thanks for your reply - how can I check this from the UI exactly? Given I can't
login!
I have the following in my RT_SiteConfig.pm, so I thought I had it all
configured:
Set($ExternalAuthPriority, [ 'Primary_LDAP' ]);
Set($ExternalInfoPriority, [ 'Primary_LDAP' ]);
Set($ExternalServiceUsesSSLorTLS, 0);
Set($AutoCreateNonExternalUsers, 0);
et($ExternalSettings, { 'Primary_LDAP' = { 'type' = 'ldap',
'server' = 'my.ldap.host',
'base' = 'ou=people,dc=MY,dc=DOMAIN',
'filter' = '(zimbraAccountStatus=active)',
'd_filter' = '(zimbraAccountStatus=closed)',
'tls' = 0,
'ssl_version' = 3,
'net_ldap_args' = [ version = 3 ],
'group' = 'RT_GROUP',
'group_attr' = 'memberUid',
'attr_match_list' = [ 'Name', 'EmailAddress' ],
'attr_map' = { 'Name' = 'uid',
'EmailAddress' = 'zimbraMailDeliveryAddress',
'Organization' = 'company',
'RealName' = 'cn',
'ExternalAuthId' = 'uid',
'Gecos' = 'uid',
'WorkPhone' = 'telephoneNumber',
'Address1' = 'street',
'City' = 'l',
'State' = 'st',
'Zip' = 'postalCode',
'Country' = 'co'
}
}});
# Set up any Plugins
Set(@Plugins, qw(Extension::QuickDelete));
Set(@Plugins, qw(RT::Authen::ExternalAuth));
Set(@Plugins, qw(RT::FM));
Cheers,
David
- Original Message -
From: Ruslan Zakirov ruslan.zaki...@gmail.com
To: David Hobley david.hob...@mionegroup.com
Cc: rt-users@lists.bestpractical.com
Sent: Tuesday, 12 May, 2009 6:21:57 PM GMT +10:00 Canberra / Melbourne / Sydney
Subject: Re: [rt-users] RT-External-Auth debugging?
This often indicates that you havn't enabled the extension. Or
installed incorrectly. If you're on RT 3.8.2 then can check system
configuration via UI, especially Plugins option and loaded modules.
On Tue, May 12, 2009 at 12:12 PM, David Hobley
david.hob...@mionegroup.com wrote:
All,
I am trying to integrate RT::Authen:: ExternalAuth to my RT instance and it
is not letting me log in. I have configured debugging in my RT_SiteConfig.pm:
Set($LogToFile, 'debug');
Set($LogDir, '/var/log/rt');
but the only message I get indicating problems is a FAILED LOGIN error in the
rt.log. How should I go about getting more detailed logging happening?
--
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
--
Best regards, Ruslan.
--
Cheers,
David Hobley
IT Manager
Creators of Miessence, MiVitality and MiEnviron
Phone: +61 (7) 5582 7020
Fax: +61 (7) 5539 6719
USA Fax 1800 840 0827
Email : david.hob...@mionegroup.com
Website: www.mionegroup.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] DB Problems upgrading to RT 3.8.2 from 3.6.5
If that is the case, then RT is un-upgradeable. Which would be a problem obviously. I can't take out our database for 6 days. Over a weekend, sure. But no more than that. Does anyone have any suggestions as to how I can optimise this at all? Cheers, David - Original Message - From: Aaron Guise aa...@guise.net.nz To: David Hobley david.hob...@mionegroup.com Cc: rt-users@lists.bestpractical.com Sent: Monday, 2 March, 2009 8:54:58 PM GMT +10:00 Brisbane Subject: Re: [rt-users] DB Problems upgrading to RT 3.8.2 from 3.6.5 Hi Dave, MySQL has to convert each one of those attachments to the new datatype. Sadly this just takes time. Our DB is only miniscule compared to yours and from memory it takes around an 1hour just to get through all of our attachments. I think it is highly likely that this could be normal due to the amount of data it has to manipulate. But as it said in the docs you need to test everything. especially those binary attachments namely .pdf,.xls etc. I have some difficulty with my database for some reason or another where in doing the schema upgrade it proceeds to corrupt them all -- Regards Aaron On Mon, Mar 2, 2009 at 2:16 PM, David Hobley david.hob...@mionegroup.com wrote: Hello, I have a (happily) running RT 3.6.5 with approx 300,000 tickets in it and a database of size of around 9 Gig (lots of attachments sadly). I have the application upgraded, but when I try and run the schema upgrade in my test environment it is taking forever (for values of forever which equate to around 6 days anyway): # perl etc/upgrade/ schema.mysql-4.0-4.1.pl rt3 root password ~/sql.queries # time `mysql -p rt3 ~/sql.queries` Enter password: real 8727m23.622s user 0m0.012s sys 0m0.004s Does anyone have any suggestions as to how I can make this faster? I have tried to optimise MySQL as much as possible, but I am not a db expert and obviously there is something wrong. Nb. The test environment is actually more powerful than the production one after having shutdown evey VM on the machine and ensured I was only running this for the time it took. -- 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 -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : david.hob...@mionegroup.com Website: www.mionegroup.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] DB Problems upgrading to RT 3.8.2 from 3.6.5
Jesse, Thanks for the suggestion - this is running on a separate test machine with nothing else running on it. Admittedly, it is running in a Xen VM, although this is the only VM on the underlying server and has been allocated both CPUs and all the RAM available. The file system is on the underlying disk, not an image on the underlying filesystem. I will try with mysqltuner and get back to you. The nightly backups are another option - the dump takes a couple of hours from memory, the reload takes 8. I'll look into that if mysqltuner doesn't help. Cheers, David - Original Message - From: Jesse Vincent je...@bestpractical.com To: David Hobley david.hob...@mionegroup.com Cc: rt-users@lists.bestpractical.com Sent: Tuesday, 3 March, 2009 8:34:27 AM GMT +10:00 Brisbane Subject: Re: [rt-users] DB Problems upgrading to RT 3.8.2 from 3.6.5 On Tue, Mar 03, 2009 at 08:23:31AM +1000, David Hobley wrote: If that is the case, then RT is un-upgradeable. Which would be a problem obviously. I can't take out our database for 6 days. Over a weekend, sure. But no more than that. Does anyone have any suggestions as to how I can optimise this at all? Hm. I've made this schema change to larger RT instances in much less time. How heavily loaded is your database? How much IO contention is there? First up, you should make sure you've tuned mysql a bit. 30 minutes with mysqltuner can be a night-and-day change. How long do your nightly MySQL backups of RT take? Another option might be to dump, massage the schema and load. -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : david.hob...@mionegroup.com Website: www.mionegroup.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] DB Problems upgrading to RT 3.8.2 from 3.6.5
Hello, I have a (happily) running RT 3.6.5 with approx 300,000 tickets in it and a database of size of around 9 Gig (lots of attachments sadly). I have the application upgraded, but when I try and run the schema upgrade in my test environment it is taking forever (for values of forever which equate to around 6 days anyway): # perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 root password ~/sql.queries # time `mysql -p rt3 ~/sql.queries` Enter password: real 8727m23.622s user 0m0.012s sys 0m0.004s Does anyone have any suggestions as to how I can make this faster? I have tried to optimise MySQL as much as possible, but I am not a db expert and obviously there is something wrong. Nb. The test environment is actually more powerful than the production one after having shutdown evey VM on the machine and ensured I was only running this for the time it took. -- 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] Problem after an upgrade to 3.8.1
Sebastien,
I had this issue as well - luckily I was running in a Virtual Machine, so I
upped the allocated memory from 1Gig to 2Gig and the problem went away. It
looks like RT is a bit of a memory pig (in the nicest possible way!) How much
memory do you have in your machine?
Cheers,
David
- Original Message -
From: Sebastien Termeau [EMAIL PROTECTED]
To: rt-users@lists.bestpractical.com
Sent: Wednesday, 20 August, 2008 11:22:13 PM GMT +10:00 Brisbane
Subject: [rt-users] Problem after an upgrade to 3.8.1
Dear RT-Users,
I have a really recent RT 3.6.7 installation (around 200 tickets)
running on CentOS 5.2.
I was able to upgrade to 3.8.0 without problems.
The problems appear when I tried to upgrade either from 3.6.7 to 3.8.1
or from 3.8.0 to 3.8.1. A fresh 3.8.1 installation works fine.
After the upgrade, when I try to access the web interface I only
receive a blank page.
In my apache error log file, the following message is present:
Out of memory!
Callback called exit.
I got the same error when I tried to use rt-clean-sessions.
Using 'perl -d', I tracked down the error to
RT::Interface::Web::Session::ClearByUser line 246
eval { tie %session, $class, $id, $attrs };
- $class=Apache::Session::MySQL
- $id=3d97a1c2c09740acfee006d0221d1d12
- attrs is an empty hash
I tried to remove all the existing sessions in the database : delete
from sessions;
And it was working fine for 5 minutes. Then the same error rise again.
Did I missed something in the upgrade process?
Do you have a suggestion?
Regards
___
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
--
Cheers,
David Hobley
IT Manager
Creators of Miessence, MiVitality and MiEnviron
Phone: +61 (7) 5582 7020
Fax: +61 (7) 5539 6719
USA Fax 1800 840 0827
Email : [EMAIL PROTECTED]
Website: www.mionegroup.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] RT38 not maintaining authentication (with RT::Authen::ExternalAuth)
Graham, We, the session has been stable for the afternoon for us anyway. So thank you for that! Cheers, David - Original Message - From: David Hobley [EMAIL PROTECTED] To: Graham Ballantyne [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Sent: Tuesday, 19 August, 2008 2:26:18 PM GMT +10:00 Brisbane Subject: Re: [rt-users] RT38 not maintaining authentication (with RT::Authen::ExternalAuth) Graham, Thanks for that - this workaround (which was not required for us in 3.6.6) has stopped the issue now, although I'll monitor it over the next couple of hours and let you know whether it is working in the longer term or not. Cheers, David - Original Message - From: Graham Ballantyne [EMAIL PROTECTED] To: David Hobley [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Sent: Tuesday, 19 August, 2008 2:23:34 PM GMT +10:00 Brisbane Subject: Re: [rt-users] RT38 not maintaining authentication (with RT::Authen::ExternalAuth) This has been happening to me as well, but with the built-in authentication. I was able to work around it by setting Set($WebSessionClass, 'Apache::Session::File'); in RT_SiteConfig.pm, but I'd really like to know what's happening as well. We've seen a similar issue with our current 3.6.3 install; we use CAS (Central Authentication Service; http://www.ja-sig.org/products/cas/) to handle campus-wide single sign-on and we'll often have RT kick us back out to the CAS login screen and CAS won't be able to re- authenticate us until several login attempts have passed. It's gotten so bad that we've cron'd a RT restart every couple of hours. I'm hoping that 3.8.1 would help, but after hearing your report... On 18-Aug-08, at 18:32 , David Hobley wrote: All, I am just testing the new RT 3.8.1 prior to rolling it out to the users here. I have configured ExternalAuth to use our LDAP server (only) and now while I can successfully log in, everytime I click on anything it takes me back to the login screen. I note on the Wiki that Mike talks about RT::Authen::CookieAuth with regards keeping the session logged in, but I didn't think I should need this? I thought the base RT maintained logged in status? Any pointers as to where I could look to work out what is happening? -- Cheers, David ___ 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 -- Graham Ballantyne [EMAIL PROTECTED] Institutional, Collaborative Academic Technologies IT Services Simon Fraser University Burnaby, BC V5A 1S6 p: 778-782-2014 www.sfu.ca/icat -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.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 -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.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] RT38 not maintaining authentication (with RT::Authen::ExternalAuth)
Graham, Thanks for that - this workaround (which was not required for us in 3.6.6) has stopped the issue now, although I'll monitor it over the next couple of hours and let you know whether it is working in the longer term or not. Cheers, David - Original Message - From: Graham Ballantyne [EMAIL PROTECTED] To: David Hobley [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Sent: Tuesday, 19 August, 2008 2:23:34 PM GMT +10:00 Brisbane Subject: Re: [rt-users] RT38 not maintaining authentication (with RT::Authen::ExternalAuth) This has been happening to me as well, but with the built-in authentication. I was able to work around it by setting Set($WebSessionClass, 'Apache::Session::File'); in RT_SiteConfig.pm, but I'd really like to know what's happening as well. We've seen a similar issue with our current 3.6.3 install; we use CAS (Central Authentication Service; http://www.ja-sig.org/products/cas/) to handle campus-wide single sign-on and we'll often have RT kick us back out to the CAS login screen and CAS won't be able to re- authenticate us until several login attempts have passed. It's gotten so bad that we've cron'd a RT restart every couple of hours. I'm hoping that 3.8.1 would help, but after hearing your report... On 18-Aug-08, at 18:32 , David Hobley wrote: All, I am just testing the new RT 3.8.1 prior to rolling it out to the users here. I have configured ExternalAuth to use our LDAP server (only) and now while I can successfully log in, everytime I click on anything it takes me back to the login screen. I note on the Wiki that Mike talks about RT::Authen::CookieAuth with regards keeping the session logged in, but I didn't think I should need this? I thought the base RT maintained logged in status? Any pointers as to where I could look to work out what is happening? -- Cheers, David ___ 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 -- Graham Ballantyne [EMAIL PROTECTED] Institutional, Collaborative Academic Technologies IT Services Simon Fraser University Burnaby, BC V5A 1S6 p: 778-782-2014 www.sfu.ca/icat -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.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] RT running slowly... Caused by RTx-Shredder indexes
All, I ran an explain on the query in MySQL and noticed that it was using one of the RTx-Shredder indexes. After I deleted all those indexes things went back to normal. Phew. In case this is useful: mysql explain select distinct main.* from Users main cross join ACL ACL_4 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 ON ( Groups_3.id = CachedGroupMembers_2.GroupId ) WHERE (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType = Groups_3.Type) AND (Principals_1.id != '1') AND (Principals_1.PrincipalType = 'User') AND (ACL_4.RightName = 'OwnTicket') AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System')) AND ((Groups_3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role')) ORDER BY main.Name ASC; ++-+--++--+---+-+-+---+--+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+--++--+---+-+-+---+--+ | 1 | SIMPLE | main | range | PRIMARY | PRIMARY | 4 | NULL | 28920 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | Groups_3 | range | PRIMARY,Groups1,Groups2 | Groups1 | 67 | NULL | 119 | Using where; Using index; Distinct | | 1 | SIMPLE | Principals_1 | eq_ref | PRIMARY | PRIMARY | 4 | rt3.main.id | 1 | Using where; Distinct | | 1 | SIMPLE | CachedGroupMembers_2 | ref | DisGrouMem,SHREDDER_CGM1 | SHREDDER_CGM1 | 10 | rt3.main.id,rt3.Groups_3.id | 1 | Using where; Using index; Distinct | | 1 | SIMPLE | ACL_4 | range | ACL1 | ACL1 | 54 | NULL | 45 | Using where; Using index; Distinct | ++-+--++--+---+-+-+---+--+ Cheers, David - Original Message - From: David Hobley [EMAIL PROTECTED] To: rt-users rt-users@lists.bestpractical.com Sent: Thursday, 22 May, 2008 3:30:21 PM GMT +10:00 Brisbane Subject: [rt-users] RT running slowly... Hello, Our RT has been running slowly for a while; having turned on mysql slow query logging, it appears to only be a single query which is causing grief. Anyone any suggestions as to what can be done to fix this? # Time: 080522 15:32:21 # [EMAIL PROTECTED]: rt[rt] @ localhost [] # Query_time: 40 Lock_time: 0 Rows_sent: 0 Rows_examined: 6888927 SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 ON ( Groups_3.id = CachedGroupMembers_2.GroupId ) WHERE (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType = Groups_3.Type) AND (Principals_1.id != '1') AND (Principals_1.PrincipalType = 'User') AND (ACL_4.RightName = 'OwnTicket') AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System')) AND ((Groups_3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role')) ORDER BY main.Name ASC; -- Cheers, David ___ 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 -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.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] RT running slowly...
Hello, Our RT has been running slowly for a while; having turned on mysql slow query logging, it appears to only be a single query which is causing grief. Anyone any suggestions as to what can be done to fix this? # Time: 080522 15:32:21 # [EMAIL PROTECTED]: rt[rt] @ localhost [] # Query_time: 40 Lock_time: 0 Rows_sent: 0 Rows_examined: 6888927 SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL ACL_4 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 ON ( Groups_3.id = CachedGroupMembers_2.GroupId ) WHERE (Principals_1.Disabled = '0') AND (ACL_4.PrincipalType = Groups_3.Type) AND (Principals_1.id != '1') AND (Principals_1.PrincipalType = 'User') AND (ACL_4.RightName = 'OwnTicket') AND ((ACL_4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System')) AND ((Groups_3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role')) ORDER BY main.Name ASC; -- Cheers, David ___ 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] Help! Suddenly getting stacktraces
Michael,
Thanks for that - the problems have been resolved. I would never have guessed
that from the variable name.
Cheers,
David
- Original Message -
From: michael brader [EMAIL PROTECTED]
To: David Hobley [EMAIL PROTECTED]
Cc: rt-users rt-users@lists.bestpractical.com
Sent: Friday, 16 May, 2008 3:23:51 PM (GMT+1000) Auto-Detected
Subject: Re: [rt-users] Help! Suddenly getting stacktraces
David Hobley writes:
Michael,
Thanks for the quick response. Are you saying that these
stacktraces are not indicative of any issues and that I can ignore
them?
Well, you should set that variable to 0, because generating the stack
trace will have some overhead (presumably mostly in writing the lines
to the log).
Normally I would expect that anything that generated a stacktrace
would also require a fix to not generate them!
Normally you'd be right, but if it's LogStackTrace, it's not a stack
trace generated by Perl, but by RT. From RT.pm:
if( $RT::LogStackTraces ) {
$str .= \nStack trace:\n;
# skip calling of the Log::* subroutins
$frame++ while( caller($frame) (caller($frame))[3] =~ /^Log::/ );
while( my ($package, $filename, $line, $sub) = caller($frame++) ) {
$str .= \t. $sub .() called at $filename:$line\n;
}
}
Cheers,
Michael
--
Michael Brader [EMAIL PROTECTED]
--
Cheers,
David Hobley
IT Manager
Creators of Miessence, MiVitality and MiEnviron
Phone: +61 (7) 5582 7020
Fax: +61 (7) 5539 6719
USA Fax 1800 840 0827
Email : [EMAIL PROTECTED]
Website: www.mionegroup.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] Help! Suddenly getting stacktraces
Hello, We have been running RT for about a year and it has suddenly started running slowly. Looking at the RT.log file, we are seeing a whole bunch of stack-traces, for no reason I can ascertain. Anyone any ideas why these would suddenly start appearing? [Fri May 16 04:33:57 2008] [error]: SQL(0.00s): SELECT count(main.id) FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Queue = '22' AND main.Status = 'stalled') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ; (/opt/rt3/share/html/autohandler:319) Stack trace: HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm:135 HTML::Mason::Component::run() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1246 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1245 HTML::Mason::Request::comp() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:411 HTML::Mason::Request::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:168 HTML::Mason::Request::ApacheHandler::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:826 HTML::Mason::ApacheHandler::handle_request() called at /opt/rt3/bin/webmux.pl:125 (eval)() called at /opt/rt3/bin/webmux.pl:125 RT::Mason::handler() called at -e:0 (eval)() called at -e:0 [Fri May 16 04:33:57 2008] [error]: SQL(0.00s): SELECT count(main.id) FROM Tickets main WHERE (main.Status != 'deleted') AND (main.Queue = '13' AND main.Status = 'new') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) ; (/opt/rt3/share/html/autohandler:319) Stack trace: HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Component.pm:135 HTML::Mason::Component::run() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1246 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:1245 HTML::Mason::Request::comp() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:459 (eval)() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/Request.pm:411 HTML::Mason::Request::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:168 HTML::Mason::Request::ApacheHandler::exec() called at /usr/lib/perl5/vendor_perl/5.8.8/HTML/Mason/ApacheHandler.pm:826 HTML::Mason::ApacheHandler::handle_request() called at /opt/rt3/bin/webmux.pl:125 (eval)() called at /opt/rt3/bin/webmux.pl:125 RT::Mason::handler() called at -e:0 (eval)() called at -e:0 -- Cheers, David ___ 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] Help! Suddenly getting stacktraces
Michael, Thanks for the quick response. Are you saying that these stacktraces are not indicative of any issues and that I can ignore them? Normally I would expect that anything that generated a stacktrace would also require a fix to not generate them! Cheers, David - Original Message - From: michael brader [EMAIL PROTECTED] To: David Hobley [EMAIL PROTECTED] Cc: rt-users rt-users@lists.bestpractical.com Sent: Friday, 16 May, 2008 2:54:25 PM GMT +10:00 Brisbane Subject: Re: [rt-users] Help! Suddenly getting stacktraces David Hobley writes: Hello, We have been running RT for about a year and it has suddenly started running slowly. Looking at the RT.log file, we are seeing a whole bunch of stack-traces, for no reason I can ascertain. Anyone any ideas why these would suddenly start appearing? Try having a look in etc/RT_SiteConfig.pm for a line like this: Set( $LogStackTraces , 1 ); and set it to 0 or comment it out. Cheers, Michael Brader -- Michael Brader [EMAIL PROTECTED] -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.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] SOLVED? LDAP_INVALID_CREDENTIALS error with 'ExternalAuth' extension
Mike, I would certainly like to see this. *wish mode* If you could drag down group memberships as well and if they exist in RT, then add that user to those RT groups, I would love to see that as well as it would mean all the functionality for User creation could be setup via LDAP as well. MediaWiki does this and it works well (although far less complicated than RT I suspect). Cheers, David - Original Message - From: Mike Peachey [EMAIL PROTECTED] To: Kenneth Crocker [EMAIL PROTECTED] Cc: Pedro Lobo S. da Rocha [EMAIL PROTECTED], RT Users rt-users@lists.bestpractical.com Sent: Saturday, 12 April, 2008 9:51:45 PM GMT +10:00 Brisbane Subject: Re: [rt-users] SOLVED? LDAP_INVALID_CREDENTIALS error with 'ExternalAuth' extension I have a thought. I don't know whether I will need to override the AutoCreate method or if I can do it all just by passing params from the autohandler auth callback, but it seems reasonable that I should be able to easily allow LDAP users to be autocreated as Privileged, while leaving the default AutoCreation at unprivileged. This way, by way of a configuration setting, that is individual to each ExternalAuth configuration group (LDAP/DBI etc) you could specify whether to autocreate as privileged or unprivileged, and RT would still retain it's own default setting for *other* users.. Do you think this is something you'd want built into the extension? Opinions welcome. -- Kind Regards, ___ Mike Peachey, IT Tel: +44 (0) 114 281 2655 Fax: +44 (0) 114 281 2951 Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK http://www.jennic.com Confidential ___ 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] Embedding Images in WikiText?
All, Can I assume from the lack of response to this question that it isn't possible? Cheers, David - Original Message - From: David Hobley [EMAIL PROTECTED] To: rt-users rt-users@lists.bestpractical.com Sent: Monday, 7 April, 2008 7:30:59 PM GMT +10:00 Brisbane Subject: [rt-users] Embedding Images in WikiText? All, Is it possible to embed images within an RTFM WikiText area? I have been trying various combinations of things which work the MediaWiki, but can't get it working within RT. -- Cheers, David ___ 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] Embedding Images in WikiText?
All, Is it possible to embed images within an RTFM WikiText area? I have been trying various combinations of things which work the MediaWiki, but can't get it working within RT. -- Cheers, David ___ 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] Attachments on reply
Holger, In the template you use for the messages, you need to include: RT-Attach-Message: yes to ensure that Attachments get sent. Cheers, David On 05/12/2007, at 3:07 AM, Holger Haase wrote: Is there anybody out there wha can tell me a solution. Why are attachments that I add to a reply or when resolving a ticket in the WebUI are not send out by mail? We need this. Regards Holger. -- Message: 3 Date: Sun, 2 Dec 2007 10:08:03 +0100 From: Holger Haase [EMAIL PROTECTED] Subject: [rt-users] Attachments on reply To: rt-users@lists.bestpractical.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=utf-8 Hi all, Is there any way forwarding attachments when replying in addition to store them in the ticket? I use RT3.4.6 Thanks in advance, Holger. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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 SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] Re: Groups and LDAP
Karl, I had a look at this, but this really relates to ticket creation. What I am after is for RT to assign group membership based on LDAP group membership. I have a bunch of groups set up within RT and it would be great if users that get auto created from LDAP also get their group memberships created. MediaWiki does this well - on logon, it queries for LDAP group membership and adds/deletes users in the relevant (local) group based on that membership. Unless I have misunderstood that page of course ;-) Cheers, David - Original Message - From: Karl Boyken [EMAIL PROTECTED] To: rt-users@lists.bestpractical.com Sent: Friday, 30 November 2007 12:57:31 AM (GMT+1000) Australia/Brisbane Subject: [rt-users] Re: Groups and LDAP snip Hello, is there any addon that allows to synchronize RT groups with LDAP groups? Best regards M.A. /snip I ran across this just yesterday: http://wiki.bestpractical.com/view/ApproximateSeparateQueues It describes a method to use some custom fields in LDAP, but you could as easily use groups. Karl -- Karl Boyken, system administrator [EMAIL PROTECTED] 303A MLH, Dept. of Comp. Sci. http://www.cs.uiowa.edu/~boyken/ The U. of Iowa, Iowa City, IA 52242 319-335-2730 (voice) 319-335-3668 (fax) -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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: Groups and LDAP
Did you ever work out how to achieve this? I am in the same boat - I have User authentication working via LDAP, but would like to assign group membership through it as well. Cheers, David -Original Message- From: Dummy cerberus dummycerberus[at]gmail.com Thanks for your answer... before posting the previous message I had browsed the Wiki and could only find the info about setting up authentication with LDAP... it worked OK, but I couldn't (can't) find the info about making RT get info about which RT groups my user belongs to from the LDAP groups he belongs to... Thanks for your patiente, and best regards On 9/17/07, stever[at]up-south.com stever[at]up-south.com wrote: Yes check the wiki Sent via BlackBerry i can be reached at (310) 947-8565 -Original Message- From: Dummy cerberus dummycerberus[at]gmail.com Date: Mon, 17 Sep 2007 08:35:00 To:rt-users rt-users[at]lists.bestpractical.com Subject: [rt-users] Groups and LDAP Hello, is there any addon that allows to synchronize RT groups with LDAP groups? Best regards M.A. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sales[at]bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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] Can I deselect a Global Scrip on a per queue basis?
Hello, We have been using RT for a while and are very happy with it (once we got our users trained up to the right level of geekyness). We have approximately 25 queues currently for various problem areas with 9 or so global scrips which apply to all queues and for the most part, this works well. However, there are 2 or 3 queues for which we don't want to apply the global scrips. Is there any way I can specify that a queue should not use a global scrip? The alternative appears to be to define per queue scrips which would be painful for 25 queues, not to mention much more maintenance if we want to change anything. Thanks for your time! -- Cheers, David Hobley ___ 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] Can I deselect a Global Scrip on a per queue basis?
Looking through the Mail archives, Dirk Pape has an extension for this, but all links point to his page which appears to no longer exist. Anyone have a link to the latest version of this extension? The link I have from the Wiki is: http://page.mi.fu-berlin.de/~pape/rt3screenshots/ Cheers, David - Original Message - From: Kenneth Crocker [EMAIL PROTECTED] To: David Hobley [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Sent: Thursday, 11 October 2007 09:36:08 AM (GMT+1000) Australia/Brisbane Subject: Re: [rt-users] Can I deselect a Global Scrip on a per queue basis? David, Alas, I don't believe there is an easy way. The only way I know of is to make the scrips queue based. Kenn LBNL On 10/10/2007 3:43 PM, David Hobley wrote: Hello, We have been using RT for a while and are very happy with it (once we got our users trained up to the right level of geekyness). We have approximately 25 queues currently for various problem areas with 9 or so global scrips which apply to all queues and for the most part, this works well. However, there are 2 or 3 queues for which we don't want to apply the global scrips. Is there any way I can specify that a queue should not use a global scrip? The alternative appears to be to define per queue scrips which would be painful for 25 queues, not to mention much more maintenance if we want to change anything. Thanks for your time! -- Cheers, David Hobley ___ 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 -- Cheers, David Hobley IT Manager Creators of Miessence, MiVitality and MiEnviron Phone: +61 (7) 5582 7020 Fax: +61 (7) 5539 6719 USA Fax 1800 840 0827 Email : [EMAIL PROTECTED] Website: www.mionegroup.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] Problem viewing HTML component of an email in Firefox
All, I asked a similar question a while ago, but got no response - possibly because I was a little unclear on the failure condition. If anyone could help, I would appreciate it. We receive a number of emails into RT which are predominantly HTML. We need to view the HTML in order to click on embedded links. With Internet Explorer, this works as expected. We view the ticket, click on the link which reads: Download (untitled) [text/html 5.7k] and the HTML component displays correctly. In Firefox however, the source of the HTML displays (starting with a table tag) rather than the nicely formatted version. Has anyone managed to make this work as expected in Firefox? Cheers, David ___ 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] Displaying HTML email as HTML in the page
Hello, We have just started using RT for internal products requests and the only real issue we have had so far is that when viewing a ticket, while there is a link to the HTML attachment, actually clicking on it results in the HTML source being displayed. We actually need to be able to see the actual HTML page itself (in a new window would be fine - currently we have to save the .html to disc and then open it using Firefox). Is there any way to configure this behaviour? Cheers, David ___ 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
