[rt-users] Ready to roll?

[John Buell]

Hm, thanks for pointing that out Kevin. I had been using:
Mysqldump --opt --add-drop-table --single-transaction -u rt_user -pPassword -h localhost rt4 > rt4-mysql-backup-`date %Y%m%d`

I see the sense in doing the backup on the page that you linked to, but when I do it that way, I'm getting 'error 1044: Access denied for user 'rt_user'@'localhost' to database 'rt4' when doing LOCK TABLES.

So is there something else I'm missing, or might someone have just been active in a session?

I also didn't have logging turned on, but I found the page on the wiki that described that and enabled it.

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin Falcone
Sent: Tuesday, February 26, 2013 11:35 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Ready to roll?

On Tue, Feb 26, 2013 at 02:56:28PM +0000, John Buell wrote:
> Am 26.02.2013 01:09, schrieb John Buell:
> > Ok, I have users set up, groups set up (company departments), queues 
> > set up.... The RT box seems to be sending messages back and forth to 
> > our main Exchange box with no trouble at all.... The RT web 
> > interface itself is only viewable from within our network, but I 
> > don't personally see that as a problem.... I JUST got the RT book 
> > today and implemented the backups for MySQL (and copying a few .pm 
> > files) onto a removable USB drive with no issue, and now scheduled 
> > that to run via cron every night at midnight.... Are there any other 
> > last second gotchas I should beware of before I unleash all of my users onto RT?

On the topic of backups, I assume you've seen the new backups documentation?
http://bestpractical.com/rt/docs/latest/backups.html

Other common things - make sure you have monitoring in place on the machine, otherwise when you start to run low on space or have a load spike you'll have no way to triage what happened.

-kevin