On 12/27/22 13:12, Aaron Axelsen wrote:
Output from a command line connection:
mysql -h secure-mysql-db.example.com -p -u mysqluser mail --ssl
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 970955
Server version: 8.0.26 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MySQL [mail]> \s
--------------
mysql Ver 15.1 Distrib 10.5.18-MariaDB, for debian-linux-gnu (x86_64)
using EditLine wrapper
Connection id: 970955
Current database: mail
Current user: postfix-ro@192.168.0.143
SSL: Cipher in use is ECDHE-RSA-AES256-GCM-SHA384
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MySQL
Server version: 8.0.26 MySQL Community Server - GPL
Protocol version: 10
Connection: secure-mysql-db.example.com via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb3
Conn. characterset: utf8mb3
TCP port: 3306
Uptime: 34 days 9 hours 39 min 51 sec
Well it looks to me as though you have the server side all set up
correctly, at least.
BTW, if memory serves, 8.x beyond some fairly low minor version (8.0.8
maybe?) will also listen on port 13306, and automatically ASSUME you
want SSL on all connections to 13306. I don't know whether that helps you.
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
