Re: [rt-users] Prepared statement already exists...
(I just realized that I originally sent my response to Ruslan only. My bad.)
On Wed, Feb 1, 2012 at 8:25 PM, Ruslan Zakirov r...@bestpractical.com wrote:
From what you have posted I suspect that problem is in DBI/DBD::Pg
modules. When you check version of the modules, double check with RT's
UI to make sure what you get in command line interface matches what RT
Admin/Tools/Configuration.html says:
| DB 1.26
| DBD::Pg 2.18.1
/usr/lib/perl5/site_perl/5.12.1/x86_64-linux-thread-multi/DBD/Pg.pm
| DBD::Sponge 12.010002
/usr/lib/perl5/vendor_perl/5.12.1/x86_64-linux-thread-multi/DBD/Sponge.pm
| DBI 1.609
/usr/lib/perl5/vendor_perl/5.12.1/x86_64-linux-thread-multi/DBI.pm
loads. Try downgrading DBD::Pg.
I'm a bit uneasy about messing around with Perl modules, so I'll try
the next one first:
As workaround you can try to disable server side preparing of statements:
http://search.cpan.org/~turnstep/DBD-Pg-2.18.1/Pg.pm#pg_server_prepare_(integer)
Is there a safe way to add that option within RT? I see that
lib/RT/Handle.pm has sub Connect which get's passed %args which
supposedly is prepared in sub BuildDSN in the same file? Is there a
conceptually better alternative to this:
(in sub BuildDSN, after %args has been set):
if ( $db_type eq 'Pg' ) {
$args{'pg_server_prepare' = 1;
}
-- Matthias
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 6, 2012
[rt-users] Add queue change to Update.html (comment/reply) CF Columns under Basic view
Hi, *Change queue during comment/reply (on Update.html)* I'm wondering of there's an easy way of adding Queue change to the comment/reply page (Update.html). It would be a nice addition to habe the ability to enable/disable this. We have several departments that communicate with each other, having the ability to change the queue when placing a comment/reply would help with the communication (easier then placing the comment and then changing the queue via Basics, or easier then using the Jumbo page. The reason I'm asking is because I want to stay away from editing these files (they break on updates ^_~), I'd like a more general solution which will persist during updates. (same goes for the next question) *CustomField Single column view under Basics* Also, I've found this plugin (thanks Rus!) RT::Extension::CustomFieldsOnUpdate ( http://search.cpan.org/dist/RT-Extension-CustomFieldsOnUpdate/lib/RT/Extension/CustomFieldsOnUpdate.pm) The plugin works great but the order in which the CustomFields are shown is kinda messy. The reason for the order being messy is because we've set the order based upon the two column view under Basics. (which goes from right to left and then from top to down) In the RT Config there's this option which should make it possible to show a single column view of the Custom Fields: =item C$EditCustomFieldsSingleColumn When displaying a list of Ticket Custom Fields for editing, RT defaults to a 2 column list. If you set this to 1, it will instead display the Custom Fields in a single column. =cut Set($EditCustomFieldsSingleColumn, 0); This option however doesn't seem to have any effect. Will this option get a fix during a future release? This would be great, if I can display the CustomFields in a single column on all pages then I can have a uniform CF order which will be the same on the Ticket overview, basics and comment/reply page. (or any other tip to achieve this would be appreciated) -- Bart RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Set Subject in if/then clause
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/02/12 19:19, Kevin Falcone wrote: Guiseppe - for reference, the syntax Gerard gave you came from the fact that RT's templates are Text::Templates and you can read more about them on CPAN: http://search.cpan.org/dist/Text-Template/lib/Text/Template.pm Hi Kevin - that's what I was missing! This is very useful for further developments. Many thanks! G -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/ iQEcBAEBAgAGBQJPKk6LAAoJEAqigArPBfJXnrUH/12aMtr+ZDAr7nz6vXES730K ESRKexikKHORLlcD9sSSTy54xgCsW64XKleHdK78bZnml93wKkVwF2UYo7w596d1 KuqcmgKgF6GUfPNXsn8nDQ6VfMgmoAPpBdk1JaB2fsBkf6ejT3SWftq1uzePcy+k f7Z8VZNW1w6CnkfE5G2rUCTJWr4KhEoWOKXG45GXhqp7MLmtwJTXJwiCICvOk73C U/hrE/ez7xuVePKRXsHP4+FfrMZPvVd2yOmkvXRj2eIz9rVMbuBkjrOSuXG4VLbQ hK8MJhGpJJGzusckaalIp3INpeWX/RA8ik4pnzCtU27njQedbDx/B6uwocQAP6M= =rtya -END PGP SIGNATURE- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Improvement suggestions
Hi all, I have a few problems that, if solved, I think may enhance the quality of RT. 1) RT displays a lot of notification messages through a pale yellow message box on top of the ticket page. Everything is displayed the same way regardless of nature (info, error, etc.). I think that it would be good to separate this messages at least into two categories: info (usual pale yellow box) and error (pale red box). Presently, since you cannot easily tell the difference, it happens quite often that one operator tries to take a ticket just half a second another operator took it, gets an error box, thinks it is the usual confirmation box, and starts working on the ticket. Sometimes he even does not realize he is doing duplicate work until he tries to resolve! 2) Beginning users of RT often fall into this error: click resolve on top of the ticket, write some message, then click resolve again instead of clicking on update ticket at the bottom. Why does resolve still show on top of the ticket when you're resolving? Is it possible to remove it? I think it doesn't belongs there. 3) Custom field of type check multiple values (check-box) could be ticked directly from the display page of a ticket instead of having to go into the modify page. It would help streamlining the work on tickets. Just a few thoughts. Thank you Cris p.s. We are using RT 3.8.10 and testing 4.02. Both have the mentioned problems. -- Cristiano Guadagnino Servizio Data Administration Bankadati S.I. Gruppo Credito Valtellinese Tel. +39-0342-522172 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] How to adjust 'Organization' in 'About me'
Hi, Quick question that hopefully is fairly easy to resolve - my users want to be able to adjust their 'Organization' within 'About me' in the Preferences menu. Providing 'ModifySelf' privileges to users allows adjustment of every other field on that screen, apart from Organization. What privilege do users need to alter this? I'm using RT 3.8.7 and 3.8.9. Thanks, Guy Please consider the environment before printing this email. This message should be regarded as confidential. If you have received this email in error please notify the sender and destroy it immediately. Statements of intent shall only become binding when confirmed in hard copy by an authorised signatory. The contents of this email may relate to dealings with other companies under the control of BAE Systems plc details of which can be found at http://www.baesystems.com/Businesses/index.htm. Detica Limited is a BAE Systems company trading as BAE Systems Detica. Detica Limited is registered in England and Wales under No: 1337451. Registered office: Surrey Research Park, Guildford, Surrey, GU2 7YP, England. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] CanonicalizeEmailAddressMatch
Need the proper syntax for 'CanonicalizeEmailAddressMatch' setting to match either @domaina or @domainb to allow 'CanonicalizeEmailAddressReplace' it with @domainc. Thank you, Kamber Dalal RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Help installing RT4 on Ubuntu
I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don't know what else to do regarding the installing RT. I seriously need help with detail how-to, please Thanks, -Original Message- From: Bart b...@pleh.info To: rt-users rt-users@lists.bestpractical.com Sent: Wed, Feb 1, 2012 10:06 am Subject: Re: [rt-users] Help installing RT4 on Ubuntu Hi, Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?) At least, it looks that way. If the above is what you've done then I really don't understand the external auth errors your getting, a clean installation doesn't contain external auth... My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point). Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ). I assume you've documented all your steps up to this point, could you show us exactly what you've done? (you've installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig). -- Bart Op 31 januari 2012 20:36 schreef Borngunners borngunn...@aol.com het volgende: Okay. Now I have try to reinstall RT again and so far these are the configurations I have: root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost 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 Name: rt4 User: rtuser DBA:root Now creating a mysql database rt4 for RT. Done. Now populating database schema. Done. Now inserting database ACLs. Granting access to rtuser@'localhost' on rt4. Done. Now inserting RT core system objects. Done. [Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles functionality. You should set the 'active' property of the 'default' lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/../lib/RT/Config.pm:766) Now inserting data. [Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536) [Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/../lib/RT/Handle.pm:826) [Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn't find row (/var/tmp/rt-4.0.4/sbin/../lib/RT/Handle.pm:956) Done inserting data. Done. Apache configuration: VirtualHost helpdesks.uhc.umd.edu ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access # LogLevel debug AddDefaultCharset UTF-8 DocumentRoot /opt/rt4/share/html Location / Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /opt/rt4/sbin/rt-server /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server); /Perl /VirtualHost thanks, -Original Message- From: Kevin Falcone falc...@bestpractical.com To: rt-users rt-users@lists.bestpractical.com Sent: Mon, Jan 30, 2012 6:32 pm Subject: Re: [rt-users] Help installing RT4 on Ubuntu On Mon, Jan 30, 2012 at 05:11:54PM -0500, Borngunners wrote: Hello Falcone, I have tried the config as stated. This is the message I receive after starting apche: root@helpdesks:/etc/apache2# /etc/init.d/apache2 start * Starting web server apache2 [Mon Jan 30 22:08:01 2012] [warning]: DBD::mysql::st execute failed: Table 'rt4.Users' doesn't exist 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) You don't appear to have created the RT database. When you said On Thu, Jan 26, 2012 at 12:02:28PM -0500, Borngunners wrote: I have installed RT 4 on ubuntu and have tested the web after What did you do to install RT? It'd be great if you looked through the README and compared the steps to the notes about what you did. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston � March 5
[rt-users] RES: Help installing RT4 on Ubuntu
Did you put /rt in the end of url? Ex: http://192.168.1.1/rt Have Ubuntu 11.10 installed 3 weeks ago, don’t remember to change apache conf except of including this line: Include /etc/request-tracker4/apache2-modperl2.conf” Last 2 lines of my conf: tail -n2 /etc/apache2/sites-available/default Include /etc/request-tracker4/apache2-modperl2.conf /VirtualHost De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Borngunners Enviada em: quinta-feira, 2 de fevereiro de 2012 12:04 Para: b...@pleh.info; rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Help installing RT4 on Ubuntu I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don't know what else to do regarding the installing RT. I seriously need help with detail how-to, please Thanks, -Original Message- From: Bart b...@pleh.infomailto:b...@pleh.info To: rt-users rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com Sent: Wed, Feb 1, 2012 10:06 am Subject: Re: [rt-users] Help installing RT4 on Ubuntu Hi, Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?) At least, it looks that way. If the above is what you've done then I really don't understand the external auth errors your getting, a clean installation doesn't contain external auth... My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point). Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ). I assume you've documented all your steps up to this point, could you show us exactly what you've done? (you've installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig). -- Bart Op 31 januari 2012 20:36 schreef Borngunners borngunn...@aol.commailto:borngunn...@aol.com het volgende: Okay. Now I have try to reinstall RT again and so far these are the configurations I have: root@helpdesks:/var/tmp/rt-4.0.4#mailto:root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost 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 Name: rt4 User: rtuser DBA:root Now creating a mysql database rt4 for RT. Done. Now populating database schema. Done. Now inserting database ACLs. Granting access to rtuser@'localhost' on rt4. Done. Now inserting RT core system objects. Done. [Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles functionality. You should set the 'active' property of the 'default' lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/../lib/RT/Config.pm:766) Now inserting data. [Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536) [Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/../lib/RT/Handle.pm:826) [Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn't find row (/var/tmp/rt-4.0.4/sbin/../lib/RT/Handle.pm:956) Done inserting data. Done. Apache configuration: VirtualHost helpdesks.uhc.umd.edu ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access # LogLevel debug AddDefaultCharset UTF-8 DocumentRoot /opt/rt4/share/html Location / Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /opt/rt4/sbin/rt-server /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server); /Perl /VirtualHost thanks, -Original Message- From: Kevin Falcone falc...@bestpractical.commailto:falc...@bestpractical.com To: rt-users rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com Sent: Mon, Jan 30, 2012 6:32 pm Subject: Re: [rt-users] Help installing RT4 on Ubuntu On Mon, Jan 30, 2012 at 05:11:54PM -0500, Borngunners wrote: Hello Falcone, I have tried the config as stated. This is the message I receive
Re: [rt-users] Help installing RT4 on Ubuntu
Hi, As mentioned, after the installation you have to manually add the RT config to apache. The installation won't configure apache automatically for you, you can probably use the include line Diaulas mentioned. Other then that, it looks like you've done the installation the Ubuntu way (which is ok), all you need to do now is configure Apache. Let us know if it worked. -- Bart Op 2 februari 2012 15:12 schreef Diaulas Castro diaulas.cas...@intersolution.inf.br het volgende: ** ** Did you put /rt in the end of url? Ex: http://192.168.1.1/rt ** ** Have Ubuntu 11.10 installed 3 weeks ago, don’t remember to change apache conf except of including this line: ** ** Include /etc/request-tracker4/apache2-modperl2.conf” ** ** ** ** Last 2 lines of my conf: ** ** tail -n2 /etc/apache2/sites-available/default Include /etc/request-tracker4/apache2-modperl2.conf /VirtualHost ** ** ** ** ** ** *De:* rt-users-boun...@lists.bestpractical.com [mailto: rt-users-boun...@lists.bestpractical.com] *Em nome de *Borngunners *Enviada em:* quinta-feira, 2 de fevereiro de 2012 12:04 *Para:* b...@pleh.info; rt-users@lists.bestpractical.com *Assunto:* Re: [rt-users] Help installing RT4 on Ubuntu ** ** I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don't know what else to do regarding the installing RT. I seriously need help with detail how-to, please Thanks, ** ** ** ** ** ** -Original Message- From: Bart b...@pleh.info To: rt-users rt-users@lists.bestpractical.com Sent: Wed, Feb 1, 2012 10:06 am Subject: Re: [rt-users] Help installing RT4 on Ubuntu Hi, ** ** Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?) ** ** At least, it looks that way. If the above is what you've done then I really don't understand the external auth errors your getting, a clean installation doesn't contain external auth... ** ** My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point). ** ** Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ). ** ** I assume you've documented all your steps up to this point, could you show us exactly what you've done? (you've installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig). ** ** -- Bart Op 31 januari 2012 20:36 schreef Borngunners borngunn...@aol.com het volgende: Okay. Now I have try to reinstall RT again and so far these are the configurations I have: root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost 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 Name: rt4 User: rtuser DBA:root Now creating a mysql database rt4 for RT. Done. Now populating database schema. Done. Now inserting database ACLs. Granting access to rtuser@'localhost' on rt4. Done. Now inserting RT core system objects. Done. [Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles functionality. You should set the 'active' property of the 'default' lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/../lib/RT/Config.pm:766) Now inserting data. [Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536) [Tue Jan 31 19:32:37 2012] [error]: Could not set user info (/var/tmp/rt-4.0.4/sbin/../lib/RT/Handle.pm:826) [Tue Jan 31 19:32:38 2012] [error]: Unable to load user: root : Couldn't find row (/var/tmp/rt-4.0.4/sbin/../lib/RT/Handle.pm:956) Done inserting data. Done. Apache configuration: VirtualHost helpdesks.uhc.umd.edu ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access # LogLevel debug AddDefaultCharset UTF-8 DocumentRoot /opt/rt4/share/html Location / Order allow,deny Allow from all SetHandler perl-script
Re: [rt-users] [rt-devel] RT 4.0.5rc1 Released
LOL -- well that's a fine how-do-you-do! Actually, I did skip 4.0.4 (my recollection is that it was announced as solely addressing an installation issue I hadn't had) so the previous version was 4.0.3. What I'm seeing in the emails seems like mostly the removal of some of the Aileron theming so it looks more like I'm getting an email than a copy/paste from the web page. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Sibley Sent: Tuesday, January 31, 2012 8:31 PM To: RT Users Subject: Re: [rt-users] [rt-devel] RT 4.0.5rc1 Released On 01/31/2012 09:57 AM, Roedel, Mark wrote: Working well for us so far -- I really like the new look for dashboard emails. I don't think the dashboard emails have changed since 4.0.4. Are you comparing to a different version? If not, I'd be curious to see what change you're talking about. ;) RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] RT-Authen-ExternalAuth plugin causes 'Can't locate Apache.pm in @INC' issue
Thanks Bart. User interface is not affected. Only Php/Perl code execution. On Feb 1, 2012, at 11:32 PM, Bart b...@pleh.infomailto:b...@pleh.info wrote: Are you only getting the errors when executing the custom PHP/Perl code? Or does this also affect RT's user interface/functionality? -- Bart Op 2 februari 2012 02:33 schreef Srikumar Nair srikum...@fb.commailto:srikum...@fb.com het volgende: We have a RT 4.0.4 installation running on Apache. We have some front end PHP code that calls Perl scripts which use Perl RT APIs for RT interactions. Recently we installed the RT-Authen-ExternalAuth plugin (version 0.09) to RT. This creates the the following error when ever the php tries to invoke the perl scripts. But if I remove the plugin from the RT_SiteConfig.pm file everything works fine again. Has anyone see this issue? Can't locate Apache.pm in @INC (@INC contains: /opt/rt4/local/lib /opt/rt4/local/plugins/RT-Site-Facebook-TicketPageMenu/lib /opt/rt4/local/plugins/RT-Site-Facebook-SetQueue/lib /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib /opt/rt4/local/plugins/RT-Extension-ArticleTemplates/lib /opt/rt4/lib /opt/rt4/share/html/fb/perl /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/lib/perl5/5.8.8/CGI/Cookie.pm line 38, DATA line 558. Compilation failed in require at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI/Cookie.pm line 3, DATA line 558. BEGIN failed--compilation aborted at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI/Cookie.pm line 3, DATA line 558. Compilation failed in require at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 4, DATA line 558. BEGIN failed--compilation aborted at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 4, DATA line 558. Compilation failed in require at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm line 27, DATA line 558. BEGIN failed--compilation aborted at /opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm line 27, DATA line 558. Thanks a bunch. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston — March 5 6, 2012 RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Problem configuring AD integration
Hello guys,
I'm having the following error when logging in with any Active Directory user
on RT:
Can't call method as_string on an undefined value at
/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm
line 304.
I've followed instructions at http://requesttracker.wikia.com/wiki/ExternalAuth
to set this up.
My /opt/rt4/etc/RT_SiteConfig.pm is as follows:
Set( $DatabaseUser, 'rt_user' );
Set( $CorrespondAddress, '' );
Set( $rtname, 'galileu.pt' );
Set( $DatabaseRequireSSL, '' );
Set( $WebPort, '8080' );
Set( $Organization, 'galileu.pt' );
Set( $DatabaseType, 'mysql' );
Set( $DatabasePort, '' );
Set( $DatabasePassword, 'db_password' );
Set( $DatabaseAdmin, 'root' );
Set( $SendmailPath, '/usr/sbin/sendmail' );
Set( $WebDomain, 'debian' );
Set( $DatabaseAdminPassword, 'db_password' );
Set( $CommentAddress, '' );
Set( $DatabaseHost, 'localhost' );
Set( $DatabaseName, 'rt4' );
Set( $OwnerEmail, 'root@localhost' );
Set( @Plugins, qw(RT::Authen::ExternalAuth) );
Set($ExternalAuthPriority, [ 'My_LDAP',
'My_MySQL',
'My_SSO_Cookie'
]
);
Set($ExternalInfoPriority, [ 'My_MySQL',
'My_LDAP'
]
);
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers,0);
Set($ExternalSettings, { # AN EXAMPLE DB SERVICE
'My_MySQL' = { ## GENERIC SECTION
# The type of service
(db/ldap/cookie)
'type'
= 'db',
# The server hosting
the service
'server'
= 'localhost',
## SERVICE-SPECIFIC
SECTION
# The database name
'database'
= 'rt4',
# The database table
'table'
= 'USERS_TABLE',
# The user to connect
to the database as
'user'
= 'DB_USER',
# The password to use
to connect with
'pass'
= 'DB_PASS',
# The port to use to
connect with (e.g. 3306)
'port'
= 'DB_PORT',
# The name of the Perl
DBI driver to use (e.g. mysql)
'dbi_driver'
= 'DBI_DRIVER',
# The field in the
table that holds usernames
'u_field'
= 'username',
# The field in the
table that holds passwords
'p_field'
= 'password',
# The Perl package
subroutine used to encrypt passwords
# e.g. if the passwords
are stored using the MySQL v3.23 PASSWORD
# function, then you
will need Crypt::MySQL::password, but for the
# MySQL4+ password
function you will need Crypt::MySQL::password41
# Alternatively, you
could use Digest::MD5::md5_hex or any other
# encryption subroutine
you can load in your perl installation
'p_enc_pkg'
= 'Crypt::MySQL',
'p_enc_sub'
= 'password',
# If your p_enc_sub
takes a salt as a second parameter,
# uncomment this line
to add your salt
#'p_salt'
= 'SALT',
#
# The field and values
in the table that determines if a user should
Re: [rt-users] External Auth using Active Directory 2008
# cat RT_SiteConfig.pm
Set($ExternalAuthPriority, [ 'My_LDAP',] );
Set($ExternalInfoPriority, [ 'My_LDAP',] );
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers, 0);
Set($ExternalSettings, {
'My_LDAP' = {
'type' = 'ldap',
'server'= 'zeus.mydomain.edu',
'user' =
'CN=LDAPRT,OU=CampusServices,DC=mydomain,DC=mydomain,DC=edu',
'pass' = '*',
'base' =
'DC=mydomain,DC=mydomain,DC=edu',
'filter'=
'((ObjectCategory=User)(ObjectClass=Person))',
'd_filter' =
'(userAccountControl:1.2.840.113556.1.4.803:=2)',
'tls' = 0,
# 'ssl_version' = 3,
'net_ldap_args' = [ version = 3 ],
'group' =
'CN=RTUsers,OU=CampusServices,DC= mydomain,DC=mydomain,DC=edu',
'group_attr'= 'member',
'attr_match_list' = [ 'Name',
'EmailAddress' ],
'attr_map' = { 'Name' =
'sAMAccountName',
'EmailAddress' =
'mail',
'Organization' =
'physicalDeliveryOfficeName',
'RealName' = 'cn',
'ExternalAuthId' =
'sAMAccountName',
'Gecos' =
'sAMAccountName',
'WorkPhone' =
'telephoneNumber',
'Address1' =
'streetAddress',
'City' = 'l',
'State' = 'st',
'Zip' =
'postalCode',
'Country' = 'co'
}
}
}
);
1;
EOF
I do not have Debugging turned on. I am going to need some help turning it on
since this is new to me.
Here are some errors from /var/log/messages...
This is a failed attempt...
Feb 1 16:02:25 localhost RT: My_LDAP AUTH FAILED mary.servantez (can't bind:
LDAP_INVALID_CREDENTIALS 49 )
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:82)
Feb 1 16:02:25 localhost RT: FAILED LOGIN for mary.servantez from 10.1.41.95
(/opt/rt4/sbin/../lib/RT/Interface/Web.pm:655)
Here is a successful attemt
Feb 2 10:14:02 localhost RT: RT::Authen::ExternalAuth::LDAP::GetAuth External
Auth OK ( My_LDAP ): test.account
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:139)
Feb 2 10:14:02 localhost RT: Couldn't enable user 28
(/opt/rt4/sbin/../lib/RT/User.pm:1066)
Feb 2 10:14:02 localhost RT: User marked as ENABLED ( test.account ) per
External Service (, )
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274)
Feb 2 10:14:02 localhost RT: RT::Authen::ExternalAuth::CanonicalizeUserInfo
returning Address1: , City: , Country: , EmailAddress: test.acco...@lcu.edu,
ExternalAuthId: test.account, Gecos: test.account, Name: test.account,
Organization: , RealName: Test Account, State: , WorkPhone: , Zip:
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536)
Feb 2 10:14:02 localhost RT: Successful login for test.account from 10.1.5.9
(/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:219)
Van Howell
System Administrator
Lubbock Christian University
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Wednesday, February 01, 2012 5:33 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] External Auth using Active Directory 2008
On Wed, Feb 01, 2012 at 11:04:38PM +, Howell, Van wrote:
I have added several users into the RTUsers group I set up in AD.
The AD Administrator, a common Domain User called Test.Account that is
located in the OU with
all my other users, my personal account also located in the OU with all
the other users and an
alternate administrative account I use.
I can logon to RT with the AD Administrator account. I can logon to RT
with the Test.Account
and I can log in using my alternate account. But I
Re: [rt-users] Add queue change to Update.html (comment/reply) CF Columns under Basic view
On Thu, Feb 02, 2012 at 09:40:32AM +0100, Bart wrote: Change queue during comment/reply (on Update.html) I'm wondering of there's an easy way of adding Queue change to the comment/reply page (Update.html). It would be a nice addition to habe the ability to enable/disable this. We have several departments that communicate with each other, having the ability to change the queue when placing a comment/reply would help with the communication (easier then placing the comment and then changing the queue via Basics, or easier then using the Jumbo page. The reason I'm asking is because I want to stay away from editing these files (they break on updates ^_~), I'd like a more general solution which will persist during updates. (same goes for the next question) You want to read about Callbacks on the wiki, or look at how the extension you link to is doing it and borrow the idea. You should be able to add the SelectQueue component and then it'll get processed during the normal update process. CustomField Single column view under Basics Also, I've found this plugin (thanks Rus!) RT::Extension::CustomFieldsOnUpdate ( [1]http://search.cpan.org/dist/RT-Extension-CustomFieldsOnUpdate/lib/RT/Extension/CustomFieldsOnUpdate.pm ) The plugin works great but the order in which the CustomFields are shown is kinda messy. The reason for the order being messy is because we've set the order based upon the two column view under Basics. (which goes from right to left and then from top to down) In the RT Config there's this option which should make it possible to show a single column view of the Custom Fields: =item C$EditCustomFieldsSingleColumn When displaying a list of Ticket Custom Fields for editing, RT defaults to a 2 column list. If you set this to 1, it will instead display the Custom Fields in a single column. =cut Set($EditCustomFieldsSingleColumn, 0); This option however doesn't seem to have any effect. Will this option get a fix during a future release? There's a bug open for this, unfortunately it was broken during the rewrite of the Update page and lost in the merge up from 3.8 to 4.0 (the option works in 3.8 where it was implemented). You can track the bug here http://issues.bestpractical.com/Ticket/Display.html?id=18555 -kevin This would be great, if I can display the CustomFields in a single column on all pages then I can have a uniform CF order which will be the same on the Ticket overview, basics and comment/reply page. (or any other tip to achieve this would be appreciated) pgpbm8bmW4GeN.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] How to adjust 'Organization' in 'About me'
On Thu, Feb 02, 2012 at 12:42:32PM -, Jeffery, Guy wrote: Quick question that hopefully is fairly easy to resolve - my users want to be able to adjust their 'Organization' within 'About me' in the Preferences menu. Providing 'ModifySelf' privileges to users allows adjustment of every other field on that screen, apart from Organization. What privilege do users need to alter this? I'm using RT 3.8.7 and 3.8.9. ModifySelf is the only right that affects this unfortunately, and it's an all or nothing right. You'd need to write some code to restrict what is updated, or you could use something similar to the LDAPImporter extension to suck in correct organization data from an up-to-date external source. -kevin pgpnTuW8ORchK.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] CanonicalizeEmailAddressMatch
On Thu, Feb 02, 2012 at 09:00:06AM -0500, Dalal, Kamber Z wrote: Need the proper syntax for 'CanonicalizeEmailAddressMatch' setting to match either @domaina or @domainb to allow 'CanonicalizeEmailAddressReplace' it with @domainc. It's just a perl regular expression, so literally you get s/CanonicalizeEmailAddressMatch/CanonicalizeEmailAddressReplace/gi at the end. So experiment with: my $email = b...@domaina.com; $email =~ s/CanonicalizeEmailAddressMatch/CanonicalizeEmailAddressReplace/gi print $email; outside RT to get what you want. -kevin pgpEoThRI8pTA.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Problem configuring AD integration
On Thu, Feb 02, 2012 at 04:21:48PM +, Bruno Martins wrote:
Can't call method as_string on an undefined value at
/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm
line 304.
I've followed instructions at
http://requesttracker.wikia.com/wiki/ExternalAuth to set this up.
I suggest the docs in the config and with the module over anything on
the wiki.
Set($ExternalAuthPriority, [ 'My_LDAP',
'My_MySQL',
'My_SSO_Cookie'
]
);
Set($ExternalInfoPriority, [ 'My_MySQL',
'My_LDAP'
]
);
Why do you have all of these turned on? You've only configured
My_LDAP. Telling RT to look into a misconfigured My_MySQL will only
cause other errors.
The config as shipped is an example and you should remove the pieces
you aren't using.
'My_LDAP' = { ## GENERIC SECTION
# The type of service
(db/ldap/cookie)
'type'
= 'ldap',
# The server hosting
the service
'server'
= 'jupiter.galileu-f.galileu.pt',
## SERVICE-SPECIFIC
SECTION
# If you can bind to
your LDAP server anonymously you should
# remove the user and
pass config lines, otherwise specify them here:
#
# The username RT
should use to connect to the LDAP server
'user'
= 'ldap_domainadmin',
# The password RT
should use to connect to the LDAP server
'pass'
= 'ldap_password',
#
# The LDAP search base
'base'
= 'dc=galileu-f,dc=galileu,dc=pt',
#
# ALL FILTERS MUST BE
VALID LDAP FILTERS ENCASED IN PARENTHESES!
See this doc ^
# YOU **MUST**
SPECIFY A filter AND A d_filter!!
#
# The filter to use
to match RT-Users
'filter'
= 'objectClass=*',
You're missing parens on this filter which I believe is causing your
problem.
# A catch-all example
filter: '(objectClass=*)'
#
# The filter that
will only match disabled users
'd_filter'
= 'UserAccountControl:1.2.840.113556.1.4.803:=2',
# A catch-none
example d_filter: '(objectClass=FooBarBaz)'
#
# Should we try to
use TLS to encrypt connections?
'tls'
= 0,
# SSL Version to
provide to Net::SSLeay *if* using SSL
'ssl_version'
= 3,
# What other args
should I pass to Net::LDAP-new($host,@args)?
'net_ldap_args'
= [version = 3 , port = 3268 ],
# Does authentication
depend on group membership? What group name?
#'group'
= 'GROUP_NAME',
# What is the
attribute for the group object that determines membership?
#'group_attr'
= 'GROUP_ATTR',
## RT ATTRIBUTE
MATCHING SECTION
Re: [rt-users] External Auth using Active Directory 2008
On Thu, Feb 02, 2012 at 04:16:53PM +, Howell, Van wrote: I do not have Debugging turned on. I am going to need some help turning it on since this is new to me. Here are some errors from /var/log/messages... This is a failed attempt... Feb 1 16:02:25 localhost RT: My_LDAP AUTH FAILED mary.servantez (can't bind: LDAP_INVALID_CREDENTIALS 49 ) (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:82) Feb 1 16:02:25 localhost RT: FAILED LOGIN for mary.servantez from 10.1.41.95 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:655) Here is a successful attemt Feb 2 10:14:02 localhost RT: RT::Authen::ExternalAuth::LDAP::GetAuth External Auth OK ( My_LDAP ): test.account (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:139) Feb 2 10:14:02 localhost RT: Couldn't enable user 28 (/opt/rt4/sbin/../lib/RT/User.pm:1066) Feb 2 10:14:02 localhost RT: User marked as ENABLED ( test.account ) per External Service (, ) (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:274) Feb 2 10:14:02 localhost RT: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Address1: , City: , Country: , EmailAddress: test.acco...@lcu.edu, ExternalAuthId: test.account, Gecos: test.account, Name: test.account, Organization: , RealName: Test Account, State: , WorkPhone: , Zip: (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536) Feb 2 10:14:02 localhost RT: Successful login for test.account from 10.1.5.9 (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:219) Since you're seeing these in /var/log/messages I assume you're using the syslog configuration. You want to read about LogToSyslog in etc/RT_Config.pm then copy that setting to RT_SiteConfig.pm and change it to debug. Restart RT and try the failed login again. -kevin pgpuyfWxcxDvm.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Two questions
On Tue, Jan 31, 2012 at 12:54:04PM -0500, Josh Narins wrote: On Tue, Jan 31, 2012 at 09:28:00AM -0500, Josh Narins wrote: I got partway along writing a Mail Plugin for RT3.8, but, somewhere along the way, I lost it. Can anyone point me to any documentation on them? My goal is to remove the endlessly duplicating newlines of the quoted text on each reply to our tickets and to remove the signatures. There is actually code in 3.8.10 or later to work around Outlook's bugs with newlines. I'm running 4.0.2 and still have the problem. Please followup with some sample data to rt-bugs? Thanks Sure. What data do you actually want? I'm happy to run any sort of query. I found a ticket with no business-sensitive information that has the problem. Josh Narins Director of Application Development SeniorBridge 845 Third Ave 7th Floor New York, NY 10022 Tel: (212) 994-6194 Mobile: (917) 488-6248 Fax: (212) 994-4260 jnar...@seniorbridge.com SeniorBridge Managing Complex Chronic Care http://www.seniorbridge.com SeniorBridge Statement of Confidentiality: The contents of this email message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. Any dissemination, distribution or copying of this email by an unintended or mistaken recipient is strictly prohibited. In said event, kindly reply to the sender and destroy all entries of this message and any attachments from your system. Thank you. RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] External Auth using Active Directory 2008
I added Set($LogToSyslog, debug); to my RT_SiteConfig.pm file I don't seem to be getting an more logging. I restarted the httpd service, didn't see any more logging so I restarted the server. This is the entire tail of the messages log [root@OpenNMS etc]# tail /var/log/messages Feb 2 11:56:45 localhost abrtd: Dump directory is a duplicate of /var/spool/abrt/ccpp-2012-02-01-14:08:36-18683 Feb 2 11:56:45 localhost abrtd: Deleting dump directory ccpp-2012-02-02-11:54:56-2567 (dup of ccpp-2012-02-01-14:08:36-18683), sending dbus signal Feb 2 12:00:42 localhost RT: The actual HTTP_HOST (192.168.1.200) does NOT match the configured WebDomain (lcu.edu). Perhaps you should Set($WebDomain, '192.168.1.200'); in RT_SiteConfig.pm, otherwise your internal links may be broken. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1087) Feb 2 12:05:43 localhost RT: The actual HTTP_HOST (192.168.1.200) does NOT match the configured WebDomain (lcu.edu). Perhaps you should Set($WebDomain, '192.168.1.200'); in RT_SiteConfig.pm, otherwise your internal links may be broken. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1087) Feb 2 12:10:44 localhost RT: The actual HTTP_HOST (192.168.1.200) does NOT match the configured WebDomain (helpdesk.lcu.edu). Perhaps you should Set($WebDomain, '192.168.1.200'); in RT_SiteConfig.pm, otherwise your internal links may be broken. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1087) Feb 2 12:14:00 localhost RT: My_LDAP AUTH FAILED: van.howell (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:127) Feb 2 12:14:00 localhost RT: FAILED LOGIN for van.howell from 10.1.5.9 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:655) Feb 2 12:15:45 localhost RT: The actual HTTP_HOST (192.168.1.200) does NOT match the configured WebDomain (helpdesk.lcu.edu). Perhaps you should Set($WebDomain, '192.168.1.200'); in RT_SiteConfig.pm, otherwise your internal links may be broken. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1087) Feb 2 12:16:16 localhost RT: My_LDAP AUTH FAILED: van.howell (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:127) Feb 2 12:16:16 localhost RT: FAILED LOGIN for van.howell from 10.1.5.9 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:655) Thanks for helping with this. Van Howell System Administrator Lubbock Christian University -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Thursday, February 02, 2012 11:17 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] External Auth using Active Directory 2008 On Thu, Feb 02, 2012 at 04:16:53PM +, Howell, Van wrote: I do not have Debugging turned on. I am going to need some help turning it on since this is new to me. Here are some errors from /var/log/messages... This is a failed attempt... Feb 1 16:02:25 localhost RT: My_LDAP AUTH FAILED mary.servantez (can't bind: LDAP_INVALID_CREDENTIALS 49 ) (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalA uth/LDAP.pm:82) Feb 1 16:02:25 localhost RT: FAILED LOGIN for mary.servantez from 10.1.41.95 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:655) Here is a successful attemt Feb 2 10:14:02 localhost RT: RT::Authen::ExternalAuth::LDAP::GetAuth External Auth OK ( My_LDAP ): test.account (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalA uth/LDAP.pm:139) Feb 2 10:14:02 localhost RT: Couldn't enable user 28 (/opt/rt4/sbin/../lib/RT/User.pm:1066) Feb 2 10:14:02 localhost RT: User marked as ENABLED ( test.account ) per External Service (, ) (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalA uth.pm:274) Feb 2 10:14:02 localhost RT: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Address1: , City: , Country: , EmailAddress: test.acco...@lcu.edu, ExternalAuthId: test.account, Gecos: test.account, Name: test.account, Organization: , RealName: Test Account, State: , WorkPhone: , Zip: (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalA uth.pm:536) Feb 2 10:14:02 localhost RT: Successful login for test.account from 10.1.5.9 (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalA uth.pm:219) Since you're seeing these in /var/log/messages I assume you're using the syslog configuration. You want to read about LogToSyslog in etc/RT_Config.pm then copy that setting to RT_SiteConfig.pm and change it to debug. Restart RT and try the failed login again. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Filter by requestor email domain
Thanks Bart,
That looks good. I'm having an issue with it though - I need to match
against a regexp for the exception list.. I added an entry like '*@
example.com' to @exceptionlist and rt is still sending out create
confirmations. What am I missing?
thanks!
On Mon, Jan 30, 2012 at 2:41 AM, Bart b...@pleh.info wrote:
Hi,
We had a similar requirement for a bunch of e-mail addresses.
This can be achieved by editing the autoreply scrip to look something like
this:
- Condition: User Defined
- Action: Auto Reply To Requestors
- Template: Your AutoReply template
- Stage: TransactionCreate
- Custom Condition:
my @exceptionList = ('na...@example.com',
'na...@example.com',
'na...@example.com');
my $transactionType = $self-TransactionObj-Type;
my $ticketRequestor = lc($self-TicketObj-RequestorAddresses);
my $trans = $self-TransactionObj;
if ($transactionType eq 'Create') {
return if grep { $ticketRequestor eq lc($_) } @exceptionList;
my $msgattr = $trans-Message-First;
return 0 unless $msgattr;
return 1 if $msgattr-GetHeader('Received');
}
return 0;
In addition the above only sends an autoreply when someone sends an
e-mail, in our case we don't like the autoreply mails when we manually
create a ticket (e.g. via quick create).
Hope this helps.
-- Bart
Op 25 januari 2012 21:02 schreef Ram Moskovitz ram0...@gmail.com het
volgende:
Hey there,
I'm looking to not auto-reply on create to inbound emails from a certain
domain ( anyth...@example.com and even anyth...@sd.example.com). I
suppose the right way to go about this is via user defined condition in the
global scrip for autoreply on create. I have steps 1 and 3.. what's step 2?
1 return 0 unless $self-TransactionObj-Type eq Create;
2 return 0 if #self-TicketObj-
3 return 1
thanks
ram
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston — March 5 6, 2012
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 6, 2012
Re: [rt-users] RT-to-RT communication
Alek Cesarz pisze, W dniu 2012-01-25 21:48: thanks Kevin. will check and get back with results. I tried to review the code but with no success. nothing found in incoming mail looks like it should trigger any special behaviour, but... I am not a Perl hacker so my understanding of RT's code is limited. what I found is that during ticket creation RT adds following headers to first transaction: RT-Squelch-Replies-To: requ...@blahblah.net.pl RT-DetectedAutoGenerated:true which may block autoresponder. requ...@blahblah.net.pl is the address from which other instance of RT is sending mails. below are original headers from incoming email and headers recorded in RT's first transation (Ticket created) *original headers*: Subject: =?UTF-8?B?W2RpYWxvZyAjMTE5MjE1MV0gVEVTVDogemfFgm9zemVuaWUgdGVzdG93ZSBm?= =?UTF-8?B?cm9tIHJlcXVlc3Q=?= From: requ...@blahblah.net.pl Reply-To: requ...@blahblah.net.pl In-Reply-To: References: rt-ticket-1192...@blahblah.net.pl Message-ID: rt-3.6.7-2530-1328097677-438.1192151-4...@blahblah.net.pl Precedence: bulk X-RT-Loop-Prevention: blahblah RT-Ticket: blahblah #1192151 Managed-by: RT 3.6.7 (http://www.bestpractical.com/rt/) RT-Originator: someu...@blahblah.net.pl To: blahb...@support.s4tech.pl Cc: some.u...@blahblah.pl MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 X-RT-Original-Encoding: utf-8 Date: Wed, 01 Feb 2012 13:01:17 +0100 *headers recorded by RT*: CC: some.u...@blahblah.pl MIME-Version:1.0 In-Reply-To: rt-3.6.7-19027-1328172472-527.1192151-4...@blahblah.net.pl References: rt-ticket-1192...@blahblah.net.pl rt-ticket...@support.s4tech.pl rt-3.6.7-2530-1328097677-438.1192151-4...@blahblah.net.pl rt-4.0.4-2156-1328172181-1268.61-...@support.s4tech.pl rt-3.6.7-19027-1328172472-527.1192151-4...@blahblah.net.pl Typ zawartości: text/plain; charset=utf-8 Reply-To:requ...@blahblah.net.pl Message-ID: rt-3.6.7-19027-1328176621-233.1192151-4...@blahblah.net.pl X-RT-Original-Encoding: utf-8 RT-Originator: someu...@wroclaw.blahblah.net.pl Received:from mail-1-out.blahblah.net.pl ([1.2.3.4] helo=srv-1.blahblah.net.pl) by support.s4tech.pl with esmtp (Exim 4.72) (envelope-from cd...@tracker-1.blahblah.net.pl) id 1RstL7-0002rf-GS for blahb...@support.s4tech.pl; Thu, 02 Feb 2012 10:52:25 +0100 Received:from [5.6.7.8] (port=39720 helo=tracker-1.blahblah.net.pl) by srv.blahblah.net.pl with esmtp (blahblah SMTP) id 1RstMA-1k-Q5 (envelope-from cd...@tracker-1.blahblah.net.pl); Thu, 02 Feb 2012 10:53:30 +0100 Received:from cdsrt by rt-cds.int with local (Exim 4.63) (envelope-from cd...@tracker-1.blahblah.net.pl) id 1RstPZ-0005X3-N9; Thu, 02 Feb 2012 10:57:01 +0100 Managed-BY: RT 3.6.7 (http://www.bestpractical.com/rt/) Temat: [blahblah #1192151] TEST: zgłoszenie testowe from request Date:Thu, 02 Feb 2012 10:57:01 +0100 RT-Ticket: blahblah #1192151 Precedence: bulk X-RT-Loop-Prevention:blahblah Do: blahb...@support.s4tech.pl Content-Transfer-Encoding: 8bit From:requ...@blahblah.net.pl RT-Squelch-Replies-To: requ...@blahblah.net.pl RT-DetectedAutoGenerated:true Content-Length: 2786 any ideas? -- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] [rt-announce] RT 4.0.5 Released
I'm happy to announce that RT 4.0.5 is now available for download. http://download.bestpractical.com/pub/rt/release/rt-4.0.5.tar.gz http://download.bestpractical.com/pub/rt/release/rt-4.0.5.tar.gz.sig SHA1 sums 59697fbfa3876d1950499796a429622941272edf rt-4.0.5.tar.gz a9040dfb1ae59f872727564709186fbdecaffe1c rt-4.0.5.tar.gz.sig This release contains a number of bugfixes and small improvements since the 4.0.4 release; a few of the more notable ones include: * Greatly improved print CSS * New Config option - HideResolveActionsWithDependencies removes actions such as Resolve from the action menu on tickets with outstanding dependencies * New Config option - AutocompleteOwnersForSearch allows admins to force an Owner autocompleter in the Query Builder * New Config option - NoTicketInterfaceForApprovals redirects users to the Approvals interface if they visit an Approval ticket in the regular RT UI * Improved Simple Search documentation and new 'any' keyword for any status * Improved case insensitivity in the User and Custom Field Autocompleters * new --enable-ssl-mailgate configure option and rt-mailgate options to assist with setting rt-mailgate up to talk to your ssl enabled RT server * More improvements to email quote detection to handle Outlook quoting * The CreateTickets action now supports adding Groups as Watchers * httpurl_overwrite no longer inserts spaces into your URLs * Added NBSP as a search column in the Query Builder * Maintain Approved/Denied state in the radio button on past Approvals * Fixes for __Bookmarked__ ticket searches * Bugfixes for OverrideOutgoingMailFrom and sending bounces * More consistent ordering of Articles * Improvements to menu internals, including fixes for Search collections and localization of key names * Preserve Content-Disposition when redistributing mail * Improved PGP handling for .asc attachments with misleading content-types * By default, RT's session cookie will not be available to javascript * Allow Charts to be grouped by Told. * Test and localization cleanups. A complete changelog is available from git by running `git log rt-4.0.4..rt-4.0.5` pgpEiX4RpK3CF.pgp Description: PGP signature ___ rt-announce mailing list rt-annou...@lists.bestpractical.com http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] Help installing RT4 on Ubuntu
Now RT is coming up, but I noticed couple of things: 1. It seems like RT is using sqlite database instead of mysql. (How do you make RT to use mysql? If I make the changes in RT_SiteConfig.pm to use mysql, will it work?) 2. How do I make RT to work without the /rt path in the RT_SiteConfig.pm? Also, If I want to configure LDAP authentication, how do I go about accomplishing that since the installation was done via aptitude? Last but not least I have a backup database from another RT server version 3.8, which was mysql database, how do I go about restoring the database from the fron-end, if possible? Thanks, -Original Message- From: Bart b...@pleh.info To: rt-users rt-users@lists.bestpractical.com Sent: Thu, Feb 2, 2012 10:00 am Subject: Re: [rt-users] Help installing RT4 on Ubuntu Hi, As mentioned, after the installation you have to manually add the RT config to apache. The installation won't configure apache automatically for you, you can probably use the include line Diaulas mentioned. Other then that, it looks like you've done the installation the Ubuntu way (which is ok), all you need to do now is configure Apache. Let us know if it worked. -- Bart Op 2 februari 2012 15:12 schreef Diaulas Castro diaulas.cas...@intersolution.inf.br het volgende: Did you put /rt in the end of url? Ex: http://192.168.1.1/rt Have Ubuntu 11.10 installed 3 weeks ago, don’t remember to change apache conf except of including this line: Include /etc/request-tracker4/apache2-modperl2.conf” Last 2 lines of my conf: tail -n2 /etc/apache2/sites-available/default Include /etc/request-tracker4/apache2-modperl2.conf /VirtualHost De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com]Em nome de Borngunners Enviada em: quinta-feira, 2 de fevereiro de 2012 12:04 Para: b...@pleh.info; rt-users@lists.bestpractical.com Assunto: Re: [rt-users] Help installing RT4 on Ubuntu I have reinstalled everything again, starting from the OS. I installed ubuntu 11 and I installed RT using the following command apt-get install request-tracker4. Everything has being installed, but I am still getting the It Works! message. It seems like this version of RT is a bit complicated to install, right? Don't know what else to do regarding the installing RT. I seriously need help with detail how-to, please Thanks, -Original Message- From: Bart b...@pleh.info To: rt-users rt-users@lists.bestpractical.com Sent: Wed, Feb 1, 2012 10:06 am Subject: Re: [rt-users] Help installing RT4 on Ubuntu Hi, Are you trying to do the source installation on Ubuntu? (btw, which version of Ubuntu?) At least, it looks that way. If the above is what you've done then I really don't understand the external auth errors your getting, a clean installation doesn't contain external auth... My advise would be to make sure you have a clean installation up and running first before playing with plugins (theres really no point). Also, if you have the latest Ubuntu server then you can also install RT using Aptitude ( aptitude search request-tracker4 ). I assume you've documented all your steps up to this point, could you show us exactly what you've done? (you've installed plugins, so undo that to begin with or at least turn off the plugins in the RT_SiteConfig). -- Bart Op 31 januari 2012 20:36 schreef Borngunners borngunn...@aol.com het volgende: Okay. Now I have try to reinstall RT again and so far these are the configurations I have: root@helpdesks:/var/tmp/rt-4.0.4# make initialize-database /usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action init --prompt-for-dba-password In order to create or update your RT database, this script needs to connect to your mysql instance on localhost 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 Name: rt4 User: rtuser DBA:root Now creating a mysql database rt4 for RT. Done. Now populating database schema. Done. Now inserting database ACLs. Granting access to rtuser@'localhost' on rt4. Done. Now inserting RT core system objects. Done. [Tue Jan 31 19:32:37 2012] [warning]: The ActiveStatus configuration has been replaced by the new Lifecycles functionality. You should set the 'active' property of the 'default' lifecycle and add transition rules; see RT_Config.pm for documentation. (/var/tmp/rt-4.0.4/sbin/../lib/RT/Config.pm:766) Now inserting data. [Tue Jan 31 19:32:37 2012] [info]: RT::Authen::ExternalAuth::CanonicalizeUserInfo returning Comments: SuperUser, Disabled: 0, EmailAddress: root@localhost, Gecos: root, Name: root, Password: password, Privileged: 1, RealName: Enoch Root (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:536) [Tue Jan 31 19:32:37 2012] [error]: Could not set user
