Roundcube Community Forum

 

Refreshing Identities with virtuser_query

Started by mailaddict, April 17, 2009, 01:55:12 PM

Previous topic - Next topic

mailaddict

Hi all,

When I first tried RoundCube (0.2.1) on our server, I knew that this will replace the annoying Confixx WebMail Interface.

The setup is: Accounts and identities are managed by Confixx 3.
Current state is: A user is created on first login and all current identities are created.

I have set the "virtuser_query" preference, which is:
$rcmail_config['virtuser_query'] = 'SELECT concat( prefix, &quot;@&quot;, domain ) AS address FROM confixx.email, confixx.email_forward WHERE ident = email_ident AND pop3 = &quot;%u&quot; AND prefix <> &quot;*&quot;;';

This works perfect so far. On first login, all Confixx identities are created in the RoundCube database.

The problem is now: The identities are not refreshed. When I create or delete a mail alias in the Confixx configuration the RoundCube database gets out of sync.

It would be nice if the virtuser_query is repeated on every RoundCube login and identies are updated. Is there any way to do this?

Also, I have set:
// Set identities access level:
// 0 - many identities with possibility to edit all params
// 1 - many identities with possibility to edit all params but not email address
// 2 - one identity with possibility to edit all params
// 3 - one identity with possibility to edit all params but not email address
$rcmail_config['identities_level'] = 1;


This prevents the user from changing the email-address of an existing identity, but he is still allowed to create or delete identities.

The goal is to let the identities always be automatically created and deleted (based on Confixx configuration), but be able to edit identity data (except of mail address).

Any ideas / hints?

Thanks, mailaddict

foxx

I'm using Roundcube 0.3.1 and have the same question as mailaddict. It would be nice to have a sync like this...

Thank you in advance!