Maximum Length for User Accounts

Discussion in 'Installation/Configuration' started by stargazer, Apr 18, 2008.

  1. stargazer

    stargazer New Member HowtoForge Supporter

    I am running into a problem with longer domain names. It is my understanding that the max domain length as per the RFC's is 256 char between each dot. However, I have gotten a descriptive, but lengthy, domain name for a client, and now can not add a user to it. The domain name is 27 characters (oklahomaprivateinvestigator.net) not counting the suffix. I may have to move it to a different box. Any suggestions?
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Are you using the domain name as the prefix for the user names?
     
  3. stargazer

    stargazer New Member HowtoForge Supporter

    domain name as prefix for user name

    yes, and am unsure of what would happen if I changed that right now. I originally did it as it was more inuitive to the client -- "it is just your e-mail address backwards" -- but it does seem to have some unforseen consequences. Do you know what happens if I change that option? Will it just create future names based on the domain number?

    Or, is there a way to increase the column size within the database without totally messing things up?

    No longer critical; I have placed the domains in question on another machine. No e-mail accounts associated with these domains: I just needed an ftp login for the client so they could upload their web site.
     
  4. webwork

    webwork New Member

    The database stores hosts and domains at 255 chr

    I looked and the database stores hosts and domains at 255 chr each. There are two tables, the sysuser and isp user tables, one field in th sysuser has an email length of 30chr the rest have 255
     
    Last edited: Apr 18, 2008
  5. stargazer

    stargazer New Member HowtoForge Supporter

    What happens if I just change the way usernames are generated

    Do you have any way of knowing what happens if I just change the way usernames are generated? In other words, go back to the webxxx_username. This is a production machine, and my test machine is down right now.

    Finally, is there a document somewhere that describes how this whole thing is put together? I'd love to read that, if it exists. It has worked out as a pretty good program, but there are a few minor changes I'd like to make in it; I'm just afraid of messing something up, and haven't taken the time to dig through all the code to figure out How It All Works.
     
  6. falko

    falko Super Moderator ISPConfig Developer

    The problem is not the database, but the length restriction that Linux has for system user names.

    Unfortunately I can't tell you what happens when you change the prefix. I *think* that existing user names should be left as they are, but I'm not 100% sure... :eek:
     
  7. webwork

    webwork New Member

    Usernames should all be in the MySQL database

    The usernames should all be in the MySQL database, I see nothing to suggest otherwise which means that most likely the page coding is restricting the length as it referances a field. A hard code into the DB to extend an existing short name would be an interesting test to see what happens.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    As falko pointed out, the problem is not ISPConfig or the length of the database field, the problem is the max. length of linux usernames. We tested with longer usernames on several distributions but it causes issues on some older distributions, thats why the length is restricted.
     
  9. stargazer

    stargazer New Member HowtoForge Supporter

    What happens if I just change the way usernames are generated

    then, how about the second question. What happens if I change the way usernames are generated on an already working system. Do I just need to build a test machine to find out (not a big deal, just won't do it if you already know the answer).

    BTW, thanks for the answer. I did not think of older distro's (which is why I'm not working on a project like this, I guess), so did not think about the usernames, though I did notice they were getting pretty large.
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    You can change the username prefix, it will affect only new usernames.
     
  11. stargazer

    stargazer New Member HowtoForge Supporter

    thank you

    Ok, thanks to everyone who responded. Gives me a way to go.
     

Share This Page