You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Niklas Johansson <ni...@hotmail.com> on 2010/11/02 22:53:37 UTC
[users@httpd] Apache2, MySQL and mod_dbd
Hello,
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.
I am using
OSX 10.6.4 (I guess one can solve it as you would do in linux)
Apache 2.2.17
MySQL 5.1
I really need to solve this and hope someone knows how to do this!
Thanks in advance!
Regards,
Niklas
---------------------------------------------------------------------
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-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: RE: [users@httpd] Apache2, MySQL and mod_dbd
Posted by Dave Mansfield <dm...@sbcglobal.net>.
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: gubydala@his.com
> > To: users@httpd.apache.org
> > Subject: Re: [users@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-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
RE: [users@httpd] Apache2, MySQL and mod_dbd
Posted by Niklas Johansson <ni...@hotmail.com>.
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: gubydala@his.com
> To: users@httpd.apache.org
> Subject: Re: [users@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.
>
> 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
> 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
>
> > I am using
> > OSX 10.6.4 (I guess one can solve it as you would do in linux)
> > Apache 2.2.17
> > MySQL 5.1
> >
> > I really need to solve this and hope someone knows how to do this!
> >
> > Thanks in advance!
> >
> > Regards,
> > Niklas
> >
> > ---------------------------------------------------------------------
> > 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-unsubscribe@httpd.apache.org
> > " from the digest: users-digest-unsubscribe@httpd.apache.org
> > For additional commands, e-mail: users-help@httpd.apache.org
> >
> >
>
>
>
> ---------------------------------------------------------------------
> 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-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
Re: [users@httpd] Apache2, MySQL and mod_dbd
Posted by Sheryl <gu...@his.com>.
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.
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
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
> I am using
> OSX 10.6.4 (I guess one can solve it as you would do in linux)
> Apache 2.2.17
> MySQL 5.1
>
> I really need to solve this and hope someone knows how to do this!
>
> Thanks in advance!
>
> Regards,
> Niklas
>
> ---------------------------------------------------------------------
> 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-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>
---------------------------------------------------------------------
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-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org