Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?
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 gnucash using File->Open and set the proper db hostname and port. GnuCash should remember your settings for the next time. Geert Op maandag 19 november 2018 08:32:33 CET schreef Colin Law: > 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 created? Not sure). Anyway, I had > > assigned a different port number to my new version of MySQL (since I > > wanted > > to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least > > until > > I confirmed the new version was working correctly). Swapping the port > > numbers so the new 8.0 version used the old 5.6 port and vice versa (via > > editing the my.ini config file) seems to have done the trick. > > > > Thanks! > > > > On Sun, Nov 18, 2018 at 1:21 AM Colin Law wrote: > >> 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 the command line client > >> mysql -u username -p > >> and it will prompt for the password. > >> > >> If that connects then > >> show databases; > >> will show the databases (oddly enough). Then you can exit with > >> exit; > >> > >> Colin > > ___ > 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 version update: GnuCash API recognize new MySQL database & tables?
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 created? Not sure). Anyway, I had > assigned a different port number to my new version of MySQL (since I wanted > to keep both MySQL 5.6 and MySQL 8.0 installed on my machine at least until > I confirmed the new version was working correctly). Swapping the port > numbers so the new 8.0 version used the old 5.6 port and vice versa (via > editing the my.ini config file) seems to have done the trick. > > Thanks! > > On Sun, Nov 18, 2018 at 1:21 AM Colin Law wrote: > >> 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 the command line client >> mysql -u username -p >> and it will prompt for the password. >> >> If that connects then >> show databases; >> will show the databases (oddly enough). Then you can exit with >> exit; >> >> Colin >> > ___ 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 version update: GnuCash API recognize new MySQL database & tables?
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 MySQL 5.6 and MySQL 8.0 installed on my machine at least until I confirmed the new version was working correctly). Swapping the port numbers so the new 8.0 version used the old 5.6 port and vice versa (via editing the my.ini config file) seems to have done the trick. Thanks! On Sun, Nov 18, 2018 at 1:21 AM Colin Law wrote: > 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 the command line client > mysql -u username -p > and it will prompt for the password. > > If that connects then > show databases; > will show the databases (oddly enough). Then you can exit with > exit; > > Colin > ___ 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 version update: GnuCash API recognize new MySQL database & tables?
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 the command line client mysql -u username -p and it will prompt for the password. If that connects then show databases; will show the databases (oddly enough). Then you can exit with exit; Colin ___ 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 version update: GnuCash API recognize new MySQL database & tables?
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 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 encountered bad or corrupt data". It seems to me the GnuCash API > is looking for an instance of my old version of MySQL (5.6) and if it's not > running, then it fails. > > You haven't told us what you found when you looked in the trace file. > > Colin > > > > > On Sat, Nov 17, 2018 at 3:20 PM Colin Law wrote: > >> > >> 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 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 to connect to my new instance of MySQL > (8.13) > >> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 > running, > >> > and then attempt to start GnuCash it asks for username and password > (also > >> > identical for the two different MySQL versions) but then gives the > standard > >> > error that the server encountered bad or corrupt data. > >> > > >> > Thanks in advance. > >> > ___ > >> > 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 version update: GnuCash API recognize new MySQL database & tables?
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 URL mysql://root@localhost/shelldb experienced an error or > encountered bad or corrupt data". It seems to me the GnuCash API is looking > for an instance of my old version of MySQL (5.6) and if it's not running, > then it fails. You haven't told us what you found when you looked in the trace file. Colin > > On Sat, Nov 17, 2018 at 3:20 PM Colin Law wrote: >> >> 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 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 to connect to my new instance of MySQL (8.13) >> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running, >> > and then attempt to start GnuCash it asks for username and password (also >> > identical for the two different MySQL versions) but then gives the standard >> > error that the server encountered bad or corrupt data. >> > >> > Thanks in advance. >> > ___ >> > 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 version update: GnuCash API recognize new MySQL database & tables?
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 encountered bad or corrupt data". It seems to me the GnuCash API is looking for an instance of my old version of MySQL (5.6) and if it's not running, then it fails. On Sat, Nov 17, 2018 at 3:20 PM Colin Law wrote: > 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 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 to connect to my new instance of MySQL > (8.13) > > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 > running, > > and then attempt to start GnuCash it asks for username and password (also > > identical for the two different MySQL versions) but then gives the > standard > > error that the server encountered bad or corrupt data. > > > > Thanks in advance. > > ___ > > 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 version update: GnuCash API recognize new MySQL database & tables?
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 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 to connect to my new instance of MySQL (8.13) > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running, > and then attempt to start GnuCash it asks for username and password (also > identical for the two different MySQL versions) but then gives the standard > error that the server encountered bad or corrupt data. > > Thanks in advance. > ___ > 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 version update: GnuCash API recognize new MySQL database & tables?
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 to connect to my new instance of MySQL (8.13) ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running, and then attempt to start GnuCash it asks for username and password (also identical for the two different MySQL versions) but then gives the standard error that the server encountered bad or corrupt data. Thanks in advance. ___ 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.