virtuser_query does not work in roundcube 0.1.1

[monotek]

Is use roundcube a couple of months now and it worked like a charm.

Now i tried to get roundcube work with "virtuser_query" via connfixx 1.6 (premium) email table.

Therefore i gave the roundcube db user select rights on the confixx email table.

In main.inc.php i added:

Code Select Expand

$rcmail_config['virtuser_query'] = 'SELECT concat( prefix, "@", domain ) AS address FROM confixx.email WHERE pop3 = "%u" LIMIT 1';

If i execute this query via PHPMyadmin i get the email address shown like "[email protected]".

Unfortunately it does not work in roundcube.

The imap login works but if i send mail the from header is missing in the received mail. In roundcube (sent messages) the header has only a empty from.

Where is the error?

Is there a possibility to get debug output or something?