Hello,
I am struggling with v2.20. It compiled and loaded
flawlessly on a FBSD 5.4-STABLE SMP (dual CPU)
server running:
Apache/1.3.33 Ben-SSL/1.55 (Unix) mod_gzip/1.3.26.1a
PHP/4.4.0 AuthMySQL/2.20.
As you can see by the Apache output it loads as
one would expect. However, the documentation
that came with my copy, while very complete
regarding the module directives, provides very
little with regard to it's usage in Apache. There is
an example for .htpasswd but it is the same *file*
*based* example that comes with the Apache doc-
umentation. Further, there are other caveats using
.htpasswd, so it's application will not be useful.
The only reference to mod_auth_mysql's usage in
httpd.conf indicates that I need to read the Apache
documentation on Authentication. The docu-
mentation comes with Apache 1.3.x makes
reference and provides an example for only one
type of database - Berkeley, (mod_auth_db).
This, as many of you already know, is a *file*
*based* database. So I am unable to under-
stand how this might be of use to anyone using
MySQL.
My interest here is to use mod_auth_mysql on a
directory based level. I am building a web based
user management system. The usual httpd.conf
directives are:
<Directory "/path/to/protected/directory">
Options Indexes FollowSymlinks MultiViews
AllowOverride AuthConfig
Order allow,deny
Allow from all
</Directory>
How on earth can I use mod_auth_mysql here?!
Thank you very much for all your time and
consideration in this matter.
--Chris
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Jerry,
Thank you *very* much for your response. Now,
as you might imagine, I am more confused than
ever ( mod_auth_mysql != mod_auth_mysql ).
But unlike the one I have compiled and installed,
the one here seems to have documentation and
support. I think I'll remove the one I have installed
and use yours. Anything I should know for my for
my box/ setup?
Thanks again.
--Chris
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello again,
Update; I uninstalled the version I was running
and discovered that your version, labeled:
mod_mysql_another is located in the ports tree
on FBSD. It is version 2.9. I installed it/ enabled it
and started Apache which resulted in:
Syntax error on line 281 of /usr/local/etc/apache/httpsd.conf:
Cannot add module via name 'mod_mysql_auth.c': not in list of loaded modules
/usr/local/sbin/httpsdctl start: httpsd could not be started
I know that order (placement) is important with
modules and have everything in the correct order.
But to no avail; mod_mysql_auth.c will not load.
So this module doesn't appear to be compatible
with Apache-1.3.33 on a FBSD 5.4 server. Are
there any other similar modules that you are
aware of that will work w/ Apache-1.3.33 on a
FBSD 5.4 box?
Thank you.
--Chris
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As to the name - yes, there are multiple modules named mod_auth_mysql out there. But I guess that's understandable, because other modules are mod_auth, mod_auth_anon, mod_auth_dbm, etc. So mod_auth_mysql is a pretty "normal" extension of what's already available.
No other "gotchas" that I know of, anyway. Just ensure you read the doc shipped with the module.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I am struggling with v2.20. It compiled and loaded
flawlessly on a FBSD 5.4-STABLE SMP (dual CPU)
server running:
Apache/1.3.33 Ben-SSL/1.55 (Unix) mod_gzip/1.3.26.1a
PHP/4.4.0 AuthMySQL/2.20.
As you can see by the Apache output it loads as
one would expect. However, the documentation
that came with my copy, while very complete
regarding the module directives, provides very
little with regard to it's usage in Apache. There is
an example for .htpasswd but it is the same *file*
*based* example that comes with the Apache doc-
umentation. Further, there are other caveats using
.htpasswd, so it's application will not be useful.
The only reference to mod_auth_mysql's usage in
httpd.conf indicates that I need to read the Apache
documentation on Authentication. The docu-
mentation comes with Apache 1.3.x makes
reference and provides an example for only one
type of database - Berkeley, (mod_auth_db).
This, as many of you already know, is a *file*
*based* database. So I am unable to under-
stand how this might be of use to anyone using
MySQL.
My interest here is to use mod_auth_mysql on a
directory based level. I am building a web based
user management system. The usual httpd.conf
directives are:
<Directory "/path/to/protected/directory">
Options Indexes FollowSymlinks MultiViews
AllowOverride AuthConfig
Order allow,deny
Allow from all
</Directory>
How on earth can I use mod_auth_mysql here?!
Thank you very much for all your time and
consideration in this matter.
--Chris
Chris,
I'm sorry, but this is not our module that you are using. This is mod_auth_mysql, not AuthModMySQL. Additionally, we never had a 2.20 version.
I'm sorry we won't be able to help you with your module.
Jerry
Jerry,
Thank you *very* much for your response. Now,
as you might imagine, I am more confused than
ever ( mod_auth_mysql != mod_auth_mysql ).
But unlike the one I have compiled and installed,
the one here seems to have documentation and
support. I think I'll remove the one I have installed
and use yours. Anything I should know for my for
my box/ setup?
Thanks again.
--Chris
Hello again,
Update; I uninstalled the version I was running
and discovered that your version, labeled:
mod_mysql_another is located in the ports tree
on FBSD. It is version 2.9. I installed it/ enabled it
and started Apache which resulted in:
Syntax error on line 281 of /usr/local/etc/apache/httpsd.conf:
Cannot add module via name 'mod_mysql_auth.c': not in list of loaded modules
/usr/local/sbin/httpsdctl start: httpsd could not be started
I know that order (placement) is important with
modules and have everything in the correct order.
But to no avail; mod_mysql_auth.c will not load.
So this module doesn't appear to be compatible
with Apache-1.3.33 on a FBSD 5.4 server. Are
there any other similar modules that you are
aware of that will work w/ Apache-1.3.33 on a
FBSD 5.4 box?
Thank you.
--Chris
Chris,
Your problem is the line shoud be:
LoadModule mysql_auth_module mod_auth_mysql.so.
It does run under Apache 1.3.x.
As to the name - yes, there are multiple modules named mod_auth_mysql out there. But I guess that's understandable, because other modules are mod_auth, mod_auth_anon, mod_auth_dbm, etc. So mod_auth_mysql is a pretty "normal" extension of what's already available.
No other "gotchas" that I know of, anyway. Just ensure you read the doc shipped with the module.
Jerry