I hope someone out there can help me. This is driving me nuts...and it is humbling, too.
I just installed tikiwiki 3.1 on a CentOS 5.2 box. I cannot log in except to reset the password. I reset the password, and try to log in with the new pasword...nothing. I created another user, same issue. I can log in through the reset email, and that is it. If I were to disable that, I am afraid I'd be out of luck.
My setup is pretty vanilla: nothing kinky, honest. I am using CentOS 5.2, tikiwiki 3.1, php 5.1.6, mysql 5.0.45, apache 2.2.3. I am using Tiki authentication, only. I have php set in php.ini to log every error in /var/log--nothing. Like I said, the only way I can log in is if I reset the password, and log in through the email I receive.
Today, I started fresh, a totally new database, totally new tikiwiki install. The tikiuser in mysql has been granted all for the tikidb. The install went flawlessly with no errors.