Hi Terry, Yes, there are compatibility issues with newer versions of mysql/mariadb clients and the old version of mysql the server uses, which is why the installation spec says to use an older version of python-mysqlclient, amongst other things.
I'm surprised the users I created aren't showing up there, but I can't take a look for myself as the VPN isn't working at my end. Hamish On 6 July 2023 13:53:25 BST, Terry Coles <d-...@hadrian-way.co.uk> wrote: >On 06/07/2023 12:45, Ralph Corderoy wrote: >> This means the TCP port on the NAS's network interface has nothing >> listening to it to accept your incoming connection request. This may be >> because the MySQL server isn't configured to listen on the network >> interface, or it is listening on that interface but on another >> non-standard TCP port. >> >> Does any existing software talk to the MySQL server on that machine from >> outside of that machine? >All of the Pis talk to the MySQL server through Hamish's framework. >> ... >>> ERROR 1043 (08S01): Bad handshake >> Is that using the mysql(1) program from a shell? Or some other MySQL >> client? > >The MySQL client that I installed from Kubuntu's repository: > >terry@OptiPlex:~/Useful$ mysql -V >mysql Ver 8.0.33-0ubuntu0.23.04.2 for Linux on x86_64 ((Ubuntu)) > >It is much newer than the server ( > >>> I can log in to the D-Link and thence to the PHPMyAdmin App with these >>> credentials through a browser. >> From there you can probably examine the configured users and perhaps the >> server's configuration. > >That's what I thought, but all I can see is that SSH is enabled for the D-Link >itself, but only for admin. For the MySQL Server, I can only see a list of >users under the "Privileges" tab. There appears to be only four; admin, >backupuser, pma and root. Additionally, there is a record for user and another >for password, but both appear to be empty. > >I can see no evidence of the credentials set up by Hamish for access from the >Pis and from the engineering GUI running on the NAS Box. > >-- >Terry Coles > > >-- > Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 > Check to whom you are replying > Meetings, mailing list, IRC, ... http://dorset.lug.org.uk > New thread, don't hijack: mailto:dorset@mailman.lug.org.uk -- Next meeting: Online, Jitsi, Tuesday, 2023-08-01 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
