Hi, Alvaro.
Thanks for asking.
Here is the MySQL stuff:
### Start SQL Dump ###
CREATE TABLE IF NOT EXISTS `auth_users` (
`username` varchar(32) NOT NULL default '',
`password` varchar(32) default NULL,
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii;
INSERT INTO `auth_users` (`username`, `password`) VALUES
('cherokee', 'cherokee');
### End SQL Dump ###
Here is the SQL query:
SELECT password FROM auth_users WHERE username = '${user}'
Regards,
Rick
-----Original Message-----
From: Alvaro Lopez Ortega <[email protected]>
To: [email protected]
Cc: [email protected]
Sent: Sat, Jun 19, 2010 1:40 pm
Subject: Re: [Cherokee] Authentication from database
Hi there,
I have just made a test, and everything seems to be working alright:
--------
alidator_mysql.c:0178 ( init_mysql_connection): Connected to
localhost:3306)
validator.c:0144 (cherokee_validator_parse_basic): Parse basic auth got
ser=alo, passwd=12tres45
validator_mysql.c:0259 (cherokee_validator_mysql_check): Query: SELECT password
ROM usuarios WHERE login = 'alo'
validator_mysql.c:0325 (cherokee_validator_mysql_check): Access to user alo has
een granted
-------
Could you please paste you user table structure along with the SQL query you
are
sing?
cheers,
On 17/06/2010, at 02:36, [email protected] wrote:
> I tried very carefully to follow the steps in the links below, but when a
> user
rovides a good username and password they get an error: "500 Internal Server
rror". Am I missing a step? Is there a log that would explain the error? I
on't get this error with other types of authentication, just MySQL.
Here are the directions that I followed, but that give the error.
http://www.cherokee-project.com/doc/cookbook_authentication.html
http://www.cherokee-project.com/doc/modules_validators_mysql.html
-----Original Message-----
From: Stefan de Konink <[email protected]>
To: [email protected]
Sent: Wed, Jun 16, 2010 4:22 pm
Subject: Re: [Cherokee] Authentication from database
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Op 16-06-10 12:39,
[email protected]
schreef:
> Could you please help me find documentation on how to get Cherokee
> to authenticate a user against a MySQL database?
>
> These links do not explain this, or at least I am missing something
> because I cannot get it to work!
>
http://www.cherokee-project.com/doc/cookbook_authentication.html
>
http://www.cherokee-project.com/doc/modules_validators_mysql.html
>
> Thank you helping if you get the chance.
What did you try, and what doesn't work :)
Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.15 (GNU/Linux)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org/
iEYEAREKAAYFAkwZJIwACgkQYH1+F2Rqwn1yqgCfYJFoycHGp4TSdVDr2UAwxmMR
r4EAnijSHAJlUitKk1qETMxWQbWIy1b5
=yEYC
-----END PGP SIGNATURE-----
_______________________________________________
Cherokee mailing list
[email protected]
http://lists.octality.com/listinfo/cherokee
_______________________________________________
Cherokee mailing list
[email protected]
http://lists.octality.com/listinfo/cherokee
--
ctality
ttp://www.octality.com/
_______________________________________________
Cherokee mailing list
[email protected]
http://lists.octality.com/listinfo/cherokee
