We use mysqldump and logrotate to keep a week of DB dumps on the local
filesystem, we perform daily backups to a VTL and then tape, and we also
perform nightly SAN snapshots on the RT host's LUN (making sure to lock
the databases before the snapshot, and then unlocking after so the MySQL
DB files
This is exactly what I do. Is this a decent way to be doing it -- I've
always just assumed it was okay. I do it hourly, and then SCP it to
another system.
Should I be stopping mysql or anything before doing the mysqldump?
--
Max,
What made you do hourly dumps? I'm thinking now instead of
Hi all,
I'm about to migrate an old RT 3.6.3 setup to a new v3.8.8 machine.
On the new installation, login data (user and password) are not stored
by the browser. On my old 3.6.3 version this works and I also want this
behaviour in the new version.
I already change the code (Elements/Login) and
On Tue, Jan 04, 2011 at 06:27:24PM -0600, Max McGrath wrote:
*I run a nightly dump as root:
mysqldump --opt rt3 -u root -p rt3.sql
(assuming the root user can perform that dump)
Then scp the file to another system.
Since the rest of the system doesn't change much, I don't bother with
I am looking for some advice on how to speed up some queries using
custom fields that got unusably slow after an upgrade from the RT 3.6 series
to 3.8.
We are currently running RT 3.6.10 on CentOS 5.5 with a postgresql
back end (used to be PgSQL 8.1 but we upgraded to 8.4 when CentOS 5.5
came
Hi RT Community,
I have an issue I want to troubleshoot and resolve. I have
- CentOS 5.5,
- RT 3.8.8,
- postfix as an MTA running on [myrtdomain.com] sending and responding
to mails internal to [mycompanydomain.com]. mycompanydomain.com is on
MDaemon mail server
- apache2 server
I keep seeing
Hello,
when creating a ticket, the spell checker button is disabled fckeditor.
How to enable this button?
Thank you
Hello,
I've been searching for a solution to this problem for some time now. I'm
hoping someone can help me.
I currently have about 25 different queues in my RT 3.8.8. I'm looking to
get statistic over a specific period of time. And mainly when tickets are
created. I can get hourly stats for a
On 01/05/2011 09:07 AM, Max McGrath wrote:
I forgot to mention, I also backup a few other files/folder critical to RT:
##
# BACKUP DATABASES #
##
mysqldump -u root rt3 rt3_backup.sql
mysqldump -u root
On 01/05/2011 09:23 AM, Konstantin Khomoutov wrote:
On Wed, 05 Jan 2011 07:36:46 -0500
Andy Graybealandy.grayb...@casanueva.com wrote:
If I ever ended up doing LVM snaps, do I need to lock the db first...
or can I get away with not locking the db with LVM snaps?
In this case locking is less
The command newaliases I was led to believe was only for sendmail. What you
need is:
postalias /etc/aliases
Unless you have newaliases somehow linked to the above, postfix won't read the
aliases file.
At least I hope that is it. :)
Sent from blackberry
-Original Message-
From:
On Wed, Jan 05, 2011 at 07:36:46AM -0500, Andy Graybeal wrote:
You use logrotate to manage your mysqldumps! Excellent idea.
if you are using Debian, the command savelog is also often convenient
to rotate a file at the beginning or end of a script.
saveloq -q /var/backups/mysql/dump.sql.gz
On Wed, Jan 05, 2011 at 03:34:21PM +0300, Gregory Greafers wrote:
JanĀ 5 14:08:10 noc postfix/cleanup[6000]: warning: database
/etc/postfix/virtual.db is older than source file /etc/postfix/virtual
...
you should probably run postmap /etc/postfix/virtual
JanĀ 5 14:51:14 noc
On Wed, Jan 05, 2011 at 02:17:49PM +0100, Obando, David DE - EV wrote:
I already change the code (Elements/Login) and removed the
autocomplete=off parameter, but browser behaviour does not change.
Any ideas?
did you cleaned-up the mason cache?
rm -rf ./rt/var/mason_data/obj
On Wed, 05 Jan 2011 07:45:33 -0500
Andy Graybeal andy.grayb...@casanueva.com wrote:
This is exactly what I do. Is this a decent way to be doing it --
I've always just assumed it was okay. I do it hourly, and then SCP
it to another system.
[...]
What made you do hourly dumps? I'm thinking
I might work on a ticket through the morning for a few hours, resolve it at
noon, and only use the Tools-MyDay screen at the end of the day.
What I thought I might be able to do was add a second query, so the main loop
looks like this:
% while ( my $Ticket = $Tickets-Next() ||
On Wed, Jan 05, 2011 at 07:31:37PM +0900, Georgi Georgiev wrote:
I am looking for some advice on how to speed up some queries using
custom fields that got unusably slow after an upgrade from the RT 3.6 series
to 3.8.
We are currently running RT 3.6.10 on CentOS 5.5 with a postgresql
back
I just figured in the case of a crash or any data loss, it'd be nice to have
only lost an hour or less worth of tickets!
--
Max McGrath
Asst. Network Admin/Systems Specialist
Carthage College
262-552-5512
mmcgr...@carthage.edu
On Wed, Jan 5, 2011 at 6:45 AM, Andy Graybeal
I forgot to mention, I also backup a few other files/folder critical to RT:
##
# BACKUP DATABASES #
##
mysqldump -u root rt3 rt3_backup.sql
mysqldump -u root mysql mysql_backup.sql
#mysqldump -u root
I am using version 3.8.4 so CustomFieldValuesAsString is not available.
I changed the template like this:
CustomField-n: {
my $separator = \n;
my $CFValue = $Tickets{'TOP'}-CustomFieldValues(n);
return join ($separator, grep { defined $_ }
I would have expected that to work, it's what I did and FF now remembers
passwords. I actually commented out the original code and entered it ahain but
it's the same as what you said you did. Looks like this:
div class=input-row
span class=label|/lPassword/:/span
!-- span class=inputinput
On Wed, Jan 05, 2011 at 03:43:49PM +, Joe Harris wrote:
The command newaliases I was led to believe was only for sendmail. What
you need is:
that's off topic for this list, but no, newaliases exists and works also
with postfix if you set variable alias_database correctly in your
MyCalendar is included in $HomepageComponents (below) but nothing
related to Calendar appears on the homepage. In fact, if I comment out
the $HomepageComponents line completely and restart the web server,
the homepage still looks the same, even if I clear my browser cache.
How could that
Hi Community.
I am using RT 3.8.7, my problem is when we send attachment it returns
following message to requesters of the tickets along with attachment.
This transaction appears to have no content
and normal communication is fine, this happens only when any of the
requester or AdminCC of the
We need to reject 'resolve' actions unless a certain
custom field is set to a value.
Is there a known solution for this, or should I start
hacking?
Hello,
when creating a ticket, the spell checker button is disabled fckeditor.
How to enable this button?
Thank you
Have tried it with some browser rather than IE?
In share/html/NoAuth/RichText/FCKeditor/fckconfig.js check the following
line:
FCKConfig.SpellChecker = 'ieSpell'
One of our queues receives job requests via e-mail. I have a scrip in place
that automatically assigns the newly-created ticket to any of several users,
if the subject is in a certain, easily-parsed format. This works fine.
For this scrip, the condition is On Create, the action is User
Hi,
We're running RT 3.8.8 and using RT-Authen-ExternalAuth 0.08 to authenticate
against Active Directory. Any new AD account I create can logon to RT, and have
corresponding account created in RT, if it is in the necessary security group,
but older accounts, mine included, pass the password
Because we only require the CF on resolve and at no other time I hacked the
update page when status = resolved.
I have seen others put scrips in place that set the status back to open but
this didn't work for us, as we didn't want the ticket to appear to be resolved
(submitted), we wanted to
Sue,
Try changing the stage to TransactionBatch. Make sure your configuration
is set to use same. Then, you need to be sure the names of the scrips a such
that an alphabetical execution of them will execute the scrip that assigns
the owners first.
Kenn
LBNL
On Wed, Jan 5, 2011 at 12:46 PM, Sue
Hi All,
If I have a ticket that is 1 month old. How can I get the value of time
worked tallied up for only the last 7 days the ticket was worked on?
So if the ticket has a grand total of 200 minutes on the 1 month old ticket.
But the last 7 days only have a cumulative 60 minutes worked. The
Hi,
SELECT SUM(TimeWorked) FROM Transactions WHERE ObjectId = ticket id
AND ObjectType = 'RT::Ticket' AND Created BETWEEN start date AND
end date;
On Thu, Jan 6, 2011 at 1:45 AM, tarminuscf tarminu...@gmail.com wrote:
Hi All,
If I have a ticket that is 1 month old. How can I get the value of
Doesn't that miss if someone just changes the TimeWorked value on the Basic tab
of the ticket?
I use (in MySQL SQL):
SUM(IF(Field = 'TimeWorked', NewValue - OldValue, TimeTaken)) as TimeWorked
-Original Message-
From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-
Thanks Ruslan/Stuart,
I haven't given your query a shot but I believe i've found a solution that
was already developed by Fran F. :
http://requesttracker.wikia.com/wiki/TimeWorkedReport
Thanks all!
Regards,
tar
On Wed, Jan 5, 2011 at 4:13 PM, Ruslan Zakirov r...@bestpractical.comwrote:
Hi,
Quoting Kenneth Marshall at 05/01/2011-08:14:10(-0600):
On Wed, Jan 05, 2011 at 07:31:37PM +0900, Georgi Georgiev wrote:
I am looking for some advice on how to speed up some queries using
custom fields that got unusably slow after an upgrade from the RT 3.6 series
to 3.8.
We are
35 matches
Mail list logo