Re: [rt-users] User Database empty?

2010-07-22 Thread Joop
Max Bern wrote: I think the reason why the 'make' commands do not work to install 3.8.8 is that CentOS doesn't use that command. The big problem here is that we are trying to install RT on a remote CentOS box with only the terminal to work with. We have been trying to install RT on this box fo

[rt-users] CommandbyMail - CustomFields - Can't get $queue->TicketCustomFields;

2010-07-22 Thread anthony acquanita
So I never enter this while loop. If I run a script outside of RT it works my $custom_fields = $queue->TicketCustomFields; while ( my $cf = $custom_fields->Next ) { $RT::Logger->error( "HORRAY" ); my %tmp = _ParseAdditiveCommand( \%cmds, 0, "CustomField{". $cf->Nam

Re: [rt-users] New install of RT3.8.8 - 64bit?

2010-07-22 Thread ronald . higgins
32bit systems cannot address more than 4GB memory so go with 64bit so you don't find yourself needing to reinstall the O.S in a year or 2 because you need more RAM. IMHO of course. Regards Ronald Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From:

[rt-users] New install of RT3.8.8 - 64bit?

2010-07-22 Thread Joseph Spenner
I'm about to build a new RT3, latest greatest 3.8.8.  My plan is to use CentOS 5.4.  Is there any advantage (disadvantage?) to using 64bit OS?  I can use 32bit or 64bit, but want to use whatever would be best and/or least problematic. Thanks! If life gives you lemons, keep them-- because hey..

Re: [rt-users] User Database empty?

2010-07-22 Thread Max Bern
I think the reason why the 'make' commands do not work to install 3.8.8 is that CentOS doesn't use that command. The big problem here is that we are trying to install RT on a remote CentOS box with only the terminal to work with. We have been trying to install RT on this box for the entire week,

Re: [rt-users] User Database empty?

2010-07-22 Thread Peter Murfitt
Just to give you a help with the permissions - using that tool, as far as I'm aware, uses the user/password and database details as per the /opt/rt3/etc/RT_SiteConfig.pm file (though I'm writing this from memory from when I last installed), you might wish to double check the information in that

Re: [rt-users] User Database empty?

2010-07-22 Thread Thomas Sibley
On 07/22/2010 05:05 PM, Max Bern wrote: How do I keep replies on the list? and the 'make initialize-database' command doesn't work with CentOS, which is what our instance of RT is installed upon, I thought I had said that in the original post but apparently not. We followed the CentOS install ins

Re: [rt-users] User Database empty?

2010-07-22 Thread Max Bern
I wiped the database as per Thomas Sibley's advice, but now I can't figure out how to make it again, we have gone through the entire installation process and the part: rt-setup-database --action init returns an error saying that we are denied. I have full root priviledges. Do I have to do som

[rt-users] CommandbyMail - CustomFields - Can't get $queue->TicketCustomFields;

2010-07-22 Thread anthony acquanita
So i've done some debug in TakeAction.pm and it seems that custom_fields is empty because I never see the ACTIONCF2 log any leads at to debugging $queue->TicketCustomFields; ? # Canonicalize custom fields my $custom_fields = $queue->TicketCustomFields; $RT::Logger->info( "ACTIONC

Re: [rt-users] User Database empty?

2010-07-22 Thread Thomas Sibley
Please make sure to keep replies on the list. Thanks. On 07/22/2010 04:44 PM, Max Bern wrote: $ /usr/sbin/rt-setup-database --action init is this the step you were talking about? we just tried it and it failed because r...@localhost is denied entry. No. The step I'm talking about is runnin

Re: [rt-users] User Database empty?

2010-07-22 Thread Thomas Sibley
On 07/22/2010 04:37 PM, Max Bern wrote: After checking the MySQL databases, we discovered the the user database was empty, no superuser, no nothing. How can we manually add the root/password superuser to the MySQL table so that we can log into the system? It sounds like the "make initdb" step d

[rt-users] User Database empty?

2010-07-22 Thread Max Bern
Hello again, I think I found the problem with logging in to the web portal, but I do not know how to fix it. We tried the default root/password credentials and every other permutation with the database user/password created in RT_SiteConfig.pm, but we still couldn't log in. After checking the My

[rt-users] Re quest Tracker 3.8.8 - Apache2::RequestIO::rflush:(103) Software caused connection abort

2010-07-22 Thread ryancfie...@gmail.com
Hi, I am new to RT and have configured my first install. I am using CentOS 5.5 and RT 3.8.8 Request tracker work great, and I have everything configured. I seem to be running into one issue which is very easy to repro. If I click a on a few things at once in RT it will hang for a few seconds

Re: [rt-users] Quick Syntax check for $RTAddressRegexp setting

2010-07-22 Thread Kenneth Marshall
On Thu, Jul 22, 2010 at 03:32:13PM -0400, Mike Johnson wrote: > Hi everyone, > > I just want to make sure i'm understanding the wiki properly... > > If I want to make sure RT doesn't create tickets using the following email > addresses, > > helpd...@here.ca > myhelpd...@here.ca > helpd...@there.

[rt-users] Quick Syntax check for $RTAddressRegexp setting

2010-07-22 Thread Mike Johnson
Hi everyone, I just want to make sure i'm understanding the wiki properly... If I want to make sure RT doesn't create tickets using the following email addresses, helpd...@here.ca myhelpd...@here.ca helpd...@there.ca myhelpd...@there.ca My config file setting should look like this, Set($RTAddr

[rt-users] Upgrade sequence?

2010-07-22 Thread Michael James
Hi, I've got the following according to RT..Configuration..Tools..System Configuration RT v3.4.6; RT::FM v2.2.1; RT::Interface::Email v2; RTx::AssetTracker v0.0.0; And I want to upgrade to RT v3.8.8 and the latest version of RTFM and RTx::AssetTracker. What's the sequence of steps I nee

Re: [rt-users] root/password combination doesn't work for first time logon

2010-07-22 Thread Mike Johnson
http://wiki.bestpractical.com/view/RecoverRootPassword This is what I did when I was too lazy to search for what RT's root password default is when you do a fresh install... worked like a charm. On Thu, Jul 22, 2010 at 2:01 PM, Max Bern wrote: > Hi all, > > We recently made a *working* RT ins

[rt-users] root/password combination doesn't work for first time logon

2010-07-22 Thread Max Bern
Hi all, We recently made a *working* RT install on CentOS, everything is configured properly and we can get to the localhost/rt3 logon page. That's where the nightmares start. We have tried every user/password combination we can think of, but always cannot log in. root/password doesn't work, n

Re: [rt-users] Mysql queries slow

2010-07-22 Thread Kenneth Marshall
On Thu, Jul 22, 2010 at 09:52:14AM -0700, William Graboyes wrote: > Hi Ken, > > I do not have the full hardware specs. It is a hosted RT system. The specs > that I do have access to are as follows: > > Probably a dual core single CPU system, speed unknown > 2gb of ram > 80 gb hd space they are

Re: [rt-users] Adding CC's from an email as Watchers on Create Ticket

2010-07-22 Thread Kenneth Crocker
Alan, Mike's point is well-taken. You don't want and endless list of duplicate tickets, which will happen if you don't follow Mike's point. Kenn LBNL On Thu, Jul 22, 2010 at 8:41 AM, Mike Johnson wrote: > Hi, > > Make sure you set RTAddresRegexp in your config if you are going to use > ParseNe

Re: [rt-users] Prioritizing Scrips

2010-07-22 Thread Jerrad Pierce
> Thanks for the replies.  The advise and suggestions worked.  Now I'm having > problems calling a Java jar from my scrip in RT.  I've tried using the > system and open functions, but have had no luck.  Does anyone know of a way > to call the Java jar from RT? Seems like a really bad idea to me, bu

Re: [rt-users] Prioritizing Scrips

2010-07-22 Thread Greg Curiel
Hi, Thanks for the replies. The advise and suggestions worked. Now I'm having problems calling a Java jar from my scrip in RT. I've tried using the system and open functions, but have had no luck. Does anyone know of a way to call the Java jar from RT? Thanks, Greg Curiel -- View this mess

Re: [rt-users] Mysql queries slow

2010-07-22 Thread William Graboyes
Hi Ken, I do not have the full hardware specs. It is a hosted RT system. The specs that I do have access to are as follows: Probably a dual core single CPU system, speed unknown 2gb of ram 80 gb hd space they are using md but I do not know the configuration particulars. I know it is not much h

Re: [rt-users] Adding CC's from an email as Watchers on Create Ticket

2010-07-22 Thread Mike Johnson
Hi, Make sure you set RTAddresRegexp in your config if you are going to use ParseNewMessageForTicketCCs. If you don't, terrible things can happen... P.S. Kenneth, sorry for the reply to you specifically :P we just switched email platforms and I wasn't paying attention to what I was doing :P Tha

Re: [rt-users] Shred more than 10 per rt-shredder run?

2010-07-22 Thread Jeff Blaine
Thanks Peter - that did it. Seems like a largely undocumented thing if it's only mentioned in an example query in the wiki. Weird. On 7/21/2010 3:13 PM, Peter Murfitt wrote: Looks like "limit,100;" might be your answer? rt-shredder --plugin "Tickets=query,Status = 'Deleted' AND LastUpdated< '

Re: [rt-users] ExternalAuth - loading fine but isn't authenticating to LDAP

2010-07-22 Thread Kenneth Crocker
Mike, First off, check to see how you've set $WebExternalAuto. I'm not sure how that would affect LDAP if it was turned on. Second, I'll assume you've set your "Plugins" appropriately to include "RT::Authen::ExternalAuth". Thirdly, you have to make sure certain LDAP parameters are consistent (ie

Re: [rt-users] Adding CC's from an email as Watchers on Create Ticket

2010-07-22 Thread Kenneth Crocker
Alan, To do this universally, you want to set the following configuration: Set($ParseNewMessageForTicketCcs , 1); To do it on a Queue-by-Queue basis, I added a scrip for that to the wiki for both create's and on-going correspondence. Kenn LBNL On Thu, Jul 22, 2010 at 12:54 AM, Kevin Falcone wr

[rt-users] ExternalAuth - loading fine but isn't authenticating to LDAP

2010-07-22 Thread Mike Johnson
Hi everyone, Where do I start debugging my setup?? I have CentOS5.5, RT3.8.8, ExternalAuth 0.8 attempting to connect to an Active Drectory LDAP. Everything loads fine(I get no errors from my config files). I've loaded the ExternalAuth plugin, but when I attempt to login to the UI with an LDAP u

Re: [rt-users] Mysql queries slow

2010-07-22 Thread Kenneth Marshall
On Wed, Jul 21, 2010 at 06:19:51PM -0700, William Graboyes wrote: > Hi List, > > As an example of what I am talking about the query `select count(id) from > Attachments;` The returned result is 174039, but it takes 39.1549 seconds > to return that simple query. The Transactions table returns 34

[rt-users] MySQL Performance

2010-07-22 Thread ronald higgins
Hi RT Users, We've started experiencing degraded performance within RT over the last few days and I am struggling to pin point where exactly the problem is lying. I suspect it might be MySQL, i've inserted a "show innodb status" below if anyone could perhaps take a gander and read something out of

Re: [rt-users] Customization / Callback Question for "Ticket/Elements/Tabs".

2010-07-22 Thread Christian Loos
Hi Torben, you should move your callback from /usr/local/share/request-tracker3.8/html/Callbacks/Ticket/Elements/Tabs/Default to /usr/local/share/request-tracker3.8/html/Callbacks/MyCallbacks/Ticket/Elements/Tabs/Default and replace MyCallbacks with a name of your choice. Restart the webserver and

Re: [rt-users] Adding CC's from an email as Watchers on Create Ticket

2010-07-22 Thread Kevin Falcone
On Wed, Jul 21, 2010 at 11:22:48PM -0400, Jason A. Smith wrote: > On Thu, 2010-07-22 at 12:42 +1000, Alan Deadman wrote: > > Hi > > > > Most of my tickets are created via emails to the RT system. When this > > happens, the CC's from the email are not automatically added as > > Watchers. > > > > I