My roundcube install (only 24 hours old) is authenticating against my regular Linux user accounts. I use exim4 with virtual hosting as my smtp software.
However, roundcube stores settings, caches of emails, drafts, etc. in the database. Having only glanced over TFM, I'm not sure about it reading a different db to authenticate users, etc.