Re: [rt-users] Differentiating while sending notifictions
Dnia 2013-08-01, czw o godzinie 12:21 -0400, Kevin Falcone pisze: Our RT web interface is used mainly locally. We have links included in templates, but external users usually don't have credentials to log in into web interface, so links just confuse them. We'd like to split templates so that only those with access get links and others don't. Unfortunately, RT uses one template to generate all the mail to all the Requestors, so you can't solve this with templates. One way to solve this is having some custom notification actions (perhaps with rt-email-group-admin to notify some internal users separately from the others). The only real solution is likely to have some sort of Notify Privileged Users vs Notify Unprivileged Users Scrip Actions that subclass the Notify action and override which Requestors are picked. It'll be weird because half the Requestors would be notified in a clump and then the others would be notified. Or to convert RT to sending one email per user. Few months ago I've implemented something similar - a role for traffic manager. It consists of a per-queue custom field, some local modifications in Action.pm and custom ScripActions in DB. I'll probably gonna try to customize it so that we can have the kind of ScripActions you've mentioned. In my opinion it would be great to have a easy-to-use mechanism for creation of custom roles like 'Requestor' od 'AdminCc'. Regards, -- Robert Wysocki administrator systemów linuksowych administrator baz danych Grupa Unity | ul. Przedmiejska 6-10, 54-201 Wrocław ul. Conrada 55B, 31-357 Kraków | ul. Złota 59, 00-120 Warszawa
Re: [rt-users] (RT::Authen::ExternalAuth) email exists problem authenticating trough AD
Hi You are right, i'm using RT::Authen::ExternalAuth. It binds because i receive all aditional fields and even creates the user with those . The problem is really focused on authentication step and i can't understand why :(
Re: [rt-users] Help with SummaryByUsers extension
Thank you Kevin. So now that I added it via Edit, I'm getting "internal error" and it doesn't show up.The rt.log is empty. However, the /var/log/messages has this error message: Aug 2 09:01:32 rttrack RT: could not find component for path 'SummaryByUser'#012#012Stack:#012 [/rtdata/share/html/Elements/MyRT:95]#012 [/rtdata/share/html/index.html:78]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:635]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:335]#012 [/rtdata/share/html/autohandler:53] (/rtdata/sbin/../lib/RT/Interface/Web/Handler.pm:208) Any ideas on how i would troubleshoot this? I'm on RT 4.013. Perhaps the extension is just not compatible?Thank you!-RSent from iCloudOn Aug 01, 2013, at 04:29 PM, Kevin Falcone falc...@bestpractical.com wrote:On Thu, Aug 01, 2013 at 06:28:41PM +, window camera wrote:Does anyone know how to use this or where to find the Summery By User option in the GUI?? Click 'Edit' in the upper right hand corner of your RT at a Glance page, choose it from the list to add it to the page. Or edit a dashboard and add it there. -kevin
Re: [rt-users] Help with GNATT RT Extension: Doesn't show up!
Thanks Nathan. Yes, I have cleared the Mason cache and the browser cache.Still, unfortunately, I don't see any option anywhere for the GNATT reports. Perhaps the GNATT extension is not compatible with RT 4.013? May I ask where the GNATT extension is supposed to show up in the GUI? Thank you-RSent from iCloudOn Aug 01, 2013, at 03:29 PM, Nathan Cutler presnyprek...@gmail.com wrote:However, there seems to be no option on the RT GUI to run the GNATTextension. Just to be sure: did you clean the Mason cache and your browser's cache, too?
Re: [rt-users] Migration Prep
On Thu, Aug 01, 2013 at 12:40:44PM -0700, Paul O'Rorke wrote: I don't remember skipping any errors during make upgrade-database. Here are the table descriptions you asked for. As you can see the Classes, Topics, Articles tables do exist. Do you have logs of the upgrade? Hopefully you will be able to tell what I need to do to my DB to fix this... Really- you need to do another test upgrade and figure out what fails. While I can tell you how to fix Users, I wouldn't trust that other parts of the upgrade didn't fail. mysql describe ACL; mysql describe Groups; mysql describe GroupMembers; mysql describe CustomFieldValues; mysql describe Tickets; mysql describe CustomFields; mysql describe Queues; mysql show tables; These all look correct. That shows that you at least ran upgrades through 3.9.7, but the User change for Password that you're missing was 4.0.0rc4. Did you stop anywhere or let it run everything through 4.0.16? You can look at 'show create table sessions' which should be innodb not myisam and look at your Attributes table, which should have a LONGBLOB for Content. While I've seen errors that reset the Password field to the wrong size on 3.6 - 4.0 upgrades, those don't apply to a 3.8 - 4.0 upgrade. At this point, I'd rerun a database upgrade, paying close attention to what steps run and watching the screen and the mysql error logs for errors. -kevin pgpUZiiu6z98l.pgp Description: PGP signature
Re: [rt-users] Help with GNATT RT Extension: Doesn't show up!
Under Links next to Graph when viewing a ticket. On Fri, Aug 2, 2013 at 10:38 AM, window camera front...@me.com wrote: May I ask where the GNATT extension is supposed to show up in the GUI? -- Later, Darin
Re: [rt-users] Date/Time Output Format
On Thu, Aug 01, 2013 at 03:25:00PM -0700, Tim Gustafson wrote: How does one add an additional option to the drop-down for Date format under the Locale fieldset on individual user's Settings pages? I'd like to add mm/dd/ hh:ii A as an option - my users don't need/want seconds to be displayed there, but would like am/pm to show. I looked at $DateTimeFormat but I don't see how that would enable me to let users still have the option of other formats. All I want to do is add a new option, not take away the old ones. Setting $DateTimeFormat controls the default your users get, there are some examples of defining 'custom' ones, such as ISO without seconds, or RFC2822 without seconds. If there's an option already which is 'close' to what you want, you might be able to do that. Otherwise, if you need something wholly custom, it's a pretty simple plugin to add to the list, I've written one or two: https://metacpan.org/module/RT::Extension::DateTAI64 you can see it's a tiny amount of perl code at the bottom of the file, most of the text is documentation: http://api.metacpan.org/source/FALCONE/RT-Extension-DateTAI64-0.01/lib/RT/Extension/DateTAI64.pm -kevin pgpbF9yHsL3zt.pgp Description: PGP signature
Re: [rt-users] Help with SummaryByUsers extension
On Fri, Aug 02, 2013 at 01:45:03PM +, window camera wrote: So now that I added it via Edit, I'm getting internal error and it doesn't show up. You said you registered the component in HomepageComponents, did you also enable it as a plugin? The rt.log is empty. However, the /var/log/messages has this error message: Aug 2 09:01:32 rttrack RT: could not find component for path 'SummaryByUser'#012#012Stack:#012 [/rtdata/share/html/Elements/MyRT:95]#012 [/rtdata/share/html/index.html:78]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:635]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:335]#012 [/rtdata/share/html/autohandler:53] (/rtdata/sbin/../lib/RT/Interface/Web/Handler.pm:208) Any ideas on how i would troubleshoot this? I'm on RT 4.013. Perhaps the extension is just not compatible? You also cut off part of this that would have shown the search paths for where it was looking for the file. -kevin pgpA2cpgNnR3f.pgp Description: PGP signature
Re: [rt-users] Migration Prep
On Fri, Aug 2, 2013 at 10:48 AM, Kevin Falcone falc...@bestpractical.comwrote: You can look at 'show create table sessions' which should be innodb not myisam and look at your Attributes table, which should have a LONGBLOB for Content. I just did my test upgrade from rt 3.8.2 / mysql 5.0.75 to rt 4.0.16 / mysql 5.5.32 but session table still showing myisam. $ mysql -e 'use rt4; show create table sessions' | sessions | CREATE TABLE `sessions` ( `id` varbinary(32) NOT NULL DEFAULT '', `a_session` longblob, `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | I guess I can just ALTER the session table now? -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
Re: [rt-users] Migration Prep
On Fri, Aug 02, 2013 at 11:21:24AM -0400, Asif Iqbal wrote: On Fri, Aug 2, 2013 at 10:48 AM, Kevin Falcone [1]falc...@bestpractical.com wrote: You can look at 'show create table sessions' which should be innodb not myisam and look at your Attributes table, which should have a LONGBLOB for Content. I just did my test upgrade from rt 3.8.2 / mysql 5.0.75 to rt 4.0.16 / mysql 5.5.32 but session table still showing myisam. $ mysql -e 'use rt4; show create table sessions' | sessions | CREATE TABLE `sessions` ( `id` varbinary(32) NOT NULL DEFAULT '', `a_session` longblob, `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | I guess I can just ALTER the session table now? Please show a log of your make upgrade-database step One of the steps explicitly drops and recreates the sessions table. -kevin pgpKmzGNJ98Sj.pgp Description: PGP signature
Re: [rt-users] Help with SummaryByUsers extension
You said you registered the component in HomepageComponents, did you also enable it as a plugin?Yes, I did. Homepagecomponents setting is in RT_Config.pm: Set( $HomepageComponents, [ qw(QuickCreate Quicksearch MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches SummaryByUser) # loc_qw ] ); =back And the plugin setting is in RT_SiteConfig.pm.Is there anyway that you know of that I can increase the logging? Or perhaps there is another log file somewhere? Also, perhaps it's just not compatible with RT 4.13. Do you know how to go about uninstalling it?You also cut off part of this that would have shown the search paths for where it was looking for the file.Unfortunately, that's how it shows up in the log file /var/log/messages. The RT engine cuts them off in the log file.Thank you for looking into this!-RickOn Aug 02, 2013, at 10:56 AM, Kevin Falcone falc...@bestpractical.com wrote:On Fri, Aug 02, 2013 at 01:45:03PM +, window camera wrote:So now that I added it via Edit, I'm getting "internal error" and it doesn't show up. You said you registered the component in HomepageComponents, did you also enable it as a plugin? The rt.log is empty. However, the /var/log/messages has this error message:Aug 2 09:01:32 rttrack RT: could not find component for path 'SummaryByUser'#012#012Stack:#012 [/rtdata/share/html/Elements/MyRT:95]#012 [/rtdata/share/html/index.html:78]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:635]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:335]#012 [/rtdata/share/html/autohandler:53] (/rtdata/sbin/../lib/RT/Interface/Web/Handler.pm:208)Any ideas on how i would troubleshoot this? I'm on RT 4.013. Perhaps the extension is just not compatible? You also cut off part of this that would have shown the search paths for where it was looking for the file. -kevin
Re: [rt-users] Help with SummaryByUsers extension
On Fri, Aug 02, 2013 at 03:33:48PM +, window camera wrote: You said you registered the component in HomepageComponents, did you also enable it as a plugin? Yes, I did. Homepagecomponents setting is in RT_Config.pm: This is wrong. Always make your changes in RT_SiteConfig.pm, never in RT_Config.pm or they'll be lost when you upgrade. Read lines 9 through 17 of RT_Config.pm: # WARNING # # # # NEVER EDIT RT_Config.pm ! # # # # Instead, copy any sections you want to change to # # RT_SiteConfig.pm and edit them there. Otherwise, # # your changes will be lost when you upgrade RT.# # # # WARNING # Set( $HomepageComponents, [ qw(QuickCreate Quicksearch MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches SummaryByUser) # loc_qw ] ); That's not actually correct. This plugin provides two components. OwnerSummmary and RequestorSummary. Go delete SummaryByUser from your RT at a Glance page, fix HomepageComponents to contain valid components and then add them to the page. -kevin pgpqlZccw6IZD.pgp Description: PGP signature
Re: [rt-users] Migration Prep
On Fri, Aug 2, 2013 at 11:32 AM, Kevin Falcone falc...@bestpractical.comwrote: I just did my test upgrade from rt 3.8.2 / mysql 5.0.75 to rt 4.0.16 / mysql 5.5.32 but session table still showing myisam. $ mysql -e 'use rt4; show create table sessions' | sessions | CREATE TABLE `sessions` ( `id` varbinary(32) NOT NULL DEFAULT '', `a_session` longblob, `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | I guess I can just ALTER the session table now? Please show a log of your make upgrade-database step One of the steps explicitly drops and recreates the sessions table. ~/src/rt-4.0.16# make upgrade-database /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost (port '') as root Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: localhost Port: Name: rt4 User: rt_user DBA: root Enter RT version you're upgrading from: 3.8.2 Going to apply following upgrades: * 3.8.3 * 3.8.4 * 3.8.6 * 3.8.8 * 3.8.9 * 3.9.1 * 3.9.2 * 3.9.3 * 3.9.5 * 3.9.6 * 3.9.7 * 3.9.8 * 4.0.1 * 4.0.3 * 4.0.4 * 4.0.6 * 4.0.9 * 4.0.12 * 4.0.13 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP Proceed [y/N]:y Processing 3.8.3 Now inserting data. Processing 3.8.4 Now inserting data. Processing 3.8.6 Now inserting data. Processing 3.8.8 Now inserting data. [Fri Aug 2 16:42:55 2013] [warning]: Couldn't set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32) [Fri Aug 2 16:42:55 2013] [warning]: Couldn't set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32) Processing 3.8.9 Now inserting data. [Fri Aug 2 16:42:58 2013] [warning]: Use of uninitialized value in string eq at /home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm line 652, line 1. (/home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm:652) [Fri Aug 2 16:42:58 2013] [warning]: Use of uninitialized value in string eq at /home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm line 652, line 1. (/home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm:652) [Fri Aug 2 16:42:58 2013] [warning]: Use of uninitialized value in string eq at /home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm line 652, line 1. (/home/iqbala/src/rt-4.0.16/sbin/../lib/RT/Template.pm:652) Processing 3.9.1 Now inserting data. [Fri Aug 2 16:43:03 2013] [warning]: Unable to grant ExecuteCode on principal 685493: NSI already has that right (./etc/upgrade/3.9.1/content:63) Processing 3.9.2 Now inserting data. Processing 3.9.3 Now populating database schema. Processing 3.9.5 Now populating database schema. Processing 3.9.6 Now populating database schema. Processing 3.9.7 Now populating database schema. Now inserting data. Processing 3.9.8 Now populating database schema. Now inserting data. [Fri Aug 2 16:46:20 2013] [error]: You appear to be upgrading from RTFM 2.0 - We don't support upgrading this old of an RTFM yet (./etc/upgrade/3.9.8/content:11) [Fri Aug 2 16:46:20 2013] [error]: We found RTFM tables in your database. Checking for content. (./etc/upgrade/3.9.8/content:14) [Fri Aug 2 16:46:20 2013] [error]: You appear to have RTFM Articles. You can upgrade using the etc/upgrade/upgrade-articles script. Read more about it in docs/UPGRADING-4.0 (./etc/upgrade/3.9.8/content:20) Processing 4.0.1 Now inserting data. Processing 4.0.3 Now inserting data. Processing 4.0.4 Now inserting data. Processing 4.0.6 Now populating database schema. Now inserting data. Processing 4.0.9 Now inserting data. Processing 4.0.12 Now populating database schema. Processing 4.0.13 Now populating database schema. Done. root@newwebrt:~/src/rt-4.0.16# -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
Re: [rt-users] Help with SummaryByUsers extension
This is wrong. Always make your changes in RT_SiteConfig.pm, never in RT_Config.pm or they'll be lost when you upgrade.Yes, I know it's wrong to do it there. Had no choice though. There was absolutely no information or documenation on how to setup "HomepageCompoents" in RT_SiteConfig.pm. I searched far and wide for it.Do you happen to know how? I'll tell you how I did it though (in RT_SiteConfig.pm): SET ( HomepageComponents, qw('SummaryByUser'));and I also added the SummaryByUser in the @plugins. Howerver, got the same exact error. No dice. Just error'ed out again. I'm just a little baffled why these extensions don't come with a README that gives directions on how to set it up. Anyway I digress. Go delete SummaryByUser from your RT at a Glance page, fix HomepageComponents to contain valid components and then add them to the page.Yes, thanks. I did do that. Same error. See above configuration I did in RT_SiteConfig.pm. Now when I add "OwnerSummary" as you said, I get error "Error while loading can't locate RT/Extensions/OwnerSummary.pm. Any other things you think I should check? Or perhaps now we're at the point where this extension is perhaps not compatible with RT 4.13?Thank youRickSent from iCloudOn Aug 02, 2013, at 11:49 AM, Kevin Falcone falc...@bestpractical.com wrote:On Fri, Aug 02, 2013 at 03:33:48PM +, window camera wrote:You said you registered the component in HomepageComponents, did youalso enable it as a plugin?Yes, I did. Homepagecomponents setting is in RT_Config.pm: This is wrong. Always make your changes in RT_SiteConfig.pm, never in RT_Config.pm or they'll be lost when you upgrade. Read lines 9 through 17 of RT_Config.pm: # WARNING # # # # NEVER EDIT RT_Config.pm ! # # # # Instead, copy any sections you want to change to # # RT_SiteConfig.pm and edit them there. Otherwise, # # your changes will be lost when you upgrade RT. # # # # WARNING # Set($HomepageComponents,[qw(QuickCreate Quicksearch MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches SummaryByUser) # loc_qw]); That's not actually correct. This plugin provides two components. OwnerSummmary and RequestorSummary. Go delete SummaryByUser from your RT at a Glance page, fix HomepageComponents to contain valid components and then add them to the page. -kevin
Re: [rt-users] Migration Prep
On Fri, Aug 02, 2013 at 12:49:47PM -0400, Asif Iqbal wrote: Please show a log of your make upgrade-database step * 3.9.8 * 4.0.1 That's definitely skipping steps. It should read: * 3.9.8 * 4.0.0rc2 * 4.0.0rc4 * 4.0.0rc7 * 4.0.1 What does ls -l etc/upgrade/ in the directory where you're running make upgrade-database show? ls -l etc/upgrade/4.0.0rc*/ would also be interesting. -kevin pgpityBl0dLTl.pgp Description: PGP signature
Re: [rt-users] Migration Prep
Thanks again Kevin, OK - I'll roll back and run the upgrade again from 3.8.4. Do you have logs of the upgrade? How do I enable/check logging for that? *Paul O'Rorke* Tracker Software Products p...@tracker-software.com mailto:paul.oro...@tracker-software.com On 8/2/2013 7:48 AM, Kevin Falcone wrote: On Thu, Aug 01, 2013 at 12:40:44PM -0700, Paul O'Rorke wrote: I don't remember skipping any errors during make upgrade-database. Here are the table descriptions you asked for. As you can see the Classes, Topics, Articles tables do exist. Do you have logs of the upgrade? Hopefully you will be able to tell what I need to do to my DB to fix this... Really- you need to do another test upgrade and figure out what fails. While I can tell you how to fix Users, I wouldn't trust that other parts of the upgrade didn't fail.
Re: [rt-users] Help with SummaryByUsers extension
On Fri, Aug 02, 2013 at 05:03:32PM +, window camera wrote: This is wrong. Always make your changes in RT_SiteConfig.pm, never in RT_Config.pm or they'll be lost when you upgrade. Yes, I know it's wrong to do it there. Had no choice though. There was absolutely no information or documenation on how to setup HomepageCompoents in RT_SiteConfig.pm. I searched far and wide for it. Um. Copy it from RT_Config.pm to RT_SiteConfig.pm and modify it there.o The documentation I copied that you deleted said what to do. # WARNING # # # # NEVER EDIT RT_Config.pm ! # # # # Instead, copy any sections you want to change to # # RT_SiteConfig.pm and edit them there. Otherwise, # # your changes will be lost when you upgrade RT.# # # # WARNING # Do you happen to know how? I'll tell you how I did it though (in RT_SiteConfig.pm): SET ( HomepageComponents, qw('SummaryByUser')); Nope, SET is invalid, it's Set (copy, don't retype). Exactly the line you had in RT_Config.pm goes in RT_SiteConfig.pm. Then you add OwnerSummary to that HomepageComponents line. (The names OwnerSummary and RequestorSummary are documented in the DESCRIPTION section of the README shipped with the extension). and I also added the SummaryByUser in the @plugins. @Plugins, not @plugins. You still haven't shown your plugins configuration. Howerver, got the same exact error. No dice. Just error'ed out again. I'm just a little baffled why these extensions don't come with a README that gives directions on how to set it up. Anyway I digress. Most extensions do, this one is underdocumented. Go delete SummaryByUser from your RT at a Glance page, fix HomepageComponents to contain valid components and then add them to the page. Yes, thanks. I did do that. Same error. See above configuration I did in RT_SiteConfig.pm. Now when I add OwnerSummary as you said, I get error Error while loading can't locate RT/Extensions/OwnerSummary.pm. No, don't add that to plugins, you add that to HomepageComponents. Any other things you think I should check? Or perhaps now we're at the point where this extension is perhaps not compatible with RT 4.13? This extension is compatible with 4.0.13. I'm the developer who contributed a patch to make it compatible with RT4. Since you don't seem to be following my explanations, I'll copy and paste the correct configuration here, but then you're on your own. Set( $HomepageComponents, [ qw(QuickCreate Quicksearch MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches OwnerSummary) # loc_qw ] ); Set( @Plugins, qw(RT::Extension::SummaryByUser)); If you use more than one plugin, this @Plugins line is incorrect and will disable other plugins. You must specify them all in a single @Plugins line. -kevin pgpSihzHYGRax.pgp Description: PGP signature
Re: [rt-users] Migration Prep
On Fri, Aug 2, 2013 at 1:04 PM, Kevin Falcone falc...@bestpractical.comwrote: On Fri, Aug 02, 2013 at 12:49:47PM -0400, Asif Iqbal wrote: Please show a log of your make upgrade-database step * 3.9.8 * 4.0.1 That's definitely skipping steps. It should read: * 3.9.8 * 4.0.0rc2 * 4.0.0rc4 * 4.0.0rc7 * 4.0.1 What does ls -l etc/upgrade/ in the directory where you're running make upgrade-database show? ~/src/rt-4.0.16$ ls -al etc/upgrade/ ... drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.8.8 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.8.9 -rwxr-xr-- 1 root root3169 Jul 30 14:37 3.8-branded-queues-extension -rwxrwxr-x 1 iqbala iqbala 3179 Jul 29 19:02 3.8-branded-queues-extension.in -rwxr-xr-- 1 root root3203 Jul 30 14:37 3.8-ical-extension -rw-rw-r-- 1 iqbala iqbala 3213 Jul 29 19:02 3.8-ical-extension.in drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.9.1 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.9.2 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.9.3 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.9.5 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.9.6 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.9.7 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 3.9.8 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.0rc2 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.0rc4 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.0rc7 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.1 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.12 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.13 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.3 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.4 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.6 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 4.0.9 ls -l etc/upgrade/4.0.0rc*/ would also be interesting. ~/src/rt-4.0.16$ ls -al etc/upgrade/4.0.0rc* etc/upgrade/4.0.0rc2: total 12 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 . drwxrwxr-x 43 iqbala iqbala 4096 Jul 30 17:31 .. -rw-rw-r-- 1 iqbala iqbala 193 Jul 29 19:02 schema.mysql etc/upgrade/4.0.0rc4: total 20 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 . drwxrwxr-x 43 iqbala iqbala 4096 Jul 30 17:31 .. -rw-rw-r-- 1 iqbala iqbala 48 Jul 29 19:02 schema.mysql -rw-rw-r-- 1 iqbala iqbala 49 Jul 29 19:02 schema.Oracle -rw-rw-r-- 1 iqbala iqbala 52 Jul 29 19:02 schema.Pg etc/upgrade/4.0.0rc7: total 12 drwxrwxr-x 2 iqbala iqbala 4096 Jul 29 19:02 . drwxrwxr-x 43 iqbala iqbala 4096 Jul 30 17:31 .. -rw-rw-r-- 1 iqbala iqbala 630 Jul 29 19:02 content ~/src/rt-4.0.16$ cat etc/upgrade/4.0.0rc2/schema.mysql DROP TABLE IF EXISTS sessions; CREATE TABLE sessions ( id char(32) NOT NULL, a_session LONGBLOB, LastUpdated TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB CHARACTER SET ascii; I am not sure why it is skipping then. Could it be because of the RTFM errors? I do not use them and not planning to either. -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
Re: [rt-users] Help with GNATT RT Extension: Doesn't show up!
Yes, it was there! Thank you.I'm still a little shocked that these RT extensions don't come with completed install directions or little helpful things like, "where to find the darn thing"! Oh well, nothing is perfect I supposed. They make the extensions, it's up to use to figure out how to use them I guess.Thanks againSent from iCloudOn Aug 02, 2013, at 10:50 AM, Darin Perusich da...@darins.net wrote:Under Links next to Graph when viewing a ticket. On Fri, Aug 2, 2013 at 10:38 AM, window camera front...@me.com wrote:May I ask where the GNATT extension is supposed to show up in the GUI? -- Later, Darin
Re: [rt-users] Migration Prep
On 08/02/2013 10:04 AM, Kevin Falcone wrote: On Fri, Aug 02, 2013 at 12:49:47PM -0400, Asif Iqbal wrote: Please show a log of your make upgrade-database step * 3.9.8 * 4.0.1 That's definitely skipping steps. It should read: * 3.9.8 * 4.0.0rc2 * 4.0.0rc4 * 4.0.0rc7 * 4.0.1 Paul and Asif, you've helped uncover a regression in RT's upgrade logic beginning in 4.0.14. It only affects folks who are upgrading from an RT 3.8.x (or older) install to 4.0.14 or higher. If you're upgrading from 4.0.0 or higher, you're unaffected. 4.0.17 will be out shortly to correct this regression. Thanks for your time spent debugging on the list.
Re: [rt-users] Help with GNATT RT Extension: Doesn't show up!
On Fri, Aug 02, 2013 at 05:22:38PM +, window camera wrote: I'm still a little shocked that these RT extensions don't come with completed install directions or little helpful things like, where to find the darn thing! Oh well, nothing is perfect I supposed. They make the extensions, it's up to use to figure out how to use them I guess. Patches welcome. This page includes an email address where you can send your suggested update. https://rt.cpan.org/Public/Bug/Report.html?Queue=RT-Extension-JSGantt -kevin pgpdhVB0HReaL.pgp Description: PGP signature
Re: [rt-users] Help with SummaryByUsers extension
Kevin, Your help is much appreciated.I've done exactly what you've stated. I've also successfully installed over 10 other extensions. For some reason, this extension just doesn't want to work on my RT 4.13 version. I still get the error :Aug 2 13:48:18 rttrack RT: could not find component for path 'SummaryByUser'#012#012Stack:#012 [/rtdata/share/html/Elements/MyRT:95]#012 [/rtdata/share/html/index.html:78]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:635]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:335]#012 [/rtdata/share/html/autohandler:53] (/rtdata/sbin/../lib/RT/Interface/Web/Handler.pm:208) At this point, i'd like to uninstall it and get rid of all the error messages (on the GUI and within the logs). Are there removal instructions anywhere?Thank you again!-RickSent from iCloudOn Aug 02, 2013, at 01:15 PM, Kevin Falcone falc...@bestpractical.com wrote:On Fri, Aug 02, 2013 at 05:03:32PM +, window camera wrote:This is wrong. Always make your changes in RT_SiteConfig.pm, never inRT_Config.pm or they'll be lost when you upgrade.Yes, I know it's wrong to do it there. Had no choice though.There was absolutely no information or documenation on how tosetup "HomepageCompoents" in RT_SiteConfig.pm. I searched far andwide for it. Um. Copy it from RT_Config.pm to RT_SiteConfig.pm and modify it there.o The documentation I copied that you deleted said what to do. # WARNING # # # # NEVER EDIT RT_Config.pm ! # # # # Instead, copy any sections you want to change to # # RT_SiteConfig.pm and edit them there. Otherwise, # # your changes will be lost when you upgrade RT. # # # # WARNING # Do you happen to know how?I'll tell you how I did it though (in RT_SiteConfig.pm):SET ( HomepageComponents, qw('SummaryByUser')); Nope, SET is invalid, it's Set (copy, don't retype). Exactly the line you had in RT_Config.pm goes in RT_SiteConfig.pm. Then you add OwnerSummary to that HomepageComponents line. (The names OwnerSummary and RequestorSummary are documented in the DESCRIPTION section of the README shipped with the extension). and I also added the SummaryByUser in the @plugins. @Plugins, not @plugins. You still haven't shown your plugins configuration. Howerver, got the same exact error. No dice. Just error'ed out again.I'm just a little baffled why these extensions don't come with aREADME that gives directions on how to set it up. Anyway I digress. Most extensions do, this one is underdocumented. Go delete SummaryByUser from your RT at a Glance page, fix HomepageComponents to contain valid components and then add them to the page.Yes, thanks. I did do that. Same error. See above configuration I did in RT_SiteConfig.pm.Now when I add "OwnerSummary" as you said, I get error "Error while loading can't locate RT/Extensions/OwnerSummary.pm. No, don't add that to plugins, you add that to HomepageComponents. Any other things you think I should check? Or perhaps now we're at the point where this extension is perhaps not compatible with RT 4.13? This extension is compatible with 4.0.13. I'm the developer who contributed a patch to make it compatible with RT4. Since you don't seem to be following my explanations, I'll copy and paste the correct configuration here, but then you're on your own. Set( $HomepageComponents, [ qw(QuickCreate Quicksearch MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards SavedSearches OwnerSummary) # loc_qw ] ); Set( @Plugins, qw(RT::Extension::SummaryByUser)); If you use more than one plugin, this @Plugins line is incorrect and will disable other plugins. You must specify them all in a single @Plugins line. -kevin
Re: [rt-users] Help with SummaryByUsers extension
On Fri, Aug 02, 2013 at 05:53:51PM +, window camera wrote: I still get the error : Aug 2 13:48:18 rttrack RT: could not find component for path 'SummaryByUser'#012#012Stack:#012 [/rtdata/share/html/Elements/MyRT:95]#012 [/rtdata/share/html/index.html:78]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:635]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:335]#012 [/rtdata/share/html/autohandler:53] (/rtdata/sbin/../lib/RT/Interface/Web/Handler.pm:208) At this point, i'd like to uninstall it and get rid of all the error messages (on the GUI and within the logs). You've not followed my instructions if you have that error. At this point, go click the Reset to Default on that page. Are there removal instructions anywhere? Delete the plugin. Remove it from your configuration. -kevin pgps0yPf5Dlr2.pgp Description: PGP signature
Re: [rt-users] Differentiating while sending notifictions
On Fri, Aug 02, 2013 at 09:29:24AM +0200, Robert Wysocki wrote: Few months ago I've implemented something similar - a role for traffic manager. It consists of a per-queue custom field, some local modifications in Action.pm and custom ScripActions in DB. I'll probably gonna try to customize it so that we can have the kind of ScripActions you've mentioned. You could probably do that with subclassing rather than direct modifications, but it sounds like you need some pretty significant changes. In my opinion it would be great to have a easy-to-use mechanism for creation of custom roles like 'Requestor' od 'AdminCc'. It sure would, but it's a rather complicated piece of the system and it's very easy to add huge performance bottlenecks. The development version of RT includes significant refactoring to make it easier to add new roles. -kevin pgpSNtO2gteKz.pgp Description: PGP signature
Re: [rt-users] (RT::Authen::ExternalAuth) email exists problem authenticating trough AD
It binds because i receive all aditional fields and even creates the user with those . Yes, it binds, but anonymously. All the information fields are first retrieved that way. Only then does the authentication phase start, when it attempts to bind as the user with the password that the user enters in the login window. The problem is really focused on authentication step and i can't understand why :( Yes, so the question is (once again): can you bind *as the user* and *with the user's password* from the command line?
Re: [rt-users] Help with SummaryByUsers extension
You've not followed my instructions if you have that error.I wouldn't assume that. But thank you for taking the time to help.Best-RickSent from iCloudOn Aug 02, 2013, at 02:03 PM, Kevin Falcone falc...@bestpractical.com wrote:On Fri, Aug 02, 2013 at 05:53:51PM +, window camera wrote:I still get the error :Aug 2 13:48:18 rttrack RT: could not find component for path 'SummaryByUser'#012#012Stack:#012 [/rtdata/share/html/Elements/MyRT:95]#012 [/rtdata/share/html/index.html:78]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:635]#012 [/rtdata/sbin/../lib/RT/Interface/Web.pm:335]#012 [/rtdata/share/html/autohandler:53] (/rtdata/sbin/../lib/RT/Interface/Web/Handler.pm:208)At this point, i'd like to uninstall it and get rid of all the error messages (on the GUI and within the logs). You've not followed my instructions if you have that error. At this point, go click the Reset to Default on that page. Are there removal instructions anywhere? Delete the plugin. Remove it from your configuration. -kevin
[rt-users] [rt-announce] RT 4.0.17 released
This release fixes an important regression in the upgrade script included in 4.0.14, 4.0.15, and 4.0.16. Attempting to upgrade from 3.x would skip key upgrade steps. New installs, and sites upgrading from within the 4.0.x series, are unaffected. Affected installations (i.e., who upgraded from 3.x to 4.0.14, 4.0.15, or 4.0.16) should install RT 4.0.17, and then run 'make upgrade-database', specifying versions 3.9.9 through 4.0.0 as the versions to upgrade from and to. This should produce: Going to apply following upgrades: * 4.0.0rc2 * 4.0.0rc4 * 4.0.0rc7 Due to the missed upgrade steps, passwords would work until after the user first logged in, or until etc/upgrade/vulnerable-passwords was run. Affected users may be found by running the following SQL query: SELECT Name FROM Users WHERE Password LIKE '!sha512!%' AND LENGTH(Password) = 40; After completing the upgrade steps mentioned above, passwords for affected users should be restored from backups, the admin UI (assuming an administrator can log in), or (as a last resort) setting them explicitly via: perl -I/opt/rt4/local/lib -I/opt/rt4/lib -MRT=-init \ -e 'my $u = RT::User-new( RT-SystemUser );' \ -e '($u-Load(username))[0] or die Failed to load user;' \ -e '$u-SetPassword(new_password);' Adjust the username and password on the last two lines accordingly. You may need to adjust /opt/rt4/local/lib and /opt/rt4/lib on the first line if your RT is not installed into the default location of /opt/rt4 http://download.bestpractical.com/pub/rt/release/rt-4.0.17.tar.gz http://download.bestpractical.com/pub/rt/release/rt-4.0.17.tar.gz.sig SHA1 sums b348fa687001db08198bc2b014a348083108e801 rt-4.0.17.tar.gz edc3848822315a14bc4a272d4d0fae60fe5ced8d rt-4.0.17.tar.gz.sig A complete changelog is available from git by running: git log rt-4.0.16..rt-4.0.17 or visiting https://github.com/bestpractical/rt/compare/rt-4.0.16...rt-4.0.17 ___ rt-announce mailing list rt-annou...@lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce
[rt-users] Multiple $rtname ?
I am trying to configure the automated email from RT to display the queue name as part of the ticket id. For example assume the queues are HR, Contracts, and Accounting. I want the following email alerts [Contracts # $TicketID] $OriginalSubject [HR # $TicketID] $OriginalSubject [Accounting # $TicketID] $OriginalSubject Is it possible to set multiple $rtname, values in the RT_SiteConfig.pm? If not how can I configure the email as I want them using one RT 4 instance with multiple queues? Thank you, Brian
Re: [rt-users] Multiple $rtname ?
On Fri, Aug 02, 2013 at 08:06:30PM +, Brian Haupt wrote: I am trying to configure the automated email from RT to display the queue name as part of the ticket id. For example assume the queues are HR, Contracts, and Accounting. I want the following email alerts [Contracts # $TicketID] $OriginalSubject [HR # $TicketID] $OriginalSubject [Accounting # $TicketID] $OriginalSubject Is it possible to set multiple $rtname, values in the RT_SiteConfig.pm? If not how can I configure the email as I want them using one RT 4 instance with multiple queues? Use Subject Tag on the Queue Admin page. It'll change it for you and keep track and parse all of it. You get one per Queue, hopefully that's sufficient. If you need more, you can do it, but it's more work. -kevin pgpS0EFxFdF68.pgp Description: PGP signature
Re: [rt-users] Multiple $rtname ?
Kevin, That did the trick; thank you. Brian -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Friday, August 02, 2013 4:11 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Multiple $rtname ? On Fri, Aug 02, 2013 at 08:06:30PM +, Brian Haupt wrote: I am trying to configure the automated email from RT to display the queue name as part of the ticket id. For example assume the queues are HR, Contracts, and Accounting. I want the following email alerts [Contracts # $TicketID] $OriginalSubject [HR # $TicketID] $OriginalSubject [Accounting # $TicketID] $OriginalSubject Is it possible to set multiple $rtname, values in the RT_SiteConfig.pm? If not how can I configure the email as I want them using one RT 4 instance with multiple queues? Use Subject Tag on the Queue Admin page. It'll change it for you and keep track and parse all of it. You get one per Queue, hopefully that's sufficient. If you need more, you can do it, but it's more work. -kevin
[rt-users] Bad name after cn' when using LDAPImport
I'm using Request Tracker 4.0.7 with LDAPImport 0.34 and Authen::ExternalAuth 10-4. I already have user creation and attribute mapping configured with ExternalAuth. I'm primarily interested in using LDAPImport to populate a half dozen or so Public Groups in Request Tracker with users from Active Directory. The idea is that separate divisions can just add their staff to that Active Directory group and when LDAPImport runs they'll be granted the appropriate rights to manage their division's queue in Request Tracker. I'm pulling from an Active Directory LDAP implementation at a functional level of Windows Server 2008. When I do a test run (/usr/local/share/request-tracker4/plugins/RT-Extension-LDAPImport/bin/rtldapimport --debug ldapimport.debug 21) I get the following: Couldn't load RT config file RT_SiteConfig.pm: Bad name after cn' at /etc/request-tracker4/RT_SiteConfig.pm line 91. Compilation failed in require at /usr/share/request-tracker4/lib/RT/Config.pm line 905. BEGIN failed--compilation aborted at ./rtldapimport line 26. That corresponds with this line of my RT_SiteConfig.pm: Set($LDAPGroupMapping, { Name = 'cn', I've configured LDAPImport as follows: ## LDAP Import ## Set($LDAPHost, 'ldaps://dc.alaska.gov'); Set($LDAPUser, 'CN=dor-requesttracker,OU=Security Groups and Accounts,OU=IT,OU=Divisions,OU=DOR,OU=State Departments,DC=alaska,DC=gov'); Set($LDAPPassword ,'Password); Set($LDAPBase, 'ou=DOR,ou=State Departments,dc=alaska,dc=gov'); Set($LDAPGroupBase, 'OU=Security Groups and Accounts,OU=IT,OU=Divisions,OU=DOR,OU=State Departments,DC=alaska,DC=gov'); Set($LDAPGroupFilter, '(|(CN=dor-rt-admins)(CN=dor-rt-staff)); Set($LDAPGroupMapping, { Name = 'cn', Member_Attr = 'member', Member_Attr_Value = 'sAMAccountName', Description = 'description'}); Set($LDAPSizeLimit, 1000); I feel like I'm missing something real simple here. Can someone lend another set of eyes to this problem? Thanks! --- Kevin Elliott Networking Specialist II Alaska Department of Revenue, ASD-IT (907) 465-2314