no login with MySQL

2015-09-13 Thread Andreas Meyer
Hello! Setup again to authenticate my users with MySQL but can't login. Sep 13 11:55:49 auth: Info: passwd-file(a.me...@nimmini.de,95.88.63.177,<R7Qe9J0fTgBfWD+x>): unknown user Sep 13 11:55:49 auth: Info: passwd-file(a.me...@nimmini.de,95.88.63.177,<R7Qe9J0fTgBfWD+x>): unknown us

Re: no login with MySQL

2015-09-13 Thread Christian Kivalo
On 2015-09-13 21:05, Andreas Meyer wrote: Hello! Christian Kivalo schrieb am 13.09.15 um 19:51:38 Uhr: > Sep 13 11:55:49 imap(a.me...@nimmini.de): Error: user > a.me...@nimmini.de: Initialization failed: Namespace '': Home > directory not set for user. Can't expand ~/

Re: no login with MySQL

2015-09-13 Thread Andreas Meyer
Christian Kivalo schrieb am 13.09.15 um 22:08:04 Uhr: > > I think the query-string für MySQL would overwrite this mail_location, > > right? But how do I define it in the query? > > yes thats how it should work but your query (looking at the query result > from your first

Re: no login with MySQL

2015-09-13 Thread Andreas Meyer
Hello! Christian Kivalo schrieb am 13.09.15 um 19:51:38 Uhr: > > Sep 13 11:55:49 imap(a.me...@nimmini.de): Error: user > > a.me...@nimmini.de: Initialization failed: Namespace '': Home > > directory not set for user. Can't expand ~/ for mail root dir in: ~/ > > Sep 13

Re: no login with MySQL

2015-09-13 Thread Christian Kivalo
On 2015-09-13 13:58, Andreas Meyer wrote: Hello! Setup again to authenticate my users with MySQL but can't login. Sep 13 11:55:49 auth: Info: passwd-file(a.me...@nimmini.de,95.88.63.177,<R7Qe9J0fTgBfWD+x>): unknown user Sep 13 11:55:49 auth: Info: passwd-file(a.me...@nimmini.de,95.88.

Re: no login with MySQL

2015-09-13 Thread Andreas Meyer
Benny Pedersen schrieb am 14.09.15 um 01:17:17 Uhr: > Andreas Meyer skrev den 2015-09-13 22:52: > > > Don't understand it. > > in mysql shell you self need to expand %u > > since there is possible no user email that is %u Yes, of course. Too much stress today. But I solved

Re: no login with MySQL

2015-09-13 Thread Tobias Franzén
On 2015-09-13 22:52, Andreas Meyer wrote: Christian Kivalo schrieb am 13.09.15 um 22:08:04 Uhr: I think the query-string für MySQL would overwrite this mail_location, right? But how do I define it in the query? yes thats how it should work but your query (looking at the

Re: no login with MySQL

2015-09-13 Thread Benny Pedersen
Andreas Meyer skrev den 2015-09-13 22:52: Don't understand it. in mysql shell you self need to expand %u since there is possible no user email that is %u :-)

[Dovecot] Master Login using MySQL problem - %{login_domain}

2010-08-17 Thread Marc Perkel
Hi Timo, Been trying to track this problem down further. The problem seems to be related to verifying the master user failing. My passdb looks like this: passdb { driver = sql args = /etc/dovecot/dovecot-domain-owner-sql.conf master = yes pass = yes } dovecot-domain-owner-sql.conf

Re: [Dovecot] Master Login using MySQL problem - %{login_domain}

2010-08-17 Thread Timo Sirainen
On Tue, 2010-08-17 at 08:50 -0700, Marc Perkel wrote: Been trying to track this problem down further. The problem seems to be related to verifying the master user failing. Show the whole dovecot -n output and the whole logs when master user is logging in? You've cut away some stuff I'd like

Re: [Dovecot] Master Login using MySQL problem - %{login_domain}

2010-08-17 Thread Marc Perkel
On 8/17/2010 9:45 AM, Timo Sirainen wrote: On Tue, 2010-08-17 at 08:50 -0700, Marc Perkel wrote: Been trying to track this problem down further. The problem seems to be related to verifying the master user failing. Show the whole dovecot -n output and the whole logs when master user is

Re: [Dovecot] Master Login using MySQL problem - %{login_domain}

2010-08-17 Thread Timo Sirainen
Does it log Master user lookup for login if you patch Dovecot with http://hg.dovecot.org/dovecot-2.0/raw-rev/7428338c8df2 ?

Re: [Dovecot] Master Login using MySQL problem - %{login_domain}

2010-08-17 Thread Marc Perkel
On 8/17/2010 10:11 AM, Timo Sirainen wrote: Does it log Master user lookup for login if you patch Dovecot with http://hg.dovecot.org/dovecot-2.0/raw-rev/7428338c8df2 ? Ran the patch - here's the results for b...@plf.net*tom@plf.net Aug 17 10:42:04 auth: Debug:

Re: [Dovecot] Master Login using MySQL problem - %{login_domain}

2010-08-17 Thread Timo Sirainen
On Tue, 2010-08-17 at 10:45 -0700, Marc Perkel wrote: Aug 17 10:42:04 auth: Debug: auth(t...@plf.net,127.0.0.1,master): Master user lookup for login: b...@plf.net Aug 17 10:42:04 auth: Debug: sql(t...@plf.net,127.0.0.1): query: SELECT user_name, domain_name, password FROM users WHERE

Re: [Dovecot] Master Login using MySQL problem - %{login_domain}

2010-08-17 Thread Marc Perkel
On 8/17/2010 11:16 AM, Timo Sirainen wrote: On Tue, 2010-08-17 at 10:45 -0700, Marc Perkel wrote: Aug 17 10:42:04 auth: Debug: auth(t...@plf.net,127.0.0.1,master): Master user lookup for login: b...@plf.net Aug 17 10:42:04 auth: Debug: sql(t...@plf.net,127.0.0.1): query: SELECT user_name,