Re: [rt-users] [repost] Performance-Bug in SelfService when updated from 3.6.1 to 3.6.3

2007-01-30 Thread Gilmar Santos Jr

Hi Torsten,

I think these parameter are most important:

key_buffer  =  16M
join_buffer_size=  32M
innodb_buffer_pool_size =  256M
innodb_log_buffer_size  =   32M
innodb_log_file_size=  128M


The last 2 affects the recovery time and write speed. Higher values provides 
better writing performance and greater crash recovery times.


Maybe you will have problems if you modify innodb_log_file_size. I had to stop 
the server, change the configuration, remove the ib_log* files and start the 
server again. Sometimes, according to some docs, it doesn't work...


You can try at least 2 GB to innodb_buffer_pool_size. MySQL save some useful 
information about innodb. The less page faults the better performance ;)


Good luck,

--
Gilmar Santos Jr

Torsten Brumm escreveu:

Hi Gilmar,

i'm playing around with this buffers since some months without finding a 
good solution, can you give me a hint about yours??


We have 4GB RAM at the DB Server.

Thanks Torsten

2007/1/28, Gilmar Santos Jr [EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]:


Dirk Pape escreveu:
  [...]
  If the latter, does anybody have a hint where to dig into?

Try to increase innodb_buffer_pool_size in my.cnf. See [1], [2] and
[3]. Tunning some parameters like join_buffer_size,
innodb_buffer_pool_size and some others gave me a huge performance
improvement. Take care of available RAM to avoid swapping.

1 - http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html
2 - http://dev.mysql.com/doc/refman/4.1/en/innodb-tuning.html
3 - http://wiki.bestpractical.com/index.cgi?PerformanceTuning

--
Gilmar Santos Jr
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com




--
MFG

Torsten Brumm

http://www.torsten-brumm.de


___
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] Mysql to Postgres Problems

2007-01-29 Thread Gilmar Santos Jr
Mario Gomide escreveu:
 [...]

 Now, when I run the upgrade script  I get the following error 3 times:
 Error: Internal Error: Couldn't execute the query 'INSERT INTO
 Attributes (ContentType, Creator, ObjectId, LastUpdatedBy, Created,
 Content, LastUpdated, Description, Name, ObjectType) VALUES (?, ?, ?,
 ?, ?, ?, ?, ?, ?, ?)'ERROR:  permission denied for sequence
 attributes_id_seq

 Any ideas?

Verify the owner of sequence objects in Pg...

--
Gilmar Santos Jr
___
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] Trying to develop a query

2007-01-27 Thread Gilmar Santos Jr
Philip J. Hollenback escreveu:
 [...]

 So is there a way to narrow this query to only tickets not updated by
 their owner in the last week?  Ideally I guess there would be a variable
 LastUpdatedByOwner instead of just LastUpdated.
   

There is a LastUpdatedBy search field, that could help you, but it
won't solve your problem cause if the owner have updated some ticket
within the due time, but the last chage was not performed by owner then
that ticket would be mistaken listed...

I think it's not possible to have LastUpdatedByOwner in a simple way
cause the Tickets table doesn't keep this information. The only way i
figure is to verify if there is any transaction created by ticket
owner... but the search interface doesn't permit to search tickets
transactions...

--
Gilmar Santos Jr
___
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] (ERRATA) Mysql to Postgres Problems

2007-01-27 Thread Gilmar Santos Jr
[..]
I considered migrating a couple weeks ago. I wrote a tutorial[1] about
[...]


1 - http://www.safernet.org.br/twiki/bin/view/Colaborar/RT_MySQL2Pg


--
Gilmar Santos Jr
___
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] Mysql to Postgres Problems

2007-01-27 Thread Gilmar Santos Jr
Hello Mario,

I considered migrating a couple weeks ago. I wrote a tutorial[1] about
it and a Perl script to help with the process. I've just added a few
instructions at RT wiki.

We have almost 400.000 tickets and had serious performance problems. Pg
performed much worse than MySQL, even after performance tunning
configurations. After increasing innodb_buffer_poll_size (MySQL's
configuration directive) the performance problem was gone.

I tested with RT 3.4.5, but i think it will work fine on 3.6, since
there were no schema changes.

ps.: create database on postgre with encoding *latin1*.

Good luck,
Gilmar Santos Jr


Mario Gomide escreveu:
 Hello list!

 I used to use RT-3.4.1 on MySQL and I´m trying to migrate to RT-3.6.1
 on PostgreSQL 8.1.
 I´m having some problems with the database import process.

 I get the same errors many times:
 ERROR:  invalid byte sequence for encoding UTF8:
 and
 invalid input syntax for integer: 
 Can I just change the value to NULL where the value is empty?

 I have noticed that most of my data was imported...

 First of all I begin a new RT 3.6.1 installation, then I follow these
 instructions (http://wiki.bestpractical.com/index.cgi?MySQLToPg).
 That is: Dump from mysql is done:
 mysqldump -u user -p mydatabase  dumpfile.sql
 I edit this dumpfile leaving it only with INSERT INTO lines and
 removing everything related to the sessions table.
 Then on my new installation, I access the DB and DELETE FROM each table.
 After that, I do:
 psql -h localhost -f dumpfile.sql newdb

 After that I run the make upgrade process.

 I hope you can help me out.
 Thanks

 Mario Gomide
 ___
 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] [repost] Performance-Bug in SelfService when updated from 3.6.1 to 3.6.3

2007-01-27 Thread Gilmar Santos Jr
Dirk Pape escreveu:
 [...]
 If the latter, does anybody have a hint where to dig into?

Try to increase innodb_buffer_pool_size in my.cnf. See [1], [2] and
[3]. Tunning some parameters like join_buffer_size,
innodb_buffer_pool_size and some others gave me a huge performance
improvement. Take care of available RAM to avoid swapping.

1 - http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html
2 - http://dev.mysql.com/doc/refman/4.1/en/innodb-tuning.html
3 - http://wiki.bestpractical.com/index.cgi?PerformanceTuning

--
Gilmar Santos Jr
___
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] Spam on the Wiki

2006-07-19 Thread Gilmar Santos Jr
Benji Wakely escreveu:
 It has been mentioned before but is there a way  to get rid of the spam
 on the Wiki?

 Don't know how it'll fly, but:
 Semi-public login, posted to the mailing lists regularly?
 Word-verification/captcha?

I take care of a few wiki sites and this problem was relatively solved
by requiring login to edit. In the register process the user writes a
comment about why she/he wants to register and a confirm mail is sent to
the supplied address. The registration is complete when  this mail is
replyed or the code sent is inputed in a particular web form. A notice
is generated and sent to the administrator, that can remove the account
if it's the case.
This way we are fairly safe from robots, and incidents with bad users
are very rare...
Btw, I use TWiki (http://twiki.org/), a very robust, flexible and
extensible wiki.

--
Gilmar Santos Jr
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Packet ticket send out?

2006-07-13 Thread Gilmar Santos Jr
Hi,

You can create a scrip with custom condition (ticket been created with
custom field X set to Y) and with action notify or even custom action
that sends the e-mail using some template (that can be customized).
Refer to http://wiki.bestpractical.com/index.cgi?Documentation Scrips Area

--
Gilmar Santos Jr

Zhiming Liu escreveu:
 Hi, Does anyone know how to do this with RT? when user
 creates a new ticket, selects a customfield value like
 yes, then click on Create button, RT automatically
 packet the ticket information and email to an email
 address. And it can do the same thing when it closes a
 ticket. Thanks, Zhiming.

 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam protection around 
 http://mail.yahoo.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


 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html
   

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] GD dependency on RT 3.6.0

2006-07-13 Thread Gilmar Santos Jr
Hi, Shannon

Shannon Adams escreveu:
 (...)
 I get:
 /usr/bin/ld: cannot find -lfontconfig
   

That's the problem. Install fontconfig (along with the development
files) on your system.
But before check if the GD isn't packed yet (most linux distributions
have binary packages for GD, assuming you are running a linux system).

--
Gilmar Santos Jr
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Templates for queue structure

2006-07-08 Thread Gilmar Santos Jr
Hi, David and everybody.

I have groups of queues with same user rights, groups rights, scrips and
templates. I had to replicate the configuration for each one and if I
need a change then it must be made to every single queue...
What I've be wondering about to solve this problem are groups of queues.
When a property applies to all queues it's enough to apply the property
globally (as if global was a group with all queues). If there was a
way I could setup queue groups then I could configure groups rights,
users rights, scrips and templates for the group and  subscribe the
queues into groups... It would be also possible to add properties
individually, but the maintenece of groups would be much easier.

What do you think about it?

Thanks,

--
Gilmar Santos Jr

David Smithson escreveu:
 Hi all.  It seems that it would be a nice feature to be able to define
 template queues.  So that semantics are not confused here, what I'm
 seeking is a way to 'copy' a queue structure and edit it.  I intend to
 have multiple queues with the same group rights, user rights, custom
 fields, etc.  It would be nice to be able to choose a template queue
 during the queue creation process.

 Does anybody else wish to have this functionality?

 Has anybody devised command-line scripts that handle this type of thing?

 Thanks.

 David Smithson
 
 ActivSupport, Inc.
 Your Flexible IT Partner
 Microsoft Gold Partner -- Small Business Specialist
 http://www.activsupport.com
 Director of Technical Services
 Direct: (415) 869 2991 
 
 Technical Support Hotline: (415) 979 9285 
 CLICK HERE FOR ONLINE SUPPORT 

 ___
 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


 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html
   

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Query tickets login?

2006-07-06 Thread Gilmar Santos Jr
Roy El-Hames escreveu:
 I am still investigating how to trap the session end .. anyone any
 ideas ?? but once its known you can update that row with logoff time

Things would be much easier if users clicked logout button.. but someone
can just close the browser. I think there's a maximum idle time
permitted to the session, after that if a connection attempt is made
then user needs to login again.
The problem is that RT is activated by the webserver, so to detect the
end of sessions there must be a stand alone tool running periodically...
There exists a tool to purge old sessions in the wiki. Some few
changes to it could insert a logout row in the table...
The stand alone tool with a change in the execution flow of the logout
proccess can achieve what you want ;)

--
Gilmar Santos Jr
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] User's Owned Tickets show incorrect URL string forsubject

2006-07-05 Thread Gilmar Santos Jr
The search results are displayed at /rt/Search/Results.html. Looking the
rt-instalation-path/html/Search/Results.html source code we find out
that the component used to display the results is /Elements/TicketList.
In this component there's a call to other in order to display the row,
but this action is governed by the $Format variable. That can be passed
to the component or use the $RT::DefaultSearchResultFormat default.

So, in the RT_Config.pm there must be a Set($DefaultSearchResultFormat,
something), and actually there is! :-)
The value I can se here is:


Set ($DefaultSearchResultFormat, qq{
   'BA
HREF=$RT::WebPath/Ticket/Display.html?id=__idid__/a/B/TITLE:#',
   'BA
HREF=$RT::WebPath/Ticket/Display.html?id=__idSubject__/a/B/TITLE:Subject',
   Status,
   QueueName,
   OwnerName,
   Priority,
   '__NEWLINE__',
   '',
   'small__Requestors__/small',
   'small__CreatedRelative__/small',
   'small__ToldRelative__/small',
   'small__LastUpdatedRelative__/small',
   'small__TimeLeft__/small'});


The first two lines are responsible for the first two columns, ticket id
and subject. They will work if the WebPath is set correctly in my
RT_SiteConfig.pm, and for me they work.

But RT allows users to customize the search format display (it's a per
user configuration), and it may be the problem's source.
If it is, then these configurations must be deleted. (DELETE FROM
Attributes WHERE Name = 'SearchDisplay', in MySQL, may in PostgreeSQL
too, but i'm not sure :) ). Use this with caution, *all* user's
SearchDisplay will be deleted and the default (set in RT_Config.pm, or
overridden in RT_SiteConfig.pm) used.

By the way, I'm using RT 3.6.

--
Gilmar Santos Jr

Josh Barron escreveu:
 At the very least could someone point me in the right direction to where
 the page is generating that URL string?  Maybe I could try to debug it
 from there?

 Also, to Kevin, are you running version 3.6.0?


 -Josh

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Kevin
 Murphy
 Sent: Monday, July 03, 2006 11:42 AM
 To: RT Users
 Subject: Re: [rt-users] User's Owned Tickets show incorrect URL string
 forsubject

 Josh Barron wrote:
   
 When doing a search for tickets you own, or on the
 RT at a glance page, if you mouse over or try to click on the
 hyperlinked ticket subject you get the following URL:
 http://ticket/Display.html?id=2.  Obviously that URL isn't going to
 work.
 
 Yes, I've reported this problem twice on this list and received no
 response.

 -Kevin Murphy

 ___
 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


 We're hiring! Come hack Perl for Best Practical:
 http://bestpractical.com/about/jobs.html
 ___
 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


 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html
   

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Query tickets login?

2006-07-05 Thread Gilmar Santos Jr
Hi,

I don't thinks that's easly possible, cause RT doesn't keep a Last Time
Login record... (does it?)
The sessions are stored in the database, so a customized
component/module could do this... but it doesn't seem to exist (I didn't
find anything with a quick search in the wiki)

--
Gilmar Santos Jr.

Zhiming Liu escreveu:
 Hi, can someone help me to write a query for
 users/super users:

 select all of modified tickets since last login

 Thanks, Zhiming.

 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam protection around 
 http://mail.yahoo.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


 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html
   

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] How can I prevent users from reading other queue's tickets?

2006-07-04 Thread Gilmar Santos Jr
Hi Tim,

1. There is more than one permission involved. The SeeQueue and the
many ShowTicket*. When someone doesn't have the SeeQueue permission 
it's still possible to see ticket, exactly as you described.
Remove the ShowTicket and related from those users that don't have the
SeeQueue.

2. If all users can see all queues that's true. Tickets in a queue you
can't see are not shown in your main page...

--
Gilmar Santos Jr

Tim Pritlove escreveu:
 Hi,

 I am using RT 3.2 and just found out two annoying things

 1. people who have NO permissions for a queue can still read the
 ticket when they get the URL
 2. tickets that do not have an owner get listed for every user of the
 system on the main page

 What can I do to prevent both things?

 Greetings
 Tim
 --Tim Pritlove, Discordian Evangelist, Chaos Computer Club
 mailto:[EMAIL PROTECTED] http://tim.geekheim.de/
 http://www.blinkenlights.de/
 jabber:[EMAIL PROTECTED] gizmo://timpritlove skype://timpritlove
 --
 Ein Lebenskünstler gedeiht am besten im Spannungsfeld zwischen Bohème
 und Askese und ist als gelebtes Gesamtkunstwerk sinnstiftend für sich
 selbst. -- Wikipedia


 

 ___
 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


 We're hiring! Come hack Perl for Best Practical: 
 http://bestpractical.com/about/jobs.html

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Q: How to build a ticket query that uses custom fields

2006-07-04 Thread Gilmar Santos Jr
Pau Montero Parés escreveu:
 This is a nice tip! I have a 3.4.1 instalation and everything works
 like a charm except the customfield searches. A CF.{value}='yes' has a
 time to display of 99.041657 sec. I supose that this is a mysql
 problem but I didn't find anything odd.

 ObjectCustomFieldValues has 2057 rows and 5 indexes:

 PRIMARY: id (cardinality 1802)
 TicketCustomFieldValues1: CustomField ObjectId Content (cardinality 1802)
 TicketCustomFieldValues2: CustomField ObjectId (cardinality 1802)
 ObjectCustomFieldValues1: Content (cardinality 901)
 ObjectCustomFieldValues2: CustomField ObjectType ObjectId (cardinality
 1802)

 Is this an innoDB problem? any suggestions?

Maybe the problem is with the index. Try to remove the
TicketCustomFieldValues (they are from previous versions).
Take a look at the wiki.bestpractical.com, there is a topic about
permormance tunning. There are mysql tips, apache tips, etc.

--
Gilmar Santos Jr
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] How to setup RT users and groups?

2006-06-30 Thread Gilmar Santos Jr
Zhiming Liu escreveu:
 Hi, How to setup RT users and groups that users can
 only ShowTicket in their own group. Group users can
 see the tickets, other group users can't. Thanks for
 help, Zhiming.
   
Hi,
You can create as many queues as you as there are groups and turn on
SeeQueue and ShowTicket for each one related to each group.
Ex. There are the A, B and C groups. I create the A_Queue, B_Queue and
C_Queue, and then on turn on the SeeQueue, ShowTicket, etc permission on
A_Queue to A group and so on...

I think it's not possible to make this kind of access control within the
same queue... Am I mistaken?

--
Gilmar Santos Jr

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] rt 3.6.x on Debian sarge

2006-06-30 Thread Gilmar Santos Jr
Hi,

I'm also using RT on debian sarge, but I backported the
libapache2-mod-perl2, perl, and some related libs from unstable.
Currently I'm running 3.4.4, and within a few weeks 3.6.0
There is no package available for RT 3.6.0 even in unstable branch, so I
had to make the packages by myself. My test server is alredy running
3.6.0 without problems :-)

That (backports + unofficial packages) is not a very goog solution,
cause I have to mantain the backports (In case of security updates, bug
fixes, etc I have to rebuild the packages). If Iim not mistaken there is
a server for backported packages, but I prefer to use mine...

--
Gilmar Santos Jr
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] How to setup RT users and groups?

2006-06-30 Thread Gilmar Santos Jr
Hi, Kenn.

Maybe I didn't make myself clear... It's possible to setup different
access rights within the same queue for different groups, like group A
can take, group B can comment, etc. But I was talking about, for
example, the ShowTicket permission. Can I set up RT to show some
tickets to a group and not to other group within the same queue? The
ShowTicket permission applies to all tickets in the queue, and not for
groups of tickets. That's why I suggested creating one queue for each
group :-)

--
Gilmar Santos Jr

Kenneth Crocker escreveu:
 Gilmar,

 You said, I think it's not possible to make this kind of access
 control within the same queue... Am I mistaken?. If I understood your
 question correctly, the answer is Yes, you could set up different
 access rights for any number of groups you want to access the Queue.
 We have a variety of Queues and groups where 1 Queue may have several
 groups with different types of access as well as many groups that have
 different types of access to several different Queues. It's all in the
 way you configure your Queues.

 Kenn
 LBNL


___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Q: How to make a user signature appear at the top of email coorespondance, instead of the bottom?

2006-06-30 Thread Gilmar Santos Jr
Hi, John.

I don't know if this could be done with some callback, but you can
change the html/Elements/MessageBox file. (See patch attached)


Refer to CleanlyCustomizeRT[1]: Using the 'local' directory.

[1] - http://wiki.bestpractical.com/index.cgi?CleanlyCustomizeRT

--
Gilmar Santos Jr.

John H. Nyhuis escreveu:
 Greetings,

 My RT users and I have signatures that we want to appear at the
 top (bottom is default) of the body of any coorespondance email.  When
 they respond to tickets, RT3.4 quotes the ticket content, but places
 the RT user's signature on the bottom, forcing the recipients of the
 coorespondance to scan through a long list of comments and
 coorespondance to get to the bottom where they actually see who
 answered them.  When tickets get bounced around to several admins,
 this get's confusing fast.

 Changeing the order of the items in the coorespondence template
 does not seem to effect whether signatures go to the top or bottom of
 the RT correspondance reply.

 Can anyone point me in the right direction for changing signature
 location since it does not seem to be controlled in the template?

 Thanks in advance,

 John H. Nyhuis
 Sr. Computer Specialist
 Dept. of Pediatrics
 HS RR349B, Box 356320
 University of Washington
 Desk: (206)-685-3884
 [EMAIL PROTECTED]
 ___
 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


 We're hiring! Come hack Perl for Best Practical:
 http://bestpractical.com/about/jobs.html


--- MessageBox.old  2006-06-30 17:09:53.0 -0300
+++ MessageBox  2006-06-30 17:10:28.0 -0300
@@ -43,7 +43,7 @@
 %# those contributions and any derivatives thereof.
 %# 
 %# END BPS TAGGED BLOCK }}}
-textarea class=messagebox COLS=%$Width% ROWS=%$Height% WRAP=%$Wrap% 
NAME=%$Name% /Elements/Callback, %ARGS % $Default 
%%$message%%$IncludeSignature ? $signature : ''%/textarea
+textarea class=messagebox COLS=%$Width% ROWS=%$Height% WRAP=%$Wrap% 
NAME=%$Name% /Elements/Callback, %ARGS % $Default 
%%$IncludeSignature ? $signature : ''%%$message%/textarea
 %INIT
 
 my ($message);
___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Re: [rt-users] How to setup RT users and groups?

2006-06-30 Thread Gilmar Santos Jr
Hi Zhiming,

I don't think that's possible, cause a ticket may have at most one owner
(enven when it has no owner it's owned by RT::Nobody) and the
permissions are queue's properties (If someone has the ShowTicket
permission for some queue, then all tickets in the queue can be shown to
him).

But if it could be possible, what would be done when a new ticket comes?
The super user would have to assign the new ticket to a group, right?
What if a hundred tickets were created in a day?
Think about using more than one queue, even if these queues have the
same templates and scrips (in which case you can make them global, or
replicate in each queue if the first isn't a good idea), differing only
in ACL.

--
Gilmar Santos Jr

Zhiming Liu escreveu:
 Hi Gilmar, Got your answer, thanks. 

 This is what I what to do on RT: Create one queue and
 several groups in the queue. A super user assigns a
 ticket to a group of users and users that are not in
 the assigned group CANNOT see the ticket.

 Is this possible? Thanks, Zhiming.
   

___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html


Re: [rt-users] Display.html link

2006-06-28 Thread Gilmar Santos Jr
Have you upgraded from a previous version?
If so, I think the problem is some kind of inconsistency in the
database, more precisely in the Attributes table, row named
'HomepageSettings'.

The problem appears only on the RT at a Glance? Is the link correct in
any search?

--
Gilmar Santos Jr


Phillip Jackson escreveu:
 Set($WebPath , /rt);

 3.6.0 on Fedora Core 5

 --
 Phillip C. Jackson
 Chief Technology Officer
 Chesapeake Medical Imaging

 Tel. 443-716-0410

 - Original Message -
 From: Gilmar Santos Jr [EMAIL PROTECTED]
 To: Phillip Jackson [EMAIL PROTECTED]
 Sent: Wednesday, June 28, 2006 10:36:24 PM GMT-0500
 Subject: Re: [rt-users] Display.html link

 Phillip Jackson wrote:

   
 On the RT at a Glance window, I can click on both the ID and the
 
 Subject to access the ticket.  The ID link works fine
 (http://alesmith.intellirad.net/rt/Ticket/Display.html?id=15) whereas
 the Subject link does not work
 (http://alesmith.intellirad.net/Ticket/Display.html?id=15)

 Take a look at the $WebPath varable in RT_SiteConfig.pm ;-)
 If it's all right, what version are you using?

 --
 Gilmar Santos Jr


   


___
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


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html