Hi, I'm actually using 2 tables for username and group. (see below)
Username
----------------------------------------------
| username | password | status |
----------------------------------------------
groups
----------------------------------------------
| FK_username | FK_groups |
----------------------------------------------
And I want to know how I can specify a different row for the username in the group table. Because, actually, the module (mod_auth_mysql 2.90) seen like using the row name that I specify be the parameter AuthMySQLNameField.
Does it exist a parameter like AuthMySQLGroupUsernameField ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No, currently mod_auth_mysql doesn't allow you to specify a different column name for the username in the group table. As you found, it uses the same column name as in the user table.
However, this does sound like a good idea; others may have the same setup as you.
I looked at the code, and it doesn't seem like there would be a lot of work involved. Mainly adding a new parameter to the configuration and accounting setting the default to be the same as is currently used.
I'd appreciate it if you could add your request to the Request For Enhancements (RFE) database here. That way we can look to including it in the next release.
Thanks,
Jerry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I'm actually using 2 tables for username and group. (see below)
Username
----------------------------------------------
| username | password | status |
----------------------------------------------
groups
----------------------------------------------
| FK_username | FK_groups |
----------------------------------------------
And I want to know how I can specify a different row for the username in the group table. Because, actually, the module (mod_auth_mysql 2.90) seen like using the row name that I specify be the parameter AuthMySQLNameField.
Does it exist a parameter like AuthMySQLGroupUsernameField ?
Hello,
No, currently mod_auth_mysql doesn't allow you to specify a different column name for the username in the group table. As you found, it uses the same column name as in the user table.
However, this does sound like a good idea; others may have the same setup as you.
I looked at the code, and it doesn't seem like there would be a lot of work involved. Mainly adding a new parameter to the configuration and accounting setting the default to be the same as is currently used.
I'd appreciate it if you could add your request to the Request For Enhancements (RFE) database here. That way we can look to including it in the next release.
Thanks,
Jerry