I'm trying to use the system to restrict access to folders and there are 3 tables in the database which have been specified in the AuthMySQLUserTable
Basically user_login and project_detail store the users and folders whilst user_access is a lookup table between the 2 tables and I have successfully joined the tables using the following details:
I'm now trying to use the path of the request to limit the access by using %U but I can't seem to match the query correctly, please could supply some further information about how this part of the module works.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You can specify different parameters for each directory, either in your httpd.conf or a .htaccess file in that directory.
When you specify parameters. Apache first looks for settings for the current dirctory. This overrides anything else. If not found for the current directory, Apache looks in parent directories, all the back to the DOCUMENT ROOT directory.
So the way to protect different directories is to use multiple settings in your httpd.conf file, or multiple .htaccess files in the appropriate places.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
I'm trying to use the system to restrict access to folders and there are 3 tables in the database which have been specified in the AuthMySQLUserTable
Basically user_login and project_detail store the users and folders whilst user_access is a lookup table between the 2 tables and I have successfully joined the tables using the following details:
AuthMySQLUserTable "user_login, user_access, project_detail"
AuthMySQLUserCondition "user_login.id = user_access.user_login_id AND user_access.project_detail_id = project_detail.id"
I'm now trying to use the path of the request to limit the access by using %U but I can't seem to match the query correctly, please could supply some further information about how this part of the module works.
Thanks
You shouldn't need to use the %U in this case.
You can specify different parameters for each directory, either in your httpd.conf or a .htaccess file in that directory.
When you specify parameters. Apache first looks for settings for the current dirctory. This overrides anything else. If not found for the current directory, Apache looks in parent directories, all the back to the DOCUMENT ROOT directory.
So the way to protect different directories is to use multiple settings in your httpd.conf file, or multiple .htaccess files in the appropriate places.