How to repopulate database username.yaml

Mic1

• February 26, 2015 15:01

Since the upgrade to cPanel 11.44 and the changes in association with username/database name, setupdbmap has become deprecated. I have seen cases where the yaml file is a barebones file. The cPanel API is already being used for creating the databases and users. I need the ability to be able to auto-recreate the yaml file for a single user and/or to check and recreate for all users on the server. What is the new cPanel solution for fixing an empty database username.yaml file?

• 

  cPanelMichael

  • February 27, 2015 12:48

  Hello :) You can use "/usr/local/cpanel/bin/dbmaptool" to update ownership of databases to specific accounts:
  -bash-4.1# /usr/local/cpanel/bin/dbmaptool /usr/local/cpanel/bin/dbmaptool cpuser --type mysql|pg --dbusers 'user1, user2' --dbs 'db1, db2' These flags are treated individually. This tool will not map a virtual user to a database. /usr/local/cpanel/bin/dbmaptool user1 --type mysql --dbs 'db1' --dbusers 'virt1' /usr/local/cpanel/bin/dbmaptool user1 --type mysql --dbs 'db1' && /usr/local/cpanel/bin/dbmaptool user1 --type mysql --dbusers 'virt1' The above two commands are analogous; result in cpuser 'user1' having privileges for 'db1' and having a virtual user named 'virt1.'
  The YAML file should create automatically when you create a database or database user. Thank you.

  0
• 

  Mic1

  • February 27, 2015 15:37

  Thank you for your reply. I'm feeling a bit short-handed with this solution. No databases/users will show up in cPanel. In order to properly fix this situation, I have to dig through mysql grants to find what user is assigned to what database, set them back up with the dbmaptool, and then use the cPanel api to re-add the user to the database. This is a very slow process when there are tens or hundreds of users to put back together again. Is there no other, more complete solution?

  0
• 

  cPanelMichael

  • February 27, 2015 16:55

  ] This is a very slow process when there are tens or hundreds of users to put back together again. Is there no other, more complete solution?

  
  Could you elaborate on how the databases/database users were removed from the account? It might be better to address the source of the problem as opposed to trying to manually resolve the issue for each account. Thank you.

  0
• 

  Mic1

  • March 02, 2015 12:28

  At this point the source of the problem is unknown. There are no related errors. All the users/databases were added to cPanel using the API and, shortly after the upgrade to 11.44, they've just gone missing, with no rhyme or reason.

  0
• 

  cPanelMichael

  • March 02, 2015 18:27

  ]At this point the source of the problem is unknown. There are no related errors. All the users/databases were added to cPanel using the API and, shortly after the upgrade to 11.44, they've just gone missing, with no rhyme or reason.

  
  Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  Mic1

  • March 19, 2015 14:24

  An in-house tool is being created to fix these. This tool is also important since, in addition to the above, I need to be able to migrate accounts, which involves some things that won't work with an API in every instance. Thank you for your time and help, Michael. It's much appreciated.

  0

Please sign in to leave a comment.