[php] htaccess mit MySQL

[michab]

>Hallo,
>
>weiss jemand, wie ein htaccess Passwortschutz mit MySQL
>realiesert werden kann? Oder besser gibt es ein fertiges=
 Script?
>
>Gruesse
>
>Heinrich
>

hi.. du brauchst  "mod_auth_mysql".... dann wie folgt:

shell >> 

/usr/sbin/apxs -i -a -I/usr/include/mysql -L/usr/lib/mysql=
 -lmysqlclient -c mod_auth_mysql.c 

Apache Conf >> 

LoadModule mysql_auth_module  /usr/lib/apache/mod_auth_mysql.so 
AddModule mod_auth_mysql.c 

HTACCESS >> 

AuthName My_Authorization 
AuthType Basic 
AuthMySQLUser mod_auth 
AuthMySQLPassword mod_auth 
AuthMySQLNameField user_name 
AuthMySQLPasswordField user_passwd 
AuthGroupFile /dev/null 
AuthMySQLHost localhost 
AuthMySQLCryptedPasswords Off 
AuthMySQLKeepAlive On 
AuthMySQLDB auth_mysql 
AuthMySQLUserTable user_info 
AuthMySQLGroupField user_group 
AuthMySQLNoPasswd Off 
require valid-user 

DB_DUMP >> 

# MySQL Dump
# 

USE auth_mysql; 

# 
# Table structure for table 'user_group' 
# 

CREATE TABLE /*!32312 IF NOT EXISTS*/ user_group ( 
 user_name char(50) NOT NULL DEFAULT '' , 
 user_group char(20) NOT NULL DEFAULT '' , 
 create_date int(11) , 
 expire_date int(11) , 
 PRIMARY KEY (user_name,user_group) 
); 

# 
# Table structure for table 'user_info' 
# 

CREATE TABLE /*!32312 IF NOT EXISTS*/ user_info ( 
 user_name char(30) NOT NULL DEFAULT '' , 
 user_passwd char(20) NOT NULL DEFAULT '' , 
 user_group char(10) , 
 PRIMARY KEY (user_name) 
); 


gr=FCsse,
micha