Set up an Affiliate Account or Set up a Small Business account.
ISPConfig is based on a reseller environment, where you have zero or more resellers who can add clients and manage domains. This is not required, for example, as administrator, you can create clients directly bypassing re-sellers completely. And in fact, you don’t need either, the admin has full capabilities.
To allow for this, there must be a uniq identifier for each client or reseller. This identifier is then added to the name of objects that are created. For instance, if we have a reseller with an id of 1, and they create a database named “MyDB”, then internal to the sql server, the database is actually named “1MyDb”. If you added a second client and they were id 2, then they would have a database of “2MyDb”.
This may seem simple at first, but when you add in the FTP clients Shell users and Wedav users, it can get complicated quickly. And remember, this is just for uniq resellers and clients. If you factor in reseller that have multiple clients , then the reseller id would be appened to the client id and added to the database name. So you could have a db name of “12MyDb” this can be a nightmare.
Now, I am sure that it is more my lack of understanding here than anything else, but in any event, I still needed a method of handling the problem encountered. After playing around for a while, it seemed that the best way to handle this, for me, was set the prefixes to add a “d” plus the domain to the prefix for the Database, FTP User, Shell User and Webdav user prefixes.
To compensate for the complexities of this enviromnent, we have implemented the prefix scheme where any user id’s, FTP, Shell or webdav users will be prepended with the c[CLIENTID]d[DOMAINID] prefix. This will allow for all user names to be the same. For example, when you create a new FTP id for a domain, you can always use the id of ftpadmin and be guaranteed the name will be uniq as in c1d1ftpadmin.
For the Database user we require only the c[CLIENTID] portion of the prefix as a single client can manage multiple databases.
- Logon to the ISPConfig3 interface.
- Select the System Tab
- Select Main Config from the menu on the left side.
- In the Sites area, Add d[DOMAINID] to the end of the Database name prefix so that it appears as c[CLIENTID]d[DOMAINID].
- Repeat this process for the FTP, Shell and Webdav user prefix entries.
- Select the Save button at the bottom of the page.