1 files changed, 53 insertions, 0 deletions
diff --git a/rp/config/rpki-sql-backup b/rp/config/rpki-sql-backup
new file mode 100755
index 00000000..986e10b1
--- /dev/null
+++ b/rp/config/rpki-sql-backup
@@ -0,0 +1,53 @@
+#!/usr/bin/env python
+
+# $Id$
+#
+# Copyright (C) 2014  Dragon Research Labs ("DRL")
+# Portions copyright (C) 2010-2013  Internet Systems Consortium ("ISC")
+#
+# Permission to use, copy, modify, and distribute this software for any
+# purpose with or without fee is hereby granted, provided that the above
+# copyright notices and this permission notice appear in all copies.
+#
+# THE SOFTWARE IS PROVIDED "AS IS" AND DRL AND ISC DISCLAIM ALL
+# WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED
+# WARRANTIES OF MERCHANTABILITY AND FITNESS.  IN NO EVENT SHALL DRL OR
+# ISC BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL
+# DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA
+# OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER
+# TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
+# PERFORMANCE OF THIS SOFTWARE.
+
+"""
+Back up data from SQL databases, looking at config file to figure out
+which databases and what credentials to use with them.
+"""
+
+import subprocess
+import os
+import argparse
+import sys
+import time
+import rpki.config
+
+os.environ["TZ"] = "UTC"
+time.tzset()
+
+parser = argparse.ArgumentParser(description = __doc__)
+parser.add_argument("-c", "--config",
+                    help = "override default location of configuration file")
+parser.add_argument("-o", "--output",
+                    type = argparse.FileType("wb"), default = sys.stdout,
+                    help = "destination for SQL dump (default: stdout)")
+args = parser.parse_args()
+
+cfg = rpki.config.parser(set_filename = args.config, section = "myrpki")
+
+for name in ("rpkid", "irdbd", "pubd"):
+    if cfg.getboolean("start_" + name, False):
+        subprocess.check_call(
+            ("mysqldump", "--add-drop-database",
+             "-u",  cfg.get("sql-username", section = name),
+             "-p" + cfg.get("sql-password", section = name),
+             "-B",  cfg.get("sql-database", section = name)),
+            stdout = args.output)