Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Nicsoft

macrumors member
Original poster
Oct 17, 2009
53
0
Stockholm
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

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
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.