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

[Neko Chang]

Hi Adrien and John

Follow suggestion, I confirmed about status of SSL support @ MySQL
8.0.28 server as result below
| have_openssl                        | YES             |
| have_ssl                            | YES             |
It is enabled default even I have never configure about SSL (Msg: CA
certificate ca.pem is self signed).

Next, I tried to disable SSL support as result below
| have_openssl                        | DISABLED |
| have_ssl                            | DISABLED |
GnuCash @ MACOS work!

Summarize:
    MySQL 8.0.23 & 8.0.28 configure same, SSL enabled as default.
    In Ubuntu, MySQL 8.023 & 8.0.28 work fine.
    In MACOS, MySQL 8.023 work fine, 8.0.28 work failed.

Root cause is libdbi still I guess.
Therefore I disable SSL as workaround until issue fixed.

Thanks a lot.
Neko


Neko Chang <epopen at gmail.com> 於 2022年3月17日 週四 下午1:39寫道：
>
> All version of MySQL using  DB name = gnucash, never change.
>
> I have never setup and using SSL in MySQL.
> Remote access via SSH tunnel.
> Therefore the error message "SSL certificate issue" is strange as me
> I will try to search it.
>
> Thanks
>
>
> Adrien Monteleone <adrien.monteleone at lusfiber.net> 於 2022年3月17日 週四 下午1:09寫道：
> >
> > As John mentioned, the db name seems incorrect. Did you register the db
> > on MacOS?
> >
> > Error 2026 deals with SSL certificate issues.
> >
> > A web search should provide some guidance.
> >
> > Maybe try without SSL to see if that resolves it? Then you can
> > troubleshoot the SSL problem.
> >
> > -----
> > And again, why do you think you need MySQL? What are you trying to
> > accomplish?
> >
> > Regards,
> > Adrien
> >
> > On 3/16/22 10:40 PM, Neko Chang wrote:
> > > 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 <jralls at ceridwen.us> 於 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.
> >
> > _______________________________________________
> > 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.
>
>
>
> --
> Regards,
> Wei-Jen Chang



-- 
Regards,
Wei-Jen Chang