[Dovecot] PgSQL+TLS

[Pascal Volk]

On 07/19/2011 08:54 AM Christian Roessner wrote:
> first of all thanks for your answer. After reading the documentation, I
> end up in a problem:
> 
> Jul 19 08:31:52 mx0 dovecot: imap(de10015 at service.intern): Fatal:
> Unknown ACL backend: pgsql

,--[ http://wiki2.dovecot.org/ACL ]--
| … but currently Dovecot supports only virtual ACL files. …
`--

> Am I pgsql missing?
> 
> ldd /usr/lib/dovecot/imap
> 	linux-gate.so.1 =>  (0x00e94000)
> 	libdovecot-storage.so.0 => /usr/lib/dovecot/libdovecot-storage.so.0
> (0x00161000)
> 	libdovecot.so.0 => /usr/lib/dovecot/libdovecot.so.0 (0x00760000)
> 	libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0x00110000)
> 	librt.so.1 => /lib/tls/i686/cmov/librt.so.1 (0x00b2c000)
> 	libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x00220000)
> 	/lib/ld-linux.so.2 (0x00acd000)
> 	libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x00114000)

No, imap doesn't communicate with your database host.

> I can not see it here, but:
> 
> ldd dict
> 	…
> 	libpq.so.5 => /usr/lib/libpq.so.5 (0x00304000)
>       …
> has libpq.so. I have these configure options in my debian/rules file:

Yes, dictionaries can be stored in sql backends.

>         ./configure --with-ldap \
>                     --with-ssl=openssl \
>                     --with-pgsql \
>                     --with-mysql \
>                     --with-sqlite \
>                     --with-gssapi \
>                     --with-ioloop=best \
>                     --host=$(DEB_HOST_GNU_TYPE) \
>                     --build=$(DEB_BUILD_GNU_TYPE) \
>                     --prefix=/usr \
>                     --sysconfdir=/etc \
>                     --libexecdir=\$${prefix}/lib \
>                     --localstatedir=/var \
>                     --mandir=\$${prefix}/share/man \
>                     --infodir=\$${prefix}/share/info \
>                     --with-moduledir=\$${prefix}/lib/dovecot/modules

You could remove --with-mysql and --with-sqlite when you are using ldap
and pgsql only.

> My dovecot installation is completely bound to OpenLDAP. The only
> exception is ACL, where I want to use PostgreSQL. I tried adding
> something like "driver=pgsql" to the plugin section, but this does
> nothing. So what am I missing here?

See the web page mentioned above.


Regards,
Pascal
-- 
The trapper recommends today: fabaceae.1120021 at localdomain.org