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
