Re: MySQL - separating web and database servers

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

 



On 18 Mar 2004 at 9:22, Peter Beckman wrote:

> 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.

Tested before, doesn't work :(

PB

> 
> 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
> 
> 

-- 
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