Rakesh's web blog: Web Server 7 stuff

The PHP Add-on 1.0 has Mysql support built into it. To test whether mysql works with Sun Java System Web Server or not, write the following simple script (in testMysql.php) and test it out. I have used 5.0.41 (The Web Server PHP Add-on works with all 5.x versions of mysql) version of mysql with user name as 'root', password as 'adminadmin', and database as 'rakesh'.

Note: please refer to my last post on setting up PHP with Sun Java System Web Server. I assume that you have already created a fastcgi handler with URI  pattern as '/php/*' and role as 'responder'.


If there was no error in the connection to the database, you should observe just the following, when your request to the web server is something like this: http://localhost:1894/php/testMysql.php.

• Connected Successfully!!

  
  

Lets deliberately introduce some error into the script by providing a wrong password ($password = wrongpassword) in the script. Again send a request to the web server as http://localhost:1894/php/testMysql.php. You should get the following error messages.

• Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\rak\ws71\iplanet\ias\server\work\B1\WINNT4.0_DBG.OBJ\https-test\ docs\php\testMysql.php on line 6 Error connecting to mysql