[GNC] mysql setup in linux (debian)

[David Cousens]

It will depend on whether you have installed for the distributions
repositories using their software manager or whether you have installed a
flatpak version either from the repository or the GnuCash website. 

The flatpak versions often require specific permissions granted so they can
access the computer's peripherals as they are a protected sandbox setup.  If
you search the mailing list archives you will find more info on how to do
this. If it is a flatpak version this may be the problem rather than GnuCash
itself although I would still expect the database options to appear in the
File -Save As dialogue but fail on the attempt to write to the database.

That may indicate that it has been built without the basic libdbi support.
The libddi-mysql library is a run time library (similar libraries for
PostGRES and SQlite3) which has to be present at runtime.  You can check
that the libraries are loaded using the command "dpkg -l |grep libdb" in a
terminal which should list all the related installed packages. My Linux MInt
20.3 system has all three libdbd-mysql, libdbd-pgsql and libdbd-sqlite3
installed as well as the libdbi library (I also have the development header
file libdbi-dev as I build GnuCash from the tarball on the website).

If you can let us know which Linux distribution and version number and the
GnuCash version which is installed and how you installed it (software
Manager, apt, or other) we may be able to give more specific advice. Usually
the versions maintained by the distribution repositories are built with all
the normal default build options which should include the database backends.

Building from scratch is a possibility if all else fails. See
https://wiki.gnucash.org/wiki/Building_On_Linux for detailed instructions

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html