Zend_Auth: not working, getDbSelect() is empty

Answer 1

try and move the getDbSelect in the is valid statement, also i normally use

$userInfo = $this->auth->getResultRowObject();

to get the user info, never saw this getDbSelect method

Answer 2

oh i found out what i did wrong ...

the 1st try, i used Sqlite, and it does not support md5(?) treatment

the 2nd try, i specified wrong column names ... name vs username ...