Change, in the /etc/hosts file, this:
localhost 209.10.33.12 # new db server
Hopefully this will work. Haven't tested, just a suggestion. Probably
breaks a few other things, but at least mysql will work.
Beckman
On Thu, 18 Mar 2004, Operator wrote:
> 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
>
---------------------------------------------------------------------------
Peter Beckman Internet Guy
beckman@xxxxxxxxxxxxx http://www.purplecow.com/
---------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
