Post Reply  Post Thread 
MySQL databases
Author Message
rexcze Offline


rexcze



Posts: 1
Group: Registered
Joined: Mar 2007
Status: Offline
Reputation: 0
Post: #1
Question MySQL databases
Hi,
I have one question. If we deploy ispCP on webhosting server and if we will have a lot of people with a lot of databases with its names is there any posibility how to make those names unique?
For example:
customer hello.com has mysql database name PEDRO and
customer hiThere.eu want to have database name PEDRO too. Is there a way?

Thanks for reply...
11-03-2007 06:29 PM
Find all posts by this user Quote this message in a reply
joximu Offline
Moderator
*****

joximu
Moderator
*****


Posts: 3,604
Group: Moderators
Joined: Jan 2007
Status: Offline
Reputation: 47
Post: #2
RE: MySQL databases
Yes

You can set the configuration to use a prefix for mysql databas names.

so the first user always has 1_PEDRO, the second customer 2_PEDRO

of course the numbr of characters for the database is reduced by the prefix...

/J

2008-08-05 ispCP RC6 released!!!
11-03-2007 07:15 PM
Visit this user's website Find all posts by this user Quote this message in a reply
chris41g Offline
Newbie
*

chris41g
Newbie
*


Posts: 5
Group: Registered
Joined: Oct 2007
Status: Offline
Reputation: 0
Post: #3
RE: MySQL databases
can we make the prefix the customer name?
like this:
domain.tld_databasename
11-05-2007 11:50 AM
Find all posts by this user Quote this message in a reply
joximu Offline
Moderator
*****

joximu
Moderator
*****


Posts: 3,604
Group: Moderators
Joined: Jan 2007
Status: Offline
Reputation: 47
Post: #4
RE: MySQL databases
Sure - you have the source code.

It's not a built-in option today. Just think about: a MySQL username should not be longer than 16 characters. So if you have a long domain name you're in troubles...

I like the number...

2008-08-05 ispCP RC6 released!!!
11-05-2007 06:06 PM
Visit this user's website Find all posts by this user Quote this message in a reply
rbtux Away
Member
***

rbtux
Member
***


Posts: 1,200
Group: Registered
Joined: Feb 2007
Status: Away
Reputation: 22
Post: #5
RE: MySQL databases
customernumber would be better IMHO

OS: Debian Lenny
ispCP Version: Trunk r1033
Activated: AWStats dynamic, Dovecot, Avelsieve, Selective Greylisting, Bogus MX Filter,
No Webtools, Roundcube, Some own modifications
11-05-2007 06:36 PM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
Moderator
*****

joximu
Moderator
*****


Posts: 3,604
Group: Moderators
Joined: Jan 2007
Status: Offline
Reputation: 47
Post: #6
RE: MySQL databases
Yes and the same scheme should also work for the MySQL users
- domain name might be too long (punicode...) - mysql usernames are limited to 16 chars
- domain name has a . (dot) which has to be replaced
- it's too long to write.

/J

2008-08-05 ispCP RC6 released!!!
11-05-2007 10:41 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply  Post Thread 

View a Printable Version
Send this Thread to a Friend
Subscribe to this thread |

Forum Jump:

| All rights reserved : isp-control.net |