[cobalt-users] WG: Install mod_auth_mysq 2.2.20l as DSO on RAQ4

[Cédric Haindl <c.haindl@xxxxxxxxx>]

Okay, I found out, why I couldn't post. Wrong sender-address. Sorry for
that. I'm getting old.

Regards
Cédric

> -----Ursprüngliche Nachricht-----
> Von: Cédric Haindl [mailto:c.haindl@xxxxxxxxx]
> Gesendet: Friday, January 04, 2002 10:28
> An: Cobalt-Users@List. Com
> Cc: Cobalt-Developers@List. Com
> Betreff: WG: Install mod_auth_mysq 2.2.20l as DSO on RAQ4
>
>
> It seems, that I was not able to post to the forum, as I did not
> receive the message myself, nor did it show up in the archives.
> So I'll dare to post again. Sorry if shows up several times, I
> don't want to hassle anyone.
>
> Regards
> Cédric
>
> > -----Ursprüngliche Nachricht-----
> > Von: Cédric Haindl [mailto:c.haindl@xxxxxxxxx]
> > Gesendet: Friday, January 04, 2002 02:06
> > An: Cobalt-Users@List. Com
> > Cc: Cobalt-Developers@List. Com
> > Betreff: WG: Install mod_auth_mysq 2.2.20l as DSO on RAQ4
> >
> >
> >
> > Hi,
> >
> > Sorry for the crosspost, but I have a very, very big problem
> > (fighting with the system, it seems ;-). I had to restore my Raq4
> > and installed all the latest patches of course (hope, they're
> > well-tested). For one site I use mod_auth_mysql, which is a very
> > nifty tool. Unfortunately it does not work anymore. I was more
> > than reluctant to compile it into Apache, since I'm fearing the
> > possible and unknown sideeffects on the cobalt platform. You
> > never know, if future patches will spoil your quirks or not.
> >
> > Anyway. I want to go for the DSO-Solution. I installed the latest
> > Apache-Package RaQ4-All-Security-1.0.1-10602.pkg with Apache
> > 1.3.20, and the "unofficial" packages for mysql 3.23.37 and PHP
> > 4.0.6 with GD and ChiliASP 3.6 for Cobalt, from the Cobalt-Website.
> >
> > I mainly followed the instructions in
> > http://list.cobalt.com/pipermail/cobalt-developers/2000-September/
> > 024369.html bei Audric, but without his addendum in
> > mod_auth_mysql.c, since it produced errors with quad.h I
> downloaded from
> > http://linux-m68k-cvs.apia.dhs.org/c/cvsweb/linux/include/math-emu
> /quad.h?sortby=rev (I probably had the wrong > version anyway).
> >
> > Could it be, that mod_auth_mysql 2.2.20 is not compatible with
> > Apache 1.3.x, as I've read somewhere. I've read the post by Zeev
> > Zuraski, who wrote it
> > (http://bugs.apache.org/index.cgi/full/2659). I alse read, that
> > Vivek Khera wrote a modified version, but the link to this
> > homepage does not work
> > (http://www.bitmechanic.com/mail-archives/mysql/Aug1998/0127.html)
> > . Must be Murphy.
> >
> > This is, what I did:
> >
> >
> > # su
> > # gunzip mod_auth_mysql-2.20.tar.gz
> > # tar xvf mod_auth_mysql-2.20.tar.gz
> > # cd mod_auth_mysql-2.20
> > # ./configure --with-mysql=/usr --with-apxs=/usr/sbin
> >
> > Then I get that
> > creating cache ./config.cache
> > checking for gcc... gcc
> > checking whether the C compiler (gcc  ) works... yes
> > checking whether the C compiler (gcc  ) is a cross-compiler... no
> > checking whether we are using GNU C... yes
> > checking whether gcc accepts -g... yes
> > checking whether gcc and cc understand -c and -o together... yes
> > checking for ranlib... ranlib
> > checking how to run the C preprocessor... gcc -E
> > checking for crypt.h... yes
> > checking for crypt... no
> > checking for crypt in -lc... no
> > checking for crypt in -lcrypt... yes
> > checking for standard DES crypt... yes
> > checking for extended DES crypt... yes
> > checking for MD5 crypt... yes
> > checking for Blowfish crypt... yes
> > checking for Apache module support via DSO through APXS...
> > ./configure: /usr/sbin: is a directory
> > yes
> > checking for Apache module support via DSO through APACI... no
> > checking for MySQL directory... /usr
> > updating cache ./config.cache
> > creating ./config.status
> > creating Makefile
> > creating libauth_mysql.module
> > creating config.h
> >
> > Please run 'make'
> >
> > # cp config.h auth_mysql_config.h
> > # make
> >
> > Then I get this error-message
> >
> > /usr/sbin -i -a -n auth_mysql libauth_mysql.so
> > make: execvp: /usr/sbin: Permission denied
> > make: *** [install] Error 127
> >
> >
> > # /usr/sbin/apxs -i -a -I/usr/include/mysql -L/usr/lib/mysql
> > -lmysqlclient -c mod_auth_mysql.c
> >
> > This runs okay, but isn't of much use probably, because of the
> > make problem.
> >
> > Here are contents of my httpd.conf:
> >
> > LoadModule auth_mysql_module  /usr/lib/apache/mod_auth_mysql.so
> > AddModule mod_auth_mysql.c
> > Auth_MySQL_Info localhost root password
> >
> > Then I restarted Apache.
> >
> >
> > Everything seemed to install well and I altered all my
> > .htaccess-files in the sites-directory so the include the
> > directive Auth_MySQL off, so the override MySQL and use .htpasswd
> > instead. For my special site I used a .htaccess-file with the
> > following content:
> >
> > AuthName "Testlogin"
> > AuthType Basic
> > require valid-user
> > Auth_MySQL_Encryption_Types Plaintext
> > Auth_MySQL_DB auth_db
> > Auth_MySQL_Password_Table mysql_auth
> > Auth_MySQL_Group_Table mysql_auth
> > Auth_MySQL_Username_Field username
> > Auth_MySQL_Password_Field passwd
> > Auth_MySQL_Group_Field groupname
> > Auth_MySQL_Encrypted_Passwords off
> > Auth_MySQL on
> > Auth_MySQL_Empty_Passwords off
> > order deny,allow
> > allow from all
> >
> >
> >
> >
> > Somehow it seems to work partially, because it recognizes
> > Auth_MySQL on and off, but a soon as it is on, I get an internal
> > server - error. If somebody could help me, I would be
> > extreeeeeemely thankful.
> >
> > Thank you very much.
> >
> > Regards
> > Cédric
> >
> >
> > Haindl Mediendesign GmbH | Untermueli 11 | 6300 Zug
> > Tel: +41-41-763 30 85 | Fax:+41-41-763 30 86
> > ISDN (Leonardo) +41-41-763 30 89 | Mobile: +41-78-843 37 36
> > Email: mailto:c.haindl@xxxxxxxxx | Internet: http://www.haindl.ch