0

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
Matti Kiviharju
  • 123
  • 8
  • Sounds like you are trying to adapt some SQL configuration for current software, so to answer this it would be essential to see what you have attempted and why that did not work or meet your requirements. Please [edit] your question to include relevant configuration, steps attempted, errors logged, .. – anx Sep 18 '21 at 14:14
  • Okay, I edit little bit my question, – Matti Kiviharju Sep 18 '21 at 14:17
  • Now I am edited my question best I can do. – Matti Kiviharju Sep 18 '21 at 14:22

1 Answers1

0

I got this issue solved by my own efforts.

with adding a line below to file authmysqlrc:

MYSQL_OPT 0

Matti Kiviharju
  • 123
  • 8