Re: [rt-users] Promoting a user who was autocreated to real user status...
Finally, a question I can answer... In Users, search for annie make sure to include disabled users, otherwise her name won't show up. select her name, and check the box grant this user rights.. Then go ahead and work your magic on the rest of her permissions. Mike Jason Marshall jas...@kelman.com 3/4/2011 12:55 AM Maybe it's just late and I'm having brain fade, but Google is failing me right now. Maybe what I hope to do is impossible, though it seems like something people would want to do. I've got a user, let's call her Annie. She has submitted tickets via email to at least one queue, so she has an account in the Users table. Now I'm setting up another queue which I need her to have privileges in. I tried to create an annie account the manual way, and it says her email address is already in use, which is of course quite true. So how do I now promote her so I can grant her some rights? For now I just created an account with an alternate email address, but I can see this coming up a lot. Again, my apologies if this is incredibly obvious. I find that quite a few simple things in RT3 confound me, so this is just another one to add to the list if that's the case. But I still think it's pretty awesome. Thanks in advance! PS. I'm using v3.8.8 if it matters. --- Jason Marshall, IT Manager, Kelman Technologies, Inc., Calgary, AB, Canada. From a Sun Microsystems bug report (#4102680): Workaround: don't pound on the mouse like a wild monkey. I have great faith in fools: Self confidence my friends call it. -Edgar Allan Poe The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer.
[rt-users] Database error
Hi, running rt 3.8.8 with our database which was upgraded from 3.6.4. On some tickets - I've identified 4 or 5 out of ~7800 - I get the following error. The ticket headers are displayed but the history is not. Can't call method Id on an undefined value at /opt/rt3/local/plugins/RT-FM/lib/RT/URI/fsck_com_rtfm.pm line 133. Any thoughts? Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Database error
Yes, very early on we did change the $Organization. I think it was prior to 3.6.4. I'm pretty sure the links still worked when we moved to 3.6.4, but they definitely don't work in 3.8.8. Is there a fix? Mike Kevin Falcone falc...@bestpractical.com 10/4/2010 3:29 PM On Mon, Oct 04, 2010 at 01:19:12PM -0400, Michael James wrote: Hi, running rt 3.8.8 with our database which was upgraded from 3.6.4. On some tickets - I've identified 4 or 5 out of ~7800 - I get the following error. The ticket headers are displayed but the history is not. Can't call method Id on an undefined value at /opt/rt3/local/plugins/RT-FM/lib/RT/URI/fsck_com_rtfm.pm line 133. This implies you changed your $Organization between 3.6.4 and 3.8.8 and the RTFM links to tickets broke. -kevin The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT!
Re: [rt-users] Warning - perl idiot here
Thanks, Robert. Permissions on RT_Config.pm were set at 550 with root as owner. I chmod'd them to 444 per your suggestion, and it worked. I had read the man page for perldoc, but didn't catch on. btw, when I now run perldoc /opt/rt3/etc/RT_Config.pm, I get three syntax errors: tracker:~ # perldoc /opt/rt3/etc/RT_Config.pm /opt/rt3/etc/RT_Config.pm:443: Unmatched =back /opt/rt3/etc/RT_Config.pm:459: Unmatched =back /opt/rt3/etc/RT_Config.pm:471: Unmatched =back Again, thanks! Mike Robert Grasso robert.grasso...@cedrat.com 7/30/2010 11:25 AM Hi, My rights on /opt/rt3/etc/RT_Config.pm are 440 (should be the stock ones); now, from man perldoc : SECURITY Because perldoc does not run properly tainted, and is known to have security issues, when run as the superuser it will attempt to drop privileges by setting the effective and real IDs to nobody’s or nouser’s account, or -2 if unavailable. If it cannot relinquish its privileges, it will not run. If I chmod 444 /opt/rt3/etc/RT_Config.pm, then perldoc (running as root) is able to display it, whereas before it failed as yours did. Hope this helps --- Robert GRASSO – System engineer CEDRAT S.A. 15 Chemin de Malacher - Inovallée - 38246 MEYLAN cedex - FRANCE Phone: +33 (0)4 76 90 50 45 - Fax: +33 (0)4 56 38 08 30 mailto:robert.gra...@cedrat.com - http://www.cedrat.com -Message d'origine- De : rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] De la part de Michael James Envoyé : 29 juillet 2010 21:26 Cc : RT Users Objet : Re: [rt-users] Warning - perl idiot here Returns nothing. Ah well, I'll just read the darned file and skip over the pod formatting. Thanks for the suggestion. Mike tracker:~ # perldoc -F /opt/rt3/etc/RT_Config.pm tracker:~ # Todd Chapman t...@chaka.net 7/29/2010 3:06 PM Try: perldoc -F On Thu, Jul 29, 2010 at 1:55 PM, Michael James mja...@stonebridgebank.com wrote: How come I can't view the documentation with RT_Config.pm using perldoc? tracker:~ # perldoc /opt/rt3/etc/RT_Config.pm Can't open /opt/rt3/etc/RT_Config.pm: Permission denied at /usr/lib/perl5/5.8.8/Pod/Perldoc.pm line 1380. Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Approvals not working - and why won't Quick Search work?
It still seems to me that a straightforward SQL search should work... no matter
how the ticket was created, although my goal is to get approvals working. I
will enable the default queue and work with that for now.
Mike
Michael James mja...@stonebridgebank.com 7/29/2010 4:43 PM
I queried the rt3 MySQL database to see what I could see vis-a-vis the approval
process. In points 1, 2, 3, and 4, I'm building a case to prove I'm not crazy.
If you can explain the results of Quick search in #5, I would be highly
appreciative!
1. SELECT * FROM `rt3`.`Queues` where Name = 'ChangeApproval'
1 row fetched: 22, 'ChangeApproval', 'Queue to hold templates for Change Mgmt
approval', '', '', 0, 0, 0, 28, '2007-01-04 19:42:12', 28, '2007-01-04
19:42:12', 0
2. SELECT * FROM `rt3`.`Tickets` where Queue = '22'
19 rows fetched. Here are some columns of data. Sorry I can't show all.
id EffectiveId Status
11571157new
28492849new
74587458new
74617461new
74647464new
74667466new
820 820 resolved
822 822 resolved
824 824 resolved
26572657resolved
28512851resolved
28762876resolved
28782878resolved
28802880resolved
28822882resolved
28842884resolved
28862886resolved
28882888resolved
29172917resolved
3. Now, note the headers below for ticket #7461, which confirms Queue =
ChangeApproval.
Wed Jul 28 13:59:08 2010: Request 7461 was acted upon.
Transaction: Ticket created by RT_System
Queue: ChangeApproval
Subject: Approve Change Request for another test
Owner: Nobody
Requestors:
Status: new
Ticket URL: http://tracker.stonebridgebank.com/rt/Ticket/Display.html?id=7461
Someone has created a Change Request. Please review.
4. SELECT * FROM `rt3`.`Tickets` where id = '7461'
id EffectiveId Queue Type
7461746122 approval
5. From my RT at a Glance page, when I click on the quick search for
ChangeApproval queue - returns 0 hits.
http://tracker.stonebridgebank.com/rt/Search/Results.html?Query=Queue =
'ChangeApproval' AND (Status = 'new' OR Status = 'open' OR Status = 'stalled')
Why don't any of the approvals with status=new show in the results screen? Any
ideas what is going on here?
Mike
Michael James mja...@stonebridgebank.com 7/28/2010 4:57 PM
It worked on 3.4.6, which is the version we were using before 3.8.8.
Foggi, Nicola nfo...@depaul.edu 7/28/2010 4:48 PM
I was never able to get a queue working with approvals other than the default
__Approvals queue, if you use that does it work?
Nicola
-Original Message-
From: rt-users-boun...@lists.bestpractical.com on behalf of Michael James
Sent: Wed 7/28/2010 3:38 PM
To: RT Users rt-users@lists.bestpractical.com
Subject: [rt-users] Approvals not working
Hi, I used example code on the wiki to create a PO-Request type approval in
RT3.8.8 http://wiki.bestpractical.com/view/ApprovalCreation The process creates
new ticket(s) but isn't quite right yet.
I created 2 queues: ChangeRequest and ChangeApproval and both are enabled.
ChangeRequest queue has 1 scrip:
On Create, Create Tickets with template CreateApproval, stage
TransactionCreate. with no User defined conditions.
The CreateApproval template is pretty much cut-n-paste from the wiki:
===Create-Ticket: poreq
Subject: Approve Change Request for {$Tickets{'TOP'}-Subject}
Depended-On-By: TOP
Queue: ChangeApproval
Type: approval
Owner: username-of-owner #note this is so that notifications work properly
Content: Someone has created a Change Request. Please review.
ENDOFCONTENT
For the ChangeApproval queue, I copied/pasted all of the scrips and templates
from the default __Approvals queue.
When I create a new ticket in the ChangeRequest queue, a 2nd ticket is created
and notifications are sent to the watchers that a new ticket is awaiting
approval. However, the approvals don't show up in My Approvals. Nor do they
show up in the ChangeApproval queue when I search for them. The
tickets/approvals exist, I can see them in the Tickets table with type=approval.
I can't sort out what I've done wrong. Any ideas?
Mike
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy
Re: [rt-users] Warning - perl idiot here
Agreed, I don't get those errors on 3.8.7, but I do see them in 3.8.8. I have both versions running for different departments. RT 3.8.8 SLES 10 SP3 tracker:~ # perldoc -V Perldoc v3.14, under perl v5.008008 for linux Thanks again. Robert Grasso robert.grasso...@cedrat.com 7/30/2010 12:40 PM tracker:~ # perldoc /opt/rt3/etc/RT_Config.pm /opt/rt3/etc/RT_Config.pm:443: Unmatched =back /opt/rt3/etc/RT_Config.pm:459: Unmatched =back /opt/rt3/etc/RT_Config.pm:471: Unmatched =back I don't get these errors : we must not be using the same versions : I am running RT v3.8.7 on CentOS 5.5 and [r...@vicen02 ~]# perldoc -V Perldoc v3.14, under perl v5.008008 for linux Again, thanks! You are welcome ! --- Robert GRASSO System Engineer CEDRAT 15, Chemin de Malacher - Inovallée - 38246 MEYLAN Cedex - FRANCE Tel: +33 (0)4 76 90 50 45 Fax: +33 (0)4 76 90 16 09 mailto:robert.gra...@cedrat.com --- Support service : mailto:supp...@cedrat.com Commercial service : mailto:ced...@cedrat.com Web site : http://www.cedrat.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Approvals not working - and why won't Quick Search work?
Thanks, Kevin. Okay, I now see that approval != ticket and that's why the quick
search wouldn't work. Still can't see the approvals on the Approval page,
however. I will enable __Approvals and see about getting things to work from
there.
Mike
Kevin Falcone falc...@bestpractical.com 7/30/2010 12:48 PM
On Fri, Jul 30, 2010 at 11:44:15AM -0400, Michael James wrote:
It still seems to me that a straightforward SQL search should work... no
matter how the ticket was created, although my goal is to get approvals
working. I will enable the default queue and work with that for now.
you really should try to work within __Approvals, especially if your
Template is going to create Type = 'approval'
Tickets have a different Type
I suggest that in your select * from rt3.Tickets you also examine the
Type column. Normal ticket searches in the RT web ui are never going
to show non-ticket tickets
-kevin
Mike
Michael James mja...@stonebridgebank.com 7/29/2010 4:43 PM
I queried the rt3 MySQL database to see what I could see vis-a-vis the
approval process. In points 1, 2, 3, and 4, I'm building a case to prove I'm
not crazy. If you can explain the results of Quick search in #5, I would be
highly appreciative!
1. SELECT * FROM `rt3`.`Queues` where Name = 'ChangeApproval'
1 row fetched: 22, 'ChangeApproval', 'Queue to hold templates for Change Mgmt
approval', '', '', 0, 0, 0, 28, '2007-01-04 19:42:12', 28, '2007-01-04
19:42:12', 0
2. SELECT * FROM `rt3`.`Tickets` where Queue = '22'
19 rows fetched. Here are some columns of data. Sorry I can't show all.
idEffectiveId Status
1157 1157new
2849 2849new
7458 7458new
7461 7461new
7464 7464new
7466 7466new
820 820 resolved
822 822 resolved
824 824 resolved
2657 2657resolved
2851 2851resolved
2876 2876resolved
2878 2878resolved
2880 2880resolved
2882 2882resolved
2884 2884resolved
2886 2886resolved
2888 2888resolved
2917 2917resolved
3. Now, note the headers below for ticket #7461, which confirms Queue =
ChangeApproval.
Wed Jul 28 13:59:08 2010: Request 7461 was acted upon.
Transaction: Ticket created by RT_System
Queue: ChangeApproval
Subject: Approve Change Request for another test
Owner: Nobody
Requestors:
Status: new
Ticket URL:
http://tracker.stonebridgebank.com/rt/Ticket/Display.html?id=7461
Someone has created a Change Request. Please review.
4. SELECT * FROM `rt3`.`Tickets` where id = '7461'
idEffectiveId Queue Type
7461 746122 approval
5. From my RT at a Glance page, when I click on the quick search for
ChangeApproval queue - returns 0 hits.
http://tracker.stonebridgebank.com/rt/Search/Results.html?Query=Queue =
'ChangeApproval' AND (Status = 'new' OR Status = 'open' OR Status = 'stalled')
Why don't any of the approvals with status=new show in the results screen?
Any ideas what is going on here?
Mike
Michael James mja...@stonebridgebank.com 7/28/2010 4:57 PM
It worked on 3.4.6, which is the version we were using before 3.8.8.
Foggi, Nicola nfo...@depaul.edu 7/28/2010 4:48 PM
I was never able to get a queue working with approvals other than the default
__Approvals queue, if you use that does it work?
Nicola
-Original Message-
From: rt-users-boun...@lists.bestpractical.com on behalf of Michael James
Sent: Wed 7/28/2010 3:38 PM
To: RT Users rt-users@lists.bestpractical.com
Subject: [rt-users] Approvals not working
Hi, I used example code on the wiki to create a PO-Request type approval in
RT3.8.8 http://wiki.bestpractical.com/view/ApprovalCreation The process
creates new ticket(s) but isn't quite right yet.
I created 2 queues: ChangeRequest and ChangeApproval and both are enabled.
ChangeRequest queue has 1 scrip:
On Create, Create Tickets with template CreateApproval, stage
TransactionCreate. with no User defined conditions.
The CreateApproval template is pretty much cut-n-paste from the wiki:
===Create-Ticket: poreq
Subject: Approve Change Request for {$Tickets{'TOP'}-Subject}
Depended-On-By: TOP
Queue: ChangeApproval
Type: approval
Owner: username-of-owner #note this is so that notifications work properly
Content: Someone has created a Change Request. Please review.
ENDOFCONTENT
For the ChangeApproval queue, I copied/pasted all of the scrips and templates
from the default __Approvals queue.
When I create a new ticket in the ChangeRequest queue, a 2nd ticket is
created and notifications are sent to the watchers that a new ticket is
awaiting approval. However, the approvals don't show up in My Approvals. Nor
do they show up in the ChangeApproval queue when I search
[rt-users] Warning - perl idiot here
How come I can't view the documentation with RT_Config.pm using perldoc? tracker:~ # perldoc /opt/rt3/etc/RT_Config.pm Can't open /opt/rt3/etc/RT_Config.pm: Permission denied at /usr/lib/perl5/5.8.8/Pod/Perldoc.pm line 1380. Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Warning - perl idiot here
Running SuSE Enterprise Linux 10, SP3. Executing perldoc /opt/rt3/etc/RT_Config.pm as root. The error occurs on line 1380 of /usr/lib/perl5/5.8.8/Pod/Perldoc.pm, which is this: open(TEST,, $file) or die Can't open $file: $!; # XXX 5.6ism So, it doesn't have permission to open a file? I don't follow. Sorry. Mike Michael James mja...@stonebridgebank.com 7/29/2010 1:55 PM How come I can't view the documentation with RT_Config.pm using perldoc? tracker:~ # perldoc /opt/rt3/etc/RT_Config.pm Can't open /opt/rt3/etc/RT_Config.pm: Permission denied at /usr/lib/perl5/5.8.8/Pod/Perldoc.pm line 1380. Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Two RT installations
Definitely do-able. Start with the wiki page on MultipleInstances. Also, figure out how to use NameVirtualHost in Apache. Read all the options for configure and make sure you set up different local-prefixes for each instance. I can give you some working configurations (working in SLES10 anyway). I use postfix/sendmail and it's pretty easy to set up aliases. Mike foram goram foramgo...@yahoo.com 7/26/2010 3:06 PM Hi, Is it possible to have two RT installations on the same server? If yes, how?. Thanks The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Warning - perl idiot here
Returns nothing. Ah well, I'll just read the darned file and skip over the pod formatting. Thanks for the suggestion. Mike tracker:~ # perldoc -F /opt/rt3/etc/RT_Config.pm tracker:~ # Todd Chapman t...@chaka.net 7/29/2010 3:06 PM Try: perldoc -F On Thu, Jul 29, 2010 at 1:55 PM, Michael James mja...@stonebridgebank.com wrote: How come I can't view the documentation with RT_Config.pm using perldoc? tracker:~ # perldoc /opt/rt3/etc/RT_Config.pm Can't open /opt/rt3/etc/RT_Config.pm: Permission denied at /usr/lib/perl5/5.8.8/Pod/Perldoc.pm line 1380. Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Approvals not working
I queried the rt3 MySQL database to see what I could see vis-a-vis the approval
process. In points 1, 2, 3, and 4, I'm building a case to prove I'm not crazy.
If you can explain the results of Quick search in #5, I would be highly
appreciative!
1. SELECT * FROM `rt3`.`Queues` where Name = 'ChangeApproval'
1 row fetched: 22, 'ChangeApproval', 'Queue to hold templates for Change Mgmt
approval', '', '', 0, 0, 0, 28, '2007-01-04 19:42:12', 28, '2007-01-04
19:42:12', 0
2. SELECT * FROM `rt3`.`Tickets` where Queue = '22'
19 rows fetched. Here are some columns of data. Sorry I can't show all.
id EffectiveId Status
11571157new
28492849new
74587458new
74617461new
74647464new
74667466new
820 820 resolved
822 822 resolved
824 824 resolved
26572657resolved
28512851resolved
28762876resolved
28782878resolved
28802880resolved
28822882resolved
28842884resolved
28862886resolved
28882888resolved
29172917resolved
3. Now, note the headers below for ticket #7461, which confirms Queue =
ChangeApproval.
Wed Jul 28 13:59:08 2010: Request 7461 was acted upon.
Transaction: Ticket created by RT_System
Queue: ChangeApproval
Subject: Approve Change Request for another test
Owner: Nobody
Requestors:
Status: new
Ticket URL: http://tracker.stonebridgebank.com/rt/Ticket/Display.html?id=7461
Someone has created a Change Request. Please review.
4. SELECT * FROM `rt3`.`Tickets` where id = '7461'
id EffectiveId Queue Type
7461746122 approval
5. From my RT at a Glance page, when I click on the quick search for
ChangeApproval queue - returns 0 hits.
http://tracker.stonebridgebank.com/rt/Search/Results.html?Query=Queue =
'ChangeApproval' AND (Status = 'new' OR Status = 'open' OR Status = 'stalled')
Why don't any of the approvals with status=new show in the results screen? Any
ideas what is going on here?
Mike
Michael James mja...@stonebridgebank.com 7/28/2010 4:57 PM
It worked on 3.4.6, which is the version we were using before 3.8.8.
Foggi, Nicola nfo...@depaul.edu 7/28/2010 4:48 PM
I was never able to get a queue working with approvals other than the default
__Approvals queue, if you use that does it work?
Nicola
-Original Message-
From: rt-users-boun...@lists.bestpractical.com on behalf of Michael James
Sent: Wed 7/28/2010 3:38 PM
To: RT Users rt-users@lists.bestpractical.com
Subject: [rt-users] Approvals not working
Hi, I used example code on the wiki to create a PO-Request type approval in
RT3.8.8 http://wiki.bestpractical.com/view/ApprovalCreation The process creates
new ticket(s) but isn't quite right yet.
I created 2 queues: ChangeRequest and ChangeApproval and both are enabled.
ChangeRequest queue has 1 scrip:
On Create, Create Tickets with template CreateApproval, stage
TransactionCreate. with no User defined conditions.
The CreateApproval template is pretty much cut-n-paste from the wiki:
===Create-Ticket: poreq
Subject: Approve Change Request for {$Tickets{'TOP'}-Subject}
Depended-On-By: TOP
Queue: ChangeApproval
Type: approval
Owner: username-of-owner #note this is so that notifications work properly
Content: Someone has created a Change Request. Please review.
ENDOFCONTENT
For the ChangeApproval queue, I copied/pasted all of the scrips and templates
from the default __Approvals queue.
When I create a new ticket in the ChangeRequest queue, a 2nd ticket is created
and notifications are sent to the watchers that a new ticket is awaiting
approval. However, the approvals don't show up in My Approvals. Nor do they
show up in the ChangeApproval queue when I search for them. The
tickets/approvals exist, I can see them in the Tickets table with type=approval.
I can't sort out what I've done wrong. Any ideas?
Mike
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Approvals not working
Hi, I used example code on the wiki to create a PO-Request type approval in
RT3.8.8 http://wiki.bestpractical.com/view/ApprovalCreation The process creates
new ticket(s) but isn't quite right yet.
I created 2 queues: ChangeRequest and ChangeApproval and both are enabled.
ChangeRequest queue has 1 scrip:
On Create, Create Tickets with template CreateApproval, stage
TransactionCreate. with no User defined conditions.
The CreateApproval template is pretty much cut-n-paste from the wiki:
===Create-Ticket: poreq
Subject: Approve Change Request for {$Tickets{'TOP'}-Subject}
Depended-On-By: TOP
Queue: ChangeApproval
Type: approval
Owner: username-of-owner #note this is so that notifications work properly
Content: Someone has created a Change Request. Please review.
ENDOFCONTENT
For the ChangeApproval queue, I copied/pasted all of the scrips and templates
from the default __Approvals queue.
When I create a new ticket in the ChangeRequest queue, a 2nd ticket is created
and notifications are sent to the watchers that a new ticket is awaiting
approval. However, the approvals don't show up in My Approvals. Nor do they
show up in the ChangeApproval queue when I search for them. The
tickets/approvals exist, I can see them in the Tickets table with type=approval.
I can't sort out what I've done wrong. Any ideas?
Mike
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Approvals not working
It worked on 3.4.6, which is the version we were using before 3.8.8.
Foggi, Nicola nfo...@depaul.edu 7/28/2010 4:48 PM
I was never able to get a queue working with approvals other than the default
__Approvals queue, if you use that does it work?
Nicola
-Original Message-
From: rt-users-boun...@lists.bestpractical.com on behalf of Michael James
Sent: Wed 7/28/2010 3:38 PM
To: RT Users rt-users@lists.bestpractical.com
Subject: [rt-users] Approvals not working
Hi, I used example code on the wiki to create a PO-Request type approval in
RT3.8.8 http://wiki.bestpractical.com/view/ApprovalCreation The process creates
new ticket(s) but isn't quite right yet.
I created 2 queues: ChangeRequest and ChangeApproval and both are enabled.
ChangeRequest queue has 1 scrip:
On Create, Create Tickets with template CreateApproval, stage
TransactionCreate. with no User defined conditions.
The CreateApproval template is pretty much cut-n-paste from the wiki:
===Create-Ticket: poreq
Subject: Approve Change Request for {$Tickets{'TOP'}-Subject}
Depended-On-By: TOP
Queue: ChangeApproval
Type: approval
Owner: username-of-owner #note this is so that notifications work properly
Content: Someone has created a Change Request. Please review.
ENDOFCONTENT
For the ChangeApproval queue, I copied/pasted all of the scrips and templates
from the default __Approvals queue.
When I create a new ticket in the ChangeRequest queue, a 2nd ticket is created
and notifications are sent to the watchers that a new ticket is awaiting
approval. However, the approvals don't show up in My Approvals. Nor do they
show up in the ChangeApproval queue when I search for them. The
tickets/approvals exist, I can see them in the Tickets table with type=approval.
I can't sort out what I've done wrong. Any ideas?
Mike
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Approvals not working
Here's what I see. A new approval ticket does get created and here's the email
notification. The Queue is ChangeApproval, BUT when I search the ChangeApproval
queue there are no new tickets in there!?
Wed Jul 28 13:59:08 2010: Request 7461 was acted upon.
Transaction: Ticket created by RT_System
Queue: ChangeApproval
Subject: Approve Change Request for another test
Owner: Nobody
Requestors:
Status: new
Ticket URL: http://tracker.stonebridgebank.com/rt/Ticket/Display.html?id=7461
Someone has created a Change Request. Please review.
Mike
Michael James mja...@stonebridgebank.com 7/28/2010 4:57 PM
It worked on 3.4.6, which is the version we were using before 3.8.8.
Foggi, Nicola nfo...@depaul.edu 7/28/2010 4:48 PM
I was never able to get a queue working with approvals other than the default
__Approvals queue, if you use that does it work?
Nicola
-Original Message-
From: rt-users-boun...@lists.bestpractical.com on behalf of Michael James
Sent: Wed 7/28/2010 3:38 PM
To: RT Users rt-users@lists.bestpractical.com
Subject: [rt-users] Approvals not working
Hi, I used example code on the wiki to create a PO-Request type approval in
RT3.8.8 http://wiki.bestpractical.com/view/ApprovalCreation The process creates
new ticket(s) but isn't quite right yet.
I created 2 queues: ChangeRequest and ChangeApproval and both are enabled.
ChangeRequest queue has 1 scrip:
On Create, Create Tickets with template CreateApproval, stage
TransactionCreate. with no User defined conditions.
The CreateApproval template is pretty much cut-n-paste from the wiki:
===Create-Ticket: poreq
Subject: Approve Change Request for {$Tickets{'TOP'}-Subject}
Depended-On-By: TOP
Queue: ChangeApproval
Type: approval
Owner: username-of-owner #note this is so that notifications work properly
Content: Someone has created a Change Request. Please review.
ENDOFCONTENT
For the ChangeApproval queue, I copied/pasted all of the scrips and templates
from the default __Approvals queue.
When I create a new ticket in the ChangeRequest queue, a 2nd ticket is created
and notifications are sent to the watchers that a new ticket is awaiting
approval. However, the approvals don't show up in My Approvals. Nor do they
show up in the ChangeApproval queue when I search for them. The
tickets/approvals exist, I can see them in the Tickets table with type=approval.
I can't sort out what I've done wrong. Any ideas?
Mike
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
The information in this message may be proprietary and/or confidential, and
protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to
the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
have received this communication in error, please notify Stonebridge Bank
immediately by replying to this message and deleting it from your computer.
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Upgrade sequence?
Hi, I've got the following according to RT..Configuration..Tools..System Configuration RT v3.4.6; RT::FM v2.2.1; RT::Interface::Email v2; RTx::AssetTracker v0.0.0; And I want to upgrade to RT v3.8.8 and the latest version of RTFM and RTx::AssetTracker. What's the sequence of steps I need to follow? My plan is to install RT 3.8.8 in a new directory. Then do I install RTFM and/or AT? When do I upgrade the database and schema in the sequence? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Page Not Found error in 3.8.8 install
Hi, I just upgraded last night from 3.4.6. to 3.8.8 and the install went mostly OK. I'm experiencing an error in the Home view, though. If I click on the Subject in the 10 highest priority tickets I own box, I get a Page Not Found error. In the 10 Newest Unowned Tickets, I don't get an error when clicking on the Subject. Clicking on the # works in both boxes. I seem to recall a similar error being discussed in the group a couple years ago, but I can't find the thread. Any ideas? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Page Not Found error in 3.8.8 install
I was reading some old threads and found some similar reports. Michael James mja...@stonebridgebank.com 7/13/2010 11:29 AM Hi, I just upgraded last night from 3.4.6. to 3.8.8 and the install went mostly OK. I'm experiencing an error in the Home view, though. If I click on the Subject in the 10 highest priority tickets I own box, I get a Page Not Found error. In the 10 Newest Unowned Tickets, I don't get an error when clicking on the Subject. Clicking on the # works in both boxes. I seem to recall a similar error being discussed in the group a couple years ago, but I can't find the thread. Any ideas? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Another RT::Authen::ExternalAuth question
Well, now we're making progress! Thanks, Bill. No offense taken. The errors are
in my setup of RT::Authen::ExternalAuth variables in RT_SiteConfig.pm.
I didn't realize mysql was so case-sensitive and the different values hadn't
really registered with me. Changing the table variable in RT_SiteConfig.pm from
USERS to Users worked and got me to the next errors. This seems a little odd to
me because I'm really using the default installation values of both RT and
RT::Authen::ExternalAuth except for the base path. I made an assumption that
the values in the sample RT_SiteConfig.pm from ExternalAuth's setup would be
consistent with the default MySQL tables/columns. My bad... Anyway, problem
solved and I thank you very much.
Mike
The next errors were fixed by changing the field names to match the actual
column names in the RT database. I'm just showing this for completeness.
Jan 14 11:04:18 rt384 RT: DBD::mysql::db selectall_hashref failed: Unknown
column 'email' in 'field list' at
/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm
line 163, DATA line 514.
(/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:163)
So now the table (Users) is found, but the columns are not. The relevant
portion of RT_SiteConfig.pm is:
# The mapping of RT attributes on to field names
'attr_map'
= { 'Name' = 'username',
'EmailAddress' = 'email',
'ExternalAuthId' = 'username',
'Gecos' = 'userID'
William Graboyes william.grabo...@theportalgrp.com 1/13/2010 6:23 PM
Hi Mike,
I intend no offense, I am just trying to help out, and sometimes we forget
to check the easy stuff first (hey we all do some times :) ).
That being said I think we have this figured out:
I know it is like a game of 20 questions, but in my current installs 3.8.4
and 3.8.6 with mysql the table USERS does not exist, because the table name
is Users. I am not sure if perl dbi is picky about case, but my gut
instinct would be that it is, and I know that mysql is picky about case in
this sense.
Even mysql directly doesn't like case mismatch.
select * from `cachemgt`.`USERS`; -- would result in an error because the
table USERS doesn't exist -- as a matter of a fact it is the same exact
error you are seeing in the logs Table 'cachemgt.USERS' doesn't exist.
select * form `cachemgt`.`Users`; -- works on my instance because the tabke
Users does exist.
Note that I changed the query to match your database structure.
HTH,
Thanks,
Bill
On Wed, Jan 13, 2010 at 3:08 PM, Michael James
mja...@stonebridgebank.comwrote:
Bill, that is indeed the RT-database. I posted my RT_SiteConfig.pm file
earlier today if you'd like to peruse it. The rt_user has permissions.
Thanks, Mike
William Graboyes william.grabo...@theportalgrp.com 1/13/2010 5:47 PM
Hi Mike,
Asking questions from the questioner.
Is that a separate database from your RT database?
If it is a separate database, does your rt db user have access to that
database?
Just trying to help.
Thanks,
Bill
On Wed, Jan 13, 2010 at 2:36 PM, Michael James
mja...@stonebridgebank.comwrote:
Thanks, Bill. The database name is cashmgt and the table name is USERS,
rather than table and column names. In any case, the table does exist.
Mike
William Graboyes william.grabo...@theportalgrp.com 1/13/2010 5:30
PM
Hi Mike,
Purely from a log file perspective, I know nothing about external auth,
it
is saying that the column USERS doesn't exist in the table cachemgmt. It
looks like it is trying to then recover gracefully, instead of puking all
over itself and refusing to allow you to log in.
Again purely from the Log File Perspective, I am sure that there are
others
out there with a massive store of knowledge on external auth, that may
help
you fix this one.
Thanks,
Bill
On Wed, Jan 13, 2010 at 2:20 PM, Michael James
mja...@stonebridgebank.comwrote:
Hi, I see an error in my /var/log/messages file when I'm logging in to
this
instance of RT. Fresh install of RT 3.8.7 on SLES10 64-bit. What does
this
imply? The mysql database cashmgt exists and I can login with the
default
root credentials, I just don't how to interpret the message.
Thanks, Mike
Jan 13 17:04:41 rt384 RT: DBD::mysql::db selectall_hashref failed:
Table
'cashmgt.USERS' doesn't exist at
/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm
line 219, DATA line 514.
(/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219)
Jan 13 17:04:41 rt384 RT: Issuing
Re: [rt-users] Another RT::Authen::ExternalAuth question
Truly. I decided the same thing myself after about 10 extra minutes of thinking
about it. I removed the MySQL external authentication and just let it use LDAP.
This was my 1st implementation of this plugin and I didn't get it in the
beginning.
thanks for everyone's help.
Mike
Kevin Falcone falc...@bestpractical.com 1/14/2010 1:23 PM
On Thu, Jan 14, 2010 at 11:20:17AM -0500, Michael James wrote:
Well, now we're making progress! Thanks, Bill. No offense taken. The errors
are in my setup of RT::Authen::ExternalAuth variables in RT_SiteConfig.pm.
I didn't realize mysql was so case-sensitive and the different values hadn't
really registered with me. Changing the table variable in RT_SiteConfig.pm
from USERS to Users worked and got me to the next errors. This seems a little
odd to me because I'm really using the default installation values of both RT
and RT::Authen::ExternalAuth except for the base path. I made an assumption
that the values in the sample RT_SiteConfig.pm from ExternalAuth's setup
would be consistent with the default MySQL tables/columns. My bad... Anyway,
problem solved and I thank you very much.
Unless you're authenticating against a custom mysql database, there is
no need to tell RT::Authen::ExternalAuth about RT's internal database
tables.
It sounds like you want to tell RT::Authen::ExternalAuth to only use
your LDAP configuration.
RT will fall back to internal auth if RT::Authen::ExternalAuth fails
to authenticate you against LDAP
-kevin
The next errors were fixed by changing the field names to match the actual
column names in the RT database. I'm just showing this for completeness.
Jan 14 11:04:18 rt384 RT: DBD::mysql::db selectall_hashref failed: Unknown
column 'email' in 'field list' at
/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm
line 163, DATA line 514.
(/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:163)
So now the table (Users) is found, but the columns are not. The relevant
portion of RT_SiteConfig.pm is:
# The mapping of RT attributes on to field names
'attr_map'
= { 'Name' = 'username',
'EmailAddress' = 'email',
'ExternalAuthId' = 'username',
'Gecos' = 'userID'
William Graboyes william.grabo...@theportalgrp.com 1/13/2010 6:23 PM
Hi Mike,
I intend no offense, I am just trying to help out, and sometimes we forget
to check the easy stuff first (hey we all do some times :) ).
That being said I think we have this figured out:
I know it is like a game of 20 questions, but in my current installs 3.8.4
and 3.8.6 with mysql the table USERS does not exist, because the table name
is Users. I am not sure if perl dbi is picky about case, but my gut
instinct would be that it is, and I know that mysql is picky about case in
this sense.
Even mysql directly doesn't like case mismatch.
select * from `cachemgt`.`USERS`; -- would result in an error because the
table USERS doesn't exist -- as a matter of a fact it is the same exact
error you are seeing in the logs Table 'cachemgt.USERS' doesn't exist.
select * form `cachemgt`.`Users`; -- works on my instance because the tabke
Users does exist.
Note that I changed the query to match your database structure.
HTH,
Thanks,
Bill
On Wed, Jan 13, 2010 at 3:08 PM, Michael James
mja...@stonebridgebank.comwrote:
Bill, that is indeed the RT-database. I posted my RT_SiteConfig.pm file
earlier today if you'd like to peruse it. The rt_user has permissions.
Thanks, Mike
William Graboyes william.grabo...@theportalgrp.com 1/13/2010 5:47 PM
Hi Mike,
Asking questions from the questioner.
Is that a separate database from your RT database?
If it is a separate database, does your rt db user have access to that
database?
Just trying to help.
Thanks,
Bill
On Wed, Jan 13, 2010 at 2:36 PM, Michael James
mja...@stonebridgebank.comwrote:
Thanks, Bill. The database name is cashmgt and the table name is USERS,
rather than table and column names. In any case, the table does exist.
Mike
William Graboyes william.grabo...@theportalgrp.com 1/13/2010 5:30
PM
Hi Mike,
Purely from a log file perspective, I know nothing about external auth,
it
is saying that the column USERS doesn't exist in the table cachemgmt. It
looks like it is trying to then recover gracefully, instead of puking all
over itself and refusing to allow you to log in.
Again purely from the Log File Perspective, I am sure that there are
others
out there with a massive store
[rt-users] ExternalAuth
Running SuSE Linux, eDirectory, LDAP, RT 3.8.7. In my test setting, I can query
ldap anonymously. I downloaded RT-Authen-ExternalAuth-0.08.tar.gz and installed
it. I notice the wiki page (http://wiki.bestpractical.com/view/ExternalAuth )
says to answer the prompt as to your RT base directory, but I didn't observe
that behavior. Added the required entries to RT_SiteConfig.pm as far as I can
tell (see below). Trying to log on as mjames, I only get your username or
password is incorrect.
I feel like I'm missing something obvious... Any ideas?
Mike
Output of ldapsearch command:
rt384:~ # ldapsearch -x -b o=sbf -h lxutility cn=mjames mail uid
# extended LDIF
#
# LDAPv3
# base o=sbf with scope subtree
# filter: cn=mjames
# requesting: mail uid
#
# MJames, STONEBRIDGE, SBF
dn: cn=MJames,ou=STONEBRIDGE,o=SBF
# MJames, Users, STONEBRIDGEBANK, SBF
dn: cn=MJames,cn=Users,ou=STONEBRIDGEBANK,o=SBF
uid: MJames
mail: mja...@stonebridgebank.com
# search result
search: 2
result: 0 Success
# numResponses: 3
# numEntries: 2
cat RT_SiteConfig.pm
Set( $rtname, 'CashMgt');
Set(@Plugins , qw(RT::Authen::ExternalAuth));
Set($WebBaseURL , http://cashmgt.stonebridgebank.com;);
Set( $Organization , cashmgt.stonebridgebank.com);
Set($Timezone , US/Eastern);
Set($RTAddressRegexp , '^...@cashmgt.stonebridgebank.com$');
Set($DatabaseType , 'mysql');
Set($DatabaseUser , 'rt_user');
Set($DatabasePassword , 'rt_pass');
Set($DatabaseName , 'cashmgt');
Set($DatabaseHost , 'localhost');
Set($DatabaseRTHost , 'localhost');
Set($MaxAttachmentSize, 5000);
Set($WebPath , );
Set($CorrespondAddress , 'corresp...@cashmgt.stonebridgebank.com');
Set($CommentAddress , 'comm...@cashmgt.stonebridgebank.com');
Set($ExternalAuthPriority, [ 'My_LDAP',
'My_MySQL',
]
);
Set($ExternalInfoPriority, [ 'My_MySQL',
'My_LDAP'
]
);
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers,0);
Set($ExternalSettings, { # AN EXAMPLE DB SERVICE
'My_MySQL' = { ## GENERIC SECTION
'type'
= 'db',
'server'
= 'localhost',
'database'
= 'cashmgt',
'table'
= 'USERS',
'user'
= 'rt_user',
'pass'
= 'rt_pass',
'port'
= '3306',
'dbi_driver'
= 'mysql',
'u_field'
= 'name',
'p_field'
= 'password',
'p_enc_pkg'
= 'Crypt::MySQL',
'p_enc_sub'
= 'password',
'd_field'
= 'disabled',
'd_values'
= ['0'],
'attr_match_list'
= [ 'Gecos',
'Name'
],
'attr_map'
= { 'Name' = 'username',
'EmailAddress' = 'email',
'ExternalAuthId' = 'username',
'Gecos' = 'userID'
}
},
# AN EXAMPLE LDAP SERVICE
'My_LDAP' = { ## GENERIC SECTION
'type'
= 'ldap',
'server'
= '172.31.4.56',
'base'
= 'o=sbf',
'filter'
= '(objectClass=*)',
[rt-users] Another RT::Authen::ExternalAuth question
Hi, I see an error in my /var/log/messages file when I'm logging in to this instance of RT. Fresh install of RT 3.8.7 on SLES10 64-bit. What does this imply? The mysql database cashmgt exists and I can login with the default root credentials, I just don't how to interpret the message. Thanks, Mike Jan 13 17:04:41 rt384 RT: DBD::mysql::db selectall_hashref failed: Table 'cashmgt.USERS' doesn't exist at /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 219, DATA line 514. (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) Jan 13 17:04:41 rt384 RT: Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 219, DATA line 514. (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) Jan 13 17:04:41 rt384 RT: Successful login for root from 172.31.4.144 (/opt/cashmgt/bin/../lib/RT/Interface/Web.pm:430) The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Another RT::Authen::ExternalAuth question
Thanks, Bill. The database name is cashmgt and the table name is USERS, rather than table and column names. In any case, the table does exist. Mike William Graboyes william.grabo...@theportalgrp.com 1/13/2010 5:30 PM Hi Mike, Purely from a log file perspective, I know nothing about external auth, it is saying that the column USERS doesn't exist in the table cachemgmt. It looks like it is trying to then recover gracefully, instead of puking all over itself and refusing to allow you to log in. Again purely from the Log File Perspective, I am sure that there are others out there with a massive store of knowledge on external auth, that may help you fix this one. Thanks, Bill On Wed, Jan 13, 2010 at 2:20 PM, Michael James mja...@stonebridgebank.comwrote: Hi, I see an error in my /var/log/messages file when I'm logging in to this instance of RT. Fresh install of RT 3.8.7 on SLES10 64-bit. What does this imply? The mysql database cashmgt exists and I can login with the default root credentials, I just don't how to interpret the message. Thanks, Mike Jan 13 17:04:41 rt384 RT: DBD::mysql::db selectall_hashref failed: Table 'cashmgt.USERS' doesn't exist at /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 219, DATA line 514. (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) Jan 13 17:04:41 rt384 RT: Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 219, DATA line 514. (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) Jan 13 17:04:41 rt384 RT: Successful login for root from 172.31.4.144 (/opt/cashmgt/bin/../lib/RT/Interface/Web.pm:430) The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Another RT::Authen::ExternalAuth question
Bill, that is indeed the RT-database. I posted my RT_SiteConfig.pm file earlier today if you'd like to peruse it. The rt_user has permissions. Thanks, Mike William Graboyes william.grabo...@theportalgrp.com 1/13/2010 5:47 PM Hi Mike, Asking questions from the questioner. Is that a separate database from your RT database? If it is a separate database, does your rt db user have access to that database? Just trying to help. Thanks, Bill On Wed, Jan 13, 2010 at 2:36 PM, Michael James mja...@stonebridgebank.comwrote: Thanks, Bill. The database name is cashmgt and the table name is USERS, rather than table and column names. In any case, the table does exist. Mike William Graboyes william.grabo...@theportalgrp.com 1/13/2010 5:30 PM Hi Mike, Purely from a log file perspective, I know nothing about external auth, it is saying that the column USERS doesn't exist in the table cachemgmt. It looks like it is trying to then recover gracefully, instead of puking all over itself and refusing to allow you to log in. Again purely from the Log File Perspective, I am sure that there are others out there with a massive store of knowledge on external auth, that may help you fix this one. Thanks, Bill On Wed, Jan 13, 2010 at 2:20 PM, Michael James mja...@stonebridgebank.comwrote: Hi, I see an error in my /var/log/messages file when I'm logging in to this instance of RT. Fresh install of RT 3.8.7 on SLES10 64-bit. What does this imply? The mysql database cashmgt exists and I can login with the default root credentials, I just don't how to interpret the message. Thanks, Mike Jan 13 17:04:41 rt384 RT: DBD::mysql::db selectall_hashref failed: Table 'cashmgt.USERS' doesn't exist at /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 219, DATA line 514. (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) Jan 13 17:04:41 rt384 RT: Issuing rollback() for database handle being DESTROY'd without explicit disconnect() at /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm line 219, DATA line 514. (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) Jan 13 17:04:41 rt384 RT: Successful login for root from 172.31.4.144 (/opt/cashmgt/bin/../lib/RT/Interface/Web.pm:430) The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message
Re: [rt-users] postfix mail to RT system
Edit the /etc/aliases file with your favorite editor. Insert entries like the following, substituting your specific URL and queue names. This assumes you installed RT in the default location at /opt/rt3. general:|/opt/rt3/bin/rt-mailgate --queue General --action correspond --url http://tracker.stonebridgebank.com/rt/; general-comment:|/opt/rt3/bin/rt-mailgate --queue General --action comment --url http://tracker.stonebridgebank.com/rt/; correspond: |/opt/rt3/bin/rt-mailgate --queue General --action correspond --url http://tracker.stonebridgebank.com/rt/; Save the file, then run the newaliases command to restart postfix. # newaliases CapiZikus ray.siri...@capita.co.uk 1/12/2010 5:38 PM Hi, I managed to send mail from RT system to my mail server using postfix (relay mail server in postfix). Could someone guide me how to deliver mail from postfix to RT please, both RT and postfix are on the same server. thanks -- View this message in context: http://old.nabble.com/postfix-mail-to-RT-system-tp27136129p27136129.html Sent from the Request Tracker - User mailing list archive at Nabble.com. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] error starting apache2
SLES 10 SP2 fresh build RT 3.8.1 downloaded from BestPractical yesterday. After installing RT, I brought an existing RT_SiteConfig.pm file over from another server running RT 3.6.6. Apache2 fails to start with the following errors in /var/log/apache2/error_log: [Thu Dec 11 13:34:09 2008] [error] Couldn't load RT config file RT_SiteConfig.pm:\n\nType of arg 1 to RT::Set must be one of [...@%] (not scalar assignment) at /opt/rt3/etc/RT_SiteConfig.pm line 43, near )\nCompilation failed in require at /opt/rt3/bin/../lib/RT/Config.pm line 410.\nBEGIN failed--compilation aborted at /opt/rt3/bin/webmux.pl line 101.\nCompilation failed in require at (eval 7) line 1.\n [Thu Dec 11 13:34:09 2008] [error] Can't load Perl file: /opt/rt3/bin/webmux.pl for server tracker3.stonebridgebank.com:0, exiting... Line 43 of RT_SiteConfig.pm is Set($WebPath = ); which looks perfectly OK to me. Any ideas? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] error starting apache2
thx! Weird, I've been using the wrong syntax for awhile. It didn't cause errors in the past. Mike Ruslan Zakirov r...@bestpractical.com 12/11/2008 1:55 PM Set($WebPath, ); On Thu, Dec 11, 2008 at 9:39 PM, Michael James mja...@stonebridgebank.com wrote: SLES 10 SP2 fresh build RT 3.8.1 downloaded from BestPractical yesterday. After installing RT, I brought an existing RT_SiteConfig.pm file over from another server running RT 3.6.6. Apache2 fails to start with the following errors in /var/log/apache2/error_log: [Thu Dec 11 13:34:09 2008] [error] Couldn't load RT config file RT_SiteConfig.pm:\n\nType of arg 1 to RT::Set must be one of [...@%] (not scalar assignment) at /opt/rt3/etc/RT_SiteConfig.pm line 43, near )\nCompilation failed in require at /opt/rt3/bin/../lib/RT/Config.pm line 410.\nBEGIN failed--compilation aborted at /opt/rt3/bin/webmux.pl line 101.\nCompilation failed in require at (eval 7) line 1.\n [Thu Dec 11 13:34:09 2008] [error] Can't load Perl file: /opt/rt3/bin/webmux.pl for server tracker3.stonebridgebank.com:0, exiting... Line 43 of RT_SiteConfig.pm is Set($WebPath = ); which looks perfectly OK to me. Any ideas? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Best regards, Ruslan. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Installation of 3.8.1 fixdeps
Hi, I am installing RT 3.8.1 on a fresh build of SLES10 SP2. I ran into an issue with MAILGATE dependencies when I ran 'make fixdeps' HTML::Tree was MISSING and wouldn't install (bad make test), so I ended up forcing the HTML::Tree installation to get it finished. I searched the archives but didn't see this problem discussed, so I thought I'd mention it in case anyone else was seeing the same problem. (PETEK/HTML-Tree-3.23.tar.gz was the module trying to install) Just do this: rt-host:~/rt-3.8.1 # cpan -MCPAN -e shell cpan force install HTML::Tree The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Howto create multiple unowned tickets default views
Hi, some of our folks want to see two Newest Unowned Tickets views in their default page - 10 Newest Unowned Tickets in Queue#1 and then 10 Newest Unowned Tickets in Queue#2, for example. This is RT 3.6.6. Is there a known way to do this? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] 3.6.6 display problem
Hi, I'm running SLES 10, SP1, with RT 3.6.6. Yesterday, I installed 2 php5 modules, then ran online updates last night from YAST2, and today I see nothing when I access the site, just a blank page. The Apache access_log shows a successful connection: 172.31.4.143 - - [10/Sep/2008:10:43:55 -0400] GET /index.html HTTP/1.1 200 - - Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1 But Firefox displays a blank page, 0 bytes. I'm guessing it's a Perl module from the YAST update. Any clues? The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 3.6.6 display problem
Yeah, 'rpm -qa --last | less' showed me that perl-5.8.8-14.10 was installed Wed Sep 10 03:26:19 2008. I tried to reinstall Scalar::Utils but I'm having some trouble with CPAN — any suggestions? cpan[1] install Scalar::Utils CPAN: Storable loaded ok (v2.15) Going to read /root/.cpan/Metadata Database was generated on Thu, 05 Jun 2008 19:06:52 GMT Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. DONE CPAN: LWP::UserAgent loaded ok (v2.036) CPAN: Time::HiRes loaded ok (v1.86) Fetching with LWP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. LWP failed with code[500] message[read timeout] CPAN: Net::FTP loaded ok (v2.77) Fetching with Net::FTP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Fetching with Net::FTP ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Trying with /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 to get ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz --11:36:08-- ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz = `/root/.cpan/sources/modules/02packages.details.txt.tmp22613' Connecting to 172.31.4.254:8080... connected. Proxy request sent, awaiting response... 404 Not Found 11:36:10 ERROR 404: Not Found. System call /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz; returned status 1 (wstat 256) Warning: expected file [/root/.cpan/sources/modules/02packages.details.txt.gz.tmp22613] doesn't exist Fetching with LWP: ftp://cpan.calvin.edu/pub/CPAN/modules/02packages.details.txt.gz CPAN: YAML loaded ok (v0.66) Going to read /root/.cpan/sources/modules/02packages.details.txt.gz Catching error: 'Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. ' at /usr/lib/perl5/5.8.8/CPAN.pm line 281 CPAN::shell() called at -e line 1 Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Lockfile removed. Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. Michael James [EMAIL PROTECTED] 9/10/2008 10:57 AM Hi, I'm running SLES 10, SP1, with RT 3.6.6. Yesterday, I installed 2 php5 modules, then ran online updates last night from YAST2, and today I see nothing when I access the site, just a blank page. The Apache access_log shows a successful connection: 172.31.4.143 - - [10/Sep/2008:10:43:55 -0400] GET /index.html HTTP/1.1 200 - - Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1 But Firefox displays a blank page, 0 bytes. I'm guessing it's a Perl module from the YAST update. Any clues? The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com
Re: [rt-users] 3.6.6 display problem
OK, I did 'force install Scalar::Util' and that worked for me. The login page displays properly. Still working on Compress::Zlib ... Thanks for listening, Mike :) Michael James [EMAIL PROTECTED] 9/10/2008 11:38 AM Yeah, 'rpm -qa --last | less' showed me that perl-5.8.8-14.10 was installed Wed Sep 10 03:26:19 2008. I tried to reinstall Scalar::Utils but I'm having some trouble with CPAN — any suggestions? cpan[1] install Scalar::Utils CPAN: Storable loaded ok (v2.15) Going to read /root/.cpan/Metadata Database was generated on Thu, 05 Jun 2008 19:06:52 GMT Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. DONE CPAN: LWP::UserAgent loaded ok (v2.036) CPAN: Time::HiRes loaded ok (v1.86) Fetching with LWP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/5.8.8/i586-linux-thread-multi/Scalar/Util.pm line 30. LWP failed with code[500] message[read timeout] CPAN: Net::FTP loaded ok (v2.77) Fetching with Net::FTP: ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Fetching with Net::FTP ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz.gz Couldn't cwd pub/mirrors/CPAN/modules: pub/mirrors/CPAN/modules: No such file or directory. Trying with /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 to get ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz --11:36:08-- ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz = `/root/.cpan/sources/modules/02packages.details.txt.tmp22613' Connecting to 172.31.4.254:8080... connected. Proxy request sent, awaiting response... 404 Not Found 11:36:10 ERROR 404: Not Found. System call /usr/bin/wget -O /root/.cpan/sources/modules/02packages.details.txt.tmp22613 ftp://bc1.hpc.lsu.edu/pub/mirrors/CPAN/modules/02packages.details.txt.gz; returned status 1 (wstat 256) Warning: expected file [/root/.cpan/sources/modules/02packages.details.txt.gz.tmp22613] doesn't exist Fetching with LWP: ftp://cpan.calvin.edu/pub/CPAN/modules/02packages.details.txt.gz CPAN: YAML loaded ok (v0.66) Going to read /root/.cpan/sources/modules/02packages.details.txt.gz Catching error: 'Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. ' at /usr/lib/perl5/5.8.8/CPAN.pm line 281 CPAN::shell() called at -e line 1 Going to read /root/.cpan/sources/authors/01mailrc.txt.gz Lockfile removed. Undefined subroutine Compress::Zlib::gzopen called at /usr/lib/perl5/5.8.8/CPAN/Tarzip.pm line 103. Michael James [EMAIL PROTECTED] 9/10/2008 10:57 AM Hi, I'm running SLES 10, SP1, with RT 3.6.6. Yesterday, I installed 2 php5 modules, then ran online updates last night from YAST2, and today I see nothing when I access the site, just a blank page. The Apache access_log shows a successful connection: 172.31.4.143 - - [10/Sep/2008:10:43:55 -0400] GET /index.html HTTP/1.1 200 - - Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1 But Firefox displays a blank page, 0 bytes. I'm guessing it's a Perl module from the YAST update. Any clues? The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately
[rt-users] Add a Delete link to Newest Unowned list
Hi, we're using a Barracuda 400 to remove spam from our incoming email, but still the occasional piece of spam gets through. I thought it might be a good idea to add a Delete column to the default 10 Newest Unowned Tickets view, so that the customer service reps could easily delete them with a single click. Can this be easily accomplished? Using RT 3.6.6 at the moment. Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT-Authen-ExternalAuth
Thanks, that's exactly what I needed. Christian Forjahn [EMAIL PROTECTED] 7/17/2008 3:17 AM Hi Michael. You have to give the path in the configure execution like that: ./configure --prefix=/opt/csr/ Best chris Michael James wrote: Hi, I'm installing an instance of RT in a non-standard local directory (/opt/csr/). The wiki indicates that when I run perl Makefile.PL, it will prompt me for the path to my RT instance, but... it doesn't. So, how can I specify the RT directory? You can see below - I want /opt/rt3 to be /opt/csr instead. hostnew:~/RT-Authen-ExternalAuth-0.05 # perl Makefile.PL Cannot determine perl version info from lib/RT/Authen/ExternalAuth.pm Cannot determine author info from lib/RT/Authen/ExternalAuth.pm Cannot determine license info from lib/RT/Authen/ExternalAuth.pm Using RT configuration from /opt/rt3/lib/RT.pm: ./etc = /opt/rt3/local/etc/Authen-ExternalAuth ./html = /opt/rt3/share/html ./lib = /opt/rt3/local/lib Cannot determine perl version info from lib/RT/Authen/ExternalAuth.pm Checking if your kit is complete... Looks good Writing Makefile for RT::Authen::ExternalAuth The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT-Authen-ExternalAuth
Hi, I'm installing an instance of RT in a non-standard local directory (/opt/csr/). The wiki indicates that when I run perl Makefile.PL, it will prompt me for the path to my RT instance, but... it doesn't. So, how can I specify the RT directory? You can see below - I want /opt/rt3 to be /opt/csr instead. hostnew:~/RT-Authen-ExternalAuth-0.05 # perl Makefile.PL Cannot determine perl version info from lib/RT/Authen/ExternalAuth.pm Cannot determine author info from lib/RT/Authen/ExternalAuth.pm Cannot determine license info from lib/RT/Authen/ExternalAuth.pm Using RT configuration from /opt/rt3/lib/RT.pm: ./etc = /opt/rt3/local/etc/Authen-ExternalAuth ./html = /opt/rt3/share/html ./lib = /opt/rt3/local/lib Cannot determine perl version info from lib/RT/Authen/ExternalAuth.pm Checking if your kit is complete... Looks good Writing Makefile for RT::Authen::ExternalAuth The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Font-AFM-1.19
Well, I'm trying to install rt-3.6.6 on a new SuSE server (SLES 10, SP1) and having trouble with this perl module :/ Here's the output I see in cpan: Test Summary Report --- t/afm.t (Wstat: 0 Tests: 1 Failed: 1) Failed test: 1 Parse errors: Bad plan. You planned 0 tests but ran 1. Files=2, Tests=3, 0 wallclock secs ( 0.00 usr 0.02 sys + 0.00 cusr 0.02 csys = 0.04 CPU) Result: FAIL Failed 1/2 test programs. 1/3 subtests failed. make: *** [test_dynamic] Error 255 GAAS/Font-AFM-1.19.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports GAAS/Font-AFM-1.19.tar.gz Running make install make test had returned bad status, won't install without force Failed during this command: GAAS/Font-AFM-1.19.tar.gz: make_test NO So, should I just force the install? or is there some other dependency that isn't being displayed? Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] SVN checkout probs.
Thanks for the quick(!) reply. Now, I get timeout errors. So, I suspect that the proxy settings might not be working for the svn:// protocol. What port is being used by svn://svn.bestpractical.com? Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.6.3 web interface problems
Actually, Apache2 will create those internal dummy connections and tell it's children to gracefully die. I just ran into that issue yesterday when I was processing some web log files on a new server. The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
RE: [rt-users] LDAP and user info
I did track down the LDAP problem, and it didn't have anything specifically to do with RT. We use Novell eDirectory here. Some of our older accounts were apparently created with NWADMIN, which does not create a UID for those users. Following the instructions on the wiki (http://wiki.bestpractical.com/index.cgi?LdapSiteConfigSettings ) I had set the attribute 'Name' = 'uid' and it worked for 95% of the users. Turns out that a few users did not have uid's defined in their LDAP accounts. Fixed their LDAP accounts, and now everything is cool. Thanks for your help! As far as logging on with LDAP or password, see the above wiki page. Line 2 of the code there says: ### What auth methods do you like and in what order? Set($AuthMethods, ['LDAP', 'Internal']); So, users with internal RT passwords can still get in. Thanks, Mike The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Scott Golby [EMAIL PROTECTED] 3/26/2007 12:27 PM Hi, I have an instance of RT 3.4.6 running nicely, thank you, that serves as our internal Helpdesk. I use LDAP to authenticate users, and I'm having a problem with some users. I think these users were created before I got the LDAP mods installed. We have almost the opposite here, accounts created before the LDAP was installed can login with either their LDAP password or their old RT password. It does a fall through, you can see it in the logs, I did a quick look and I don't spot a config which turns that on or off. One issue I came up against with the LDAP / Email causing account creation was userids would get created as [EMAIL PROTECTED], where our Active Directory server would only allow 'username'. I wrote a little cleaner script to go into the Database and strip the @emailaddress.com out of the name.users table. Doesn't sound like your exact problem, but maybe your LDAP wants those user-id's in Format A. and your historical pre-LDAP accounts are in Format B. and what is actually happening is they are falling through to the RT password (which you mention you set) and that's how they get in ? Turning the debug on gives quite a lot of useful info Set($LogToFile , 'debug'); Good luck. Scott ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Problem with creating new users
I would guess that the user is unprivileged. The information in this message may be proprietary and/or confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Stonebridge Bank immediately by replying to this message and deleting it from your computer. Andrej Ricnik-Bay [EMAIL PROTECTED] 10/31/2006 3:07:07 pm Hi, I did some googling and looked on the twiki, but can't seem to find and relevant references. I've installed RT 3.6.1 on Slackware 10.2 with mod_perl (which was a bit of a PITA but that's another story :}). My instance of RT is up running against PostgreSQL 8.1.2. I managed to create two initial user accounts which show up under Configuration - Users. Today I cannot seem to add users any longer. I don't get an error when I create a new user, he exists in the database, but won't show up in the web-interface. If I try to create the user again he will be rejected as already existing. What am I doing wrong - where did I fail? Cheers, Andrej ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
