.htaccess mit Authentifizierung an einer MySQL Datenbank (Drupal)
Submitted by floh on Mo, 2010-02-08 21:56
Htaccess mit Authentifizierung an einer MySQL basierten Drupal-Installation.
Installation des benötigten Apache Moduls
aptitude install libapache2-mod-auth-mysql
Aktivierung des authmysql-Moduls
a2enmod auth_mysql
Dieses Snippet in die jeweilige Apache-VirtualHost-Datei einfügen
<Directory /var/www/git>
AuthName "Authentication required"
AuthType Basic
require valid-user
AuthUserFile /dev/null
AuthBasicAuthoritative Off
Auth_MYSQL On
Auth_MySQL_Host mysqlhost
Auth_MySQL_User mysqluser
Auth_MySQL_Password mysqlpasswd
Auth_MySQL_DB drupaldb
Auth_MySQL_Authoritative On
Auth_MySQL_Password_Table users
Auth_MySQL_Encryption_Types PHP_MD5
Auth_MySQL_Encrypted_Passwords On
Auth_MySQL_Empty_Passwords Off
Auth_MySQL_Username_Field name
Auth_MySQL_Password_Field pass
</Directory>
AuthName "Authentication required"
AuthType Basic
require valid-user
AuthUserFile /dev/null
AuthBasicAuthoritative Off
Auth_MYSQL On
Auth_MySQL_Host mysqlhost
Auth_MySQL_User mysqluser
Auth_MySQL_Password mysqlpasswd
Auth_MySQL_DB drupaldb
Auth_MySQL_Authoritative On
Auth_MySQL_Password_Table users
Auth_MySQL_Encryption_Types PHP_MD5
Auth_MySQL_Encrypted_Passwords On
Auth_MySQL_Empty_Passwords Off
Auth_MySQL_Username_Field name
Auth_MySQL_Password_Field pass
</Directory>
Neustart des Apachen
/etc/init.d/apache2 restart
