Skip to content

Instantly share code, notes, and snippets.

View aaronr's full-sized avatar

Aaron Racicot aaronr

View GitHub Profile
.olLayerGoogleV3.olLayerGooglePoweredBy {
display: none !important;
}
# Verify that the user has permission to view the layer.
if query_params.has_key('LAYERS'):
layers=query_params['LAYERS']
elif query_params.has_key('LAYER'):
layers=query_params['LAYER']
else:
raise ERMAException('Not Found', '404 Not Found')
[Fri Aug 03 11:00:32 2012] [error] MapServerProxy.DEBUG: {'LAYERS': 'ports_pame_2009_10572', 'SERVICE': 'WMS', 'FORMAT': 'image/png', 'BUFFER': '0', 'REQUEST': 'GetMap', 'SRS': 'EPSG:900913', 'HEIGHT': '256', 'WIDTH': '256', 'VERSION': '1.1.1', 'BBOX': '-20037508.34,12523442.7125,-18785164.06875,13775786.98375', 'TRANSPARENT': 'true'}
[Fri Aug 03 11:00:32 2012] [error] MapServerProxy.DEBUG: Retrieved query string of BBOX=-20037508.34,12523442.7125,-18785164.06875,13775786.98375&BUFFER=0&FORMAT=image%2Fpng&HEIGHT=256&LAYERS=ports_pame_2009_10572&REQUEST=GetMap&SERVICE=WMS&SRS=EPSG%3A900913&STYLES=&TRANSPARENT=true&VERSION=1.1.1&WIDTH=256
[Fri Aug 03 11:00:32 2012] [error] [client 127.0.0.1] mod_wsgi (pid=28943): Exception occurred processing WSGI script '/data2/allison.noaaerma.org/regional/arctic/ERMA/lib/ERMA/Apache/MapServerProxy.wsgi'.
[Fri Aug 03 11:00:32 2012] [error] [client 127.0.0.1] Traceback (most recent call last):
[Fri Aug 03 11:00:32 2012] [error] [client 127.0.0.1] File "/data2/allison.noaaerm
Failed to apply update 3 (/data2/erd.noaaerma.org/regional/gulfofmexico/ERMA/database/updates/update_3.py)
Traceback (most recent call last):
File "setupSiteDB.py", line 575, in apply_database_updates
update_module.updateDDL(cursor, schema, config)
File "/data2/erd.noaaerma.org/regional/gulfofmexico/ERMA/database/updates/update_3.py", line 70, in updateDDL
cursor.execute(qs)
File "/data2/erd.noaaerma.org/regional/gulfofmexico/venv/erma/lib/python2.6/site-packages/psycopg2/extras.py", line 123, in execute
return _cursor.execute(self, query, vars)
ProgrammingError: function toc_text2var(text, character varying) does not exist
LINE 10: toc_text2var('data-legend'::text, data_layer...
ERROR: function toc_text2var(text, text) does not exist
LINE 2: ... || ' data-ver='::text) || data_layer.version) || toc_text2v...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR: relation "layer_datatoc" does not exist
LINE 2: ...atoc.attachedfiles, layer_datatoc.created_by FROM layer_data...
Generating models for Django applications...
Traceback (most recent call last):
File "manage.py", line 23, in <module>
execute_manager(settings)
File "/data2/erd.noaaerma.org/regional/gulfofmexico/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 459, in execute_manager
utility.execute()
File "/data2/erd.noaaerma.org/regional/gulfofmexico/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/data2/erd.noaaerma.org/regional/gulfofmexico/venv/erma/lib/python2.6/site-packages/django/core/management/base.py", line 196, in run_from_argv
self.execute(*args, **options.__dict__)
Restarting celery periodic task scheduler
Stopping celerybeat... OK
Starting celerybeat...
update-rc.d: using dependency based boot sequencing
Updating cache with layer permissionsTraceback (most recent call last):
File "/data2/erd.noaaerma.org/regional/pacific/django/layerquery/manage.py", line 23, in <module>
execute_manager(settings)
File "/data2/erd.noaaerma.org/regional/pacific/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 459, in execute_manager
utility.execute()
File "/data2/erd.noaaerma.org/regional/pacific/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 382, in execute
ALTER TABLE
ALTER TABLE
Completed restoring non-shapefile tables, view, and sequences
Starting celery task to restore shapefile tables.
Restore started (please wait)Traceback (most recent call last):
File "manage.py", line 23, in <module>
execute_manager(settings)
File "/data2/aaron.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 459, in execute_manager
utility.execute()
File "/data2/aaron.noaaerma.org/regional/arctic/venv/erma/lib/python2.6/site-packages/django/core/management/__init__.py", line 382, in execute
regional2_aaronr=# select * from pg_stat_activity where datname like 'erma%';
datid | datname | procpid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | query_start | waiting | current_query
----------+------------+---------+----------+----------------------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+-------------------------------+---------+-----------------------
10980581 | erma_gregc | 12113 | 352258 | erma_gulfofmexico | | 127.0.0.1 | | 56565 | 2012-08-29 13:30:01.955284-07 | | 2012-08-29 13:30:01.963217-07 | f | <IDLE>
10980581 | erma_gregc | 8777 | 11319998 | erma_pacific_gregc | erma_django | 127.0.0.1 | | 55597 | 2012-08-29 13:12:01.56137-07 | 2012-08