Adding database → Error: db_user .. is not valid

[Rebbu]

I had this same issue - I had an account with a username that was 15 characters long, and then the "_" made it 16 so I couldn't add any users.

I modified the code differently however - I reduced the prefix to 8 characters with the underscore by modifying the v-add-database script as follows:

shortuser=${user:0:7}
database="$shortuser"_"$2"
dbuser="$shortuser"_"$3"

This works fine for me. I also modified the add/db/index.php so it would display the correct prefix on the frontend.

[worldspicejason]

Thanks Rebbu. This is exactly what I was looking for. What did you change in add/db/index.php to make it display correctly?

Thanks.

[Pong]

Error: db_user Mihanja80_Mihanja80 is not valid.
Put the panel for the test, the same problem!
I do not understand why you made a limit of 16 characters and does not show this warning in the panel? Simply print the warning on the entry form.

And if the user login will be 16 characters long, what to do then? :)

True, but this is a limitation imposed by mysql afaik.
Other control panels suffer the same fate.

It would be nice to allow the user to override the default in case the domain name is too long.
I love the auto-mode, but with a long domain name I still need this to work and it would be nice to shorten it myself (it would require an additional test I suppose to prevent collisions).

[skurudo]

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

Please vote for this feature.

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