Backing up RT's configuration files?

Hello all.

I have temporary custodianship over our RT server and would like to implement some sort of simple script backup system.

I’m planning on just dumping a copy of the database onto our backup server but what other files should I tar and move off the host? I am not very familiar with the underpinnings of RT so it’s difficult for me to decide what to backup.

What files/directories should I backup so that I can quickly recover the RT server and our ticket content in the event of Something Bad™?

Thanks.

Kevin Elliott

Network Specialist
City and Borough of Juneau, MIS
(907) 586 - 0905

Hi Kevin,

I think it’s enough to back up:

  • etc/ containing RT’s config files
  • local/ containing all the extensions you added and your own customizations

Regards

Inizio: rt-users-bounces@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] per conto di Kevin Elliott [kevin_elliott@ci.juneau.ak.us]
Inviato: giovedì 12 luglio 2012 19.52
Fine: rt-users@lists.bestpractical.com
Oggetto: [rt-users] Backing up RT’s configuration files?

Hello all.

I have temporary custodianship over our RT server and would like to implement some sort of simple script backup system.

I’m planning on just dumping a copy of the database onto our backup server but what other files should I tar and move off the host? I am not very familiar with the underpinnings of RT so it’s difficult for me to decide what to backup.

What files/directories should I backup so that I can quickly recover the RT server and our ticket content in the event of Something Bad™?

Thanks.

Kevin Elliott

Network Specialist
City and Borough of Juneau, MIS
(907) 586 - 0905

Alberto Scotto

Blue Reply
Via Cardinal Massaia, 83
10147 - Torino - ITALY
phone: +39 011 29100
al.scotto@reply.it
www.reply.it

The information transmitted is intended for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

I think it’s enough to back up:

  • etc/ containing RT’s config files
  • local/ containing all the extensions you added and your own customizations

/opt/rt4 is pretty tiny, you should back the whole thing up (ignoring
var/mason_data/ if you want).
Otherwise you’d miss something like your GPG config if you skipped
/opt/rt4/var

Don’t forget your apache and email configurations which won’t be under
RT’s directory.

-kevin

A small add: I assumed that all your customizations were made following official guidelines, i.e. putting everything under local/ path. If you are unsure, include lib/ directory in your backup.

Moreover, here are two semi-official backup scripts:

http://requesttracker.wikia.com/wiki/BackupRTDB
http://requesttracker.wikia.com/wiki/BackupRT

Inizio: rt-users-bounces@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] per conto di Scotto Alberto [al.scotto@reply.it]
Inviato: giovedì 12 luglio 2012 20.13
Fine: Kevin Elliott; rt-users@lists.bestpractical.com
Oggetto: [rt-users] R: Backing up RT’s configuration files?

Hi Kevin,

I think it’s enough to back up:

  • etc/ containing RT’s config files
  • local/ containing all the extensions you added and your own customizations

Regards

Inizio: rt-users-bounces@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] per conto di Kevin Elliott [kevin_elliott@ci.juneau.ak.us]
Inviato: giovedì 12 luglio 2012 19.52
Fine: rt-users@lists.bestpractical.com
Oggetto: [rt-users] Backing up RT’s configuration files?

Hello all.

I have temporary custodianship over our RT server and would like to implement some sort of simple script backup system.

I’m planning on just dumping a copy of the database onto our backup server but what other files should I tar and move off the host? I am not very familiar with the underpinnings of RT so it’s difficult for me to decide what to backup.

What files/directories should I backup so that I can quickly recover the RT server and our ticket content in the event of Something Bad™?

Thanks.

Kevin Elliott

Network Specialist
City and Borough of Juneau, MIS
(907) 586 - 0905

Alberto Scotto

Blue Reply
Via Cardinal Massaia, 83
10147 - Torino - ITALY
phone: +39 011 29100
al.scotto@reply.it
www.reply.it

The information transmitted is intended for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Alberto Scotto

Blue Reply
Via Cardinal Massaia, 83
10147 - Torino - ITALY
phone: +39 011 29100
al.scotto@reply.it
www.reply.it

The information transmitted is intended for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Moreover, here are two semi-official backup scripts:

http://requesttracker.wikia.com/wiki/BackupRTDB
http://requesttracker.wikia.com/wiki/BackupRT

Those are not even semi-official. They’re 100% user contributed.
Anything official ships with RT inside the tarballs or is released as an
extension by Best Practical to CPAN.

Sorry all - I’m a bit confused on where these files live.

I have RT-ish stuff in:

/usr/share/request-tracker4
/usr/local/share/request-tracker4
/etc/request-tracker4

Should I just grab all of those directories in my backup?

What about the mail filters for each queue? I can’t find anything in /etc/postfix/ that looks related. Are the filters configured within-RT?

I’m working with a Debian server for what its worth.-----Original Message-----
From: Scotto Alberto [mailto:al.scotto@reply.it]
Sent: Thursday, July 12, 2012 10:14 AM
To: Kevin Elliott; rt-users@lists.bestpractical.com
Subject: R: Backing up RT’s configuration files?

Hi Kevin,

I think it’s enough to back up:

  • etc/ containing RT’s config files
  • local/ containing all the extensions you added and your own customizations

Regards

Inizio: rt-users-bounces@lists.bestpractical.com [rt-users-bounces@lists.bestpractical.com] per conto di Kevin Elliott [kevin_elliott@ci.juneau.ak.us]
Inviato: giovedì 12 luglio 2012 19.52
Fine: rt-users@lists.bestpractical.com
Oggetto: [rt-users] Backing up RT’s configuration files?

Hello all.

I have temporary custodianship over our RT server and would like to implement some sort of simple script backup system.

I’m planning on just dumping a copy of the database onto our backup server but what other files should I tar and move off the host? I am not very familiar with the underpinnings of RT so it’s difficult for me to decide what to backup.

What files/directories should I backup so that I can quickly recover the RT server and our ticket content in the event of Something Bad™?

Thanks.

Kevin Elliott

Network Specialist
City and Borough of Juneau, MIS
(907) 586 - 0905

Alberto Scotto

Blue Reply
Via Cardinal Massaia, 83
10147 - Torino - ITALY
phone: +39 011 29100
al.scotto@reply.it
www.reply.it

The information transmitted is intended for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Sorry all - I’m a bit confused on where these files live.

I have RT-ish stuff in:

/usr/share/request-tracker4
/usr/local/share/request-tracker4
/etc/request-tracker4

Should I just grab all of those directories in my backup?

Yes. See dpkg -L request-tracker4 for all the files the Debian
package installed, and if there are any directories you missed.

With the official packages this is slightly easier since everything
lives under one directory (/opt/rt4).

What about the mail filters for each queue? I can’t find anything in /etc/postfix/ that looks related. Are the filters configured within-RT?

/etc/aliases?

Don’t forget your crontab for RT.