Search the Community

Hi There, I am a voice engineer, not a php programmer or mysql specialist. I employ a tool written in php to assist in the mass provisioning of phones. This tool has now broken and I would appreciated help in debugging the situation. I have experience in Java, C++ and MySQL but I am finding it incredibly frustrating not to be able to step through the PHP code and track the variables, their values, and ultimately find where the problem is. Any help will greatly be appreciated. MySQL version: Server version: 5.1.67 Error from the SQL error log: Access denied for user 'root'@'localhost' (using password: YES) Code PHP where I set the MySQL username and password: <?php include_once(dirname(__FILE__)."/ez_sql_core.php"); include_once(dirname(__FILE__)."/ez_sql_mysql.php"); class mysqldbaccess { var $db; var $freepbxdb; function mysqldbaccess() { //database settings $username="root"; $password=""; $name="snom"; $host="localhost"; $this->db=new ezSQL_mysql($username,$password,$name,$host); } function freepbxdbaccess() { //echo "hi"; //database settings $username="root"; $password=""; $name="asterisk"; $host="localhost"; $this->freepbxdb=new ezSQL_mysql($username,$password,$name,$host); } Now in your forum Sticky you say you don't want php code, but the raw sql query - It seems this tool employs a library called EZ_SQL - and I trust that the library query is fine? How can I track whether the username and password I supply are passed to MySQL correctly? Can I see the username and password presented to MySQL? (The password is intentionally blank in the forum post) Now from my research my error is because: 1) I'm not supplying the correct password. As a above, I know I typed the values in correctly, whether they actually get to sql is another questions. I have used this tool many times before so I doubt this is the issue. 2) Permissions and Privileges on my database. The correct username and password does not guarantee access to all DB's? show grants for root; +--------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@% | +--------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*Half the hash removed on purpose CBEB70167D0D3D1F4' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `snom`.* TO 'root'@'%' WITH GRANT OPTION | +--------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> show grants for root@localhost; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*Half the hash removed on purpose C316CBEB70167D0D3D1F4' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `snom`.* TO 'root'@'localhost' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) The server is running Centos 6.3, I get the connection refused error when I try to log in remotely or on they local machine with lynx. I would really appreciate any advise on debugging this issue. Kind Regards, Rudolf