Okay that solved a problem... thanks!!! But at least not the SASL one! ;)
Am 23.03.2012 17:00, schrieb Reindl Harald:
we are using "mydestination", "local_recipient_maps" and dbmail-lmtpd for
years and my webinterface is simply maintaining a domain/transport
list in a table based on dbmail_aliases triggered in a php-function
after changes
in other words: i see no reason for virtual_* at all the transport
table is much flexibler because you can define external transports
and with some lines of code prefer them even if dbmail is pre-configured
for a domain while you relay messages to the old server until all users
are configured for the new one (domain-transfers and so)
mydestination = proxy:mysql:/etc/postfix/mysql-mydestination.cf
[root@srv-rhsoft:~]$ cat /etc/postfix/mysql-mydestination.cf
user = dbmail
password = ****************
dbname = dbmail
hosts = unix:/var/lib/mysql/mysql.sock inet:127.0.0.1:3307
query = select transport from dbma_mta where mydestination='%s';
mysql> select * from dbma_mta where mydestination like '%rhsoft%';
+-----------------------+--------------------------+
| mydestination | transport |
+-----------------------+--------------------------+
| arrakisvm.rhsoft.net | dbmail-lmtp:127.0.0.1:24 |
| local.rhsoft.net | dbmail-lmtp:127.0.0.1:24 |
| notebook.rhsoft.net | dbmail-lmtp:127.0.0.1:24 |
| rhsoft.net | dbmail-lmtp:127.0.0.1:24 |
| srv-rhsoft.rhsoft.net | dbmail-lmtp:127.0.0.1:24 |
| testserver.rhsoft.net | dbmail-lmtp:127.0.0.1:24 |
+-----------------------+--------------------------+
6 rows in set (0.00 sec)
Am 23.03.2012 16:49, schrieb Claas Kähler:
Your are right! But that isn't the problem. Postfix only checks if there is a
result or not. Take a look at:
http://dbmail.org/dokuwiki/doku.php/setup_postfix
They used the same query.
Am 23.03.2012 16:45, schrieb Reindl Harald:
what the hell should "SELECT DISTINCT 1" do?
this will result in "1" and never in any list
mysql> SELECT DISTINCT 1 FROM dbmail_aliases;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
Am 23.03.2012 16:39, schrieb Claas Kähler:
root@(none):/etc/postfix# grep virtual /etc/postfix/main.cf
virtual_mailbox_domains = mysql:/etc/postfix/sql-virtual_mailbox_domains.cf
root@(none):/etc/postfix# cat /etc/postfix/sql-virtual_mailbox_domains.cf
user = dbmail
password = changeMe
hosts = 127.0.0.1
dbname = dbmail
query = SELECT DISTINCT 1 FROM dbmail_aliases WHERE SUBSTRING_INDEX(alias, '@',
-1) = '%s';
Am 23.03.2012 16:29, schrieb Paul J Stevens:
On 03/23/2012 04:22 PM, Claas Kähler wrote:
Okay i've got the following in my mail.log when my trying to sent a
Email to an account:
Mar 23 16:19:34 (none) postfix/virtual[8591]: fatal: bad string length 0
< 1: virtual_mailbox_base
Mar 23 16:19:35 (none) postfix/master[2737]: warning: process
/usr/lib/postfix/virtual pid 8591 exi status 1
Mar 23 16:19:35 (none) postfix/master[2737]: warning:
/usr/lib/postfix/virtual: bad command startup-- throttling
That's not SASL related at all!
what does
grep virtual /etc/postfix/main.cf
have to say?
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
