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

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • philippe Tressard

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

    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_s ocket /var/mysql/mysql1.sock

    php_admin_value mysql.default_h ost 127.0.0.1

    php_admin_value mysql.default_p ort 3306

    </IfModule>



    in httpd2.conf, I use :

    <IfModule mod_php4.c>

    php_admin_value mysql.default_s ocket /var/mysql/mysql2.sock

    php_admin_value mysql.default_h ost 127.0.0.1

    php_admin_value mysql.default_p ort 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_s ocket is set with the good value !



    Does anyone have a solution for the 2 last cases ?


Working...