Re: Re[2]: mysql server move
Hi use rinetd to redirect the connect's to the mysl-port.
if the users using DNS-names, put them into /etc/hosts
and be sure that the /etc/nsswitch.conf usese first file and then bind or nis.
you can check this with mysql-client to the hostname/ip
and you must get the connect.
to look whats going on you can use logging from rinetd to
see what them make if you connect.
rinetd handle the complete connect after the point that rinetd makes
the connection to the remote server.
regards
michael
2005/7/19, Marek Podmaka <marki@onee.sk>:
> Hello wim,
>
> I tried that, but it would work only for those users who leave the
> host parameter in mysql_connect() empty - and not for those who fill
> in "localhost".
>
> I have tried that unix2tcp and it seems it is exactly what I need.
> For the first look it seems better than other suggested socat,
> because it doesn't fork for each new connection.
>
> Tuesday, July 19, 2005, 11:56:18, wim wrote:
>
> w> Marek Podmaka wrote:
> >> Hello,
> >>
> >> I want to move mysql4 server to new machine, but I have problems
> >> with php. I thought that using port redirector (rinetd) would be
> >> sufficient until all customers change their php scripts, but it
> >> doesn't work.
> >>
> >> Most people use "localhost" in call to mysql_connect() and php tries
> >> to connect using socket - which isn't present if mysqld is running
> >> on another box. I tried playing with mysql.default_host and
> >> default_port in php.ini, but with no effect.
> >>
> >> In php manual I have found that php will always try to connect using
> >> socket if it finds "localhost". But is there any option how to move
> >> database to another box flawlessly?
> >>
> >>
> w> Change your default mysql-server in php.ini?
>
> w> wim.
>
>
> --
> bYE, Marki
>
>
> --
> To UNSUBSCRIBE, email to debian-isp-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
>
Reply to: