[GNC] mysql setup in linux (debian)

[gnu Gord]

Thank you very much for the information. It seems the problem was that I
had not installed the libdbd-mysql package. I did have the libdbi but not
the mysql package. I also did not have the libdbd packages for pgsql or
sqlite3 ... but I do now! and they now show up in gnucash as options for
the 'save as' Data Format.

The only problem I have now is when I try to save a larger database (about
3.1M in XML) I get an error. It seems to work OK with a smaller database.
The error just says, "An error occurred while processing
mysql://gord@localhost/gnucash."
I tried starting gnucash with the --debug option but I did not get any
error messages other than the one in the gui.



On Sun, Jan 31, 2021 at 4:52 PM David Cousens <davidcousens at bigpond.com>
wrote:

> 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
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>