I have trac .10 using a Postgresql database that has multiple schemas for various applications. Trac is running on a server and the postgres database is on a different server
I read the ticket http://trac.edgewall.org/ticket/3308 but it said it has been resolved. I checked the file I have in my /usr/lib/python2.4/site-packages/trac/db folder and verified the changes are still there. The address is as follows: postgres://trac:trac@vp-vm-postgres:5432/APPSUPPORTDB?schema=trac The error I get reports: [Fri Sep 07 00:18:09 2012] [info] [client 10.248.54.176] mod_wsgi (pid=30411, process='', application=''): Loading WSGI script '/etc/trac/vp/apache/cgi-bin/trac.wsgi'. [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] mod_wsgi (pid=30411): Exception occurred processing WSGI script '/etc/trac/vp/apache/cgi-bin/trac.wsgi'. [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] Traceback (most recent call last): [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 391, in dispatch_request [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] env = _open_environment(env_path, run_once=run_once) [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 58, in _open_environment [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] env_cache[env_path] = open_environment(env_path) [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/env.py", line 467, in open_environment [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] if env.needs_upgrade(): [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/env.py", line 354, in needs_upgrade [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] if participant.environment_needs_upgrade(db): [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/env.py", line 408, in environment_needs_upgrade [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] dbver = self.env.get_version(db) [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/env.py", line 268, in get_version [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] cursor.execute("SELECT value FROM system WHERE name='database_version'") [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 51, in execute [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] return self.cursor.execute(sql) [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 51, in execute [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] return self.cursor.execute(sql) [Fri Sep 07 00:18:09 2012] [error] [client 10.248.54.176] ProgrammingError: relation "system" does not exist at character 19 -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/M9kFU0N4Qa8J. 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/trac-users?hl=en.
