Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.
Bug 890646 - SELinux don't allow postfix to connect MySQL database
SELinux don't allow postfix to connect MySQL database
Status: CLOSED ERRATA
Product: Red Hat Enterprise Linux 6
Classification: Red Hat
Component: selinux-policy (Show other bugs)
6.5
All Linux
unspecified Severity unspecified
: rc
: ---
Assigned To: Miroslav Grepl
Michal Trunecka
:
Depends On:
Blocks: 1004654
  Show dependency treegraph
 
Reported: 2012-12-28 07:24 EST by Filip Bartmann
Modified: 2014-11-07 05:50 EST (History)
5 users (show)

See Also:
Fixed In Version: selinux-policy-3.7.19-210.el6
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 1004654 (view as bug list)
Environment:
Last Closed: 2013-11-21 05:11:58 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2013:1598 normal SHIPPED_LIVE selinux-policy bug fix and enhancement update 2013-11-20 16:39:24 EST

  None (edit)
Description Filip Bartmann 2012-12-28 07:24:27 EST
Description of problem:
SELinux don't allow postfix to connect to MySQL database if Postfix use external storage for maps

Version-Release number of selected component (if applicable):

selinux-policy.noarch                                                                                                                       3.7.19-189.el6                                                                                                               @selinux
selinux-policy-targeted.noarch                                                                                                              3.7.19-189.el6                                                                                                               @selinux
How reproducible:
Set postfix maps as for example:

virtual_mailbox_domains=mysql:/etc/postfix/domains
virtual_mailbox_maps=mysql:/etc/postfix/mailboxes

Steps to Reproduce:
1. Set Postfix maps as above
2. Send mail to this server

Actual results:
allow postfix_virtual_t mysqld_db_t:dir search;
allow postfix_virtual_t mysqld_t:unix_stream_socket connectto;
allow postfix_virtual_t mysqld_var_run_t:sock_file write;

Expected results:
No entries in audit.log

Additional info:
I suggest to solve this by adding tunable to postfix with 
mysql_stream_connect(postfix_virtual_t)
and so for postgres
Comment 2 Daniel Walsh 2012-12-28 11:24:53 EST
Lets back port d3b3143f959f738e805c855b155775478955391d
Comment 5 Michal Trunecka 2013-08-14 04:39:27 EDT
To backport commit from Comment 2, you would also need to backport postfix_domain attribute, which is missing on RHEL6.

+  optional_policy(`
+       mysql_stream_connect(postfix_domain)
+')

This bug was fixed just this way:

+ mysql_stream_connect(postfix_virtual_t)

was there a reason not to backport suggested rule for whole postfix_domain?
Comment 6 Miroslav Grepl 2013-08-19 09:42:07 EDT
It was not back ported.
Comment 7 Miroslav Grepl 2013-08-19 09:42:55 EDT
Basically we don't have postfix_domain attribute in RHEL6.5. Should be also back ported.
Comment 10 errata-xmlrpc 2013-11-21 05:11:58 EST
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHBA-2013-1598.html

Note You need to log in before you can comment on or make changes to this bug.