Is it possible that the reason is as simple as mysql vs mysqli?
If I cant get this figured out is there a way to uninstall and reinstall roundcube with reinstalling cwp?
just check the Roundcube config /usr/local/cwpsrv/var/services/roundcube/config/config.inc.php
Probably, you have an incorrect username/password.