https://bugs.gnucash.org/show_bug.cgi?id=798992 Reports that after upgrading to
MariaDB 11 on their servers, two Windows users are unable to work with their
GnuCash databases. GnuCash appears to connect but DBI thinks that numeric
variables are strings and, since it's expecting numbers,
Hi Adrien and John
Follow suggestion, I confirmed about status of SSL support @ MySQL
8.0.28 server as result below
| have_openssl| YES |
| have_ssl| YES |
It is enabled default even I have never configure about SSL (Msg:
All version of MySQL using DB name = gnucash, never change.
I have never setup and using SSL in MySQL.
Remote access via SSH tunnel.
Therefore the error message "SSL certificate issue" is strange as me
I will try to search it.
Thanks
Adrien Monteleone 於 2022年3月17日 週四 下午1:09寫道：
>
> As John
As John mentioned, the db name seems incorrect. Did you register the db
on MacOS?
Error 2026 deals with SSL certificate issues.
A web search should provide some guidance.
Maybe try without SSL to see if that resolves it? Then you can
troubleshoot the SSL problem.
-
And again, why do
Thank you for the clarification.
Hi Adrien
I am using MySQL @ FreeBSD remote mainly,
MySQL @ MACOS for the issue tested.
GNUCASH @ MACOS work fine both MySQL v8.0.23.
Hi Josh
Either MySQL v8.0.23 or v8.0.28, all parameter
same(user/password/database name).
Therefore issue caused from libdbi I
Neko,
AFAiCT this has nothing to do with macOS but rather that your MySQL server
doesn't recognize the database name you passed it plus another error, number
2026, that GnuCash doesn't know how to handle.
As a reminder, users using the MySQL or Postgresql backends *must* be *expert*
database
You have to install MySQL/MariaDB on MacOS separately as far as I
recall. (then save the file in that backend format)
But before you go through all of that trouble, what advantages do you
think you will gain by using the MySQL backend vs. XML or SQLite?
Regards,
Adrien
On 3/16/22 8:31 PM,
Hi All
I have no idea how to run on MACOS still.
Can help/information for it?
Thanks a lot
>
> Hi gnucash-user
>
> I had been encounter as subject, can help to resolve?
>
> Detail:
> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
> @ MySQL 8.0.23
> After MySQL upgrade to
Hi All
I have no idea how to run on MACOS still.
Can help/information for it?
Thanks a lot
Neko Chang 於 2022年2月17日 週四 下午2:16寫道：
>
> Hi gnucash-user
>
> I had been encounter as subject, can help to resolve?
>
> Detail:
> I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
> @
server.
David T.
Original Message
From: davidcousen...@gmail.com
Sent: Sun Mar 13 18:28:45 EDT 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] MySQL
Henrik,
I doubt if the reliability problem you are experiencing is intrinsically in
GnuCash itself although it may
Henrik,
I doubt if the reliability problem you are experiencing is intrinsically in
GnuCash itself although it may be associated with the library used to connect to
MMySQL.
GnuCash is not designed for multiple access in particular, i.e. multiple users
cannot simultaneously access the same data
Henrik,
The GnuCash program alone is very stable and reliable. It can work with
local data files directly or remote data files using third party or network
software. Whatever reliability issue you are having is most likely an
external one.
It is not required to use the mysql database format to
Hi,
I'm new to GnuCash but really wanted it to save to MySQL so I could easily access it form
different locations. It seems extremely un-reliable though, is this expected? Half the
time is just hangs and says "The server experienced and error..." even though I
can connect and log in
Hi gnucash-user
I had been encounter as subject, can help to resolve?
Detail:
I have both Gnucash v4.9 in MACOS 12 and Ubuntu 20 and both work fine
@ MySQL 8.0.23
After MySQL upgrade to 8.0.28, Gnucash @ Ubuntu 20 work fine, but
MACOS 12 won't.
Log as below, generate by
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,
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)
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
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
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
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 (
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
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
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
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
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
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
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
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?
___
Having problems
Server setup in AWS
When 'save as' the Local host Version into the AWS endpoint Msgbox becomes
non responsive and eventually crashes GnuCash
The tables in cloud db are setup but I can excess any data.
And I can open the cloud db in the Gnucash UI but no accounts (as expected)
Okay. I didn't realize you are just creating a label.
Ignore my comment.
Will
On 2020 Aug 18, at 08-18 22:21:20, John Ralls wrote:
In the alias there *should* be a space in 'local host' to keep the OS from
mistaking it for the hardcoded 'localhost' in the networking code.
Regards,
John
Yes, you are correct. Siri did that.
Regards
On Tue, Aug 18, 2020 at 11:27 PM John Ralls wrote:
> In the alias there *should* be a space in 'local host' to keep the OS from
> mistaking it for the hardcoded 'localhost' in the networking code.
>
>
>
> Regards,
>
> John Ralls
>
>
>
> > On Aug 18,
In the alias there *should* be a space in 'local host' to keep the OS from
mistaking it for the hardcoded 'localhost' in the networking code.
Regards,
John Ralls
> On Aug 18, 2020, at 5:29 PM, w...@theprescotts.com wrote:
>
> Probably should not be a space in "localhost".
>
> Will
>
> On
Probably should not be a space in "localhost".
Will
On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice wrote:
You can set up the MySQL to point to 127.0.0.1 and the alias “local host”
On Tue, Aug 18, 2020 at 4:31 PM andy ngo wrote:
> Thank you for your help.
>
> I don't remember using
You can set up the MySQL to point to 127.0.0.1 and the alias “local host”
On Tue, Aug 18, 2020 at 4:31 PM andy ngo wrote:
> Thank you for your help.
>
> I don't remember using Flatpak back then (too long ago, couldn't remember
>
> exactly).
>
> However, the problem is solved with Geert's
Thank you very much for your help.
The problem is solved with Geert's suggestion to change from localhost to
127.0.0.1
Cheers
Andy
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
Thank you for your help.
I don't remember using Flatpak back then (too long ago, couldn't remember
exactly).
However, the problem is solved with Geert's suggestion to change "localhost"
to 127.0.0.1
Cheers
andy
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
Hi Geert:
Yes, it works after I changed from "localhost" to "127.0.0.1"
Thank you very much
Andy
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your
Can you open any MySQL database? Need to find out if it's mysql
installation or a connection issue.
On 8/17/2020 1:11 PM, andy ngo wrote:
Hi there:
Up to now, I've been used
Gnucash 3.2
in Ubuntu 18.04
with mysql 5.7.31
My old laptop is now too old and needs to retire.
So I bought a new one
Op maandag 17 augustus 2020 19:11:13 CEST schreef andy ngo:
> Hi there:
> Up to now, I've been used
> Gnucash 3.2
> in Ubuntu 18.04
> with mysql 5.7.31
>
> My old laptop is now too old and needs to retire.
> So I bought a new one and install Gnucash, mysql ...
>
> Gnucash 4.1
> Build ID: Flathub
You were using the 3.2 Flatpak and it worked?
I'd suspect something with the Flatpak sandbox would be interfering.
Note, if you had to seek help on the list in 2018, you could search the
list archives for that time period via your favorite search engine.
prepend your search terms with:
Hi there:
Up to now, I've been used
Gnucash 3.2
in Ubuntu 18.04
with mysql 5.7.31
My old laptop is now too old and needs to retire.
So I bought a new one and install Gnucash, mysql ...
Gnucash 4.1
Build ID: Flathub 4.1-2
Finance::Quote: 1.49
in Ubuntu 20.04
with mysql 8.0.21
Now, I can't
Have you checked you can access the server using the same credentials,
with a different mysql client?
Colin
On Fri, 29 Nov 2019 at 18:51, wrote:
>
> Hi
>
>
>
> I used to be able to save my Gnucash file as MySQL but recently got a new
> laptop and I now get a message "the server at URL
Sent: 29 November 2019 19:55
To: gnucash-user@gnucash.org
Cc: m...@mgillis.uk
Subject: Re: [GNC] MySQL
Hi,
There was a change in the format for storing dates in MySQL. I don't know
the exact details but it may well be the source of your problem.
I'm pretty sure gnucash 2.6.19 doesn't have (all
Hi,
There was a change in the format for storing dates in MySQL. I don't know the
exact details but it may well be the source of your problem.
I'm pretty sure gnucash 2.6.19 doesn't have (all of) the patches required to
work with this new format. You could try to upgrade to gnucash 2.6.21, the
Hi
I used to be able to save my Gnucash file as MySQL but recently got a new
laptop and I now get a message "the server at URL nysql://etc/etc
experienced an error or encountered bad or corrupt data". The data can be
stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and I've
> On Mar 7, 2019, at 7:39 AM, Jean-David Beyer via gnucash-user
> wrote:
>
> On 3/7/19 7:22 AM, David G Hamblen wrote:
>> In the past, I've had problems with a mysql file, just getting
>> seqfaults. Turned out that I was entering a transaction with a 1962
>> date. I forget the details, but
On 3/7/19 7:22 AM, David G Hamblen wrote:
> In the past, I've had problems with a mysql file, just getting
> seqfaults. Turned out that I was entering a transaction with a 1962
> date. I forget the details, but mysql stored it as a zero, which I
> couldn't reopen. I changed the date (to
In the past, I've had problems with a mysql file, just getting
seqfaults. Turned out that I was entering a transaction with a 1962
date. I forget the details, but mysql stored it as a zero, which I
couldn't reopen. I changed the date (to post-1970?) with the mysql
command line tool.
On Wed, 6 Mar 2019 at 21:44, Keith Bellairs wrote:
>
> Yes I can connect using the mysql command line tool. No, the gnucash db has
> not been created.
>
> But I cannot use the mysqlworkbench shell. It complains about a missing
> connector (python?)
>
> Also, gnc get the "bad data" error even if
Yes I can connect using the mysql command line tool. No, the gnucash db has
not been created.
But I cannot use the mysqlworkbench shell. It complains about a missing
connector (python?)
Also, gnc get the "bad data" error even if I try to "save as" with a bad
password, no password, or no user id.
On Wed, 6 Mar 2019 at 19:09, Keith Bellairs wrote:
>
> gnucash.trace is empty.
>
> Of some interest, I did a Save As to sqlite and it worked. So the xml data is
> acceptable to that DB.
>
> XML -> sqlite OK
> XML -> mysql NG
> sqlite -> mysql NG
>
> I tried to do a Save As from the sqlite db to
gnucash.trace is empty.
Of some interest, I did a Save As to sqlite and it worked. So the xml data
is acceptable to that DB.
XML -> sqlite OK
XML -> mysql NG
sqlite -> mysql NG
I tried to do a Save As from the sqlite db to MySQL. That Save As ground
away for a few minutes and then threw the
On Wed, 6 Mar 2019 at 15:36, Keith Bellairs wrote:
>
> Yes, the Save As selection is not grayed out. So I assumed the drivers were
> in the Mac package.
>
> My MySQL instance is up and running.
>
> But I get a gnc error when I try to do the Save As.
>
Have a look in the gnucash trace file to see
Thanks for clarifying.
I'm probably also mixing some of this in with the whole Python on Macs issue.
David
On Wed, Mar 6, 2019 at 10:11, John Ralls
wrote: David,
For 2.6 yes. For 3.x everything is in the bundle for all three database
backends just like Windows.
Regards,
John Ralls
David,
For 2.6 yes. For 3.x everything is in the bundle for all three database
backends just like Windows.
Regards,
John Ralls
> On Mar 5, 2019, at 6:12 PM, David T. wrote:
>
> John, for MySQL, don't Mac users have to build Gnucash with the appropriate
> libdbd-mysql dependency added in?
John, for MySQL, don't Mac users have to build Gnucash with the appropriate
libdbd-mysql dependency added in? ISTR at some point that we needed to build
gnucash ourselves to add this functionality. Or am I misremembering?
David T.
On Wed, Mar 6, 2019 at 3:50, John Ralls wrote:
> On
> On Mar 5, 2019, at 12:56 PM, Keith Bellairs wrote:
>
> For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
> my xml file exportable to mysql? If so, is there a writeup? I tried a
> couple of obvious things (save as, make myself a dba, create Gnucash schema
> in mysql)
Keith,
See the following links for setup on MacOSX with MySQL
https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html
https://wiki.gnucash.org/wiki/MacOS_Installation
https://lists.gnucash.org/pipermail/gnucash-user/2011-February/038511.html
For other reasons I added MySQL to my Mac OS X and I am using GNC 3.4. Is
my xml file exportable to mysql? If so, is there a writeup? I tried a
couple of obvious things (save as, make myself a dba, create Gnucash schema
in mysql) and made no progress.
Keith
You can set a port number when saving to DB. If not set, GnuCash will use the
default. There is no separate field for it, but I believe you can use a
"host:port" format in the hostname field.
If you prefer to keep the non-default port number for your mysql server, you
can reopen your db in
I expect that gnucash assumes you are using the default mysql port.
Colin
On Mon, 19 Nov 2018, 03:31 Peter Holck Thanks again for your help; I think I understand my problem now.
>
> GnuCash (reasonably) looks for an instance of MySQL using the same port
> that it used when closed (or when
Thanks again for your help; I think I understand my problem now.
GnuCash (reasonably) looks for an instance of MySQL using the same port
that it used when closed (or when created? Not sure). Anyway, I had
assigned a different port number to my new version of MySQL (since I wanted
to keep both
On Sat, 17 Nov 2018 at 22:52, Peter Holck wrote:
>
> * 15:25:47 CRIT [GncDbiBackend::session_begin()]
> Unable to connect to database 'gnucash'
Please copy the list on replies, you sent this one just to me. On
gmail use Reply All when replying.
Are you able to connect to the server using
Check credentials in MySQL. Specifically permissions for Root@Localhost
On Sat, Nov 17, 2018 at 5:38 PM Colin Law wrote:
> On Sat, 17 Nov 2018 at 22:31, Peter Holck wrote:
> >
> > Thanks for your suggestion. No, with only my new instance of MySQL
> running (8.13 running, 5.6 stopped) when I
On Sat, 17 Nov 2018 at 22:31, Peter Holck wrote:
>
> Thanks for your suggestion. No, with only my new instance of MySQL running
> (8.13 running, 5.6 stopped) when I use the GnuCash API to create a new shell
> database (shelldb) and try to save as mysql, I get the same error: "The
> server at
Thanks for your suggestion. No, with only my new instance of MySQL running
(8.13 running, 5.6 stopped) when I use the GnuCash API to create a new
shell database (shelldb) and try to save as mysql, I get the same error:
"The server at URL mysql://root@localhost/shelldb experienced an error or
Are you able to Save As mysql with the new server?
Also have a look in the trace file and see what it says, often it will
give more information in the case of db problems.
Colin
On Sat, 17 Nov 2018 at 22:07, Peter Holck wrote:
>
> I recently installed an updated version of MySQL Server (8.13) on
I recently installed an updated version of MySQL Server (8.13) on my
machine. I have an established GnuCash database under an instance of MySQL
5.6. I copied all GnCash db/tables from that older version of MySQL to an
identically named database/tables in MySQL 8.13.
How do I get the GnuCash API
That may work fine for a single instance of gnucash. However, it this is 2
instances of gnucash on 2 separate computers, does libdbi provide any
notification mechanism to notify gnucash on computer #2 that computer #1
has written to the db?
On Mon, Nov 5, 2018 at 2:39 AM craigarno wrote:
>
Geert Janssens-4 wrote
> Op zondag 4 november 2018 14:49:22 CET schreef craigarno:
>> Geert Janssens-4 wrote
>>
> Whether it can work depends on
> whether the db layer we rely on has a notification mechanism for db
> changes we
> can hook into. The current db layer is provided by libdbi, which
Geert Janssens-4 wrote
> Op zondag 4 november 2018 04:36:30 CET schreef craigarno:
> The only part I have no idea about at this stage is how to tell all views
> to refresh when one user makes a change.
If you are headed toward C++, the "Observer" Design Pattern may be able to
get the "refresh
Op zondag 4 november 2018 04:36:30 CET schreef craigarno:
> My application is similar, except two of my users will be outside of my
> local network, working from the Internet. I'm a tiny one man SOHO
> operation who is off-site a lot of the time and may also be accessing my
> GnuCash database
My application is similar, except two of my users will be outside of my local
network, working from the Internet. I'm a tiny one man SOHO operation who
is off-site a lot of the time and may also be accessing my GnuCash database
remotely and concurrently from a job site providing client
On Sat, 2018-10-20 at 14:39 -0400, Charles Gagnon wrote:
>
> My question is around online transactions. After importing, I would
> typically spend some time in the window assigning the right accounts to the
> transactions. This process is now terribly slow with the cloud DB so I'm
> assuming it
I wanted to share something quickly and ask a question at the same time.
I've been using gnucash since ~ 2001-2002 for my personal finances. I was
"closing" and starting fresh every year until 2006 at which point I just
started accumulated into the same file. So I currently have data in a
single
Gnucash will put a lock on the database as long as it's in use by one user. If
a second user tries to open it that user will be presented with a warning tje
db is still in use by ssomeone else. So you can't accidentally be working on an
open db with two users at once. If you ignore the warning
I'd like to understand if gnucash + mysql supports avoiding simultaneous
editors (e.g., via locks).
In more detail:
I want to keep accounts for a small organisation in which we've decided
several people should have access to the books for transparency and
distribution of work. One possibility
77 matches
Mail list logo
