Ticket #1174 (closed defect: fixed)

Opened 4 years ago

Last modified 3 years ago

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

comment:1 Changed 3 years ago by benjamin

  • Status changed from new to closed
  • Resolution set to fixed

(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)

Note: See TracTickets for help on using tickets.