[GNC] MySQL back-end access failed @ MACOS 12 after MySQL server upgrade to 8.0.28

[john]

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 <epopen at gmail.com> 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
> gnucash-user at 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.