[NTLUG:Discuss] OT: mod_auth_mysql

[JM5379@sbcglobal.net]

Excuse the OT but I couldn't find any place specifically for
mod_auth_mysql questions:

I'm trying to authenticate users who may be members of several
groups.  I can get 
authentication to work with "require valid-user", but not with
"require group growth".

i had a groups field in user_auth initially, and could get
authentication against "valid-user", 
"user" and "group", but that will not allow multiple groups;
multiple groups requires a separate 
table from what i've read so far.

can anyone tell me what i'm missing in the information below, or
where i need to direct 
this request to?


The Apache server is:
Apache/1.3.26 (Unix) Debian GNU/Linux PHP/4.1.2
mod_fastcgi/2.2.10 AuthMySQL/3.1
 mod_ssl/2.8.9 OpenSSL/0.9.6g

This is my mysql user_auth table:
fields: comp_uid        password        (comp_uid is PRIMARY)
values: username

and my mysql group_auth table:
fields: comp_uid        groups  (comp_uid + groups is PRIMARY)
values: username        growth
        username        test

This is my .htaccess file

AuthName "Growth Users"
Auth_MySQL_DB common_data
Auth_MySQL_Password_Table user_auth
Auth_MySQL_Username_Field comp_uid
Auth_MySQL_Password_Field password
Auth_MySQL_Empty_Passwords on
Auth_MySQL_Group_Table group_auth
Auth_MySQL_Group_Field groups
AuthType basic
require group growth
#require valid-user


thanks,
joe