I'm looking for someone with specific experience installing the latest version on a cPanel 10.x/CentOS 4.1/Apache 1.3.3 machine. cPanel tends to take over the box and mess up a lot of things regarding paths, permissions, and defaults so that might be the source of my problems...
I've installed this module a couple of times now and everything appears to go smoothly (compiles clean - installs clean) but any mention of auth_mysql in an .htaccess file throws an error:
Invalid command 'Auth_MYSQL', perhaps mis-spelled or defined by a module not included in the server configuration
I have followed the instructions in the BUILD file to the letter with the exception of:
It's mentioned in some docs but not in others. Apparently it's required for Apache 1.3.3 but it doesn't say where to put it. One article I came across someplace insisted that it has to go at the top of the "xxx.c" list or it would break htaccess altogether (confirmed) and another said to add it at the bottom.
Also, it seems like the default compile options set the module to be active all the time, but this needs to go on a busy production server with dozens of membership sites that use basic with the standard "passwds" file so I need it to load in the "off" condition. Any attempt at putting:
AuthMySQLEnable Off
anywhere in httpd.conf also throws an error. Can someone give me the EXACT syntax and the location where this line is supposed to go? (pretend I'm an idiot and talk slow ;)
Thanks. I've never installed an Apache module before and so far, I'm not the least bit impressed with my own abilities ... :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry, I can't help you much on the CPanel end. I know it changes things around a lot.
First of all, AddModule is an Apache 1.x statement; it's not required for Apache 2.x.
Your problem with the unrecognized statements is that it's AuthMySQLxxx, not Auth_Mysqlxxx. No underscore.
As for trying to disable it in the main part of the configuration file, Apache doesn't allow this. Authorization module statements can only be in <directory> sections or .htaccess files. However, you can disable it by default when you compile it; see the BUILD file for more information.
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
All cPanel servers run Apache 1.3.x so I still need to know where the AddModule statement goes - top or bottom of the list?
I'll try the different spelling in .htaccess. That's probably the biggest problem. :-)
I guess there really are two versions of this module running around because I can point to a hundred htaccess examples all over the web and Usenet that show it as Auth_MySQL...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There are multiple versions of this module running around. What you need to be looking at it the documentation which comes with the module! Other doc may be inaccurate.
As for the Addmodule statement - it shouldn't matter that much where it goes. The module should not be dependent on other modules.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm looking for someone with specific experience installing the latest version on a cPanel 10.x/CentOS 4.1/Apache 1.3.3 machine. cPanel tends to take over the box and mess up a lot of things regarding paths, permissions, and defaults so that might be the source of my problems...
I've installed this module a couple of times now and everything appears to go smoothly (compiles clean - installs clean) but any mention of auth_mysql in an .htaccess file throws an error:
Invalid command 'Auth_MYSQL', perhaps mis-spelled or defined by a module not included in the server configuration
I have followed the instructions in the BUILD file to the letter with the exception of:
LoadModule mysql_auth_module modules/mod_auth_mysql.so
Which is not valid since apxs does not install the module there - it winds up in libexec with every other module, so I use:
LoadModule mysql_auth_module libexec/mod_auth_mysql.so
The documentation is vague about the addition of
AddModule mod_auth_mysql.c
It's mentioned in some docs but not in others. Apparently it's required for Apache 1.3.3 but it doesn't say where to put it. One article I came across someplace insisted that it has to go at the top of the "xxx.c" list or it would break htaccess altogether (confirmed) and another said to add it at the bottom.
Also, it seems like the default compile options set the module to be active all the time, but this needs to go on a busy production server with dozens of membership sites that use basic with the standard "passwds" file so I need it to load in the "off" condition. Any attempt at putting:
AuthMySQLEnable Off
anywhere in httpd.conf also throws an error. Can someone give me the EXACT syntax and the location where this line is supposed to go? (pretend I'm an idiot and talk slow ;)
Thanks. I've never installed an Apache module before and so far, I'm not the least bit impressed with my own abilities ... :)
Marshall,
Sorry, I can't help you much on the CPanel end. I know it changes things around a lot.
First of all, AddModule is an Apache 1.x statement; it's not required for Apache 2.x.
Your problem with the unrecognized statements is that it's AuthMySQLxxx, not Auth_Mysqlxxx. No underscore.
As for trying to disable it in the main part of the configuration file, Apache doesn't allow this. Authorization module statements can only be in <directory> sections or .htaccess files. However, you can disable it by default when you compile it; see the BUILD file for more information.
Jerry
All cPanel servers run Apache 1.3.x so I still need to know where the AddModule statement goes - top or bottom of the list?
I'll try the different spelling in .htaccess. That's probably the biggest problem. :-)
I guess there really are two versions of this module running around because I can point to a hundred htaccess examples all over the web and Usenet that show it as Auth_MySQL...
There are multiple versions of this module running around. What you need to be looking at it the documentation which comes with the module! Other doc may be inaccurate.
As for the Addmodule statement - it shouldn't matter that much where it goes. The module should not be dependent on other modules.