id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
10319	Error with postgresql and Trac 1.0	mcdevil@gmx.net	sandinak	I tried to upgraded from version 0.2.2 and have some problems\r\n\r\nInstallation:\r\n * since v0.3 a database upgrade is needed\r\n * this does only work if tracext.adauth.db.activedirectoryauthpluginsetup = enabled (this hint qould be good in the documentation) \r\n\r\n * the upgrade fails on postgresql with unknown type varcahar(32) -> typo: varchar(32)\r\n * the upgrade fails on postgresql with unknown type binary -> i tried: text\r\n\r\nAfter this the installation and upgrade succeeds \r\n\r\nBut i've still an error:\r\n\r\n{{{\r\n  File "/usr/local/lib/python2.6/dist-packages/TracActiveDirectoryAuth-0.3.2-py2.6.egg/tracext/adauth/auth.py", line 139, in check_password\r\n    dn = self._get_user_dn(user)\r\n  File "/usr/local/lib/python2.6/dist-packages/TracActiveDirectoryAuth-0.3.2-py2.6.egg/tracext/adauth/auth.py", line 271, in _get_user_dn\r\n    if self.has_user(user):\r\n  File "/usr/local/lib/python2.6/dist-packages/TracActiveDirectoryAuth-0.3.2-py2.6.egg/tracext/adauth/auth.py", line 129, in has_user\r\n    users = self.get_users()\r\n  File "/usr/local/lib/python2.6/dist-packages/TracActiveDirectoryAuth-0.3.2-py2.6.egg/tracext/adauth/auth.py", line 73, in get_users\r\n    userinfo = self.expand_group_users(self.auth_group)\r\n  File "/usr/local/lib/python2.6/dist-packages/TracActiveDirectoryAuth-0.3.2-py2.6.egg/tracext/adauth/auth.py", line 97, in expand_group_users\r\n    g = self._ad_search(self.base_dn, ldap.SCOPE_SUBTREE, groupfilter, ['member'])\r\n  File "/usr/local/lib/python2.6/dist-packages/TracActiveDirectoryAuth-0.3.2-py2.6.egg/tracext/adauth/auth.py", line 439, in _ad_search\r\n    cur.execute("SELECT lut,data FROM ad_cache WHERE id='%s'" % key)\r\n  File "/usr/local/lib/python2.6/dist-packages/Trac-1.0-py2.6.egg/trac/db/util.py", line 66, in execute\r\n    return self.cursor.execute(sql)\r\nInternalError: FEHLER:  aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert\r\n}}}\r\n\r\nAny idea what's wrong?	defect	closed	normal	DirectoryAuthPlugin	normal	fixed			1.0