mark2326
asked on
Need help building an Apache module
I'm trying to build an apache module "mod_auth_mysql" so I can password protect a directory and have the users and passwords stored in MySQL. http://support.modwest.com/content/1/161/en/how-do-i-protect-a-directory-with-mod_auth_mysql.html
I downloaded mod_auth_mysql 3.0
As per the build instructions...
If the mysql.h header file cannot be found, add the -I option to specify the
directory where mysql.h can be found.
If the mysqlclient library cannot be found, add the -L option to specify the
directory where libmysqlclient.so can be found.
Example:
apxs -c -L/usr/lib/mysql -I/usr/include/mysql -lmysqlclient -lm -lz mod_auth_mysql.c
My command...
apxs -c -L/usr/local/mysql-5.1.47-
I get the error...
i686-apple-darwin10-gcc-4.
I cd to the folder where the mod_auth_mysql.c file lives and get the same error.
Can anyone help?
I downloaded mod_auth_mysql 3.0
As per the build instructions...
If the mysql.h header file cannot be found, add the -I option to specify the
directory where mysql.h can be found.
If the mysqlclient library cannot be found, add the -L option to specify the
directory where libmysqlclient.so can be found.
Example:
apxs -c -L/usr/lib/mysql -I/usr/include/mysql -lmysqlclient -lm -lz mod_auth_mysql.c
My command...
apxs -c -L/usr/local/mysql-5.1.47-
I get the error...
i686-apple-darwin10-gcc-4.
I cd to the folder where the mod_auth_mysql.c file lives and get the same error.
Can anyone help?
ASKER
Thank You.
Now when I run it I'm getting these errors...
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
apxs:Error: Command failed with rc=65536
Now when I run it I'm getting these errors...
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
/Users/markaman_macpro/Dow
apxs:Error: Command failed with rc=65536
Try this patch: http://download.3uu.org/3uu-ROM/mod_auth_mysql-3.0.0-apr1x.patch
Save the file, then apply the patch using the "patch" program.
Save the file, then apply the patch using the "patch" program.
ASKER
Here is my input...
markaman:~ markaman_macpro$ apxs -c -L/usr/local/mysql-5.1.47-
Here is the result...
/usr/share/apr-1/build-1/l
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
apxs:Error: Command failed with rc=65536
markaman:~ markaman_macpro$ apxs -c -L/usr/local/mysql-5.1.47-
Here is the result...
/usr/share/apr-1/build-1/l
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
/Users/markaman_macpro/Des
apxs:Error: Command failed with rc=65536
The patch must be applied using the patch program: "patch < mod_auth_mysql-3.0.0-apr1x
Run this in the same directory as you have the original mod_auth_mysql.c program.
See http://en.wikipedia.org/wiki/Patch_(Unix) for an explanation of what the patch program is.
Run this in the same directory as you have the original mod_auth_mysql.c program.
See http://en.wikipedia.org/wiki/Patch_(Unix) for an explanation of what the patch program is.
ASKER
After cd to the director, my input...
patch < mod_auth_mysql-3.0.0-apr1x
Result
patch: **** Only garbage was found in the patch input.
patch < mod_auth_mysql-3.0.0-apr1x
Result
patch: **** Only garbage was found in the patch input.
I've attached the path as code to this posting. Is this what you have in your file?
--- mod_auth_mysql-3.0.0/mod_auth_mysql.c.apr1x
+++ mod_auth_mysql-3.0.0/mod_auth_mysql.c
@@ -206,7 +206,7 @@
#define SNPRINTF apr_snprintf
#define PSTRDUP apr_pstrdup
#define PSTRNDUP apr_pstrndup
- #define STRCAT ap_pstrcat
+ #define STRCAT apr_pstrcat
#define POOL apr_pool_t
#include "http_request.h" /* for ap_hook_(check_user_id | auth_checker)*/
#include "ap_compat.h"
@@ -586,90 +586,91 @@
}
#ifdef APACHE2
+
static
command_rec mysql_auth_cmds[] = {
AP_INIT_TAKE1("AuthMySQLHost", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlhost),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlhost),
OR_AUTHCFG, "mysql server host name"),
AP_INIT_TAKE1("AuthMySQLPort", ap_set_int_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlport),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlport),
OR_AUTHCFG, "mysql server port number"),
AP_INIT_TAKE1("AuthMySQLSocket", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlsocket),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlsocket),
OR_AUTHCFG, "mysql server socket path"),
AP_INIT_TAKE1("AuthMySQLUser", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqluser),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqluser),
OR_AUTHCFG, "mysql server user name"),
AP_INIT_TAKE1("AuthMySQLPassword", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlpasswd),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlpasswd),
OR_AUTHCFG, "mysql server user password"),
AP_INIT_TAKE1("AuthMySQLDB", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlDB),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlDB),
OR_AUTHCFG, "mysql database name"),
AP_INIT_TAKE1("AuthMySQLUserTable", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlpwtable),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlpwtable),
OR_AUTHCFG, "mysql user table name"),
AP_INIT_TAKE1("AuthMySQLGroupTable", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlgrptable),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlgrptable),
OR_AUTHCFG, "mysql group table name"),
AP_INIT_TAKE1("AuthMySQLNameField", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlNameField),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlNameField),
OR_AUTHCFG, "mysql User ID field name within User table"),
AP_INIT_TAKE1("AuthMySQLGroupField", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlGroupField),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlGroupField),
OR_AUTHCFG, "mysql Group field name within table"),
AP_INIT_TAKE1("AuthMySQLGroupUserNameField", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlGroupUserNameField),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlGroupUserNameField),
OR_AUTHCFG, "mysql User ID field name within Group table"),
AP_INIT_TAKE1("AuthMySQLPasswordField", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlPasswordField),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlPasswordField),
OR_AUTHCFG, "mysql Password field name within table"),
AP_INIT_TAKE1("AuthMySQLPwEncryption", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlEncryptionField),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlEncryptionField),
OR_AUTHCFG, "mysql password encryption method"),
AP_INIT_TAKE1("AuthMySQLSaltField", ap_set_string_slot,
- (void*) APR_XtOffsetOf(mysql_auth_config_rec, mysqlSaltField),
+ (void*) APR_OFFSETOF(mysql_auth_config_rec, mysqlSaltField),
OR_AUTHCFG, "mysql salfe field name within table"),
/* AP_INIT_FLAG("AuthMySQLKeepAlive", ap_set_flag_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlKeepAlive),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlKeepAlive),
OR_AUTHCFG, "mysql connection kept open across requests if On"),
*/
AP_INIT_FLAG("AuthMySQLAuthoritative", ap_set_flag_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlAuthoritative),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlAuthoritative),
OR_AUTHCFG, "mysql lookup is authoritative if On"),
AP_INIT_FLAG("AuthMySQLNoPasswd", ap_set_flag_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlNoPasswd),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlNoPasswd),
OR_AUTHCFG, "If On, only check if user exists; ignore password"),
AP_INIT_FLAG("AuthMySQLEnable", ap_set_flag_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlEnable),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlEnable),
OR_AUTHCFG, "enable mysql authorization"),
AP_INIT_TAKE1("AuthMySQLUserCondition", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlUserCondition),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlUserCondition),
OR_AUTHCFG, "condition to add to user where-clause"),
AP_INIT_TAKE1("AuthMySQLGroupCondition", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlGroupCondition),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlGroupCondition),
OR_AUTHCFG, "condition to add to group where-clause"),
AP_INIT_TAKE1("AuthMySQLCharacterSet", ap_set_string_slot,
- (void *) APR_XtOffsetOf(mysql_auth_config_rec, mysqlCharacterSet),
+ (void *) APR_OFFSETOF(mysql_auth_config_rec, mysqlCharacterSet),
OR_AUTHCFG, "mysql character set to be used"),
{ NULL }
@@ -889,7 +890,7 @@
}
if (!found) {
LOG_ERROR_2(APLOG_ERR|APLOG_NOERRNO, 0, r, "MySQL ERROR: Invalid formatting character at position %d: \"%s\"",
- pos-output, output);
+ (int)(pos-output), output);
return input;
}
}
ASKER
Sorry, I realized after I replied I renamed the wrong file.
This is the result. Not sure if it worked, or what to do now.
markaman:mod_auth_mysql-3.
patching file mod_auth_mysql.c
patch unexpectedly ends in middle of line
Hunk #3 succeeded at 890 with fuzz 1.
This is the result. Not sure if it worked, or what to do now.
markaman:mod_auth_mysql-3.
patching file mod_auth_mysql.c
patch unexpectedly ends in middle of line
Hunk #3 succeeded at 890 with fuzz 1.
Now try compiling the file again to see if it's any better.
ASKER
/usr/share/apr-1/build-1/l
/usr/share/apr-1/build-1/l
ld: warning: in /usr/local/mysql/lib/libmy
ld: warning: in /usr/local/mysql/lib/libz.
warning: no debug symbols in executable (-arch x86_64)
/usr/share/apr-1/build-1/l
ld: warning: in /usr/local/mysql/lib/libmy
ld: warning: in /usr/local/mysql/lib/libz.
warning: no debug symbols in executable (-arch x86_64)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your help.
Yes I assumed I needed the 32bit since I'm not booting into the 64 Kernel.
I'll download the correct one.
Yes I assumed I needed the 32bit since I'm not booting into the 64 Kernel.
I'll download the correct one.
ASKER
I'm not sure if I need to start a new thread, but I'm having some problems I can't get past.
I installed 64 bit MySQL, re installed the module, in my httpd.conf I entered LoadModule mysql_auth_module libexec/apache2/mod_auth_m
in .htaccess I entered..
AuthName "pastissues"
AuthType Basic
AuthMySQLHost 127.0.0.1:3306
AuthMySQLUser mark
AuthMySQLPassword MyPasswd
AuthMySQLDB test
AuthMySQLUserTable user_info
AuthMySQLNameField user_name
AuthMySQLPasswordField user_passwd
AuthMySQLPwEncryption none
AuthMySQLEnable On
require valid-user
When I go to the protected directory I get the prompt to enter my username and password, I enter it then I get an "Internal Server Error"
In my apache error log...
[Tue Jun 29 11:48:13 2010] [error] Internal error: pcfg_openfile() called with NULL filename
[Tue Jun 29 11:48:13 2010] [error] [client 10.0.1.205] (9)Bad file descriptor: Could not open password file: (null)
I installed 64 bit MySQL, re installed the module, in my httpd.conf I entered LoadModule mysql_auth_module libexec/apache2/mod_auth_m
in .htaccess I entered..
AuthName "pastissues"
AuthType Basic
AuthMySQLHost 127.0.0.1:3306
AuthMySQLUser mark
AuthMySQLPassword MyPasswd
AuthMySQLDB test
AuthMySQLUserTable user_info
AuthMySQLNameField user_name
AuthMySQLPasswordField user_passwd
AuthMySQLPwEncryption none
AuthMySQLEnable On
require valid-user
When I go to the protected directory I get the prompt to enter my username and password, I enter it then I get an "Internal Server Error"
In my apache error log...
[Tue Jun 29 11:48:13 2010] [error] Internal error: pcfg_openfile() called with NULL filename
[Tue Jun 29 11:48:13 2010] [error] [client 10.0.1.205] (9)Bad file descriptor: Could not open password file: (null)
Hmm, it looks like mod_auth_mysql may not be taking effect. Can you double-check that there aren't errors about loading the module at startup time?
ASKER
sudo apachectl configtest
Syntax OK
phpinfo() shows the module loaded
Syntax OK
phpinfo() shows the module loaded
Ok, I think the attached two lines should fix the issue. Apparently Apache looks for the auth file even if the method doesn't require one.
AuthUserFile /dev/null
AuthBasicAuthoritative Off
ASKER
Thank You, Thank You, Thank You!!
It works!
I've been on this for over two weeks.
I still have some work to do, I need to apply this to my Xserve (been testing on my MacPro). I also need to incorporate an expiration date.
You made my day :)
It works!
I've been on this for over two weeks.
I still have some work to do, I need to apply this to my Xserve (been testing on my MacPro). I also need to incorporate an expiration date.
You made my day :)
-Try giving a fuller path to mod_auth_mysql.c (e.g., "./mod_auth_mysql.c").
-Check the permissions on the file and make sure you have read access to the file.