First 8 characters conflict with one or more other usernames

[HostXNow_Chris]

Hi,

Any idea how to turn off the following when trying to migrate cPanel accounts from one server to another?

The following <insert number> remote users are set to migrate with new names whose first 8 characters conflict with one or more other proposed new usernames. To resolve this, you can either rename the incoming accounts or deselect them.

When migrating many servers at the same time it can really slow the work rate down. I read somewhere if using MariaDB it would not do this but it is with latest version 10.3

 

[sparek-3]

Welcome to cPanel... where what we do, doesn't always make a lot of sense.

Kudos to whoever it was that thought allowing longer than 8 character usernames would be a great idea - so long as the first 8 characters are unique! Great idea!

Seriously though, yea this was enabled in cPanel some time ago when most were still using MySQL which had a certain character limit. MariaDB greatly lifted this limit and it may now be lifted in MySQL. But the cPanel system still requires the first 8 characters of every username to be unique.

I said it then and I'm still saying it... if the first 8 characters of a username have to be unique... then what's the point of having longer than 8 character usernames? That's just stupid if you ask me. Either lift the restriction on the first 8 characters having to be unique (which depends on MySQL/MariaDB username limits, of which I have not followed) or the inclusion of longer than 8 character usernames never should have been enacted.

 

[cPanelMichael]

Hello @HostXNow_Chris,

With MariaDB, you can disable the following option under the SQL tab in WHM >> Tweak Settings to bypass the eight-character unique username requirement:

Require a username prefix on names of new databases and database users

Here's this option's description:

When this option is enabled, the system will require that the name of each new database or database user from a cPanel session begin with the system username and an underscore (_). This makes it easier to tell which user owns a given database, but it also restricts the number of characters that users can use for names of databases and database users. Note that if the username changes at a later point, the name of the database or database user does NOT change. Also, while older cPanel API calls automatically add this prefix, newer API calls expect the caller to add it.

Let me know if this helps.

Thank you.

 

[HostXNow_Chris]

Hello @HostXNow_Chris,

With MariaDB, you can disable the following option under the SQL tab in WHM >> Tweak Settings to bypass the eight-character unique username requirement:

Require a username prefix on names of new databases and database users

Here's this option's description:



Let me know if this helps.

Thank you.

I did not see that setting before. I wish I knew that before spending 2 hours doing it all manually.

I shall try it. Thanks.

 

[HostXNow_Chris]

@cPanelMichael actually I already found that setting and turned it off, but it still shows the same error as mentioned before?

Why does it say it is going to rename the database from a name to the same name as below

Error: The following 9 remote users are set to migrate with new names whose first 8 characters conflict with one or more other proposed new usernames. To resolve this, you can either rename the incoming accounts or deselect them.

“user1” is set to be renamed “user1”.
“user2” is set to be renamed “user2”.
“user3” is set to be renamed “user3”.
“user4” is set to be renamed “user4”.
“user5” is set to be renamed “user5”.
“user5” is set to be renamed “user6”.
“user6” is set to be renamed “user7”.
“user7” is set to be renamed “user8”.
“user8” is set to be renamed “user9”.

Bug?

 

[cPanelMichael]

Hello @HostXNow_Chris,

Can you report the issue from your last response using our Defects link so we can confirm why that's happening? You can post the ticket number here once it's opened.

Thank you.

 

[HostXNow_Chris]

Ok. I created it.

Your Request ID is: 12352621

 

[Steini Petur]

Fantastic, I am running into the same issue right now, I just setup a Cloudlinux 8.5 with cPanel latest, and it defaulted to Mysql 8.0 which I can only assume would work but I am running into issues like

Error: The following 4 remote users are set to migrate with new names whose first 8 characters conflict with one or more other proposed new usernames. To resolve this, you can either rename the incoming accounts or deselect them.

Then I have them like so

"wanderin" will be renamed to "wanderin"

I checked and I have two accounts one is called

wanderingsomething with user wanderin
wanderingreselleraccount with user wanderingreseller

Literally same first 8 letters on an old Centos 6 with MariaDB installed, Im upgrading, and Im stuck at migrating 8 accounts all by some resellers because they have "johndoe" and "johndoedoe" as actual usernames longer than 8 letters..

It wont let me copy this over as is

Id love if i could get what was the solution to this case, attaching the image.. Im postponing the migration until tomorrow, hopefully Ill get some solution to this, without deselecting them, I know that the "Require" tweak does not fix this, source server is MariaDB latest and unfortunately my cPanel default setup on MySQL 8 and I can't go from that to MariaDB

 

[Steini Petur]

Fantastic, I am running into the same issue right now, I just setup a Cloudlinux 8.5 with cPanel latest, and it defaulted to Mysql 8.0 which I can only assume would work but I am running into issues like

Error: The following 4 remote users are set to migrate with new names whose first 8 characters conflict with one or more other proposed new usernames. To resolve this, you can either rename the incoming accounts or deselect them.

Then I have them like so

"wanderin" will be renamed to "wanderin"

I checked and I have two accounts one is called

wanderingsomething with user wanderin
wanderingreselleraccount with user wanderingreseller

Literally same first 8 letters on an old Centos 6 with MariaDB installed, Im upgrading, and Im stuck at migrating 8 accounts all by some resellers because they have "johndoe" and "johndoedoe" as actual usernames longer than 8 letters..

It wont let me copy this over as is

Id love if i could get what was the solution to this case, attaching the image.. Im postponing the migration until tomorrow, hopefully Ill get some solution to this, without deselecting them, I know that the "Require" tweak does not fix this, source server is MariaDB latest and unfortunately my cPanel default setup on MySQL 8 and I can't go from that to MariaDB

Ended skipping the Transfer tool and do the Pkgacct or a Backup just locally, of all the things, then rsync them myself over and restorepkg no issues when doing it that way..