https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-03-27T19:40:28ZQGIS Issue TrackingQGIS Application - Bug report #18515: QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionErrorhttps://issues.qgis.org/issues/18515?journal_id=889872018-03-27T19:40:28ZRaphael Dumasrdumas@toronto.ca
<ul></ul><p>Just updated to 3.0.1 and this is still affected.</p>
<p>Interestingly this doesn't prevent loading layers from previous custom queries, but does prevent me from opening the SQL Window and loading new layers through that</p> QGIS Application - Bug report #18515: QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionErrorhttps://issues.qgis.org/issues/18515?journal_id=893532018-04-20T06:49:35ZJürgen Fischerjef@norbit.de
<ul><li><strong>Duplicated by</strong> <i><a class="issue tracker-1 status-5 priority-4 priority- closed" href="/issues/18775">Bug report #18775</a>: Permission denied error when connecting to PostGIS DB with auth config using DB Manager </i> added</li></ul> QGIS Application - Bug report #18515: QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionErrorhttps://issues.qgis.org/issues/18515?journal_id=893552018-04-20T06:50:00ZJürgen Fischerjef@norbit.de
<ul><li><strong>Description</strong> updated (<a href="/journals/diff/89355?detail_id=78167" title="View differences">diff</a>)</li><li><strong>Subject</strong> changed from <i>QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PremissionError</i> to <i>QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionError</i></li></ul> QGIS Application - Bug report #18515: QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionErrorhttps://issues.qgis.org/issues/18515?journal_id=893562018-04-20T06:52:33ZJürgen Fischerjef@norbit.de
<ul><li><strong>Description</strong> updated (<a href="/journals/diff/89356?detail_id=78168" title="View differences">diff</a>)</li></ul> QGIS Application - Bug report #18515: QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionErrorhttps://issues.qgis.org/issues/18515?journal_id=893592018-04-20T09:20:02ZJkr Da
<ul></ul><p>I have the same issue. Also the Toolbox -> Database -> Import into PostGIS function gives the same error.</p>
<pre>
2018-04-20T11:03:53 WARNING Traceback (most recent call last):
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\gui\ProcessingToolbox.py", line 333, in executeAlgorithm
dlg = AlgorithmDialog(alg)
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\gui\AlgorithmDialog.py", line 70, in __init__
self.setMainWidget(self.getParametersPanel(alg, self))
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\gui\AlgorithmDialog.py", line 77, in getParametersPanel
return ParametersPanel(parent, alg)
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\gui\ParametersPanel.py", line 82, in __init__
self.initWidgets()
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\gui\ParametersPanel.py", line 184, in initWidgets
wrapper.postInitialize(list(self.wrappers.values()))
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\gui\wrappers_postgis.py", line 94, in postInitialize
self.setConnection(wrapper.value())
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\gui\wrappers_postgis.py", line 108, in setConnection
self._database = GeoDB.from_name(connection)
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\tools\postgis.py", line 180, in from_name
return cls(uri=uri)
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\processing\tools\postgis.py", line 242, in __init__
os.remove(sslCAFile)
PermissionError: [WinError 5] Access is denied: 'C:/Users/username/AppData/Local/Temp/tmp_basic_{alphanumeric_values}.pem'
</pre>
<p>Windows 10. 3.0.1-Girona</p> QGIS Application - Bug report #18515: QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionErrorhttps://issues.qgis.org/issues/18515?journal_id=898472018-05-24T15:06:26ZRaphael Dumasrdumas@toronto.ca
<ul></ul><p>Also affects `3.0.3-Girona` <br />QGIS code revision: 8a899c8758</p> QGIS Application - Bug report #18515: QGIS 3.0 Can't Connect to PostgreSQL from DB Manager: PermissionErrorhttps://issues.qgis.org/issues/18515?journal_id=907692018-07-09T14:47:24ZRaphael Dumasrdumas@toronto.ca
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>The error in 3.0.3 appears to be different (I just updated to 3.2 and they are installed beside each other at the moment).</p>
<pre>
TypeError: unable to convert a QVariant of type 10 to a QMetaType of type 2
Traceback (most recent call last):
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\db_manager\db_model.py", line 441, in rowCount
self._refreshIndex(parent, True)
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\db_manager\db_model.py", line 490, in _refreshIndex
if item.populate():
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\db_manager\db_model.py", line 167, in populate
if not connection.connect():
File "C:/PROGRA~1/QGIS3~1.0/apps/qgis/./python/plugins\db_manager\db_plugins\postgis\plugin.py", line 88, in connect
sslmode = settings.value("sslmode", QgsDataSourceUri.SslPrefer, type=int)
TypeError: unable to convert a QVariant of type 10 to a QMetaType of type 2
Python version: 3.6.0 (v3.6.0:41df79263a11, Dec 23 2016, 08:06:12) [MSC v.1900 64 bit (AMD64)]
QGIS version: 3.0.3-Girona Girona, 8a899c8758
</pre>
<p>This is fixed in 3.2!</p>