[Qgis-user] DB manager error

[Even Rouault]

Le vendredi 28 octobre 2016 21:09:26, vous avez écrit :
> Hi, 
> 
> I'm using QGIS 2.99.0-Master rev. b2587b7 on Ubuntu 16.04 64bits.
> 
> When I tried to open a SQL query on a POSTGIS database I've got the
> following error while trying to open the saved connection to the
> database: 
> 
> 2016-10-28T15:58:35	1	Traceback (most recent call last):
> 
> 			  File "/usr/share/qgis/python/plugins/db_manager/db_model.py", 
line
> 440, in rowCount
> 
> 			    self._refreshIndex(parent, True)
> 
> 			  File "/usr/share/qgis/python/plugins/db_manager/db_model.py", 
line
> 491, in _refreshIndex
> 
> 			    if item.populate():
> 
> 			  File "/usr/share/qgis/python/plugins/db_manager/db_model.py", 
line
> 166, in populate
> 
> 			    if not connection.connect():
> 
> 			  File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 99, in connect
> 
> 			    return self.connectToUri(uri)
> 
> 			  File 
"/usr/share/qgis/python/plugins/db_manager/db_plugins/plugin.py",
> line 108, in connectToUri
> 
> 			    self.db = self.databasesFactory(self, uri)
> 
> 			  File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 69, in databasesFactory
> 
> 			    return PGDatabase(connection, uri)
> 
> 			  File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 107, in __init__
> 
> 			    Database.__init__(self, connection, uri)
> 
> 			  File 
"/usr/share/qgis/python/plugins/db_manager/db_plugins/plugin.py",
> line 217, in __init__
> 
> 			    self.connector = self.connectorsFactory(uri)
> 
> 			  File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/plugin.py",
> line 110, in connectorsFactory
> 
> 			    return PostGisDBConnector(uri)
> 
> 			  File
> "/usr/share/qgis/python/plugins/db_manager/db_plugins/postgis/connector.py
> ", line 67, in __init__
> 
> 			    self.connection = 
psycopg2.connect(expandedConnInfo.encode('utf-8'))
> 
> 			  File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", 
line 164,
> in connect
> 
> 			    conn = _connect(dsn, connection_factory=connection_factory,
> async=async)
> 
> 			TypeError: argument 1 must be str, not bytes
> 
> 
> I can load postgis layers from the same connection without problems.
> What can I do?

I see a pull request about that https://github.com/qgis/QGIS/pull/3635, but it 
is still tagged work in progress.

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com