Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread cl445
I put my howto into the wiki... At the moment i stucked with SASL, i tried serveral configuration and nothing worked for me. I installed those packages: aptitude install libsasl2 sasl2-bin libsasl2-modules-sql created this file: /etc/postfix/sasl/smtpd.conf with pwcheck_method: auxprop

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Paul J Stevens
On 03/23/2012 03:20 PM, cl445 wrote: > > I put my howto into the wiki... > At the moment i stucked with SASL, i tried serveral configuration and > nothing worked for me. > > I installed those packages: > aptitude install libsasl2 sasl2-bin libsasl2-modules-sql > > created this file: /etc/postf

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Claas Kähler
Yes I did! I didn't compile SASL on my own, but used the configuration. Same result! :( Am 23.03.2012 15:44, schrieb Paul J Stevens: On 03/23/2012 03:20 PM, cl445 wrote: I put my howto into the wiki... At the moment i stucked with SASL, i tried serveral configuration and nothing worked for me.

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Claas Kähler
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

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread 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:

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Paul J Stevens
Updated the etherpad page a bit. -- Paul J Stevenspjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 __

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread 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 DIST

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Claas Kähler
Am 23.03.2012 16:38, schrieb Paul J Stevens: Updated the etherpad page a bit. Well, the etherpad was outdated sorry, i put the newer version into the wiki: http://dbmail.org/dokuwiki/doku.php/a_sample_mailserver_from_the_scratch_with_dbmail_3.0 ___ D

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread 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

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread 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

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread 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

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Claas Kähler
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_alias

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Reindl Harald
alternative solution for sasl is dovecot-auth "smtpd_sasl_type = dovecot" in main.cf is the only postfix-relevant chamge we are using dovecot at all as imap/pop3 proxy in front of dbmail which listens only on 127.0.0.1 but should be useable only for SASL-auth too somehow the proxy solution is bec

Re: [Dbmail] A very simple working installation of DBMail 3.0

2012-03-23 Thread Claas Kähler
Okay... thats computersience, i found my misstake! It was a simple blank space behind the password!!! I would use Dovecot the next time, it's a bit more up to date than cyrus and not that (stupid) sensitive! ;) I will add an advice into the wiki to prevent this misstake for other users. Am 23.