Changeset 1824

Timestamp:

08/14/08 17:47:59 (3 months ago)

Author:

taher

Message:

Files:

cherokee/trunk/doc/Makefile.am

r1821	r1824
118	118	media/images/cookbook_ror_common.png \
119	119	media/images/cookbook_ror_fcgi.png \
	120	media/images/cookbook_mysql_rule.png \
	121	media/images/cookbook_mysql_validator.png \
120	122	media/images/tracelor.png
121	123

r1823	r1824
103	103
104	104
	105	=== MySQL
	106
	107	Lets set up a simple server requiring authentication against a MySQL
	108	database to fetch any content.
	109
	110	First, lets define a unique rule in our virtual server managed by the
	111	`List and Send` handler. Through the `Security` tab we can configure
	112	it to use MySQL as authentication mechanism. Filling up just the
	113	essential fields will be enough. Realm, database name, user, password
	114	and an SQL query that must return one row with one column as password.
	115
	116	image::media/images/cookbook_mysql_validator.png[MySQL handler set up]
	117
	118	In this case, we have used:
	119
	120	----
	121	SELECT password FROM auth_users WHERE username = '${user}'
	122	----
	123
	124	And that is about it.
	125	In this example you will need a MySQL server running (localhost in
	126	this case, as it takes the default value), a database called
	127	`cherokee` with `cherokee` as user and password, and a table that
	128	suits the shown query.
	129
	130	When we are done, our simple virtual server should look like this:
	131
	132	image::media/images/cookbook_mysql_rule.png[MySQL Authenticated rule]
	133
	134	And any content requested to Cherokee will require prior
	135	authentication agains the database.
	136
105	137	////
106
107		~~=== MySQL~~
108	138	To be written
109		Details for mysql and ldap, with screenshots.
	139	More details for mysql and ldap, with screenshots.
110	140	////