1 files changed, 22 insertions, 8 deletions
diff --git a/rpkid/portal-gui/settings.py.in b/rpkid/portal-gui/settings.py.in
index 2800bc24..baa9197c 100644
--- a/rpkid/portal-gui/settings.py.in
+++ b/rpkid/portal-gui/settings.py.in
@@ -6,13 +6,33 @@
 # DO NOT EDIT!  This file is automatically generated from
 # settings.py.in
 
+import rpki.config
+
 DEBUG = True
 TEMPLATE_DEBUG = DEBUG
 
+# needs to be set prior to the call to rpki.config.parser so it knows
+# where to find the system rpki.conf
+rpki.config.default_dirname = '%(AC_SYSCONFDIR)s'
+
+# load the sql authentication bits from the system rpki.conf
+rpki_config = rpki.config.parser(section='web_portal')
+
 DATABASES = {
   'default' : {
-    'ENGINE': 'django.db.backends.sqlite3',
-    'NAME'  : '%(AC_DATABASE_PATH)s'
+     'ENGINE'  : 'django.db.backends.mysql',
+     'NAME'    : rpki_config.get('sql-database'),
+     'USER'    : rpki_config.get('sql-username'),
+     'PASSWORD': rpki_config.get('sql-password'),
+
+     # Ensure the default storage engine is InnoDB since we need
+     # foreign key support.  The Django documentation suggests
+     # removing this after the syncdb is performed as an optimization,
+     # but there isn't an easy way to do this automatically.
+
+     'OPTIONS' : {
+        'init_command': 'SET storage_engine=INNODB'
+     }
   }
 }
 
@@ -54,7 +74,6 @@ INSTALLED_APPS = (
     'django.contrib.admindocs',
     'django.contrib.contenttypes',
     'django.contrib.sessions',
-#    'django.contrib.staticfiles',
     'rpki.gui.app',
     'rpki.gui.cacheview'
 )
@@ -67,8 +86,3 @@ TEMPLATE_CONTEXT_PROCESSORS = (
     "django.contrib.messages.context_processors.messages",
     "django.core.context_processors.request"
 )
-
-#STATIC_URL = '/static/'
-#STATIC_ROOT = '%(AC_DATAROOTDIR)s/rpki/gui/static'
-#STATICFILES_DIRS = (("admin", "%(AC_DJANGO_DIR)s/contrib/admin/media"),)
-#STATICFILES_FINDERS = ("django.contrib.staticfiles.finders.FileSystemFinder",)