incorrect username or password in blog tutorial

Yii 1.1 General Discussion
1

I have follow the blog tutorial in yii doc in authentication user part.

I have problem can not login in login page, the result is incorrect username and password.

but, when I try in demo, it can login, try to compare code, I have found nothing.

what I missing?

my log :

15:10:43.927642 trace system.CModule

Loading "log" application component

in /var/www/blog/index.php (13)

15:10:43.928339 trace system.CModule

Loading "request" application component

in /var/www/blog/index.php (13)

15:10:43.928757 trace system.CModule

Loading "urlManager" application component

in /var/www/blog/index.php (13)

15:10:43.931794 trace system.CModule

Loading "db" application component

in /var/www/blog/protected/models/User.php (25)

in /var/www/blog/protected/components/UserIdentity.php (41)

in /var/www/blog/protected/models/LoginForm.php (52)

15:10:43.932158 trace system.db.CDbConnection

Opening DB connection

in /var/www/blog/protected/models/User.php (25)

in /var/www/blog/protected/components/UserIdentity.php (41)

in /var/www/blog/protected/models/LoginForm.php (52)

15:10:43.946335 trace system.db.CDbCommand

Querying SQL: SHOW COLUMNS FROM blog.tbl_user

in /var/www/blog/protected/models/User.php (25)

in /var/www/blog/protected/components/UserIdentity.php (41)

in /var/www/blog/protected/models/LoginForm.php (52)

15:10:43.947499 trace system.db.CDbCommand

Querying SQL: SHOW CREATE TABLE blog.tbl_user

in /var/www/blog/protected/models/User.php (25)

in /var/www/blog/protected/components/UserIdentity.php (41)

in /var/www/blog/protected/models/LoginForm.php (52)

15:10:43.947846 trace system.db.ar.CActiveRecord

User.find()

in /var/www/blog/protected/components/UserIdentity.php (41)

in /var/www/blog/protected/models/LoginForm.php (52)

in /var/www/blog/protected/controllers/SiteController.php (88)

15:10:43.948179 trace system.db.CDbCommand

Querying SQL: SELECT * FROM blog.tbl_user t WHERE LOWER(username)=?

LIMIT 1

in /var/www/blog/protected/components/UserIdentity.php (41)

in /var/www/blog/protected/models/LoginForm.php (52)

in /var/www/blog/protected/controllers/SiteController.php (88)

15:10:43.948607 trace system.CModule

Loading "widgetFactory" application component

in /var/www/blog/protected/views/site/login.php (19)

in /var/www/blog/protected/controllers/SiteController.php (92)

in /var/www/blog/index.php (13)

15:10:43.949393 trace system.CModule

Loading "coreMessages" application component

in /var/www/blog/protected/views/site/login.php (26)

in /var/www/blog/protected/controllers/SiteController.php (92)

in /var/www/blog/index.php (13)

15:10:43.950234 trace system.CModule

Loading "clientScript" application component

in /var/www/blog/protected/views/site/login.php (48)

in /var/www/blog/protected/controllers/SiteController.php (92)

in /var/www/blog/index.php (13)

15:10:43.951128 trace system.CModule

Loading "user" application component

in /var/www/blog/protected/views/layouts/main.php (34)

in /var/www/blog/protected/views/layouts/column1.php (7)

in /var/www/blog/protected/controllers/SiteController.php (92)

15:10:43.951307 trace system.CModule

Loading "session" application component

in /var/www/blog/protected/views/layouts/main.php (34)

in /var/www/blog/protected/views/layouts/column1.php (7)

in /var/www/blog/protected/controllers/SiteController.php (92)

15:10:43.952167 trace system.CModule

Loading "assetManager" application component

in /var/www/blog/protected/controllers/SiteController.php (92)

in /var/www/blog/index.php (13)

2

If it say incorrect username and password… you should check that you are entering a username that exists in tbl_user…

3

Also, if you have typed in the code (instead of copy/pasting it), make sure you typed the return statement as:


return $this->errorCode == self::ERROR_NONE;

… as opposed to


return $this->errorCode = self::ERROR_NONE;

That one has bit me when I followed the tutorial.

4

[SOLVED]

thanks mdomba and jodev for solution.

My mistake is

public function hashPassword($password,$salt)

{

return md5($salt,$password);

}

should be

public function hashPassword($password,$salt)

{

return md5($salt.$password);

}

you know what? so amazing this little mark, can bang my head 1 day 1 night.

5

Thanks for posting your solution. I made the same mistake and this helped me.