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 guess. The issue would not be resolve. I forgot GNUCASH @ MACOS, using GNUCASH @ Ubuntu continue. Regards Neko john <[email protected]> 於 2022年3月17日 週四 上午11:13寫道： > > 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 administrators for the respective servers. The GnuCash team > most emphatically are not and cannot provide any support for database server > problems. If you are not a MySQL expert then you should use the SQLite3 or > XML backends which don't require DB Admin skills. > > Regards > John Ralls > > > > On Mar 16, 2022, at 6:31 PM, Neko Chang <[email protected]> wrote: > > > > 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 8.0.28, Gnucash @ Ubuntu 20 work fine, but > >> MACOS 12 won't. > >> > >> Log as below, generate by > >> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug --extra > >> --logto stdout > >> * 21:32:54 INFO <qof.session> [QofSessionImpl::load_backend] The > >> provider providers access_method, file, but we're loading for > >> access_method, mysql. Skipping. > >> * 21:32:54 INFO <qof.session> [QofSessionImpl::load_backend] The > >> provider providers access_method, sqlite3, but we're loading for > >> access_method, mysql. Skipping. > >> * 21:32:54 INFO <qof.session> [QofSessionImpl::load_backend] > >> Selected provider GnuCash Libdbi (MYSQL) Backend > >> * 21:32:54 INFO <gnc.backend.dbi> [error_handler] DBI error: -5: > >> An invalid name was passed to libdbi > >> * 21:32:54 INFO <gnc.backend.dbi> [error_handler] Note: > >> GbcDbiSqlConnection not yet initialized. Skipping further error > >> processing. > >> * 21:32:54 INFO <gnc.backend.dbi> [error_handler] DBI error: 2026: > >> SSL connection error: unknown error number > >> * 21:32:54 INFO <gnc.backend.dbi> [error_handler] Note: > >> GbcDbiSqlConnection not yet initialized. Skipping further error > >> processing. > >> * 21:32:54 ERROR <gnc.backend.dbi> > >> [GncDbiBackend<DbType::DBI_MYSQL>::session_begin()] Unable to connect > >> to database 'gnucash' > >> * 21:32:54 INFO <qof.session> [QofSessionImpl::begin] Done running > >> session_begin on backend > >> > >> Root cause version of libdbi maybe I guess. > >> Package in Ubuntu 20 = 1.9.0 > >> Bundle in Gnucash = 1.8.? (by Google) > >> > >> Using package version of libdbi in MACOS possible? > >> Or work-around/solution/fix at next version? > >> > >> Thanks very much. > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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. > -- Regards, Wei-Jen Chang _______________________________________________ gnucash-user mailing list [email protected] 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.
