should php be installed on apche web server or mysql database server

Question

Setup:

Two separate boxes:

1. Fedora 15, Apache, PHP and PHP modules
2. Fedora 15, MySQL

I am unable to make a connection to mysql from Apache web server.

<?php

  echo "<br>begin test<br>";

  mysql_connect('hostname[FQDN]','username','password') or ("Error" . mysql_error());

  echo "<br>end test<br>";

?>

the 'begin test' text is being displayed but no mysql error or the 'end test' text when Apache serves the page.

I am able to connect to the MySQL DB using the MySQL workbench on port 3306 from a remote machine. Privileges and access to the user and IP address have been left completely open (%) to avoid any issues in those respects.

Answer 1

Don't forget that, mysql_connect, mysql_error, etc are not part of PHP. They are an extension.

If you want to test if php has those functions you could do a little test like:

if(!function_exists('mysql_connect'))
    echo 'MySQL extension not installed';

You should have mysql and mysql-server installed on your MySQL Box

You should have php and php-mysql installed on your Apache box. If you haven't installed php-mysql install it: yum -y install php-mysql and then restart Apache.

Answer 2

Run

$ netstat -l

You should see the mysql server listening on port 3306. If it's 127.0.0.1, the server listens on the loopback interface only. Fix your my.cnf in that case.

Answer 3

The issue was resolved. The change I made was with SElinux and running setsebool -P httpd_can_network_connect=1 or running setenforce=0 which is permissive mode