Transfer Tool does not copy database user name in transfer tool

azadhussnain

• October 23, 2023 23:03

Hello, We are migrating accounts from DirectAdmin to cPanel from Transfer Tool. The problem we are facing is database user's name is not coming completely. For example, in DirectAdmin if the database user's name is bestvideostatus_265 then in cPanel it will be as bestvideostatus_2 The database name is same and it comes complete in cPanel, but the user name is not coming completely. We are using cPanel 114 and CloudLinux MySQL Governor with MariaDB. Do you know how can we fix it?

• 

  cPRex Jurassic Moderator

  • October 24, 2023 09:36

  Hey there! This is expected behavior with cPanel as we have a 16-character limit on database usernames:

  0
• 

  SimpleSonic

  • October 24, 2023 15:17

  There isn't a way to fix this, so you'd need to update your application after the migration to reference the adjusted username.

  
  I feel bad for the OP if they have a large amount of accounts and databases to migrate. :(

  0
• 

  ITHKBO

  • October 25, 2023 12:48

  Hey there! This is expected behavior with cPanel as we have a 16-character limit on database usernames: To allow usernames over eight characters in length, set the LONGUSERS: 1 environment variable in the /var/cpanel/whm/nvdata/root.yaml file.

  If you plan to use MySQL" or PostgreSQL" as a database engine, the first eight characters must be unique on the system. Note: You can disable database prefixing with the Add prefix to names of new databases and database users option in the SQL section of WHM"s ).

  To allow leading digits in a username, create the /etc/allowstupidstuff touch file.

  
  MIgration Tool should pick that up as far as I am aware if it is done before transfer. Granted any already transfered accounts need to be redone. Please correct me if I am interpreting the information wrong in the linked article.

  0
• 

  SimpleSonic

  • October 25, 2023 12:52

  cPRex isnt it mentioned in the article you can set it to higher? MIgration Tool should pick that up as far as I am aware if it is done before transfer. Granted any already transfered accounts need to be redone. Please correct me if I am interpreting the information wrong in the linked article.

  
  I believe that refers to the cPanel username, not the database username. @cPRex can correct me if I'm wrong.

  0
• 

  ITHKBO

  • October 25, 2023 13:06

  I believe that refers to the cPanel username, not the database username. @cPRex can correct me if I'm wrong.

  
  Which Is also why am curious about it because we can create it without problems and no warning message.

  0
• 

  cPRex Jurassic Moderator

  • October 25, 2023 15:15

  @azadhussnain - could you create a ticket so our Migrations team can do some testing with this? It seems I was wrong and this transfer should be allowed, as we used to have a character limit and that was fixed in version 102.

  0

Please sign in to leave a comment.