[rt-users] Trying to change the logo. Fedora Core 7, RT3.6.3 yum install

2007-08-07 Thread Luke E Morgan
I'm sure I'm just missing something simple, but I cannot seem to change the BP logo on my install of RT 3.6.3 on Fedora Core 7. I've installed RT using yum (lazy I know, but it works apart from this issue). It has been installed into /usr/share/rt3 I've created /usr/local/rt3/html/Elements/ and

Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Boris Lytochkin
-- An HTML attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm -- Message: 5 Date: Tue, 7 Aug 2007 12:39:04 +0100 From: Luke E Morgan [EMAIL PROTECTED] Subject: Re: {Disarmed} [rt

Re: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Kenneth Marshall
-- An HTML attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm -- Message: 5 Date: Tue, 7 Aug 2007 12:39:04 +0100 From: Luke E Morgan [EMAIL PROTECTED] Subject: Re: {Disarmed

[rt-users] Optimize database after using rtx-shredder

2007-08-07 Thread Mathew Snyder
When we migrated from 3.2.x to 3.6.1 I cleared out roughly 15,000 users created by spam and a comparable number of tickets. I now have in place a script which does this automatically and, considering we get about 100-150 emails a day which are deemed to be spam, this leaves us with quite a few

[rt-users] Error while dumping RT database

2007-08-07 Thread Alex Moura
Hello, Recently our RT database backup script started to show this message. mysqldump: Error 5: Out of memory (Needed 19928072 bytes) when dumping table `Attachments` at row: 390157 Any recommendations? Thanks in advance, Alex ___

Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Boris Lytochkin
Court, Luton, LU1 3JJ -- next part -- An HTML attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm -- Message: 5 Date: Tue, 7 Aug 2007 12:39:04 +0100 From

RE: Re[2]: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Justin Brodley
nor endorsed by it. Registered in England No. 1871978, VAT Reg. No 449343040, MTL Instruments Ltd, Power Court, Luton, LU1 3JJ -- next part -- An HTML attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464

Re[4]: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Viktor
, VAT Reg. No 449343040, MTL Instruments Ltd, Power Court, Luton, LU1 3JJ -- next part -- An HTML attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm

Re: [rt-users] Optimize database after using rtx-shredder

2007-08-07 Thread Viktor
Hello, Mathew. When we migrated from 3.2.x to 3.6.1 I cleared out roughly 15,000 users created by spam and a comparable number of tickets. I now have in place a script which does this automatically and, considering we get about 100-150 emails a day which are deemed to be spam, this

Re: [rt-users] History Display for a Ticket

2007-08-07 Thread Scott T. Hildreth
On Fri, 2007-08-03 at 15:19 -0500, Scott T. Hildreth wrote: On Fri, 2007-08-03 at 10:51 -0500, Scott T. Hildreth wrote: On Thu, 2007-08-02 at 11:53 -0500, Scott T. Hildreth wrote: On Thu, 2007-08-02 at 09:27 -0700, Kenneth Crocker wrote: Scott, Normally, I would say

Re: [rt-users] Attachments table of RT's Mysql database

2007-08-07 Thread Drew Barnes
attachment was scrubbed... URL: http://lists.bestpractical.com/pipermail/rt-users/attachments/20070807/37bbd464/attachment-0001.htm -- Message: 5 Date: Tue, 7 Aug 2007 12:39:04 +0100 From: Luke E Morgan [EMAIL PROTECTED] Subject: Re: {Disarmed} [rt-users] Trying

[rt-users] Problem initializing database

2007-08-07 Thread John Oliver
[EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password In order to create or update your RT database,this script needs to connect to your mysql instance on 10.12.14.149 as root. Please specify that user's database password below. If the user has no

Re: [rt-users] Problem initializing database

2007-08-07 Thread Scott Hebert
On 8/7/07, John Oliver [EMAIL PROTECTED] wrote: grant all on *.* to 'root'@'10.12.14.164' identified by '' This is *almost* proper syntax. Try this instead... GRANT ALL ON *.* TO 'root'@'10.12.14.164' IDENTIFIED BY 'password' WITH GRANT OPTION Good luck! -- Scott

Re: [rt-users] Problem initializing database

2007-08-07 Thread John Oliver
On Tue, Aug 07, 2007 at 01:11:24PM -0500, Scott Hebert wrote: On 8/7/07, John Oliver [EMAIL PROTECTED] wrote: grant all on *.* to 'root'@'10.12.14.164' identified by '' This is *almost* proper syntax. Try this instead... GRANT ALL ON *.* TO 'root'@'10.12.14.164'

[rt-users] Search old tickets from within scrip

2007-08-07 Thread Keith Edmunds
RT 3.6.1 We have one custom field per ticket, Customer, of type 'select one value'. So far, we've set that value manually on each new ticket, but I'd like to automate it. What I'd like to do, within a script, is search for the last ticket from this requestor and set the customer custom field to

Re: [rt-users] Search old tickets from within scrip

2007-08-07 Thread Ruslan Zakirov
my $tickets = RT::Tickets-new( $RT::SystemUser ); $tickets-FromSQL(Requestor.EmailAddress = '$address' AND 'CustomField.{Customer}' IS NOT NULL); # fetch from DB only first one ticket $tickets-RowsPerPage(1); my $ticket = $tickets-First; return undef unless $ticket; return

[rt-users] RTFM public viewable

2007-08-07 Thread Kevin Squire
I have been doing about 2 days worth of searching both the mailing list and the general web trying to find some example/screenshots/etc of RTFM, but with little luck. I am trying to figure out (1) If RTFM can be used to create/maintain a publicly viewable (i.e. no need to log into RT) FAQ base