Niklas Johansson wrote:
Hello,
Thank you for your answer.
What I have learned now is that lmysqlclient is named differently in
OSX and Linux. Hence, since I planned to develop on OSX but deploy on
Linux, I think I will need to abandon OSX for this projekt and use
Linux. I thought that it would be almost transparent, but since I have
found this difference I will use Linux in order to avoid future
problems and also for not needing to learn things twice, once for each
OS. Also, almost all instructions are taylored for Linux.
Regards,
Niklas
> Date: Thu, 4 Nov 2010 19:16:39 -0400
> From: gubyd...@his.com
> To: users@httpd.apache.org
> Subject: Re: [us...@httpd] Apache2, MySQL and mod_dbd
>
> Niklas wrote:
>
> > I want to use Apache2's built in functionality to authenticate and
> > authorize user for accessing certain pages, mod_dbd. I want to
store the
> > users in MySQL.
> >
> > How should I set up this? I have tried a lot of things and it
seems to be
> > really hard getting it to work. As I understand, there is no
support for
> > this by default in Apache but I have to compile Apache in order to
> > "include" the mysql driver. Today I get the "Invalid command
'DBDriver'"
> > when starting httpd.
This happens because your APR (util) library was not built with the
mysql driver enabled. You have to either get a binary of apr-util that
includes the MySQL driver, or, compile Apache/APR up yourself, including
the "--with-mysql" flag - it is disabled by default (licensing
issues). The hard part about compiling httpd is understanding (at the
very least) the prerequisites..
>
> I have done this fairly recently. Rather than go through it all here,
> I'll refer you to http://www.apachefriends.org/f/viewtopic.php?p=93012
> which I think is the article I found with google to figure out how
to get
> things working.
>
> Essentially you need to install a third-party module to take care of the
> logins. There are a couple of them out there, none of them updated for
You can get there via mod_dbd.. I guess it's sort of third party! In
any case, using mod_auth_mysql ties you closer to MySQL; using mod_dbd
you can stick to vanilla SQL statements (e.g., "select password from
pw_table where user = %s"). As other posts have pointed out, you can
use stored procedures, too, further de-coupling your Apache deployment
from a specific database.
> apache 2.2.x, but mysql-3.0.0 is close and a patch is available from
> another source which will bring it the rest of the way.
>
> Good luck,
>
> Sheryl
-- D Mansfield
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscr...@httpd.apache.org
" from the digest: users-digest-unsubscr...@httpd.apache.org
For additional commands, e-mail: users-h...@httpd.apache.org
