[rt-users] Missing dependencies in RT3.8.1?

2008-09-04 Thread Paul Goffin
I've just done a fresh install of 3.8.1 and found the graphing functions 
didn't work.

make testdeps of our old version, 3.6.6 indicated various GD packages were 
necessary but 3.8.1 does not do this.

Manually installing the GD packages indicated by 3.6.6 fixed the graphs.

Paul Goffin___
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] Charset issues after upgrade to 3.8.1

2008-09-04 Thread Gian Luca Gobbi
Hi,
you must add/change this lines in your my.cnf:
 
[client]
default-character-set = utf8 
 
[mysqld]
default-character-set=utf8
character_set_server=utf8
collation_server=utf8_general_ci
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET CHARACTER_SET utf8'
init_connect='SET NAMES utf8'
 
[mysql]
default-character-set=utf8
 
Stop/start you mysqld and you have:
 
mysql show variables like 'c%';
+--++
| Variable_name| Value  |
+--++
| character_set_client | utf8   | 
| character_set_connection | utf8   | 
| character_set_database   | utf8   | 
| character_set_filesystem | binary | 
| character_set_results| utf8   | 
| character_set_server | utf8   | 
| character_set_system | utf8   | 
| character_sets_dir   | /usr/share/mysql/charsets/ | 
| collation_connection | utf8_general_ci| 
| collation_database   | utf8_general_ci| 
| collation_server | utf8_general_ci| 
| completion_type  | 0  | 
| concurrent_insert| 1  | 
| connect_timeout  | 10 | 
+--++
14 rows in set (0.00 sec)


After these modifications all works well.

--
Gian Luca Gobbi 

 



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of BALINT Bekeny
Sent: Wednesday, September 03, 2008 11:07 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Charset issues after upgrade to 3.8.1


Hi,

I reported the same problem here (but nobody answered):
http://lists.bestpractical.com/pipermail/rt-users/2008-August/053512.html

I think there is a lack in the mysql upgrade document or in the upgrade script.
I did it on a test environment and didn't have time to find out the real 
solution,
so I delayed the migration of the real system.

Some more information:
- After migration, new entries (for example CF-s) seemed good, even if they 
have non-ascii characters.
- In mysql CLI:   show variables like 'c%'   shows that everything is utf8 (so 
this seems good)

Any suggestion?

Thanks,
--
Bekény



On Tue, Sep 2, 2008 at 5:28 PM, Emmanuel Lacour [EMAIL PROTECTED] wrote:


On Tue, Sep 02, 2008 at 08:14:55AM -0700, F350 wrote:

 Thanks a lot for your help and time Emmanuel.
 I updated all the tickets, CF and templates that look corrupted.
 Next time i'll make sure I do the updates on a test server :)



You're welcome :)

Using a test server or a test db/rt instance is a must have ;)

___



___
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] Missing dependencies in RT3.8.1?

2008-09-04 Thread Jason Doran

Hi Paul,
From memory on my CentOS machine I had to make sure that I
had following:

rpm -qa|grep graphviz

graphviz-devel-2.20.2-1.el5
graphviz-perl-2.20.2-1.el5
graphviz-2.20.2-1.el5

I then configured RT with:

  --enable-graphviz   Turns on support for RT's GraphViz  
dependency charts
  --enable-gd Turns on support for RT's GD pie and bar  
charts



Under links section I then got a graph button/link.


Regards,
Jason


On 4 Sep 2008, at 07:29, Paul Goffin wrote:



I've just done a fresh install of 3.8.1 and found the graphing  
functions didn't work.


make testdeps of our old version, 3.6.6 indicated various GD  
packages were necessary but 3.8.1 does not do this.


Manually installing the GD packages indicated by 3.6.6 fixed the  
graphs.


Paul Goffin___
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

[rt-users] urgent: Connect Failed received invalid response to SSL negotiation

2008-09-04 Thread Hakan Kaya
Please help me, I am not a perl nor Pg expert. After a restart,
request-tracker 3.6.1 on Debian etch stopped working. The complete error
message is this:
Connect Failed received invalid response to SSL negotiation: F\n\n at
/usr/share/request-tracker3.6/lib/RT.pm line 176\n

I have tried to figure out where to switch off SSL off but could not find
it.
How can I get this working again?

Thanks for your valued assistance.

H. Kaya
___
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] urgent: Connect Failed received invalid response to SSL negotiation

2008-09-04 Thread Emmanuel Lacour
On Thu, Sep 04, 2008 at 12:20:00PM +0200, Hakan Kaya wrote:
 Please help me, I am not a perl nor Pg expert. After a restart,
 request-tracker 3.6.1 on Debian etch stopped working. The complete error
 message is this:
 Connect Failed received invalid response to SSL negotiation: F\n\n at
 /usr/share/request-tracker3.6/lib/RT.pm line 176\n
 
 I have tried to figure out where to switch off SSL off but could not find
 it.
 How can I get this working again?
 

There is a variable in RT config file: DatabaseRequireSSL, you can try
to disable it (set to 0 or undef) if your databse isn't configured for
SSL connections.

___
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] Charset issues after upgrade to 3.8.1

2008-09-04 Thread F350

Are u sure it is the way to do ? In the Upgrading.mysql help file, they say
that the default charset should not be utf-8. In my database, all my tables
are set as utf-8 but the default charset of the database is latin1.


Gian Luca Gobbi wrote:
 
 Hi,
 you must add/change this lines in your my.cnf:
  
 [client]
 default-character-set = utf8 
  
 [mysqld]
 default-character-set=utf8
 character_set_server=utf8
 collation_server=utf8_general_ci
 init_connect='SET collation_connection = utf8_general_ci'
 init_connect='SET CHARACTER_SET utf8'
 init_connect='SET NAMES utf8'
  
 [mysql]
 default-character-set=utf8
  
 Stop/start you mysqld and you have:
  
 mysql show variables like 'c%';
 +--++
 | Variable_name| Value  |
 +--++
 | character_set_client | utf8   | 
 | character_set_connection | utf8   | 
 | character_set_database   | utf8   | 
 | character_set_filesystem | binary | 
 | character_set_results| utf8   | 
 | character_set_server | utf8   | 
 | character_set_system | utf8   | 
 | character_sets_dir   | /usr/share/mysql/charsets/ | 
 | collation_connection | utf8_general_ci| 
 | collation_database   | utf8_general_ci| 
 | collation_server | utf8_general_ci| 
 | completion_type  | 0  | 
 | concurrent_insert| 1  | 
 | connect_timeout  | 10 | 
 +--++
 14 rows in set (0.00 sec)
 
 
 After these modifications all works well.
 
 --
 Gian Luca Gobbi 
 
  
 
 
 
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of BALINT
 Bekeny
 Sent: Wednesday, September 03, 2008 11:07 AM
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Charset issues after upgrade to 3.8.1
 
 
 Hi,
 
 I reported the same problem here (but nobody answered):
 http://lists.bestpractical.com/pipermail/rt-users/2008-August/053512.html
 
 I think there is a lack in the mysql upgrade document or in the upgrade
 script.
 I did it on a test environment and didn't have time to find out the real
 solution,
 so I delayed the migration of the real system.
 
 Some more information:
 - After migration, new entries (for example CF-s) seemed good, even if
 they have non-ascii characters.
 - In mysql CLI:   show variables like 'c%'   shows that everything is utf8
 (so this seems good)
 
 Any suggestion?
 
 Thanks,
 --
 Bekény
 
 
 
 On Tue, Sep 2, 2008 at 5:28 PM, Emmanuel Lacour [EMAIL PROTECTED]
 wrote:
 
 
   On Tue, Sep 02, 2008 at 08:14:55AM -0700, F350 wrote:
   
Thanks a lot for your help and time Emmanuel.
I updated all the tickets, CF and templates that look corrupted.
Next time i'll make sure I do the updates on a test server :)
   
   
   
   You're welcome :)
   
   Using a test server or a test db/rt instance is a must have ;)
   
   ___
   
 
 
 ___
 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
 
 

-- 
View this message in context: 
http://www.nabble.com/Charset-issues-after-upgrade-to-3.8.1-tp19267620p19308775.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: [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] Charset issues after upgrade to 3.8.1

2008-09-04 Thread F350

Here is a sample of my custom fields table schema:
CREATE TABLE `CustomFields` (
  `id` int(11) NOT NULL auto_increment,
  `Name` varchar(200) default NULL,
  `Type` varchar(200) character set ascii default NULL,
  `MaxValues` int(11) default NULL,
  `Pattern` text,
  `Repeated` smallint(6) NOT NULL default '0',
  `Description` varchar(255) default NULL,
  `SortOrder` int(11) NOT NULL default '0',
  `LookupType` varchar(255) character set ascii NOT NULL,
  `Creator` int(11) NOT NULL default '0',
  `Created` datetime default NULL,
  `LastUpdatedBy` int(11) NOT NULL default '0',
  `LastUpdated` datetime default NULL,
  `Disabled` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Can someone tell me if the schema is correct ? When comparing the old
database version (3.8.0) and the new one (3.8.1) I found no differences in
the schema even after applying the script.

Thanks

F350 wrote:
 
 Are u sure it is the way to do ? In the Upgrading.mysql help file, they
 say that the default charset should not be utf-8. In my database, all my
 tables are set as utf-8 but the default charset of the database is latin1.
 
 
 Gian Luca Gobbi wrote:
 
 Hi,
 you must add/change this lines in your my.cnf:
  
 [client]
 default-character-set = utf8 
  
 [mysqld]
 default-character-set=utf8
 character_set_server=utf8
 collation_server=utf8_general_ci
 init_connect='SET collation_connection = utf8_general_ci'
 init_connect='SET CHARACTER_SET utf8'
 init_connect='SET NAMES utf8'
  
 [mysql]
 default-character-set=utf8
  
 Stop/start you mysqld and you have:
  
 mysql show variables like 'c%';
 +--++
 | Variable_name| Value  |
 +--++
 | character_set_client | utf8   | 
 | character_set_connection | utf8   | 
 | character_set_database   | utf8   | 
 | character_set_filesystem | binary | 
 | character_set_results| utf8   | 
 | character_set_server | utf8   | 
 | character_set_system | utf8   | 
 | character_sets_dir   | /usr/share/mysql/charsets/ | 
 | collation_connection | utf8_general_ci| 
 | collation_database   | utf8_general_ci| 
 | collation_server | utf8_general_ci| 
 | completion_type  | 0  | 
 | concurrent_insert| 1  | 
 | connect_timeout  | 10 | 
 +--++
 14 rows in set (0.00 sec)
 
 
 After these modifications all works well.
 
 --
 Gian Luca Gobbi 
 
  
 
 
 
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of BALINT
 Bekeny
 Sent: Wednesday, September 03, 2008 11:07 AM
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Charset issues after upgrade to 3.8.1
 
 
 Hi,
 
 I reported the same problem here (but nobody answered):
 http://lists.bestpractical.com/pipermail/rt-users/2008-August/053512.html
 
 I think there is a lack in the mysql upgrade document or in the upgrade
 script.
 I did it on a test environment and didn't have time to find out the real
 solution,
 so I delayed the migration of the real system.
 
 Some more information:
 - After migration, new entries (for example CF-s) seemed good, even if
 they have non-ascii characters.
 - In mysql CLI:   show variables like 'c%'   shows that everything is
 utf8 (so this seems good)
 
 Any suggestion?
 
 Thanks,
 --
 Bekény
 
 
 
 On Tue, Sep 2, 2008 at 5:28 PM, Emmanuel Lacour [EMAIL PROTECTED]
 wrote:
 
 
  On Tue, Sep 02, 2008 at 08:14:55AM -0700, F350 wrote:
  
   Thanks a lot for your help and time Emmanuel.
   I updated all the tickets, CF and templates that look corrupted.
   Next time i'll make sure I do the updates on a test server :)
  
  
  
  You're welcome :)
  
  Using a test server or a test db/rt instance is a must have ;)
  
  ___
  
 
 
 ___
 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
 
 
 
 

-- 
View this message in context: 
http://www.nabble.com/Charset-issues-after-upgrade-to-3.8.1-tp19267620p19308784.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: [EMAIL PROTECTED]


Discover RT's 

[rt-users] GPG inbound decrypt/verify problems in RT 3.8.1

2008-09-04 Thread Tim Wilde
Greetings all!

I've been running into a very strange decrypt/verify problem with
inbound GPG mail in RT 3.8.1.  The problem seems to be the same with
both PGP/MIME and inline PGP, though I've been mostly testing with
inline PGP.  RT gets the inbound message, and all of the GPG
infrastructure appears to be set up correctly, but encrypted messages
get NODATA 1 and NODATA 2 back from GPG, and signed-only messages
get BADSIG back.  However, when I look in /tmp, I can see the temp
files that RT creates with the appropriate body parts (based on their
contents and the timestamps), and when I pass them through command-line
gpg, using the same homedir and other options that I pass in my RT
config, it can decrypt/verify them just fine!

As far as I can tell from some testing, it seems that something wonky is
happening with the file handles that are getting passed around - I just
can't figure out what!  If I strip out even one character from those
temp files I found, and run them through command-line gpg, I get the
same results that RT gets.

I have verified that GPG encryption works outbound - I can send an
encrypted message from the queue, and it is encrypted with the
appropriate keys.

RT is 3.8.1, GnuPG::Interface is 0.36, gpg is 1.2.6 (working on getting
that upgraded, though it doesn't seem a likely culprit), Apache is
2.2.9, mod_perl is 2.0.

GnuPG options in RT_SiteConfig.pm:

Set( %GnuPG,
Enable=1,
OutgoingMessagesFormat='RFC',
AllowEncryptDataInDB=0,
);
Set( %GnuPGOptions,
'passphrase'='mypassphrasehere',
'no-permission-warning'=undef,
'homedir'='var/data/gpg',
);
Set(@MailPlugins, 'Auth::MailFrom', 'Auth::GnuPG',
);

My GPG keyrings are in var/data/gpg relative to the RT root, and all my
command-line testing of temp files has used those same keyrings for
consistency.

Debug log entries from encrypted inbound message:

[Thu Sep  4 14:35:03 2008] [debug]: Found encrypted inline part
(/usr/local/rt-3.8.1/bin/../local/lib/RT/Crypt/GnuPG.pm:883)
[Thu Sep  4 14:35:03 2008] [debug]: [GNUPG:] NODATA 1
[GNUPG:] NODATA 2
(/usr/local/rt-3.8.1/bin/../local/lib/RT/Crypt/GnuPG.pm:1313)
[Thu Sep  4 14:35:03 2008] [error]: gpg: no valid OpenPGP data found.
gpg: decrypt_message failed: eof
(/usr/local/rt-3.8.1/bin/../local/lib/RT/Crypt/GnuPG.pm:1315)
[Thu Sep  4 14:35:03 2008] [debug]: Found GnuPG protected parts
(/usr/local/rt-3.8.1/bin/../lib/RT/Interface/Email/Auth/GnuPG.pm:234)
[Thu Sep  4 14:35:03 2008] [debug]: Error during verify/decrypt
operation
(/usr/local/rt-3.8.1/bin/../lib/RT/Interface/Email/Auth/GnuPG.pm:238)
[Thu Sep  4 14:35:03 2008] [error]: Had a problem during decrypting and
verifying
(/usr/local/rt-3.8.1/bin/../lib/RT/Interface/Email/Auth/GnuPG.pm:97)
[Thu Sep  4 14:35:03 2008] [error]: Couldn't process a message: No data
has been found. The reason is 'No armored data', No data has been found.
The reason is 'Expected a packet, but did not found one'
(/usr/local/rt-3.8.1/bin/../lib/RT/Interface/Email/Auth/GnuPG.pm:204)
[Thu Sep  4 14:35:04 2008] [debug]: Converting 'ISO-8859-1' to 'utf-8'
for text/plain - encrypted test
(/usr/local/rt-3.8.1/bin/../lib/RT/I18N.pm:231)

Same debug log section from signed inbound message:

[Thu Sep  4 14:35:37 2008] [debug]: Found signed inline part
(/usr/local/rt-3.8.1/bin/../local/lib/RT/Crypt/GnuPG.pm:883)
[Thu Sep  4 14:35:37 2008] [debug]: [GNUPG:] BADSIG 96E45B46redacted Tim
Wilde [EMAIL PROTECTED]
(/usr/local/rt-3.8.1/bin/../local/lib/RT/Crypt/GnuPG.pm:1313)
[Thu Sep  4 14:35:37 2008] [error]: gpg: Signature made Thu Sep  4
14:35:35 2008 GMT using DSA key ID redacted
gpg: BAD signature from Tim Wilde [EMAIL PROTECTED]
(/usr/local/rt-3.8.1/bin/../local/lib/RT/Crypt/GnuPG.pm:1315)
[Thu Sep  4 14:35:37 2008] [debug]: Found GnuPG protected parts
(/usr/local/rt-3.8.1/bin/../lib/RT/Interface/Email/Auth/GnuPG.pm:234)
[Thu Sep  4 14:35:37 2008] [debug]: Error during verify/decrypt
operation
(/usr/local/rt-3.8.1/bin/../lib/RT/Interface/Email/Auth/GnuPG.pm:238)
[Thu Sep  4 14:35:37 2008] [error]: Had a problem during decrypting and
verifying
(/usr/local/rt-3.8.1/bin/../lib/RT/Interface/Email/Auth/GnuPG.pm:97)
[Thu Sep  4 14:35:37 2008] [debug]: Converting 'ISO-8859-1' to 'utf-8'
for text/plain - Subjectless message
(/usr/local/rt-3.8.1/bin/../lib/RT/I18N.pm:231)

Note that the second message did have a subject, signed test, I don't
know if the fact that RT thinks it was subjectless is relevant or not.

Is it possible that all of this has something to do with specifying the
passphrase in the config (verified multiple times to be the correct
passphrase for the secret key for the queue, by the way) rather than
using the agent?

Based on the other threads here in the archives, I hope this is all the
information needed to take a peek at this.  Again, for both of the
specific messages for which I pasted debug entries here, I have files in
/tmp with the exact body content, which, when passed in to command-line
gpg, work just fine.  I'm at my wit's end, to be 

[rt-users] automatic take

2008-09-04 Thread Joshua N Pritikin
Suppose there is a new unassigned ticket. Suppose I reply to the ticket 
via email. Is there some way for my RT account to automatically take the 
ticket? If so, how?

If this is a bad idea, why?
___
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] automatic take

2008-09-04 Thread Tim Cutts

On 4 Sep 2008, at 4:05 pm, Joshua N Pritikin wrote:

 Suppose there is a new unassigned ticket. Suppose I reply to the  
 ticket
 via email. Is there some way for my RT account to automatically take  
 the
 ticket? If so, how?


We have this set up.

You need to add a Scrip to do it.  We have a Global scrip called  
AutoTakeOnCorrespond, which has the following custom action.  You'll  
notice there are some parts of it (particularly the line about the  
syshelp queue) which are specific to our site, so you will want to  
change parts of it.

my $correspondent = $self-TransactionObj-Creator;

# don't auto-take for root
return 1 if $correspondent == $RT::SystemUser-id;

# only auto-take if owned by Nobody
return 1 unless $self-TicketObj-Owner == $RT::Nobody-id;

# don't auto-take tickets in syshelp
return 1 if $self-TicketObj-QueueObj-Name eq 'syshelp';

# don't auto-take if correspondent is requestor
# see http://wiki.bestpractical.com/index.cgi?OnCreateSetDeptHeadCc
my $rgobj = $self-TicketObj-Requestors;
my $rmobj = $rgobj-UserMembersObj;
my $uobj;
while ($uobj = $rmobj-Next) {
   if ($uobj-PrincipalObj-Id == $correspondent) {
 $RT::Logger-info(Not auto-assigning ticket # .  $self- 
 TicketObj-id .  to its requestor);
 return 1;
   }
}

$RT::Logger-info(Auto assign ticket #. $self-TicketObj-id . to  
user #. $correspondent );
my ($status, $msg) = $self-TicketObj-SetOwner( $correspondent );
unless( $status ) {
   $RT::Logger-error( Impossible to assign ticket to $correspondent:  
$msg );
   return undef;
}
return 1;



-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE. 
___
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] Separate permission

2008-09-04 Thread Kenneth Crocker
Kevin,


My situation is that these queues are completely seperate support 
groups and very seldom do they work on the same issue. This is for those 
tickets where one support group needs another group to complete their 
work in order for the first group to complete theirs. The DependsOn 
link is perfect, but to do that, I have to allow the ModifyTicket 
right for group1 to a queue they normally do not touch. Not very secure. 
But thanks.


Kenn
LBNL

On 8/29/2008 4:46 PM, Kevin Falcone wrote:
 On Aug 29, 2008, at 4:55 PM, Kenneth Crocker wrote:
 
  I'm not using 3.8 yet, but I was hoping that perhaps the permissions
 had been modified a bit to allow a user from one queue to link his
 ticket to a ticket in another queue without having to have the
 ModifyTicket privilege. I have many queues that could have their
 tickets linked to tickets in other queues, but don't want the support
 personnel of those other queues to be able to modify tickets in their
 own. Does that make any sense?
 
 I can't tell if you don't want to hand out ModifyTicket to these
 users at all or if you're ok letting them have ModifyTicket in their
 own queue.
 
 If the latter, StrictLinkACL in your config may help.
 
 If the former, there is some rather tangled code that would
 need untangling to do what you want.
 
 -kevin
 ___
 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


[rt-users] canned replies with attachment

2008-09-04 Thread Ruben Lehmann
Hi

Is it possible to have attachments directly attached to a template. So
if I choose this template as canned reply the attachment will be
attached as well?

Thanks Ruben


Monzoon Networks AG
Ruben Lehmann

--
Nomadic Workers - hotspot.monzoon.net
Wireless Internet - home.monzoon.net
Surf the safer way - www.swissvpn.net
--

___
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] canned replies with attachment

2008-09-04 Thread Jerrad Pierce
On Thu, Sep 4, 2008 at 11:46, Ruben Lehmann [EMAIL PROTECTED] wrote:

 Hi

 Is it possible to have attachments directly attached to a template. So if I
 choose this template as canned reply the attachment will be
 attached as well?

I would suggest that the proper way to handle this is to provide a URI to
the documents instead.
-- 
Cambridge Energy Alliance: Save money  the planet
___
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 upgrade from 3.6.2 - 3.8.1 - No longer seems to be looking at the Requestor Permisions

2008-09-04 Thread Kris Lindgren
Hello,

 

We have had a couple queues that have been setup and working fine for a
while now, however after the upgrade to 3.8.1 we have ran into an issue.
Anyone can open a ticket in the queue via email, however once they have
opened the ticket they cannot reply to the ticket.  The permissions on
the queue are setup as follows:

 

System Groups:

 Unprivileged: none

 Privileged: none

 Everyone: Create Ticket

 

Roles:

Requestor:  ReplyToTicket, ShowTicket

Owner: AssignCustomFields, CommentOnTicket, ModifyACL,
ModifyQueueWatchers, ModifyTicket, ReplyToTicket, SeeQueue, ShowACL,
ShowOutgoingEmail, ShowScrips, ShowTemplate, ShowTicket,
ShowTicketComments, Watch, WatchAsAdminCc

AdminCC:  has the same permissions as Owner

 

Then we have our own User Defined Groups however that shouldn't play a
role in this as the user that created the ticket is unprivileged.

 

If I modified the Everyone Permissions to include ReplyToTicket then the
user that created the ticket can reply to the ticket without issue.

 

Under the People portion of the Ticket information it does correctly
list the user that created the ticket as the Requestor.

 

The email that is given back to the user is the following:

 

Message not recorded: RE: [Data393 #4554] Testing, permission denied.

 

From the rt.log:

[Wed Sep  3 21:51:52 2008] [crit]: Permission Denied
(/opt/rt3/bin/../lib/RT/Interface/Email.pm:244)

[Wed Sep  3 21:51:52 2008] [error]: Could not record email: Message not
recorded: Permission Denied (/opt/rt3/share/html/REST/1.0/No

Auth/mail-gateway:75)

 

 

One other thing I am getting a bunch of errors in the log file:

[Thu Sep  4 13:28:32 2008] [warning]: RT::Handle=HASH(0xbae51be0)
couldn't execute the query 'SELECT ACL.id FROM ACL, Groups, Princi

pals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR
ACL.RightName = 'CreateTicket') AND Principals.Disabled = 0 AND Cache

dGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND
Principals.PrincipalType = 'Group' AND Principals.id = CachedGroupMembe

rs.GroupId AND CachedGroupMembers.MemberId = 5000 AND ACL.PrincipalType
= Groups.Type  AND ((ACL.ObjectType = 'RT::System' AND ACL.O

bjectId = 1) OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = 6)) AND
Groups.Domain = 'RT::System-Role' AND Groups.Instance = '1'

 LIMIT 1' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 518

 

Which as I understand means I need to run the mysql schema script.  The
output of that script is as follows:

 

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

Use of uninitialized value in numeric gt () at schema.mysql-4.0-4.1.pl
line 311.

ALTER DATABASE rt DEFAULT CHARACTER SET utf8;

ALTER TABLE ACL DEFAULT CHARACTER SET utf8;

ALTER TABLE Attachments DEFAULT CHARACTER SET utf8;

ALTER TABLE Attachments MODIFY Content CHAR NULL DEFAULT NULL;

ALTER TABLE Attributes DEFAULT CHARACTER SET utf8;

ALTER TABLE Attributes MODIFY Content CHAR NULL DEFAULT NULL;

ALTER TABLE CustomFields DEFAULT CHARACTER SET utf8;

ALTER TABLE CustomFieldValues DEFAULT CHARACTER SET utf8;

ALTER TABLE GroupMembers DEFAULT CHARACTER SET utf8;

ALTER TABLE Groups DEFAULT CHARACTER SET utf8;

ALTER TABLE Links DEFAULT CHARACTER SET utf8;

ALTER TABLE ObjectCustomFields DEFAULT CHARACTER SET utf8;

ALTER TABLE ObjectCustomFieldValues DEFAULT CHARACTER SET utf8;

ALTER TABLE ObjectCustomFieldValues MODIFY LargeContent CHAR NULL
DEFAULT NULL;

ALTER TABLE Principals DEFAULT CHARACTER SET utf8;

ALTER TABLE Queues DEFAULT CHARACTER SET utf8;

ALTER TABLE ScripActions DEFAULT CHARACTER SET utf8;

ALTER TABLE ScripActions MODIFY Argument CHAR NULL DEFAULT NULL;

ALTER TABLE ScripConditions DEFAULT CHARACTER SET utf8;

ALTER TABLE ScripConditions MODIFY Argument CHAR NULL DEFAULT NULL;

ALTER TABLE Scrips DEFAULT CHARACTER SET utf8;

ALTER TABLE sessions DEFAULT CHARACTER SET utf8;

ALTER TABLE sessions MODIFY id CHAR NOT NULL DEFAULT '';

ALTER TABLE sessions MODIFY a_session CHAR NULL DEFAULT NULL;

ALTER TABLE Templates DEFAULT CHARACTER SET utf8;

ALTER TABLE Tickets DEFAULT CHARACTER SET utf8;

ALTER TABLE Transactions DEFAULT CHARACTER SET utf8;

ALTER TABLE Users DEFAULT CHARACTER SET utf8;

ALTER TABLE Users MODIFY PGPKey CHAR NULL DEFAULT NULL;

ALTER TABLE Users MODIFY Password CHAR NULL DEFAULT NULL;

 

If I run the script against the MYSQL database I get the following mysql

[rt-users] Extension CommandByMail

2008-09-04 Thread Reginaldo Russinholi
Hi all,

I'm using RT 3.6.6 and I'd like to use the extension CommandByMail.

Well, I downloaded the source and follow the instrunctions to install, 
but I didn't understand in what file and in what part of that file I 
have to put the CommandByMail configuration.

Any help?


Regards,


Reginaldo Russinholi
Developer/Sys.Adm.
IRapida Telecom
___
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] [patch] GPG inbound decrypt/verify problems in RT 3.8.1

2008-09-04 Thread Tim Wilde
Tim Wilde wrote:
[ snip ]
 Is it possible that all of this has something to do with specifying the
 passphrase in the config (verified multiple times to be the correct
 passphrase for the secret key for the queue, by the way) rather than
 using the agent?
[ snip ]

Greetings again all!

Ding ding ding ding, we have a winner!  After far too many hours of
digging, I found something that didn't look quite right to me, changed
it, and viola, problem solved.

The attached patch to lib/RT/Crypt/GnuPG.pm should make operation with a
passphrase specified in RT_SiteConfig.pm actually work - without it, I
don't think it can work, at least not with gpg 1.2.6.  The passphrase
needs to be deleted out of %opt before it's passed to
_PrepareGnuPGOptions, otherwise it gets very very grumpy in ways that
don't even come close to immediately pointing back to the real cause.

I note there was an additional section of code dealing with
$args{'Passphrase'} right after the one I moved - I didn't move that to
the new location, since it doesn't seem to much matter which place it
exists.  I assume the intent of GetPassphrase() is to allow for
subclassing and/or local versions of the module to do more than return
'test' all the time?  Otherwise, that code probably doesn't need to be
there at all. :)  This should probably be mentioned in the documentation.

Finally, the area of this module that this patch modifies could use some
additional attention/cleanup - almost identical code, with very few
variations, occurs 8 times in the same source file, as far as I can
tell.  It shouldn't be too difficult to factor the options handling out
and make maintenance considerably easier.

Best Practical folks, please review and apply this patch (or an
appropriate variation thereof) to the next release so that others don't
have to dig through these problems for as many hours as we did!  Please
feel free to contact me if you have any further questions about it.

Thanks,
Tim Wilde
--- lib/RT/Crypt/GnuPG.pm   2008-08-29 15:50:00.0 +
+++ local/lib/RT/Crypt/GnuPG.pm 2008-09-04 19:45:39.0 +
@@ -435,6 +435,11 @@
 
 my $gnupg = new GnuPG::Interface;
 my %opt = RT-Config-Get('GnuPGOptions');
+
+# handling passphrase in GnuPGOptions
+$args{'Passphrase'} = delete $opt{'passphrase'}
+if !defined $args{'Passphrase'};
+
 $opt{'digest-algo'} ||= 'SHA1';
 $opt{'default_key'} = $args{'Signer'}
 if $args{'Sign'}  $args{'Signer'};
@@ -446,10 +451,6 @@
 
 my $entity = $args{'Entity'};
 
-# handling passphrase in GnuPGOptions
-$args{'Passphrase'} = delete $opt{'passphrase'}
-if !defined $args{'Passphrase'};
-
 if ( $args{'Sign'}  !defined $args{'Passphrase'} ) {
 $args{'Passphrase'} = GetPassphrase( Address = $args{'Signer'} );
 }
@@ -610,6 +611,11 @@
 
 my $gnupg = new GnuPG::Interface;
 my %opt = RT-Config-Get('GnuPGOptions');
+
+# handling passphrase in GnupGOptions
+$args{'Passphrase'} = delete $opt{'passphrase'}
+if !defined($args{'Passphrase'});
+
 $opt{'digest-algo'} ||= 'SHA1';
 $opt{'default_key'} = $args{'Signer'}
 if $args{'Sign'}  $args{'Signer'};
@@ -619,10 +625,6 @@
 meta_interactive = 0,
 );
 
-# handling passphrase in GnupGOptions
-$args{'Passphrase'} = delete $opt{'passphrase'}
-if !defined($args{'Passphrase'});
-
 if ( $args{'Sign'}  !defined $args{'Passphrase'} ) {
 $args{'Passphrase'} = GetPassphrase( Address = $args{'Signer'} );
 }
@@ -694,6 +696,11 @@
 
 my $gnupg = new GnuPG::Interface;
 my %opt = RT-Config-Get('GnuPGOptions');
+
+# handling passphrase in GnupGOptions
+$args{'Passphrase'} = delete $opt{'passphrase'}
+if !defined($args{'Passphrase'});
+
 $opt{'digest-algo'} ||= 'SHA1';
 $opt{'default_key'} = $args{'Signer'}
 if $args{'Sign'}  $args{'Signer'};
@@ -703,10 +710,6 @@
 meta_interactive = 0,
 );
 
-# handling passphrase in GnupGOptions
-$args{'Passphrase'} = delete $opt{'passphrase'}
-if !defined($args{'Passphrase'});
-
 if ( $args{'Sign'}  !defined $args{'Passphrase'} ) {
 $args{'Passphrase'} = GetPassphrase( Address = $args{'Signer'} );
 }
@@ -792,6 +795,11 @@
 
 my $gnupg = new GnuPG::Interface;
 my %opt = RT-Config-Get('GnuPGOptions');
+
+# handling passphrase in GnupGOptions
+$args{'Passphrase'} = delete $opt{'passphrase'}
+if !defined($args{'Passphrase'});
+
 $opt{'digest-algo'} ||= 'SHA1';
 $opt{'default_key'} = $args{'Signer'}
 if $args{'Sign'}  $args{'Signer'};
@@ -801,10 +809,6 @@
 meta_interactive = 0,
 );
 
-# handling passphrase in GnupGOptions
-$args{'Passphrase'} = delete $opt{'passphrase'}
-if !defined($args{'Passphrase'});
-
 if ( $args{'Sign'}  !defined $args{'Passphrase'} ) {
 $args{'Passphrase'} = GetPassphrase( Address = $args{'Signer'} );
 }
@@ -1131,6 +1135,11 @@
 

Re: [rt-users] Extension CommandByMail

2008-09-04 Thread Shawn M Moore
On Thu, Sep 04, 2008 at 01:59:06PM -0300, Reginaldo Russinholi wrote:
 Hi all,
 
 I'm using RT 3.6.6 and I'd like to use the extension CommandByMail.
 
 Well, I downloaded the source and follow the instrunctions to install, 
 but I didn't understand in what file and in what part of that file I 
 have to put the CommandByMail configuration.
 
 Any help?

Hi Reginaldo,

The config for CommandByMail goes in your RT_SiteConfig.pm file. If
you're using the standard layout, it'll be in /opt/rt3/etc.

Shawn

___
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] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread Helmuth Ramirez
Hi everyone,

A couple of my users noticed our newly upgraded version of RT (3.8.1)
handles the quick searches differently from past versions (3.6.3).  When
they perform a Quick Search, it does not search on Resolved tickets
anymore.  The quick search was how we were able to quickly pull up
historical resolved tickets.  Is this something I can turn on globally
somewhere?

 

Cheers!

 

Helmuth Ramirez

 

___
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] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread Jesse Vincent



On Thu, Sep 04, 2008 at 05:53:41PM -0400, Helmuth Ramirez wrote:
 Hi everyone,
 
 A couple of my users noticed our newly upgraded version of RT (3.8.1)
 handles the quick searches differently from past versions (3.6.3).  When
 they perform a Quick Search, it does not search on Resolved tickets
 anymore.  The quick search was how we were able to quickly pull up
 historical resolved tickets.  Is this something I can turn on globally
 somewhere?

I'd take a patch to make it configurable, but generally, we've found
that more often than not, users want to search current tickets quickly.
Limiting it to only open tickets makes the actual search much faster and
less cluttered.

 
  
 
 Cheers!
 
  
 
 Helmuth Ramirez
 
  
 

 ___
 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


Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread Helmuth Ramirez
I'd love to say I'd write the patch, but sadly Perl (or any coding for
that matter) is not my strong point.  Not from a lack of trying though,
I went out and bought a Perl book just to help me understand RT better
:)  Unfortunately I haven't used it yet :(

Oh well, I'll tell them they'll have to use the standard Tickets section
for their searches going forward.

Thanks Jesse for the quick response.
Helmuth

-Original Message-
From: Jesse Vincent [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 04, 2008 5:58 PM
To: Helmuth Ramirez
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved
Status




On Thu, Sep 04, 2008 at 05:53:41PM -0400, Helmuth Ramirez wrote:
 Hi everyone,
 
 A couple of my users noticed our newly upgraded version of RT (3.8.1)
 handles the quick searches differently from past versions (3.6.3).
When
 they perform a Quick Search, it does not search on Resolved tickets
 anymore.  The quick search was how we were able to quickly pull up
 historical resolved tickets.  Is this something I can turn on globally
 somewhere?

I'd take a patch to make it configurable, but generally, we've found
that more often than not, users want to search current tickets quickly.
Limiting it to only open tickets makes the actual search much faster and
less cluttered.

 
  
 
 Cheers!
 
  
 
 Helmuth Ramirez
 
  
 

 ___
 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


Re: [rt-users] Editing Comments or Replies

2008-09-04 Thread Jesse Vincent

 I don't really see a business reason for comments/replies not to be
 editable, as long as a record of edits were kept. You can argue that  
 the
 content of a reply or comment is data, not an audit trail entry.

If RT has sent it out by email, it can't be taken back.  Ticket  
replies or comments are a record of a conversation, rather than a  
notes field.

It's perfectly reasonable to set up a big text custom field for  
recording a cleaned up version of the ticket's data, but that's a  
very separate thing than the log of all history.

-j
___
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] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread Greg Evans
They can still search resolved by using a format like 'search term
resolved' I have the same issue, in which we need to search resolved tickets
as it makes it much easier to find someone since most of the people that
call us don't have a clue what their email is (hard to believe I know) or
have 10 different emails that they give us

Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Helmuth
Ramirez
Sent: Thursday, September 04, 2008 3:03 PM
To: Jesse Vincent
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved
Status

I'd love to say I'd write the patch, but sadly Perl (or any coding for
that matter) is not my strong point.  Not from a lack of trying though,
I went out and bought a Perl book just to help me understand RT better
:)  Unfortunately I haven't used it yet :(

Oh well, I'll tell them they'll have to use the standard Tickets section
for their searches going forward.

Thanks Jesse for the quick response.
Helmuth

-Original Message-
From: Jesse Vincent [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 04, 2008 5:58 PM
To: Helmuth Ramirez
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved
Status




On Thu, Sep 04, 2008 at 05:53:41PM -0400, Helmuth Ramirez wrote:
 Hi everyone,
 
 A couple of my users noticed our newly upgraded version of RT (3.8.1)
 handles the quick searches differently from past versions (3.6.3).
When
 they perform a Quick Search, it does not search on Resolved tickets
 anymore.  The quick search was how we were able to quickly pull up
 historical resolved tickets.  Is this something I can turn on globally
 somewhere?

I'd take a patch to make it configurable, but generally, we've found
that more often than not, users want to search current tickets quickly.
Limiting it to only open tickets makes the actual search much faster and
less cluttered.

 
  
 
 Cheers!
 
  
 
 Helmuth Ramirez
 
  
 

 ___
 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

___
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] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread Helmuth Ramirez
Thanks Greg for the tip.  That does work :)  And I completely understand where 
you're coming from.  On our end when we're searching for a ticket, 99% of the 
time its to look for something that's already been done/resolved (end users 
calling for status, etc).

Thanks
Helmuth


-Original Message-
From: Greg Evans [mailto:[EMAIL PROTECTED]
Sent: Thu 9/4/2008 6:42 PM
To: Helmuth Ramirez; 'Jesse Vincent'
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Quick Search in 3.8.1 doesn't include Resolved Status
 
They can still search resolved by using a format like 'search term
resolved' I have the same issue, in which we need to search resolved tickets
as it makes it much easier to find someone since most of the people that
call us don't have a clue what their email is (hard to believe I know) or
have 10 different emails that they give us

Greg Evans
Hood Canal Communications
(360) 898-2481 ext.212 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Helmuth
Ramirez
Sent: Thursday, September 04, 2008 3:03 PM
To: Jesse Vincent
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved
Status

I'd love to say I'd write the patch, but sadly Perl (or any coding for
that matter) is not my strong point.  Not from a lack of trying though,
I went out and bought a Perl book just to help me understand RT better
:)  Unfortunately I haven't used it yet :(

Oh well, I'll tell them they'll have to use the standard Tickets section
for their searches going forward.

Thanks Jesse for the quick response.
Helmuth

-Original Message-
From: Jesse Vincent [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 04, 2008 5:58 PM
To: Helmuth Ramirez
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved
Status




On Thu, Sep 04, 2008 at 05:53:41PM -0400, Helmuth Ramirez wrote:
 Hi everyone,
 
 A couple of my users noticed our newly upgraded version of RT (3.8.1)
 handles the quick searches differently from past versions (3.6.3).
When
 they perform a Quick Search, it does not search on Resolved tickets
 anymore.  The quick search was how we were able to quickly pull up
 historical resolved tickets.  Is this something I can turn on globally
 somewhere?

I'd take a patch to make it configurable, but generally, we've found
that more often than not, users want to search current tickets quickly.
Limiting it to only open tickets makes the actual search much faster and
less cluttered.

 
  
 
 Cheers!
 
  
 
 Helmuth Ramirez
 
  
 

 ___
 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


___
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] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread gordon
We are the same, much prefer searching for all unresolved and resolved 
tickets in the quick search. The change has caused quite a bit of abuse 
at the sysadmin (me).

Gordon


Helmuth Ramirez wrote:
 On our end when we're searching for a ticket, 
 99% of the time its to look for something that's already been 
 done/resolved (end users calling for status, etc).
 
 Thanks
 Helmuth
___
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] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread Jesse Vincent

On Sep 4, 2008, at 8:42 PM, [EMAIL PROTECTED] wrote:

 We are the same, much prefer searching for all unresolved and resolved
 tickets in the quick search. The change has caused quite a bit of  
 abuse
 at the sysadmin (me).

As I sad before, I'd love to take a patch :)

Best,
Jesse

 Gordon


 Helmuth Ramirez wrote:
 On our end when we're searching for a ticket,
 99% of the time its to look for something that's already been
 done/resolved (end users calling for status, etc).

 Thanks
 Helmuth
 ___
 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


Re: [rt-users] Quick Search in 3.8.1 doesn't include Resolved Status

2008-09-04 Thread jmoseley
Jessie, I guess it just depends on the size of the organization, how many
queues they have, and how many open tickets are open at a given time.  In
our environment, we have over 30,000 resolved tickets while we usually have
no more than a few dozen open in any given queue.  It makes much more sense
for our users to simply look at the open tickets in the queues they are
responsible for rather than actually perform a search.

When we perform a search, 99% of the time we are searching resolved
tickets, not open tickets.  In our environment, it makes much more sense to
have quick searches return results of resolved and open tickets.

Any thoughts (based upon feedback thus far) to simply reverting back to the
old way vs. a patch to make things configurable?


James Moseley





I'd take a patch to make it configurable, but generally, we've found
that more often than not, users want to search current tickets quickly.
Limiting it to only open tickets makes the actual search much faster and
less cluttered.



___
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] Privileges not honored for Everyone after 3.8.1 upgrade

2008-09-04 Thread RT
rt-users,

I recently upgraded from 3.6.5 (MySQL 4.0.21) to 3.8.1 (MySQL 5.0.45),
using the following --

/opt/rt3/sbin/rt-setup-database --dba root --action upgrade
perl etc/upgrade/schema.mysql-4.0-4.1.pl rt3 (and applying the output)

Everything appears to be fine with respects to incoming tickets,
ownership, etc. No obvious errors appear in any logs. Authentication
is handled by mod_authnz_ldap.

One queue in particular, Support has no privileges enabled for the
Everyone role. Unprivileged users, which are manually created, have
CreateTicket privileges. Prior to the 3.8.1 upgrade, incoming e-mails
from unknown users were rejected with the appropriate No permissions
to create tickets in queue Support. Only e-mails from existing
Unprivileged users would generate tickets.

After the 3.8.1 upgrade, any incoming e-mail causes a user to be
auto-created by form submission and the ticket to be created in the
appropriate queue, disregarding any permissions for the queue. (This
is bad.)

Auth::Mailfrom appears in 'Admin/Tools/Configuration.html', which as
best I understand it, should check the Queue permissions and reject
the e-mail appropriately. It doesn't appear that this is occurring. No
obvious errors for Auth::Mailfrom appear in any of the logs
(error_log, ssl_error_log, maillog, messages).

If there's a workaround, e.g. disabling the auto-creation of users,
that would work just as well.

Any thoughts are appreciated. I'm at a loss for the moment.

Thank you for any assistance or insight.
___
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] Web interface

2008-09-04 Thread Nick Price
Hell
 
I have done 2 installs rt-3.8.1 exactly the same with the same confgis
except one is on fedora 7 and the other is on fedora 9  both with all the 
updates  installed
 
the fedora 9 works web as it should do
 
On the fedora 7 the program works ok except the web interface gives everything 
in text mode.
 
 
Any ideas please
 
 
Many thanks 
_
Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008___
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] Web interface

2008-09-04 Thread chaim . rieger
Permissions for the html noauth dir


Sent via BlackBerry from T-Mobile

-Original Message-
From: Nick Price [EMAIL PROTECTED]

Date: Fri, 5 Sep 2008 04:18:10 
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Web interface


___
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