DevHeads.net

Postings by Dave

virtual transport lmtp vs. dovecot lda?

Hello,

I'm running a Postfix 3.1 setup with Dovecot 2.29 and Mysql 5.7. I am
trying to track down an elusive problem. Previously I had my
virtual_transport set to dovecot with a dovecot service in master.cf.
I then enabled the lmtp service which uses a socket
/var/spool/postfix/private/dovecot-lmtp

I keep getting the error in the logs to many connections to the mysql
database and stuff is deferred.

Any ideas?

Thanks.
Dave.

Apache 2.4 with Mysql authentication

Hello,

I've got a Mysql database set up for user authentication, with fields
username, password, group, and active. I've got a group testgroup that
i've put users in.

Re: Can not add foreign key constraint

Hello,

Here's the create table sand error message.

root@localhost [(none)]> use mail;
Database changed
root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` (
-> `user` varchar(40) NOT NULL,
-> `remote_ip` varchar(18) NOT NULL,
-> `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,
-> PRIMARY KEY (`user`),
-> FOREIGN KEY (user) REFERENCES virtual_users(user) ON DELETE CASCADE
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ERROR 1215 (HY000): Cannot add foreign key constraint

For the table it's referencing

Can not add foreign key constraints

Hello,

I'm trying to add a table to an existing database. I'm wanting it to get
one of it's fields from an already existing table. I've done this
before in this database.

file attachments for the domain only, and virtual mailbox size

Hello,

I've got two issues. The first is I'm blocking file attachments in the
mime_headers file below. I'd like to allow those attachments but only
for hosts within the domain, so for example <a href="mailto: ... at example dot com"> ... at example dot com</a> can send
<a href="mailto: ... at example dot com"> ... at example dot com</a> a word document.

The second issue is I'm running virtual users out of a mysql database.
I'd like to ensure that each virtual user's mailbox is no larger than
250MB in size.

bitdefender

Hello,

I'm running a postfix mail server. One of it's components is
antivirus. For that I'm running clamav. I'd like to have a second
scanner as backup. Does anyone have any experience with bitdefender?
If not any other suggestions?

Thanks.
Dave.

gmail servers on blacklists?

Hello,

I'm starting to see blocks on my messages to my mail server.

Possibly o.t. Postfixadmin 3.x unable to log in

Hello,

Not sure if this is the right place for this question.

I have no previous experience with Postfixadmin for domain and user
management with postfix as I usually do my configuration file editing
manually.

I've got a project where i'm needing to run it. I've got a postfix
2.11 and Postfixadmin 3.0 install in a virtual machine. The setup.php
is complete, database connectivity works fine. I've generated the hash
password and put that line in config.local.php and an admin email.

nonconsistent proxy 503 or 502 errors with apache 2.4

Hello,

I'm running a FreeBSD 10.3 server which has an Apache 2.4.25 system
running on it. It's reverse proxying to two web servers example.com
and example2.com hosted in two separate FreeBSD jails.

I'm getting nonconsistent 502 and 503 errors when atempting to access
the systems from the outside.

For example one time I hit example.com and it works. I then go to
example2.com and get either a 502 or 503 message. I try from another
browser this time going to example2.com and it works, but then going
to example.com gives me those same 502 or 503 error messages.

Inserting a signature

Hello,

I'm wanting to insert an email signature in all outgoing email
messages. Is altermime still the best way of doing this or is there
another path?

Thanks.
Dave.

free email fax setup postfix integration

Hello,

I am looking for a free email 2 fax system that integrates with
postfix. I looked at faximum but that's very out of my range.

Anyone know of any product comparable?

Thanks.
Dave.

Postfix, Dmarc, and Dkim for multiple domains

Hello,

I'm not sure if this is the right place to ask this question, but it
is mail related.

I've got Postfix 3.1, and two milter filters dkim (with OpenDKIM), and
dmarc (with OpenDMARC). At the time of initial setup I had one virtual
mailbox domain and things were working fine.

Now I've added two more virtual mailbox domains and need to configure
both opendkim and opendmarc to handle them.

smtpd not announcing sasl capabilities

Hello,

I'm running Postfix 3.1.

Allowing users to edit web sites safely

Hello,

I've got a FreeBSD 10.3 server on which is running Apache 2.4. I've
got two web sites that are relevant to this message and which both get
backed up on an other daily basis.

A user wants now to take control of both. I don't use a control panel
so he'll have to make files then upload. I've got sftp set up to
restrict the user to his home directory area.

Autoresponder

Hello,

I'm looking for an autoresponder, free, and one that does not rely on
postfixadmin.

I saw one featured in a howtoforge article called Autoresponse 1.6.3
but that has been taken down, which is unfortunate, because how it
worked, sending an email to an address sounded great for my needs.

If anyone has this, or has any suggestions i'd appreciate them. I have
looked on the postfix page and the autoresponders there are paid
products, and the one that isn't uses an LDAP format which I am not
using.

Thanks.
Dave.

Postfix migration 2.11 to 3.1, Thunderbird, and antispam questions

Hello,

I'm running a FreeBSD 10.3 AMD64 system. I just upgraded Postfix from
2.11 to 3.1. I'm using Dovecot for Sasl authentication via mysql and
email storage via maildir.

The system can receive emails from the internet via port 25, (running
postscreen), and store them on disk using dovecot, no p roblem.

I'm using Thunderbird 31.7.0 to connect remotely to my server and
retrieve and send email.

Am I overdoing my configuration?

Hello,

I'm running Postfix 2.11.6 on a FreeBSD 10 system. I'm wondering if
I'm making my Postfix work to hard? I've got postscreen checking
various rbl lists to check for spammers then doing checks in my
smtpd_recipient_restrictions. Here's my config I'd appreciate any
comments on it?

postfix tls error on port 587

Hello,

I'm running a FreeBSD 10.2 system, postfix 2.11.6, Openssl 1.0.1P. I'm
working on setting up a webmail client to my existing
Postfix/Dovecot/Mysql setup. I've tried two webmail clients both are
giving me the below errors when the webmail client (postfix dovecot
mysql the web server are all running on the same machine), atempts to
send mail through port 587.

Using the most secure SSL cipher suites

Hello,

I'm configuring a new apache 2.4 system which will have a webmail app
running on it. I'm wanting to use only the most current/secure ssl
ciphers and ones that offer perfect forward secrecy. I'm using FreeBSD
10.1 and my openssl version is 1.0.1l. In the virtual host
configuration that will run the webmail app I have:

SSLEngine on
SSLCipherSuite HIGH

and then of course the path to my certificate and key.

Postfix with Postscreen and Fail2ban

Hello,

Is anyone running Postfix 2.11 on an f21 machine? I'm using it and am
using postscreen which I really like. The system firewall is FirewallD
and I'm using fail2ban 0.9.1 to block brute force bot hits on the
machine. I've got the jail Fail2ban for Postfix enabled, but the
regexp don't appear to be catching the logs of attempted postscreen
connections. I'm assuming here that anything postscreen rejects is a
spammer and would like them rejected out of hand.

If anyone has this working I'd appreciate knowing how you did it.

Thanks.
Dave.

postscreen fine tuning

Hello,

I'm running postscreen and I'm wondering about a setting. For
postscreen_dnsbl_action, and postscreen_greet_action I've got them set
to enforce. My problem is while it works I get clients that are repeat
customers after they've already been dealt with.

Follow up to my Postfix and DSpam issue

Hello,

This is a short follow up to my message on Postfix and DSpam
integration specifically dealing with the spam and notspam aliases. I
still have not found out what the problem is, but I know what it
isn't. It's definitely not postfix. I removed the content_filter
option and kept everything else, also changed in master.cff
/usr/bin/dspamc to /usr/bin/dspam and forwarding to the spam and
notspam addresses worked fine, locked them down with a sender and
recipient check and that also worked. Adding back in the
content_filter option and they return error 555 invalid user.

Thanks.
Dave.

Postfix DSpam retrain aliases and error 555 user does not exist

Hello,

I'm using Postfix 2.10 and DSpam 3.10 on an FC20 system.

I'm trying to set up the DSpam aliases for retraining, <a href="mailto: ... at domain dot com"> ... at domain dot com</a>
and <a href="mailto: ... at domain dot com"> ... at domain dot com</a> and I keep getting an error 555 from Postfix,
user does not exist.

Postfix and DSpam

Hello,

Do we have any users of Postfix and DSpam here? If so, can you write
me privately? I'm having a few issues fine tuning my configuration.

I'm running FC20, Postfix 2.10, and DSpam 3.10. Authentication is done
via a Mysql database.

Redirecting virtual host to https in Apache 2.4

Hello,

I'm running Apache 2.4 on an FC20 box. It's running several name based
virtual hosts.

I've set up one name based virtual host on port 443 I'll call it
webmail.example.com. When a user goes to <a href="https://webmail.example.com" title="https://webmail.example.com">https://webmail.example.com</a>
the connection encrypts, the page is displayed.

updating a Centos 6 lamp stack

Hello,

I've got a new centos 6 system it's i386 and I'm wanting to update
it's lamp stack, specifically httpd, php, and mysql. Also, if postfix
as an MTA would be available that's a plus.

I've checked out the centos wiki and it looks like I have two choices
for third party repos for this task. I have enabled rpmforge as of
now.

Apache 2.2 authentication against a Mysql Database

Hello,

I'm wanting to set up Apache 2.2 to authenticate using either basic or
digest authentication whichever I decide to do, against a Mysql
Database. I am running Apache 2.2 and mysql 5.52.

Ive set up authentication using textfiles in the past now I am wanting
to utilize a database. I've been googling and not finding anything
clear specifically for Mysql on this process. If anyone has any
pointers please let me know, the docs kind of get me pointed right,
i.e.

IPV6 and SPF

Hello,

Does anyone publish SPF records for IPV6 in DNS? The reason I ask is
my mail server has both an IPV4 and an IPV6 address and when
connecting to it via webmail that goes to localhost, it seems as if
the outgoing connection is either IPV4 or IPV6 depending on whether
that localhost connection got the v4 or v6 address first. I've got an
IPV4 SPF record which works fine and validates. On the IPV6 side that
one doesn't and when reading headers it says so. I'd like to fix this.

Thanks.
Dave.

clamsmtp or clamav-milter for antivirus with postfix 2.9?

Hello,

This might be off topic, but I was wondering I am using Postfix 2.9.x
and am wanting to integrate antivirus capabilities. What are the
differences between clamsmtp and clamav-milter? I'm wondering which
one would be better for an antivirus setup?

Thanks.
Dave.

using htaccess on all hosts to block addresses

Hello,

I've got a list of host IP's i'd like to block. I want to do this with
an .htaccess file and want it to effect all virtual hosts on my
server. I've got the .htaccess file and am wondering where to place
it. Can I put it in the ServerRoot area which is /srv/http I believe
on my arch box or do I have to put in the public_html directory of
every virtual host? Or is there another way?