Unable to access 4.15.1 installation as admin

Password resets give me this error:

Error: SMTP Error: Could not connect to SMTP host. Connection failed. stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failedPossible reason: your host may have disabled the mail() function.
Please contact your Matomo administrator.

php.ini’s disable_functions does not include mail
I purged and reinstalled postfix (and its sendmail).
I successfully tested the reinstalled postfix using both mailx and sendmail,
and saw my tests immediately come through.

attempts to run this:

UPDATE matomo_user SET password = md5(‘my_new_admin_password’) WHERE login = ‘admin’;

gives me no joy.

Any thoughts on how to resolve this?

– Hugh

Hi @hesco
Can you check:

Thank you @Philippe.

I run a postfix server on this container.
Do I need to open some other port to accept traffic wrapped in an encrypted connection?
Do I need install an ssl certificate on my mail server?
Is there some way for me to easily disable this unnecessary ssl encryption on this localhost connection?
What is this error trying to tell me here, please?

# grep ^.mail -A4 config/config.ini.php 
[mail]
transport = "smtp"
port = "25"
host = "127.0.0.1"
# ./console core:test-email hesco@our_domain.com 
2023-09-26 14:29:19     SERVER -> CLIENT: 220 localhost ESMTP Postfix (Ubuntu)
2023-09-26 14:29:19     CLIENT -> SERVER: EHLO localhost.localdomain
2023-09-26 14:29:19     SERVER -> CLIENT: 250-localhost
                                          250-PIPELINING
                                          250-SIZE 10240000
                                          250-VRFY
                                          250-ETRN
                                          250-STARTTLS
                                          250-ENHANCEDSTATUSCODES
                                          250-8BITMIME
                                          250-DSN
                                          250-SMTPUTF8
                                          250 CHUNKING
2023-09-26 14:29:19     CLIENT -> SERVER: STARTTLS
2023-09-26 14:29:19     SERVER -> CLIENT: 220 2.0.0 Ready to start TLS
2023-09-26 14:29:19     SMTP Error: Could not connect to SMTP host. Connection failed. stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages:
                                          error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed
2023-09-26 14:29:19     CLIENT -> SERVER: QUIT
2023-09-26 14:29:19     SERVER -> CLIENT: ZhrHJ-;MBѩ8<RXP6T )phI-Vzt)Nmˬ>"+?KhnYI:P~}HOi?x
                                                                                          5RE1*wN zBg--i
                                                                                                        5BOl,8"Y4%K~4ޭ!dad8\G?   y
                                                                                                                                 9Ker,^
                                          cRy}EgF۸9bEyqFz-fU/p2&$YJ!s3m%s#O55vGp9
2023-09-26 14:29:19     SMTP ERROR: QUIT command failed: ZhrHJ-;MBѩ8<RXP6T )phI-Vzt)Nmˬ>"+?KhnYI:P~}HOi?x
                                                                                                         5RE1*wN zBg--i
                                                                                                                       5BOl,8"Y4%K~4ޭ!dad8\G?    y
                                                                                                                                                 9Ker,^
                                          cRy}EgF۸9bEyqFz-fU/p2&$YJ!s3m%s#O55vGp9
2023-09-26 14:29:19     SMTP Error: Could not connect to SMTP host. Connection failed. stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages:
                                          error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed
ERROR [2023-09-26 14:29:19] 30435  Uncaught exception: /var/www/html/matomo/vendor/phpmailer/phpmailer/src/PHPMailer.php(2199): SMTP Error: Could not connect to SMTP host. Connection failed. stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages:
error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed [Query: , CLI mode: 1]


                                                                                                                                                           
  [PHPMailer\PHPMailer\Exception]                                                                                                                          
  SMTP Error: Could not connect to SMTP host. Connection failed. stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages:  
  error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed                                                                     
                                                                                                                                                           


core:test-email emailAddress

Hi @hesco
Maybe have a look at: