MySQL - separating web and database servers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi everyone,

I need to put my database server on the another machine - how can I
configure system(Debian Linux)/php/mysql etc. to make it work without 
changing all 'localhost' in a hundreds of customer's scripts?

The problem is, when localhost is specified as a host the connection is made
using unix socket, not TCP (is it possible to change this?). I tried to
export the socket from database server via NFS, but with no success:

(...)
munmap(0x2e1f2000, 4096) = 0
rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0
socket(PF_UNIX, SOCK_STREAM, 0) = 3
fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR)
connect(3, {sin_family=AF_UNIX, path="/var/run/mysqld/mysqld.sock"}, 
110)
= -1 ECONNREFUSED (Connection refused)
shutdown(3, 2 /* send and receive */) = 0
close(3) = 0
(...)

Any ideas?

Regards
Piotr Babula

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux