Customers with usernames bigger than 14 characters, can't create database users

[Petrou Net]

It seems we have found a huge bug on Plesk 10.1.1
When username and underscore to the beginning of database user names is enabled, customers can't create database users if their account username is bigger than 14 characters.
This wasn't happening on plesk 10.0.1 or older plesk versions. It seems Plesk 10.1.1 doesn't trim the username if it's too big, when creating a database user.

This is a major problem, Parallels please fix it asap.

 

[IgorG]

http://forum.parallels.com/showthread.php?t=106113

 

[Petrou Net]

http://forum.parallels.com/showthread.php?t=106113

Ok IgorG, here are the details:

Product: Parallels Plesk Panel Linux 10.1.1, version: psa v10.1.1_build1010110120.18 os_CentOS
Operating System: CentOS 5 i386. Kernel: 2.6.18-194.26.1.el5PAE
Architecture: i386

Problem Description:
When username and underscore to the beginning of database user names is enabled, customers can't create database users if their account username has a length of 15 characters or more.

Steps to reproduce:
1. On Plesk Panel 10.1.1 enable the options "Add username and underscore to the beginning of database names" and "Add username and underscore to the beginning of database user names".
2. Add a customer account to Plesk Panel with a username length of 15 characters or more.
3. Try to create a database and a database user.

Actual Results:
The customer can create a database but when he/she goes to add a database user to the database, it's not possible, because the database user prefix (username and underscore) has already a length of 16 characters or more.
Plesk Panel has a 16 characters limit length for database users, so since the database user prefix length is already 16 characters or more, the customer can't type anything in the "Database user name" text box, therefore the database user can't be created.

Expected Results:
Plesk Panel 10.1.1 should trim the username to 5 characters when it's used as a database user prefix (username and underscore total length of 6 characters), allowing the customer to type up to 10 characters in the "Database user name" text box, when creating a database user. This was working correctly on Plesk Panel 10.0.1 and older Plesk Panel versions, but it's not working correctly on Plesk Panel 10.1.1

Additional Information:
Upgraded from Plesk Panel 10.0.1 to Plesk Panel 10.1.1 successfully.
This issue wasn't occurring in Plesk Panel 10.0.1 or Plesk Panel 9x versions.

 

[IgorG]

Thank you for detailed report.
I have forwarded it to developers and will inform you with results as soon as I receive it.

 

[Petrou Net]

More than a month have passed but this bug is still not fixed. Is there some temporary workaround for now?

 

[CoreyC]

I have confirmed this as well under Ubuntu 10, P10.0.1 and P10.1

 

[AtifQ]

This is beginning to get really frustrating.

Can someone please tell us if we are to expect any solutions to this sometime this month/year?

 

[IgorG]

This is beginning to get really frustrating.

Can someone please tell us if we are to expect any solutions to this sometime this month/year?

This bug was already fixed in Plesk 10.2 which will be released very soon.

 

[Petrou Net]

Thanks for the update IgorG,
We have just upgraded to Plesk 10.2, the bug no longer exists.