[EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Nathan Kellogg
Has anyone successfully setup user authentication using an SQL database? - 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,

RE: [EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Rob Sterenborg
Nathan Kellogg mailto:[EMAIL PROTECTED] wrote: Has anyone successfully setup user authentication using an SQL database? Yes, and I cannot imagine I'm the only one. If you didn't succeed in getting it to work, then you'd better post what you have done so far (compile/config) and what errors you

RE: [EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Nathan Kellogg
We tried using mod_authn_dbd with MySQL but there are apparently no MySQL ( or PostgreSQL ) drivers built in to the mod_authn_dbd or to mod_dbd. I do not have the resources to compile myself so that is where I get stuck! Thanks At 09:17 AM 1/23/2007, you wrote: Nathan Kellogg mailto:[EMAIL

RE: [EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Rob Sterenborg
Nathan Kellogg mailto:[EMAIL PROTECTED] wrote: We tried using mod_authn_dbd with MySQL but there are apparently no MySQL ( or PostgreSQL ) drivers built in to the mod_authn_dbd or to mod_dbd. I do not have the resources to compile myself so that is where I get stuck! Yes, that has something

RE: [EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Nathan Kellogg
There is also mod_auth_mysql which I got to work on 2.2.3 for both user and group (at the time I tried 2.2.3, only user auth was available). There is a patch available for mod_auth_mysql-3.0.0 to make it compile with Apache 2.2.3. We installed the compiled version of mod_auth_mysql for

RE: [EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Rob Sterenborg
Nathan Kellogg mailto:[EMAIL PROTECTED] wrote: There is also mod_auth_mysql which I got to work on 2.2.3 for both user and group (at the time I tried 2.2.3, only user auth was available). There is a patch available for mod_auth_mysql-3.0.0 to make it compile with Apache 2.2.3. We installed

RE: [EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Nathan Kellogg
Thanks for the reply Rob. For the benefit of anyone following this thread : I finally got this working using mod_authn_mysql , http://www.gknw.net/development/apache/httpd-2.2/win32/modules/mod_authn_mysql-2.2.3-w32.zip At first I thought id didn't work because Apache would crash with this

RE: [EMAIL PROTECTED] Auth via SQL

2007-01-23 Thread Rob Sterenborg
Nathan Kellogg mailto:[EMAIL PROTECTED] wrote: Thanks for the reply Rob. ... Client does not support authentication protocol This was because the MySQL client built into the mod was not compatible with MySQL 5.x To make it compatible, we needed to tell MySQL server to use the old