All Questions
121
questions
0
votes
2
answers
57
views
Not able to connect to MySQL from postfix
opensource community
I am using Postfix, dovecot and Postfix Admin for my complete email setup
I am using virtual users so I have installed postfix-mysql and dovecot-mysql
Issue:
My postfix service is ...
1
vote
0
answers
25
views
Postfix accepting email from incorrect domain
I have a postfix setup and it appears to be accepting emails for other recepients and forwarding them to an existing legitimate email.
For example, we receive a spam email for [email protected], and postfix ...
- 11
1
vote
1
answer
93
views
Postfix Dovecot connection with MySQL8 SSL mode disabled
I have a production running installation of Postfix 3.1 and Dovecot. Recently upgraded to a new version of MySQL, passing from 5.6 to 8 hosted in a new server.
The problem now is that postfix and ...
- 113
0
votes
0
answers
75
views
E-Mails are not storing. Postfix, Dovecot & MySQL
I am trying to set up a mail server with Postfix & Dovecot using MySQL to store the aliases, domain & user.
The issue is, users are not receiving emails.
According to the log files, the ...
- 1
1
vote
0
answers
41
views
postfix delivery location has changed for new users
I have run my postfix/dovecot server for 6 years with out config change. I have just noticed recently that new users emails are getting delivered to another location.
current users are going to /home/...
- 23
0
votes
0
answers
139
views
Connecting postfix to mysql with ssl
I've been trying to get the correct recipe of settings to allow postfix to connect to mysql where ssl is required. So far I have the following config that is not working:
user = mysqluser
password = ...
- 249
0
votes
1
answer
213
views
From "Display Name" not working - Postfix/Dovecot
Working with Dovecot, Postfix and MySQL to send email from my web server (at [email protected]) but what shows up in the inbox is example instead of the display name I put into the email client (...
- 11
1
vote
0
answers
273
views
postfix high availability and scalability
i have successfully set up a postfix , dovecot , mysql container .i can receive and send emails through this container and every thing is going alright.now i am thinking about high availabilty and ...
0
votes
1
answer
253
views
postfix container kubernetes - setting up encrypted secret, configmap for successful db connection
I am trying to run postfix as a container in k8s. The container starts (including the svcs) but my config maps and secrets don't want to play nice.
I tried the following:
setup the config map with ...
- 81
0
votes
1
answer
135
views
Why does authtest [email protected] password do not work on MySQL based email server on Ubuntu 20.04
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 ...
- 123
1
vote
1
answer
511
views
Why does MySQL reject my postfix virtual domain query as "an error in your SQL syntax"?
I have problem with MySQL Courier + Postfix Email Server
Here is error log:
warning: mysql:/etc/postfix/mysql-virtual_domains.cf: query failed: You have an error in your SQL syntax; check the manual ...
- 123
0
votes
1
answer
846
views
Postfix doesn't send mail
I am trying to learn about mail servers and am quite daunted by all of the moving pieces in the setup..
Currently I am unable to send via from my smtp server. I can receive mails fine from various ...
0
votes
1
answer
1k
views
Postfix/Dovecot cannot connect to MariaDB after crash
I am running a mail server on CentOS 8 using Postfix, Dovecot (virtual users) with MariaDB.
~1 week ago, Mariadb seemingly crashed and deleted most (?!) of the users, but failed "softly" and ...
- 125
0
votes
1
answer
914
views
Postfix SSL USING SNI
I What to give assign multiple SSL cert to Multiple Domains
I have manage to do so :
by creating a single wild card SSL cert (e.g mail.example.com , mail.example2.com, etc)
But I Want Each domain to ...
- 3
0
votes
1
answer
5k
views
RoundCube: Connection to storage server failed
This is probably the hardest challenge I have ever faced on Linux. I would never thought sending and receiving the ubiquitous Emails is such hell of a complication!
Following this tutorial on Setup ...
-1
votes
2
answers
5k
views
Postfixadmin can't connect to mysql database
postfixadmin can't connect to mysql database.
Error: Can't connect to database
Please edit the $CONF['database_*'] parameters in config.local.php.
DEBUG INFORMATION:
Connect: Access denied for user '...
- 9
0
votes
0
answers
522
views
postfix+saslauthd+pam_mysql adds EOL to passwords, thus breaks
I'm trying to use the pam_mysql module in conjunction with postfix and saslauthd. Everything appears to be working, except the actual password comparison is failing.
Note: the case being tested is ...
1
vote
1
answer
5k
views
postfix 3.3.0 has fatal error "bad string length 0 < 1"
I'm migrating my mail server from an older instance of postfix (3.2.0) to 3.3.0 on Ubuntu. I'm installing from apt and installation went fine. I'm in the process of trying to set up my MySQL ...
- 386
1
vote
0
answers
45
views
Postfix check how many emails a user is trying to send before queuing them
I have Postfix installed, and set as a send-only smtp server, on a VPS(running ubuntu 18.04).
Now I want to limit a user to 100 emails/day(if possible saving that limit - sent and remaining - inside ...
- 23
1
vote
2
answers
1k
views
Postfix: unused parameter for mysql maps
I need to re-configure Postfix from scratch. When I configured on version 2.11.8-1.4 everything worked fine.
Now I am configuring version 3.3.1 on openSUSE Leap 15.0. I noticed that when postfix works ...
- 11
1
vote
2
answers
2k
views
Different password for Roundcube and external IMAP/SMTP
Is it possible to have the Roundcube password, and the password that's used for IMAP and SMTP connections (such as when using a mail app), be different?
I would like to do this because I've set up 2 ...
- 119
0
votes
1
answer
377
views
Postfix to receive only to database email addresses
I have a standard Postfix server on one of my servers and I have not set up anything so far. What I wish to achieve is:
In a MySQL database I want to store email addresses that are accepted by Postfix....
- 1,096
0
votes
1
answer
1k
views
Postmap returns database not found error
I have set up my Postfix configuration with Mysql maps, prety much as detailed here and here.
I have a file at /etc/postfix/mysql-virtual-mailbox-domains.cf which contains the following:
user = ...
0
votes
1
answer
1k
views
Postfix authentication using MySQL SHA512
In our postfix setup, we are using the pam_mysql module to authenticate the user from the MySQL database. ( similar to this link)
Which is perfectly working fine. We are using SHA512_CRYPT() for ...
- 1
0
votes
1
answer
347
views
How do I configure postfix for Mysql 5.7
I made the appropriate changes to postfix to get mysql 5.7 working as the database instead fo Maria DB. I can run tests and all seems to work on the server. However, I cannot log into my account from ...
- 135
1
vote
1
answer
742
views
postfix + dovecot + mysql : virtual user management
I have a postfix+dovecor email server configured to use mySql as virtual domains/users/aliases repository.
I know I can create/update/delete users in mySQL. The question is: Is there any simpler way ...
- 123
4
votes
1
answer
2k
views
Force Postfix to use TLS for MySQL Connection?
The Problem
I cannot figure out how to force Postfix to use a TLS connection to MySQL. I can manually connect from the Postfix server to the MySQL server with TLS as the postfix user, so there's ...
- 81
0
votes
1
answer
2k
views
Postfix SMTP SASL Authentication with pam_mysql can't accept email addresses as username
I'm currently trying working on a project to update an existing postfix deployment. I'm having issues with authenticating users against smtp.
The primary issue I have is that our postfix users ...
- 219
-1
votes
1
answer
34
views
Dovecot + Postfix: How to automatically send a e-mail back when requested e-mail adress is not found
I currently have a e-mail server set up with dovecot and postfix, getting users from a mysql database, on an ubuntu server. I would like to know how to automatically send an e-mail to the sender if he ...
- 121
0
votes
1
answer
5k
views
Centos 7 Postfix install using MYSQL 5.7 which replaced mariadb
Sorry to disturb you, but I've a problem I can't seem to get around.
I'm trying to install Postfix on a new server which was needed to move to for more space/memory, the old server had 256MB of RAM ...
0
votes
2
answers
324
views
pure-ftpd-mysql and postfix stop working after mysql server update 5.5 to 5.7
I have debian 7.8 and using postfix, mysql with roundcube and pure-ftpd-mysql. All working perfectly with mysql Ver 14.14 Distrib 5.5.40 since 2014.
I try to update mysql to 5.7 in order to play with ...
1
vote
1
answer
987
views
postfix newaliases - mysql does not support bulk-mode creation
As the title implies, I am getting this error whenever I am trying to run newaliases. First, a bit of explanation. I was trying to do an upgrade on my debian server from jessie to stretch, and I ...
- 133
0
votes
1
answer
2k
views
Postfix not respecting mysql alias domains
So the setup is using postfix, dovecot, postfixadmin and mysql. I have configured postfix admin to alias one domain, "name.co.uk" to "name.net", I see this in the database so there's no issue there. ...
- 101
0
votes
2
answers
607
views
Dovecot v2.2.9 mysql user query issue
I am trying to setup a Dovecot and postfix e-mail server. now, i was able to authenticate correctly, but when I open up /var/log/dovecot.log, I get this:
Jun 18 23:20:10 auth-worker(17531): Error: ...
- 1
0
votes
1
answer
3k
views
SMTP doesnt allow me to login (dovecot postfix SSL)
So i followed an tutorial to setup a mailserver but sadly SMTP doesnt seem to work. It also doesn't show any errors in /var/log/mail.log or /var/log/dovecot.log.
Seems like im the only one that has ...
-2
votes
1
answer
2k
views
Unable to login to email server that I can telnet to?
I just finished following this tutorial on Digital Ocean for configuring a Dovecot, MySQL, and Postfix email server. I did not follow it to the end. (I didn't install Spam Assassin.) I also used a ...
- 135
2
votes
3
answers
5k
views
postfix - allow sending email with related alias
I have installed postfix 2.11.3 + +sasl + postfixadmin + dovecot + roundcube on debian 8. All is working fine but today every users can send email with another email address.
I would like to add a ...
- 33
1
vote
3
answers
3k
views
Postfix(admin), Dovecot, MySQL: Aliases not working
I'm able to send mail to the mailboxes i've setup with postfixadmin. This is working correctly and i can send and deliver mail on them. But now i'm in need of Aliases to work properly as well.
I've ...
- 127
2
votes
1
answer
2k
views
Postfix + SASL using wrong query to authenticate
I recently set up postfix + dovecot on a aws ec2 instance following this guide: http://flurdy.com/docs/postfix/#config-secure-auth
Currently I'm stuck with SASL.
The SQL query doesn't seem to be ...
- 165
1
vote
1
answer
4k
views
convert plain text passwords to sha512-crypt in dovecot + postfix's mysql mailbox table
I have an old postfix + dovecot + Roundcube mailserver (mail.domain.Tld). Server clock is loosing time and adjusting it causes dovecot to kill itself, we cannot install more memory, bigger hard-drives,...
- 21
0
votes
1
answer
198
views
ubuntu - Postfix mail sent from server not logged in mail.log or phpmail.log
I am having server which hosts 70-80 websites and also using relay server for smtp using postfix using mysql database for domain and email boxes.
I have also activated the phpmail.log for sendmail.
...
- 97
1
vote
1
answer
2k
views
Postfix can't connect to MariaDB on 127.0.0.1
(Yes, this question seems very similar, but I understand why I get the message. What I don't get, and can't find any palpable information about on my own, is what to do about it. So here I am.)
I am ...
1
vote
0
answers
295
views
Alias with all users in mysql table for postfix/dovecot
I have a table with users for my mail server. This table for imap authenfication in dovecot:
+-------------+------------------+-------------------+------------------+------+------+--------------------...
0
votes
1
answer
359
views
Postfix - MySQL - noreply custom response not working
I'm trying to get a custom response working for [email protected] and I keep getting "User doesn't exist" errors.
I have an alias of [email protected] which has a 'goto' of the same value, then ...
- 1,738
0
votes
1
answer
1k
views
IMAP authentication issue with roundcube + postfix + mysql + ubuntu mailserver
This problem is driving me insane and I'm now stumped. Need some help please ;)
I'm setting up a mail server on an Ubuntu 14 AWS EC2 instance using mysql backend, postfix MTA and roundcube webmail ...
- 1
0
votes
1
answer
5k
views
Postfix & Dovecot: Mailbox Quota Configurations
I'm running Postfix 2.11, Dovecot 2.2.9 and MySQL 5.6.27 under Ubuntu 14.04.3.
I've configured Postfix to support virtual mailboxes but it seems that there're some problems with the quota settings.
~...
3
votes
2
answers
1k
views
How to specify target directory in Postfix with MySQL?
I have setup a mail server with Postfix, Dovecot and MySQL. Dovecot works perfectly. Postfix sends mail, but I have a problem with receiving mail.
After 2 days of debugging and tweaking ...
- 173
2
votes
2
answers
1k
views
Postfix omits realm (@domain) when checking for smtpd pam+mysql authentication
I've trying to configure Postfix so users can send email through SMTP having a username and password. And I'm trying to store credential within a MySQL database. I've taken the path of saslauthd and ...
- 519
0
votes
1
answer
193
views
Postfix virtual_mailbox_maps mysql lookup on 2 different DBs
I'm trying to configure a postfix server to receive email for 2 different domains (no problem so far). But the users/mailboxes for both domains need to be looked up in 2 different tables on 2 ...
-2
votes
1
answer
247
views
Mailserver force password change
Mailserver has been setup using postfix,dovecot,mysql,postfixadmin and squirrel mail. Is it possible to forcefully make an user change his password after certain days and also send an alert email ...
- 93