PDA

View Full Version : Client username length bug


bwragg
8th January 2007, 03:09
I just had a reseller contact me about 4 sites that they setup but were unable to login to each sites control panel.

After a bit or playing around I figured out that they were setting up the clients username (on the "Login Data" tab) as something like "looooooooooooooongdomain.com" . When they pressed save it appeared to get saved (no error) and when they went back to the tab the same username was displayed.

But when I do a select * from sys_user I can see that the username thats actually getting saved is "looooooooooooooongdo", the rest of the username is being cut off. This is due to the username having a limit of 20 chars.

So firstly, is it possible to change the length of the field without any dire consequences to the workings of ISPConfig?

Secondly, if it field can't be changed, is there a form that can be changed to limit the max characters to 20 on the "Login Data" tab.

Thanks,

Benjamin

till
8th January 2007, 11:09
This filed can be changed in sys_user. Please set the username field in sys_user to varchar 255. I put this issue on the bug list.

bwragg
8th January 2007, 13:41
Thanks Till. Just changed it using

alter table sys_user change username username VARCHAR(255);

Seems to have fixed it. Thanks.

Cheers,

Benjamin