Ticket #1174 (closed defect: fixed)
No check of too long MySQL users
| Reported by: | daniche | Owned by: | anonymous |
|---|---|---|---|
| Priority: | normal | Milestone: | alternc-0.9.10 |
| Component: | Bureau: bases de données | Version: | alternc-0.9.9 |
| Severity: | major | Keywords: | #1074 |
| Cc: |
Description
In alternc database, MySQL users max length is 16 characters.
When creating a new dbuser through alternc where alterncUser_dbUser has more than 16 characters, there is a bug: AlternC shows a user named alterncUser_alterncUser, but no configuration or deletion is possible. You have to erase them in the alternc database.
A direct consequence is that an alternC user with a login longer than 15 characters, cannot create additional db users.
There should be some sanity check in the php scripts.
I don't know it the 16 char length is needed by MySQL, but if not, maybe better to modify the AlternC dbuser table.
Change History
Note: See
TracTickets for help on using
tickets.

(In [2620]) Fixed #1174 : we check the length of mysql login everywhere. + english comments and misc code cleanup (hook functions at the end of the class)