> Ryan Steele wrote:
> > I'm working on migrating an installation from SQLite to PostgreSQL,
> > but the sqlite2pg script seems to fail, even with all the pre-
> > requisite packages installed:
> >
> > ii python-psycopg2
> > 2.0.13-2ubuntu2 Python module for PostgreSQL
> > ii python-psycopg2-dbg 2.0.13-2ubuntu2
> > Python module for PostgreSQL (debug extension)
> > ii python-psycopg2-testsuite 2.0.13-2ubuntu2
> > Python module for PostgreSQL
> > ii python
> > 2.6.5-0ubuntu1 An interactive high-level object-
> > oriented language (default version)
> > ii postgresql-9.0
> > 9.0.4-1~lucid1 object-relational SQL database,
> > version 9.0 server
> > ii postgresql-client-9.0
> > 9.0.4-1~lucid1 front-end programs for PostgreSQL
> > 9.0
> >
> >
> >
> > root@host:~# ./sqlite2pg.py -e /path/to/trac -p 'postgres://
> > user:pass@localhost:5432/trac'
> > Traceback (most recent call last):
> > File "./sqlite2pg.py", line 335, in <module>
> > sys.exit(main(sys.argv[1:]))
> > File "./sqlite2pg.py", line 331, in main
> > Main(opts)
> > File "./sqlite2pg.py", line 244, in Main
> > pgenv = getPostgreSQLEnvironment(opts)
> > File "./sqlite2pg.py", line 209, in getPostgreSQLEnvironment
> > cnx = env.get_db_cnx()
> > File "/usr/lib/python2.6/dist-packages/trac/env.py", line 285, in
> > get_db_cnx
> > return DatabaseManager(self).get_connection()
> > File "/usr/lib/python2.6/dist-packages/trac/db/api.py",
> line 90, in
> > get_connection
> > connector, args = self._get_connector()
> > File "/usr/lib/python2.6/dist-packages/trac/db/api.py",
> line 131, in
> > _get_connector
> > raise TracError('Unsupported database type "%s"' % scheme)
> > trac.core.TracError: Unsupported database type "postgres"
> >
> > I know that the PG backend is supported, because the
> > TracEnvironment#DatabaseConnectionStrings wiki page says so (this is
> > version 0.11.7), and all of the necessary files exist underneath
> > $PYTHONPATH (e.g., postgres_backend.py), so I'm a little confused as
> > to what the problem is. If it helps, the relevant part of
> > _get_connector is:
> >
> > def _get_connector(self): ### FIXME: Make it public?
> > scheme, args = _parse_db_str(self.connection_uri)
> > candidates = [
> > (priority, connector)
> > for connector in self.connectors
> > for scheme_, priority in
> connector.get_supported_schemes()
> > if scheme_ == scheme
> > ]
> > if not candidates:
> > raise TracError('Unsupported database type
> "%s"' % scheme)
> >
> > Also, the connectors are defined like so in the
> DatabaseManager class:
> >
> > class DatabaseManager(Component):
> > connectors = ExtensionPoint(IDatabaseConnector)
> >
> > The IDatabaseConnector class is what has the get_connection method,
> > and in postgres_backend.py, I can see that the PostgreSQLConnector
> > class implements IDatabaseConnector:
> >
> > class PostgreSQLConnector(Component):
> > implements(IDatabaseConnector)
> >
> >
> > So, the error provided doesn't make a whole lot of sense to me. I
> > would tend to think it's an installation-specific problem (e.g.,
> > something nothing being in $PYTHONPATH), but I don't see evidence of
> > that here. Any help is most appreciated, and more detail can be
> > provided if requested.
> >
> > Cheers,
> > Ryan
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Ryan Steele
> Sent: 12 August 2011 19:43
> To: Trac Users
> Subject: [Trac] Re: Migrating from SQLite to PostgreSQL
>
> Just for kicks, I decided to print out the list of connectors
> right before it
> tries to validate what is passed in:
>
> def _get_connector(self): ### FIXME: Make it public?
> scheme, args = _parse_db_str(self.connection_uri)
> print self.connectors
> candidates = [
> (priority, connector)
> for connector in self.connectors
> for scheme_, priority in connector.get_supported_schemes()
> if scheme_ == scheme
> ]
> if not candidates:
> raise TracError('Unsupported database type "%s"' % scheme)
>
>
> The root of the problem here is that the list only shows the
> SQLite connector:
>
> root@host:~# ./sqlite2pg.py --tracenv /path/to/trac -p
> 'postgres://user:pass@localhost:5432/trac'
>
> [<trac.db.sqlite_backend.SQLiteConnector object at 0x2ee4cd0>]
>
> Why exactly that is, I'm not sure yet, as the connectors
> (sqlite, mysql,
> postgres) are all in the same directory. Gonna keep digging,
> but open to
> suggestions.
>
> Cheers,
> Ryan
>
I am guessing but... if that error is coming from the script and your trac
works OK (have you tried just creating a new, empty trac using PostgreSQL as
the backend to make sure?) then perhaps it is to do with the way trac is
configured... Is it in some sort of python virtualenv which would mean when you
_run_ the script (instead of www-user etc) does not see the postgresql code?
~ mark c
--
You received this message because you are subscribed to the Google Groups "Trac
Users" 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/trac-users?hl=en.
