I'm using Apache/1.3.33 (Debian GNU/Linux) and PHP/4.3.11 and the latest (3.0) mod_auth_mysql. The database that we use to authenticate is located on a different server. Everything works (in the sense that Apache loads/runs fine) until I add the line AuthMySQLPwTable <table_name> to the .htaccess and I get the following error in my apache logs:
Invalid command 'AuthMySQLPwTable', perhaps mis-spelled or defined by a module not included in the server configuration
If I leave that directive out, the browser will ask for authentication, but a valid authentication name/pass will not work and I see this error in the apache logs:
MySQL ERROR: Table 'http_auth.user_info' doesn't exist:
We are using the tablename mysql_auth to store the info.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please see the CONFIGURE file. The correct statement is
AuthMySQLUserTable
Also - I would personally be interested in the performance in having the database on another system. Performance has been a problem in some very heavily loaded systems. We're working on a way to improve performance, but haven't gotten there yet.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using Apache/1.3.33 (Debian GNU/Linux) and PHP/4.3.11 and the latest (3.0) mod_auth_mysql. The database that we use to authenticate is located on a different server. Everything works (in the sense that Apache loads/runs fine) until I add the line AuthMySQLPwTable <table_name> to the .htaccess and I get the following error in my apache logs:
Invalid command 'AuthMySQLPwTable', perhaps mis-spelled or defined by a module not included in the server configuration
If I leave that directive out, the browser will ask for authentication, but a valid authentication name/pass will not work and I see this error in the apache logs:
MySQL ERROR: Table 'http_auth.user_info' doesn't exist:
We are using the tablename mysql_auth to store the info.
Ian,
Please see the CONFIGURE file. The correct statement is
AuthMySQLUserTable
Also - I would personally be interested in the performance in having the database on another system. Performance has been a problem in some very heavily loaded systems. We're working on a way to improve performance, but haven't gotten there yet.
Jerry
oops! i was pulling this information from the BUILD file instead. thanks for pointing that out to me.
as far as performance goes, the system that is using the remote db isn't heavily used, so we've had no real load/lag issues.
Ian,
I looked at the BUILD file, and you're correct. There is a problem here!
I'll change the BUILD file for the next release. I'll also change the compile parameter to USERTABLE instead of PWTABLE for consitency.
Thanks for letting me know about this error.
Jerry