dbmaptool: DB is already owned by USER

Hello...

WHM 60.0 (build 24)

I also seem to have this issue, however I am not trying to recreate a database, I am trying to have another user/account owner it which seems to the the reason for the tool.

"The Database Map Tool allows you to assign ownership of databases and database users to specific cPanel accounts."

I go into WHM and into the Database Map Tool.
I select the account to whom the database should be owned by.
In the Database Name box I enter in the name of the database I want the selected account to own.

"DATABASE is already owned by USERNAME" (Which is TRUE as that account is still active.)

I did the same thing for users I wanted to move, and it did not actually MOVE them, it duplicated them into the new account.

Per the tools description it should allow me to assign ownership.

Please help.


Side Note...The help doc on how to use it is incorrect. Look step #4 and #5, they are clearly wrong.

Database Map Tool - Documentation - cPanel Documentation

4. In the Database users text box, enter a comma-separated list of databases that you wish for the cPanel user to own.
5. In the Database names text box, enter a comma-separated list of database users that you wish for the cPanel user to own.

Should be...

4. In the Database users text box, enter a comma-separated list of database users users that you wish for the cPanel user to own.
5. In the Database names text box, enter a comma-separated list of databases that you wish for the cPanel user to own.

 

Same here...

Code:

root@geekshack2 [/var/cpanel]# /usr/local/cpanel/bin/dbmaptool capilisco --type mysql --dbs newstrad_civicrm
newstrad_civicrm is already owned by newstrad

Highly annoying as I need to delete the newstrad account and assign the database to another user

 

In my case, I CAN NOT remove the current user as it is still being used. I switched community software I used but wanted to keep the old site active so I could reference it if I needed to. So I made a new account for it and moved all the old site to it and just need to make the database be owned by the right account.

 

Hi...

Thank you kindly for the reply. Clearly, that is not what the tool states and thus, yes, should be updated to reflect the right information.

The solution is not ideal as you are talking about large databases that would take a very, very long time to export and import. After all, the databases are just fine and just WHM needs to updated to know what account should have control over them. This does not sound like it should be an issue like this at all seeing if I were to remove the account, I could map the database to someone else. So why would you not be able to do so regardless?

Is there no other way to map it to the right user? IE...Could you remove some files or something that is used to map them and then just remap them using the tool thus remaking the files?

Thank you Michael.

 

Thanks...however I think I think that would also take the new database that was made for the conversion with it as it would also be assigned to the account. (Unless it allows for you to select databases to move with it.) And if you can, then surely it is possible to change the account a database belongs to.

Thank you again Michael.

 

Augh...I tried to make the feature request and it allows me to start a new one, however when I go to submit, it asks me to login and it fails every time yet it allows me compose.

 

Looks like it took my new registration even though it reads when you go to the link you provided...

You've been automatically registered on the cPanel Feature Requests System!

As a registered user of the cPanel Community Forums, you have been automatically logged into the cPanel Feature Requests System by visiting this page. You should not need to register on the cPanel Feature Requests site to contribute and get involved, we've taken care of that for you here. Your cPanel Community Forum login details are now tied to the Feature Requests site. You can use the link on top of any page of the forums to access the Feature Requests site directly from now on. Thank you visiting this page! If you're looking for an introduction to the new Feature Requests site, you'll find that below.

...So something is not right somewhere as it clearly did not work and allowed me to register with the same address. I did get the email and registered.

I have now made the request which is in moderation.

 

Your welcome Michael. And Thank YOU for the support you all give.

I will post the link once it is approved. (Hope I get a not on it or I surely will forget. )

 

Hi Michael...

Well, this sounded like a good idea, however it requires me to take out another domain to do it. (Unless I can fake it somehow because it goes to look up the address to see if it is valid.) I tried using oldsite.currentdomain.com and it says I can not park it on top of itself. (That is what sub domains are for.)

So do you know of a way I can fake it to I can make the add on domain and then do what we need to do to convert it to an account?

I was trying to make a url like oldsite.domain.com using make new account (Thus really a sub domain but with a real account.) The reason, as I think I mentioned, was that then I did not need to back it up each night.

Hope all that made sense.

 

Feature Request Now Posted... Remap Database to another Account

 

Hi...

Ok, I made a fake domain as an add-on. I then turned it into an account while taking the database with it. I then went into WHM and changed the domain name from the fake one to be the one I wanted so it would work.

So...I did finely get it done. But it should would have been much easier if WHM could just change the owner.

Thank you Michael for your help.