Hey,
I noticed this a while back, however I never connected the dots until today.
THE ENVIRONMENT:
I use a "user" naming schema of:
ABC1234
Each domain added to the system is given a unique username, and sub-domains share this username when created. Each domain is and sub-domain also are granted a single "database" (unless one is manually added afterwards)
The default database name schema is like this:
ABC1234 => top-level server (ex. mydomain.com)
ABC1234_mysub => sub-server (ex. mysub.mydomain.com)
THE ISSUE:
If I create two or more domains which use the "same" sub-domain, the first creates the database correctly using my schema above, while all additional domains end up getting different naming schema set by the system.
Ex.
ABC1000 => mydomain01.com
ABC1000_mysub => mysub.mydomain01.com
ABC2000 => mydomain02.com
ABC2000_mysub_mydomain02 => mysub.mydomain02.com
The problem with this is, all domain beyond the first one added to the system using the same "sub-domain" portion, end up breaking my preferred naming schema. Now I can go into the config, and manually change this, or even drop the database and create it manually using the Webmin tool, however this is not desired as this adds more time onto the process of creating new sub-domains, and requires me to remember to do so every time I create a sub-domain which matches another sub-domain.
What I'd prefer is to have the schema work out like this:
ABC1000 => mydomain01.com
ABC1000_mysub => mysub.mydomain01.com
and
ABC2000 => mydomain02.com
ABC2000_mysub => mysub.mydomain02.com
Frankly, I'm not sure if my situation is caused by a bug in the system, or perhaps somewhere the system is finding a conflict that I'm not aware of.
It's also worth noting, that in the above examples, both "mydomain01.com" and "mysub.mydomain01.com" are using the common username of "ABC1000", (the same is true for "mydomain02.com" and "mysub.mydomain02.com" which uses "ABC2000" respectively)
Thanks in advance!
Comments
Submitted by JamieCameron on Wed, 09/30/2009 - 13:03 Comment #1
Ok .. so just to be clear, the problem is that your database names are like ABC1000_mysub ABC2000_mysub_mydomain02 , when you would really prefer the second one to be ABC2000_mysub ?
There is actually a field on the domain creation form called "Default database name" which you can use to control this. Does that help?
I believe this may.
Wow, I feel stupid, cause totally overlooked those fields, given I normally don't have to alter the defaults.
Thanks Jamie!
I'll let you know if the problem persists beyond this.
Submitted by JamieCameron on Wed, 09/30/2009 - 15:00 Comment #3
Great! I'm pretty sure that this will fix it ..
Submitted by Issues on Thu, 10/15/2009 - 05:28 Comment #4
Automatically closed -- issue fixed for 2 weeks with no activity.