Related

How to set up postfix on nginx server to allow WP send emails through outlook.com aka (mail.live.com) via SMTP with TLS auth? Question Question
Email Setup for Wordpress & Normal Accounts Question Question

Question

Setting up email server for wordpress 1 click install

Posted September 8, 2020 118 views
WordPressEmail

Hello i’m trying to setup my email on my server per the tutorial posted on digital ocean(https://www.digitalocean.com/community/tutorials/how-to-configure-a-mail-server-using-postfix-dovecot-mysql-and-spamassassin). When I get to the step:

INSERT INTO servermail.virtual_users
(id, domain_id, password , email)
VALUES
(‘1’, '1’, ENCRYPT('firstpassword’, CONCAT(’$6$’, SUBSTRING(SHA(RAND()), -16))), ’email1@example.com’),
('2’, '1’, ENCRYPT('secondpassword’, CONCAT(’$6$’, SUBSTRING(SHA(RAND()), -16))), ’email2@example.com’);

I get an error:
ERROR 1305 (42000): FUNCTION servermail.ENCRYPT does not exist

How can this be fixed so I can have access to email. Thanks.

Add a comment
brianallen714
By:
brianallen714
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
KFSys September 8, 2020

Hi @brianallen714,

Can you confirm where exactly are you getting this error, the above mentioned 


INSERT INTO `servermail`.`virtual_domains`
(`id` ,`name`)
VALUES
('1', 'example.com'),
('2', 'hostname.example.com');

Needs to be added in your MySQL DB which you have configured previously.

Are you executing the query there?

Regards,
KFSys

Reply Report
YoghurtPower September 9, 2020

Hello,

Think that the ENCRYPT function was depricated in the latest versions.
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html

You should be able to use the SHA2() https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_sha2

Hope this might help you.

Regards,
Ivan / YoghurtPower

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help