Bug 405171

Summary:	MySQL and PostgreSQL plugins not found for KEXI flatpak
Product:	[Applications] KEXI	Reporter:	Jarosław Staniek <staniek>
Component:	General	Assignee:	Kexi Bugs <kexi-bugs>
Status:	CONFIRMED ---
Severity:	normal	CC:	adam, aleixpol, inksi
Priority:	NOR
Version:	3.2.0 Beta
Target Milestone:	---
Platform:	Flatpak
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Attachments:	Database plugins not found

Description Jarosław Staniek 2019-03-07 09:20:17 UTC

Created attachment 118620 [details]
Database plugins not found

SUMMARY

Database plugins not found for KEXI flatpak. 

STEPS TO REPRODUCE
1. Run KEXI org.kde.kexi-stable (3.2 beta for now) or org.kde.kexi (3.3 alpha for now)
2. Go to Open -> Projects stored on DB server

OBSERVED RESULT

As on screenshot: no plugins

EXPECTED RESULT

MySQL and PostgreSQL plugin found so it's possible to add server locations in step 2.

Developer's note: these plugins shall belong to the KDb package, not KEXI.

SOFTWARE/OS VERSIONS
Linux: Flatpak -- http://distribute.kde.org/flatpak-apps-testing
Desktop: XFCE

Comment 1 Jarosław Staniek 2019-03-07 09:27:19 UTC

It seems that the KDb component has SQLite plugin only and not MySQL and PostgreSQL:

03:27:34  -- Could NOT find MySQL (missing: MYSQL_LIBRARIES MYSQL_INCLUDE_DIR MYSQL_LIB_DIR) 
03:27:34  -- Could NOT find PostgreSQL (missing: PostgreSQL_LIBRARY PostgreSQL_INCLUDE_DIR PostgreSQL_TYPE_INCLUDE_DIR) 

See https://binary-factory.kde.org/job/Kexi_stable_flatpak/7/consoleFull

Comment 2 Aleix Pol 2019-03-08 11:18:39 UTC

Yep, they're not installed. It needs the libraries included in the packaging.

Comment 3 Jarosław Staniek 2019-03-08 21:47:12 UTC

@Aleix I would appreciate pointers on how to do it.

Comment 4 Aleix Pol 2019-03-11 11:52:59 UTC

It will need the projects bundled.

Here for example you can see how they build mariadb for flatpak:
https://github.com/flathub/com.github.alecaddd.sequeler/blob/d2a26dbc45a754892f2963f6beca5075a27d7e2c/com.github.alecaddd.sequeler.json#L123