I''m having a similar problem running Radiant CMS. I set ROR and the
mysql database as instructed but when I try to login with the default
admin login I get the same result as Mohammed. Below is the output from
my log, which is very similar to what he is seeing, along with what I
believe is the hashed password stored in MySQL. The two values don''t
match. I don''t have the mysql bindings for Ruby on this machine and
also
don''t have the gem installed for mysql. I''m trying to install
it but I''m
missing all the things the install is checking for. I''d like to get
this
working so any guidance would be very much appreciated.
Rick
Processing WelcomeController#login (for 127.0.0.1 at 2006-05-03 22:56:15) [POST]
Session ID: c9ac7164c46237a5ff0ef6556a869d5b
Parameters: {"user"=>{"login"=>"admin",
"password"=>"radiant"},
"commit"=>"Login",
"action"=>"login","controller"=>"admin/welcome"}
User Columns (0.001630) SHOW FIELDS FROM users
User Load (0.001413) SELECT * FROM users WHERE (users.`login` =
''admin'' AND users.`password` =
''ba3043ba889540e17d38da8532f4f84eb0d53843'' ) LIMIT 1
Rendering within layouts/application
Rendering admin/welcome/login
Hash stored in Mysql database f37194f74a42f4b41b0eaefb598952e2ffd5dd77
rails-request@lists.rubyonrails.org wrote:> Message: 4
> Date: Fri, 5 May 2006 00:19:42 +0200
> From: Mohammad <name.goes.here44@gmail.com>
> Subject: [Rails] Login generator ALWAYS says login unseccesfull
> To: rails@lists.rubyonrails.org
> Message-ID: <6a537d96f327bc47e14432cef0cc3c58@ruby-forum.com>
> Content-Type: text/plain; charset=utf-8
>
> 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?
>
>