Databases with prefixes

[kevke]

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?

[joximu]

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.

[Lucan]

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

[joximu]

MYSQL_PREFIX = yes
MYSQL_PREFIX_TYPE = infront

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


/J

[Lucan]

thanks

[kevke]

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

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

[joximu]

ok, I close..