blob: eec557aa4a09f5750b5303279cb4db533cda0627 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
Notes from the author:
======================
Modified by Jaanus Toomsalu for using MYSQL userdirs
03. Sept. 2001
Configuration options
MyUserDirHost localhost - Mysql database host
MyUserDirSock /var/run/mysql/mysql.sock - Mysql Unix filesocket
if not present then database host option will be used
MyUserDirUser user - DB User
MyUserDirPass pass - DB User password
MyUserDirDB database _ DB name
MyUserDirTable table - DB table name
MyUserDirDirCol directory - directory column name
MyUserDirUserCol login - login column name
#MyUserDirLeftJoinCol - if needed
MyUserDirWhereCol "and enabled=1"
Notes from Anders:
==================
The module is successfully tested with this configuration:
MyUserDirSock /tmp/mysql.sock
MyUserDirUser sqluserdir
MyUserDirPass foo
MyUserDirDB sqlusers
MyUserDirTable sqlusers
MyUserDirDirCol directory
MyUserDirUserCol user
I had to disable the LoadModule and AddModule commands for the default Apache
mod_userdir to make mod_mysqluserdir work.
And a MySQL table crated like this:
CREATE TABLE sqlusers (
id int(13) NOT NULL auto_increment,
user varchar(50) NOT NULL default '',
directory varchar(50) NOT NULL default '',
enabled tinyint(3) NOT NULL default '1',
PRIMARY KEY (id)
);
INSERT INTO sqlusers VALUES (1,'anders','/home/anders',1);
|
