Hi Marco,
I cheat by doing:
user_query = SELECT '/mailboxes/%d/%n' as home, uid, gid FROM users WHERE username = '%u'
I'm using MySQL, but I think the postgresql should be the same.
Regards Andrew
Marco Herrn wrote:
Hi,
I am using postgresql for my password and user databases. The problem is, that the information needed in the user database is held in more than one table. But it seems to me that dovecot expects to get all the information for mailbox, uid, gid and home in _one_ query. Is there a way to get around this? Maybe even getting some of this information by another way than pgsql (this is more a rethorical question, since I have this information in the DB, but sometimes it is useful to get, for example the location of the mailbox by another way than the uid and gid).
But my primary question is if I can set these fields in different queries.
Regards Marco
-- Andrew Hutchings Systems Operator / Developer / Linux Guru Netserve Consultants Ltd. http://www.domaincity.co.uk/