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?
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.
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
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.
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...
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.
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.
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.
