RE: [linux-392] Mod_auth_mysql

From: user 4.
Sent on: Monday, December 15, 2008 7:29 PM
I have an application which already authenticates users using a mysql user
database table.
I have another part of the website which is outside of that php
authenticated area which I need to sync up with the application's user
database table.

Michele

-----Original Message-----
From: [address removed] [mailto:[address removed]] On Behalf Of Sean
OMeara
Sent: Monday, December 15,[masked]:21 PM
To: [address removed]
Subject: Re: [linux-392] Mod_auth_mysql

Typically database centric user administration should be (and is)
handled by the application running inside the web server (the site).
That way you can have a nice pretty little login box on the site
instead of the browser's built in prompt box.

Sometimes though, typically for "internal" applications, it's
appropriate to move authentication duties to the web server
(mod_auth_foo).  Things like SVN and WebDAV drops are excellent
candidates for this. mod_auth_kerb, mod_auth_ldap, or even
mod_auth_pam (with appropriate system config) are usually found in
corprate environments. (authentication against AD and/or LDAP)

Mod auth_auth_mysql is very rarely appropriate.

Could you explain in a little more detail the scenario?

-s

On Mon, Dec 15, 2008 at 6:00 PM, Michele <[address removed]> wrote:
> What is a large apache install verse a small apache install?  I will need
to
> admin a good number of users.  At least, that's what my client
anticipates.
>
>
>
> ____________________­____________
>
> From: [address removed] [mailto:[address removed]] On Behalf Of Dan
> Sent: Monday, December 15,[masked]:16 PM
> To: [address removed]
> Subject: Re: [linux-392] Mod_auth_mysql
>
>
>
> .htaccess is a folder level file type not a type of authentication. So,
let
> me rephrase, why do you need mysql backed auth for your apache install?
> Mod_auth_ldap would intergrate with your exsiting centrailized auth
system.
> Running a mysqeel instance for just apache auth is overcomplicated. All
this
> is moot anyway unless you have a lot of users you need to admin. Also,
your
> choice of AuthType is fairly important. Is this a large apache install or
a
> smaller one?
>
> On Mon, Dec 15, 2008 at 5:04 PM, Michele <[address removed]> wrote:
>
> The purpose of the mod_auth_mysql module is so you can use htaccess mysql
> authorization.
>
>
>
> Michele
>
>
>
> ____________________­____________
>
> From: [address removed] [mailto:[address removed]] On Behalf Of Dan
> Sent: Monday, December 15,[masked]:58 PM
>
> To: [address removed]
>
> Subject: Re: [linux-392] Mod_auth_mysql
>
>
>
> What are you trying to achieve with this module?
>
> On Mon, Dec 15, 2008 at 4:23 PM, Michele <[address removed]> wrote:
>
> I got the mod_auth_mysql module loaded an apache restarted.
>
> I don't know if it's going to actually work, but it's taken me since
10a.m.
> to get this far.
>
>
>
> ____________________­____________
>
> From: [address removed] [mailto:[address removed]] On Behalf Of
> Michele
> Sent: Monday, December 15,[masked]:49 PM
>
> To: [address removed]
> Subject: RE: [linux-392] Mod_auth_mysql
>
>
>
> Since, I haven't heard back.  I'm guessing this is not an approach.
>
> I went back to trying to create the module via apxs.
>
> It looks good when I run it.
>
> apxs -c -L/usr/lib/mysql -I/usr/include/mysql­ -lm -lz mod_auth_mysql.c
>
> /usr/sbin/httpd/usr/­local/src/httpd-2.2.­8/srclib/apr/libtool­ --silent
> --mode=compile gcc -prefer-pic   -DLINUX=2 -D_REENTRANT -D_GNU_SOURCE
> -D_LARGEFILE64_SOURC­E -g -O2 -pthread -I/usr/local/src/htt­pd-2.2.8/include
> -I/usr/local/src/htt­pd-2.2.8/srclib/apr/­include
> -I/usr/local/src/htt­pd-2.2.8/srclib/apr-­util/include
> -I/usr/local/src/htt­pd-2.2.8/srclib/apr-­util/xml/expat/lib
> -I/usr/local/src/htt­pd-2.2.8/os/unix -I/usr/include/mysql­  -c -o
> mod_auth_mysql.lo mod_auth_mysql.c && touch mod_auth_mysql.slo
>
> /usr/local/src/httpd­-2.2.8/srclib/apr/li­btool --silent --mode=link gcc -o
> mod_auth_mysql.la  -L/usr/lib/mysql -lm -lz -rpath
> /usr/local/src/httpd­-2.2.8/modules -module -avoid-version
> mod_auth_mysql.lo
>
> I added a loadmodule line the httpd.conf file.
>
> However, when I run ./apachectl restart, I get:
>
> apachectl: Configuration syntax error, will not run "restart":
>
> httpd: Syntax error on line 199 of /etc/httpd/conf/http­d.conf: Cannot load
> /etc/httpd/modules/m­od_auth_mysql.so into server:
> /etc/httpd/modules/m­od_auth_mysql.so: undefined symbol: mysql_select_db
>
> Can anyone see where I'm linking incorrectly to the mysql library?  I'm
> thinking mysql_select_db should have been in that library.
>
> ____________________­____________
>
> From: [address removed] [mailto:[address removed]] On Behalf Of
> Michele
> Sent: Monday, December 15,[masked]:02 PM
> To: [address removed]
> Subject: RE: [linux-392] Mod_auth_mysql
>
>
>
> I'm running redhat apache v. 2.2.8 Linux.
>
> My hosting provider doesn't provide the source code.
>
> I found all the apr modules I needed were in the http source srclib
> directory.
>
> Because my environment is not setup correctly because I'm not actually
> installing apache but simply trying to create a mod_auth_mysql module, I
> thought I could put mod_auth_mysql in the aaa directory, modify the
> makefiles to include mysql and compile.
>
> This worked sortof.  I've successful compiled mod_auth_mysql in the httpd
> directory.  However, I have an .o file, not a .so file.  Does anyone know
> the difference between a .o and .so file?  I'd like to somehow use this .o
> file to include as the module, but I don't know how to get the end
product.
>
>
>
> ____________________­____________
>
> From: [address removed] [mailto:[address removed]] On Behalf Of
> William mantly
> Sent: Monday, December 15,[masked]:00 AM
> To: [address removed]
> Subject: Re: [linux-392] Mod_auth_mysql
>
>
>
> What OS are you running?
>
> On Mon, Dec 15, 2008 at 10:44 AM, Michele <[address removed]> wrote:
>
> I'm trying to install mod_auth_mysql.
>
>
>
> My hosting provider does not have the apache source code on my server.
>
>
>
> I downloaded httpd 2.2.8 and apr 1.3.2.
>
>
>
> I'm not sure if that's the right apr.
>
>
>
> However, apxs is complaining that apr.h and apr_tables.h does not exist.
>
>
>
> Does anyone know what other libraries I need to compile mod_auth_mysql.
>
>
>
> Michele
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Michele ([address removed]) from The New York
> GNU/Linux Meetup Group.
> To learn more about Michele, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by William mantly ([address removed]) from The New
> York GNU/Linux Meetup Group.
> To learn more about William mantly, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Michele ([address removed]) from The New York
> GNU/Linux Meetup Group.
> To learn more about Michele, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Michele ([address removed]) from The New York
> GNU/Linux Meetup Group.
> To learn more about Michele, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Michele ([address removed]) from The New York
> GNU/Linux Meetup Group.
> To learn more about Michele, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Dan ([address removed]) from The New York
GNU/Linux
> Meetup Group.
> To learn more about Dan , visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Michele ([address removed]) from The New York
> GNU/Linux Meetup Group.
> To learn more about Michele, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Dan ([address removed]) from The New York
GNU/Linux
> Meetup Group.
> To learn more about Dan , visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on
> this mailing list ([address removed])
> This message was sent by Michele ([address removed]) from The New York
> GNU/Linux Meetup Group.
> To learn more about Michele, visit his/her member profile
> To unsubscribe or to update your mailing list settings, click here
>
> Meetup Support: [address removed]
> 632 Broadway, New York, NY 10012 USA




--
Please Note: If you hit "REPLY", your message will be sent to everyone on
this mailing list ([address removed])
http://linux.meet...­
This message was sent by Sean OMeara ([address removed]) from The New York
GNU/Linux Meetup Group.
To learn more about Sean OMeara, visit his/her member profile:
http://linux.meet...­
To unsubscribe or to update your mailing list settings, click here:
http://www.meetup...­
Meetup Support: [address removed]
632 Broadway, New York, NY 10012 USA

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy