Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Jul 2004
    Posts
    11

    Default not yet another username max lenght

    ok, just so this doesnt sound too much like the 400 other questions on how to make longer usernames, this isnt..
    due to my research on cpanel before hand we have from day1 had max 25 character usernames
    thanks to the editing of the wwwacct trick,
    recently a customer has come forward wanting to setup their database, now their username is mynewdomaincom (example) so their mysql database is mynewdomaincom_newdb
    this has the small problem that the max characters of the users table is 16 characters, i have edited this up to 100, on top of that found a suggestion for the modification to the whostmgr2 file which i have also completed.
    the problem remains, a user can go in and create a database, but....
    1 it doesnt show up in myphpadmin
    2 doesnt show up under the sql change password for databases in the cpanel manager

    so
    my question is .. has anyone gotten around this ? or has nobody encountered this so far (i doubt I could be the first)
    if i create the domain with a username of 8 or less characters all is fine

    any ideas are very welcome...

    ps this i think is something that cpanel should really address, even if its a option somewhere to set max username character lenght on install and default it to 8, there are very few distros out there these days that have a 8 character max...

    regards Jav
    Last edited by javelin; 12-15-2004 at 02:05 AM.

  2. #2
    Member
    Join Date
    Jul 2004
    Posts
    11

    Default

    anyone anyone ?
    minty for the first person with the correct answer..

  3. #3
    Moderator cPanel Partner NOC Badge dgbaker's Avatar
    Join Date
    Sep 2002
    Location
    Toronto, Ontario Canada
    Posts
    2,773

    Default

    That is exactly why cPanel has left things at 8 char. for usernames, it wrecks havoc with sql.
    Regards,
    David
    Forum Moderator

  4. #4
    Member
    Join Date
    Jul 2004
    Posts
    11

    Default

    It doesnt seem to be a problem with the database creation,
    the username and the database get created fine.
    its the linking between phpmysql and the database that seem to be at odds.. .

    without changing the max characters in the users field (from 16) the database gets truncated, but still doesnt show up in phpmyadmin.

    wonder if i need to compile phpmyadmin outside of cpanel for this to work ?...


    jav

  5. #5
    cPanelBilly
    Guest

    Default

    Quote Originally Posted by javelin
    It doesnt seem to be a problem with the database creation,
    the username and the database get created fine.
    its the linking between phpmysql and the database that seem to be at odds.. .

    without changing the max characters in the users field (from 16) the database gets truncated, but still doesnt show up in phpmyadmin.

    wonder if i need to compile phpmyadmin outside of cpanel for this to work ?...


    jav
    There is a specific reason that cPanel does not allow longer DB names, and this is it. We dont suggest nor afvise changing it. It can cause many issues and may be overwritten at a later date.

Similar Threads & Tags
Similar threads

  1. Username - Max 8 letter and no number???
    By ko-kylling in forum New User Questions
    Replies: 12
    Last Post: 02-21-2011, 07:37 AM
  2. UserName is too long -> max 8 letters
    By uur in forum cPanel and WHM Discussions
    Replies: 5
    Last Post: 05-20-2007, 11:36 AM
  3. Max username length = 8 chars?
    By bjg in forum cPanel and WHM Discussions
    Replies: 5
    Last Post: 03-23-2004, 04:11 PM
  4. WHM username max length
    By gemininetcom in forum cPanel and WHM Discussions
    Replies: 7
    Last Post: 12-19-2003, 03:27 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube