[rt-users] Problems with user Custom fields

2010-11-19 Thread Wolfram Huettermann

Hello,

I have a big problem with user custom fields. I will  describe it that way:

I habe a use with the real name Max Mustermann with the id #13159. He 
possesses a  user custom field  with  the  id #17 and the name test. 
It is a text field and its value is foo.  It is supposed to be empty 
for all other users.


One day, I change that costumfield of that user to bar and I have a 
collection of Users called $Users which I intend to limit that way:


$Users-LimitCustomField(
   CUSTOMFIELD = 17,
   OPERATOR = =,
   VALUE = foo);

The very trouble is that this collection still enlists Max Mustermann 
as foo is a former customfield value of the customfield #17.


This is not  very helpful. Nevertheless, I want to enlist all users 
whose CURRENT value of  customfield  #17 is foo. Is it possible?  Or 
is it impossible?


Thanks in advance,


Wolfram









[rt-users] Add group membership via CLI

2010-11-19 Thread tanguy.lagroy
Dear Community,

I currently setup script to create users from CSV file via CLI, and also add 
the users to and existing group.

The first part is working fine with command :
/opt/rt3/bin/rt create -t users add Name=$name EmailAddress=$email 
Password=$pass Privileged=$priv Organization=$orga RealName=\$realname\

But the command to add group member doesn't work :
/opt/rt3/bin/rt edit group/mygroup add Members=$name

I try the several syntax, but none works:
-   Members=$email
-   Members=realname $email
-   Members=user/id
-   etc

The output says :
# members: Unkown field
# group  updated

Can anyone help me, please ?

--
Tanguy LAGROY
Département NSS/IPOC
BT Services
Email : tanguy.lag...@bt.com
Tel : +33 (0)1 78 41 15 39





Re: [rt-users] Users randomly being logged in as other users

2010-11-19 Thread vmos

Well we upgraded from debian sarge to debian lenny so that included an apache
upgrade. I don't see mod_cache enabled on the new or the old server, do you
think that would help?


Jeff Voskamp wrote:
 
 On 11/18/2010 04:31 AM, vmos wrote:
 
 You're right, we went from 3.3 to 3.8.7. I think 2.4 was the nagios
 version I
 recently upgraded.
 There's no proxy. I wouldn't have thought that cookies were being passed
 about, the network is identical, it hasn't changed.
 All we've changed is the server and version. All this server does is RT
 
 
 Kevin Falcone-2 wrote:

 On Wed, Nov 17, 2010 at 06:07:22AM -0800, vmos wrote:

 Hello, we were running RT 2.4 and we decided to upgrade to 3.8. we
 built
 a
 new server and instead of running it in-house, we moved it into our
 data
 centre.

 There was no RT release labeled 2.4, and you should be more specific
 about which release of 3.8.  3.8 covers releases of RT over more than
 2.5 years.

 You haven't really provided helpful details (such as authorization and
 webserver configurations) so any speculating is guesswork.

 Usually this involves a proxy server or incorrect caching.
 You really need to sort out if there are cookies being passed from
 user to user or something else going on.

 -kevin

 The we started getting a problem were you would click on a link in RT
 or
 refresh the page and suddenly you would be logged in as somebody else.
 I asked about this and was told that it was down to some sort of NAT
 issue
 between here and our DC as we all appeared to be coming from the same
 IP
 address.
 After trying and failing to get to the bottom of the NAT issue, we
 decided
 to move the server back in-house. It's now in the same rack, plugged in
 to
 the same switch as the old server (that NEVER had this issue)
 That was two days ago and now we see the problem is still happening. 

 What's going on?
 -- 
 View this message in context:
 http://old.nabble.com/Users-randomly-being-logged-in-as-other-users-tp30238345p30238345.html
 Sent from the Request Tracker - User mailing list archive at
 Nabble.com.


  

 
 I thought I recalled issues with mod_cache in apache and mixed sessions.
  I don't recall if you mentioned any apache changes at the same time.
 
 Jeff
 
 

-- 
View this message in context: 
http://old.nabble.com/Users-randomly-being-logged-in-as-other-users-tp30238345p30256452.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



Re: [rt-users] Users randomly being logged in as other users

2010-11-19 Thread Jeff Voskamp
On 11/19/2010 05:50 AM, vmos wrote:
 
 Well we upgraded from debian sarge to debian lenny so that included an apache
 upgrade. I don't see mod_cache enabled on the new or the old server, do you
 think that would help?
 
 I thought I recalled issues with mod_cache in apache and mixed sessions.
  I don't recall if you mentioned any apache changes at the same time.

 Jeff


 
From about this time last year:
http://www.mail-archive.com/rt-users@lists.bestpractical.com/msg23253.html


jeff


Re: [rt-users] Users randomly being logged in as other users

2010-11-19 Thread vmos

Thank you for that, it's very interesting. what's most interesting is that
when I brought this up in january I was laughed at like an idiot for
suggesting that the problem might possibly be something other than a faulty
proxy server or caching router, but I digress.

It turns out that mod_cache is actually enabled, I've been trying to disable
it without breaking apache but no joy so far. I've done an apt-get apache
upgrade to see if that'll help.

Am I being daft because I don't actually see a solution in that thread?
There's a patch but the responder says it doesn't work.



Jeff Voskamp wrote:
 
 On 11/19/2010 05:50 AM, vmos wrote:
 
 Well we upgraded from debian sarge to debian lenny so that included an
 apache
 upgrade. I don't see mod_cache enabled on the new or the old server, do
 you
 think that would help?
 
 I thought I recalled issues with mod_cache in apache and mixed sessions.
  I don't recall if you mentioned any apache changes at the same time.

 Jeff


 
 From about this time last year:
 http://www.mail-archive.com/rt-users@lists.bestpractical.com/msg23253.html
 
 
 jeff
 
 

-- 
View this message in context: 
http://old.nabble.com/Users-randomly-being-logged-in-as-other-users-tp30238345p30259026.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



Re: [rt-users] Users randomly being logged in as other users

2010-11-19 Thread Josh Narins
 From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
 Sent: Friday, November 19, 2010 11:14 AM
 To: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Users randomly being logged in as other users


 Thank you for that, it's very interesting. what's most interesting is
 that
 when I brought this up in january I was laughed at like an idiot for
 suggesting that the problem might possibly be something other than a
 faulty
 proxy server or caching router, but I digress.

 It turns out that mod_cache is actually enabled, I've been trying to
 disable
 it without breaking apache but no joy so far. I've done an apt-get
 apache
 upgrade to see if that'll help.

 Am I being daft because I don't actually see a solution in that thread?
 There's a patch but the responder says it doesn't work.


If you end up needing to build your apache from source, I think the ./configure 
option is --disable-module=cache

Reading the documentation at 
http://httpd.apache.org/docs/2.2/mod/mod_cache.html says that you can add this 
to your httpd.conf to prevent caching of anything:

# disables caching of any file under / directory
CacheDisable /


Josh Narins
Director of Application Development
SeniorBridge
845 Third Ave
7th Floor
New York, NY 10022
Tel: (212) 994-6194
Mobile: (917) 488-6248
Fax: (212) 994-4260
jnar...@seniorbridge.com

SeniorBridge
Managing Complex Chronic Care
http://www.seniorbridge.com



SeniorBridge Statement of Confidentiality: The contents of this email message 
are intended for the exclusive use of the addressee(s) and may contain 
confidential or privileged information. Any dissemination, distribution or 
copying of this email by an unintended or mistaken recipient is strictly 
prohibited. In said event, kindly reply to the sender and destroy all entries 
of this message and any attachments from your system. Thank you.


Re: [rt-users] Users randomly being logged in as other users

2010-11-19 Thread Kevin Falcone
 Am I being daft because I don't actually see a solution in that thread?
 There's a patch but the responder says it doesn't work.

I think the solution was disabling mod_cache

If there is documentation on what we can set to tell mod_cache not to
cache headers, RT can be patched to use it.  At this point, I don't
think we've found the appropriate documentation.

-kevin


pgp53dQwLXAC7.pgp
Description: PGP signature


[rt-users] RT and mySQL cluster?

2010-11-19 Thread Thierry Thelliez
Hello all,

Has anyone some experience running RT  on top of MySQL Cluster?
Feasible? Overkill? Any issues?

We think that with our application we will see peaks/burts of tickets
submissions. We want to be able to absorb these peaks safely.

Cheers,
Thierry


Re: [rt-users] ShowConfigTab right shows too many Information

2010-11-19 Thread Jesse Vincent



On Fri, Nov 19, 2010 at 08:41:36AM +0100, Brumm, Torsten / Kuehne + Nagel / Ham 
MI-ID wrote:
 Hi RT Users,
 today i figured out on a fresh RT 3.8.8 installation, that a group with only 
 ShowConfigTab Right granted globally is able to see all users without having 
 the right AdminUsers. All other Options like Groups/Queues/CF's are not 
 display any information, only the Admin/Users is listing all.

Go into the Users tab on a ticket and do a search for users. 


Re: [rt-users] The new ticket lifecycle state engine... What is it?

2010-11-19 Thread Jesse Vincent



On Thu 18.Nov'10 at 10:58:26 -0500, Josh Narins wrote:
 I don't think I'll have any problem convincing people to upgrade to RT4.0 when
 it comes out, since management already seeks to have Date custom fields, but I
 was wondering what the ticket lifecycle state engine, mentioned here[1], is.
 


Have a look in etc/RT_Config.pm at the %Lifecycles section

 
 [1] - http://blog.bestpractical.com/2010/09/
 rt-394-first-development-release-leading-to-rt-400.html
 
 
 
 Josh Narins
 
 Director of Application Development
 SeniorBridge
 845 Third Ave
 7th Floor
 New York, NY 10022
 Tel: (212) 994-6194
 Fax: (212) 994-4260
 Mobile: (917) 488-6248
 jnar...@seniorbridge.com
 seniorbridge.com
 
 SeniorBridge
 
 ━━━
 SeniorBridge Statement of Confidentiality: The contents of this email message
 are intended for the exclusive use of the addressee(s) and may contain
 confidential or privileged information. Any dissemination, distribution or
 copying of this email by an unintended or mistaken recipient is strictly
 prohibited. In said event, kindly reply to the sender and destroy all entries
 of this message and any attachments from your system. Thank you.


Re: [rt-users] RT Chinese Characters?

2010-11-19 Thread Brian Thompson
Jesse,

What do you mean by using fonts without traditional glyphs in them?  What 
we're seeing are square boxes in place of some of the characters.  Would that 
be a symptom of the font issue?  Can you please point us to an example of a 
Traditional Chinese font that *should* work with RT so we can test?  Is the 
test suite available to the public or just Best Practical customers?

Thank you!,

Brian

-Original Message-
From: Jesse Vincent [mailto:je...@bestpractical.com] 
Sent: Thursday, November 18, 2010 5:10 PM
To: Brian Thompson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT  Chinese Characters?




On Thu, Nov 18, 2010 at 02:48:40PM -0800, Brian Thompson wrote:
 Hi,
 
 We're running RT 3.8.8 and find that some Traditional Chinese characters 
 are not being displayed correctly (Simplified Chinese are okay).  Has anyone 
 had this experience and been able to overcome?

RT should be working just fine with Traditional Chinese.  Heck, I believe there 
are specific tests for it in our test suite.  The most typical failure mode I 
can think of would be using fonts without traditional glyphs in them

-Jesse

 
 Thank you,
 
 Brian

-- 



Re: [rt-users] RT Chinese Characters?

2010-11-19 Thread Vick Khera
On Nov 19, 2010, at 12:19 PM, Brian Thompson wrote:

 What do you mean by using fonts without traditional glyphs in them?  What 
 we're seeing are square boxes in place of some of the characters.  Would that 
 be a symptom of the font issue?  Can you please point us to an example of a 

That's the normal symptom of a font not having the glyph for the specified 
character.



Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Emmanuel Lacour
On Fri, Nov 19, 2010 at 10:03:53AM -0700, Thierry Thelliez wrote:
 Hello all,
 
 Has anyone some experience running RT  on top of MySQL Cluster?

Do you have experience with MySQL Cluster with other software. I doubt
there is a need for MySQL cluster with RT and I'm sure there will be
issue because unless something has changed, all data must fit in servers
memory when using MySQL cluster and an RT DB with many tickets is a DB
of several GB ;)

 Feasible? Overkill? Any issues?
 
 We think that with our application we will see peaks/burts of tickets
 submissions. We want to be able to absorb these peaks safely.
 

can you tell us more about yout peaks, I know many big setups that just
works fine with one DB. With RT, ticket submissions are often not an
issue, but having a lot of queues/groups/privileged users may slow down
your RT.




Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Kenneth Marshall
On Fri, Nov 19, 2010 at 10:03:53AM -0700, Thierry Thelliez wrote:
 Hello all,
 
 Has anyone some experience running RT  on top of MySQL Cluster?
 Feasible? Overkill? Any issues?
 
 We think that with our application we will see peaks/burts of tickets
 submissions. We want to be able to absorb these peaks safely.
 
 Cheers,
 Thierry
 

Are you sure the bottle-neck is the database backend. It seems
to me that most of the processing is in the webserver front-ends.
If that is the case, point a second front-end to the same backend
database and you will be able to handle more tickets. It is worth
testing, but is your database I/O even close to 100%?

Cheers,
Ken


Re: [rt-users] Add group membership via CLI

2010-11-19 Thread Emmanuel Lacour
On Fri, Nov 19, 2010 at 08:37:22AM +, tanguy.lag...@bt.com wrote:
 Dear Community,
 
 I currently setup script to create users from CSV file via CLI, and also add 
 the users to and existing group.
 
 The first part is working fine with command :
 /opt/rt3/bin/rt create -t users add Name=$name EmailAddress=$email 
 Password=$pass Privileged=$priv Organization=$orga RealName=\$realname\
 
 But the command to add group member doesn't work :
 /opt/rt3/bin/rt edit group/mygroup add Members=$name
 
 I try the several syntax, but none works:
 -   Members=$email
 -   Members=realname $email
 -   Members=user/id
 -   etc
 
 The output says :
 # members: Unkown field
 # group  updated
 
 Can anyone help me, please ?
 

well reading this part of rt code, it doesn't seems you can update groups 
members
with rt cli (only display members) :(

I would do this using a custom script ;)



Re: [rt-users] RT Chinese Characters?

2010-11-19 Thread Brian Thompson
Thank you for the confirmation.  Follow-up question if you know:  How might an 
organization ensure that users of Chinese Traditional characters always use a 
font that works with RT?


-Original Message-
From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Vick Khera
Sent: Friday, November 19, 2010 9:24 AM
To: RT Users
Subject: Re: [rt-users] RT  Chinese Characters?

On Nov 19, 2010, at 12:19 PM, Brian Thompson wrote:

 What do you mean by using fonts without traditional glyphs in them?  What 
 we're seeing are square boxes in place of some of the characters.  Would that 
 be a symptom of the font issue?  Can you please point us to an example of a 

That's the normal symptom of a font not having the glyph for the specified 
character.




Re: [rt-users] RT Chinese Characters?

2010-11-19 Thread Jesse Vincent



On Fri, Nov 19, 2010 at 09:45:15AM -0800, Brian Thompson wrote:
 Thank you for the confirmation.  Follow-up question if you know:  How might 
 an organization ensure that users of Chinese Traditional characters always 
 use a font that works with RT?

That's a platform-dependent question. It might be that you need to install the 
relevant language support for your platform. I recall this being an issue on 
some installs of Windows XP.


Re: [rt-users] RT Chinese Characters?

2010-11-19 Thread Brian Thompson
Is there a list of Chinese Traditional fonts that work with RT available so 
that we can make sure we're using one that works?

Thanks!,

Brian


-Original Message-
From: Jesse Vincent [mailto:je...@bestpractical.com] 
Sent: Friday, November 19, 2010 9:47 AM
To: Brian Thompson
Cc: Vick Khera; RT Users
Subject: Re: [rt-users] RT  Chinese Characters?




On Fri, Nov 19, 2010 at 09:45:15AM -0800, Brian Thompson wrote:
 Thank you for the confirmation.  Follow-up question if you know:  How might 
 an organization ensure that users of Chinese Traditional characters always 
 use a font that works with RT?

That's a platform-dependent question. It might be that you need to install the 
relevant language support for your platform. I recall this being an issue on 
some installs of Windows XP.



Re: [rt-users] ShowConfigTab right shows too many Information

2010-11-19 Thread Torsten Brumm
Hi Jesse, 
I think i explaned it wrong. Not Inside Tickets is the Problem, it is Inside 
the admin/Users/ Part. They can See all Users without the right adminusers.

Sent from my phone, sorry for all typo's.

Am 19.11.2010 um 18:06 schrieb Jesse Vincent je...@bestpractical.com:

 
 
 
 On Fri, Nov 19, 2010 at 08:41:36AM +0100, Brumm, Torsten / Kuehne + Nagel / 
 Ham MI-ID wrote:
 Hi RT Users,
 today i figured out on a fresh RT 3.8.8 installation, that a group with only 
 ShowConfigTab Right granted globally is able to see all users without having 
 the right AdminUsers. All other Options like Groups/Queues/CF's are not 
 display any information, only the Admin/Users is listing all.
 
 Go into the Users tab on a ticket and do a search for users. 


Re: [rt-users] ShowConfigTab right shows too many Information

2010-11-19 Thread Jesse Vincent



On Fri, Nov 19, 2010 at 07:02:03PM +0100, Torsten Brumm wrote:
 Hi Jesse, 
 I think i explaned it wrong. Not Inside Tickets is the Problem, it is Inside 
 the admin/Users/ Part. They can See all Users without the right adminusers.

No, you explained it right. I was saying that regular staff users can get the 
same data from regular user search on a ticket.


Re: [rt-users] RT Mobile UI 0.99

2010-11-19 Thread Jesse Vincent
I've just pushed 1.00 to CPAN. tell me if it deals right.


On Tue, Nov 16, 2010 at 09:02:18AM +, G.Booth wrote:
 Hi Jason
 
 I asked the same thing last week, but updating to version 0.99
 from CPAN fixed it for me, the mobile browser is automatically
 redirected to the mobile ticket show URL.
 
 It seems to be semi-fixed for me, used to get the error that's been
 discussed:
 
 Can't call method id on an undefined value at 
 /opt/rt3/local/plugins/RT-Extension-MobileUI/html/Callbacks/RT-Extension-MobileUI/Ticket/Display.html/Initial
 line 4.
 
 This has now stopped, but I cant get the url to go to the ticket :-[
 
 
 I am seeing the same problem that John Arends reported though, the
 link to switch to the full interface does not work for me.  I
 tried adding a / after m, but it didn't fix it for me.  However,
 if I add the full /index.html after the m, then it does work for
 me:
 
 RT-Config-Get('WebPath')%/m/index.html?NotMobile=1
 
 ~Jason
 
 Got this one too :-[
 
 regards
 
 garry

-- 


Re: [rt-users] ShowConfigTab right shows too many Information

2010-11-19 Thread Torsten Brumm
Ah, understood, so it's a Feature. Was only confused.

Thanks

Sent from my phone, sorry for all typo's.

Am 19.11.2010 um 19:02 schrieb Jesse Vincent je...@bestpractical.com:

 
 
 
 On Fri, Nov 19, 2010 at 07:02:03PM +0100, Torsten Brumm wrote:
 Hi Jesse, 
 I think i explaned it wrong. Not Inside Tickets is the Problem, it is Inside 
 the admin/Users/ Part. They can See all Users without the right adminusers.
 
 No, you explained it right. I was saying that regular staff users can get the 
 same data from regular user search on a ticket.


Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Torsten Brumm
Hi Thierry,
you should tell us more about your setup, Hardware Sizing and so on. How
many (concurrent) users etc.

Don't think, that you will solve your problems with a mysql cluster..

Torsten

2010/11/19 Thierry Thelliez thierry.thelliez.t...@gmail.com

 Hello all,

 Has anyone some experience running RT  on top of MySQL Cluster?
 Feasible? Overkill? Any issues?

 We think that with our application we will see peaks/burts of tickets
 submissions. We want to be able to absorb these peaks safely.

 Cheers,
 Thierry




-- 
MFG

Torsten Brumm

http://www.brumm.me
http://www.elektrofeld.de


Re: [rt-users] Add group membership via CLI

2010-11-19 Thread Emmanuel Lacour
On Fri, Nov 19, 2010 at 06:16:08PM +, tanguy.lag...@bt.com wrote:
 Thanks for your help Emmanuel. 
 What's the better ? Perl script or mysql script ?
 

Perl script using the RT API, sample untested code, without error
checking (get it with ($val, $msg) = method; die $msg unless ( $val ); ):

#!/usr/bin/perl -w

use strict;
use lib /home/rt/rt/lib;
use RT;
use RT::Interface::CLI qw( CleanEnv );

CleanEnv();
RT::LoadConfig();
RT::Init();

my $User = RT::User-new ( $RT::SystemUser );
$User-Create( Name = NAME, EmailAddress = EMAIL, ... );

my $Group = RT::Group-new ( $RT::SystemUser );
$Group-LoadUserDefinedGroup( GROUPNAME );

$Group-AddMember( $User-PrincipalObj-Id );



Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread tanguy.lagroy
Hi Thierry,

I successfull experience RT cluster on Mysql cluster
All works fine on debian lenny with heartbeat (Linux HA) + DRBD (raid 1 over IP 
- block synchronization).

The /var/lib/mysql is installed on DRBD partition
Apache and RT config are setup identically on both cluster node.

Regards
Tanguy

Le 19 nov. 2010 à 19:56, Torsten Brumm 
torsten.br...@googlemail.commailto:torsten.br...@googlemail.com a écrit :

Hi Thierry,
you should tell us more about your setup, Hardware Sizing and so on. How many 
(concurrent) users etc.

Don't think, that you will solve your problems with a mysql cluster..

Torsten

2010/11/19 Thierry Thelliez 
mailto:thierry.thelliez.t...@gmail.comthierry.thelliez.t...@gmail.commailto:thierry.thelliez.t...@gmail.com
Hello all,

Has anyone some experience running RT  on top of MySQL Cluster?
Feasible? Overkill? Any issues?

We think that with our application we will see peaks/burts of tickets
submissions. We want to be able to absorb these peaks safely.

Cheers,
Thierry



--
MFG

Torsten Brumm

http://www.brumm.mehttp://www.brumm.me
http://www.elektrofeld.dehttp://www.elektrofeld.de


Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Thierry Thelliez
Thanks all for the quick answers.

In terms of sizing, we could have several thousands (max = 10,000;
more realistically 3,000) tickets submissions within a day. They will
not be nicely spread during the day. Some hours might be a lot busier
than others. Each ticket will have at least one attachment (about 1 to
3 mb each).

I am just starting to learn about MySQL Cluster, trying to find an
architecture that could be robust enough to minimize data loss in case
of failure. In other words, we do not want to lose hours of submitted
tickets if something bad happens. Likewise, we want to provide
continuity of operations even if a server goes down.

From what I read in this forum, RT should be fine with the volume
assuming a decent server. My concern is more about robustness.

Thanks for your comments and suggestions.
Thierry


Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Thierry Thelliez
And to respond to Emmanuel's question about queues/group/privileged
users, this is a simple setup... 2 queues, 5 groups, and a dozen
privileged users and few hundred unprivileged ones. So I understand
that this is ok?


Thierry Thelliez


Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Eric Dropps
You can always just use MySQL replication to keep a hot backup of the DB
on another server/site.  This is what we do, and it works out pretty well.
Failover isn't automated in any fashion, but in theory would just be a
config change to point to the new DB server.

-Eric
 
-Original Message-
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thierry
Thelliez
Sent: Friday, November 19, 2010 4:16 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT and mySQL cluster?

Thanks all for the quick answers.

In terms of sizing, we could have several thousands (max = 10,000; more
realistically 3,000) tickets submissions within a day. They will not be
nicely spread during the day. Some hours might be a lot busier than
others. Each ticket will have at least one attachment (about 1 to
3 mb each).

I am just starting to learn about MySQL Cluster, trying to find an
architecture that could be robust enough to minimize data loss in case of
failure. In other words, we do not want to lose hours of submitted tickets
if something bad happens. Likewise, we want to provide continuity of
operations even if a server goes down.

From what I read in this forum, RT should be fine with the volume assuming
a decent server. My concern is more about robustness.

Thanks for your comments and suggestions.
Thierry


[rt-users] Extension cloneticket-withdata install on 3.8.8

2010-11-19 Thread Susan McClure

I am having problems with the install of the Extension
cloneticket-withdata (using 892fcbe source ), on RT 3.8.8

When I run:  perl Makefile.PL
I receive the error:

Can't locate inc/Module/Install.pm in @INC (@INC contains: 
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi 
/usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl 
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl 
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 
.) at Makefile.PL line 1.


My perl includes:
perl -V


Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
  Platform:
osname=linux, osvers=2.6.18-128.1.10.el5, 
archname=x86_64-linux-thread-multi
uname='linux ls20-bc2-13.build.redhat.com 2.6.18-128.1.10.el5 #1 
smp wed apr 29 13:53:08 edt 2009 x86_64 x86_64 x86_64 gnulinux '


..

Built under linux
  Compiled at Jul  2 2009 05:49:38
  @INC:
/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.8
/usr/lib/perl5/site_perl
/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.8
/usr/lib/perl5/vendor_perl
/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi
/usr/lib/perl5/5.8.8
.


Any suggestions on how to fix it??  From what I read, 
cloneticket-withdata is the

updated/improved version of the old Extension-ForkTicket.

Thanks


Re: [rt-users] RT Mobile UI 0.99

2010-11-19 Thread John Arends

This solves the problem I was having with the non-mobile browser link.

On 11/19/10 12:13 PM, Jesse Vincent wrote:

I've just pushed 1.00 to CPAN. tell me if it deals right.


On Tue, Nov 16, 2010 at 09:02:18AM +, G.Booth wrote:

Hi Jason


I asked the same thing last week, but updating to version 0.99

from CPAN fixed it for me, the mobile browser is automatically

redirected to the mobile ticket show URL.

It seems to be semi-fixed for me, used to get the error that's been
discussed:

Can't call method id on an undefined value at 
/opt/rt3/local/plugins/RT-Extension-MobileUI/html/Callbacks/RT-Extension-MobileUI/Ticket/Display.html/Initial
line 4.

This has now stopped, but I cant get the url to go to the ticket :-[


I am seeing the same problem that John Arends reported though, the
link to switch to the full interface does not work for me.  I
tried adding a / after m, but it didn't fix it for me.  However,
if I add the full /index.html after the m, then it does work for
me:

RT-Config-Get('WebPath')%/m/index.html?NotMobile=1

~Jason

Got this one too :-[

regards

garry



--
John Arends
jare...@illinois.edu
Network Analyst
College of ACES ITCS
University of Illinois at Urbana-Champaign



Re: [rt-users] RT Mobile UI 0.99

2010-11-19 Thread Jason A. Smith

On 11/19/2010 04:54 PM, John Arends wrote:

This solves the problem I was having with the non-mobile browser link.


Works for me too, thanks Jesse.

~Jason



On 11/19/10 12:13 PM, Jesse Vincent wrote:

I've just pushed 1.00 to CPAN. tell me if it deals right.


On Tue, Nov 16, 2010 at 09:02:18AM +, G.Booth wrote:

Hi Jason


I asked the same thing last week, but updating to version 0.99

from CPAN fixed it for me, the mobile browser is automatically

redirected to the mobile ticket show URL.

It seems to be semi-fixed for me, used to get the error that's been
discussed:

Can't call method id on an undefined value at
/opt/rt3/local/plugins/RT-Extension-MobileUI/html/Callbacks/RT-Extension-MobileUI/Ticket/Display.html/Initial

line 4.

This has now stopped, but I cant get the url to go to the ticket :-[


I am seeing the same problem that John Arends reported though, the
link to switch to the full interface does not work for me. I
tried adding a / after m, but it didn't fix it for me. However,
if I add the full /index.html after the m, then it does work for
me:

RT-Config-Get('WebPath')%/m/index.html?NotMobile=1

~Jason

Got this one too :-[

regards

garry








smime.p7s
Description: S/MIME Cryptographic Signature


Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Emmanuel Lacour
On Fri, Nov 19, 2010 at 07:14:36PM +, tanguy.lag...@bt.com wrote:
 Hi Thierry,
 
 I successfull experience RT cluster on Mysql cluster
 All works fine on debian lenny with heartbeat (Linux HA) + DRBD (raid 1 over 
 IP - block synchronization).
 
 The /var/lib/mysql is installed on DRBD partition
 Apache and RT config are setup identically on both cluster node.
 

speaking of DB, you're not using the cluster mode of MySQL, you have
just a failover between those two servers which is IMHO a good setup for
failover ;)



Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Emmanuel Lacour
On Fri, Nov 19, 2010 at 02:15:40PM -0700, Thierry Thelliez wrote:
 Thanks all for the quick answers.
 
 In terms of sizing, we could have several thousands (max = 10,000;
 more realistically 3,000) tickets submissions within a day. They will
 not be nicely spread during the day. Some hours might be a lot busier
 than others. Each ticket will have at least one attachment (about 1 to
 3 mb each).
 

you have to do benchmark, but here cluster mode of MySQL will not help
at all (to my knowledge it may decrease performances).

here I will go with good hardware (RAID 10) and one DB.

 I am just starting to learn about MySQL Cluster, trying to find an
 architecture that could be robust enough to minimize data loss in case
 of failure. In other words, we do not want to lose hours of submitted
 tickets if something bad happens. Likewise, we want to provide
 continuity of operations even if a server goes down.
 

using RT on a failover architecture is pretty easy and a good idea. You
just have to setup either a master/slave MySQL configuration, or drbd,
or a hot backup MySQL.



Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Emmanuel Lacour
On Fri, Nov 19, 2010 at 02:27:01PM -0700, Thierry Thelliez wrote:
 And to respond to Emmanuel's question about queues/group/privileged
 users, this is a simple setup... 2 queues, 5 groups, and a dozen
 privileged users and few hundred unprivileged ones. So I understand
 that this is ok?
 

yes ;)



Re: [rt-users] RT and mySQL cluster?

2010-11-19 Thread Torsten Brumm
Sounds like a Overkill for your setup. Think MySQL Master/Slave is what you are 
looking for like Emmanuel Said.

Torsten

Sent from my phone, sorry for all typo's.

Am 19.11.2010 um 22:27 schrieb Thierry Thelliez 
thierry.thelliez.t...@gmail.com:

 And to respond to Emmanuel's question about queues/group/privileged
 users, this is a simple setup... 2 queues, 5 groups, and a dozen
 privileged users and few hundred unprivileged ones. So I understand
 that this is ok?
 
 
 Thierry Thelliez