Re: [rt-users] RT - Oracle db authentication as secondary methode
Hi Thomas, thanks for the reply, I have removed all that MY_Oracle from the config file and its works. But when I go to select users it dont list database only users (I can see all the LDAP users) 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT second instance
On Mon, 2011-06-20 at 05:36 +0300, kobo...@udvarhely.net wrote: [snip] So, it's a bug, mod_perl limitation or i'm missing something? It's a mod_perl limitation; if you want to tun more than one RT instance in an Apache instance, run them under fastcgi. - Alex 2011 Training: http://bestpractical.com/services/training.html
[rt-users] logged out when requesting a ticket page
Hi all, I upgraded an rt4 system manually for testing reason and imported a database from an 3.8.8 installation. Apart from the DB and the RT_SiteConfig.pm no changes/customizations have been done yet. I use Apache and mod_perl with the simple config: VirtualHost rt2.abc.de ### Optional apache logs for RT ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access LogLevel debug AddDefaultCharset UTF-8 DocumentRoot /opt/rt4/share/html Alias /NoAuth/Images/ /opt/rt4/share/html/NoAuth/images/ 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 After logging in I can access all pages (e.g. http://rt2.abc.de/Search/Simple.html) apart from ticket pages. The ticket pages have a URL like http://rt2.abc.de/rt/Ticket/Display.html?id=17274, with /rt as a first directory. When requesting a ticket page I'm kicked out and have to log in again with a session ID in the URL like http://rt2.abc.de/NoAuth/Login.html?next=becffd2d0918f5b194bfa32b686bd851. When trying to login on that page I receive a new login page with a new session ID. Any hints what I missed? Best regards, David 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT second instance
On Mon, Jun 20, 2011 at 05:36:07AM +0300, kobo...@udvarhely.net wrote: Hello, I installed a RT 4 under the standard /opt/rt4, with mysql database : rt4db, and rt4user/password mysql privileges. In apache is configured as virtualhost with mod_perl (2.0.4). Working great. Now i wanted to add a second install under /opt/rtsecond , with different db etc (rtseconddb, rtseconduser etc), so i did a new configure/make install/initd. I configured as a second virtualhost in apache under its own subdomain, restarted apache, tried to login and to my suprise default root/password didn't work. After a bit of troubleshooting i realised that RT is trying to connect to the first db, with the first user ( adding quey loging to mysql shows clearly Connect rt4user@localhost on rt4db ; and not Connect rtseconduser on rtseconddb). Then i did triple check everything, but everything seems right (grep -r rt4 /opt/rtsecond matches only Readme files , or perldoc part from .pm files; so config is good; also second virtualhost definition is corretly reffering /opt/rtsecond and not /opt/rt4) Of course if i remove the first virtualhost; or if i start the first via apache and second with rt_server on different port , then works. So, it's a bug, mod_perl limitation or i'm missing something? Thanks, Sandor Marton Did you take a look at the wiki? http://requesttracker.wikia.com/wiki/MultipleInstances Cheers, Ken 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] logged out when requesting a ticket page
On Mon, Jun 20, 2011 at 12:50:13PM +, Obando, David DE - EV wrote: Hi all, I upgraded an rt4 system manually for testing reason and imported a database from an 3.8.8 installation. Apart from the DB and the RT_SiteConfig.pm no changes/customizations have been done yet. After logging in I can access all pages (e.g. [1]http://rt2.abc.de/Search/Simple.html) apart from ticket pages. The ticket pages have a URL like [2]http://rt2.abc.de/rt/Ticket/Display.html?id=17274, with /rt as a first directory. When requesting a ticket page I'm kicked out and have to log in again with a session ID in the URL like [3]http://rt2.abc.de/NoAuth/Login.html?next=becffd2d0918f5b194bfa32b686bd851. When trying to login on that page I receive a new login page with a new session ID. How are you getting to the Ticket page? Did you have WebPath set in your 3.8 install? Did you have a customized search format? Please provide your sanitized RT_SiteConfig.pm -kevin pgph9mFNoOqDb.pgp Description: PGP signature 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT4 rt-server fcgi
On Sat, Jun 18, 2011 at 10:07:19AM +0400, Vitaly Tskhovrebov wrote: Hello. I'm using RT4. While it's clear how to run it with nginx, it's still not clear for me, is there an init script for rt-server to put it to appropriate runlevel? I believe you're asking if there is an init script to start the external fcgi server? We don't include one. -kevin pgpy3oDxDVtze.pgp Description: PGP signature 2011 Training: http://bestpractical.com/services/training.html
[rt-users] RT::Extension::Nagios
Hi all, I'm trying to get RT::Extension::Nagios to work but I'm stuck and I can't totally understand why as there's nothing in the logs. My RT_SiteConfig.pm looks like this in the relevant bits: Set( @Plugins, qw(RT::Authen::ExternalAuth RT::Extension::LDAPImport RT::Extension::Nagios)); Set($NagiosSearchAllQueues, 0); # true Set($NagiosMergeTickets, 1); # merged to the newest ticket. As far as I understand this should be enough. Now, the regexp that is matched against the subject is (PROBLEM|RECOVERY|ACKNOWLEDGEMENT)\s+(Service|Host) Alert: ([^/]+)/?(.*)\s+is\s+(\w+) and as far as I can understand the match is made only over the subject line (i.e. PROBLEM of a given host/service is matched with RECOVERY or ACKNOWLEDGEMENT of the same host/service). I've tried issuing two e-mails with subjects PROBLEM Service Alert: sambaserver/sambaserver_root is WARNING PROBLEM Service Alert: sambaserver/sambaserver_root is OK but no automatic closure/merge happened. As I said, there's no mention in the logs. How can I understand what's going on? 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 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT::Extension::Nagios
On Mon, Jun 20, 2011 at 03:31:07PM +0100, Giuseppe Sollazzo wrote: Hi all, I'm trying to get RT::Extension::Nagios to work but I'm stuck and I can't totally understand why as there's nothing in the logs. My RT_SiteConfig.pm looks like this in the relevant bits: Set( @Plugins, qw(RT::Authen::ExternalAuth RT::Extension::LDAPImport RT::Extension::Nagios)); Set($NagiosSearchAllQueues, 0); # true Set($NagiosMergeTickets, 1); # merged to the newest ticket. As far as I understand this should be enough. Now, the regexp that is matched against the subject is (PROBLEM|RECOVERY|ACKNOWLEDGEMENT)\s+(Service|Host) Alert: ([^/]+)/?(.*)\s+is\s+(\w+) and as far as I can understand the match is made only over the subject line (i.e. PROBLEM of a given host/service is matched with RECOVERY or ACKNOWLEDGEMENT of the same host/service). I've tried issuing two e-mails with subjects PROBLEM Service Alert: sambaserver/sambaserver_root is WARNING PROBLEM Service Alert: sambaserver/sambaserver_root is OK but no automatic closure/merge happened. As I said, there's no mention in the logs. How can I understand what's going on? Did you run make initdb? Do you have the On Create Update Nagios Tickets scrip? That scrip will log if it matches in the subject. -kevin pgpZBGUSqT6MQ.pgp Description: PGP signature 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT::Extension::Nagios
Did you run make initdb? Do you have the On Create Update Nagios Tickets scrip? That scrip will log if it matches in the subject. Hi Kevin, thanks - I haven't. I can't find such info in the readme/wiki. Is there any example anywhere else? So basically, 1) There's no update nagios option in the scrip, or such scrip at all, so I suppose this is because I didn't run the make initdb 2) make initdb in which makefile? (I installed the extension via cpan, if that makes any difference). Thanks, Giuseppe Attached Message Part Description: PGP signature 2011 Training: http://bestpractical.com/services/training.html 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT::Extension::Nagios
On Mon, Jun 20, 2011 at 03:53:23PM +0100, Giuseppe Sollazzo wrote: Did you run make initdb? Do you have the On Create Update Nagios Tickets scrip? That scrip will log if it matches in the subject. Hi Kevin, thanks - I haven't. I can't find such info in the readme/wiki. Is there any example anywhere else? Step 4 of the README included in the extension covers this. http://cpansearch.perl.org/src/SUNNAVY/RT-Extension-Nagios-0.06/README -kevin So basically, 1) There's no update nagios option in the scrip, or such scrip at all, so I suppose this is because I didn't run the make initdb 2) make initdb in which makefile? (I installed the extension via cpan, if that makes any difference). Thanks, Giuseppe pgpm3f2u0mIHM.pgp Description: PGP signature 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT::Extension::Nagios
Ok - so I assume there's no way of having this to work when installed via cpan? G On 20/06/11 16:11, Kevin Falcone wrote: On Mon, Jun 20, 2011 at 03:53:23PM +0100, Giuseppe Sollazzo wrote: Did you run make initdb? Do you have the On Create Update Nagios Tickets scrip? That scrip will log if it matches in the subject. Hi Kevin, thanks - I haven't. I can't find such info in the readme/wiki. Is there any example anywhere else? Step 4 of the README included in the extension covers this. http://cpansearch.perl.org/src/SUNNAVY/RT-Extension-Nagios-0.06/README -kevin So basically, 1) There's no update nagios option in the scrip, or such scrip at all, so I suppose this is because I didn't run the make initdb 2) make initdb in which makefile? (I installed the extension via cpan, if that makes any difference). Thanks, Giuseppe 2011 Training: http://bestpractical.com/services/training.html -- 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 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT::Authen::ExternalAuth?
So RT 3.8.10 is working swimmingly well except for one possible post upgrade snag - two users (out of 100+) reported that after RT was restarted they were logged in as someone else. Any ideas? On Tue, 2011-06-14 at 15:17 -0400, Kevin Falcone wrote: On Tue, Jun 14, 2011 at 02:50:24PM -0400, Joshua Knarr wrote: Kevin - We gave up on RT 4. RTFM is not the answer. The problem is threefold: Oh, now that I reread your original thread I see. You didn't run any database upgrades between 3.4.5 and 4.0.0 other than those described in UPGRADING.mysql. That's going to cause you problems on 3.8.10 also. -kevin -- Joshua Knarr Systems Engineer GSI Commerce, Inc. http://www.gsicommerce.com E-Mail: kna...@gsicommerce.com Office: 610-491-7110 Mobile: 484-636-7371 The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of GSI Commerce, Inc. or its subsidiaries and/or affiliates. 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] AdminCC and requestor mailings
Vitaly, Sorry for the typo. This is the code we use: Condition: User Defined Action: Notify AdminCcs Template: Global template: Admin Correspond Stage: TransactionBatch Custom Condition Code: # Set initial values my $trans = $self-TransactionObj; my $ticket = $self-TicketObj; my $queue = $ticket-QueueObj; my $requestor = $ticket-Requestors-UserMembersObj-First-PrincipalId; # Get out now if the requestor or owner is an AdminCc if ($queue-AdminCc-HasMember($requestor)) { return 0; } # Get out now if the transaction is NOT a Correspond return ($trans-Type eq Correspond); return 0; Hope this helps. Kenn LBNL On Mon, Jun 20, 2011 at 9:33 AM, Kenneth Crocker kfcroc...@lbl.gov wrote: Vitaly, I believe you are referring to duplicate emails when the Requesdtor is also an AdminCc. Yes, I ran into that problem myself and just modifed the scrip to ignore those cases. The code is below: Condition: User Defined Action: Notify AdminCcs Template: Global template: Admin Correspond Stage: TransactionBatch Custom Condition Code # Set initial values my $trans = $self-TransactionObj; my $ticket = $self-TicketObj; my $queue = $ticket-QueueObj; my $qname = substr($queue-Name, 0, 3); my $owner = $ticket-OwnerObj-PrincipalId; my $requestor = $ticket-Requestors-UserMembersObj-First-PrincipalId; # Get out now if the requestor or owner is an AdminCc if ($queue-AdminCc-HasMember($requestor)) { return 0; } # Get out now if the transaction is NOT a Correspond return 0 unless ($trans-Type eq Correspond); Hope this helps. Kenn LBNL return 0; On Fri, Jun 17, 2011 at 11:05 PM, Vitaly Tskhovrebov v...@chgk.info wrote: Hello. I'm using group for AdminCC the queue. Eventually, member of AdminCC created ticket, so he became requester. When owner of ticket reply him, requestor receives duplicate email notification: one for requestor, and the same for AdminCC. Is there any way to get rid of duplicate emails? RT4. -- Regards, Vitaly Tskhovrebov Senior System Administrator U.S. +1 (206) 905-9939 Russia +7 911 094-2035 2011 Training: http://bestpractical.com/**services/training.htmlhttp://bestpractical.com/services/training.html 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] AdminCC and requestor mailings
Thank you very much! I salute you, sir. On 6/20/2011 8:40 PM, Kenneth Crocker wrote: Sorry for the typo. This is the code we use: -- Regards, Vitaly Tskhovrebov Senior System Administrator U.S. +1 (206) 905-9939 Russia +7 911 094-2035 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] RT4 rt-server fcgi
On 6/20/2011 6:16 PM, Kevin Falcone wrote: external fcgi server? We don't include one. Thanks, Kevin. Why not? :-) I do understand it's maintainers' job to do so for OS they are responsible, but I'd like to have some reference script at last. -- Regards, Vitaly Tskhovrebov Senior System Administrator U.S. +1 (206) 905-9939 Russia +7 911 094-2035 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] Blacklist and Bugzilla
On Mon, 13 Jun 2011 10:48:15 +0100, k...@midnighthax.com said: The question, in case it's lost in the history, is why is the address being blacklisted (or how can I find out why the address is being blacklisted or, ultimately, how can I stop it being blacklisted). Any chance of a pointer to being able to answer this? Thanks, Keith -- You can have everything in life you want if you help enough other people get what they want - Zig Ziglar. Who did you help today? 2011 Training: http://bestpractical.com/services/training.html
Re: [rt-users] Blacklist and Bugzilla
On Mon, Jun 13, 2011 at 10:48:15AM +0100, Keith Edmunds wrote: You should probably include a full log, rather than cherry picked parts of it. Fair comment. Here's the full log of a new ticket, up to the time when the 'blacklisted' message appears. I've put blank lines between each line to reduce the confusion from wrapping. You still seem to have trimmed some, since 9 scrips are identified. [Thu Jun 9 11:33:34 2011] [info]: rt-3.8.8-6748-1307619214-28.7387-29-0@[COMPANY].co.uk bugzilla-internal@[REDACTED] was blacklisted for outbound mail on this transaction. Skipping (/usr/share/request-tracker3.8/lib/RT/Action/SendEmail.pm:828) What is scrip 29? -kevin pgpMSIa6Im6yO.pgp Description: PGP signature 2011 Training: http://bestpractical.com/services/training.html
[rt-users] RT error “Couldn't load user ''
Hi I have installed RT4 and when I try to create a user I am getting an error RT error “Couldn't load user '' I read in one of your mailing list replies saying that user was got over this issue by removing Authen::ExternalAuth from plugging. But in my case I am unable to do so since AD authentication is my primary method of authentication. http://lists.fsck.com/pipermail/rt-users/2009-December/062628.html I don’t want RT to create users in AD but to create new users in oracle DB Can someone tell me how to get over this problem? Thanks regards 2011 Training: http://bestpractical.com/services/training.html