Hello,
I am running into the wall over-and-over again trying to get Apache2 working with MySQL. What I want to do is to use mod_dbd when authenticating users that should have access to certain web-pages on Apache.
I've done a lot of things, the last thing I did was re-compiling Apache as this thread describes (I know it's for Ubuntu, but I guess it works about the same for OsX): http://ubuntuforums.org/showthread.php?t=757353
Now, I'm not sure if it worked since I got this error, both when making and installing it (first time I am trying to compile and install):
Before I compiled Apache I did install the latest MySQL-drive using their .dmg download (32-bit).
Before I did the make/make install above, I followed instructions here trying to get it to work, I don't think I got the same error as above: http://snippets.dzone.com/posts/show/6301
I didn't remove the old installation, just compiled it according to the new instructions and installed it again.
I was also trying to figure out how to get the "apr_dbd_mysql.so" in place, but according to the link above this shouldn't be possible.
It feels like I am getting close, I really need help getting the last pieces together...
These is the significant part of my httpd.conf file
I'm not really getting anywhere with google anymore...
Thank you in advance!
Regards,
Niklas
I am running into the wall over-and-over again trying to get Apache2 working with MySQL. What I want to do is to use mod_dbd when authenticating users that should have access to certain web-pages on Apache.
I've done a lot of things, the last thing I did was re-compiling Apache as this thread describes (I know it's for Ubuntu, but I guess it works about the same for OsX): http://ubuntuforums.org/showthread.php?t=757353
Code:
./configure --prefix=/usr/local/apache2 --with-apr=/usr/local/apache2 --with-apr-util=/usr/local/apache2 --enable-mods-shared=all
make
sudo make install
Now, I'm not sure if it worked since I got this error, both when making and installing it (first time I am trying to compile and install):
Code:
/usr/local/apache2/build-1/libtool --silent --mode=link gcc -g -O2 -o httpd modules.lo buildmark.o -export-dynamic server/libmain.la modules/http/libmod_http.la modules/mappers/libmod_so.la server/mpm/prefork/libprefork.la os/unix/libos.la /Users/Niklas/Development/apache/httpd-2.2.17/srclib/pcre/libpcre.la /usr/local/apache2/lib/libaprutil-1.la -lexpat -liconv /usr/local/apache2/lib/libapr-1.la -lpthread
Undefined symbols:
"_apr_dir_read$INODE64", referenced from:
_process_resource_config_nofnmatch in libmain.a(config.o)
_ap_process_resource_config in libmain.a(config.o)
"_apr_file_info_get$INODE64", referenced from:
_ap_pcfg_openfile in libmain.a(util.o)
"_apr_dir_open$INODE64", referenced from:
_process_resource_config_nofnmatch in libmain.a(config.o)
_ap_process_resource_config in libmain.a(config.o)
"_apr_stat$INODE64", referenced from:
_ap_process_resource_config in libmain.a(config.o)
_ap_mpm_set_coredumpdir in libmain.a(mpm_common.o)
_ap_is_directory in libmain.a(util.o)
_ap_is_rdirectory in libmain.a(util.o)
_ap_log_pid in libmain.a(log.o)
_unixd_pre_config in libos.a(unixd.o)
_resolve_symlink in libmain.a(request.o)
_resolve_symlink in libmain.a(request.o)
_resolve_symlink in libmain.a(request.o)
_ap_directory_walk in libmain.a(request.o)
_ap_directory_walk in libmain.a(request.o)
_ap_directory_walk in libmain.a(request.o)
_ap_sub_req_lookup_dirent in libmain.a(request.o)
_ap_sub_req_lookup_dirent in libmain.a(request.o)
_ap_sub_req_lookup_file in libmain.a(request.o)
_ap_sub_req_lookup_file in libmain.a(request.o)
ld: symbol(s) not found
collect2: ld returned 1 exit status
make[1]: *** [httpd] Error 1
make: *** [install-recursive] Error 1
Before I compiled Apache I did install the latest MySQL-drive using their .dmg download (32-bit).
Before I did the make/make install above, I followed instructions here trying to get it to work, I don't think I got the same error as above: http://snippets.dzone.com/posts/show/6301
I didn't remove the old installation, just compiled it according to the new instructions and installed it again.
I was also trying to figure out how to get the "apr_dbd_mysql.so" in place, but according to the link above this shouldn't be possible.
It feels like I am getting close, I really need help getting the last pieces together...
These is the significant part of my httpd.conf file
Code:
# mod_dbd configuration
DBDriver mysql
DBDParams "dbname=ia_timereporting user=root@localhost pass="
DBDMin 4
DBDKeep 8
DBDMax 20
DBDExptime 300
<Directory /usr/local/apache2/htdocs/area1>
AuthType Basic
AuthName "Area1"
# (Following line optional)
AuthBasicProvider dbd
Require valid-user
AuthDBDUserPWQuery \
"SELECT password FROM users WHERE user = %s"
</Directory>
<Directory /usr/local/apache2/htdocs/area2>
AuthType Basic
AuthName "Area2"
# (Following line optional)
AuthBasicProvider dbd
Require valid-user
AuthDBDUserPWQuery \
"SELECT password FROM users WHERE user = %s"
</Directory>
I'm not really getting anywhere with google anymore...
Thank you in advance!
Regards,
Niklas