MySQL – Fix Authtest Issues on MySQL Based Email Server

courierMySQLpostfix

I used this manual for dummies for configure email sever for Ubuntu 20.04:

https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-ubuntu-14.04-lts

And for passwords ENCRYPT function on MySQL is removed from my MySQL Server version.

How to make password crypt right way for virtual users on MySQL?

I tried make password crypt with this manual:

https://www.courier-mta.org/authlib/authpasswd.html

Here is code of users table for MySQL in file mysql-virtual_mailboxes.cf:

   user = mail_admin
   password = password
   dbname = mail
   query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM `users` WHERE email='%s'
   hosts = 127.0.0.1

And error of Linux bash command described in this subject:

Authentication FAILED: Operation not permitted 

Here is some error logs:

Sep 18 16:25:52 alm authdaemond: authmysql: cannot parse the MYSQL_OPT setting

Best Answer

I got this issue solved by my own efforts.

with adding a line below to file authmysqlrc:

MYSQL_OPT 0