[prev in list] [next in list] [prev in thread] [next in thread] 

List:       webmin-l
Subject:    Re: [webmin-l] Virtualmin and mysql user name limits
From:       "Jamie Cameron" <jcameron () webmin ! com>
Date:       2004-09-21 23:31:56
Message-ID: 1095809516.12342 () fudu ! home
[Download RAW message or body]

Sean Patrick wrote ..
> Hello,
> 
> I have found an issue with virtualmin and mysql
> database user names.
> 
> I have Virtualmin creating new databases for clients.
> 
> If the domain user is superduperdomain.com, the
> database is automatically called
> "superduperdomain_com". The mysql user automatically
> created is "superduperdomain" (16 characters max).
> 
> In every test, only 16 characters show up, including
> some domains which have a "." in them eg.
> "blahsupdomain.com" in virtualmin = "blahsupdomain.co"
> in the user permissions mysql webmin module.
> 
> Is 16 character usernames a limitation of mysql? Is
> there a way to make the virtualmin mysql database
> creation a bit more intuitive?

The 16 character limit is a restriction imposed by MySQL. Virtualmin truncates all \
MySQL usernames to this so that they actually work ..

Also, it replaces any . in database names with _, as the . can cause problems with \
some MySQL versions.

 - Jamie


-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
-
Forwarded by the Webmin mailing list at webadmin-list@lists.sourceforge.net
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list


[prev in list] [next in list] [prev in thread] [next in thread]