Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: sayajin on June 22, 2010, 06:30:22 AM

Title: alias from exim database
Post by: sayajin on June 22, 2010, 06:30:22 AM
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
Title: alias from exim database
Post by: JohnDoh on June 23, 2010, 03:26:27 AM
if you are using 0.3 or above have you tried the virtuser_query plugin, it sounds like thats what you want.
Title: alias from exim database
Post by: sayajin on June 24, 2010, 07:03:54 AM
ok, the virtuser plugin looks what, i want,

i added this into the virtuser_query.php

$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:
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.
Title: alias from exim database
Post by: sayajin on June 29, 2010, 04:11:02 PM
*bump*

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