ID: 28071 Updated by: [EMAIL PROTECTED] Reported By: phpb at lwnetwork dot com -Status: Open +Status: Feedback Bug Type: MySQL related Operating System: Linux RedHat PHP Version: 4.3.4 New Comment:
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Please provide information about php configuration (incl. mysql client library) and MySQL Server configuration. What does SHOW VARIABLES LIKE 'have_compress' show? Previous Comments: ------------------------------------------------------------------------ [2004-04-20 05:13:57] phpb at lwnetwork dot com Description: ------------ Tested with: PHP 4.3.4 / MySQL 4.0.18 I have been testing MYSQL_CLIENT_COMPRESS flag in mysql_connect funcion and compressed protocol is not used, data is transfered from client/server in no compressed way. mytest.php : ---------------------- $mycmsconn=mysql_connect("$dbip","$dblogin","$dbpass",false,MYSQL_CLIENT _COMPRESS); $mycmsdataquery="SELECT * FROM foo"; $mycmsdataresult = mysql_query($mycmsdataquery,$mycmsconn); $mycmsdatarow = mysql_fetch_array($mycmsdataresult); ----------------------- I test versus my firewall : 29 2486 3685K ACCEPT tcp -- any any anywhere anywhere state ESTABLISHED tcp spt:mysql 29 1249 65053 ACCEPT tcp -- any any anywhere anywhere state NEW,ESTABLISHED tcp dpt:mysql then i restart my firewall and do : mytest.php : ------------------------ $mycmsconn=mysql_connect("$dbip","$dblogin","$dbpass",false,MYSQL_CLIENT_COMPRESS); $mycmsdataquery="SELECT * FROM foo"; $mycmsdataresult = mysql_query($mycmsdataquery,$mycmsconn); $mycmsdatarow = mysql_fetch_array($mycmsdataresult); ------------------------ /etc/init.d/firewall.sh status | grep mysql 29 2486 3684K ACCEPT tcp -- any any anywhere anywhere state ESTABLISHED tcp spt:mysql 29 1249 65053 ACCEPT tcp -- any any anywhere anywhere state NEW,ESTABLISHED tcp dpt:mysql (needless to say that the database server is on a remote host....) (Info copied from Sebastian, as he got same problem as me and tested with a firewall) Regards, Alex ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28071&edit=1