[SLUG] Re: Apache probs - Invalid command 'Alias', perhaps mis-spelled

[Matthew Palmer <mpalmer@xxxxxxxxxxx>]

On Mon, Jul 04, 2005 at 02:08:56PM +1000, Michael Lake wrote:
> The problem was many and varied. For a start a Debian upgrade some time ago 
> had added the following lines to my httpd conf file: 
> 
> # Please keep this LoadModule: line here, it is needed for installation.
> Include /etc/apache-perl/modules.conf
> Include /etc/apache/modules.conf
> 
> Mistake!: I'm running apache-perl and not apache and it was including two 
> module.conf files which were slightly different. Thats why I was getting 
> errors like "module config_log_module is already loaded, skipping"
> I commented out the include for /etc/apache/modules.conf and restarted 
> apache-perl.

Out of curiousity, why are you running apache-perl and not apache with
mod_perl?  I've never seen the attraction, myself (or for apache-ssl,
either).  I've heard speed mentioned, but I've never seen any stats to
support it, so I put it in the Gentoo bucket <grin>.

> I also needed to manually add "LoadModule auth_mysql_module 
> /usr/lib/apache/1.3/mod_auth_mysql.so"
> to the modules.conf file cause for some reason "/usr/sbin/apache-modconf 
> apache-perl" updated modules.conf but didn't add the required line.

A lack of properly formed -info file would cause apache-modconf to not see
the module, I believe.

> Then I just got the errors about: 
> Invalid command 'AuthMySQLCryptedPasswords', perhaps mis-spelled .....
> I had had this for 4 years in httpd.conf:
> 
>       AuthType Basic
>       AuthMySQLCryptedPasswords On
>       AuthMySQLHost 
>       AuthMySQLUser
>       AuthMySQLUserTable 
>       AuthMySQLNameField 
>       AuthMySQLPasswordField 
> 
> But now it seems the interface has changed. Even Crypt has changed to 
> Encrypted!

I think you were using a non-Debian-packaged edition of mod-auth-mysql.
3.2-1 (the version in Woody) doesn't have the AMCryptedPasswords option
(Auth_MySQL_Encrypted_Passwords is the equivalent).  There's lots of
different mod-auth-mysql modules out there, each with New! and Interesting!
configuration directives, and mod-auth-mysql has a tortured and fractured
history overall.  Feed me beer at a Spice Boys meet and I'll give you the
whole sorry, bitter tale.  Or I could make it into a SLUG talk: "Fear and
Loathing in Forked Projects".

> I found in /usr/lib/apache/1.3/500mod_auth_mysql.info the list of valid 
> directives.

Or /u/s/d/la-m-a-m/USAGE.gz, for that matter.  That one even has
explanations of what everything does.

> I then renamed each one above to the ones below one by one until 
> apache-perl-ctl configtest
> didn't complain anymore:
> 
>       AuthType Basic
>       AuthMySQL_Encrypted_Passwords On

Although the preferred option is

AuthMySQL_Encryption_Types Crypt_DES

(or add Crypt_MD5 if you'd like both hashing schemes).  It is preferred
because it's easier to comprehend which hash scheme gets tried when.

- Matt
(apt-cache show libapache-mod-auth-mysql | grep ^Maintainer <grin>)

Attachment: signature.asc
Description: Digital signature