1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

ftp/mysql user name prefix

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by HaraldH, Feb 4, 2010.

  1. HaraldH

    HaraldH Guest

    0
     
    Hello,

    2 questions came around since we are using Plesk.

    In earlier versions it was possible to change the default MySQL db user name length. Is this also possible with Plesk 9.3? Adding db_user_length 10 to the misc table in the psa db has no effect. Usernames are still truncated after 5 characters.

    Is it possible to set a prefix to ftp users? I want to have the client login name prefixed to the ftp user name.

    Thanks
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    I have performed test on 9.3.0 version. I have created mysql user with 10 symbols password length. As you can see password was not truncated:

    Also adding ftp prefix require re-coding and not sure that it is so easy.
     
  3. HaraldH

    HaraldH Guest

    0
     
    The problem is not the length of the password. I'm having troubles with the length of the database username prefix. I've checked the options "Add user's login name and underscore to the beginning of database user names" and "Add user's login name and underscore to the beginning of database names" in the database hosting preferences. Our client login names are 10 characters long. When I now add a new database user the username (prefix) gets truncated to 5 characters. That's the problem.

    For example:
    client login name: h005124001
    database name: h005124001_db1 (prefix correct)
    database username: h0051_ (prefix truncated to 5 chars)

    Is there any possibility to extend the prefix to 10 characters?
    And is there an option to add a prefix to the ftp users? In that case (for example) h005124001_ftp1?

    Thanks
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Ok, I see.
    I have checked and found that is is impossible to change it with some database or config file options. Therefore it is hardcoded.
     
Loading...