Username length and database creation

[sau]

When creating a user - no prompt about length of username. As a result - if the user name 15 or more characters - this user can't create a database.

[kusspaprika.com]

Same problem here.
I read that MYSQL has hard coded 16char for Username.
So it seams the Username of VCP-User has to be limited + the MYSQL-User must limited to max length.

Will this solved next release?

Is a workaround out there (without new registration of the user)

@The VCP Team: You are doing a great job!



... I found more information on this.
viewtopic.php?f=14&t=6740

[sau]

It will be a nice fix of this issue to make an option for use or no the prefix in database names.

[skurudo]

So it seams the Username of VCP-User has to be limited + the MYSQL-User must limited to max length.Will this solved next release?

It will be a nice fix of this issue to make an option for use or no the prefix in database names.

But how? It's MySQL limitations, not VestaCP
It was light hope, MariaDB will support long username, I was wrong.
Long usernames supports, but by dirty hack and patch. Works that not stable.

... I found more information on this.
viewtopic.php?f=14&t=6740

Nice to see link on my answer. ))

[kusspaprika.com]

I think another way is to shortening the username if its used for MySQL users prefix
+ limit the MySQL usernames so its not more than 15 characters.

It will be a nice fix of this issue to make an option for use or no the prefix in database names.

Thinking...
It would be a nice solution if I can set a MySQL prefix in user-profile, the standard would be a shorten username.

Shortening username to 7 characters, probably like this:

Code: Select all

$username = "brennholzhandel-boxberg.de";

if (strlen($username) >= 7) {
    echo substr($username, 0, 4). "-" . substr($username, -2);
}
else {
    echo $username;
}

--> $username = "bren-de";

+ MySQL-Username-field-limit to 8 characters, could do it.

What do you think?
Hope we can find a good solution for all.

Regards

[skurudo]

the database user should be not longer than 16 characters (together with the prefix of user)

but if you want it so badly, there is not tested officially fix - viewtopic.php?f=14&t=4927#p14320

[skurudo]

Added idea on bugtracker:
https://bugs.vestacp.com/issues/258

Please vote for this feature.

Discussion topic:
viewtopic.php?f=14&t=11522