when connecting to 2 db( one sqllite for tg2 auth and the second
mssql)
I commented out the sqlalchemy.url in development.ini and instead
wrote 2 lines: sqlalchemy.first.url and sqlalchemy.second.url
I also changed app_cfg and model.__init__ according to the docs - so
everything finally worked - but!
when I run paster setup-app development.ini in the end I get a
"keyerror:sqlalchemy.url" .I think this is called from schema.py who
ends with:
try:
main(argv=['version_control'], url=config['sqlalchemy.url'],
repository='migration', name='migration')
except DatabaseAlreadyControlledError:
print 'Database already under version control'
and some of the information isn't loaded to sqllite (like users and
passwords)
when I manually change the sqlalchemy.url to sqlalchemy.first.url -
everything works fine except for tg2 admin screen where when I try to
enter the class mapped to the second db (not users,groups etc) I get
an error
OperationalError: (OperationalError) no such table:..
where the traceback is :
Module weberror.evalexception:431 in respond view
>> app_iter = self.application(environ, detect_start_response)
Module tg.configuration:825 in remover view
>> return app(environ, start_response)
Module repoze.tm:24 in __call__ view
>> result = self.application(environ, save_status_and_headers)
Module repoze.who.middleware:107 in __call__ view
>> app_iter = app(environ, wrapper.wrap_start_response)
Module tw.core.middleware:46 in __call__ view
>> return self.wsgi_app(environ, start_response)
Module tw.core.middleware:72 in wsgi_app view
>> resp = req.get_response(self.application)
Module webob.request:1053 in get_response view
>> application, catch_exc_info=False)
Module webob.request:1022 in call_application view
>> app_iter = application(self.environ, start_response)
Module tw.core.resource_injector:70 in _injector view
>> resp = req.get_response(app)
Module webob.request:1053 in get_response view
>> application, catch_exc_info=False)
Module webob.request:1022 in call_application view
>> app_iter = application(self.environ, start_response)
Module beaker.middleware:73 in __call__ view
>> return self.app(environ, start_response)
Module beaker.middleware:152 in __call__ view
>> return self.wrap_app(environ, session_start_response)
Module routes.middleware:131 in __call__ view
>> response = self.app(environ, start_response)
Module pylons.wsgiapp:107 in __call__ view
>> response = self.dispatch(controller, environ, start_response)
Module pylons.wsgiapp:312 in dispatch view
>> return controller(environ, start_response)
Module priorityagent.lib.base:31 in __call__ view
>> return TGController.__call__(self, environ, start_response)
Module pylons.controllers.core:211 in __call__ view
>> response = self._dispatch_call()
Module pylons.controllers.core:162 in _dispatch_call view
>> response = self._inspect_call(func)
Module pylons.controllers.core:105 in _inspect_call view
>> result = self._perform_call(func, args)
Module tg.controllers.dispatcher:254 in _perform_call view
>> r = self._call(func, params, remainder=remainder)
Module tg.controllers.decoratedcontroller:116 in _call view
>> output = controller(*remainder, **dict(params))
Module tgext.crud.controller:119 in get_all view
>> values = self.table_filler.get_value(**kw)
Module sprox.fillerbase:191 in get_value view
>> count, objs = self._do_get_provider_count_and_objs(**kw)
Module sprox.fillerbase:173 in
_do_get_provider_count_and_objs view
>> count, objs = self.__provider__.query(self.__entity__, limit, offset,
>> self.__limit_fields__, order_by, desc)
Module sprox.sa.provider:397 in query view
>> count = query.count()
Module sqlalchemy.orm.query:2375 in count view
>> return self.from_self(col).scalar()
Module sqlalchemy.orm.query:2020 in scalar view
>> ret = self.one()
Module sqlalchemy.orm.query:1989 in one view
>> ret = list(self)
Module sqlalchemy.orm.query:2032 in __iter__ view
>> return self._execute_and_instances(context)
Module sqlalchemy.orm.query:2047 in _execute_and_instances
view
>> result = conn.execute(querycontext.statement, self._params)
Module sqlalchemy.engine.base:1399 in execute view
>> params)
Module sqlalchemy.engine.base:1532 in _execute_clauseelement
view
>> compiled_sql, distilled_params
Module sqlalchemy.engine.base:1640 in _execute_context view
>> context)
Module sqlalchemy.engine.base:1633 in _execute_context view
>> context)
Module sqlalchemy.engine.default:330 in do_execute view
>> cursor.execute(statement, parameters)
OperationalError: (OperationalError) no such table: SOMETABLE u'SELECT
count(*) AS count_1 \nFROM (SELECT "SOMETABLE "."EVENTCODE" AS
"SOMETABLE _EVENTCODE" \nFROM "SOMETABLE ") AS anon_1' ()
be glad to any help with this
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.
