id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 10641 Unable to create new project using PostgreSQL schema ilias@… "I've tried to create a new project: {{{ ilias@localhost:/srv/trac/projects$ sudo -u trac trac-admin ./the-project initenv Creating a new Trac environment at /srv/trac/projects/the-project Trac will first ask a few questions about your environment in order to initialize and prepare the project database. Please enter the name of your project. This name will be used in page titles and descriptions. Project Name [My Project]> The Project Please specify the connection string for the database to use. By default, a local SQLite database is created in the environment directory. It is also possible to use an already existing PostgreSQL database (check the Trac documentation for the exact connection string syntax). Database connection string [sqlite:db/trac.db]> postgres://trac@/trac?schema=the_project Creating and Initializing Project Initenv for '/srv/trac/projects/the-project' failed. Failed to create environment. invalid value for parameter ""search_path"": ""the_project"" DETAIL: schema ""the_project"" does not exist Traceback (most recent call last): File ""/usr/lib/python2.7/dist-packages/trac/admin/console.py"", line 422, in do_initenv options=options) File ""/usr/lib/python2.7/dist-packages/trac/env.py"", line 213, in __init__ self.create(options) File ""/usr/lib/python2.7/dist-packages/trac/env.py"", line 401, in create DatabaseManager(self).init_db() File ""/usr/lib/python2.7/dist-packages/trac/db/api.py"", line 146, in init_db connector.init_db(**args) File ""/usr/lib/python2.7/dist-packages/trac/db/postgres_backend.py"", line 98, in init_db params) File ""/usr/lib/python2.7/dist-packages/trac/db/postgres_backend.py"", line 87, in get_connection params) File ""/usr/lib/python2.7/dist-packages/trac/db/postgres_backend.py"", line 212, in __init__ cnx.cursor().execute('SET search_path TO %s', (self.schema,)) DataError: invalid value for parameter ""search_path"": ""the_project"" DETAIL: schema ""the_project"" does not exist }}} Of course, the database 'trac' exists and user 'trac' has necessary permissions to operate on the database. The problem is in function PostgreSQLConnector.init_db(). The function obtains new connection. Eventually PostgreSQLConnection's constructor checks if 'schema' is among params and updates the 'search_path'. The problem is that the schema does not exist before project creation, and it's impossible to update the 'search_path'. This error is in the version 0.12-stable as well as in the trunk. Patches with the little hack are applied. The hack removes 'schema' from 'params' and updates 'cnx.schema' as 'cnx' has been created." defect closed high database backend 0.12.2 major duplicate PostgreSQL, initenv, postgresql