I have a working system with Postfix 3.5.17+debian11u1 and MariaDB
10.5. After adding ssl certificates and configurations it stopped
authenticating. I don't know if it is Postfix or MariaDB. Using ngrep
to monitor the stream, I can see initial encrypted traffic followed by
clear text. It appears to be authentication:
1 T 192.168.9.10:3306 -> 63.221.51.43:49694 [AP] #30
2 c...
3 5.5.5-10.5.15-MariaDB-0+deb11u1.
...?zj%s;h{...-...............TpV=o8g~dZwi.mysql_native_password.
4 ##
5 T 63.221.51.43:49694 -> 192.168.9.10:3306 [AP] #32
6 ...........@-.......................vmail...V..R
...JZ.X4]....Ivmail.mysql_native_password.j._os.Linux._client_name
7
libmariadb._pid.68607._client_version.3.1.18._platform.x86_64._server_host.sqlhost
8 ##
9 T 192.168.9.10:3306 -> 63.221.51.43:49694 [AP] #34
10 G......#28000Access denied for user 'vmail'@'mymail' (using
password: YES)
11 #######
12 T 192.168.9.10:3306 -> 63.221.51.43:49706 [AP] #41
13 c...
14
5.5.5-10.5.15-MariaDB-0+deb11u1.!...*1XIDXnA...-...............9;Y/!R[UunGV.mysql_native_password.
15 ##
16 T 63.221.51.43:49706 -> 192.168.9.10:3306 [AP] #43
17
...........@-.......................vmail.......?~..a.$.H.y....vmail.mysql_native_password.j._os.Linux._client_name
18
libmariadb._pid.68607._client_version.3.1.18._platform.x86_64._server_host.sqlhost
19 ##
20 T 192.168.9.10:3306 -> 63.221.51.43:49706 [AP] #45
21 G......#28000Access denied for user 'vmail'@'mymail' (using
password: YES)
To be clear, disabling ssl between MariaDB client (Postfix server) and
MariaDB server makes it work but all is clear text, of course.
Looking for clues.
Regards,
David Koski
dko...@sutinen.com
