[PHP-DB] accessing mysql on non default port - windows
Hi. I need to access mysql from windows to *nix on both the default port of 3306 and a secondary port of 3307. php.ini states that win32 will only pay attention to MYSQL_PORT. Is there a way to change the value of that constant without compiling my own version of php on win32. I don't mind having mutiple installs, but don't have access to the compilers for windoze to do it myself. Or are they out there for free somewhere? I work for a very small company and we're trying to set up multiple environments for devlopment/testing etc with a limited number of physical boxes. Part of our application needs to reside on windows and communicate with *nix. If this doesn't work, i guess i could use IPTables to NAT when requests come in on certian IPs? THanks for any assistance/advice you may have. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] accessing mysql on non default port - windows
On Sunday 06 February 2005 04:58, Jeff wrote: Hi. I need to access mysql from windows to *nix on both the default port of 3306 and a secondary port of 3307. php.ini states that win32 will only pay attention to MYSQL_PORT. Just specify the port you want to use in mysql_connect(). Is there a way to change the value of that constant without compiling my own version of php on win32. I think you're misunderstanding what those comments are saying. If you don't specify a port in mysql_connect() then PHP will try to use what is defined by mysql.default_port in php.ini. If mysql.default_port is not defined *then* it will start loking at other places (as detailed in the comments). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- New Year Resolution: Ignore top posted posts -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] accessing mysql on non default port - windows
Jason Wong wrote: On Sunday 06 February 2005 04:58, Jeff wrote: Hi. I need to access mysql from windows to *nix on both the default port of 3306 and a secondary port of 3307. php.ini states that win32 will only pay attention to MYSQL_PORT. Just specify the port you want to use in mysql_connect(). Is there a way to change the value of that constant without compiling my own version of php on win32. I think you're misunderstanding what those comments are saying. If you don't specify a port in mysql_connect() then PHP will try to use what is defined by mysql.default_port in php.ini. If mysql.default_port is not defined *then* it will start loking at other places (as detailed in the comments). Thats what i thought as well, but each time i attempt to use the port in mysql_connect, i.e. 'localhost:3307' or if i change the mysql.default_port = 3307 and just use 'localhost' in the server argument, i get Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client - this using php 4.3.10, unfortunately i don't have the option of running 5. Of course the *nix client works like a champ, but from all the searching, it seems that the constant MYSQL_PORT is a compile time argument. since the client is built into the install, i figured i'd have to rebuild. another thing that is easy to do in *nix Have you succesfully connected from a php/mysql client to a mysql server running on 330[not 6] Thanks for the reply. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] accessing mysql on non default port - windows
On Sunday 06 February 2005 07:59, Jeff wrote: Thats what i thought as well, but each time i attempt to use the port in mysql_connect, i.e. 'localhost:3307' or if i change the mysql.default_port = 3307 and just use 'localhost' in the server argument, i get OK, but my understanding was that your mysql server is on *nix, and your problem was accessing it from a windows client. So you should not be using localhost? Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client - this using php 4.3.10, unfortunately i don't have the option of running 5. This error has nothing (AFAICS) to do with the use port being used. The fact that you're getting this error indicates that the port being used is in fact correct and you have successfully managed to connect to the server. Google the error message. Of course the *nix client works like a champ, but from all the searching, it seems that the constant MYSQL_PORT is a compile time argument. Yes, but like I said, if you specify a port then whatever MYSQL_PORT is irrelevant because it doesn't come into play. Have you succesfully connected from a php/mysql client to a mysql server running on 330[not 6] All the time! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- New Year Resolution: Ignore top posted posts -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] accessing mysql on non default port - windows
Jason Wong wrote: On Sunday 06 February 2005 07:59, Jeff wrote: OK, but my understanding was that your mysql server is on *nix, and your problem was accessing it from a windows client. So you should not be using localhost? I just did that for a test to remove the remote connection from the equation. And i get the same result. Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client - this using php 4.3.10, unfortunately i don't have the option of running 5. This error has nothing (AFAICS) to do with the use port being used. The fact that you're getting this error indicates that the port being used is in fact correct and you have successfully managed to connect to the server. Google the error message. this *only* happens from windows clients when the port is used. as soon as i remove the port and connect to any mysql on 3306, it works fine. Of course the *nix client works like a champ, but from all the searching, it seems that the constant MYSQL_PORT is a compile time argument. Yes, but like I said, if you specify a port then whatever MYSQL_PORT is irrelevant because it doesn't come into play. Have you succesfully connected from a php/mysql client to a mysql server running on 330[not 6] All the time! from a php/mysql - windows client?? i've tried this from three machines runnign different versions of php4 and none of them have the ability to connect. my code is quite simply $cnx = mysql_connect(192.168.2.XX,'user','password'); $db = mysql_select_db(mysql,$cnx); var_dump($cnx,$db); and the error comes from the $cnx = line. the relevant portion from php.ini mysql.default_port 3307 3307 if you see something wrong wtih that, please let me know. I've noticed that i get the same issue from command line mysql client 4.0.18 C:\mysql\binmysql -h 192.168.2.XX --port 3307 -u jdyke -p Enter password: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client but if i use mysql 4.1 it works fine. C:\Program Files\MySQL\MySQL Server 4.1\binmysql -h 192.168.2.XX --port 3307 -u jdyke -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 54 to server version: 4.1.9-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. how do i get php to use a higher version then pre-configured one, which according to phpinfo() Client API version 3.23.49 thats no good. man if its something simple, i'm not seeing it. Thanks Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] accessing mysql on non default port - windows
thats no good. man if its something simple, i'm not seeing it. well it was something simple...and now i see it. old_passwords. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] accessing mysql on non default port - windows
Jeff wrote: thats no good. man if its something simple, i'm not seeing it. well it was something simple...and now i see it. old_passwords. Don't you just love informative error messages ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
