By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,278 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,278 IT Pros & Developers. It's quick & easy.

2 MySQL : How does PHP can use the good socket ?

P: n/a
Hi,

I've 2 instances of apache 1.3.27 with php 4.2.3 and mysql 3.23.42 running
on the same server.

The 1st apache listens the port number 80 and communicates with the 1st
mysql with the socket /var/mysql/mysql1.sock (i've also defined the port
3306)

The 2nd apache listens the port number 8080 and communicates with the 2nd
mysql with the socket /var/mysql/mysql2.sock (i've also defined the port
3366)

I've only one "bin" of apache (then of couse one php.ini). So, I start the 2
instances of apache with 2 apachectl (apachectl1 and apachectl2) linked to 2
httpd.conf (httpd1.conf and httpd2.conf)

in httpd1.conf, I use :

<IfModule mod_php4.c>

php_admin_value mysql.default_socket /var/mysql/mysql1.sock

php_admin_value mysql.default_host 127.0.0.1

php_admin_value mysql.default_port 3306

</IfModule>

in httpd2.conf, I use :

<IfModule mod_php4.c>

php_admin_value mysql.default_socket /var/mysql/mysql2.sock

php_admin_value mysql.default_host 127.0.0.1

php_admin_value mysql.default_port 3366

</IfModule>

when I'm connecting, on each apache, a mysql_connect with "IP and user and
password (without mysql's port)" : The connexion is succeded and the good
mysql is well reached !

when I'm connecting, on each apache, a mysql_connect with "127.0.0.1 and
user and password (without mysql's port)" : The connexion is succeded, the
good mysql is well reached !

BUT :

when I'm connecting, on each apache, a mysql_connect with "localhost and
user and password (without mysql's port)" : The connexion is failed !

when I'm connecting, on each apache, a mysql_connect with "user and password
(without mysql's host and port)" : The connexion is failed !

I think in the 2 last cases, it's a problen of socket. When I run the "php
info" : mysql.default_socket is set with the good value !

Does anyone have a solution for the 2 last cases ?
Jul 16 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.