Access denied for user 'ssh-user'@'localhost' (using password: NO)

kmthayil

• March 02, 2015 12:13

Hello All, I need your feedbacks on the below message which I am seeing these days in my apache error_logs (/usr/local/apache/logs/error_log). I have script in place which when executed in the browser, gives me the message, PHP Warning: mysql_query() [function.mysql-query]: Access denied for user 'ssh-user'@'localhost' (using password: NO) in /home/example/public_html/test1121x11.php on line 14 I have no issues with this error and it is something which I am expecting because the mysql_connect query is getting called without any user/host/password details. So ideally it should either user apache user which is nobody or should be blank. But here, it is taken as ssh-user having wheel group (i use this user for doing su - as root with wheel group) Any idea why this is happening. When putting this same script in another server and calling via browser, I get the expected output which is, Access denied for user 'nobody'@'localhost' (using password: NO). I can confirm that when checking the phpinfo() of the server, mysql.default_user is set to "no value" and also, apache is run as user nobody when I am checking ps aux Can someone suggest what is the issue here? Thank you. Regards, K.

• 

  cPanelMichael

  • March 03, 2015 12:42

  Hello :) What PHP handler have you configured in "WHM Home " Service Configuration " Configure PHP and suEXEC"? Are you using Mod_Ruid2? Does this configuration match the other server you referenced? Thank you.

  0
• 

  kmthayil

  • March 03, 2015 17:19

  Hello Michael, Thank you for the response. I can confirm that in both the server I have the following setting. Default PHP Version (.php files) 5 PHP 5 Handler dso Apache suEXEC on Apache Ruid2 off One server gives me output Access denied to 'nobody'@'localhost' and in another it gives me the output Access denied to 'ssh-server'@'localhost' NOTE: ssh-user is not the user of the account (domain), but a normal user which I created using `useradd` for doing su - (as direct root access is disabled) Any clue why this is ? Regards, K.

  0
• 

  cPanelMichael

  • March 03, 2015 18:05

  Are there any other differences between the servers (e.g. CloudLinux, Apache/PHP versions)? Thank you.

  0
• 

  kmthayil

  • March 03, 2015 18:47

  Hello Michael, Both are installed with Apache 2.2.x and PHP 5.3.x. However OS for the working one (which thows as nobody) is CentOS 5.11 and the other (which throws as ssh-user) is CentOS 6.6 Just a quick note. When I access the same script using browser from a CentOS 6.6 / PHP 5.5.x / Apache 2.2.x server, it gave message "Access denied to ''@'localhost'. Which also seemed fine. Regards, K.

  0
• 

  cPanelMichael

  • March 03, 2015 19:04

  Feel free to 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

Please sign in to leave a comment.