# Login generator ALWAYS says login unseccesfull **URL:** \ **Category:** Rails\ **Created:** [May 5, 2006, 12:19am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645 "2006-05-05T00:19:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![mohammad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@mohammad](https://www.ruby-forum.com/u/mohammad)\ **Post date:** [May 5, 2006, 12:19am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645/1 "2006-05-05T00:19:42Z")
Hey I just ran this “ruby script/generate login loging\_in” here is my SQL: CREATE TABLE `users` ( `id` int(11) NOT NULL auto\_increment, `user_name` varchar(80) default NULL, `login` varchar(120) NOT NULL default ‘’, `last_update` timestamp NOT NULL default ‘0000-00-00 00:00:00’, `last_attack` timestamp NOT NULL default ‘0000-00-00 00:00:00’, `password` varchar(40) default NULL, `points` int(30) NOT NULL default ‘0’, `activated` int(1) NOT NULL default ‘0’, `a_key` int(6) NOT NULL default ‘0’, `email` varchar(100) NOT NULL default ‘’, `xw` int(100) NOT NULL default ‘0’, `w` int(100) NOT NULL default ‘0’, `m` int(100) NOT NULL default ‘0’, `l` int(100) NOT NULL default ‘0’, `xl` int(100) NOT NULL default ‘0’, `s` int(100) NOT NULL default ‘0’, `ss` int(100) NOT NULL default ‘0’, `created_on` timestamp NOT NULL default ‘0000-00-00 00:00:00’, `ds` int(3) NOT NULL default ‘0’, `dm` int(3) NOT NULL default ‘0’, `dl` int(3) NOT NULL default ‘0’, `dss` int(3) NOT NULL default ‘0’, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO\_INCREMENT=7 ; I don’t know why it dosn’t work for some reasson any one know why? ---
**Author:** ![mohammad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@mohammad](https://www.ruby-forum.com/u/mohammad)\ **Post date:** [May 5, 2006, 12:30am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645/2 "2006-05-05T00:30:21Z")
The schema of your table isn’t all that helpful. Are you getting an error message? What does your development.log say? ~ Ben On 5/4/06, Mohammad [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > `activated` int(1) NOT NULL default ‘0’, > `ds` int(3) NOT NULL default ‘0’, > Rails mailing list > removed\_email\_address@domain.invalid > [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) – Ben R. 303-947-0446 [http://www.benr75.com](http://www.benr75.com) ---
**Author:** ![mohammad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@mohammad](https://www.ruby-forum.com/u/mohammad)\ **Post date:** [May 5, 2006, 12:38am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645/3 "2006-05-05T00:38:12Z")
No error messages, here is the log: Processing LogingInController#login (for 127.0.0.1 at 2006-05-04 17:11:30) [POST] Session ID: ad46b855212634e8c02524588dc654d7 Parameters: {“user\_login”=\>“admin”, “action”=\>“login”, “controller”=\>“loging\_in”, “user\_password”=\>“secret”, “login”=\>“Login \302\273”} e[4;35;1mUser Load (0.000000)e[0m e[0mSELECT \* FROM users WHERE (login = ‘admin’ AND password = ‘3042a0c5cf8d4d2b5900d2a2ad869fb679870dac’) LIMIT 1e[0m Rendering within layouts/scaffold Rendering loging\_in/login Completed in 0.02000 (50 reqs/sec) | Rendering: 0.01000 (50%) | DB: 0.00000 (0%) | 200 OK [[http://127.0.0.1/loging\_in/login](http://127.0.0.1/loging_in/login)] ---
**Author:** ![mohammad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@mohammad](https://www.ruby-forum.com/u/mohammad)\ **Post date:** [May 5, 2006, 12:43am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645/4 "2006-05-05T00:43:19Z")
No no edits. ---
**Author:** ![mohammad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@mohammad](https://www.ruby-forum.com/u/mohammad)\ **Post date:** [May 5, 2006, 1:01am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645/5 "2006-05-05T01:01:13Z")
Do you have a User that matches the SQL where clause? If you don’t the login will always fail as no User is returned. WHERE (login = ‘admin’ AND password = ‘3042a0c5cf8d4d2b5900d2a2ad869fb679870dac’) On 5/4/06, Mohammad [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > No no edits. > > – > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/). > > * * * > > Rails mailing list > removed\_email\_address@domain.invalid > [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) – Ben R. 303-947-0446 [http://www.benr75.com](http://www.benr75.com) ---
**Author:** ![mohammad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@mohammad](https://www.ruby-forum.com/u/mohammad)\ **Post date:** [May 5, 2006, 1:12am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645/6 "2006-05-05T01:12:27Z")
yup ---
**Author:** ![mohammad](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e274bd/32.png) [@mohammad](https://www.ruby-forum.com/u/mohammad)\ **Post date:** [May 5, 2006, 12:42am UTC](https://www.ruby-forum.com/t/login-generator-always-says-login-unseccesfull/59645/7 "2006-05-05T00:42:43Z")
SELECT \* FROM users WHERE (login = ‘admin’ AND password = ‘3042a0c5cf8d4d2b5900d2a2ad869fb679870dac’) Hmm… Are you writing your own sql for this? Login generator should just select out the User with the corresponding login and then use some methods in the Model for checking the password. ~ Ben On 5/4/06, Mohammad [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Rendering within layouts/scaffold – Ben R. 303-947-0446 [http://www.benr75.com](http://www.benr75.com)