search

petlof / liveresults

EmmaClient is a client-server system for publishing liveresults from Orienteering events. It have been used on many major events such as JWOC, WOC, EOC,..
http://liveresultat.orientering.se
GNU Lesser General Public License v3.0
40 stars 24 forks source link

Error starting client with MySQL 8.0.29 and OLA 6.3.4 #56

Closed arnesor closed 2 years ago

arnesor commented 2 years ago

I have a fresh install of MySQL 8.0.29 and OLA 6.3.4. OLA-Server is configured to use MySQL as a database and I have registered one simple competition. When I try to start Liveresults Client 2022-04-22, I get the following error when I click on the OLA SOFT button, select MySQL-Server, and enter the information for it (running on localhost): "Authentication method caching_sha2_password not supported by any of the available plugins".

I have tried to reconfigure MySQL (my.ini) by changing authentication policy to: authentication_policy=mysql_native_password,, and running the following command ALTER USER "root"@"localhost" IDENTIFIED WITH mysql_native_password BY "password"; as suggested by googling.

But then I get a lot of "Objektreferanse er ikke satt til en objektforekomst" errors instead. Bottom line: I'm unable to use LiveResult Client to report live results from the newest versions of OLA and MySQL.

petlof commented 2 years ago

Hi, this should be fixed with the latest version now