c9BsLUpY

1MultiValueDictKeyError at /system/response-types/answer/update/1257/
2"u'components_formset-1-id'"
3
4Request Method: POST
5Request URL: http://client.nwc.local:8080/system/response-types/answer/update/1257/
6Django Version: 1.6.10
7Python Executable: /home/iza/.virtualenvs/nwc/bin/python
8Python Version: 2.7.3
9Python Path: ['/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/libs', '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python', '/home/iza/.virtualenvs/nwc/src/django-multilingual', '/home/iza/.virtualenvs/nwc/src/django-easy-badbrowser', '/home/iza/.virtualenvs/nwc/src/django-badbrowser', '/home/iza/.virtualenvs/nwc/src/django-reversion/src', '/home/iza/.virtualenvs/nwc/src/djangocms-text-ckeditor', '/home/iza/.virtualenvs/nwc/src/django-redshift', '/home/iza/.virtualenvs/nwc/lib/python2.7', '/home/iza/.virtualenvs/nwc/lib/python2.7/plat-linux2', '/home/iza/.virtualenvs/nwc/lib/python2.7/lib-tk', '/home/iza/.virtualenvs/nwc/lib/python2.7/lib-old', '/home/iza/.virtualenvs/nwc/lib/python2.7/lib-dynload', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-linux2', '/usr/lib/python2.7/lib-tk', '/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages', '/usr/local/lib/python2.7/site-packages', '/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages/PIL', '/usr/lib/python2.7/dist-packages/gst-0.10', '/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/python2.7/dist-packages/ubuntu-sso-client', '/usr/lib/python2.7/dist-packages/ubuntuone-client', '/usr/lib/python2.7/dist-packages/ubuntuone-control-panel', '/usr/lib/python2.7/dist-packages/ubuntuone-couch', '/usr/lib/python2.7/dist-packages/ubuntuone-installer', '/usr/lib/python2.7/dist-packages/ubuntuone-storage-protocol']
10Server time: Tue, 26 Jan 2016 14:31:20 +0000
11Installed Applications:
12['djangocms_admin_style',
13 'djangocms_text_ckeditor',
14 'django.contrib.auth',
15 'django.contrib.contenttypes',
16 'django.contrib.sessions',
17 'django.contrib.messages',
18 'django.contrib.staticfiles',
19 'django.contrib.humanize',
20 'django.contrib.sites',
21 'django.contrib.humanize',
22 'django.contrib.formtools',
23 'grappelli.dashboard',
24 'grappelli',
25 'filebrowser',
26 'floppyforms',
27 'django.contrib.admin',
28 'axes',
29 'cms',
30 'mptt',
31 'menus',
32 'password_policies',
33 'south',
34 'sekizai',
35 'djangocms_column',
36 'djangocms_inherit',
37 'djangocms_link',
38 'raven.contrib.django.raven_compat',
39 'reversion',
40 'nwc.common',
41 'nwc.histories',
42 'nwc.globals',
43 'nwc.globals.tenants',
44 'nwc.globals.aws',
45 'nwc.builds',
46 'nwc.builds.api',
47 'nwc.build_base',
48 'nwc.builds.cmspages',
49 'nwc.builds.criteria',
50 'nwc.builds.extensions',
51 'nwc.builds.extensions.database_connector',
52 'nwc.builds.extensions.post_code',
53 'nwc.builds.extensions.s3_upload',
54 'nwc.builds.extensions.rds_storage',
55 'nwc.builds.extensions.sms',
56 'nwc.builds.extensions.sms.pageone',
57 'nwc.builds.extensions.cc_pdfs',
58 'nwc.builds.extensions.truthtables',
59 'nwc.builds.levels',
60 'nwc.builds.logicons',
61 'nwc.builds.patrons',
62 'nwc.builds.properties',
63 'nwc.builds.responsetypes',
64 'nwc.builds.responsetypes.plugins.internal.rt_activity',
65 'nwc.builds.responsetypes.plugins.internal.rt_text',
66 'nwc.builds.responsetypes.plugins.internal.rt_select',
67 'nwc.builds.responsetypes.plugins.internal.rt_datepicker',
68 'nwc.builds.responsetypes.plugins.internal.rt_document',
69 'nwc.builds.responsetypes.plugins.internal.rt_fieldupdater',
70 'nwc.builds.responsetypes.plugins.internal.rt_webcheck',
71 'nwc.builds.responsetypes.plugins.internal.rt_webscrape',
72 'nwc.builds.responsetypes.plugins.internal.rt_message',
73 'nwc.builds.responsetypes.plugins.idchecker.rt_idcheck',
74 'nwc.builds.responsetypes.plugins.idchecker.rt_iddocument',
75 'nwc.builds.responsetypes.plugins.gbgroup.rt_basic_identity',
76 'nwc.builds.responsetypes.plugins.synety.rt_c2c',
77 'nwc.builds.responsetypes.validators',
78 'nwc.builds.roles',
79 'nwc.builds.variables',
80 'nwc.response_type',
81 'nwc.swfupload',
82 'nwc.accounts',
83 'nwc.pdf_generator',
84 'ckeditor',
85 'django_extensions',
86 'django_jenkins',
87 'nwc.customfields',
88 'nwc.globals.partners',
89 'nwc.builds.sequencer',
90 'nwc.globals.signup',
91 'nwc.globals.licenses',
92 'nwc.globals.general',
93 'nwc.globals.emailconfigs',
94 'nwc.globals.noticetemplates',
95 'nwc.reminders',
96 'nwc.builds.communication',
97 'nwc.builds.revalidations',
98 'nwc.builds.confs',
99 'nwc.builds.targetimports',
100 'nwc.builds.targetimports.backends.targetimportmail',
101 'nwc.builds.ckeditorextra',
102 'nwc.builds.filestore',
103 'nwc.builds.targets',
104 'nwc.builds.dashboard_v2',
105 'nwc.builds.design',
106 'nwc.builds.taskqueue',
107 'nwc.builds.categories',
108 'nwc.housekeeping',
109 'nwc.viewpermissions',
110 'nwc.softdeletion',
111 'nwc.versioning',
112 'djcelery',
113 'djkombu',
114 'djcelery_email',
115 'sorl.thumbnail',
116 'rosetta-grappelli',
117 'rosetta',
118 'pagination',
119 'httplib2',
120 'openid',
121 'oauth2',
122 'social_auth',
123 'nwc.accountssocial',
124 'qrcode',
125 'endless_pagination',
126 'loginurl',
127 'nwc.globals.store',
128 'tagging',
129 'django_badbrowser',
130 'django_js_reverse',
131 'guardian',
132 'nwc.builds.extensions.analytics',
133 'nwc.patcher',
134 'debug_toolbar']
135Installed Middleware:
136(u'debug_toolbar.middleware.DebugToolbarMiddleware',
137 'django_statsd.middleware.GraphiteRequestTimingMiddleware',
138 'django_statsd.middleware.GraphiteMiddleware',
139 'nwc.common.middleware.DBConnectionUnloadMiddleware',
140 'nwc.common.middleware.SubdomainsMiddleware',
141 'nwc.requestprovider.middleware.RequestProvider',
142 'nwc.swfupload.middleware.SWFUploadMiddleware',
143 'django.contrib.sessions.middleware.SessionMiddleware',
144 'django.middleware.common.CommonMiddleware',
145 'django.middleware.csrf.CsrfViewMiddleware',
146 'nwc.accounts.middleware.AuthenticationMiddleware',
147 'django.contrib.messages.middleware.MessageMiddleware',
148 'django.middleware.clickjacking.XFrameOptionsMiddleware',
149 'axes.middleware.FailedLoginMiddleware',
150 'nwc.builds.roles.middleware.RestrictByIpMiddleware',
151 'nwc.builds.roles.middleware.SessionTimeoutMiddleware',
152 'nwc.builds.roles.middleware.PasswordChangeMiddleware',
153 'cms.middleware.user.CurrentUserMiddleware',
154 'cms.middleware.page.CurrentPageMiddleware',
155 'cms.middleware.toolbar.ToolbarMiddleware',
156 'nwc.accounts.middleware.MasqueradeMiddleware',
157 'nwc.accounts.middleware.UserVisitMiddleware',
158 'nwc.common.middleware.ExceptionMiddleware',
159 'nwc.common.middleware.BrowserSupportDetectionHack',
160 'nwc.common.middleware.BleachMiddleware')
161
162Traceback:
163File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
164  112.                     response = wrapped_callback(request, *callback_args, **callback_kwargs)
165File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/db/transaction.py" in inner
166  371.                 return func(*args, **kwargs)
167File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/db/transaction.py" in inner
168  371.                 return func(*args, **kwargs)
169File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/views/generic/base.py" in view
170  69.             return self.dispatch(request, *args, **kwargs)
171File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/views/generic/base.py" in dispatch
172  87.         return handler(request, *args, **kwargs)
173File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/builds/responsetypes/plugins/views.py" in post
174  97.         return self.get_view()(*args, **kwargs)
175File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/views/generic/base.py" in view
176  69.             return self.dispatch(request, *args, **kwargs)
177File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapper
178  29.             return bound_func(*args, **kwargs)
179File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/common/decorators.py" in result
180  114.             return view(request, *args, **kwargs)
181File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/utils/decorators.py" in bound_func
182  25.                 return func(self, *args2, **kwargs2)
183File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapper
184  29.             return bound_func(*args, **kwargs)
185File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/common/decorators.py" in result
186  59.                 return view(request, *args, **kwargs)
187File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/utils/decorators.py" in bound_func
188  25.                 return func(self, *args2, **kwargs2)
189File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/builds/responsetypes/views/target.py" in dispatch
190  214.         return super(ResponseDispatcher, self).dispatch( *args, **kwargs)
191File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/common/views.py" in dispatch
192  242.         return super(Dispatcher, self).dispatch(request, *args, **kwargs)
193File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/views/generic/base.py" in dispatch
194  87.         return handler(request, *args, **kwargs)
195File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/common/views.py" in post
196  399.         if self.all_valid(self._forms):
197File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/builds/responsetypes/plugins/views.py" in all_valid
198  230.         return super(BasePluginAnswerView, self).all_valid(forms)
199File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/common/views.py" in all_valid
200  408.         return all_valid(forms.values())
201File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/forms/formsets.py" in all_valid
202  415.         if not formset.is_valid():
203File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/builds/responsetypes/plugins/forms.py" in is_valid
204  761.         return self.all_valid(self._forms)
205File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/builds/responsetypes/plugins/forms.py" in all_valid
206  1242.         return super(PluginComponentAnswerForm, self).all_valid(forms_to_validate)
207File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/common/views.py" in all_valid
208  408.         return all_valid(forms.values())
209File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/forms/formsets.py" in all_valid
210  415.         if not formset.is_valid():
211File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/forms/formsets.py" in is_valid
212  292.         err = self.errors
213File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/forms/formsets.py" in errors
214  267.             self.full_clean()
215File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/forms/formsets.py" in full_clean
216  314.             form = self.forms[i]
217File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/utils/functional.py" in __get__
218  49.         res = instance.__dict__[self.func.__name__] = self.func(instance)
219File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/forms/formsets.py" in forms
220  133.         forms = [self._construct_form(i) for i in xrange(self.total_form_count())]
221File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/forms/models.py" in _construct_form
222  848.         form = super(BaseInlineFormSet, self)._construct_form(i, **kwargs)
223File "/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/patcher/__init__.py" in _construct_form
224  25.         pk = self.data[pk_key]
225File "/home/iza/.virtualenvs/nwc/local/lib/python2.7/site-packages/django/utils/datastructures.py" in __getitem__
226  301.             raise MultiValueDictKeyError(repr(key))
227
228Exception Type: MultiValueDictKeyError at /system/response-types/answer/update/1257/
229Exception Value: "u'components_formset-1-id'"
230Request information:
231GET: No GET data
232
233POST:
234components_formset-0-id = u'398'
235input_search = u''
236response_value = u'394'
237_prefix = u'components_formset'
238components_formset-TOTAL_FORMS = u'2'
239components_formset-1-component = u'394'
240components_formset-MAX_NUM_FORMS = u'1000'
241csrfmiddlewaretoken = u'xxqN2VJ1beqibxzhd1bQgjSqwi0Sa673'
242direct_attachment_upload_field_244 = u'5861d033-398c-4837-b7cf-10c25f014eee'
243components_formset-INITIAL_FORMS = u'2'
244components_formset-0-component = u'392'
245_save = u'Update'
246
247FILES: No FILES data
248
249COOKIES:
250csrftoken = 'xxqN2VJ1beqibxzhd1bQgjSqwi0Sa673'
251djdt = 'hide'
252sessionid = 'jd6s2wib9lcqni8lcrdu8lb0s66ib929'
253
254META:
255RUN_MAIN = 'true'
256HTTP_REFERER = 'http://client.nwc.local:8080/dashboard/'
257SERVER_SOFTWARE = 'WSGIServer/0.1 Python/2.7.3'
258SCRIPT_NAME = u''
259REQUEST_METHOD = 'POST'
260HTTP_ORIGIN = 'http://client.nwc.local:8080'
261SERVER_PROTOCOL = 'HTTP/1.1'
262LC_PAPER = 'en_GB.UTF-8'
263HOME = '/home/iza'
264DISPLAY = ':0'
265LANG = 'pl_PL.UTF-8'
266VIRTUAL_ENV = '/home/iza/.virtualenvs/nwc'
267SHELL = '/bin/bash'
268LC_MONETARY = 'en_GB.UTF-8'
269MANDATORY_PATH = '/usr/share/gconf/ubuntu.mandatory.path'
270SERVER_PORT = '8080'
271JAVA_HOME = '/usr/lib/jvm/java-7-oracle'
272WORKON_HOME = '/home/iza/.virtualenvs'
273HTTP_PRAGMA = 'no-cache'
274HTTP_X_REQUESTED_WITH = 'XMLHttpRequest'
275LC_IDENTIFICATION = 'en_GB.UTF-8'
276LC_ADDRESS = 'en_GB.UTF-8'
277COMP_WORDBREAKS = ' \t\n"\'><;|&(:'
278J2SDKDIR = '/usr/lib/jvm/java-7-oracle'
279HTTP_CACHE_CONTROL = 'no-cache'
280HTTP_CONNECTION = 'keep-alive'
281HTTP_HOST = 'client.nwc.local:8080'
282GNOME_KEYRING_PID = '2266'
283wsgi.version = 
284XDG_CURRENT_DESKTOP = 'Unity'
285DBUS_SESSION_BUS_ADDRESS = 'unix:abstract=/tmp/dbus-gEi730wZ8r,guid=70becc9009bf90aef25d483800000034'
286VIRTUALENVWRAPPER_HOOK_DIR = '/home/iza/.virtualenvs'
287HTTP_ACCEPT = '*/*'
288TERMCAP = 'SC|screen|VT 100/ANSI X3.64 virtual terminal:\\\n\t:DO=\\E[%dB:LE=\\E[%dD:RI=\\E[%dC:UP=\\E[%dA:bs:bt=\\E[Z:\\\n\t:cd=\\E[J:ce=\\E[K:cl=\\E[H\\E[J:cm=\\E[%i%d;%dH:ct=\\E[3g:\\\n\t:do=^J:nd=\\E[C:pt:rc=\\E8:rs=\\Ec:sc=\\E7:st=\\EH:up=\\EM:\\\n\t:le=^H:bl=^G:cr=^M:it#8:ho=\\E[H:nw=\\EE:ta=^I:is=\\E)0:\\\n\t:li#24:co#80:am:xn:xv:LP:sr=\\EM:al=\\E[L:AL=\\E[%dL:\\\n\t:cs=\\E[%i%d;%dr:dl=\\E[M:DL=\\E[%dM:dc=\\E[P:DC=\\E[%dP:\\\n\t:im=\\E[4h:ei=\\E[4l:mi:IC=\\E[%d@:ks=\\E[?1h\\E=:\\\n\t:ke=\\E[?1l\\E>:vi=\\E[?25l:ve=\\E[34h\\E[?25h:vs=\\E[34l:\\\n\t:ti=\\E[?1049h:te=\\E[?1049l:us=\\E[4m:ue=\\E[24m:so=\\E[3m:\\\n\t:se=\\E[23m:mb=\\E[5m:md=\\E[1m:mr=\\E[7m:me=\\E[m:ms:\\\n\t:Co#8:pa#64:AF=\\E[3%dm:AB=\\E[4%dm:op=\\E[39;49m:AX:\\\n\t:vb=\\Eg:G0:as=\\E(0:ae=\\E(B:\\\n\t:ac=\\140\\140aaffggjjkkllmmnnooppqqrrssttuuvvwwxxyyzz{{||}}~~..--++,,hhII00:\\\n\t:po=\\E[5i:pf=\\E[4i:k0=\\E[10~:k1=\\EOP:k2=\\EOQ:k3=\\EOR:\\\n\t:k4=\\EOS:k5=\\E[15~:k6=\\E[17~:k7=\\E[18~:k8=\\E[19~:\\\n\t:k9=\\E[20~:k;=\\E[21~:F1=\\E[23~:F2=\\E[24~:F3=\\E[1;2P:\\\n\t:F4=\\E[1;2Q:F5=\\E[1;2R:F6=\\E[1;2S:F7=\\E[15;2~:\\\n\t:F8=\\E[17;2~:F9=\\E[18;2~:FA=\\E[19;2~:kb=\x7f:K2=\\EOE:\\\n\t:kB=\\E[Z:kF=\\E[1;2B:kR=\\E[1;2A:*4=\\E[3;2~:*7=\\E[1;2F:\\\n\t:#2=\\E[1;2H:#3=\\E[2;2~:#4=\\E[1;2D:%c=\\E[6;2~:%e=\\E[5;2~:\\\n\t:%i=\\E[1;2C:kh=\\E[1~:@1=\\E[1~:kH=\\E[4~:@7=\\E[4~:\\\n\t:kN=\\E[6~:kP=\\E[5~:kI=\\E[2~:kD=\\E[3~:ku=\\EOA:kd=\\EOB:\\\n\t:kr=\\EOC:kl=\\EOD:km:'
289DESKTOP_SESSION = 'ubuntu'
290LESSCLOSE = '/usr/bin/lesspipe %s %s'
291DEFAULTS_PATH = '/usr/share/gconf/ubuntu.default.path'
292wsgi.run_once = False
293wsgi.errors = <open file '<stderr>', mode 'w' at 0x7fbf59167270>
294GATEWAY_INTERFACE = 'CGI/1.1'
295HTTP_ACCEPT_LANGUAGE = 'pl-PL,pl;q=0.8,en-US;q=0.6,en;q=0.4'
296LC_NAME = 'en_GB.UTF-8'
297LS_COLORS = 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:'
298PATH_INFO = u'/system/response-types/answer/update/1257/'
299LC_NUMERIC = 'en_GB.UTF-8'
300wsgi.multiprocess = False
301HTTP_COOKIE = 'djdt=hide; csrftoken=xxqN2VJ1beqibxzhd1bQgjSqwi0Sa673; sessionid=jd6s2wib9lcqni8lcrdu8lb0s66ib929'
302GNOME_DESKTOP_SESSION_ID = 'this-is-deprecated'
303LESSOPEN = '| /usr/bin/lesspipe %s'
304LOGNAME = 'iza'
305USER = 'iza'
306GNOME_KEYRING_CONTROL = '/tmp/keyring-uw48kc'
307QUERY_STRING = ''
308PATH = '/home/iza/.virtualenvs/nwc/bin:/home/iza/bin:/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/lib/jvm/java-7-oracle/bin:/usr/lib/jvm/java-7-oracle/db/bin:/usr/lib/jvm/java-7-oracle/jre/bin'
309PS1 = '(nwc)\\[\\033[0;32m\\]\\w\\$\\[\\033[0m\\]'
310SSH_AGENT_PID = '9167'
311TERM = 'screen'
312HTTP_USER_AGENT = 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36'
313XDG_SESSION_PATH = '/org/freedesktop/DisplayManager/Session0'
314XDG_SESSION_COOKIE = '7dbb5302c0523de6504038bf0000000e-1453793744.941027-1302688459'
315SERVER_NAME = 'elasticache.nwc.int'
316SESSION_MANAGER = 'local/kido:@/tmp/.ICE-unix/2277,unix/kido:/tmp/.ICE-unix/2277'
317LC_MEASUREMENT = 'en_GB.UTF-8'
318WINDOW = '0'
319wsgi.url_scheme = 'http'
320COMPIZ_CONFIG_PROFILE = 'ubuntu'
321WINDOWID = '65011718'
322GPG_AGENT_INFO = '/tmp/keyring-uw48kc/gpg:0:1'
323CONTENT_LENGTH = '433'
324SHLVL = '2'
325CONTENT_TYPE = 'application/x-www-form-urlencoded; charset=UTF-8'
326SSH_AUTH_SOCK = '/tmp/ssh-abPgJvop9165/agent.9165'
327GDMSESSION = 'ubuntu'
328CELERY_LOADER = 'djcelery.loaders.DjangoLoader'
329wsgi.input = <socket._fileobject object at 0x7fbf3cc81b50>
330wsgi.multithread = True
331XDG_SEAT_PATH = '/org/freedesktop/DisplayManager/Seat0'
332TZ = 'Europe/London'
333STY = '9178.pts-0.kido'
334_ = '/home/iza/.virtualenvs/nwc/bin/python'
335XAUTHORITY = '/home/iza/.Xauthority'
336VIRTUALENVWRAPPER_PROJECT_FILENAME = '.project'
337DERBY_HOME = '/usr/lib/jvm/java-7-oracle/db'
338J2REDIR = '/usr/lib/jvm/java-7-oracle/jre'
339XDG_CONFIG_DIRS = '/etc/xdg/xdg-ubuntu:/etc/xdg'
340UBUNTU_MENUPROXY = 'libappmenu.so'
341CSRF_COOKIE = u'xxqN2VJ1beqibxzhd1bQgjSqwi0Sa673'
342OLDPWD = '/home/iza'
343REMOTE_ADDR = '127.0.0.1'
344LC_TELEPHONE = 'en_GB.UTF-8'
345XDG_DATA_DIRS = '/usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/'
346PWD = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python'
347DJANGO_SETTINGS_MODULE = 'nwc.settings'
348COLORTERM = 'gnome-terminal'
349LC_TIME = 'en_GB.UTF-8'
350wsgi.file_wrapper = ''
351REMOTE_HOST = ''
352HTTP_ACCEPT_ENCODING = 'gzip, deflate'
353
354Settings:
355Using settings module nwc.settings
356PASSWORD_DURATION_SECONDS = u'********************'
357BROKER_TRANSPORT_OPTIONS = {'region': 'eu-west-1', 'visibility_timeout': 3600}
358SOUTH_DATABASE_ADAPTERS = {'default': 'south.db.mysql'}
359CKEDITOR_MEDIA_PREFIX = '/static/common/lib/ckeditor/'
360USE_L10N = False
361GOOGLE_CHAT_ID = 'michealadams811@gmail.com'
362COTTERPIN_POSTCODE_PATH = '/pca/postcode/'
363GA_CODE_SIGNUP_APP_ENTERPRISE = '\n'
364CELERY_SEND_TASK_SENT_EVENT = True
365BROKER_URL = 'amqp://admin:nwc@localhost:5672//'
366COTTERPIN_WEBCHECK_PATH = '/web-check/'
367SESSION_SERIALIZER = 'django.contrib.sessions.serializers.PickleSerializer'
368SOCIAL_AUTH_RAISE_EXCEPTIONS = False
369SITE_PROTOCOL = 'http'
370DEFAULT_CONTACT_EMAIL = 'contact@nowwecomply.com'
371SOCIAL_AUTH_ASSOCIATE_URL_NAME = 'socialauth_associate_complete'
372MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
373REMINDERS_CONTEXT_PROCESSORS = 
374MAIN_PAGE_URL_FOR_PARTNER_ACCOUNT = '/partner/home/'
375AWS_DB_HISTORY_SUBSCRIPTIONS = ['rds-prod-conf-change']
376SESSION_COOKIE_NAME = 'sessionid'
377BUILD_RT_C2C_RECORDINGS_DIR_NAME = 'response_types/c2c/recordings'
378COTTERPIN_BASIC_IDENTITY_PATH = '/gb-group/basic-identity-check/'
379SITE_URL = 'http://nwc.local:8080'
380PROTOCOL_HTTPS = 'https'
381SERVER_EMAIL = 'noreply@nowwecomply.com'
382PCA_API_KEY = u'********************'
383FIRST_DAY_OF_WEEK = 0
384CMS_PLUGIN_PROCESSORS = 'nwc.builds.cmspages.plugin_processors.render_merge_fields'
385CACHES = {'default': {'BACKEND': 'django.core.cache.backends.dummy.DummyCache'}, 'task_queue': {'BACKEND': 'redis_cache.cache.RedisCache', 'OPTIONS': {'IGNORE_EXCEPTIONS': True, 'CLIENT_CLASS': 'redis_cache.client.DefaultClient'}, 'KEY_PREFIX': u'********************', 'LOCATION': 'localhost:6379:2'}, 'task_lock': {'BACKEND': 'redis_cache.cache.RedisCache', 'OPTIONS': {'IGNORE_EXCEPTIONS': True, 'CLIENT_CLASS': 'redis_cache.client.DefaultClient'}, 'KEY_PREFIX': u'********************', 'LOCATION': 'localhost:6379:1'}, 'data': {'BACKEND': 'django.core.cache.backends.filebased.FileBasedCache', 'OPTIONS': {'MAX_ENTRIES': 1000000000}, 'LOCATION': '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/shared/cache/data'}}
386SESSION_COOKIE_PATH = '/'
387SOCIAL_AUTH_PARTIAL_PIPELINE_KEY = u'********************'
388AWS_DYNAMODB_HOST = 'localhost'
389AWS_DNS_MAPPING = {}
390GET_SITE_URL = 'http://nwc.local:8080'
391BUILD_RT_WEBSCRAPE_SCREENS_DIR_NAME = 'response_types/webscrape/screens'
392DEFAULT_INDEX_TABLESPACE = ''
393BUILD_CLIENT_LOGO = 'logo'
394COTTERPIN_VALIDATOR_DECIMAL = '/check/decimal/'
395CELERY_DEFAULT_EXCHANGE = 'nwc'
396USE_X_FORWARDED_HOST = False
397BUILD_RESPONSE_ATTACHMENTS_DIR_NAME = 'response/attachments'
398ASYNC_HISTORY = False
399SOCIAL_AUTH_REDIRECT_IS_HTTPS = False
400CSRF_COOKIE_DOMAIN = None
401FILE_CHARSET = 'utf-8'
402DEBUG = True
403SESSION_FILE_PATH = None
404REMINDERS_SMS_ENDPOINT = 'https://sms.openmarket.com/sms/v1/send'
405STATICFILES_DIRS = 
406AXES_USERNAME_FORM_FIELD = 'credentials-username'
407SECURE_PROXY_SSL_HEADER = 
408AWS_SECRET_ACCESS_KEY = u'********************'
409DEBUG_PROPAGATE_EXCEPTIONS = False
410REMINDERS_SMS_DELIVERY_REPORT = 2
411ALLOWED_MIMETYPES = ['text/plain', 'text/csv', 'image/jpeg', 'image/gif', 'image/png', 'application/pdf', 'application/msword', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document']
412MONTH_DAY_FORMAT = 'F j'
413BUILD_PREVIEWS = 'previews'
414GA_CODE = '\n'
415APP_DATABASE_MAP = {}
416COTTERPIN_VALIDATOR_IDC9 = '/check/idc9/'
417USE_THOUSAND_SEPARATOR = False
418CELERY_DISABLE_RATE_LIMITS = True
419TWITTER_ACCESS_TOKEN = u'********************'
420TARGET_PATRON_CREATE_QUERY = 'CREATE TABLE {build}.target_patrons (\n    target_id int not null primary key encode delta,\n    target_name varchar(255) not null encode lzo\n)\ndiststyle even\nsortkey(target_id);'
421CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
422LOGIN_REDIRECT_URL = '/'
423DECIMAL_SEPARATOR = '.'
424TENANT_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/shared/tenant'
425IGNORABLE_404_URLS = 
426TARGET_DATADETAILS_CREATE_QUERY = 'CREATE TABLE {build}.target_data_details (\n    id bigint not null primary key identity encode delta,\n    data_id int4 not null encode lzo,\n    field_name varchar(255) null encode lzo,\n    field_value varchar(65535) null encode lzo,\n    foreign key(data_id) references {build}.target_data(id)\n)\ndiststyle even\nsortkey(data_id);'
427TARGET_LATESTCRITERIA_DELETE_QUERY = 'drop view if exists target_latest_criteria;'
428TEMPLATE_STRING_IF_INVALID = ''
429COTTERPIN_WEBCHECK_PROCESS_WEB_PATH = '/web-process/'
430GOOGLE_CHAT_PORT = '5223'
431FIXTURE_DIRS = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/build_base/fixtures/'
432TWITTER_ACCESS_TOKEN_SECRET = u'********************'
433FACEBOOK_USER_ID = 'micheal.adam.583@chat.facebook.com'
434DATETIME_INPUT_FORMATS_US = 
435CELERY_ROUTES = 
436FORMAT_MODULE_PATH = None
437CLMS_HOST = 'clms.nwc.dt.fcpl.com'
438TARGET_CURRENTDATA_VIEW_QUERY = 'create or replace view target_log_latest as\n    select target_log.target_id as tid, target_log.type_name, target_log.group_name,\n           target_log.created_at, target_log_detail.field_name, target_log_detail.field_value\n    from target_log join target_log_detail on target_log.id = target_log_detail.target_log_id\n    where target_log.id = (select max(tl.id) from target_log as tl where tl.target_id = target_log.target_id);'
439DISALLOWED_USER_AGENTS = 
440REMINDERS_SMS_PASSWORD = u'********************'
441AWS_INSTANCE_CLASS_DEFAULT = 'db.t2.micro'
442AWS_DB_HISTORY_DNS_PATTERN = 'history.{clientID}.prod'
443BUILD_EMAIL_FOOTERS_DIR_NAME = 'emailing/images'
444BUILD_DATABASE_PREFIX = 'nwc_'
445COTTERPIN_VALIDATOR_VAT = '/check/vat/'
446BUILD_SUPPLIED_DOCUMENTS_DIR_NAME = 'supplied_documents'
447GLOBAL_APPS = ['auth', 'contenttypes', 'sessions', 'messages', 'staticfiles', 'humanize', 'sites', 'humanize', 'formtools', 'admin', 'cms', 'djangocms_column', 'djangocms_inherit', 'djangocms_link', 'djangocms_text_ckeditor', 'axes', 'menus', 'password_policies', 'reversion', 'softdeletion', 'globals', 'tenants', 'aws', 'partners', 'signup', 'licenses', 'general', 'emailconfigs', 'noticetemplates', 'store']
448CELERY_QUEUES = 
449BADBROWSER_REQUIREMENTS = 
450SITE_DOMAIN = 'nwc.local:8080'
451HISTORY_DATABASE_DEFAULTS = {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'ATOMIC_REQUESTS': True, 'NAME': None, 'PORT': None, 'HOST': None, 'BUILD': True, 'PASSWORD': u'********************', 'OPTIONS': {'application_name': 'kido', 'connect_timeout': 5}, 'USER': None}
452HISTORY_CREATE_QUERY = 'CREATE TABLE {build}.history_log (\n    id bigint not null primary key identity encode delta,\n    type int2 NOT null encode lzo,\n    type_name char(100) null encode lzo,\n    patron_id int4 null encode lzo,\n    user_id int4 null encode lzo,\n    user_name char(70) null encode lzo,\n    actioned_by_user_id int4 null encode lzo,\n    actioned_by_user_name char(70) null encode lzo,\n    target_instance_id int4 null encode lzo,\n    target_instance_name char(70) null encode lzo,\n    created timestamp null encode lzo,\n    content_type int2 null encode lzo,\n    object_id int4 null encode lzo,\n    ip char(20) null encode lzo,\n    actioned_by_ip char(20) null encode lzo,\n    criteria_id int4 null encode lzo,\n    criteria_name char(100) null encode lzo,\n    criteria_expiry_date timestamp null encode lzo,\n    criteria_status char(32) null encode lzo,\n    criteria_state char(32) null encode lzo,\n    level_id int4 null encode lzo,\n    level_name char(100) null encode lzo,\n    sequence_id int4 null encode lzo,\n    sequence_name char(100) null encode lzo,\n    viewed bool encode runlength,\n    visible bool encode runlength,\n    notes varchar(65535) null encode lzo,\n    internal_notes varchar(65535) null encode lzo,\n    additional_data varchar(4096) null encode lzo,\n    foreign key(patron_id) references {build}.target_patrons(target_id)\n)\ndiststyle even\nsortkey(created, type, content_type);'
453PASSWORD_CHECK_ONLY_AT_LOGIN = u'********************'
454ES_INDEXES = {'default': 'nwc_index'}
455SOCIAL_AUTH_COMPLETE_URL_NAME = 'socialauth_complete'
456TARGET_LATESTCRITERIA_VIEW_QUERY = 'create or replace view target_latest_criteria as\nselect * from (\n    SELECT ROW_NUMBER() OVER (PARTITION BY user_id, criteria_id order by id DESC) AS r,\n    t.user_id, t.user_name, t.target_id, t.target_name, t.actioned_by_user_name,\n    (select tp.name from patron as tp where tp.id = t.patron_id) as patron_name,\n    t.level_name, t.criteria_id, t.criteria_name, t.criteria_status,\n    t.criteria_state, t.criteria_expiry_date, t.type_name, t.created_at\n    from history_log as t where\n    t.criteria_status is not null\n    order by t.user_id, t.criteria_id, t.id desc\n) x\nwhere x.r <= 1;'
457USE_TZ = True
458SHORT_DATETIME_FORMAT = 'm/d/Y P'
459COTTERPIN_VALIDATOR_EMAIL_PROVIDER = '/check/free-email/'
460DJANGO_APPS = ['auth', 'contenttypes', 'sessions', 'messages', 'staticfiles', 'humanize', 'sites', 'humanize', 'formtools', 'admin']
461AWS_AVAILABILITY_ZONE_DEFAULT = 'eu-west-1c'
462ALLOWED_TAGS = ['h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'a', 'abbr', 'acronym', 'b', 'blockquote', 'code', 'em', 'i', 'li', 'p', 'ol', 'strong', 'table', 'tbody', 'tfoot', 'thead', 'td', 'th', 'tr', 'ul', 'span', 'div', 'message-text', 'br']
463DATETIME_FORMAT_EUROPEAN = 'd/m/Y H:i:s'
464AWS_DB_IDENTIFIER_PATTERN = 'mc{counter}-dt'
465CC_API_KEY = u'********************'
466BUILD_DATABASE_DEFAULTS = {'ENGINE': 'transaction_hooks.backends.mysql', 'ATOMIC_REQUESTS': True, 'NAME': None, 'HOST': None, 'BUILD': True, 'PASSWORD': u'********************', 'PORT': None, 'USER': None}
467COTTERPIN_C2C_START_CALL_PATH = '/make-call/'
468AWS_GET_AVAILABLE_DB_INSTANCE = ''
469LANGUAGE_CODE = 'en-gb'
470ROOT_URLCONF = 'nwc.urls.root'
471LOGIN_URL = '/accounts/login/'
472GOOGLE_CHAT_SERVER = 'gmail.com'
473ALLOWED_ATTRIBUTES = {'a': ['href', 'rel', 'target'], 'table': ['align', 'border', 'cellpadding', 'cellspacing', 'height', 'width', 'style'], '*': ['class', 'title', 'style']}
474CKEDITOR_RESTRICT_BY_BUILD = True
475TEMPLATE_DIRS = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/templates'
476SESSION_CACHE_ALIAS = 'default'
477STATSD_PREFIX = 'nwc.local'
478COTTERPIN_VALIDATOR_PASSPORT = u'********************'
479SESSION_COOKIE_DOMAIN = None
480COTTERPIN_C2C_GET_CALL_PATH = '/get-call/'
481ROSETTA_EXCLUDED_APPLICATIONS = 'django.contrib.flatpages'
482CKEDITOR_UPLOAD_PREFIX = '/media/ckfiles/'
483COTTERPIN_WEBSCRAPE_PATH = '/web-scrape/'
484GA_CODE_SIGNUP_APP_PERSONAL = '\n'
485FILE_UPLOAD_PERMISSIONS = None
486COTTERPIN_VALIDATOR_VEHICLE_REGISTRATION = '/check/vehicle-registration/{country}/'
487PROTOCOL_HTTP = 'http'
488TASTYPIE_FULL_DEBUG = True
489TARGET_ALLDATA_VIEW_QUERY = 'create or replace view target_log_all as\n    SELECT target_log.target_id AS tid, target_log.type_name, target_log.group_name,\n           target_log.created_at, target_log_detail.field_name, target_log_detail.field_value\n    FROM target_log JOIN target_log_detail ON (target_log.id = target_log_detail.target_log_id);'
490APPEND_SLASH = True
491DATABASE_ROUTERS = ['nwc.builds.routers.BuildRouter']
492YEAR_MONTH_FORMAT = 'F Y'
493TARGET_ALLDATA_DELETE_QUERY = 'drop view if exists target_log_all;'
494COTTERPIN_HOST = 'http://localhost:8000'
495PAGEONE_SMS_URL = 'https://www.oventus.com/rest/v1/%(username)s/message?password=%(password)s'
496CMS_TEMPLATES = 
497MIDDLEWARE_CLASSES = 
498USE_I18N = True
499LANGUAGE_COOKIE_NAME = 'django_language'
500DELETE_INACTIVE_CLIENT_AFTER_DAYS = 30
501ALLOWED_INCLUDE_ROOTS = 
502COTTERPIN_VALIDATOR_TEMPERATURE = '/check/temperature/'
503AWS_REGION = 'eu-west-1'
504GOOGLE_OAUTH2_CLIENT_SECRET = u'********************'
505WSGI_APPLICATION = None
506CKEDITOR_SETTINGS = {'mergeFields': 'portal', 'extraPlugins': 'fields', 'toolbar': 'BasicWithTags', 'customConfig': '/static/ckeditorextra/ckeditor_config.js'}
507ICONS_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/common/static/common/images/icons'
508X_FRAME_OPTIONS = 'SAMEORIGIN'
509FORCE_SCRIPT_NAME = None
510USE_ETAGS = False
511SERVE_MEDIA = False
512TARGET_CURRENTRELATIONS_DELETE_QUERY = 'drop view if exists target_relations_latest;'
513PDF_CERT_HASH = 'c3df3aa8455b593374bb96b0b0a53be2af2fb39055bfc5d3'
514DATE_FORMAT_EUROPEAN = 'd/m/Y'
515PREPEND_WWW = False
516GA_CODE_SIGNUP_APP = '\n'
517SOCIAL_AUTH_URLOPEN_TIMEOUT = 30
518FACEBOOK_APP_ID = '301241923314274'
519GOOGLE_CHAT_PASSWD = u'********************'
520COTTERPIN_IDCHECK_PATH = '/document-verification/'
521DATE_INPUT_FORMATS_US = '%m/%d/%Y'
522CLIENT_EMAIL_BACKEND_MAX_ERRORS = 10
523AWS_VPC_DEFAULT = 'default'
524OMNIPRESENT_APPS = ['south']
525CACHE_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/shared/cache'
526CKEDITOR_UPLOAD_DIR_NAME = 'ckfiles'
527EMAIL_HOST_PASSWORD = u'********************'
528SENTRY_DSN = ''
529PASSWORD_RESET_TIMEOUT_DAYS = u'********************'
530COTTERPIN_VALIDATOR_ABN = '/check/abn/'
531ADMIN_MEDIA_PREFIX = '/static/grappelli/'
532AXES_LOCK_OUT_AT_FAILURE = True
533SESSION_ENGINE = 'django.contrib.sessions.backends.db'
534CELERY_EMAIL_TASK_CONFIG = {'queue': 'nwc_notices_email_queue', 'routing_key': 'nwc_notices_email'}
535PASSWORD_CHANGE_MIDDLEWARE_EXCLUDED_PATHS = u'********************'
536GOOGLE_CONSUMER_SECRET = u'********************'
537CLMS_SERVICE_PATH = '/Service/Nwc/'
538AWS_DB_HISTORY_CONFIG = {'default': {'Engine': 'postgres', 'DBParameterGroupName': 'history-db-parameters', 'CharacterSetName': None, 'AvailabilityZone': 'eu-west-1c', 'DBSecurityGroups': [], 'PubliclyAccessible': True, 'MultiAZ': False, 'StorageType': 'gp2', 'LicenseModel': 'postgresql-license', 'AutoMinorVersionUpgrade': True, 'PreferredBackupWindow': None, 'VpcSecurityGroups': [], 'Iops': None, 'PreferredMaintenanceWindow': None, 'AllocatedStorage': 5, 'EngineVersion': '9.4.1', 'DBInstanceClass': 'db.t2.micro', 'BackupRetentionPeriod': 7, 'DBSubnetGroupName': 'default', 'Port': 5432, 'OptionGroupName': 'default:postgres-9-4'}}
539ES_URLS = ['localhost:9200']
540MAIN_PAGE_URL_FOR_TARGET_ACCOUNT = '/portal/'
541PCA_RETRIEVE_URL = 'http://services.postcodeanywhere.co.uk/CapturePlus/Interactive/Retrieve/v2.00/xmla.ws?'
542COTTERPIN_VALIDATOR_REGEXP = '/check/custom-validator/'
543AWS_DB_ROTATOR = False
544DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
545ADMINS = ('Iza', 'iza.stolarska@nowwecomply.com')
546TARGET_DATA_CREATE_QUERY = 'CREATE TABLE {build}.target_data (\n    id bigint not null primary key identity encode delta,\n    target_id int4 not null encode lzo,\n    type_name varchar(255) null encode lzo,\n    group_name varchar(255) null encode lzo,\n    valid_at timestamp not null\n)\ndiststyle even\nsortkey(target_id);'
547DATETIME_FORMAT = 'd/m/Y H:i:s'
548AWS_DNS_SERVER = '172.31.0.2'
549COTTERPIN_VALIDATOR_ZIP_CODE = '/check/zip-code/'
550LOGOUT_URL = '/accounts/logout/'
551VIEW_PERMISSIONS_URLCONFS = 
552LOCAL_HISTORY = False
553AWS_DB_PER_HOST = 10
554AWS_DB_HISTORY_IDENTIFIER_PATTERN = 'history-{clientID}-prod'
555FACEBOOK_PROFILE_ID = 'micheal.adam.583'
556COTTERPIN_VALIDATOR_VIN = '/check/vin/'
557SIGNUP_DD_KEY = u'********************'
558DEFAULT_TABLESPACE = ''
559CELERY_ACKS_LATE = True
560PCA_FIND_URL = 'http://services.postcodeanywhere.co.uk/CapturePlus/Interactive/Find/v2.00/xmla.ws?'
561SESSION_COOKIE_AGE = 1209600
562SETTINGS_MODULE = 'nwc.settings'
563LANGUAGES = 
564CELERY_TASK_RESULT_EXPIRES = 120
565ABSOLUTE_URL_OVERRIDES = {}
566CELERYBEAT_SCHEDULE = {'unsuspend_tilc': {'task': 'nwc.build_base.tasks.unsuspend_tilc_all', 'schedule': <crontab: */30 * * * * (m/h/d/dM/MY)>}, 'monitor_fifo': {'task': 'nwc.builds.taskqueue.tasks.monitor_fifo', 'schedule': <crontab: */30 * * * * (m/h/d/dM/MY)>}, 'clean_temporary_uploaded_file': {'task': 'nwc.builds.filestore.tasks.clean_temporary_uploaded_file_all', 'schedule': <crontab: 10 */12 * * * (m/h/d/dM/MY)>}, 'send_reminders': {'task': 'nwc.reminders.tasks.send_reminders_all', 'schedule': <crontab: */30 * * * * (m/h/d/dM/MY)>}, 'clean_loginurl': {'task': 'nwc.build_base.tasks.clean_loginurl_all', 'schedule': <crontab: 15 */12 * * * (m/h/d/dM/MY)>}, 'collect_import_retries': {'task': 'nwc.builds.targetimports.tasks.retry_import_all', 'schedule': <crontab: */5 * * * * (m/h/d/dM/MY)>}, 'collect_retries': {'task': 'nwc.builds.targetimports.backends.targetimportmail.tasks.collect_retries_all', 'schedule': <crontab: */5 * * * * (m/h/d/dM/MY)>}, 'ensure_history_partition': {'task': 'nwc.histories.tasks.ensure_history_partition_all', 'schedule': <crontab: 00 3 * * * (m/h/d/dM/MY)>}, 'deactivate_client': {'task': 'nwc.globals.tenants.tasks.deactivate_client', 'schedule': <crontab: 30 */12 * * * (m/h/d/dM/MY)>}, 'delete_inactive_client': {'task': 'nwc.globals.tenants.tasks.delete_inactive_client', 'schedule': <crontab: 50 */12 * * * (m/h/d/dM/MY)>}, 'criteria_urgency_update_all': {'task': 'nwc.build_base.tasks.criteria_urgency_update_all', 'schedule': <crontab: 30 */2 * * * (m/h/d/dM/MY)>}, 'send_grouped_message': {'task': 'nwc.reminders.tasks.send_grouped_messages_all', 'schedule': <crontab: */10 * * * * (m/h/d/dM/MY)>}, 'notify_escalations': {'task': 'nwc.build_base.tasks.notify_escalations_all', 'schedule': <crontab: */40 */4 * * * (m/h/d/dM/MY)>}, 'notify_outstanding_criteria': {'task': 'nwc.build_base.tasks.notify_outstanding_criteria_all', 'schedule': <crontab: */20 */1 * * * (m/h/d/dM/MY)>}, 'unsuspend_reminders': {'task': 'nwc.reminders.tasks.unsuspend_reminders_all', 'schedule': <crontab: */30 * * * * (m/h/d/dM/MY)>}, 'send_retry': {'task': 'nwc.reminders.tasks.send_retry_all', 'schedule': <crontab: */10 * * * * (m/h/d/dM/MY)>}, 'criteria_revalidate': {'task': 'nwc.build_base.tasks.criteria_revalidate_all', 'schedule': <crontab: */20 * * * * (m/h/d/dM/MY)>}, 'trigger_schedule_run_all': {'task': 'nwc.builds.sequencer.tasks.trigger_schedule_run_all', 'schedule': <crontab: */5 * * * * (m/h/d/dM/MY)>}, 'trigger_schedule_clean_all': {'task': 'nwc.builds.sequencer.tasks.trigger_schedule_clean_all', 'schedule': <crontab: 15 3 * * * (m/h/d/dM/MY)>}, 'count_month_limits': {'task': 'nwc.reminders.tasks.monitor_backend_limit_all', 'schedule': <crontab: 0 */1 * * * (m/h/d/dM/MY)>}, 'send_event_report': {'task': 'nwc.housekeeping.tasks.send_event_report', 'schedule': <crontab: 0 0 * 1 * (m/h/d/dM/MY)>}, 'clean_notices': {'task': 'nwc.reminders.tasks.clean_notices_all', 'schedule': <crontab: 15 */12 * * * (m/h/d/dM/MY)>}, 'criteria_expiry': {'task': 'nwc.build_base.tasks.criteria_expiry_all', 'schedule': <crontab: */20 * * * * (m/h/d/dM/MY)>}, 'send_notices': {'task': 'nwc.reminders.tasks.send_notices_all', 'schedule': <crontab: */2 * * * * (m/h/d/dM/MY)>}, 'suspend_reminders': {'task': 'nwc.reminders.tasks.suspend_reminders_all', 'schedule': <crontab: */30 * * * * (m/h/d/dM/MY)>}, 'collect_mailbox': {'task': 'nwc.builds.targetimports.backends.targetimportmail.tasks.collect_mailbox_all', 'schedule': <crontab: */5 * * * * (m/h/d/dM/MY)>}, 'clean_deletion_versioning': {'task': 'nwc.versioning.tasks.clean_deletion_versioning_all', 'schedule': <crontab: 45 1 * * * (m/h/d/dM/MY)>}, 'suspend_tilc': {'task': 'nwc.build_base.tasks.suspend_tilc_all', 'schedule': <crontab: */30 * * * * (m/h/d/dM/MY)>}}
567CACHE_MIDDLEWARE_SECONDS = 600
568KPI_CREATE_QUERY = 'CREATE TABLE {build}.kpi (\n    id bigint not null primary key identity encode delta,\n    target_id int4 not null encode lzo,\n    patron_id int4 not null encode lzo,\n    assigned int4 not null default 0 encode lzo,\n    outstanding int4 not null default 0 encode lzo,\n    completed int4 not null default 0 encode lzo,\n    to_approve int4 not null default 0 encode lzo,\n    approved int4 not null default 0 encode lzo,\n    rejected int4 not null default 0 encode lzo,\n    expired_for_target int4 not null default 0 encode lzo,\n    expired_for_su int4 not null default 0 encode lzo,\n    created_at timestamp not null\n)\ndiststyle even\nsortkey(patron_id, target_id, created_at);'
569AWS_DYNAMODB_IS_SECURE = False
570CSRF_COOKIE_HTTPONLY = True
571GIT_VERSION_CMD = 'git describe --always'
572EMAIL_HOST_USER = ''
573DATE_FORMAT_US = 'm/d/Y'
574GRAPPELLI_INDEX_DASHBOARD = 'nwc.dashboard.CustomIndexDashboard'
575TARGET_CURRENTDATA_DELETE_QUERY = 'drop view if exists target_log_latest;'
576CSRF_COOKIE_SECURE = False
577CELERY_TRACK_STARTED = True
578CELERY_DEFAULT_EXCHANGE_TYPE = 'direct'
579CKEDITOR_UPLOAD_PATH = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/shared/public_media/media/ckfiles'
580MULTILINGUAL_LANGUAGE_CODE = 'en-gb'
581BUILD_RT_SELECT_EXAMPLE_ATTACHMENTS_DIR_NAME = 'response_types/select/example_files'
582RESTRICTED_DOMAINS = 
583GOOGLE_OAUTH2_CLIENT_ID = '546140904050.apps.googleusercontent.com'
584ADMIN_FOR = 
585AWS_DNS_PUBLIC_ZONE = 'nowwecomply.com'
586BUILD_TMP_DIR_NAME = 'temporary_files'
587PUBLIC_MEDIA_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/shared/public_media'
588FILE_UPLOAD_HANDLERS = 
589DEFAULT_CONTENT_TYPE = 'text/html'
590DEACTIVATE_NOT_CONFIRMED_CLIENT_AFTER_DAYS = 30
591COTTERPIN_VALIDATOR_SOCIAL_SECURITY = '/check/social-security/{country}-{kind}/'
592STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
593FACEBOOK_CHAT_PORT = '5222'
594HISTORY_PIVOTCODE_FUNCTION = "create or replace function pivotcode (target_type varchar, target_group varchar) returns varchar language plpgsql as $$\ndeclare\n    return_sql varchar;\n    crosstab_sql varchar;\n    columnlist varchar;\n\nbegin\n    -- 1. retrieve list of column names.\n    return_sql = 'select string_agg(pivotnames(''field_'' || field_name), '' text, '')\n                  from (select distinct lower(field_name) as field_name from target_log_latest where type_name = ''' || target_type || ''' and group_name = ''' || target_group || ''' order by lower(field_name)) as q';\n    execute return_sql into columnlist;\n\n    -- 2. set up the crosstab query\n    crosstab_sql = 'select * from crosstab (\n            ''select tid, lower(field_name) as field_name, array_to_string(array_agg(field_value), '''', '''')\n            from target_log_latest\n            where type_name = ''''' || target_type || ''''' and group_name = ''''' || target_group || '''''\n            group by tid, lower(field_name)\n            order by tid, lower(field_name)'',\n            ''select distinct lower(field_name) as field_name from target_log_latest where type_name = ''''' || target_type || ''''' and group_name = ''''' || target_group || ''''' order by lower(field_name)''\n    )\n    as newtable (\n        tid integer, ' || columnlist || ' text\n    );';\n\n    return crosstab_sql;\nend\n$$"
595PDF_CERT_EXTRARANGE = 10740
596TASK_LOCK_TABLE = 'globals_task_lock'
597FACEBOOK_EXTENDED_PERMISSIONS = ['user_photos']
598STATSD_PORT = 8125
599LOGGING_CONFIG = 'django.utils.log.dictConfig'
600TEMPLATE_LOADERS = 
601ANALYTICS_API = u'********************'
602PAGEONE_DELIVERY_URL = 'https://www.oventus.com/rest/v1/%(username)s/message/reports?password=%(password)s'
603GA_CODE_SIGNUP_APP_TRIAL = '\n'
604MAIN_PAGE_URL_FOR_SYSTEM_ACCOUNT = '/system/'
605CELERY_DEFAULT_ROUTING_KEY = u'********************'
606SESSION_COOKIE_SECURE = False
607AWS_SUBNET_GROUP_DEFAULT = 'default'
608AWS_ACCESS_KEY_ID = u'********************'
609INSTALLED_APPS = ['djangocms_admin_style', 'djangocms_text_ckeditor', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.humanize', 'django.contrib.sites', 'django.contrib.humanize', 'django.contrib.formtools', 'grappelli.dashboard', 'grappelli', 'filebrowser', 'floppyforms', 'django.contrib.admin', 'axes', 'cms', 'mptt', 'menus', 'password_policies', 'south', 'sekizai', 'djangocms_column', 'djangocms_inherit', 'djangocms_link', 'raven.contrib.django.raven_compat', 'reversion', 'nwc.common', 'nwc.histories', 'nwc.globals', 'nwc.globals.tenants', 'nwc.globals.aws', 'nwc.builds', 'nwc.builds.api', 'nwc.build_base', 'nwc.builds.cmspages', 'nwc.builds.criteria', 'nwc.builds.extensions', 'nwc.builds.extensions.database_connector', 'nwc.builds.extensions.post_code', 'nwc.builds.extensions.s3_upload', 'nwc.builds.extensions.rds_storage', 'nwc.builds.extensions.sms', 'nwc.builds.extensions.sms.pageone', 'nwc.builds.extensions.cc_pdfs', 'nwc.builds.extensions.truthtables', 'nwc.builds.levels', 'nwc.builds.logicons', 'nwc.builds.patrons', 'nwc.builds.properties', 'nwc.builds.responsetypes', 'nwc.builds.responsetypes.plugins.internal.rt_activity', 'nwc.builds.responsetypes.plugins.internal.rt_text', 'nwc.builds.responsetypes.plugins.internal.rt_select', 'nwc.builds.responsetypes.plugins.internal.rt_datepicker', 'nwc.builds.responsetypes.plugins.internal.rt_document', 'nwc.builds.responsetypes.plugins.internal.rt_fieldupdater', 'nwc.builds.responsetypes.plugins.internal.rt_webcheck', 'nwc.builds.responsetypes.plugins.internal.rt_webscrape', 'nwc.builds.responsetypes.plugins.internal.rt_message', 'nwc.builds.responsetypes.plugins.idchecker.rt_idcheck', 'nwc.builds.responsetypes.plugins.idchecker.rt_iddocument', 'nwc.builds.responsetypes.plugins.gbgroup.rt_basic_identity', 'nwc.builds.responsetypes.plugins.synety.rt_c2c', 'nwc.builds.responsetypes.validators', 'nwc.builds.roles', 'nwc.builds.variables', 'nwc.response_type', 'nwc.swfupload', 'nwc.accounts', 'nwc.pdf_generator', 'ckeditor', 'django_extensions', 'django_jenkins', 'nwc.customfields', 'nwc.globals.partners', 'nwc.builds.sequencer', 'nwc.globals.signup', 'nwc.globals.licenses', 'nwc.globals.general', 'nwc.globals.emailconfigs', 'nwc.globals.noticetemplates', 'nwc.reminders', 'nwc.builds.communication', 'nwc.builds.revalidations', 'nwc.builds.confs', 'nwc.builds.targetimports', 'nwc.builds.targetimports.backends.targetimportmail', 'nwc.builds.ckeditorextra', 'nwc.builds.filestore', 'nwc.builds.targets', 'nwc.builds.dashboard_v2', 'nwc.builds.design', 'nwc.builds.taskqueue', 'nwc.builds.categories', 'nwc.housekeeping', 'nwc.viewpermissions', 'nwc.softdeletion', 'nwc.versioning', 'djcelery', 'djkombu', 'djcelery_email', 'sorl.thumbnail', 'rosetta-grappelli', 'rosetta', 'pagination', 'httplib2', 'openid', 'oauth2', 'social_auth', 'nwc.accountssocial', 'qrcode', 'endless_pagination', 'loginurl', 'nwc.globals.store', 'tagging', 'django_badbrowser', 'django_js_reverse', 'guardian', 'nwc.builds.extensions.analytics', 'nwc.patcher', 'debug_toolbar']
610COMMENTS_ALLOW_PROFANITIES = False
611STATIC_ROOT = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/static'
612KPI_DATES_CREATE_QUERY = 'CREATE TABLE {build}.kpi_dates (\n    id bigint not null primary key identity encode delta,\n    kpi_id bigint not null encode lzo,\n    criteria_id int4 not null encode lzo,\n    assigned_at timestamp null encode lzo,\n    due_date timestamp null encode lzo,\n    completed_at timestamp null encode lzo,\n    foreign key(kpi_id) references {build}.kpi(id)\n)\ndiststyle even\nsortkey(kpi_id);'
613BUILD_USER_PROFILE_PHOTO = 'user_profile/photo'
614SESSION_COOKIE_HTTPONLY = True
615AXES_LOCKOUT_TEMPLATE = 'client/accounts/account_locked.html'
616DATABASE_CONNECTORS_DRIVERS = {'d_pgsql_db_connector': {'connector': 'PGSqlConnector', 'driver': 'PGSqlDatabaseDriver', 'kwargs': {}}, 'd_oracle_db_connector': {'connector': 'OracleConnector', 'driver': 'OracleDatabaseDriver', 'kwargs': {}}, 'd_mysql_db_connector': {'connector': 'MySQLConnector', 'driver': 'MySQLDatabaseDriver', 'kwargs': {}}, 'd_teradata_db_connector': {'connector': 'TerradataConnector', 'driver': 'TerradataDatabaseDriver', 'kwargs': {}}, 'd_informix_db_connector': {'connector': 'InformixConnector', 'driver': 'InformixDatabaseDriver', 'kwargs': {}}, 'd_db2_db_connector': {'connector': 'DB2Connector', 'driver': 'DB2DatabaseDriver', 'kwargs': {}}, 'd_sqlserver_db_connector': {'connector': 'SQLServerConnector', 'driver': 'SQLServerDatabaseDriver', 'kwargs': {}}}
617FACEBOOK_CHAT_SERVER = 'chat.facebook.com'
618DATE_INPUT_FORMATS_EUROPEAN = '%d/%m/%Y'
619HISTORY_PIVOTVIEW_FUNCTION = "create or replace function pivotview (target_type varchar, target_group varchar) returns integer language plpgsql as $$\ndeclare\n    crosstab_sql varchar;\n    pivot_view varchar;\n    view_name varchar;\n    ret integer;\n\nbegin\n    -- 1. retrieve pivot view code.\n    execute 'select pivotcode(''' || target_type || ''', ''' || target_group || ''');' into crosstab_sql;\n\n    -- 2. geenrate view name\n    view_name = 'target_' || lower(pivotnames(target_type)) || '_' || lower(pivotnames(target_group));\n\n    -- 3. delete old view version\n    execute 'drop view if exists ' || view_name || ';';\n\n    -- 4. final adjustments and execute\n    pivot_view = 'create or replace view ' || view_name || ' as ' || crosstab_sql;\n    begin\n        execute pivot_view;\n        return 1;\n    exception when others then\n        return 0;\n    end;\nend;\n$$"
620BUILD_RT_IDCHECK_REPORTS_DIR_NAME = 'response_types/idcheck/reports'
621DATE_INPUT_FORMATS = 
622ROSETTA_UWSGI_AUTO_RELOAD = True
623CSRF_COOKIE_NAME = 'csrftoken'
624COTTERPIN_VALIDATOR_PHONE = '/check/phone/'
625AUTH_PROFILE_MODULE = 'accounts.UserProfile'
626SKYPE_NAME = 'nowwecomply'
627SESSION_SAVE_EVERY_REQUEST = False
628NUMBER_GROUPING = 0
629TWITTER_CONSUMER_SECRET = u'********************'
630LOGS_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/logs'
631LOCALE_PATHS = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/locale'
632SOCIAL_AUTH_PIPELINE = 
633HISTORY_DB_PREFIX = 'history:'
634BUILD_DOCUMENT_STORE = 'filestore'
635LOGGING = {'loggers': {'xhtml2pdf': {'handlers': ['console', 'sentry'], 'propagate': True, 'level': 'WARNING'}, 'nwc.globals.signup': {'handlers': ['file', 'console'], 'propagate': False, 'level': 'DEBUG'}, 'elasticsearch.trace': {'handlers': ['console'], 'propagate': True, 'level': 'WARNING'}, 'django': {'handlers': ['file', 'null'], 'propagate': True, 'level': 'WARNING'}, 'menus': {'handlers': ['file', 'console'], 'propagate': True, 'level': 'WARNING'}, 'elasticsearch': {'handlers': ['console'], 'propagate': True, 'level': 'WARNING'}, 'nwc_spec': {'handlers': ['file_spec'], 'propagate': True, 'level': 'DEBUG'}, 'nwc': {'handlers': ['file', 'console', 'sentry'], 'propagate': True, 'level': 'DEBUG'}, 'django.db': {'handlers': ['console', 'sentry'], 'propagate': True, 'level': 'WARNING'}, 'nwc.requestprovider': {'handlers': ['console'], 'propagate': True, 'level': 'WARNING'}, 'django.request': {'handlers': ['file', 'mail_admins', 'sentry'], 'propagate': True, 'level': 'ERROR'}}, 'version': 1, 'formatters': {'simple': {'format': '%(levelname)s %(message)s'}, 'verbose': {'format': '%(levelname)s %(asctime)s %(module)s %(process)d %(thread)d %(message)s'}}, 'disable_existing_loggers': True, 'handlers': {'console': {'formatter': 'simple', 'class': 'logging.StreamHandler', 'level': 'DEBUG'}, 'mail_admins': {'class': 'django.utils.log.AdminEmailHandler', 'level': 'ERROR'}, 'sentry': {'class': 'raven.contrib.django.raven_compat.handlers.SentryHandler', 'level': 'ERROR'}, 'file': {'backupCount': 10, 'level': 'DEBUG', 'filename': '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/logs/nwc.log', 'formatter': 'verbose', 'class': 'logging.handlers.RotatingFileHandler', 'maxBytes': 15728640}, 'null': {'class': 'django.utils.log.NullHandler', 'level': 'DEBUG'}, 'file_spec': {'backupCount': 10, 'level': 'DEBUG', 'filename': '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/logs/nwc_spec.log', 'formatter': 'verbose', 'class': 'logging.handlers.RotatingFileHandler', 'maxBytes': 15728640}}}
636TARGET_ALLRELATIONS_DELETE_QUERY = 'drop view if exists target_relations_all;'
637CKEDITOR_RESTRICT_BY_USER = False
638STATSD_PATCHES = ['django_statsd.patches.db']
639AXES_COOLOFF_TIME = 0.08
640EMAIL_USE_TLS = False
641EMAIL_HOST = 'localhost'
642BUILD_STUFF_STORE = 'filestore_stuff'
643NFS_SHARED_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/shared'
644JENKINS_TASKS = 
645MEDIA_URL = '/media/'
646CKEDITOR_CONFIGS = {'basic_with_tags': {'mergeFields': 'portal', 'extraPlugins': 'fields,responsevalue', 'customConfig': '/static/ckeditorextra/ckeditor_config.js', 'width': 650, 'resize_enabled': False, 'skin': 'kama', 'height': 300, 'toolbar': 'BasicWithTags'}, 'direct_message': {'height': 140, 'width': 685, 'resize_enabled': False, 'skin': 'kama', 'customConfig': '/static/ckeditorextra/ckeditor_config.js', 'toolbar': 'Basic'}, 'admin': {'extraPlugins': 'fields,responsevalue', 'height': 300, 'width': 650, 'resize_enabled': False, 'skin': 'kama', 'customConfig': '/static/ckeditorextra/ckeditor_config.js', 'toolbar': 'Admin'}, 'basic_with_char_limit': {'mergeFields': 'portal', 'extraPlugins': 'fields,responsevalue,maxlength', 'customConfig': '/static/ckeditorextra/ckeditor_config.js', 'width': 650, 'resize_enabled': False, 'skin': 'kama', 'height': 300, 'toolbar': 'BasicWithTags'}, 'message_template': {'mergeFields': 'message', 'extraPlugins': 'fields,responsevalue', 'customConfig': '/static/ckeditorextra/ckeditor_config.js', 'width': 650, 'resize_enabled': False, 'skin': 'kama', 'height': 300, 'toolbar': 'FullWithTags'}, 'basic': {'extraPlugins': 'fields,responsevalue', 'height': 300, 'width': 650, 'resize_enabled': False, 'skin': 'kama', 'customConfig': '/static/ckeditorextra/ckeditor_config.js', 'toolbar': 'Basic'}, 'document_template': {'mergeFields': 'document', 'extraPlugins': 'fields,responsevalue', 'customConfig': '/static/ckeditorextra/ckeditor_config.js', 'width': 650, 'resize_enabled': False, 'skin': 'kama', 'height': 390, 'toolbar': 'FullWithTags'}}
647CLMS_REST_SERVICE = 
648CLMS_CERT = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../cert/nowwecomply.nwc.clms.fcpl.com.crt'
649TARGET_CURRENTRELATIONS_VIEW_QUERY = 'create or replace view target_relations_latest as\n    select target_log.target_id as tid, target_log_relations.related_target_id, target_log_relations.relation_type,\n           target_log.created_at\n    from target_log join target_log_relations on target_log.id = target_log_relations.target_log_id\n    where target_log.created_at = (select max(tl.created_at) from target_log as tl where tl.target_id = target_log.target_id);'
650TEST_RUNNER = 'django.test.runner.DiscoverRunner'
651TIME_ZONE = 'Europe/London'
652COTTERPIN_C2C_FINISH_CALL_PATH = '/close-call/{pk}/'
653EMAIL_BACKEND = 'djcelery_email.backends.CeleryEmailBackend'
654RAVEN_CONFIG = {u'public_key': None, u'string_max_length': None, u'key': '2c2a4fe3ccd498524e52fa772a869d51', u'exclude_paths': None, u'processors': None, u'auto_log_stacks': None, u'servers': None, u'project': None, u'timeout': None, u'include_paths': set(['django.contrib.formtools', 'nwc.patcher', 'nwc.builds.responsetypes', 'nwc.builds.extensions.database_connector', 'grappelli.dashboard', 'nwc.builds.logicons', 'nwc.builds.sequencer', 'nwc.builds.cmspages', 'nwc.builds.ckeditorextra', 'nwc.builds.responsetypes.plugins.internal.rt_select', 'django_extensions', 'nwc.builds.responsetypes.plugins.internal.rt_fieldupdater', 'qrcode', 'floppyforms', 'nwc.versioning', 'raven.contrib.django.raven_compat', 'rosetta-grappelli', 'djangocms_inherit', 'rosetta', 'django.contrib.sites', 'nwc.builds.responsetypes.plugins.internal.rt_webscrape', 'nwc.accountssocial', 'django_badbrowser', 'djkombu', 'nwc.builds.extensions.cc_pdfs', 'nwc.builds.levels', 'nwc.softdeletion', 'nwc.builds.responsetypes.plugins.gbgroup.rt_basic_identity', 'nwc.builds.extensions.sms.pageone', 'nwc.builds.extensions.sms', 'nwc.builds.extensions.analytics', 'nwc.globals.licenses', 'nwc.builds.communication', 'mptt', 'nwc.response_type', 'grappelli', 'djangocms_admin_style', 'nwc.builds.variables', 'menus', 'django.contrib.admin', 'httplib2', 'nwc.builds.taskqueue', 'nwc.builds.responsetypes.plugins.internal.rt_message', 'tagging', 'pagination', 'oauth2', 'nwc.globals.signup', 'nwc.builds', 'nwc.swfupload', 'nwc.builds.extensions.s3_upload', 'debug_toolbar', 'nwc.globals.store', 'nwc.builds.responsetypes.plugins.idchecker.rt_idcheck', 'nwc.builds.revalidations', 'nwc.builds.properties', 'nwc.build_base', 'nwc.globals.partners', 'django.contrib.auth', 'nwc.builds.responsetypes.plugins.synety.rt_c2c', 'cms', 'djangocms_text_ckeditor', 'django.contrib.humanize', 'nwc.builds.responsetypes.plugins.idchecker.rt_iddocument', 'nwc.globals.emailconfigs', 'nwc.reminders', 'djcelery', 'nwc.histories', 'nwc.builds.targetimports.backends.targetimportmail', 'sekizai', 'loginurl', 'nwc.builds.targets', 'nwc.globals.tenants', 'nwc.globals.noticetemplates', 'djcelery_email', 'nwc.builds.criteria', 'nwc.builds.extensions', 'axes', 'nwc.builds.api', 'password_policies', 'nwc.pdf_generator', 'nwc.globals.general', 'django.contrib.sessions', 'django_js_reverse', 'nwc.builds.confs', 'djangocms_column', 'nwc.builds.responsetypes.plugins.internal.rt_activity', 'openid', 'nwc.builds.categories', 'nwc.accounts', 'nwc.builds.responsetypes.plugins.internal.rt_document', 'reversion', 'nwc.builds.responsetypes.validators', 'sorl.thumbnail', 'nwc.housekeeping', 'nwc.builds.targetimports', 'nwc.builds.design', 'guardian', 'django.contrib.staticfiles', 'nwc.builds.responsetypes.plugins.internal.rt_text', 'nwc.builds.filestore', 'filebrowser', 'nwc.builds.patrons', 'nwc.globals', 'ckeditor', 'django_jenkins', 'django.contrib.contenttypes', 'nwc.globals.aws', 'djangocms_link', 'nwc.builds.responsetypes.plugins.internal.rt_webcheck', 'nwc.common', 'nwc.builds.extensions.post_code', 'endless_pagination', 'django.contrib.messages', 'nwc.builds.extensions.truthtables', 'nwc.builds.responsetypes.plugins.internal.rt_datepicker', 'social_auth', 'nwc.viewpermissions', 'nwc.builds.roles', 'nwc.builds.extensions.rds_storage', 'nwc.customfields', 'nwc.builds.dashboard_v2', 'south']), u'context': None, u'site': None, u'secret_key': None, 'dsn': '', u'list_max_length': None, u'name': None}
655TEMPLATE_CONTEXT_PROCESSORS = 
656AXES_LOGIN_FAILURE_LIMIT = 5
657STATSD_HOST = 'localhost'
658HISTORY_DATABASE_NAME = 'nwc_history'
659TRANSACTIONS_MANAGED = False
660LANGUAGES_BIDI = 
661HISTORY_PIVOTCRITERIACODE_FUNCTION = "create or replace function pivotcrieriacode() returns varchar language plpgsql as $$\n\ndeclare\n    return_sql varchar;\n    crosstab_sql varchar;\n    columnlist varchar;\n\nbegin\n    -- 1. retrieve list of column names.\n    return_sql = 'select string_agg(pivotnames(''criteria_'' || field_name), '' text, '')\n                  from (select distinct lower(trim(criteria_name)) as field_name from target_latest_criteria order by lower(trim(criteria_name))) as q';\n    execute return_sql into columnlist;\n\n    -- 2. set up the crosstab query\n    crosstab_sql = 'select * from crosstab (\n            ''select user_id as uid, trim(criteria_name) as field_name, array_to_string(array_agg(criteria_state), '''', '''') as field_value\n            from target_latest_criteria\n            group by uid,field_name\n            order by uid,field_name'',\n            ''select distinct trim(criteria_name) as field_name from target_latest_criteria order by trim(criteria_name)''\n    )\n    as newtable (\n        tid integer, ' || columnlist || ' text\n    );';\n\n    return crosstab_sql;\nend\n$$\n"
662WORK_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work'
663CELERY_RESULT_BACKEND = 'database'
664DATETIME_INPUT_FORMATS_EUROPEAN = 
665AWS_DYNAMODB_PORT = 8001
666BUILD_APPS = ['auth', 'contenttypes', 'sessions', 'messages', 'staticfiles', 'humanize', 'sites', 'humanize', 'formtools', 'admin', 'cms', 'djangocms_column', 'djangocms_inherit', 'djangocms_link', 'djangocms_text_ckeditor', 'axes', 'menus', 'password_policies', 'reversion', 'guardian', 'softdeletion', 'builds', 'api', 'cmspages', 'criteria', 'extensions', 'database_connector', 'post_code', 's3_upload', 'rds_storage', 'sms', 'pageone', 'cc_pdfs', 'truthtables', 'levels', 'logicons', 'patrons', 'properties', 'responsetypes', 'rt_activity', 'rt_text', 'rt_select', 'rt_datepicker', 'rt_document', 'rt_fieldupdater', 'rt_webcheck', 'rt_webscrape', 'rt_message', 'rt_idcheck', 'rt_iddocument', 'rt_basic_identity', 'rt_c2c', 'validators', 'roles', 'variables', 'sequencer', 'communication', 'revalidations', 'confs', 'targetimports', 'targetimportmail', 'ckeditorextra', 'filestore', 'targets', 'dashboard_v2', 'design', 'taskqueue', 'categories', 'analytics', 'accounts', 'accountssocial', 'build_base', 'histories', 'housekeeping', 'reminders', 'response_type', 'swfupload', 'viewpermissions', 'analytics', 'loginurl', 'social_auth']
667COTTERPIN_VALIDATOR_IP = '/check/ip/'
668PROFANITIES_LIST = u'********************'
669CELERY_CREATE_MISSING_QUEUES = True
670REMINDERS_SMS_USER = 'nowwecomply'
671CELERY_DEFAULT_QUEUE = 'nwc_default_queue'
672APP_DATABASE_PREFIX_MAP = {'histories': 'history:'}
673BUILD_DATABASE_USER_PREFIX = 'nwc_client_'
674DEFAULT_CHARSET = 'utf-8'
675ALLOWED_HOSTS = ['.nwc.local']
676EMAIL_SUBJECT_PREFIX = '[NWC]'
677SEND_BROKEN_LINK_EMAILS = False
678COTTERPIN_ACCOUNT_POSTCODE_PATH = '/pca/create/account/'
679STATICFILES_FINDERS = 
680SOCIAL_AUTH_DISCONNECT_REDIRECT_URL = '/social/disconnected/'
681STATIC_URL = '/static/'
682TIME_INPUT_FORMATS = 
683DATABASES = <nwc.builds.databases.BuildDBConfigurator object at 0x1dcacd0>
684PCA_ADD_CHILD_ACCOUNT_URL = 'http://services.postcodeanywhere.co.uk/Management/Accounts/Add/v2.10/xmla.ws?'
685TWITTER_NAME = 'nowwecomply'
686CC_NWC_LOGO = '/common/static/common/images/footer_logo.png'
687HISTORY_PIVOTCRITERIAVIEW_FUNCTION = "create or replace function pivotcriteriaview () returns integer language plpgsql as $$\ndeclare\n    crosstab_sql varchar;\n    pivot_view varchar;\n    view_name varchar;\n    ret integer;\n\nbegin\n    -- 1. retrieve pivot view code.\n    execute 'select pivotcrieriacode();' into crosstab_sql;\n\n    -- 2. geenrate view name\n    view_name = 'target_criteria_answers';\n\n    -- 3. delete old view version\n    execute 'drop view if exists ' || view_name || ';';\n\n    -- 4. final adjustments and execute\n    pivot_view = 'create or replace view ' || view_name || ' as ' || crosstab_sql;\n    begin\n        execute pivot_view;\n        return 1;\n    exception when others then\n        return 0;\n    end;\nend;\n$$"
688AUTH_USER_MODEL = 'auth.User'
689THOUSAND_SEPARATOR = ','
690SECRET_KEY = u'********************'
691COTTERPIN_VALIDATOR_IBAN = '/check/iban/'
692FILE_UPLOAD_TEMP_DIR = None
693BUILD_RT_WEBCHECK_SCREENS_DIR_NAME = 'response_types/webcheck/screens'
694COTTERPIN_VALIDATOR_CREDIT_CARD = '/check/credit-card/'
695BUILD_IMPORTED_FILE_DIR_NAME = 'imported'
696COTTERPIN_VALIDATOR_PERCENTAGE = '/check/percentage/'
697AWS_DNS_ZONE = 'nwc.int'
698AUTHENTICATION_BACKENDS = ['nwc.accounts.backends.ModelBackend', 'loginurl.backends.LoginUrlBackend', 'guardian.backends.ObjectPermissionBackend', 'social_auth.backends.facebook.FacebookBackend', 'social_auth.backends.twitter.TwitterBackend', 'social_auth.backends.google.GoogleOAuthBackend', 'social_auth.backends.yahoo.YahooBackend', 'social_auth.backends.OpenIDBackend']
699SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
700DATETIME_FORMAT_US = 'm/d/Y H:i:s'
701SOCIAL_AUTH_FIELDS_STORED_IN_SESSION = ['next', 'to_use']
702TWITTER_CONSUMER_KEY = u'********************'
703HISTORY_PIVOTNAMES_FUNCTION = "create or replace function pivotnames (field_name varchar) returns varchar language plpgsql as $$\ndeclare\n    name varchar;\n\nbegin\n    select regexp_replace(\n               regexp_replace(\n                   regexp_replace(trim(field_name), E'(\\\\s|-)', '_', 'g'), -- trim leadin and trailing spaces and convert space and - to _\n                   E'(\\\\''|\\\\(|\\\\)|/|\\\\\\\\|\\\\?|&|\\\\*|\\\\.|,|`|~|<|>|;|:|[|]|{|}|#)', '', 'g' -- trim special characters like ', \\, /, (, ), ?\n               ),\n               E'_+', '_', 'g' --  replace multiple occurances of _ leaving only one\n           ) into name;\n\n    return name;\nend\n$$"
704DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
705CELERYD_PREFETCH_MULTIPLIER = 1
706ROOT_USER = {'PASSWORD': u'********************', 'USER': 'root'}
707MANAGERS = ('Admins', 'staff.dev@nowwecomply.com')
708SESSION_EXPIRE_AT_BROWSER_CLOSE = True
709TIME_FORMAT = 'P'
710FACEBOOK_CHAT_PASSWD = u'********************'
711GRAPPELLI_ADMIN_TITLE = u'NowWeComply - Admin'
712CACHE_MIDDLEWARE_ALIAS = 'default'
713CSRF_COOKIE_PATH = '/'
714COTTERPIN_WEBCHECK_V2_PATH = '/web-check/v2/'
715CONTACT_US_URL = 'http://www.nowwecomply.com/contact-us'
716MANAGE_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/..'
717PROJECT_ROOT = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc'
718CACHE_MIDDLEWARE_KEY_PREFIX = u'********************'
719DEFAULT_CURRENCY_CODE = 'GBP'
720GOOGLE_CONSUMER_KEY = u'********************'
721CLMS_KEY = u'********************'
722DATE_FORMAT = 'd/m/Y'
723STATSD_CLIENT = 'django_statsd.clients.null'
724FACEBOOK_API_SECRET = u'********************'
725MEDIA_ROOT = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../work/shared/public_media/media/'
726CELERYD_CONCURRENCY = 1
727TEMPLATE_DEBUG = True
728DEFAULT_FROM_EMAIL = 'noreply@nowwecomply.com'
729SIGNUP_DD_PAYMENT_URL = 'https://www.securecollections.com/dd/nwc/index.aspx'
730CERT_DIR = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../cert'
731COTTERPIN_VALIDATOR_POST_CODE = '/check/post-code/{country}/'
732SITE_ID = 1
733CMS_PERMISSION = True
734SITE_SIGNUP_SUBDOMAIN = 'signup'
735SHORT_DATE_FORMAT = 'm/d/Y'
736BADBROWSER_BASE_TEMPLATE = 'client/unsuported_browser.html'
737CELERYD_MAX_TASKS_PER_CHILD = 500
738CELERY_SEND_EVENTS = True
739FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
740BUILD_DATABASE_DEFAULT_URL = 'localhost:3306'
741CELERY_SEND_TASK_ERROR_EMAILS = True
742COTTERPIN_VALIDATOR_DOMAIN = '/check/domain/'
743GA_CODE_SIGNUP_APP_PROFESSIONAL = '\n'
744GOOGLE_DISPLAY_NAME = 'NowWeComply'
745PDF_CERT_FILE = '/home/iza/projects/nowwecomply/nwc2/nowwecomply/python/nwc/../cert/pdfsign.p12'
746INTERNAL_IPS = '127.0.0.1'
747EMAIL_PORT = 25
748PASSWORD_HASHERS = u'********************'
749CMS_TOOLBARS = ['cms.cms_toolbar.PlaceholderToolbar', 'cms.cms_toolbar.PageToolbar', 'nwc.builds.cmspages.cms_toolbar.BasicToolbar', 'nwc.builds.cmspages.cms_toolbar.PageDetailsToolbar']
750ANONYMOUS_USER_ID = None
751DATETIME_INPUT_FORMATS = 
752TARGET_ALLRELATIONS_VIEW_QUERY = 'create or replace view target_relations_all as\n    SELECT target_log.target_id AS tid, target_log_relations.related_target_id, target_log_relations.relation_type,\n           target_log.created_at\n    FROM target_log JOIN target_log_relations ON (target_log.id = target_log_relations.target_log_id);'
753BUILD_SUPPLIED_CUSTOM_DOCUMENTS_DIR_NAME = 'supplied_documents/custom'
754
755You're seeing this error because you have DEBUG = True in your
756Django settings file. Change that to False, and Django will
757display a standard 500 page.