[Dovecot] SQL passdb, LDAP userdb
Hi,
in my current setup, LDAP authentication + userdb works fine.
I'd like to integrate Dovecot with Shibboleth. I have a custom module at the IdP (*) that inserts short-time tokens to an SQL table at user authentication, and I want Dovecot to use the token table for passdb but keep LDAP for storing the userdb (uid, quota, etc)
I thought it was simple as omitting the sql user_query, but I got: Warning: mysql: Query failed, retrying: Table 'webmail.users' doesn't exist Error: sql(user@domain,ipaddr): User query failed: Table 'webmail.users' doesn't exist (using built-in default user_query: SELECT home, uid, gid FROM users WHERE username = '%n' AND domain = '%d')
Do you have any hints how to do this? Thanks, Kristof
(*): in SAML there is an Identity Provider that does user authentication, which is separated from the services
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Tue, 27 May 2014, Kristof Bajnok wrote:
in my current setup, LDAP authentication + userdb works fine.
I'd like to integrate Dovecot with Shibboleth. I have a custom module at the IdP (*) that inserts short-time tokens to an SQL table at user authentication, and I want Dovecot to use the token table for passdb but keep LDAP for storing the userdb (uid, quota, etc)
I thought it was simple as omitting the sql user_query, but I got: Warning: mysql: Query failed, retrying: Table 'webmail.users' doesn't exist Error: sql(user@domain,ipaddr): User query failed: Table 'webmail.users' doesn't exist (using built-in default user_query: SELECT home, uid, gid FROM users WHERE username = '%n' AND domain = '%d')
Do you have any hints how to do this?
post your doveconf -n .
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux)
iQEUAwUBU5BXjXz1H7kL/d9rAQIjhwf4ovQKnTkJYSO7yJXslFHOPrASuF+XII74 9v2im0iR3Rrulxw7b1mp2T2OuOuYqVOVjDgquumNTzPXm0jJ4o7W+OY8Px8cDQI0 fGmbuTOaUKkvNYT7VEp+gZ6Keu9cDi3Kf0jebshUTzj5sS/LOl9G4jkvTweYxQoo oh0Gl1ua+ZplYDHSaT3Q/PZT4rgKWDJ2z+1huhEi/vjahZU29XDNh3upjmGjcaNu dm3XwtpAd/iHxIR0ZNjvEl5siJWacszofwJhY33AYdL5Sj7bIneKk4vAqhiNrMYK Qra7YTm1pdeFSxWcJFoPA9gD+F1MPN3kn2xCiYF7L9RU8MlKO/BR =cnoZ -----END PGP SIGNATURE-----
On 2014-06-05 13:42, Steffen Kaiser wrote:
in my current setup, LDAP authentication + userdb works fine.
Sorry for not getting back to this earlier. It was a silly error on my side that should've been clear from doveconf -n: I had had an erroneous sql userdb definition lurking in the middle of the chain of configuration includes.
Sorry for the noise, Kristof
participants (2)
-
Kristof Bajnok
-
Steffen Kaiser