qgis3 - no write/read of Geopackage or Sqlite databases

[Malauch]

Hi, I noticed that there is no Geopackage or Sqlite support in qgis3 port. I can't either save or read these databases. On other platforms (windows and linux) there is no problem like that.

[Schamschula (Marius Schamschula)]

Please don't set priority. This field is for MacPorts maintainers.

[Malauch]

I noticed that when trying to create new geopackage or sqlite layer QGIS shows error: "Layer creation failed. GeoPackage driver not found."

[Veence (Vincent)]

I don’t seem to have the same problem. I can create a SQLite layer, however the DB manager doesn’t work. Is that what you get?

[Malauch]

My mistake, it's true that creating Sqlite works but for Geopackage still doesn't. Reading doesn't work for both formats.

[Malauch]

Today I noticed that problem is wider, because there is no option to connect any database type when adding vector layer (for example ODBC). I checked oficial binaries from KyngChaos on VM and there wasn't any problem like that.

[Malauch]

Is there any progress in that matter or only I have that problem with connection to data base driver?

[Veence (Vincent)]

Did you upgrade to 3.0.1?

[Malauch]

Yes, I did. The MacPorts build is the only one which has problem like that. Official MacOS binaries, Linux version, Windows version all read and write geopackage without problem.

[Veence (Vincent)]

I can create Geopackage layers, but trying to open one crashes QGis. Do you get the same behaviour?

[Veence (Vincent)]

If you have loaded the "official Mac binaries" could you take a screen shot of the "about" dialogue to know what versions it is linked against? Thanks.

[Malauch]

In Macport's QGIS version I don't have crash, only dialog about no data base drive or "can't connect to database".

[Veence (Vincent)]

You’re still using the 3.0.0 version. Try upgrading to the 3.0.1 I committed yesterday and tell me if that bug is always here.

[Malauch]

That "About" screenshot is from "official" KyngChaos version.

[Malauch]

In addition in Macport's version, when trying to connect to Sqlite database from database manager there are some python bugs.

			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_model.py", line 441, in rowCount
			    self._refreshIndex(parent, True)
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_model.py", line 490, in _refreshIndex
			    if item.populate():
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_model.py", line 167, in populate
			    if not connection.connect():
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 80, in connect
			    return self.connectToUri(uri)
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/plugin.py", line 109, in connectToUri
			    self.db = self.databasesFactory(self, uri)
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 66, in databasesFactory
			    return SLDatabase(connection, uri)
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 109, in __init__
			    Database.__init__(self, connection, uri)
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/plugin.py", line 218, in __init__
			    self.connector = self.connectorsFactory(uri)
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/plugin.py", line 112, in connectorsFactory
			    return SpatiaLiteDBConnector(uri)
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/plugins/db_manager/db_plugins/spatialite/connector.py", line 51, in __init__
			    self.connection = spatialite_connect(self._connectionInfo())
			  File "/Applications/MacPorts/Qgis3.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 616, in spatialite_connect
			    raise RuntimeError("Cannot find any suitable spatialite module")
			RuntimeError: Cannot find any suitable spatialite module
			

[Veence (Vincent)]

Interesting. I’ll try that later today. Thanks for the info.

[Malauch]

I solve that problem. Today I tried to use ogr2ogr in Terminal and I found out that there are almost no drivers installed. I install gdal with additional variants: ` sudo port install gdal +odbc +spatialite +sqlite3 ` Now it support all necessary formats in ogr2ogr and QGIS. I think QGIS should install all these variants by default.

[Veence (Vincent)]

Ah, okay, I will do that, makes sense. Thanks and sorry for the hair tearing —