Why does authtest [email protected] password do not work on MySQL based email server on Ubuntu 20.04

Matti Kiviharju

1/18/23, 2:09 PM

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

0 + 0

mysql

postfix

courier

anx

1/18/23, 2:14 PM

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, ..

Matti Kiviharju

1/18/23, 2:17 PM

Okay, I edit little bit my question,

Matti Kiviharju

1/18/23, 2:22 PM

Now I am edited my question best I can do.

Score:0

Server

Matti Kiviharju

1/18/23, 5:08 PM

I got this issue solved by my own efforts.

with adding a line below to file authmysqlrc:

MYSQL_OPT 0

0 + 0

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Why does authtest [email protected] password do not work on MySQL based email server on Ubuntu 20.04

TH: ทำไมรหัสผ่าน authtest [email protected] ไม่ทำงานบนเซิร์ฟเวอร์อีเมลที่ใช้ MySQL บน Ubuntu 20.04

RO: De ce parola authtest [email protected] nu funcționează pe serverul de e-mail bazat pe MySQL pe Ubuntu 20.04

RU: Почему пароль authtest [email protected] не работает на почтовом сервере на базе MySQL в Ubuntu 20.04

VI: Tại sao mật khẩu authtest [email protected] không hoạt động trên máy chủ email dựa trên MySQL trên Ubuntu 20.04

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.