cannot log in via roundcube with virtual users (postfix/dovecot)

[neil@weblator]

Hi everyone, i'll try to keep this message short.

I have used roundcube a couple of times but this time i am having trouble. I have a setup which is fundamentally as described here:

http://workaround.org/articles/ispmail-etch/

Though I have altered the MySQL table structure a little. The system is working fine but I cannot log in via roundcube. My roundcube main.inc.php file includes:

// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '/etc/postfix/mysql-virtual-mailbox-maps.cf';

// Query to resolve user names and e-mail addresses from the database
// %u will be replaced with the current username for login.
// The query should select the user's e-mail address as first col
$rcmail_config['virtuser_query'] = 'select virtual_user_username from mailserver.virtual_user where virtual_user_username="%u" and virtual_user_active=1 and virtual_user_date_deleted="0000-00-00 00:00:00" limit 1';

which is a working query and the path to the user auth file for postfix.

I have looked at the various threads on here which are about the same issue but no-one seems to have a solution. Any ideas would be greatly appreciated!

I am more than willing to write some PHP code if needed, I am a web-developer and I use PHP by choice...

Thanks