Re: [GNC] mysql setup in linux (debian)

[Jim DeLaHunt]

Sure! Thank you for being willing to try new things. We are glad to help 
you learn, because more hands are better.


The right direction is the link on the main GnuCash.org page, left 
column, under "Support", labelled "Bug Reports". It points to an 
introduction page, >. Give that a read.


You may find that some of the instructions there are not clear. In that 
case, you can either improve the page yourself — it is a wiki; or report 
problems in this email thread, and we'll help you along. You may help us 
find where /we/ want to improve the instructions.


Don't worry if the bug report isn't perfect. Do your best, and then 
others can come in and polish it. The main thing is to make a record 
that the problem exists.


Thank you, Gord!
 —Jim DeLaHunt

On 2021-02-02 13:27, gnu Gord wrote:

I would be happy to open a bug report but I have no idea how to do it.
Can you point me in the right direction?


On Mon, Feb 1, 2021 at 7:25 PM Jim DeLaHunt > wrote:


Good catch, Gord!

On 2021-02-01 10:36, gnu Gord wrote:
> …It appears that mysql (or somewhere in the backend of gnuCash)
does not
> like a back slash character as the last character in a field.
The data I
> was trying to save had one entry with a 'notes' field that …  was
> "2 books one for A one for\".…
>
> Here are the relevant lines from the 'gnucash.trace' file:
>
> * 09:09:43 ERROR  [error_handler()] DBI error:
1064: You
> have an error in your SQL syntax; check the manual that
corresponds to your
> MariaDB server version for the right syntax to use near '1970-01-01
> 00:00:00',0,1)' at line 1
> * 09:09:43 ERROR 
> [GncDbiSqlConnection::execute_nonselect_statement()] Error
executing SQL
> INSERT INTO
>

slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books
one for A
> one for\','1970-01-01 00:00:00',0,1)
> * 09:09:43 ERROR 
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT
INTO
>

slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books
one for A
> one for\','1970-01-01 00:00:00',0,1)
> * 09:09:43 ERROR  [GncSqlTransBackend::commit()]
> Transaction Chapters dated 2011-02-21 in account Gifts not saved
due to
> Slots save failed. Check trace log for SQL errors.

I encourage you to write a bug report in the GnuCash bug tracker
about
this problem. As a general matter, GnuCash should not let any text
you
type into a Notes field turn into a syntax error for the database. It
should wrap the Notes text in a way that prevents the syntax error
from
happening. I suspect that GnuCash does this kind of wrapping the
XML way
if the backend is XML, but doesn't do it the SQL way if the
database is SQL.

It's good to have people turn up errors with nice solid evidence like
you collected. Thanks!

Best regard,
  —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@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@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.

Re: [GNC] mysql setup in linux (debian)

[gnu Gord]

I would be happy to open a bug report but I have no idea how to do it.
Can you point me in the right direction?


On Mon, Feb 1, 2021 at 7:25 PM Jim DeLaHunt  wrote:

> Good catch, Gord!
>
> On 2021-02-01 10:36, gnu Gord wrote:
> > …It appears that mysql (or somewhere in the backend of gnuCash) does not
> > like a back slash character as the last character in a field. The data I
> > was trying to save had one entry with a 'notes' field that …  was
> > "2 books one for A one for\".…
> >
> > Here are the relevant lines from the 'gnucash.trace' file:
> >
> > * 09:09:43 ERROR  [error_handler()] DBI error: 1064: You
> > have an error in your SQL syntax; check the manual that corresponds to
> your
> > MariaDB server version for the right syntax to use near '1970-01-01
> > 00:00:00',0,1)' at line 1
> > * 09:09:43 ERROR 
> > [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> > INSERT INTO
> >
> slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> > VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
> > one for\','1970-01-01 00:00:00',0,1)
> > * 09:09:43 ERROR 
> > [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> >
> slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
> > VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
> > one for\','1970-01-01 00:00:00',0,1)
> > * 09:09:43 ERROR  [GncSqlTransBackend::commit()]
> > Transaction Chapters dated 2011-02-21 in account Gifts not saved due to
> > Slots save failed. Check trace log for SQL errors.
>
> I encourage you to write a bug report in the GnuCash bug tracker about
> this problem. As a general matter, GnuCash should not let any text you
> type into a Notes field turn into a syntax error for the database. It
> should wrap the Notes text in a way that prevents the syntax error from
> happening. I suspect that GnuCash does this kind of wrapping the XML way
> if the backend is XML, but doesn't do it the SQL way if the database is
> SQL.
>
> It's good to have people turn up errors with nice solid evidence like
> you collected. Thanks!
>
> Best regard,
>   —Jim DeLaHunt
>
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] mysql setup in linux (debian)

[Jim DeLaHunt]

Good catch, Gord!

On 2021-02-01 10:36, gnu Gord wrote:

…It appears that mysql (or somewhere in the backend of gnuCash) does not
like a back slash character as the last character in a field. The data I
was trying to save had one entry with a 'notes' field that …  was
"2 books one for A one for\".…

Here are the relevant lines from the 'gnucash.trace' file:

* 09:09:43 ERROR  [error_handler()] DBI error: 1064: You
have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '1970-01-01
00:00:00',0,1)' at line 1
* 09:09:43 ERROR 
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR 
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR  [GncSqlTransBackend::commit()]
Transaction Chapters dated 2011-02-21 in account Gifts not saved due to
Slots save failed. Check trace log for SQL errors.


I encourage you to write a bug report in the GnuCash bug tracker about 
this problem. As a general matter, GnuCash should not let any text you 
type into a Notes field turn into a syntax error for the database. It 
should wrap the Notes text in a way that prevents the syntax error from 
happening. I suspect that GnuCash does this kind of wrapping the XML way 
if the backend is XML, but doesn't do it the SQL way if the database is SQL.


It's good to have people turn up errors with nice solid evidence like 
you collected. Thanks!


Best regard,
 —Jim DeLaHunt

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] mysql setup in linux (debian)

[Stephen M. Butler]

On 2/1/21 10:36 AM, gnu Gord wrote:

Thanks to all that commented on this and thanks to the '/tmp/gnucash.trace'
file, I think I have discovered the problem.
It appears that mysql (or somewhere in the backend of gnuCash) does not
like a back slash character as the last character in a field. The data I
was trying to save had one entry with a 'notes' field that had a backslash
as the last character. The text was "2 books one for A one for\". It
appears when I save this as an XML file there is no problem but if I try to
save this as a mysql I get an error message. A backslash other than at the
end of the field does not appear to cause a problem.
BTW if I remove the backslash and successfully save to a mysql file and
then go back into the register GnuCash will not let me add a backslash to a
field. However, if I save it as an XML file the backslash is allowed.



Looks like you are on a Linux/Unix box.  The backslash is the escape 
character.  It probably ate the ending quote mark.
I think you can get the backslash by escaping it!  Yes, escape the 
escape character.  \\


--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] mysql setup in linux (debian)

[gnu Gord]

Thanks to all that commented on this and thanks to the '/tmp/gnucash.trace'
file, I think I have discovered the problem.
It appears that mysql (or somewhere in the backend of gnuCash) does not
like a back slash character as the last character in a field. The data I
was trying to save had one entry with a 'notes' field that had a backslash
as the last character. The text was "2 books one for A one for\". It
appears when I save this as an XML file there is no problem but if I try to
save this as a mysql I get an error message. A backslash other than at the
end of the field does not appear to cause a problem.
BTW if I remove the backslash and successfully save to a mysql file and
then go back into the register GnuCash will not let me add a backslash to a
field. However, if I save it as an XML file the backslash is allowed.

Here are the relevant lines from the 'gnucash.trace' file:

* 09:09:43 ERROR  [error_handler()] DBI error: 1064: You
have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '1970-01-01
00:00:00',0,1)' at line 1
* 09:09:43 ERROR 
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR 
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,timespec_val,numeric_val_num,numeric_val_denom)
VALUES('c4f3c08454534822a2ff8cbb662b44cf','notes',4,0,'2 books one for A
one for\','1970-01-01 00:00:00',0,1)
* 09:09:43 ERROR  [GncSqlTransBackend::commit()]
Transaction Chapters dated 2011-02-21 in account Gifts not saved due to
Slots save failed. Check trace log for SQL errors.


On Sun, Jan 31, 2021 at 9:14 PM Cam Ellison  wrote:

> On 2021-01-31 20:05, David Cousens wrote:
> > I don't have any experience of MySQL with GnuCash but I would try and
> > look at
> > logs for the MySQL server in  /var/log/mysql. If the problem is with
> > the
> > server rather than GnuCash itself, that may indicate it. Also check the
> > Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which
> > should
> > be in /tmp but is also located in /var/tmp on some systems.
>
> Looking in the logs will work only if logging is enabled, which in
> Debian it is not, by default. He'll have to set that.
>
> It is possible that the DB was saved correctly. 3.1M in XML is not very
> large, and I seem to recall encountering an error msg of some sort when
> I converted from XML. Using PHPMyAdmin or similar, or logging into mysql
> via CL as root should allow for determining whether the tables were
> created and loaded. Alternatively, try to load the DB as a new file.
>
> HTH
>
> Cam
>
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] mysql setup in linux (debian)

[Cam Ellison]

On 2021-01-31 20:05, David Cousens wrote:
I don't have any experience of MySQL with GnuCash but I would try and 
look at
logs for the MySQL server in  /var/log/mysql. If the problem is with 
the

server rather than GnuCash itself, that may indicate it. Also check the
Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which 
should

be in /tmp but is also located in /var/tmp on some systems.


Looking in the logs will work only if logging is enabled, which in 
Debian it is not, by default. He'll have to set that.


It is possible that the DB was saved correctly. 3.1M in XML is not very 
large, and I seem to recall encountering an error msg of some sort when 
I converted from XML. Using PHPMyAdmin or similar, or logging into mysql 
via CL as root should allow for determining whether the tables were 
created and loaded. Alternatively, try to load the DB as a new file.


HTH

Cam

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] mysql setup in linux (debian)

[David Cousens]

I don't have any experience of MySQL with GnuCash but I would try and look at
logs for the MySQL server in  /var/log/mysql. If the problem is with the
server rather than GnuCash itself, that may indicate it. Also check the
Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which should
be in /tmp but is also located in /var/tmp on some systems.

Also see
https://www.sumologic.com/blog/mysql-log-file-location/#:~:text=Platform%2DSpecific%20UNIX%2FLinux,-The%20official%20distributions&text=log%20or%20mysqld.,%2Fetc%2Fmysql%2Fmysql.
for MySQL logging

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [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  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 
> 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@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@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@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.

Re: [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 
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@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@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.

Re: [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
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] mysql setup in linux (debian)

[gnu Gord]

 Thanks for the reply.
When I go to 'save as' the Data Format drop-down only has XML as an option,
unlike my Windows version that has Mysql and others.
I installed the Linux version using apt so I did not build it myself.
Perhaps the official package was built without this support? If so, would I
need to build from the source code to get the MySQL option?


On Sun, Jan 31, 2021 at 3:50 PM David Cousens 
wrote:

> If you select File-Saves As from the menu, you should see a drop down box
> labelled Data Format at the top of the dialog window. "xml" is selected by
> default.Click on the down arrow and select the format you wish to use.
>
> GnuCash is normally built by default with the support for the various
> database options. You would have had to use an explicit switch to turn it
> off during the build if you built GNuCash yourself.
>
> http://www.howtodoityourself.org/set-mysql-gnucash-backend.html  This may
> help with the general setup even though a bit dated. Note "$apt install
> libdbd-mysql"  is a support library which is not necessarily present during
> the build of GNuCash and may need to be explicitly installed
>
> To setup the MYSQL server on Linux a google search should give you a
> procedure appropriate for your OS.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: [GNC] mysql setup in linux (debian)

[David Cousens]

If you select File-Saves As from the menu, you should see a drop down box
labelled Data Format at the top of the dialog window. "xml" is selected by
default.Click on the down arrow and select the format you wish to use. 

GnuCash is normally built by default with the support for the various
database options. You would have had to use an explicit switch to turn it
off during the build if you built GNuCash yourself.

http://www.howtodoityourself.org/set-mysql-gnucash-backend.html  This may
help with the general setup even though a bit dated. Note "$apt install
libdbd-mysql"  is a support library which is not necessarily present during
the build of GNuCash and may need to be explicitly installed

To setup the MYSQL server on Linux a google search should give you a
procedure appropriate for your OS.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] mysql setup in linux (debian)

[Michael via gnucash-user]

I believe the first thing to check is libdbi, is it installed?  Mike

On Sun, 2021-01-31 at 14:56 -0800, gnu Gord wrote:
> Having some problems with mysql setup for linux.
> 
> I got the Windows version to work but don't seem to have the option
> to
> "save as" mysql in my linux version.
> Are there some instructions somewhere that talk about using/setting
> up
> mysql in linux?
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

[GNC] mysql setup in linux (debian)

[gnu Gord]

Having some problems with mysql setup for linux.

I got the Windows version to work but don't seem to have the option to
"save as" mysql in my linux version.
Are there some instructions somewhere that talk about using/setting up
mysql in linux?
___
gnucash-user mailing list
gnucash-user@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.