Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
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 853 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

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
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

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.

×
Submit an Answer
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

Related

Looking for something else?

Ask a new question Search for more help