alias from exim database

[sayajin]

Hi,

i would like to know, where would i be able to specify the alias so that it can link to a different database, cause currently the way it sets the email address is {username}@mail.{hostname}.co.za, which is deff the incorrect email address, and i have many different domains that i host.

so i want roundcube to pull the "local_part"@"domain" in table "emailtable"
and the username from "box" in table "emailtable".

now it can do this only on 1st login or everytime some1 logs in,
if it happens only on 1st login, then it must copy the data from the above tables to its own "username" & "alias" tables.

regards

[JohnDoh]

if you are using 0.3 or above have you tried the virtuser_query plugin, it sounds like thats what you want.

[sayajin]

ok, the virtuser plugin looks what, i want,

i added this into the virtuser_query.php

Code Select Expand

$rcmail_config['virtuser_query'] = "SELECT CONCAT(local_part, '@', domain) AS \"email\", user AS \"name\" FROM email.emailtable WHERE box = '%u' AND  Lower(is_enabled) = 'yes'";

but when i try login with the full email address im still getting this error:

Code Select Expand

IMAP Error: Authentication for [email protected] failed (LOGIN): "a001 NO Login failed." in /path/to/roundcubemail/program/include/rcube_imap.php on line 141 (POST /?_task=&_action=login)
am i doing something wrong? has something changed?

i am using the latest release of roundcube 0.4-beta

regards.

[sayajin]

*bump*

it would really be nice to get this resolved, and im sure we are very close