Comments on How to Password-Protect Directories with mod_authn_dbd and MySQL on Apache (Debian 8)

This guide explains how to password-protect web directories (with users from a MySQL database) with mod_authn_dbd on Apache2 on a Debian 8 (Jessie) server. It is an alternative to the plain-text password files provided by mod_auth and allows you to use normal SQL syntax to create/modify delete users.

5 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Flo

Hey,Was muss ich machen, wenn ich eine neue Tabell "groups" anlegen und dort die Gruppenmitglieder speicher möchte? Welche Einstellungen muss ich dann vornehmen?Grüße,Flo

 

By: Igor

Not be authenticated, simply entry on directory, why?

By: Pippo Pippuzzo

How to do it without that terrible popup? Is it possible to use this auth method with auth_form?

By: Adrian

authn_socache was not found as command and syslog says:

Can't load driver file apr_dbd_mysql.so

How i can solve this problem?

By: as

Hi,

this doesn't work in mysql 8 because 'groups' is reserved word https://dev.mysql.com/doc/refman/8.0/en/keywords.html

create table mysql_auth (username varchar(255) not null,passwd varchar(255),groups varchar(255),primary key (username));