Re: [PHP-DB] MySQL - separating web and database servers

2004-03-19 Thread Matthew Vos
Hi Piotr, Everyone else is suggesting edit all of the code. Alternatively you could setup an iptables rule which forwards all incoming requests on 127.0.0.1:3306 (or whatever port your mysql server is running on) to 192.168.0.1:3306 (repolace 192.168.0.1 wit the IP of your DB server). This way

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-19 Thread Operator
On 19 Mar 2004 at 9:53, Matthew Vos wrote: Hi Piotr, Everyone else is suggesting edit all of the code. Alternatively you could setup an iptables rule which forwards all incoming requests on 127.0.0.1:3306 (or whatever port your mysql server is running on) to 192.168.0.1:3306 (repolace

[PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
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

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Ricardo Lopes
. :) - Original Message - From: Operator [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 18, 2004 8:57 AM Subject: [PHP-DB] MySQL - separating web and database servers Hi everyone, I need to put my database server on the another machine - how can I configure system(Debian Linux)/php

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
to the other machine is a good practice. :) I agree. But it doesn't work anyway ;) PB - Original Message - From: Operator [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 18, 2004 8:57 AM Subject: [PHP-DB] MySQL - separating web and database servers Hi everyone, I

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Peter Beckman
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

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Ricardo Lopes
but and least appears to logical and implementable. Good luck. - Original Message - From: Operator [EMAIL PROTECTED] To: PHP DB [EMAIL PROTECTED] Sent: Thursday, March 18, 2004 1:34 PM Subject: Re: [PHP-DB] MySQL - separating web and database servers On 18 Mar 2004 at 11:15, Ricardo Lopes

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
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

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Operator
On 18 Mar 2004 at 14:24, Ricardo Lopes wrote: in your php.ini you have mysql.default_host, mysql.default_user and mysql.default_password which are used if: a) you are not in safe mode b) you supply no string for those parameters. But i guess this is not your case, i think this doesnt

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Adam Voigt
I don't understand, your ready to hack the MySQL extension, rather then just use one of the free text editors, that let you mass replace all your pages at once (which takes roughly 10 seconds)? On Thu, 2004-03-18 at 10:15, Operator wrote: Probably I need to change this behaviour in

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread John W. Holmes
From: Operator [EMAIL PROTECTED] Probably I need to change this behaviour in ext/mysql/libmysql/libmysql.c for my installation, but this is my last hope (mostly because I'm not a C programist...) If some of you could tell me if it's possible without breaking something else, or point me to

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread Justin Patrin
Operator wrote: On 18 Mar 2004 at 14:24, Ricardo Lopes wrote: in your php.ini you have mysql.default_host, mysql.default_user and mysql.default_password which are used if: a) you are not in safe mode b) you supply no string for those parameters. But i guess this is not your case, i think this

Re: [PHP-DB] MySQL - separating web and database servers

2004-03-18 Thread W. D.
At 09:20 3/18/2004, Adam Voigt wrote: I don't understand, your ready to hack the MySQL extension, rather then just use one of the free text editors, that let you mass replace all your pages at once (which takes roughly 10 seconds)? Adam is right. Make backups of all the files, then do the edits.