MySQL access host is not applied to existing db users

chamithlkml

• February 24, 2016 21:24

Hi, I tried adding an external host as MySQL access host for a cPanel user account via the cPanel API UAPI Mysql::add_host and then API2 MysqlFE::authorizehost. In both scenarios, ip and host are successfully added into the list of access hosts, but when I try to access the database from the external host, it's getting failed. Then I tried adding the external host and IP into MySQL Access Hosts and updated for all users via WHM admin panel. It did not fix the issue too. cPanel error log seems not giving any meaningful error message. Could you please help me to debug this issue.? Server is running OS - CloudLinux 6.7 and cPanel - 11.52.3.1.

• 

  cPanelMichael

  • February 25, 2016 16:35

  Hello :) Could you let us know the output to /usr/local/cpanel/logs/error_log when adding the host? Also, is the /var/cpanel/databases/grants_.yaml updated with the correct entries after adding the host? Thank you.

  0
• 

  chamithlkml

  • February 29, 2016 01:07

  Thanks for the response Michael. Suspicious part of cPanel error log is as follow: info [cpanellogd] New bandwidth database metadata: greentechgroup.homemagonline.ca_hourly_http_interpolation_end_iso8601 = "2013-10-29T04:00:00Z" warn [MysqlFE::changedbuserpassword] Encountered error in MysqlFE::changedbuserpassword: You do not control a MySQL user named "xxxxx_xxxxx". Yaml file is updated by the correct IP and the host. But inside .yaml file, I could find most underscores ("_") are escaped by adding "\_" fields in the yaml file. Not sure whether the issue is raised by the escaping of underscores. Regards. - Chamith

  0
• 

  cPanelMichael

  • March 14, 2016 21:44

  Hello :) Is there an entry for "skip-name-resolve" in your /etc/my.cnf file? Thank you.

  0

Please sign in to leave a comment.