hi all,
i'm trying to get mod_auth_mysql up/running on my OSX 10.2.1 box
to date, i've successuflly gotten Apache2, PHP, Perl, & MySQL humming along
together. Here's the env:
my current apache server-info reports as:
Apache/2.0.44-dev (Unix) mod_perl/1.99_07-dev Perl/v5.8.0
mod_webapp/1.2.0-dev mod_fastcgi/mod_fastcgi-SNAP-0210222112 PHP/4.3.0-dev
DAV/2
and mysqladmin version reports:
mysqladmin Ver 8.37 Distrib 4.0.4-beta, for apple-darwin6.1 on
powerpc
Next step for me is User Authentication in Apache2 via a "central" MySQL
DB. I.e. -- mod_auth_mysql
After having fumbled & failed with Zeef Suraski's mod_auth_mysql-2.20, i
discovered Vivek Khera's apache2-friendly build on sourceforge
a "normal" (per instrtuctions) apxs build of it got me nowhere ..... no
".so" was ever built, just a ".la", but combining info from a couple of the
sparse posts on the matter got me a lot further!
to build mod_auth_mysql.so, the following seems to work .....
cd /usr/ports/mod_auth_mysql
setenv CFLAGS "-no-cpp-precomp"
apxs -DAPACHE2 -L/usr/local/mysql4/lib/mysql
-I/usr/local/mysql4/include/mysql -lmysqlclient -lm -Wc,-g -c
mod_auth_mysql.c
cc -DAPACHE2 -DDARWIN -DUSE_HSREGEX -DUSE_EXPAT -DSHARED_MODULE
-I/usr/include/apache2 -g -L/usr/local/mysql4/lib/mysql
-I/usr/local/mysql4/include/mysql -c mod_auth_mysql.c
cc -bundle -flat_namespace undefined suppress -o mod_auth_mysql.so
mod_auth_mysql.o
cp /usr/ports/mod_auth_mysql/mod_auth_mysql.so /usr/libexec/apache2/
apxs -i -a mod_auth_mysql.so
this creates:
-rwxr-xr-x 1 root wheel 41712 Oct 31 12:53
/usr/libexec/apache2/mod_auth_mysql.so
& adds to httpd.conf:
LoadModule mysql_auth_module libexec/apache2/libauth_mysql.la (hmmmmm
.... strange!)
so a quick fix in httpd.conf .......
(EDITOR) /etc/apache2/httpd.conf
--- LoadModule mysql_auth_module libexec/apache2/libauth_mysql.la
+++ LoadModule auth_mysql_module libexec/apache2/mod_auth_mysql.so
unfortunately, upon access to a test directory "(webroot)/testing", with
.htaccess
i get an Internal Server Error 500
a peek into my /var/log/apache2/error_log shows:
[Thu Oct 31 13:12:29 2002] [alert] [client 172.30.10.6]
/Library/WebServer/Documents/testing/.htaccess: Invalid command
'AuthMySQLHost', perhaps mis-spelled or defined by a module not included in
the server configuration
where my (webroot)/testing/.htaccess is:
AuthName "MySQL Testing"
AuthType Basic
AuthGroupFile /dev/null
<Limit GET>
AuthMySQLHost localhost
AuthMySQLDB http_user_auth
AuthMySQLUserTable user_info
AuthMySQLGroupTable user_group
AuthMySQLNameField user_name
AuthMySQLPasswordField user_passwd
AuthMySQLGroupField user_group
require valid-user
# * AuthMySQLUser <no default -- NULL>
# * AuthMySQLPassword <no default -- NULL>
AuthMySQLNoPasswd On
AuthMySQLCryptedPasswords On
AuthMySQLScrambledPasswords Off
AuthMySQLKeepAlive Off
AuthMySQLAuthoritative On
# * AuthMySQLUserCondition <no default>
# * AuthMySQLGroupCondition <no default>
</Limit>
any thoughts/insights/pointers as to what the problem/fix is would be much
appreciated!
regards,
richard
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
