View Single Post
  #1  
Old 1st August 2010, 22:14
fatbear fatbear is offline
Member
 
Join Date: Jul 2010
Location: Raleigh, NC US
Posts: 40
Thanks: 4
Thanked 8 Times in 4 Posts
Default UIDs, GIDs, and Database Naming

As I'm coming up to speed on ISPConfig3, I have a couple of questions:

1. I see in System > Interface Config the prefix for the Database name and the Database user. I changed the Database name prefix to:
[CLIENTNAME]_
I added the trailing underscore as a convention so to help avoid namespace collisions (as long as usernames are never assigned with underscores). For example, with usernames abc and abcdef, the database abcdefghi could have been created by either user without this naming convention.

2. I have the Database user prefix set to be:
[CLIENTNAME]
When I try to create a database without any additional characters typed in the Database user field, I get an error. This field should be optional. Do you agree?

3. What is the purpose of the Database password field? As far as I know, passwords are not assigned to databases, but instead to users. If that is what is meant here, I still see an issue: what if the database user already exists? I think the Database user should be renamed to be Database user password. Also, it appears that I cannot create two databases with the same database user. If this is so, I think this is a bug. It is reasonable for a user to have more than database.

4. I see UIDs and GIDs such as:
web1:client1
web2:client1
web3:client1
for each of the websites that are created. I would much rather have a more mnemonic naming. I'd like [CLIENTNAME] to be the GID. And, I'd like the UID to be something like [CLIENTNAME]_[DOMAINNAME] where [DOMAINNAME] is the actual domain name with the period (".") replaced by an underscore ("_"). Then, instead of the above, for the username "fatbear" and for the domains domain1.com, domain2.com, and domain3.com, you'd have:
fatbear_domain1_com:fatbear
fatbear_domain2_com:fatbear
fatbear_domain3_com:fatbear
Yes, it is verbose, but it is also guaranteed to be unique, and it makes it much easier to verify correctness when doing operations on a server.

How can I modify ISPConfig (either via the GUI, or by modifying the code) to enable this naming convention for UIDs and GIDs?
__________________
Steve Amerige, Fat Bear Incorporated
Server Leasing | Web Software Development | User Experience & Graphic Design
Managed Services, Website, Java, and Source-Code Hosting
Did my post help you? Click the Thanks button!
Reply With Quote
Sponsored Links