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