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

[Adrien Monteleone]

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, Neko Chang 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?