Re: [rt-users] RT4 - mod_perl problem with apache2
Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Carlos Ramos Gesendet: Montag, 31. Oktober 2011 05:25 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] RT4 - mod_perl problem with apache2 On Tue, May 31, 2011 at 9:00 AM, Kevin Falcone falc...@bestpractical.com wrote: On Mon, May 30, 2011 at 12:09:11PM +0200, Robert Wysocki wrote: Hi guys, I've googled it, some people also have this problem, but no solutions were provided by anyone. The problem is: testrt:/opt/rt4/etc# apache2ctl restart /usr/sbin/apache2ctl: line 107: 11712 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t 2 /dev/null Syntax OK /usr/sbin/apache2ctl: line 107: 11715 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t Action 'restart' failed. The Apache error log may have more information. testrt:/opt/rt4/etc# /etc/init.d/apache2 reload Syntax OK /usr/sbin/apache2ctl: line 107: 11729 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t Action 'configtest' failed. The Apache error log may have more information. failed! The way of restarting apache which doesn't cause error to be thrown is just: /etc/init.d/apache2 stop; /etc/init.d/apache2 start but it's, well, inelegant. The issue is probably related to Plack. Unfortunately, it's difficult to try replicating without a perl/apache/mod_perl2/plack version list -kevin Hello, I'm having a VERY similar problem here. Using rt-4.0.2 and debian squeeze 6.0.3, which comes with apache 2.2.16-6+squeeze4, mod_perl 2.0.4-7, perl 5.10.1-17squeeze2 and from what i can tell Plack 0.9984 which i just installed from CPAN. This is my rt config in apache: Location /rt 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 If I don't comment this Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server);, I can't do the following without getting a segmentation fault, even if apache is not running: root@blazar:~# export APACHE_RUN_USER=www-data root@blazar:~# export APACHE_RUN_GROUP=www-data root@blazar:~# export APACHE_PID_FILE=/var/run/apache2.pid root@blazar:~# export APACHE_RUN_DIR=/var/run/apache2 root@blazar:~# export APACHE_LOCK_DIR=/var/lock/apache2 root@blazar:~# export APACHE_LOG_DIR=/var/log/apache2 root@blazar:~# root@blazar:~# root@blazar:~# apache2 -t Syntax OK Segmentation fault That last sequence of commands is something that apache2ctl do almost every time you run it, and at least in Debian apache2ctl is used in a lot of places, from startup to shutdown to log rotation. RT4 works correctly from what i can tell as long as i don't comment the preload line, but then again apache2ctl breaks down and with it, other things follow. The only error i can see in my syslog every time i run 'apache -t' is the following: Oct 30 21:44:22 blazar kernel: [4016030.401140] apache2[17570]: segfault at 7fa814baa640 ip 7fa814baa640 sp 7d346fc8 error 14 in libnss_files-2.11.2.so[7fa817aaf000+b000] As a side note, I do have a working RT4 installation in debian squeeze, but this was installed some time ago and it was the rt-4.0.0 tarball and I guess some of the CPAN modules are older too. Any help would be really appreciated. Thanks a lot. RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Rights and permissions
On 1 Nov 2011, at 20:45, Zoedog wrote: I need to get some better advice for this subject. Super user, we assume having this privilege supersedes all rights and privileges, is this correct statement. I believe so. Group rights and individual rights. Do the group rights supersede individual rights and privileges or is it the other way around. Neither - they act like a logical OR. If a user has a right, through either an individual right or a group right, then they will have that right. I basically avoid using individual user rights altogether; on anything beyond a very small setup it becomes unmanageable. I always create an admincc group for each queue, for example, and give users rights to that queue by changing their group membership. Tim -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE. RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Apache2 CPU hungry !
Hi Kevin et al, thanks for your reply. I gove 2GByte to our RT installation but still eating a lot opf CPU and memory, as shown in this screenshot: http://dl.dropbox.com/u/15540617/Varie/rt.jpg It's a normal behavour ? Michele Il 27/10/2011 15:33, Kevin Falcone ha scritto: On Thu, Oct 27, 2011 at 10:52:13AM +0200, Michele Pinassi wrote: this is the problem ! There's a lot of memory and CPU usage but, on that machine, there's ONLY RT 4.0.2 ! 1G is not a lot of memory for a machine running RT's apache children AND mysql. Give it 2G or tune your apache footprint to be smaller. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Washington DC, USA — October 31 November 1, 2011 * Barcelona, Spain — November 28 29, 2011 -- Michele Pinassi Servizio Reti, Sistemi e Sicurezza Informatica Università degli Studi di Siena tel: 0577.(23)2169 https://sites.google.com/a/unisi.it/o-zone/ signature.asc Description: OpenPGP digital signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Apache2 CPU hungry !
On Wed, Nov 2, 2011 at 3:16 PM, Michele Pinassi michele.pina...@unisi.it wrote: Hi Kevin et al, thanks for your reply. I gove 2GByte to our RT installation but still eating a lot opf CPU and memory, as shown in this screenshot: http://dl.dropbox.com/u/15540617/Varie/rt.jpg It's a normal behavour ? CPU usage is not normal. Switching to FastCGI may help without investigating. Michele Il 27/10/2011 15:33, Kevin Falcone ha scritto: On Thu, Oct 27, 2011 at 10:52:13AM +0200, Michele Pinassi wrote: this is the problem ! There's a lot of memory and CPU usage but, on that machine, there's ONLY RT 4.0.2 ! 1G is not a lot of memory for a machine running RT's apache children AND mysql. Give it 2G or tune your apache footprint to be smaller. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Washington DC, USA — October 31 November 1, 2011 * Barcelona, Spain — November 28 29, 2011 -- Michele Pinassi Servizio Reti, Sistemi e Sicurezza Informatica Università degli Studi di Siena tel: 0577.(23)2169 https://sites.google.com/a/unisi.it/o-zone/ RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 -- Best regards, Ruslan. RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Apache2 CPU hungry !
On Wed, Nov 02, 2011 at 12:16:53PM +0100, Michele Pinassi wrote: thanks for your reply. I gove 2GByte to our RT installation but still eating a lot opf CPU and memory, as shown in this screenshot: http://dl.dropbox.com/u/15540617/Varie/rt.jpg It's a normal behavour ? While children occasionally spike to a high CPU usage, if that's been spinning for a while at 93% then something is wrong. You'll want to use your logs to find out what the apache child is doing. You might be able to divine it from access logs and seeing what pages are being loaded. You might need to use MasonX::Profiler to get more information about what pages are being run. -kevin Il 27/10/2011 15:33, Kevin Falcone ha scritto: On Thu, Oct 27, 2011 at 10:52:13AM +0200, Michele Pinassi wrote: this is the problem ! There's a lot of memory and CPU usage but, on that machine, there's ONLY RT 4.0.2 ! 1G is not a lot of memory for a machine running RT's apache children AND mysql. Give it 2G or tune your apache footprint to be smaller. -kevin pgp3NZIRanwVH.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Setting and locking priority settings
On Tue, Nov 01, 2011 at 08:09:25PM -0700, Zoedog wrote: I need to set and lock my priority settings as 1 to 3, with 3 being my lowest priority and 1 the highest with 3 being the initial default when a ticket is created. Along with that I need to ensure that only the system admin can have the ability to change those settings. Is there a way, and how can it be done. You can turn it into a dropdown list by using RT-Extension-PriorityAsString. If you need to limit who can edit it, you'll need to make changes to RT. The default value is controlled on the Queue admin page. -kevin pgpd60jSkiZ4y.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom per queue views
On Wed, Nov 02, 2011 at 03:16:14PM +1100, Samuel Leslie wrote: Does RT provide a mechanism to do this? I know that I can define search critera, sorting and displayed columns in the Query Builder and save the query, but I can't find a way to set a given saved query as the default for a queue. I can also see an option to configure the custom fields displayed in all queues: $DefaultSearchResultFormat; but this isn't really applicable I think to custom fields defined per queue (even if some exist in multiple queues)? Apologies in advance if I've overlooked something obvious; 95% of the functionality seems to already exist, it's just that last step to make the defined query the default that remains! There isn't a per-queue default format. You *can* just show all the CFs in the global format and they'll stay blank for queues where the CF isn't applied. -kevin pgpgfLdOJwYju.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Wed, Nov 02, 2011 at 08:44:23AM +0100, Nehmer Torben wrote: Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Were you actually using gpg, or did you just have the perl modules installed and that was enough to cause segfaults? -kevin pgpztHOTG8d5H.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] showing requestor's info on the ticket
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'd like to have info about the requestor on the ticket display page - things like telephone number, e-mail, etc. I've read there is a Requestor Info Box, but I can't find much about it. Is it an option for what I'm trying to achieve - or is there any other best practice to follow? Thanks, Giuseppe - -- 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/ iQEcBAEBAgAGBQJOsWN+AAoJEAqigArPBfJXM00H+we/DnD1NwP+2al25Bmqp2eY 0WQs9XA+AKaL4aYGLmnHZQ5Y3WJRDlSHhHA792jck8f6dfG2BE/0RLbToQSMaeKm /D/SuxHykH4AkXkWU1KhHDzECglqcuJ7vwYlX14CWfuc9R+CFaqm0OeUo5ygEjhU bELMSqzC3ls2ONpRSGi7M/BN+o88T2gBqhAieYZyWtlJRWevPPYOgAAxHiSh25aF B7GHSkDq+kmqQwnIstJe6B21QXDzt02CVKyjwmc9kVOj2LGZIrSRYdVUc9VY8uHd eQAYzUCf8qc/yo719W6dxFOQCNebIcYAyPBDeEzmwhJOts6k+WT08bLL3Yq/qT8= =bTe9 -END PGP SIGNATURE- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] showing requestor's info on the ticket
On Wed, Nov 02, 2011 at 03:36:31PM +, Giuseppe Sollazzo wrote: I'd like to have info about the requestor on the ticket display page - things like telephone number, e-mail, etc. I've read there is a Requestor Info Box, but I can't find much about it. Is it an option for what I'm trying to achieve - or is there any other best practice to follow? Start with $ grep MoreAbout etc/RT_Config.pm =item C$ShowMoreAboutPrivilegedUsers Set($ShowMoreAboutPrivilegedUsers, 0); =item C$MoreAboutRequestorTicketList Set($MoreAboutRequestorTicketList, Active); =item C$MoreAboutRequestorExtraInfo Set($MoreAboutRequestorExtraInfo, ); =item C$MoreAboutRequestorGroupsLimit Set($MoreAboutRequestorGroupsLimit, 0); 4.0.3rc1 includes improved documentation for MoreAboutRequestorExtraInfo -kevin pgp96BmS4b1I6.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On 11/02/2011 7:54 AM, Kevin Falcone wrote: On Wed, Nov 02, 2011 at 08:44:23AM +0100, Nehmer Torben wrote: Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Were you actually using gpg, or did you just have the perl modules installed and that was enough to cause segfaults? -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain --- November 28 29, 2011 We currently have the the pgp modules installed (tho we're not using them yet) and have no problems. We're also running: ubuntu system 11.10 apache 2.2.20 gnupg 1.4.11 perl/perl-mods 5.12.4 We've been running 4.0.2 for some time, however we had a noticeable performance increase when we upgraded from 10.10 server. I dont remember what versions of the mentioned software was when we upgraded. Hope my two cents help, Matt RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Wed, Nov 2, 2011 at 1:44 AM, Nehmer Torben torben.neh...@cancom.de wrote: Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Thanks a lot for the answer, this solves the problem. I just ran ./configure again without --enable-gpg and then make install. Since I'm not actually using GPG this will do it. As a side note the GPG modules are still installed on the system, so disabling the functionality in the configure script is enough to fix this issue. -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Wed, Nov 02, 2011 at 10:13:40AM -0600, Carlos Ramos wrote: On Wed, Nov 2, 2011 at 1:44 AM, Nehmer Torben torben.neh...@cancom.de wrote: Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Thanks a lot for the answer, this solves the problem. I just ran ./configure again without --enable-gpg and then make install. Since I'm not actually using GPG this will do it. As a side note the GPG modules are still installed on the system, so disabling the functionality in the configure script is enough to fix this issue. Unless you added Enable = 0 to your config, I'm not entirely sure how that would fix it. By default, RT installs with it enabled and then disables it at runtime. Did you rerun with --disable-gpg or did you just leave off --enable-gpg -kevin pgpsKAmcQjfKO.pgp Description: PGP signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
On Wed, Nov 2, 2011 at 10:58 AM, Kevin Falcone falc...@bestpractical.com wrote: On Wed, Nov 02, 2011 at 10:13:40AM -0600, Carlos Ramos wrote: On Wed, Nov 2, 2011 at 1:44 AM, Nehmer Torben torben.neh...@cancom.de wrote: Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Thanks a lot for the answer, this solves the problem. I just ran ./configure again without --enable-gpg and then make install. Since I'm not actually using GPG this will do it. As a side note the GPG modules are still installed on the system, so disabling the functionality in the configure script is enough to fix this issue. Unless you added Enable = 0 to your config, I'm not entirely sure how that would fix it. By default, RT installs with it enabled and then disables it at runtime. Did you rerun with --disable-gpg or did you just leave off --enable-gpg -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 This was the configure script I was using: ./configure --enable-graphviz --enable-gd --enable-gpg --with-web-user=www-data --with-web-group=www-data --with-db-type=Pg --with-web-handler=modperl2 All I did was change it to: ./configure --enable-graphviz --enable-gd --with-web-user=www-data --with-web-group=www-data --with-db-type=Pg --with-web-handler=modperl2 and the problem disappeared. As per the configure script help: --enable-gpgTurns on GNU Privacy Guard (GPG) support it does not look like it's on by default so by not providing --enable-gpg should turn gpg off. But if indeed is on by default and I have to use --disable-gpg to disable it, then I have no idea why the problem went away, maybe it will reappear later. I would hate that. -- Carlos Ramos RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] Native FullText Search in mysql
Hey folks, Looks like MySQL has FTS built in : http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html Is this supported by RT 4.0x? Thanks! RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Native FullText Search in mysql
Never mind... looks likt it's MyISAM only :( On Wed, Nov 2, 2011 at 11:59 AM, Ram Moskovitz ram0...@gmail.com wrote: Hey folks, Looks like MySQL has FTS built in : http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html Is this supported by RT 4.0x? Thanks! RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] Can I grant GroupA privilege to reset passwords for GroupB?
Hi, I have RT 3.8.4. One of the groups has asked me if a few members could be given the privilege to reset passwords for all the members in the group. Thus far in my reading, I have not been able to find a way to do this. Only thing I have found is the http://search.cpan.org/dist/RT-Extension-ResetPassword/. By the way, we are currently using RT's internal authentication, (no external auth). Thanks for any pointers or suggestions. Best regards, Brian smime.p7s Description: S/MIME cryptographic signature RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Native FullText Search in mysql
On Wed, 2011-11-02 at 11:59 -0700, Ram Moskovitz wrote: Hey folks, Looks like MySQL has FTS built in : http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html Is this supported by RT 4.0x? No. That fulltext indexing is only on MyISAM tables, which are not used in RT because they lack transaction isolation. RT 4 only supports fulltext indexing on mysql using the external Sphinx engine, until InnoDB fulltext indexing is integrated into mysql. There is ongoing work on this support (see [1], [2]) but it isn't in a released version yet. - Alex [1] http://blogs.innodb.com/wp/2011/07/overview-and-getting-started-with-innodb-fts/ [2] http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/ RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Native FullText Search in mysql
On Wed, Nov 02, 2011 at 11:59:40AM -0700, Ram Moskovitz wrote: Hey folks, Looks like MySQL has FTS built in : http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html Is this supported by RT 4.0x? Thanks! No quite, I believe. Oracle just announced InnoDB fulltext search vailability in a preview release of MySQL 5.6. Version 5.5 only supports fulltext-search with MYISM tables, and not with InnoDB tables which are used by RT. So maybe next year... fingers crossed. Regards, Ken RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] Rights question
To List, What is the difference between ModifyScrips and ExecuteCode? The wording for ExecuteCode says it allows the writing of perl code, but I thought that's what ModifyScrips did. Kenn RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] Custom per queue views
Thanks for the response! I've just implemented the below for a few of the more common fields, however, there's still several custom fields that are very queue specific so if implemented as below it will result in the Queue Summary being full of empty fields for queues where that custom field is not defined. I do think this would be a fantastic capability for RT in being able to define a default view based off the Query Builder. In the mean time, are there perhaps any callbacks that could be taken advantage of to emulate such a capability? I've taken a look but haven't found any that seemed to be a sensible match for what I'm trying to achieve. Thanks again for the advice. Kind regards, Samuel Leslie On 3 November 2011 01:54, Kevin Falcone falc...@bestpractical.com wrote: On Wed, Nov 02, 2011 at 03:16:14PM +1100, Samuel Leslie wrote: Does RT provide a mechanism to do this? I know that I can define search critera, sorting and displayed columns in the Query Builder and save the query, but I can't find a way to set a given saved query as the default for a queue. I can also see an option to configure the custom fields displayed in all queues: $DefaultSearchResultFormat; but this isn't really applicable I think to custom fields defined per queue (even if some exist in multiple queues)? Apologies in advance if I've overlooked something obvious; 95% of the functionality seems to already exist, it's just that last step to make the defined query the default that remains! There isn't a per-queue default format. You *can* just show all the CFs in the global format and they'll stay blank for queues where the CF isn't applied. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain — November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011