I'm trying to authenticate against my application's database, but I am currently running into some difficulties.
I'm not sure, if my setup is supported by your module. For a short overview; my app uses three tables
* 'user' holds all user information (id, login, password, status)
* 'group' contains the group data (id, groupname, status)
* 'membership' table (id, user_id, group_id)
As long as i am only authenticating users everything works fine, but I don't know how to handle the groups.
AuthMySQLGroupTable "group,membership"
causes SQL errors.
How can I handle this?
Thanks in advance,
s.alpers
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
AuthMySQLGroupTable - mysql group table name
AuthMySQLNameField - mysql User ID field name within User table
AuthMySQLGroupField - mysql Group field name within table
AuthMySQLGroupUserNameField - mysql User ID field name within Group table
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
thank you for your reply, but that's not exactly what I'm looking for. I missed the 'AuthMySQLGroupUserNameField', but your answer does not solve my question.
Is it possible to to query three tables. I described the setup in my first post.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I'm trying to authenticate against my application's database, but I am currently running into some difficulties.
I'm not sure, if my setup is supported by your module. For a short overview; my app uses three tables
* 'user' holds all user information (id, login, password, status)
* 'group' contains the group data (id, groupname, status)
* 'membership' table (id, user_id, group_id)
As long as i am only authenticating users everything works fine, but I don't know how to handle the groups.
AuthMySQLGroupTable "group,membership"
causes SQL errors.
How can I handle this?
Thanks in advance,
s.alpers
AuthMySQLGroupTable - mysql group table name
AuthMySQLNameField - mysql User ID field name within User table
AuthMySQLGroupField - mysql Group field name within table
AuthMySQLGroupUserNameField - mysql User ID field name within Group table
macftphttp,
thank you for your reply, but that's not exactly what I'm looking for. I missed the 'AuthMySQLGroupUserNameField', but your answer does not solve my question.
Is it possible to to query three tables. I described the setup in my first post.
Sorry, we really aren't set up to handle multiple group tables.
I'm not sure how you can get it to work with the user condition, either.