[GNC] mysql setup in linux (debian)

[David Carlson]

That might be a permissions issue.   Recently I have had some problems when
GnuCash doesn't know how to gain access if it doesn't already have it in
Linux.  In my case it is a Samba problem.

On Sun, Jan 31, 2021, 7:45 PM gnu Gord <gnucashgord at gmail.com> wrote:

> 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.
> >
> _______________________________________________
> 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.
>