Re: [rt-users] RT:Extension:ResetPassweord errors out
On Tue, Feb 07, 2012 at 11:13:26PM +, Axay Desai wrote: > I have version 4.0.4. installed. I am trying to put > 'Reset Password' link on > the main page by installing plugin > RT-Extension-ResetPassword-0.04. > It gives following message during install: > perl Makefile.PL make install These are actually meant to be two commands perl Makefile.PL make install Try running make install and you should be good. I've released a 0.05 that corrects the documentation error. Thanks -kevin > Cannot determine perl version info from > lib/RT/Extension/ResetPassword.pm > Cannot determine author info from > lib/RT/Extension/ResetPassword.pm > Cannot determine license info from > lib/RT/Extension/ResetPassword.pm > Using RT configuration from /opt/rt4/lib/RT.pm: > ./html => /opt/rt4/local/plugins/RT-Extension-ResetPassword/html > ./lib => /opt/rt4/local/plugins/RT-Extension-ResetPassword/lib > Cannot determine perl version info from lib/RT/Extension/ResetPassword.pm > Cannot determine license info from lib/RT/Extension/ResetPassword.pm > Writing Makefile for RT::Extension::ResetPassword > Writing MYMETA.yml and MYMETA.json > > I have updated RT_SiteConfig.pm with plugin information. > When I try to restart > Apache, i get following error: > > [Tue Feb 7 23:03:36 2012] [warning]: > (in cleanup) Error while loading > /opt/rt4/sbin/rt-server: Can't locate > RT/Extension/ResetPassword.pm in @INC (@INC contains: /opt/rt4/sbin/.. > /local/lib > /opt/rt4/sbin/../lib /usr/local/lib/perl5 > /usr/local/share/perl5 > /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_perl > /usr/lib/perl5 /u > sr/share/perl5 . /etc/httpd) at /opt/rt4/sbin/../lib/RT.pm > line 659. > (/opt/rt4/sbin/../lib/RT.pm:343) > > Any help in this matter is appreciated. Thanks - Axay pgpSChpqUZg3I.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] RT:Extension:ResetPassweord errors out
I have version 4.0.4. installed. I am trying to put 'Reset Password' link on the main page by installing plugin RT-Extension-ResetPassword-0.04. It gives following message during install: perl Makefile.PL make install Cannot determine perl version info from lib/RT/Extension/ResetPassword.pm Cannot determine author info from lib/RT/Extension/ResetPassword.pm Cannot determine license info from lib/RT/Extension/ResetPassword.pm Using RT configuration from /opt/rt4/lib/RT.pm: ./html => /opt/rt4/local/plugins/RT-Extension-ResetPassword/html ./lib => /opt/rt4/local/plugins/RT-Extension-ResetPassword/lib Cannot determine perl version info from lib/RT/Extension/ResetPassword.pm Cannot determine license info from lib/RT/Extension/ResetPassword.pm Writing Makefile for RT::Extension::ResetPassword Writing MYMETA.yml and MYMETA.json I have updated RT_SiteConfig.pm with plugin information. When I try to restart Apache, i get following error: [Tue Feb 7 23:03:36 2012] [warning]: (in cleanup) Error while loading /opt/rt4/sbin/rt-server: Can't locate RT/Extension/ResetPassword.pm in @INC (@INC contains: /opt/rt4/sbin/.. /local/lib /opt/rt4/sbin/../lib /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib/perl5 /u sr/share/perl5 . /etc/httpd) at /opt/rt4/sbin/../lib/RT.pm line 659. (/opt/rt4/sbin/../lib/RT.pm:343) Any help in this matter is appreciated. Thanks - Axay RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] rt-crontool question
> > > /opt/rt4/bin/rt-crontool --search RT::Search::FromSQL --search-arg "Status > > > = 'open'" --condition RT::Condition::UntouchedInHours --condition-arg > > > '1'--action RT::Action::NotifyGroup --action-arg '$owner' --template > > > > Is there a space between '1' and --action? If not, the command isn't > > seeing the action argument. > > > > I'll also note that I'm not sure what $owner is in your usage above. > I am trying to get it to notify whoever the owner of the ticket is and > that is from what I can see is the variable for the tickets owner That isn't how that action works. It sounds like you want Notify and to pass the argument Owner, not $owner. -kevin pgpSzglGLePaa.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] LDAPImport
On Tue, Feb 07, 2012 at 09:45:49PM +, Howell, Van wrote: >I have installed and configured RT::Extension::LDAPImport and have run a > successful test > >I have several distribution groups setup in AD and I would like to import > users and place them >in the same groups in RT. > >Like I have AD groups Faculty, Staff, Students, etc > >I want to import these users into a Faculty, Staff, Students group in RT. > >In my test I used a filter > > (&(memberOf=CN=Technology,CN=Departments_Groups,CN=Users,DC=x,DC=xxx,DC=edu)) > >And I setup a LDAPGroupName, `Technology' > >Is there a way to do this for multiple different groups in the same config? LDAPGroupName is just a default group to track people who were imported. If you want to import groups from AD, you want the part of the documentation that covers LDAPGroupBase and friends. -kevin pgpF86xZYgMUH.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] rt-crontool question
I am trying to get it to notify whoever the owner of the ticket is and that is from what I can see is the variable for the tickets owner mark RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] LDAPImport
I have installed and configured RT::Extension::LDAPImport and have run a successful test I have several distribution groups setup in AD and I would like to import users and place them in the same groups in RT. Like I have AD groups Faculty, Staff, Students, etc I want to import these users into a Faculty, Staff, Students group in RT. In my test I used a filter (&(memberOf=CN=Technology,CN=Departments_Groups,CN=Users,DC=x,DC=xxx,DC=edu)) And I setup a LDAPGroupName, 'Technology' Is there a way to do this for multiple different groups in the same config? Van Howell System Administrator Lubbock Christian University RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Upgraded from 3.8.7 to 4.0.5
I reran this script and noticed that it complained about access to the remote MySQL database. Looked into MySQL, and root isn't accessible from remote users. Updated root's access from remote machines and reran the script. Restarted Apache and it is now working Changed root's access back to local only. Thanks Kevin Gerrard -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Tuesday, February 07, 2012 3:44 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Upgraded from 3.8.7 to 4.0.5 On Tue, Feb 07, 2012 at 03:25:39PM -0500, Gerrard Leach wrote: > [Tue Feb 7 20:22:49 2012] [warning]: DBD::mysql::st execute failed: > Unknown column 'RenderType' in 'field list' at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. > (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) This implies you didn't run the database upgrades referred to in README and docs/UPGRADING* If you look back through your notes and logs, what happened when you ran make upgrade-database? If you missed that step, you may wish to review the rest of the documentation to ensure that the other upgrade steps were completed. -kevin > [Tue Feb 7 20:22:49 2012] [warning]: RT::Handle=HASH(0x7fba542db0e0) > couldn't execute the query 'INSERT INTO CustomFields (RenderType, Pattern, > Creator, LastUpdatedBy, LookupType, Type, MaxValues, Repeated, Disabled, > ValuesClass, BasedOn, Created, Description, Name, LastUpdated) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 > > DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fba542db0e0)', > 'INSERT INTO CustomFields (RenderType, Pattern, Creator, LastU...', undef, > '', 9655, 9655, 'RT::Queue-RT::Ticket', 'Freeform', 1, ...) called at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 350 > > DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x7fba542db0e0)', > 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, > 'LastUpdatedBy', ...) called at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle/mysql.pm line 36 > > DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x7fba542db0e0)', > 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, > 'LastUpdatedBy', ...) called at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1292 > > DBIx::SearchBuilder::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', > 'RenderType', undef, 'Creator', 9655, 'Pattern', '', 'LastUpdatedBy', 9655, > ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 316 > RT::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'Name', > 'SLA', 'Type', 'Freeform', 'RenderType', undef, 'MaxValues', 1, ...) called > at /opt/rt4/sbin/../lib/RT/CustomField.pm line 377 > RT::CustomField::Create('RT::CustomField=HASH(0x7fba5518e6c0)', > 'Name', 'SLA', 'TypeComposite', 'Freeform-1', 'LookupType', > 'RT::Queue-RT::Ticket', 'Description', 'Is the SLA applicable to this > ticket', ...) called at /opt/rt4/share/html/Admin/CustomFields/Modify.html > line 167 > HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', > 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at > /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 > > HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d4a9a0)', > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', > '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line > 1302 > eval {...} called at > /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 > HTML::Mason::Request::comp(undef, undef, undef, > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) called at > /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 955 > > HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7fba55219fc8)', > 'Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', > 'Freeform-1', ...) called at /opt/rt4/share/html/Admin/autohandler line 49 > HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', > 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at > /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 > > HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d33b18)', > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', > '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line > 1302 > eval {...} called at > /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 > HTML::Mason::Request::comp(undef, undef, undef, > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) c
Re: [rt-users] Upgraded from 3.8.7 to 4.0.5
On Tue, Feb 07, 2012 at 03:25:39PM -0500, Gerrard Leach wrote: > [Tue Feb 7 20:22:49 2012] [warning]: DBD::mysql::st execute failed: Unknown > column 'RenderType' in 'field list' at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. > (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) This implies you didn't run the database upgrades referred to in README and docs/UPGRADING* If you look back through your notes and logs, what happened when you ran make upgrade-database? If you missed that step, you may wish to review the rest of the documentation to ensure that the other upgrade steps were completed. -kevin > [Tue Feb 7 20:22:49 2012] [warning]: RT::Handle=HASH(0x7fba542db0e0) > couldn't execute the query 'INSERT INTO CustomFields (RenderType, Pattern, > Creator, LastUpdatedBy, LookupType, Type, MaxValues, Repeated, Disabled, > ValuesClass, BasedOn, Created, Description, Name, LastUpdated) VALUES (?, ?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 > > DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fba542db0e0)', > 'INSERT INTO CustomFields (RenderType, Pattern, Creator, LastU...', undef, > '', 9655, 9655, 'RT::Queue-RT::Ticket', 'Freeform', 1, ...) called at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 350 > > DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x7fba542db0e0)', > 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, > 'LastUpdatedBy', ...) called at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle/mysql.pm line 36 > > DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x7fba542db0e0)', > 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, > 'LastUpdatedBy', ...) called at > /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1292 > > DBIx::SearchBuilder::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', > 'RenderType', undef, 'Creator', 9655, 'Pattern', '', 'LastUpdatedBy', 9655, > ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 316 > RT::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'Name', > 'SLA', 'Type', 'Freeform', 'RenderType', undef, 'MaxValues', 1, ...) called > at /opt/rt4/sbin/../lib/RT/CustomField.pm line 377 > RT::CustomField::Create('RT::CustomField=HASH(0x7fba5518e6c0)', > 'Name', 'SLA', 'TypeComposite', 'Freeform-1', 'LookupType', > 'RT::Queue-RT::Ticket', 'Description', 'Is the SLA applicable to this > ticket', ...) called at /opt/rt4/share/html/Admin/CustomFields/Modify.html > line 167 > HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', > 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at > /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 > > HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d4a9a0)', > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', > '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line > 1302 > eval {...} called at > /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 > HTML::Mason::Request::comp(undef, undef, undef, > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) called at > /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 955 > > HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7fba55219fc8)', > 'Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', > 'Freeform-1', ...) called at /opt/rt4/share/html/Admin/autohandler line 49 > HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', > 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at > /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 > > HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d33b18)', > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', > '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line > 1302 > eval {...} called at > /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 > HTML::Mason::Request::comp(undef, undef, undef, > 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) called at > /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548 > RT::Interface::Web::ShowRequestedPage('HASH(0x7fba5523be48)') called > at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295 > RT::Interface::Web::HandleRequest('HASH(0x7fba5523be48)') called at > /opt/rt4/share/html/autohandler line 53 > HTML::Mason::Commands::__ANON__('Pattern', '', 'Update', 'Create', > 'id', 'new', 'TypeComposite', 'Freeform-1', 'IncludeContentForValue', ...) > called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 > > HTML::Mason::Component::run('HTML::Mason::Component::Fi
Re: [rt-users] Upgraded from 3.8.7 to 4.0.5
[Tue Feb 7 20:22:49 2012] [warning]: DBD::mysql::st execute failed: Unknown column 'RenderType' in 'field list' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm:587) [Tue Feb 7 20:22:49 2012] [warning]: RT::Handle=HASH(0x7fba542db0e0) couldn't execute the query 'INSERT INTO CustomFields (RenderType, Pattern, Creator, LastUpdatedBy, LookupType, Type, MaxValues, Repeated, Disabled, ValuesClass, BasedOn, Created, Description, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 600 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fba542db0e0)', 'INSERT INTO CustomFields (RenderType, Pattern, Creator, LastU...', undef, '', 9655, 9655, 'RT::Queue-RT::Ticket', 'Freeform', 1, ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle.pm line 350 DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x7fba542db0e0)', 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, 'LastUpdatedBy', ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Handle/mysql.pm line 36 DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0x7fba542db0e0)', 'CustomFields', 'RenderType', undef, 'Pattern', '', 'Creator', 9655, 'LastUpdatedBy', ...) called at /usr/local/share/perl/5.10.1/DBIx/SearchBuilder/Record.pm line 1292 DBIx::SearchBuilder::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'RenderType', undef, 'Creator', 9655, 'Pattern', '', 'LastUpdatedBy', 9655, ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 316 RT::Record::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'Name', 'SLA', 'Type', 'Freeform', 'RenderType', undef, 'MaxValues', 1, ...) called at /opt/rt4/sbin/../lib/RT/CustomField.pm line 377 RT::CustomField::Create('RT::CustomField=HASH(0x7fba5518e6c0)', 'Name', 'SLA', 'TypeComposite', 'Freeform-1', 'LookupType', 'RT::Queue-RT::Ticket', 'Description', 'Is the SLA applicable to this ticket', ...) called at /opt/rt4/share/html/Admin/CustomFields/Modify.html line 167 HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d4a9a0)', 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 955 HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7fba55219fc8)', 'Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', 'Freeform-1', ...) called at /opt/rt4/share/html/Admin/autohandler line 49 HTML::Mason::Commands::__ANON__('IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', 'Pattern', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54d33b18)', 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, 'LinkValueTo', '', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1302 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'IncludeContentForValue', '', 'SetEnabled', 1, 'Enabled', 1, ...) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548 RT::Interface::Web::ShowRequestedPage('HASH(0x7fba5523be48)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295 RT::Interface::Web::HandleRequest('HASH(0x7fba5523be48)') called at /opt/rt4/share/html/autohandler line 53 HTML::Mason::Commands::__ANON__('Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', 'Freeform-1', 'IncludeContentForValue', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fba54321118)', 'Pattern', '', 'Update', 'Create', 'id', 'new', 'TypeComposite', 'Freeform-1', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1297 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'Pattern', '', 'Update', 'Create', 'id', 'new', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481 eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 481
Re: [rt-users] rt-crontool question
On Tue, Feb 07, 2012 at 02:43:50PM -0500, Mark Fuller wrote: > Ok I changed everything and still get errors > > /opt/rt4/bin/rt-crontool --search RT::Search::FromSQL --search-arg "Status > = 'open'" --condition RT::Condition::UntouchedInHours --condition-arg > '1'--action RT::Action::NotifyGroup --action-arg '$owner' --template Is there a space between '1' and --action? If not, the command isn't seeing the action argument. I'll also note that I'm not sure what $owner is in your usage above. -kevin > '21' --transaction 'last' transaction-type 'Correspond' --verbose > > /var/log/open3daynotifyowner.out > > > Any ideas the output is the rtcrontool help menu pgpNr05Hyf22S.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Upgraded from 3.8.7 to 4.0.5
On Tue, Feb 07, 2012 at 02:59:45PM -0500, Gerrard Leach wrote: >I am trying to get a simple checkbox setup as a custom field when a ticket > is created. > >I have selected a type of Select One Value, > >But when I choose a Render Type of list and save, I get an error > "RenderType could not be set >to List." What shows up in your apache error logs? -kevin pgpnQJB06Ggq6.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Upgraded from 3.8.7 to 4.0.5
Hello, I am trying to get a simple checkbox setup as a custom field when a ticket is created. I have selected a type of Select One Value, But when I choose a Render Type of list and save, I get an error "RenderType could not be set to List." Has anyone else seen this? Or know how to resolve it? Thanks Gerrard RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] rt-crontool question
Ok I changed everything and still get errors /opt/rt4/bin/rt-crontool --search RT::Search::FromSQL --search-arg "Status = 'open'" --condition RT::Condition::UntouchedInHours --condition-arg '1'--action RT::Action::NotifyGroup --action-arg '$owner' --template '21' --transaction 'last' transaction-type 'Correspond' --verbose > /var/log/open3daynotifyowner.out Any ideas the output is the rtcrontool help menu Mark RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Unassigning tickets does not work
Thomas, Le 07/02/2012 17:47, Thomas Sibley a écrit : Unless you're seeing problems in the logs, I think you're fine. Nobody displays as the Owner in the Basics section of the ticket display page, right? Nope, still me. I give the ticket to some coworker : select * from tickets where id=27155; id | effectiveid | queue | type | issuestatement | resolution | owner | subject | initialpriority | finalpriority | priority | timeestimated | timeworked | status | timeleft | told | starts| started | due | resolved | lastupdatedby | lastupdated | creator | created | disabled ---+-+---++++---+--+-+---+--+---+++--+--+-+-+-+-+---+-+-+-+-- 27155 | 27155 |33 | ticket | 0 | 0 | 104 | [0450757d] **Temps de réponse anormal - rca0450757dcpe01 | 0 | 0 |0 | 0 | 0 | open |0 | | 1970-01-01 00:00:00 | 2012-02-07 13:23:52 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 |22 | 2012-02-07 19:13:07 | 19061 | 2012-02-07 13:14:20 |0 I steal the ticket : select * from tickets where id=27155; id | effectiveid | queue | type | issuestatement | resolution | owner | subject | initialpriority | finalpriority | priority | timeestimated | timeworked | status | timeleft | told | starts| started | due | resolved | lastupdatedby | lastupdated | creator | created | disabled ---+-+---++++---+--+-+---+--+---+++--+--+-+-+-+-+---+-+-+-+-- 27155 | 27155 |33 | ticket | 0 | 0 |22 | [0450757d] **Temps de réponse anormal - rca0450757dcpe01 | 0 | 0 |0 | 0 | 0 | open |0 | | 1970-01-01 00:00:00 | 2012-02-07 13:23:52 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 |22 | 2012-02-07 19:08:19 | 19061 | 2012-02-07 13:14:20 |0 I change it to "Nobody in particular" : select * from tickets where id=27155; id | effectiveid | queue | type | issuestatement | resolution | owner | subject | initialpriority | finalpriority | priority | timeestimated | timeworked | status | timeleft | told | starts| started | due | resolved | lastupdatedby | lastupdated | creator | created | disabled ---+-+---++++---+--+-+---+--+---+++--+--+-+-+-+-+---+-+-+-+-- 27155 | 27155 |33 | ticket | 0 | 0 |22 | [0450757d] **Temps de réponse anormal - rca0450757dcpe01 | 0 | 0 |0 | 0 | 0 | open |0 | | 1970-01-01 00:00:00 | 2012-02-07 13:23:52 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 |22 | 2012-02-07 19:09:34 | 19061 | 2012-02-07 13:14:20 |0 The yellow "Results" box says : Intervenant changé de cat à Nobody The history says : JC BOGGIO - Non pris Unfortunately, on the box underneath "modify users for ticket 27155", I see myself. Same thing on "Ticket metadata" page. And as you see on the query, owner is not 6. select id,name from users where id in (1,6,22); id | name +--- 1 | RT_System 6 | Nobody 22 | cat Nothing in /var/log/apache2/error.log RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] FW: CustomField input must match formatting in edit
> > On Mon, Feb 06, 2012 at 04:54:51PM -0700, Brent Wiese wrote: > > Sorry, wasn't sure if a screenshot would come through on the list. > > The layout of that field could use some loving, it has a CSS class > these days so it should be much easier to do things to it: > cfinvalidfield Yeah, I played a little with that CSS, but since it was inconsistent between different types of fields, and IIRC (yesterday is a blur at this point), that CSS is also used on the create ticket, I was hoping there was another solution or a bug in the modify html page that I was too blind to see that could be corrected. It was a long (and productive thanks to the awesome structure of RT) day of coding. > > Maybe a different topic, but while debugging the formatting above, I > > noticed if I use a * in a custom field validation (ie: I want to > allow > > the field to contain only digits or be empty, so I modified the regex > > from ^[\d.]+$ to ^[\d.]*$), the validation works, but it doesn’t > > display the “Input must match…” text at all. > > RT decides whether or not display the hint by validating all the CFs at > page render time. This means that since * matches the empty field, it > doesn't have an error hint to show. > > Frankly - it'd probably be a lot better if we just started showing the > Description of Custom Fields as a Hint box on 4.2. That makes sense, but it'd be nice if it rendered the comment in the validation regardless of whether it validated the regex. Or, as you suggest, show the CF description. Thanks again! Brent RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Unassigning tickets does not work
On 02/07/2012 09:44 AM, JC Boggio wrote: > Since we upgraded from RT 3.8 to 4.0.4, we can't assign tickets to > Nobody anymore. > To anybody else works. > > When I give to someuser history says : > "JC Boggio - Given to someuser" > > When I try to give to nobody, I get : > "JC Boggio - Not taken" > > (These are free translations from french) A coworker pointed out that the french translation is likely just incorrect or misleading. The english for your second transaction is "Untaken" (meaning you gave up the ticket; RT implements this by making a Nobody user the owner). Unless you're seeing problems in the logs, I think you're fine. Nobody displays as the Owner in the Basics section of the ticket display page, right? Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Unassigning tickets does not work
Thomas, Le 07/02/2012 16:22, Thomas Sibley a écrit : SELECT * FROM Users WHERE Name='Nobody'; rt3=> SELECT * FROM Users WHERE Name='Nobody'; -[ RECORD 1 ]-+--- id| 6 name | Nobody password | *NO-PASSWORD* comments | Do not delete or modify this user. It is integral to RT's internal data structures signature | emailaddress | freeformcontactinfo | organization | realname | Nobody in particular nickname | lang | emailencoding | webencoding | externalcontactinfoid | contactinfosystem | externalauthid| authsystem| gecos | homephone | workphone | mobilephone | pagerphone| address1 | address2 | city | state | zip | country | timezone | pgpkey| creator | 1 created | 2009-04-06 09:31:34 lastupdatedby | 1 lastupdated | 2009-04-06 09:31:34 authtoken | SELECT u.Name, a.id, a.RightName, a.ObjectType, a.ObjectId, a.Creator, a.Created FROM ACL a join CachedGroupMembers cgm on a.PrincipalId = cgm.GroupId join Principals p on p.id = cgm.MemberId join Users u on u.id = p.id WHERE a.PrincipalType = 'Group' and u.Name = 'Nobody'; name | id | rightname | objecttype | objectid | creator | created +--+--++--+-+- Nobody |2 | OwnTicket| RT::System |1 | 0 | Nobody |9 | AdminGroup | RT::Group | 24 | 0 | Nobody |8 | AdminGroupMembership | RT::Group | 24 | 0 | Nobody |6 | CreateGroupDashboard | RT::Group | 24 | 0 | Nobody | 13 | DeleteGroupDashboard | RT::Group | 24 | 0 | Nobody | 11 | EditSavedSearches| RT::Group | 24 | 0 | Nobody | 12 | ModifyGroupDashboard | RT::Group | 24 | 0 | Nobody | 10 | ModifyOwnMembership | RT::Group | 24 | 0 | Nobody | 14 | SeeGroup | RT::Group | 24 | 0 | Nobody | 1336 | SeeGroup | RT::Group | 3358 | 0 | Nobody | 1339 | SeeGroup | RT::Group | 3975 | 0 | Nobody | 1351 | SeeGroup | RT::Group | 4372 | 0 | Nobody | 2904 | SeeGroup | RT::Group |66841 | 0 | Nobody | 15 | SeeGroupDashboard| RT::Group | 24 | 0 | Nobody |5 | ShowSavedSearches| RT::Group | 24 | 0 | RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] [RT4] Create a new admin account
On Tue, Feb 07, 2012 at 04:54:20PM +0100, Ronan MOUCHOUX wrote: >I'm trying to create from the web interface a new admin account. >As I can't find a way (Tools>Configure>Users|Groups|Queues), I'm wondering > if it is even >possible? > >I'm sure I'm missing something, but I can't see what... You probably want to create an Admins group, grant it a bunch of rights (possibly SuperUser, but understand what that does) and then put your admin users in that group. -kevin pgpzjxTjz0W7p.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] CustomField input must match formatting in edit
On Mon, Feb 06, 2012 at 04:54:51PM -0700, Brent Wiese wrote: > Sorry, wasn't sure if a screenshot would come through on the list. The layout of that field could use some loving, it has a CSS class these days so it should be much easier to do things to it: cfinvalidfield > Maybe a different topic, but while debugging the formatting above, I > noticed if I use a * in a custom field validation (ie: I want to allow > the field to contain only digits or be empty, so I modified the regex > from ^[\d.]+$ to ^[\d.]*$), the validation works, but it doesn’t > display the “Input must match…” text at all. RT decides whether or not display the hint by validating all the CFs at page render time. This means that since * matches the empty field, it doesn't have an error hint to show. Frankly - it'd probably be a lot better if we just started showing the Description of Custom Fields as a Hint box on 4.2. -kevin pgp1Ulz4plJHL.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] [RT4] Create a new admin account
Hello, I'm trying to create from the web interface a new admin account. As I can't find a way (Tools>Configure>Users|Groups|Queues), I'm wondering if it is even possible? I'm sure I'm missing something, but I can't see what... Thanking you in advance, Best Regards Ronan RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Adding Custom Field to QuickCreate
I am trying to add an additional widget to the dashboard for a password reset ticket. We have a custom field called "Customers Name" and I was curious if anyone knew how to call it in the QuickCreate script? I copied over the script and have been modifying it, but I can't figure out what the syntax is for calling the custom field in the HTML. Thanks a lot for any help! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Abnormal number of groups
On 02/07/2012 10:17 AM, Haim Dimer wrote: > Hello, > > Check this out: > > mysql> SELECT COUNT(id) FROM Groups; > +---+ > | count(id) | > +---+ > | 4674 | > +---+ > > I don't think this is normal behavior since, as the administrator, I > have not created this many groups (at least not intentionally). I may > have an idea as to where they come from, look at this: The Groups table also contains many internal groups RT uses for access control. Don't worry about it. > We currently have about 1,100 tickets in the database. Every time a > ticket is created, a scrip runs using a template that contains the > following code: Your scrip isn't causing this. _Don't_ delete groups, however. > It seems that my $addGroupObj = RT::Group->new($RT::SystemUser) creates > a real group in the database. Can someone confirm? No, this just creates an RT::Group object. Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Unassigning tickets does not work
On 02/07/2012 09:44 AM, JC Boggio wrote: > Since we upgraded from RT 3.8 to 4.0.4, we can't assign tickets to > Nobody anymore. > To anybody else works. > > When I give to someuser history says : > "JC Boggio - Given to someuser" > > When I try to give to nobody, I get : > "JC Boggio - Not taken" > > (These are free translations from french) What do these queries return? SELECT * FROM Users WHERE Name='Nobody'; SELECT u.Name, a.id, a.RightName, a.ObjectType, a.ObjectId, a.Creator, a.Created FROM ACL a join CachedGroupMembers cgm on a.PrincipalId = cgm.GroupId join Principals p on p.id = cgm.MemberId join Users u on u.id = p.id WHERE a.PrincipalType = 'Group' and u.Name = 'Nobody'; RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Abnormal number of groups
Hello, Check this out: mysql> SELECT COUNT(id) FROM Groups; +---+ | count(id) | +---+ | 4674 | +---+ I don't think this is normal behavior since, as the administrator, I have not created this many groups (at least not intentionally). I may have an idea as to where they come from, look at this: mysql> SELECT COUNT(id) FROM Groups WHERE Domain = "RT::Ticket-Role"; +---+ | COUNT(id) | +---+ | 4496 | +---+ We currently have about 1,100 tickets in the database. Every time a ticket is created, a scrip runs using a template that contains the following code: --- CUT HERE my $GroupName = ''Computer Support; # instantiate a group object my $addGroupObj = RT::Group->new($RT::SystemUser); $addGroupObj->LoadUserDefinedGroup($GroupName); return undef unless $addGroupObj; my $addGroupMembersObj = $addGroupObj->UserMembersObj; my $res = ''; # walk through members of group to do stuff while ( my $userObj = $addGroupMembersObj->Next) { --- CUT HERE It seems that my $addGroupObj = RT::Group->new($RT::SystemUser) creates a real group in the database. Can someone confirm? I figuredit could be the case so after I'm done with that $addGroupObj, I tried to clean things up by using $addGroupObj->Delete(); Here is the error I got in the logs: [Sun Jan 1 22:50:54 2012] [crit]: Deleting groups violates referential integrity until we go through and fix this (/usr/local/rt4/sbin/../lib/RT/Group.pm:627) I do not believe it's healthy. I need to know if it's really my template that is causing the issue and if so, how can I gather the email addresses for each member of an existing group without creating a new one. I use RT 4.0.4. Thank you for your help. Haïm Dimermanas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Unassigning tickets does not work
Since we upgraded from RT 3.8 to 4.0.4, we can't assign tickets to Nobody anymore. To anybody else works. When I give to someuser history says : "JC Boggio - Given to someuser" When I try to give to nobody, I get : "JC Boggio - Not taken" (These are free translations from french) Any clues ? Thanks, JC RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] Importing Tickets and Comments
On 02/07/2012 12:35 AM, Tim Gustafson wrote: > And I get how to import the main ticket itself...but how can I import > ticket comments? The old system has 10 years worth of comments that > I'd like to also get into RT. Is there a way to do this without > hacking the database? Don't hack the database. Use RT's Perl API to make tickets and transactions (comments, replies, etc). You'll need to be handy with Perl, but the API is pretty well documented. Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] rt-4.0.5 - How to populate a custom field using a web service?
On 02/06/2012 04:42 PM, Kevin Falcone wrote: > This means that you can render content into an iframe using the value > of the custom field. > > If your user selected "Foo" from a custom field, RT can make a call to > an external webservice with Foo and some other information and then > iframe the data into Ticket/Display.html (assuming you don't violate > any of the security restrictions on iframes). Custom Fields which include content from a URL don't use an iframe; they make an ajax request and insert the resulting HTML into the page. Unlike the iframe approach, the ajax approach requires cross domain policies to be in place if you're fetching a url on another domain. To get around the cross-domain restriction, you can either write a shim residing on the same host as RT that proxies the request/response, or implement the cross-origin resource sharing headers (http://en.wikipedia.org/wiki/Cross-Origin_Resource_Sharing). Thomas RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
[rt-users] Fulltext Indexing RT 4.0.4
Hello all, I've setup full text indexing in RT4.0.4 as follows: - Vanilla install RT 4.0.4 on Ubuntu 10.04 LTS - MySQL 5.1.61 built from source with mysqlse added - Sphinx 2.0.3 added using the x86 package from the sphinxsearch.com site - run /opt/rt4/sbin/rt-setup-fulltext-index etc As the version of Sphinx had id64 enabled, I had to change the type of the id field in the AttachmentsIndex to bigint to make it 64 bit. Other than that, no issues (just a lot of time!!). RT works just fine. Here are my questions: - I can run manual searches (using search) and see hits that RT does not (0 tickets found), others work OK. - A lot of the data we need to search on is in entries that are of type html not plain text. How can we index those too? Any clues on how to proceed. If we can sort this, we want to index our own RT instance and then offer this as a feature to other potential customers. Thanks, Gary RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
Re: [rt-users] highlighting tickets with a reply
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Kevin, thanks, that's a great suggestion! Best regards, Giuseppe On 06/02/12 19:02, Kevin Falcone wrote: > On Mon, Feb 06, 2012 at 02:53:32PM +, Giuseppe Sollazzo wrote: >> >> a colleague here has asked me a question I'm not totally sure >> about. >> >> He asked: is there any way to highlight a ticket that has >> received a reply, in any way other than adding the "New" field? >> >> What he'd like is roughly a highlighting background to the ticket >> in the list. >> >> Has anyone done anything similar? > > You can use the UpdateStatus column. Changing the background > would require you to use a Callback with RT__Ticket's ColumnMap. > > I believe there are several examples of the ColumnMap Callback on > the wiki for highlighting a ticket with high priority that you > could work from. > > -kevin > > > RT Training Sessions > (http://bestpractical.com/services/training.html) * Boston ? March > 5 & 6, 2012 - -- Giuseppe Sollazzo Senior Systems Analyst Computing Services Information Services St. George's, University Of London Cranmer Terrace London SW17 0RE Email: gsoll...@sgul.ac.uk Direct Dial: +44 20 8725 5160 Fax: +44 20 8725 3583 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJPMPQrAAoJEAqigArPBfJXi1wH/20d4jW/TKhI59iJANhyoXao nja5u6ikSoI6E96+1wapb0q4zCrEiB5vuchnvzqwero+/TQ2E8HxLmftAc9cv6X5 BuaXuoZvA+ftVf7GV+a17fVxiyJSI8b8xuM2mfANrj/KZwSbGkQ1uLEbNm53Ei2d vFF/D5MoR0G20qNASHOTALlK53aanxYq9i3QtaQX2dHGNBAKKF3gqFdVgRYrn9qq EHcACZr6xbj+hPGtz50z9Q12BidGpR8Xi2p2G4UmybjMVfzENEmLMDXTPM75oBzE xueF81qsBySJkuRnrCXhi9WVeArQOdyIvIcop+BPhhk0fAsI1VFLmAsyyoc7t1g= =eUFU -END PGP SIGNATURE- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012