[Bug 1095144] New: Postfix does not support mysql maps
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144 Bug ID: 1095144 Summary: Postfix does not support mysql maps Classification: openSUSE Product: openSUSE Distribution Version: Leap 15.0 Hardware: x86-64 OS: SUSE Other Status: NEW Severity: Major Priority: P5 - None Component: Other Assignee: bnc-team-screening@forge.provo.novell.com Reporter: woe.2018@wizonet.ch QA Contact: qa-bugs@suse.de Found By: --- Blocker: --- Postfix 3.3 in Leap-15 does no longer support mysql virtual maps. Installed is: i | postfix | A fast, secure, and flexible mailer i+ | postfix-mysql | Postfix plugin to support MySQL maps When I use this line in main.cf: virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf and restart postfix, or check postfix with postconf -n this ends up in this warn messages: postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: password=xxxxxxx postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: dbname=postfix postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: query=SELECT maildir FROM mailbox WHERE username='%u' AND active=1 postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: user=postfix postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: hosts=localhost In Leap 43.2 this was possible without any issue. Another MySQL/MariaDB Client problem in Leap 15? Postfix manpage and sample configurations still suggest this as a possibility. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
Tomáš Chvátal
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c2
Per Jessen
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c3
--- Comment #3 from Per Jessen
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c5
--- Comment #5 from Per Jessen
I can confirm that the error message disappears if you enter the map without path.
virtual_mailbox_maps = mysql:mysql_virtual_mailbox_maps.cf
However, no error message is displayed if you specify a non-existing map file - so it is possible that the maps are simply not found in this variant.
Yes, I think that is probably the explanation.
virtual_mailbox_maps = mysql:blablubbhaha_mysql_virtual_mailbox_maps.cf
does also not print out an error message, and this file is not present in any path.
Also very weird. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c6
Peter Varkoly
Postfix 3.3 in Leap-15 does no longer support mysql virtual maps.
Installed is: i | postfix | A fast, secure, and flexible mailer i+ | postfix-mysql | Postfix plugin to support MySQL maps
When I use this line in main.cf: virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
and restart postfix, or check postfix with postconf -n this ends up in this warn messages:
postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: password=xxxxxxx postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: dbname=postfix postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: query=SELECT maildir FROM mailbox WHERE username='%u' AND active=1 postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: user=postfix postconf: warning: mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf: unused parameter: hosts=localhost
In Leap 43.2 this was possible without any issue. Another MySQL/MariaDB Client problem in Leap 15? Postfix manpage and sample configurations still suggest this as a possibility.
Sorry for being too late. Now I've found that in 3.3.0 a new function pcf_check_dbms_client was introduced to "report unknown database client configuration parameters". This function will be called only if the database configuration files are given with absolute path. Unfortunately this function seems to be buggy. But this warnings should not have any influence on the functionality. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c7
--- Comment #7 from Peter Varkoly
(In reply to Martin Willisegger from comment #4)
I can confirm that the error message disappears if you enter the map without path.
virtual_mailbox_maps = mysql:mysql_virtual_mailbox_maps.cf
However, no error message is displayed if you specify a non-existing map file - so it is possible that the maps are simply not found in this variant.
Yes, I think that is probably the explanation.
virtual_mailbox_maps = mysql:blablubbhaha_mysql_virtual_mailbox_maps.cf
does also not print out an error message, and this file is not present in any path.
Also very weird.
Do not forget: In case mysql:blablubbhaha_mysql_virtual_mailbox_maps.cf postconf -d do not read the file /etc/postfix/blablblablubbhaha_mysql_virtual_mailbox_maps.cf. Instead of postconf requires now the virtual_mailbox_maps mysql parameters in main.cf in form of: blablubbhaha_mysql_virtual_mailbox_maps.cf_hosts blablubbhaha_mysql_virtual_mailbox_maps.cf_query ... See man mysql_table: OBSOLETE MAIN.CF PARAMETERS For compatibility with other Postfix lookup tables, MySQL parameters can also be defined in main.cf. In order to do that, specify as MySQL source a name that doesn't begin with a slash or a dot. The MySQL parameters will then be accessible as the name you've given the source in its definition, an underscore, and the name of the parameter. For example, if the map is specified as "mysql:mysqlname", the parameter "hosts" would be defined in main.cf as "mysqlname_hosts". -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c8
--- Comment #8 from Per Jessen
Sorry for being too late. Now I've found that in 3.3.0 a new function pcf_check_dbms_client was introduced to "report unknown database client configuration parameters". This function will be called only if the database configuration files are given with absolute path. Unfortunately this function seems to be buggy. But this warnings should not have any influence on the functionality.
Aha - I didn't test any actual functionality. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c9
--- Comment #9 from Martin Willisegger
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c10
Ricardo Minnaard
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c11
--- Comment #11 from Ricardo Minnaard
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c12
Christian Boltz
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c13
Daniel B
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144
http://bugzilla.opensuse.org/show_bug.cgi?id=1095144#c14
--- Comment #14 from Christian Boltz
participants (1)
-
bugzilla_noreply@novell.com