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 <[email protected]> 於 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 <[email protected]> 於 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 <[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.
> >
> > _______________________________________________
> > 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
--
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.
