ispCP - Board - Support
Databases with prefixes - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Databases with prefixes (/thread-8592.html)

Databases with prefixes - kevke - 11-27-2009 08:14 PM

I was wondering, I know that prefixes are possible in the manor like Databasenumber_Databasename, Databaseusernumber_Databaseusername, whoever, in most other Controlpanels you can set Databases like [customer]Databasename, and [customer]Databaseuser.

I have heard it is possible and the setup for this is in the ispcp.conf

I think the important part is this:

MYSQL_PREFIX = yes

# '' for MYSQL_PREFIX = no,
# 'infront' or 'behind' for MYSQL_PREFIX = yes
MYSQL_PREFIX_TYPE =

If it is in there, how do I have to set it, so that as a prefix like [customer] is forced.

I crossposted this request as well in the German section, but all I got so far is numbered databases, like 1_Databasename. Any Ideas?

RE: Databases with prefixes - joximu - 11-28-2009 01:47 AM

MYSQL_PREFIX_TYPE = 'infront'

I recommend this for every ISP.

My points:
you need a prefix otherwise two customers want a DB named test -> problem
you need a short prefix because the username length is limited (16 chars) -> therefore only customer number...
prefix must be infront otherwise a 16 char db username is not unique (or you should check the length so a prefix at the end can be added).

If you add a customer name as prefix - eg. "testdomain.com" then you are in troubles with the length of the user name.

RE: Databases with prefixes - Lucan - 11-28-2009 02:11 AM

Joximo, how can i use the vu20xx as a prefix?

RE: Databases with prefixes - joximu - 11-28-2009 02:14 AM

MYSQL_PREFIX = yes
MYSQL_PREFIX_TYPE = infront

then the xx_ will be the prefix (1_, 2_, 3_, ..., 10_, 11_, ...., 100_, 101_ etc)


/J

RE: Databases with prefixes - Lucan - 11-28-2009 03:45 AM

thanks Wink

RE: Databases with prefixes - kevke - 11-28-2009 05:14 AM

(11-28-2009 03:45 AM)Lucan Wrote:  thanks Wink

Tagg it and bag it, This thread is closed!
Thanks a lot

RE: Databases with prefixes - joximu - 11-28-2009 07:11 AM

ok, I close..