1 files changed, 32 insertions, 0 deletions
diff --git a/potpourri/rpkigui-sync-users.py b/potpourri/rpkigui-sync-users.py
new file mode 100644
index 00000000..9c636e95
--- /dev/null
+++ b/potpourri/rpkigui-sync-users.py
@@ -0,0 +1,32 @@
+# Copyright (C) 2013  SPARTA, Inc. a Parsons Company
+#
+# 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 SPARTA DISCLAIMS ALL WARRANTIES WITH
+# REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
+# AND FITNESS.  IN NO EVENT SHALL SPARTA 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.
+
+__version__ = '$Id$'
+
+"""
+Ensure that a web login exists for labuser* resource holder
+"""
+from rpki.gui.script_util import setup
+setup()
+
+from django.contrib.auth.models import User
+from rpki.gui.app.models import Conf, ConfACL
+
+# mysql> select * from irdb_resourceholderca left outer join auth_user on irdb_resourceholderca.handle = auth_user.username where username=NULL;
+
+for conf in Conf.objects.filter(handle__startswith='labuser'):
+    if not User.objects.filter(username=conf.handle).exists():
+        print 'creating matching user for ' + conf.handle
+        user = User.objects.create_user(conf.handle, password='fnord')
+        ConfACL.objects.create(conf=conf, user=user)