Hi everyone, I have connected WebDAV and SVN auth with a wsgi script. I needed to use a standalone DAL. When you do a dav petition with the navigator it makes a lot of petitions. Well, the thing is that always there is a connection opened (i can see them with PhpMyAdmin)
if self.db: self.db._adapter.close() seeing this issue: http://code.google.com/p/web2py/issues/detail?id=731<http://code.google.com/p/web2py/issues/detail?id=731#c4> I have tried a lot of the lines that i found there something like: if self.db: from gluon.dal import BaseAdapter BaseAdapter.close_all_instances(None) BaseAdapter.close_all_instances('commit') BaseAdapter.close_all_instances('rollback') something like: if self.db: from gluon.dal import thread as dal_thread dal_thread.instances.remove(self.db._adapter) self.db._adapter.close() and even something desesperated like: if self.db: from gluon.dal import thread as dal_thread dal_thread.instances.remove(self.db._adapter) self.db._adapter.close() self.db._adapter.close_all_instances(None) self.db._adapter.close_all_instances('commit') self.db._adapter.close_all_instances('rollback') from gluon.dal import ConnectionPool ConnectionPool.close_all_instances(None) ConnectionPool.close_all_instances('commit') ConnectionPool.close_all_instances('rollback') from gluon.dal import BaseAdapter BaseAdapter.close_all_instances(None) BaseAdapter.close_all_instances('commit') BaseAdapter.close_all_instances('rollback') But always, in the best, it leaves at least one connection opened, and i don't know how to deal with it. I have using web2py 1.99.7 in both development and production environments. Any ideas? in this moment we are building a python mysql script, but we want to use DAL to make it runnable on any of the web2py/DAL supported db Thanks in advance --