User's databases are not showing in hosting manager

urello

• May 15, 2015 11:31

All user's databases are not showing in hosting manager. I see only message "There are no databases associated with your account." Checked in PhpMyAdmin - databases exist Checked ownership/perms - OK Tried to create new db in hosting manager - got error: Mysql::adddb($FORM{'db'}) failed: Can't use string ("27.124.113.129") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB/Map.pm line 169. Please advise.

• 

  urello

  • May 15, 2015 16:42

  Tried to use "Database map tool" in WHM, got the same error Can't use string ("27.124.113.129") as a HASH ref while "strict refs" in use at /usr/local/cpanel/Cpanel/DB/Map.pm line 169.

  0
• 

  cPanelMichael

  • May 15, 2015 16:46

  Hello, Review the YAML file for this account's databases at:
  /var/cpanel/databases/$username.YAML
  Do you see "server" entries under the database user fields? Thank you.

  0
• 

  urello

  • May 15, 2015 17:19

  I found YAML file looking like this
  --- MYSQL: dbs: {} dbusers: cpses_nuopPaoesl: dbs: {} server: 203.170.85.7 cpses_nurcRfQE5F: dbs: {} server: 203.170.85.7 cpses_nuut1ai6ga: dbs: {} server: 203.170.85.7 cpses_nuwXJmG3Vj: dbs: {} server: 203.170.85.7 noprefix: {} owner: nutechs1 server: 203.170.85.7
  I believe it is not good, so i altered this file using YAML from working account as example. Now it looks so
  --- MYSQL: dbs: nutechs1_clone: 203.170.85.7 nutechs1_wp1: 203.170.85.7 nutechs1_wp2: 203.170.85.7 dbusers: nutechs1_clone: dbs: nutechs1_clone: 203.170.85.7 server: 203.170.85.7 nutechs1_wp1: dbs: nutechs1_wp1: 203.170.85.7 server: 203.170.85.7 nutechs1_wp2: dbs: nutechs1_wp2: 203.170.85.7 server: 203.170.85.7 noprefix: {} owner: nutechs1 server: 203.170.85.7
  However this didn't solve the issue. Please advise

  0
• 

  cPanelMichael

  • May 15, 2015 17:31

  Please try removing all of the "server:" entries with the exception of the last line in the original YAML file. Then, use the database map tool to add in the databases. Thank you.

  0
• 

  urello

  • May 15, 2015 18:09

  Thank you very much!

  0

Please sign in to leave a comment.