Adding a domain with various extension produce a my sql creation failure

Submitted by bpds on Sun, 07/12/2009 - 09:36

i have :

pereira-da-silva.com pereira-da-silva.org ...

on the same server.

When adding pereira-da-silva.org virtualmin is not able to create a my sql table due to the existence of pereira-da-silva.com

B

Status: 
Closed (fixed)

Comments

Submitted by xps on Sun, 07/12/2009 - 10:42

I have just checked that on mine and setup a sub-server with same domainname but different TLD. I had no problems creating Databases.

I had: va.dom.com and the databses are named va and va_name than i added va.dom.net and those databases were named va_domain and va_domain_name etc.

the only problem i could see here would be if va_domain already existed.

Submitted by JamieCameron on Sun, 07/12/2009 - 12:12

bpds - could you tell me what error message you are getting from Virtualmin when you try to add a table (or is it a database) ?

Submitted by bpds on Mon, 07/13/2009 - 03:56

Error Failed to create virtual server : A MySQL user named pereira-da-silva already exists

Submitted by bpds on Mon, 07/13/2009 - 04:02

Jamie,

May be you will find something inspecting my screen shots..

Best

bpds

Submitted by JamieCameron on Mon, 07/13/2009 - 12:26

Ok, I see the problem .. because you already have a domain with the same name but .com, the .fr MySQL username clashes due to limits on the length of MySQL usernames.

The possible fixes are :

1) Create the new domain as a sub-server under the existing .com domain.

2) Enter a different username on the creation form, in the "Administration username" field.