[Live-demo] Mapfish - 5.0 beta2 - no database ?

maplabs at light42.com maplabs at light42.com
Sun Jul 31 00:48:51 EDT 2011


Unfortunately, it appears that this is still the case for   5.0 beta3
looking in the postgresql logs, I see the attempts to remove the 
database, and to connect to i
  but no sign of an attempt to install it... 

ideas?

==
Brian Hamlin
GeoCal
OSGeo California Chapter
415-717-4462 cell

On Mon, 25 Jul 2011 16:50:32 -0400, maplabs at light42.com wrote:
Mapfish fails to launch - apache error log showsthe following
> --
> also, searching for installed postgres databases shows
> user at osgeo-live:~$ psql -l | grep fish
> user at osgeo-live:~$
>
> ---
>
> [Mon Jul 25 14:47:41 2011] [error] 
> /usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/ext/declarative.py:1129: SAWarning: The classname 'Poi' is already in the registry of this declarative base, mapped to <class 
> 'mapfishsample.model.Poi'>
> [Mon Jul 25 14:47:41 2011] [error]   _as_declarative(cls, 
> classname, cls.__dict__)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1] mod_wsgi 
> (pid=1244): Target WSGI script 
> '/usr/local/lib/mapfish/MapfishSample/buildout/parts/modwsgi/wsgi' 
> cannot be loaded as Python module. [Mon Jul 25 14:47:41 2011] [error] 
> [client 127.0.0.1] mod_wsgi (pid=1244): Exception occurred processing 
> WSGI script 
> '/usr/local/lib/mapfish/MapfishSample/buildout/parts/modwsgi/wsgi'. 
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1] Traceback (most 
> recent call last):
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/parts/modwsgi/wsgi", 
> line 46, in <module>
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     
> application = loadapp("config:" + configfile)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/PasteDeploy-1.3.4-py2.7.egg/paste/deploy/loadwsgi.py", line 203, in 
> loadapp
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> loadobj(APP, uri, name=name, **kw)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/PasteDeploy-1.3.4-py2.7.egg/paste/deploy/loadwsgi.py", line 224, in 
> loadobj
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> context.create()
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/PasteDeploy-1.3.4-py2.7.egg/paste/deploy/loadwsgi.py", line 617, in 
> create
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> self.object_type.invoke(self)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/PasteDeploy-1.3.4-py2.7.egg/paste/deploy/loadwsgi.py", line 109, in 
> invoke
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> fix_call(context.object, context.global_conf, **context.local_conf)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/PasteDeploy-1.3.4-py2.7.egg/paste/deploy/util/fixtypeerror.py", line 57, in 
> fix_call
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     val = 
> callable(*args, **kw)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/mapfishsample/config/middleware.py", 
> line 37, in make_app
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     config 
> = load_environment(global_conf, app_conf)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/mapfishsample/config/environment.py", 
> line 49, in load_environment
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     
> init_model(engine)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/mapfishsample/model/__init__.py", line 
> 16, in init_model
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     class 
> Poi(Base, GeometryTableMixIn):
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/ext/declarative.py", line 1129, in 
> __init__
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     
> _as_declarative(cls, classname, cls.__dict__)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/ext/declarative.py", line 1027, in 
> _as_declarative
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     **table_kw)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/schema.py", line 265, in 
> __new__
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     
> table._init(name, metadata, *args, **kw)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/schema.py", line 324, in 
> _init
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     self, 
> include_columns
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/engine/base.py", line 2218, in 
> run_callable
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     conn = 
> self.contextual_connect()
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/engine/base.py", line 2284, in 
> contextual_connect
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     
> self.pool.connect(),
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/pool.py", line 209, in 
> connect
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> _ConnectionFairy(self).checkout()
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/pool.py", line 370, in 
> __init__
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     rec = 
> self._connection_record = pool._do_get()
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/pool.py", line 696, in 
> _do_get
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     con = 
> self._create_connection()
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/pool.py", line 174, in 
> _create_connection
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> _ConnectionRecord(self)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/pool.py", line 255, in 
> __init__
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     
> self.connection = self.__connect()
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/pool.py", line 315, in 
> __connect
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     
> connection = self.__pool._creator()
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/engine/strategies.py", line 80, in 
> connect
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> dialect.connect(*cargs, **cparams)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]   File 
> "/usr/local/lib/mapfish/MapfishSample/buildout/eggs/SQLAlchemy-0.7.1-py2.7-linux-i686.egg/sqlalchemy/engine/default.py", line 275, in 
> connect
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]     return 
> self.dbapi.connect(*cargs, **cparams)
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1] 
> OperationalError: (OperationalError) FATAL:  database 
> "v2.2_mapfishsample" does not exist
> [Mon Jul 25 14:47:41 2011] [error] [client 127.0.0.1]  None None
>
>
> _______________________________________________
> Live-demo mailing list
> Live-demo at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/live-demo
> http://wiki.osgeo.org/wiki/Live_GIS_Disc
>
>




More information about the Live-demo mailing list