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