mod_auth_mysql

mod_auth_mysql

[Bill McCormick]

Hey all,

I would like to build, CYGwin style, the latest mod_auth_mysql (ver 2.20)
for Apache. The Apache directives have been updated in this version along
with a number of encryption bug fixes. I've got the source from MySQL but
there doesn't seem to be any info for CYGwin build. The CYGwin setup source
download only provides a .c file. Can I simply implement the same changes
from that to the new source? How about any special configure options? Could
someone point me in the right direction with this?

Thanks,

Bill
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql

[Bill McCormick]

I launched missiles before I was really ready here.

After looking at the 1.11 source, I really don't find any obvious changes
for cygwin.

Actually, I'm not even exactly sure how Apache mod's work.

	LoadModule mysql_auth_module  lib/apache/mod_auth_mysql.dll

This dll is built from the source? i.e. when I configure;make;make install
I'll get a dll? (assuming I use the correct configure options - which would
be ... what)?

	AddModule mod_auth_mysql.c

I wouldn't imagine that I can just copy the new .c file to the right place
and be happy. Or can that be all I need to do?

Thanks


>
> I would like to build, CYGwin style, the latest mod_auth_mysql (ver 2.20)
> for Apache. The Apache directives have been updated in this version along
> with a number of encryption bug fixes. I've got the source from MySQL but
> there doesn't seem to be any info for CYGwin build. The CYGwin
> setup source
> download only provides a .c file. Can I simply implement the same changes
> from that to the new source? How about any special configure
> options? Could
> someone point me in the right direction with this?
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql

[Bill McCormick]

So I went ahead and tried to rebuild Apache (the build on mod_auth_mysql)
said that I needed to. I'm stuck here:

modules/auth_mysql/libauth_mysql.a(mod_auth_mysql.o.b)(.text+0xc4b):mod_auth
_mysql.c: undefined reference to `_mysql_connect'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x8b):my_co
mpress.c: undefined reference to `_compress'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x16d):my_c
ompress.c: undefined reference to `_compress'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x210):my_c
ompress.c: undefined reference to `_uncompress'
collect2: ld returned 1 exit status
make: *** [target_static] Error 1

By the way, I'm running a Win32 MySQL server (on the sme box) and trying to
link against the standard unix mysql binaries.

Ideas?

Thanks,


Bill

>
> I launched missiles before I was really ready here.
>
> After looking at the 1.11 source, I really don't find any obvious changes
> for cygwin.
>
> Actually, I'm not even exactly sure how Apache mod's work.
>
> 	LoadModule mysql_auth_module  lib/apache/mod_auth_mysql.dll
>
> This dll is built from the source? i.e. when I configure;make;make install
> I'll get a dll? (assuming I use the correct configure options -
> which would
> be ... what)?
>
> 	AddModule mod_auth_mysql.c
>
> I wouldn't imagine that I can just copy the new .c file to the right place
> and be happy. Or can that be all I need to do?
>
> Thanks
>
>
> >
> > I would like to build, CYGwin style, the latest mod_auth_mysql
> (ver 2.20)
> > for Apache. The Apache directives have been updated in this
> version along
> > with a number of encryption bug fixes. I've got the source from
> MySQL but
> > there doesn't seem to be any info for CYGwin build. The CYGwin
> > setup source
> > download only provides a .c file. Can I simply implement the
> same changes
> > from that to the new source? How about any special configure
> > options? Could
> > someone point me in the right direction with this?
> >
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003
>
>
> --
> Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
> Problem reports:       http://cygwin.com/problems.html
> Documentation:         http://cygwin.com/docs.html
> FAQ:                   http://cygwin.com/faq/
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql

[Gerrit P. Haase]

Hallo Bill,

Am Dienstag, 19. August 2003 um 08:11 schriebst du:

> So I went ahead and tried to rebuild Apache (the build on mod_auth_mysql)
> said that I needed to. I'm stuck here:

> modules/auth_mysql/libauth_mysql.a(mod_auth_mysql.o.b)(.text+0xc4b):mod_auth
> _mysql.c: undefined reference to `_mysql_connect'
> /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x8b):my_co
> mpress.c: undefined reference to `_compress'
> /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x16d):my_c
> ompress.c: undefined reference to `_compress'
> /usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x210):my_c
> ompress.c: undefined reference to `_uncompress'
> collect2: ld returned 1 exit status
> make: *** [target_static] Error 1

> By the way, I'm running a Win32 MySQL server (on the sme box) and trying to
> link against the standard unix mysql binaries.

You need a mysql client library to link against.  _compress is
probably in zlib.


Gerrit
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql

[Bill McCormick]

Gerrit:

> > By the way, I'm running a Win32 MySQL server (on the same box)
> and trying to
> > link against the standard unix mysql binaries.
>
> You need a mysql client library to link against.  _compress is
> probably in zlib.

Sorry Gerrit, I said binaries and meant src (above).

I see no zlib nor find no zlib*.

These are the 2 mysql libs I have ... I think (libs are .a right?):

	/usr/local/mysql/lib/mysql/libmysqlclient.a
	/usr/local/mysql/libmysql/.libs/libmysqlclient.a

I tried linking to both with the same results.

I see /usr/local/mysql/libmysql/my_compress.o, so now I'm thinking I have an
incomplete lib. Any ideas?

Sorry to copy you direct on this but I'd like to get this work asap.


Bill
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql

[Gerrit P. Haase]

Hello Bill,

>> You need a mysql client library to link against.  _compress is
>> probably in zlib.

> Sorry Gerrit, I said binaries and meant src (above).

> I see no zlib nor find no zlib*.

zlib is the canonical name of the zlib package / project, the library is
called cygz.dll and the archive libz.a (libz.dll.a) you can add it add
to the linkline as '-L/usr/lib -lz'.


> These are the 2 mysql libs I have ... I think (libs are .a right?):

>         /usr/local/mysql/lib/mysql/libmysqlclient.a
>         /usr/local/mysql/libmysql/.libs/libmysqlclient.a

> I tried linking to both with the same results.

> I see /usr/local/mysql/libmysql/my_compress.o, so now I'm thinking I have an
> incomplete lib. Any ideas?

You need to link against zlib.

> Sorry to copy you direct on this but I'd like to get this work asap.


Gerrit
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql

[Bill McCormick]

> You need to link against zlib.
>


gcc  -I/usr/local/mysql/include/mysql  -DCYGWIN -DUSE_HSREGEX -DNO_DL_NEEDED
`./apaci`    \
      -o httpd buildmark.o modules.o modules/standard/libstandard.a
modules/auth_mysql/libauth_mysql.a main/libmain.a ./os/cygwin/libos.a
ap/libap.a
regex/libregex.a   -L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt   -lcr
ypt -lgdbm -lexpat -lz
modules/auth_mysql/libauth_mysql.a(mod_auth_mysql.o.b)(.text+0xc4b):mod_auth
_mysql.c: undefined reference to `_mysql_connect'
collect2: ld returned 1 exit status


Still no joy :(


Bill
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql

[Elfyn McBratney]

Bill McCormick <wpmccormick@covad.net> wrote:
> > You need to link against zlib.
> >
> 
> 
> gcc  -I/usr/local/mysql/include/mysql  -DCYGWIN -DUSE_HSREGEX -DNO_DL_NEEDED
> `./apaci`    \
>       -o httpd buildmark.o modules.o modules/standard/libstandard.a
> modules/auth_mysql/libauth_mysql.a main/libmain.a ./os/cygwin/libos.a
> ap/libap.a
> regex/libregex.a   -L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt   -lcr
> ypt -lgdbm -lexpat -lz
>[...]

Try moving `-lz' to the beginning of the link line (before `-lmysqlclient' as
zlib is a dependency, AFAIK).

-- Elfyn

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql : HELP!!!

[Bill McCormick]

> Try moving `-lz' to the beginning of the link line (before
> `-lmysqlclient' as
> zlib is a dependency, AFAIK).
>

gcc  -I/usr/local/mysql/include/mysql  -DCYGWIN -DUSE_HSREGEX -DNO_DL_NEEDED
`./apaci`    \
      -o httpd buildmark.o modules.o modules/standard/libstandard.a
modules/auth_mysql/libauth_mysql.a main/libmain.a ./os/cygwin/libos.a
ap/libap.a
regex/libregex.a   -L/usr/local/mysql/lib/mysql -L/lib -lz -lmysqlclient -lc
rypt -lgdbm -lexpat
modules/auth_mysql/libauth_mysql.a(mod_auth_mysql.o.b)(.text+0xc4b):mod_auth
_mysql.c: undefined reference to `_mysql_connect'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x8b):my_co
mpress.c: undefined reference to `_compress'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x16d):my_c
ompress.c: undefined reference to `_compress'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x210):my_c
ompress.c: undefined reference to `_uncompress'
collect2: ld returned 1 exit status
make[2]: *** [target_static] Error 1
make[2]: Leaving directory `/usr/src/apache_1.3.24-5/src'
make[1]: *** [build-std] Error 2
make[1]: Leaving directory `/usr/src/apache_1.3.24-5'
make: *** [build] Error 2

Still no joy >:O
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql : HELP!!!

[Gerrit P. Haase]

Bill schrieb:

>> Try moving `-lz' to the beginning of the link line (before
>> `-lmysqlclient' as
>> zlib is a dependency, AFAIK).

[...]

> my_compress.c: undefined reference to `_uncompress'

> Still no joy >:O

Looks better with libz.a at the end like in your previous mail, or
did you removed errors from the first message?

Gerrit
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql

[Gerrit P. Haase]

Bill schrieb:

>> You need to link against zlib.
>>


> gcc  -I/usr/local/mysql/include/mysql  -DCYGWIN -DUSE_HSREGEX -DNO_DL_NEEDED
> `./apaci`    \
>       -o httpd buildmark.o modules.o modules/standard/libstandard.a
> modules/auth_mysql/libauth_mysql.a main/libmain.a ./os/cygwin/libos.a
> ap/libap.a
> regex/libregex.a   -L/usr/local/mysql/lib/mysql -lmysqlclient -lcrypt   -lcr
> ypt -lgdbm -lexpat -lz
> modules/auth_mysql/libauth_mysql.a(mod_auth_mysql.o.b)(.text+0xc4b):mod_auth
> _mysql.c: undefined reference to `_mysql_connect'
> collect2: ld returned 1 exit status


> Still no joy :(

At least we found _compress et.al.

Hmm, which version of mysql are you using, and is there any version
recommended for httpd?

$ nm libmysqlclient.a | grep _mysql_connect
00002db0 T _mysql_connect

This is version 3.23.43

In version 4.1.0-alpha I just find:
$ nm libmysqlclient.a | grep connect
00000000 T _mysql_real_connect
00000000 T _mysql_manager_connect
00000000 T _my_connect


Gerrit
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql

[Bill McCormick]

> Hmm, which version of mysql are you using, and is there any version
> recommended for httpd?

I'm not sure ... to both questions. I can't (quickly) locate the ver  number
in the source. BTW, I'm *running* the Win32 and *using* the Linux source
(fresh d/l) to link against.

>
> $ nm libmysqlclient.a | grep _mysql_connect
> 00002db0 T _mysql_connect
>
> This is version 3.23.43
>
> In version 4.1.0-alpha I just find:
> $ nm libmysqlclient.a | grep connect
> 00000000 T _mysql_real_connect
> 00000000 T _mysql_manager_connect
> 00000000 T _my_connect
>

What is nm? I'm not finding that.


Thanks,

Bill
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql

[Gerrit P. Haase]

Bill schrieb:

>> Hmm, which version of mysql are you using, and is there any version
>> recommended for httpd?

> I'm not sure ... to both questions. I can't (quickly) locate the ver  number
> in the source. BTW, I'm *running* the Win32 and *using* the Linux source
> (fresh d/l) to link against.

>>
>> $ nm libmysqlclient.a | grep _mysql_connect
>> 00002db0 T _mysql_connect
>>
>> This is version 3.23.43
>>
>> In version 4.1.0-alpha I just find:
>> $ nm libmysqlclient.a | grep connect
>> 00000000 T _mysql_real_connect
>> 00000000 T _mysql_manager_connect
>> 00000000 T _my_connect
>>

> What is nm? I'm not finding that.

nm.exe is in the binutils package which you need to link, so you should
find it in /usr/bin.


Gerrit
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql

[Bill McCormick]

> $ nm libmysqlclient.a | grep _mysql_connect
> 00002db0 T _mysql_connect
>
> This is version 3.23.43
>
> In version 4.1.0-alpha I just find:
> $ nm libmysqlclient.a | grep connect
> 00000000 T _mysql_real_connect
> 00000000 T _mysql_manager_connect
> 00000000 T _my_connect
>

I downloaded the 4.0 production release; looks like it's not lining up with
mod_auth_mysql:

$ nm libmysqlclient.a | grep connect
         U _connect
00000000 T _my_connect
00000ae0 T _mysql_real_connect
00001940 t _mysql_reconnect
         U _my_connect
000000f0 T _mysql_manager_connect


I don't find any documentation fro Zeev that indicates which version of
MySQL it supports.


Bill


P.S. is nm a POSIX program or a strictly a cygwin-izm?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql

[Gerrit P. Haase]

Bill schrieb:

>> $ nm libmysqlclient.a | grep _mysql_connect
>> 00002db0 T _mysql_connect
>>
>> This is version 3.23.43
>>
>> In version 4.1.0-alpha I just find:
>> $ nm libmysqlclient.a | grep connect
>> 00000000 T _mysql_real_connect
>> 00000000 T _mysql_manager_connect
>> 00000000 T _my_connect
>>

> I downloaded the 4.0 production release; looks like it's not lining up with
> mod_auth_mysql:

> $ nm libmysqlclient.a | grep connect
>          U _connect
> 00000000 T _my_connect
> 00000ae0 T _mysql_real_connect
> 00001940 t _mysql_reconnect
>          U _my_connect
> 000000f0 T _mysql_manager_connect


> I don't find any documentation fro Zeev that indicates which version of
> MySQL it supports.

Probably 3.4x.xx series it seems.


> P.S. is nm a POSIX program or a strictly a cygwin-izm?

It is in the binutils package like ld, should be available for every
platform, I don't know if this has s.th. to do with POSIX, but it is not
Cygwin specific.


Gerrit
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql

[Bill McCormick]

> It is in the binutils package like ld, should be available for every
> platform, I don't know if this has s.th. to do with POSIX, but it is not

Right, I found it (obviously)

I guess what I meant to say was: I don't see this command in Linux (that
is - it's not listed in the index of my Linux admin book under "nm".) Does
it go by another name under Linux?


Thanks,


Bill
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mod_auth_mysql

[Gerrit P. Haase]

Bill schrieb:

>> It is in the binutils package like ld, should be available for every
>> platform, I don't know if this has s.th. to do with POSIX, but it is not

> Right, I found it (obviously)

> I guess what I meant to say was: I don't see this command in Linux (that
> is - it's not listed in the index of my Linux admin book under "nm".) Does
> it go by another name under Linux?

Not that I'm aware of, it should be the same there.  It is use to
extract the symbol names from archives eg. from Perl's Configure script
if nm is available which runs on pretty mcuh platforms.

Maybe it is in the Linux devel book;)


Gerrit
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql (2nd request)

[Bill McCormick]

So I went ahead and tried to rebuild Apache (the build on mod_auth_mysql)
said that I needed to. I'm stuck here:

modules/auth_mysql/libauth_mysql.a(mod_auth_mysql.o.b)(.text+0xc4b):mod_auth
_mysql.c: undefined reference to `_mysql_connect'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x8b):my_co
mpress.c: undefined reference to `_compress'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x16d):my_c
ompress.c: undefined reference to `_compress'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x210):my_c
ompress.c: undefined reference to `_uncompress'
collect2: ld returned 1 exit status
make: *** [target_static] Error 1

By the way, I'm running a Win32 MySQL server (on the same box) and trying to
link against the standard unix mysql binaries.

Ideas?

Thanks,


Bill



--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

RE: mod_auth_mysql (2nd request)

[Bill McCormick]

Thanks Stipe:

[snip]
> >
> > Auth_MySQL_Info host user password
> > Auth_MySQL_Encryption_Types Plaintext, Crypt_DES, MySQL
> >
> > <Directory /var/www/htdocs/*/admin>
> >     AuthType Basic
> >     AuthName "Password Required"
> >     Auth_MySQL_DB *
> >     Auth_MySQL_Password_Table http_auth
> >     Auth_MySQL_Group_Table http_auth
> >     Auth_MySQL_Empty_Passwords  Off
> >     Require Group admins
> > </Directory>
>
> I didn't get the point what you want to do here?!


I would like to be able to use the [Auth_MySQL_DB *] directive in httpd.conf
to avoid having a .htaccess in each of my users admin directory. (see
example directive above)

> now, I guess you are building apache statically, right? In that case
> you will have to provide the libmysqlclient.a and libz.a as LDFLAGS to
> the build process.
>
> Another option is to rebuild apache in shared dynamic mode, which will
> create .dll files for each module (even the core).
>

I expected shared dynamic mode. This is how it comes with the cygwin disto,
right? So I followed the cygwin/apache docs:


I used the recommended configure from the cygwin/apache docs ...

$ ./configure \
--with-layout=Cygwin \
--with-port=80 \
--enable-rule=EAPI\
--enable-module=most\
--enable-shared=max\
--activate-module=src/modules/auth_mysql/libauth_mysql.a\
--with-perl=/bin/perl.exe\
--disable-module=src/modules/standard/mod_auth_dbm

... and added the last three parameters.

Which produced:
-----------------------
##
##  Inherited Makefile options from Configure script
##  (Begin of automatically generated section)
##
SRCDIR=.
EXTRA_CFLAGS=`$(SRCDIR)/apaci`
EXTRA_LDFLAGS=
EXTRA_LIBS=
EXTRA_INCLUDES=
EXTRA_DEPS=
OSDIR=$(SRCDIR)/os/cygwin
INCDIR=$(SRCDIR)/include
INCLUDES0=-I$(OSDIR) -I$(INCDIR)
SHELL=/bin/sh
OS=Cygwin
CC=gcc
CPP=gcc -E
TARGET=httpd
OPTIM=
CFLAGS1=-I/usr/local/mysql/include/mysql  -DCYGWIN -DUSE_HSREGEX -DNO_DL_NEE
DED
INCLUDES1=
LIBS_SHLIB=
LDFLAGS1=
MFLAGS_STATIC=--no-print-directory
REGLIB=regex/libregex.a
EXPATLIB=
RANLIB=ranlib
LIBS1= -L/usr/local/mysql/lib/mysql -L/lib -lz -lmysqlclient -lcrypt -lgdbm 
-lexpat
-----------------------------------

I then made minor changes to LIBS1 section. At the time I wasn't aware that
the libs need to be in LDFLAGS for dynamic build. So did I leave something
out during configure? For dynamic build, should the lib flags be in LDFLAGS1
or EXTRA_LDFLAGS, or it doesn't matter?

> Then you can tweak /usr/local/apache/bin/apxs as it is in the cygwin
> net distribution (this can't be done automatically from the apache
> build process for cygwin unfortunately).
>
> After you 'make' and 'make install' simply copy the apxs from the
> orginal distribution tree into your build install tree and then use
> apxs to compile the mysql_auth module like
>
>   $ ./apxc -c mod_auth_mysql.c
>
> in case you need to add LDFLAGS you can pass apxs the -L and -l
> options for the gcc.
>
> Hope I gave you a good roadmap.

Yes, very helpful, thank you :)

>
> BTW, why is the recompiling of mysql_auth necessary?
>

No it's not. However, in the latest ver (2.20), Zeev has changed the apache
directives. He's kindly providing a script to update .htaccess files but I'd
rather avoid that whole mess and go with all the latest as I just now begin
to add password security to my application. Furthermore, in 2.20 there have
been a number of fixes relating to crypt'ing that I'd like to get out of the
way.

Is the versioning the same between the cygwin distro and disto from Zeev?
i.e. does cygwin mod_auth_myslq 1.11-1 == mod_auth_myslq 1.11-1. I didn't
find a 1.11-1 in Zeev's rev history?


Thanks,

Bill
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/