[rt-users] R: How to configure font for RTFM articles?

2011-03-09 Thread Guadagnino Cristiano
Hi Kevin!

Thank you, that's exactly what I needed.

Bye
Cris

-Messaggio originale-
Da: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] Per conto di Kevin Falcone
Inviato: Tuesday, March 08, 2011 5:10 PM
A: rt-users@lists.bestpractical.com
Oggetto: Re: [rt-users] How to configure font for RTFM articles?

On Tue, Mar 08, 2011 at 12:49:15PM +0100, Guadagnino Cristiano wrote:
Hi all,
 
I feel the default font in RTFM articles is too tiny. Is there a way to 
 configure the standard
font for RTFM article bodies?
 
I did not find anything in RTFM docs, nor in this list archives.

Do you mean on the article display page?

Override the declarations in webrtfm.css in some local css, or send a patch 
against it for future releases.

-kevin


[rt-users] Delete attachments of closed tickets

2011-03-09 Thread Niclas Möre
Hi,

 

I am looking for a way to schedule (cron) a job to remove attachments of all 
tickets that's been closed for more than one week. Or even better, replace the 
attachment with an informative text that the attachment been removed.

I've been looking into RT-Shredder, but don't really understand how to restrict 
the selection of attachments to tickets closed for a certain period of time.

 

Thanks

 



[rt-users] Saving info for Custom Fields

2011-03-09 Thread Lionel Wolfaardt
Ok I'm hoping someone knows how to do this.

We have various custom fields where Users will fill in data about a specific 
thing.
Is there a way that when someone fills in one of these custom fields whilst 
creating a ticket, the Info they put into the Custom field will be saved to a 
drop down list for future use so that the user doesn't have to type in this 
data into the custom field for another ticket?

From: Lionel Wolfaardt
Sent: 09 March 2011 11:45 AM
To: 'rt-users@lists.bestpractical.com'
Subject: Saving info for Custom Fields



Lionel Wolfaardt

[cid:image001.jpg@01CBDE50.D03CB320]
* +27 21 710 2999(Tel)
*   +27 21 710 2399   (Fax)
*   lion...@imperatech.commailto:ald...@imperatech.com
* www.imperatech.comhttp://www.imperatech.com/

[cid:image002.png@01CBDE50.D03CB320][cid:image003.png@01CBDE50.D03CB320]


**
Relevant company disclaimers are available at the following addresses:
Email: mailto:disclai...@imperatech.com?Subject=Imperatech_Disclaimer
**
**
Relevant company disclaimers are available at the following addresses:
Email: mailto:disclai...@imperatech.com?Subject=Imperatech_Disclaimer
**
inline: image001.jpginline: image002.pnginline: image003.png

[rt-users] Saving info for Custom Fields

2011-03-09 Thread Lionel Wolfaardt


Lionel Wolfaardt

[cid:image001.jpg@01CBDE4F.6F82B210]
* +27 21 710 2999(Tel)
*   +27 21 710 2399   (Fax)
*   lion...@imperatech.commailto:ald...@imperatech.com
* www.imperatech.comhttp://www.imperatech.com/

[cid:image002.png@01CBDE4F.6F82B210][cid:image003.png@01CBDE4F.6F82B210]


**
Relevant company disclaimers are available at the following addresses:
Email: mailto:disclai...@imperatech.com?Subject=Imperatech_Disclaimer
**
inline: image001.jpginline: image002.pnginline: image003.png

Re: [rt-users] Delete attachments of closed tickets

2011-03-09 Thread Ruslan Zakirov
Hello,

There is no such search capabilities in the shredder. Write a script
that finds attachments you want to delete and fire shredder.

On Wed, Mar 9, 2011 at 11:37 AM, Niclas Möre niclas.m...@ticnet.se wrote:
 Hi,



 I am looking for a way to schedule (cron) a job to remove attachments of all
 tickets that’s been closed for more than one week. Or even better, replace
 the attachment with an informative text that the attachment been removed.

 I’ve been looking into RT-Shredder, but don’t really understand how to
 restrict the selection of attachments to tickets closed for a certain period
 of time.



 Thanks





-- 
Best regards, Ruslan.


Re: [rt-users] Possible to deny Resolve. Reject permissions?

2011-03-09 Thread Ruslan Zakirov
Hello,

In 3.8 with a hack. In 4.0 with lifecycles configuration.

On Wed, Mar 9, 2011 at 7:41 AM, Yan Seiner y...@seiner.com wrote:
 Is it possible to deny users permission to Resolve or Reject a ticket while
 giving them modify permissions on the ticket?

 --
 My car is Japanese. My Vodka is Russian. My pizza is Italian. My kebab is
 Turkish. My democracy is Greek. My wine is French. My coffee is Brazilian.
 My language is English. My movies are American. My music is African. My
 beers are German. My shirt is Indian. My oil is Saudi Arabian. My
 electronics are Taiwanese. My rifle is Czech. My shoes are Chinese.  My math
 is Arabic, my writing Latin. And you complain that your neighbor is Mexican?





-- 
Best regards, Ruslan.


Re: [rt-users] Possible to deny Resolve. Reject permissions?

2011-03-09 Thread Yan Seiner

So... Any hints on the hack?  And/or, when will 4.0 be out?

Ruslan Zakirov wrote:

Hello,

In 3.8 with a hack. In 4.0 with lifecycles configuration.

On Wed, Mar 9, 2011 at 7:41 AM, Yan Seiner y...@seiner.com wrote:
  

Is it possible to deny users permission to Resolve or Reject a ticket while
giving them modify permissions on the ticket?

--
My car is Japanese. My Vodka is Russian. My pizza is Italian. My kebab is
Turkish. My democracy is Greek. My wine is French. My coffee is Brazilian..
My language is English. My movies are American. My music is African. My
beers are German. My shirt is Indian. My oil is Saudi Arabian. My
electronics are Taiwanese. My rifle is Czech. My shoes are Chinese.  My math
is Arabic, my writing Latin. And you complain that your neighbor is Mexican?







  



--
My car is Japanese. My Vodka is Russian. My pizza is Italian. My kebab is 
Turkish. My democracy is Greek. My wine is French. My coffee is Brazilian. My 
language is English. My movies are American. My music is African. My beers are 
German. My shirt is Indian. My oil is Saudi Arabian. My electronics are 
Taiwanese. My rifle is Czech. My shoes are Chinese.  My math is Arabic, my 
writing Latin. And you complain that your neighbor is Mexican?



Re: [rt-users] Possible to view a ticket with inline graphics wysiwyg

2011-03-09 Thread Thomas Sibley
On 08 Mar 2011 20:12, Gilbert Rebeiro wrote:
 Is it possible for to have the emails and attachments inline as they
 were sent?

This is (unfortunately) not possible at the moment because RT doesn't
rewrite img tags which refer to CIDs.  Support for that would be great.

Thomas


Re: [rt-users] Possible to deny Resolve. Reject permissions?

2011-03-09 Thread Raed El-Hames
Yan:

One way of doing this is to put the hack in Elements/SelectStatus
Something like :
if 
($session{'CurrentUser'}{'can_resolve_ticket_or_whatever_you_want_to_call_it'}) 
{
  @status = $queue-StatusArray();  
} else {
  @status = RT-Config-Get('ActiveStatus') ;
}

The above will hide the non active statuses (resolve/reject/delete) from the 
dropdown unless the user can resolve/reject etc.

But you need to define / work on how you establish 
$session{'CurrentUser'}{'can_resolve_ticket_or_whatever_you_want_to_call_it'}

It all depends on how you distinguish those that can resolve from those that 
cannot.

Roy

 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
 boun...@lists.bestpractical.com] On Behalf Of Yan Seiner
 Sent: 09 March 2011 13:44
 To: Ruslan Zakirov
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Possible to deny Resolve. Reject permissions?
 
 So... Any hints on the hack?  And/or, when will 4.0 be out?
 
 Ruslan Zakirov wrote:
  Hello,
 
  In 3.8 with a hack. In 4.0 with lifecycles configuration.
 
  On Wed, Mar 9, 2011 at 7:41 AM, Yan Seiner y...@seiner.com wrote:
 
  Is it possible to deny users permission to Resolve or Reject a ticket
 while
  giving them modify permissions on the ticket?
 
  --
  My car is Japanese. My Vodka is Russian. My pizza is Italian. My kebab
 is
  Turkish. My democracy is Greek. My wine is French. My coffee is
 Brazilian..
  My language is English. My movies are American. My music is African. My
  beers are German. My shirt is Indian. My oil is Saudi Arabian. My
  electronics are Taiwanese. My rifle is Czech. My shoes are Chinese.  My
 math
  is Arabic, my writing Latin. And you complain that your neighbor is
 Mexican?
 
 
 
 
 
 
 
 
 
 --
 My car is Japanese. My Vodka is Russian. My pizza is Italian. My kebab is
 Turkish. My democracy is Greek. My wine is French. My coffee is Brazilian.
 My language is English. My movies are American. My music is African. My
 beers are German. My shirt is Indian. My oil is Saudi Arabian. My
 electronics are Taiwanese. My rifle is Czech. My shoes are Chinese.  My
 math is Arabic, my writing Latin. And you complain that your neighbor is
 Mexican?



Re: [rt-users] Promoting a user who was autocreated to real user status...

2011-03-09 Thread Michael James
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] RT Ticket History Search

2011-03-09 Thread ronald higgins
Greetings List Members,

Does anyone know how to search through the ticket history. I'm trying
to trace all the tickets that a particular user has worked on and not
necessarily closed, possibly handed over to another user,
is there a way to do this via the front or back end ?

Regards

Ronald


Re: [rt-users] RT Ticket History Search

2011-03-09 Thread Kenneth Marshall
On Wed, Mar 09, 2011 at 08:30:11PM +0200, ronald higgins wrote:
 Greetings List Members,
 
 Does anyone know how to search through the ticket history. I'm trying
 to trace all the tickets that a particular user has worked on and not
 necessarily closed, possibly handed over to another user,
 is there a way to do this via the front or back end ?
 
 Regards
 
 Ronald
 
You can troll through the transactions table looking for a
specific creator with SQL certainly.

Cheers,
Ken


[rt-users] Searching for approval tickets

2011-03-09 Thread Yan Seiner
Whta's the magic search for approval tickets?

type = 'approval'

Shows all approval tickets.

type = 'approval' and Status = 'open'

Shows open tickets, but not those awaiting approval.

I'd like to search for all approval tickets that are pending.




-- 
If you have eight hours to chop down a tree
spend six sharpening your axe.
--Abraham Lincoln



[rt-users] Recovering RT data base

2011-03-09 Thread CLOSE Dave
Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working correctly 
for several months, though with only casual use. Approximately three 
weeks ago, two MySQL tables started reporting corruption. This was 
coincident with installation of NagiosQL, which created a new data base, 
but I don't know that the two events are related. Now all tables for RT 
report OK with mysqlcheck *except* Attachments and Transactions. For 
those, any attempt to reference them results in loss of the data base 
connection.

# ./rt-validator -c
[Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
Lost connection to MySQL server during query at ./rt-validator line
1058. (./rt-validator:1058)
[Thu Feb 24 01:11:06 2011] [crit]: DBD::mysql::st execute failed: Lost
connection to MySQL server during query at ./rt-validator line 1058.
(/opt/rt3/sbin/../lib/RT.pm:379)
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./rt-validator line 1058.

# mysqlcheck -p --repair rt3 Attachments
Enter password:
mysqlcheck: Got error: 2013: Lost connection to MySQL server during
query when executing 'REPAIR TABLE ... '

Unfortunately, I do not have MySQL backups from before this situation. 
The corrupt MySQL data base is backed-up by actual copy (cp while mysqld 
was stopped). The non-corrupt tables are backed-up by mysqldump.

Is there any way to recover use of these two tables short of dropping 
the entire data base and recreating? If I did that, would the mysqldump 
of the remaining tables allow me to restore most content?
-- 
Dave Close



Re: [rt-users] Possible to deny Resolve. Reject permissions?

2011-03-09 Thread Ruslan Zakirov
You better look at SetStatus in RT/Ticket_Overlay.pm.

On Wed, Mar 9, 2011 at 7:07 PM, Raed El-Hames
raed.el-ha...@daisygroupplc.com wrote:
 Yan:

 One way of doing this is to put the hack in Elements/SelectStatus
 Something like :
 if 
 ($session{'CurrentUser'}{'can_resolve_ticket_or_whatever_you_want_to_call_it'})
  {
  @status = $queue-StatusArray();
 } else {
  @status = RT-Config-Get('ActiveStatus') ;
 }

 The above will hide the non active statuses (resolve/reject/delete) from the 
 dropdown unless the user can resolve/reject etc.

 But you need to define / work on how you establish
 $session{'CurrentUser'}{'can_resolve_ticket_or_whatever_you_want_to_call_it'}

 It all depends on how you distinguish those that can resolve from those that 
 cannot.

 Roy

 -Original Message-
 From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
 boun...@lists.bestpractical.com] On Behalf Of Yan Seiner
 Sent: 09 March 2011 13:44
 To: Ruslan Zakirov
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Possible to deny Resolve. Reject permissions?

 So... Any hints on the hack?  And/or, when will 4.0 be out?

 Ruslan Zakirov wrote:
  Hello,
 
  In 3.8 with a hack. In 4.0 with lifecycles configuration.
 
  On Wed, Mar 9, 2011 at 7:41 AM, Yan Seiner y...@seiner.com wrote:
 
  Is it possible to deny users permission to Resolve or Reject a ticket
 while
  giving them modify permissions on the ticket?
 
  --
  My car is Japanese. My Vodka is Russian. My pizza is Italian. My kebab
 is
  Turkish. My democracy is Greek. My wine is French. My coffee is
 Brazilian..
  My language is English. My movies are American. My music is African. My
  beers are German. My shirt is Indian. My oil is Saudi Arabian. My
  electronics are Taiwanese. My rifle is Czech. My shoes are Chinese.  My
 math
  is Arabic, my writing Latin. And you complain that your neighbor is
 Mexican?
 
 
 
 
 
 
 


 --
 My car is Japanese. My Vodka is Russian. My pizza is Italian. My kebab is
 Turkish. My democracy is Greek. My wine is French. My coffee is Brazilian.
 My language is English. My movies are American. My music is African. My
 beers are German. My shirt is Indian. My oil is Saudi Arabian. My
 electronics are Taiwanese. My rifle is Czech. My shoes are Chinese.  My
 math is Arabic, my writing Latin. And you complain that your neighbor is
 Mexican?





-- 
Best regards, Ruslan.


Re: [rt-users] Recovering RT data base

2011-03-09 Thread Ruslan Zakirov
You should look into Innodb recovery manuals.

http://dev.mysql.com/doc/refman/5.0/en/innodb-recovery.html

Also, you should look at mysql logs for more info.

And it's really better to move forward to mysql forums/lists for help.

On Wed, Mar 9, 2011 at 10:31 PM, CLOSE Dave
dave.cl...@us.thalesgroup.com wrote:
 Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working correctly
 for several months, though with only casual use. Approximately three
 weeks ago, two MySQL tables started reporting corruption. This was
 coincident with installation of NagiosQL, which created a new data base,
 but I don't know that the two events are related. Now all tables for RT
 report OK with mysqlcheck *except* Attachments and Transactions. For
 those, any attempt to reference them results in loss of the data base
 connection.

 # ./rt-validator -c
 [Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
 Lost connection to MySQL server during query at ./rt-validator line
 1058. (./rt-validator:1058)
 [Thu Feb 24 01:11:06 2011] [crit]: DBD::mysql::st execute failed: Lost
 connection to MySQL server during query at ./rt-validator line 1058.
 (/opt/rt3/sbin/../lib/RT.pm:379)
 DBD::mysql::st execute failed: Lost connection to MySQL server during
 query at ./rt-validator line 1058.

 # mysqlcheck -p --repair rt3 Attachments
 Enter password:
 mysqlcheck: Got error: 2013: Lost connection to MySQL server during
 query when executing 'REPAIR TABLE ... '

 Unfortunately, I do not have MySQL backups from before this situation.
 The corrupt MySQL data base is backed-up by actual copy (cp while mysqld
 was stopped). The non-corrupt tables are backed-up by mysqldump.

 Is there any way to recover use of these two tables short of dropping
 the entire data base and recreating? If I did that, would the mysqldump
 of the remaining tables allow me to restore most content?
 --
 Dave Close





-- 
Best regards, Ruslan.


[rt-users] Need RT to send mail to a group

2011-03-09 Thread Brandon Olszewski
Greetings,

I am trying to get my RT 3.8.9 instance running on SLES11 to send emails to all 
members of an RT group whenever a ticket is moved from any queue into the LAN 
queue.  I've created a group called LAN, and placed the desired recipient's 
RT user account as a member.

I've used the following command to create a custom action to send email to this 
group:
/opt/rt3/sbin/rt-email-gorup-admin -add 'Notify LAN group' -group 'LAN'

And I have verified the successful creation of this action with this command:
/opt/rt3/sbin/rt-email-group-admin -list 'Notify LAN group'

Result of the above command:
Name: Notify LAN group
Module: NotifyGroup
Members:
Group  = LAN

I've created a scrip (number 14 for this RT instance) in the LAN queue with the 
following paramaters:

Description: NotifyLAN
Condition: On Queue Change
Action: Notify LAN group (the custom action created in the above step)
Template: Global template: Admin Correspondence (unchanged default template)
Stage: TransactionCreate


When I move a ticket to the LAN queue, no email is sent, and these two lines 
appear in the RT log file:

[info]: #27/427 - Scrip 14 NotifyLAN 
(/opt/rt3/bin/../lib/RT/Interface/Email.pm:302)
[info]: No recipients found. Not Sending. 
(/opt/rt3/bin/../lib/RT/Interface/Email.pm:352)


I'm not set on using this method of sending email to a group if someone has an 
easier/working way to do it.  Any help would be greatly appreciated.

Brandon


The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and privileged material. 
Unauthorized review, use, disclosure, or distribution is prohibited. If you 
receive this material/information in error, please contact the sender and 
destroy the material/information.

Email is not a secure form of communication and should not be used to transmit 
personal or confidential information such as account numbers, balance 
information, or wire transfer requests. The PrivateBank is not responsible for 
the security of sensitive information received by email.


Re: [rt-users] Recovering RT data base

2011-03-09 Thread Matthew Hattersley
Just to chip in with this one, chances are that the corruption is down
to a hard disk problem of some sort. MySQL only tends to corrupt
(assuming innodb), if you messed with the innodb engine settings during
the install of NagioSQL or a underlying HDD issue. At which point MySQL
will have binlogs it struggles with and a world of other problems. Check
for changes to my.cnf and dmesg for kernel messages regarding the disc. 


Kind Regards,
Find Vaioni's latest Terms and Conditions  SLA docs 
http://www.vaioni.com/tcaupsla.html.
http://www.vaioni.com/ 
http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285 
http://www.cbawards.co.uk/Reader_Vote_3.cfm
http://www.vaioni.com/
Matthew Hattersley

Email: mailto:matthew.hatters...@vaioni.com
Mobile:
 
Address: 14 Leslie Hough Way
   Manchester
   Lancashire 
M6 6AJ
 
Tel:   0870-160-0650 Ext 201
Fax:  0870-160-0651
Web: http://www.vaioni.com
 
http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285
The information transmitted in and with this email is intended only for the 
person or entity to which it is addressed and may contain confidential and/or 
privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
Company. Any review, retransmission, dissemination or other use of, or taking 
of any action in reliance upon, this information by persons or entities other 
than the intended recipient is prohibited. If you received this in error, 
please contact the sender immediately and delete the material from any 
computer.  
Please also note, Vaioni filter incoming email for spam and inappropriate 
words. Unfortunately this does mean that sometimes genuine messages can be 
filtered out. Although we take measures to recover such messages, it must not 
be assumed that an email has been received by us and important communications 
should always be followed up by a phone call, fax or printed copy.
 
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Ruslan
Zakirov
Sent: 09 March 2011 21:57
To: CLOSE Dave
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Recovering RT data base

You should look into Innodb recovery manuals.

http://dev.mysql.com/doc/refman/5.0/en/innodb-recovery.html

Also, you should look at mysql logs for more info.

And it's really better to move forward to mysql forums/lists for help.

On Wed, Mar 9, 2011 at 10:31 PM, CLOSE Dave
dave.cl...@us.thalesgroup.com wrote:
 Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working
correctly
 for several months, though with only casual use. Approximately three
 weeks ago, two MySQL tables started reporting corruption. This was
 coincident with installation of NagiosQL, which created a new data
base,
 but I don't know that the two events are related. Now all tables for
RT
 report OK with mysqlcheck *except* Attachments and Transactions. For
 those, any attempt to reference them results in loss of the data base
 connection.

 # ./rt-validator -c
 [Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
 Lost connection to MySQL server during query at ./rt-validator line
 1058. (./rt-validator:1058)
 [Thu Feb 24 01:11:06 2011] [crit]: DBD::mysql::st execute failed: Lost
 connection to MySQL server during query at ./rt-validator line 1058.
 (/opt/rt3/sbin/../lib/RT.pm:379)
 DBD::mysql::st execute failed: Lost connection to MySQL server during
 query at ./rt-validator line 1058.

 # mysqlcheck -p --repair rt3 Attachments
 Enter password:
 mysqlcheck: Got error: 2013: Lost connection to MySQL server during
 query when executing 'REPAIR TABLE ... '

 Unfortunately, I do not have MySQL backups from before this situation.
 The corrupt MySQL data base is backed-up by actual copy (cp while
mysqld
 was stopped). The non-corrupt tables are backed-up by mysqldump.

 Is there any way to recover use of these two tables short of dropping
 the entire data base and recreating? If I did that, would the
mysqldump
 of the remaining tables allow me to restore most content?
 --
 Dave Close





-- 
Best regards, Ruslan.


[rt-users] Need assistance with rt authentication to Active Directory

2011-03-09 Thread m0bilitee
Hi folks, I'm trying to run rt 3.8.9 on CentOS 5.5, talking to Active
Directory on a Windows Server 2003 domain controller.  I followed the guide
at the wiki at http://requesttracker.wikia.com/wiki/CentOS5InstallPlusSome and
got everything working up to the external plugin.

I consolidated the RT_SiteConfig.pm to not include the ExternalAuth pm to
make it simpler for me to edit just a single file. My RT_SiteConfig.pm looks
like this:

 ##
   # Custom Site Config #
   ##

   Set($rtname , MyCo Inc.);
   Set($Organization , rt.mydomain.internal);
   Set($MinimumPasswordLength , 5);
   Set($Timezone , 'US/Central');

   Set(@Plugins, qw(
   RT::Authen::ExternalAuth
));

   Set($HomepageComponents, [qw(
QuickCreate
Quicksearch
MyAdminQueues
MySupportQueues
MyReminders
RefreshHomepage
Dashboards
   )]);

   Set($DatabaseType , 'mysql');
   Set($DatabaseHost   , 'localhost');
   Set($DatabaseRTHost , 'localhost');
   Set($DatabasePort , '');
   Set($DatabaseUser , 'rt_user');
   Set($DatabasePassword , 'X');
   Set($DatabaseName , 'rt3');

   Set($OwnerEmail , 'root');
   Set($LoopsToRTOwner , 1);

   Set($SendmailArguments , -oi -t -f support\@rt.mydomain.internal);

   Set($MaxAttachmentSize , 1000);

   Set($RTAddressRegexp , '^rt\@rt.mydomain.internal$');
   Set($CorrespondAddress , 'no-reply@rt.mydomain.internal');
   Set($CommentAddress , 'no-reply@rt.mydomain.internal');

   Set($UseFriendlyFromLine , 1);
   Set($FriendlyFromLineFormat , \%s\ %s);
   Set($UseFriendlyToLine , 1);
   Set($FriendlyToLineFormat, \%s Ticket #%s\:;);

   Set($NotifyActor, 0);
   Set($RecordOutgoingEmail, 1);

   Set($WebPath , /ticket);
   Set($WebPort , 80);
   Set($WebBaseURL , http://rt;);
   Set($WebURL , $WebBaseURL . $WebPath . /);

   Set($MessageBoxWidth , 72);
   Set($MessageBoxWrap, HARD);

   Set($MaxInlineBody, 13456);
   Set($DefaultSummaryRows, 10);

   Set($OldestTransactionsFirst, '1');
   Set($ShowTransactionImages, 1);

   Set($DateDayBeforeMonth , 0);
   Set($AmbiguousDayInPast , 1);

   Set($AutoCreate,{Privileged = 1});

Set($ExternalAuthPriority,   [ 'My_LDAP' ] );
Set($ExternalInfoPriority,   [ 'My_LDAP' ] );
Set($ExternalServiceUsesSSLorTLS,0);
Set($AutoCreateNonExternalUsers, 0);

Set($ExternalSettings,  {
'My_LDAP'   =  {

'type'  =  'ldap',
'auth'  =  1,
'info'  =  1,
'server'=
 'paris.mydomain.internal',
'user'  =  'rtuser',
'pass'  =  'rtuserpassword',
'base'  =
 'dc=newcospares,dc=internal',

'filter'=
 '((ObjectCategory=User)(ObjectClass=Person))',
'd_filter'  =
 '(userAccountControl:1.2.840.113556.1.4.803:=2)',

'tls'   =  0,
#   'ssl_version'   =  3,

'net_ldap_args' = [version =  3
],
'group' =  'cn=Domain
Users,ou=Users,dc=newcospares,dc=internal',
'group_attr'=  'member',

'attr_match_list'   = [   'Name',
'EmailAddress'   ],
'attr_map'  = {   'Name' =
'sAMAccountName',
   'EmailAddress' =
'mail',
   'Organization' =
'physicalDeliveryOfficeName',
   'RealName' = 'cn',
   'ExternalAuthId' =
'sAMAccountName',
   'Gecos' =
'sAMAccountName',
   'WorkPhone' =
'telephoneNumber',
   'Address1' =
'streetAddress',
   'City' = 'l',
   'State' = 'st',
   'Zip' =
'postalCode',
   'Country' = 'co'
   }
   }
 }
);





# Steve Stuff

Set ($LogToFileName,rt3.error);
Set ($LogDir,'/var/tmp');
Set 

[rt-users] Saving advanced searches

2011-03-09 Thread Yan Seiner
I'm trying to build an advanced search that I can save as a global search.

I'm running 3.8.9.

As admin, I click on Edit Search, load a previously saved search, click on
Advanced, make my modifications, click Apply.

When I click on Edit Search, RT doesn't take me to the edit screen, but
instead remains in the Advanced screen.  I can go to Show Results, Bulk
Update, New Search - but not Edit Search, so I cannot save my
modifications.  I'm convined this used to work.

Is this a known bug, or am I just missing something?


-- 
If you have eight hours to chop down a tree
spend six sharpening your axe.
--Abraham Lincoln



Re: [rt-users] Saving advanced searches

2011-03-09 Thread Yan Seiner
Never mind

Turns out that it was probably a typo in the advanced query.  Sure is
confusing - would be nice if RT said something about that.

On Wed, March 9, 2011 3:42 pm, Yan Seiner wrote:
 I'm trying to build an advanced search that I can save as a global
 search..

 I'm running 3.8.9.

 As admin, I click on Edit Search, load a previously saved search, click on
 Advanced, make my modifications, click Apply.

 When I click on Edit Search, RT doesn't take me to the edit screen, but
 instead remains in the Advanced screen.  I can go to Show Results, Bulk
 Update, New Search - but not Edit Search, so I cannot save my
 modifications.  I'm convined this used to work.

 Is this a known bug, or am I just missing something?


 --
 If you have eight hours to chop down a tree
 spend six sharpening your axe.
 --Abraham Lincoln


 !DSPAM:4d781075231856171720384!




-- 
If you have eight hours to chop down a tree
spend six sharpening your axe.
--Abraham Lincoln



Re: [rt-users] I can't authenticate via LDAP; I don't see the log messages I expect

2011-03-09 Thread Micah R Ledbetter
THANK YOU! This worked for me - I am now getting a lot more stuff logged to
rt.log!

What I did, in detail: 

- I removed what CPAN had installed to /opt/rt3/local/plugins
- I downloaded and installed the dev release of external auth
- I installed it via `perl Makefile.PL; make; make install`
- I removed the default RT_SiteConfig.pm it created in 
  /opt/rt3/local/plugins/RT-Authen-ExternalAuth/etc

Now my each failed login produces these lines in rt.log: 
 

-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jason Ledford
Sent: Tuesday, March 08, 2011 18:48
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] I can't authenticate via LDAP; I don't see the log
messages I expect

I am using rt 3.8.9, but I had to update to the dev release of external auth
http://search.cpan.org/CPAN/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0
.08_01.tar.gz

I was getting results like you, or lack of results.  It didn't appear to
even be loading the plugin.


From: rt-users-boun...@lists.bestpractical.com
[rt-users-boun...@lists.bestpractical.com] On Behalf Of Micah R Ledbetter
[mledbet...@neuric.com]
Sent: Tuesday, March 08, 2011 3:24 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] I can't authenticate via LDAP;  I don't see the log
messages I expect

Hi all,

I'm having a problem making RT::Authen::ExternalAuth work with LDAP.
Furthermore, when I go to the log to find out what's wrong, I see almost
nothing there.

I'm on Ubuntu 10.04.1, running RT 3.8.8 installed from source to /opt/rt3,
and RT::Authen::ExternalAuth 0.08 installed from CPAN via this command:
 PERL5LIB=/opt/rt3/lib cpan RT::Authen::ExternalAuth

Here is my RT_SiteConfig.pm: http://pastie.org/1648532


I can log in as root, or any other locally-created user. When I do, I get a
message to rt.log that looks like this:
 [Tue Mar  8 19:46:18 2011] [info]: Successful login for root from \
 192.168.55.133 (/opt/rt3/bin/../lib/RT/Interface/Web.pm:430)

I cannot log in as any of my Active Directory users. When I do, or when I
send a known-bad username/password combination, I get a message to rt.log
that looks like this:
 [Tue Mar  8 19:45:55 2011] [error]: FAILED LOGIN for mledbetter from \
 192.168.55.133 (/opt/rt3/bin/../lib/RT/Interface/Web.pm:424)

Those are the only messages that are EVER logged to the log file. I didn't
even realize that there were more things that RT would log, until I ran
across this message:
http://lists.bestpractical.com/pipermail/rt-users/2010-August/065986.html

Why can I not see those log messages? I would very much appreciate help in
this regard, because if I could just solve that problem I think I could fix
the Active Directory problem myself.

Note that when I log in as root (which works because, of course, root is a
local user, not an AD user), I can go to the System Configuration page.

There, in the RT Configuration section, I see this line:
 Plugins   RT::Authen::ExternalAuthsite config
And in the Loaded perl modules section, I see this line:
 RT::Interface::Web::Request   0.30\
 /opt/rt3/bin/../lib/RT/Interface/Web/Request.pm


I'm not sure where to go from here, and I'd appreciate any input. I'd also
like to thank trs and jibsheet for helping me on IRC.

- Micah




Re: [rt-users] I can't authenticate via LDAP; I don't see the log messages I expect

2011-03-09 Thread Micah R Ledbetter
YES! This worked, thank you so much!

In detail, here's what I did. 

- I removed everything that CPAN had put in /opt/rt3/local/plugins
- I downloaded the dev release of external auth
- I installed it with a simple `perl Makefile.PL; make; make install`
- I removed the example RT_SiteConfig.pm that was created in 
  /opt/rt3/local/plugins/RT-Authen-ExternalAuth/etc/

Now my logs are full of [debug] lines that pointed me in the right
direction, and now Active Directory authentication is finally working.  

Thanks again. 

Should I file a bug report somewhere with what happened? I'd be happy to if
it would be helpful for someone. 

- Micah


-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Jason Ledford
Sent: Tuesday, March 08, 2011 18:48
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] I can't authenticate via LDAP; I don't see the log
messages I expect

I am using rt 3.8.9, but I had to update to the dev release of external auth
http://search.cpan.org/CPAN/authors/id/F/FA/FALCONE/RT-Authen-ExternalAuth-0
.08_01.tar.gz

I was getting results like you, or lack of results.  It didn't appear to
even be loading the plugin.


From: rt-users-boun...@lists.bestpractical.com
[rt-users-boun...@lists.bestpractical.com] On Behalf Of Micah R Ledbetter
[mledbet...@neuric.com]
Sent: Tuesday, March 08, 2011 3:24 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] I can't authenticate via LDAP;  I don't see the log
messages I expect

Hi all,

I'm having a problem making RT::Authen::ExternalAuth work with LDAP.
Furthermore, when I go to the log to find out what's wrong, I see almost
nothing there.

I'm on Ubuntu 10.04.1, running RT 3.8.8 installed from source to /opt/rt3,
and RT::Authen::ExternalAuth 0.08 installed from CPAN via this command:
 PERL5LIB=/opt/rt3/lib cpan RT::Authen::ExternalAuth

Here is my RT_SiteConfig.pm: http://pastie.org/1648532


I can log in as root, or any other locally-created user. When I do, I get a
message to rt.log that looks like this:
 [Tue Mar  8 19:46:18 2011] [info]: Successful login for root from \
 192.168.55.133 (/opt/rt3/bin/../lib/RT/Interface/Web.pm:430)

I cannot log in as any of my Active Directory users. When I do, or when I
send a known-bad username/password combination, I get a message to rt.log
that looks like this:
 [Tue Mar  8 19:45:55 2011] [error]: FAILED LOGIN for mledbetter from \
 192.168.55.133 (/opt/rt3/bin/../lib/RT/Interface/Web.pm:424)

Those are the only messages that are EVER logged to the log file. I didn't
even realize that there were more things that RT would log, until I ran
across this message:
http://lists.bestpractical.com/pipermail/rt-users/2010-August/065986.html

Why can I not see those log messages? I would very much appreciate help in
this regard, because if I could just solve that problem I think I could fix
the Active Directory problem myself.

Note that when I log in as root (which works because, of course, root is a
local user, not an AD user), I can go to the System Configuration page.

There, in the RT Configuration section, I see this line:
 Plugins   RT::Authen::ExternalAuthsite config
And in the Loaded perl modules section, I see this line:
 RT::Interface::Web::Request   0.30\
 /opt/rt3/bin/../lib/RT/Interface/Web/Request.pm


I'm not sure where to go from here, and I'd appreciate any input. I'd also
like to thank trs and jibsheet for helping me on IRC.

- Micah




Re: [rt-users] I can't authenticate via LDAP; I don't see the log messages I expect

2011-03-09 Thread Thomas Sibley
On 09 Mar 2011 19:25, Micah R Ledbetter wrote:
 Should I file a bug report somewhere with what happened? I'd be happy to if
 it would be helpful for someone. 

What RT version are you actually running?

You claimed RT 3.8.8, but ExternalAuth 0.08 is known to work with that
and upgrading to ExternalAuth 0.08_01 shouldn't have mattered for 3.8.8.

Thomas


Re: [rt-users] Need assistance with rt authentication to Active Directory

2011-03-09 Thread Thomas Sibley
On 09 Mar 2011 17:57, m0bilitee wrote:
 Hi folks, I'm trying to run rt 3.8.9 on CentOS 5.5, talking to Active
 Directory on a Windows Server 2003 domain controller.  I followed the
 guide at the wiki
 at http://requesttracker.wikia.com/wiki/CentOS5InstallPlusSome and got
 everything working up to the external plugin.

RT 3.8.9 broke version 0.08 of ExternalAuth.  0.08_01 is the developer
release which fixes the issue.  You probably have 0.08.

http://search.cpan.org/~falcone/RT-Authen-ExternalAuth-0.08_01/

Thomas