From 8ada594d05c4e79fc2e3a13b50489bb75bd90cae Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Thu, 7 Oct 2010 00:12:50 +0000 Subject: Stash a copy of pre-conversion (with TLS) tree temporarily, in case of problems during switchover. Will clean this up after testbed is back up without TLS. svn path=/rpkid.with_tls; revision=3464 --- rpkid.with_tls/tests/sql-dumper.py | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 rpkid.with_tls/tests/sql-dumper.py (limited to 'rpkid.with_tls/tests/sql-dumper.py') diff --git a/rpkid.with_tls/tests/sql-dumper.py b/rpkid.with_tls/tests/sql-dumper.py new file mode 100644 index 00000000..4437d858 --- /dev/null +++ b/rpkid.with_tls/tests/sql-dumper.py @@ -0,0 +1,32 @@ +""" +Dump backup copies of SQL tables used by these programs. + +$Id$ + +Copyright (C) 2009-2010 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 notice and this permission notice appear in all copies. + +THE SOFTWARE IS PROVIDED "AS IS" AND ISC DISCLAIMS ALL WARRANTIES WITH +REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY +AND FITNESS. IN NO EVENT SHALL 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. +""" + +import subprocess, rpki.config + +cfg = rpki.config.parser("yamltest.conf", "yamltest") + +for name in ("rpkid", "irdbd", "pubd"): + + username = cfg.get("%s_sql_username" % name, name[:4]) + password = cfg.get("%s_sql_password" % name, "fnord") + + cmd = ["mysqldump", "-u", username, "-p" + password, "--databases", name[:4]] + cmd.extend("%s%d" % (name[:4], i) for i in xrange(12)) + subprocess.check_call(cmd, stdout = open("backup.%s.sql" % name, "w")) -- cgit v1.2.3