YES how often shoud i reapeat this? * < 5.3.6 since a year on several machines cronjobs connecting per WAN to mysql * update to 5.3.7 * it takes 30 minutes to get the first error-mails from cronjobs * it takes so long because they all run in a timeout * after an hour you have 50 instances of every-5-minutes scripts * the one machine which stays on 5.3.6 has no problems * all are using exactly the same "php.ini" and ssl-certs * all mysql-servers are using the same ssl-certs as php on all machines
and that is the reason why i want revert this damned change Am 22.08.2011 10:31, schrieb Pierre Joye: > but does it work with 5.3.6? On the servers where 5.3.7 fails? > > On Mon, Aug 22, 2011 at 10:26 AM, Reindl Harald <h.rei...@thelounge.net> > wrote: >> i can not easily replace files because rpmbuild does >> unpack and patch the source automated and some patches >> are needed since ages to get PHP even compiled on fedora >> >> Am 22.08.2011 10:05, schrieb Andrey Hristov: >>> Hi guys, >>> what I observe is hanging on the client side with SSL. Pconn doesn't >>> matter. Tracing the server showed that somehow >>> the server doesn't flush, although it should. In gdb I called manually a >>> function to flush and there was no hang. I >>> need to investigate it more. >>> Harald, if you get the mysqli files from 5.3.6 and put them in 5.3.7, then >>> compile, does it work? >>> >>> Best, >>> Andrey >>> >>> On 08/21/2011 08:30 PM, Pierre Joye wrote: >>>> hi, >>>> >>>> I shortly discussed this issue with Ulf. As far I can tell it is not >>>> certain that this bug is in php itself but on the server side. It >>>> means that the fix applied in 5.3.7 actually works with server >>>> versions but not other. >>>> >>>> However we can't take a decision without their agreement (no revert if >>>> they don't do it themselves or if they don't ask us to do it). >>>> >>>> Cheers, >>>> >>>> On Sun, Aug 21, 2011 at 3:26 PM, Reindl Harald<h.rei...@thelounge.net> >>>> wrote: >>>>> hi >>>>> >>>>> it was surely not present in mysqlnd before because we are running a >>>>> bundle >>>>> of servers which using the same ssl-certs for php and mysql over WAN and >>>>> all >>>>> of them started running in timeot/mysql server gone away directly >>>>> after update to PHP 5.3.7 (we are speaking about cronjobs every 5 minutes) >>>>> >>>>> only one machine which stays this time on 5.3.6 does not have the problem >>>>> and this one was not updated becuase there is no webserver running, on >>>>> the other machines it is problematic - 5.3.7 breaks SSL but 5.3.6 >>>>> has full disclosed security bugs - so every decision is wrong >>>>> >>>>> i solved this temporary with SSH-Tunnels but that is not beautiful >>>>> and implicated other security bypasses because it exports from the >>>>> view of mysql 127.0.0.1 to external hosts >>>>> >>>>> >>>>> Am 21.08.2011 15:21, schrieb Pierre Joye: >>>>> >>>>> hi, >>>>> >>>>> The question is more about whether this bug was present �before as >>>>> well. If yes, I'd to wait to make sure we get 5.3.8 out on Tuesday >>>>> without any other change but the crypt's fix. >>>>> >>>>> Cheers, >>>>> >>>>> On Sun, Aug 21, 2011 at 3:08 PM, Reindl Harald<h.rei...@thelounge.net> >>>>> wrote: >>>>> >>>>>> This is my try to help badly prevent broken releases like >>>>>> 5.3.7 in the future, 54 failing tests are way too much and >>>>>> the XFAILED should be removed until they are working >>>>>> >>>>>> the crypt()-bug which is the reason for 5.3.8 this week is fixed >>>>>> in this build with the patch included on fedora-buildserver >>>>>> >>>>>> Tests failed: 54 ( �0.5%) ( �0.7%) >>>>>> Expected fail: 33 ( �0.3%) ( �0.4%) >>>>>> ________________________ >>>>>> >>>>>> this is the badest one, because the fix broke mysqlnd waht worked before >>>>>> this change should be reverted too in 5.3.8 this week >>>>>> FAIL Bug #55283 (SSL options set by mysqli_ssl_set ignored for MySQLi >>>>>> persistent connections) >>>>>> [ext/mysqli/tests/bug55283.phpt] >>>>>> ________________________ >>>>>> >>>>>> the whole PDO-tests are broken because they ignore the ENV-VARS >>>>>> "MYSQL_TEST_HOST""MYSQL_TEST_PORT" "MYSQL_TEST_USER""MYSQL_TEST_PASSWD" >>>>>> "MYSQL_TEST_DB" >>>>>> >>>>>> SKIP MySQL PDOStatement->columnCount() >>>>>> [ext/pdo_mysql/tests/pdo_mysql_stmt_columncount.phpt] reason: >>>>>> SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using >>>>>> password: NO) >>>>>> SKIP MySQL PDOStatement->errorCode(); >>>>>> [ext/pdo_mysql/tests/pdo_mysql_stmt_errorcode.phpt] reason: >>>>>> SQLSTATE[28000] >>>>>> [1045] Access denied for user 'root'@'localhost' (using password: NO) >>>>>> SKIP MySQL PDOStatement->errorInfo(); >>>>>> [ext/pdo_mysql/tests/pdo_mysql_stmt_errorinfo.phpt] reason: >>>>>> SQLSTATE[28000] >>>>>> [1045] Access denied for user 'root'@'localhost' (using password: NO) >>>>>> ________________________ >>>>>> >>>>>> -O3 -march=core2 -mtune=core2 -mmmx -msse2 -msse3 -msse4.1 -fopenmp >>>>>> -mfpmath=sse -pipe >>>>>> -fno-delete-null-pointer-checks -fstack-protector >>>>>> --param=ssp-buffer-size=4 -mfpmath=sse -D_FORTIFY_SOURCE=2 >>>>>> -fexceptions -prefer-pic >>>>>> >>>>>> exactly the same with -O6 as with -O3 >>>>>> >>>>>> FAIL Bug #55156 (ReflectionClass::getDocComment() returns comment even >>>>>> though the class has none) >>>>>> [Zend/tests/bug55156.phpt] >>>>>> FAIL unixtojd() [ext/calendar/tests/unixtojd.phpt] >>>>>> FAIL DateTime::diff() days -- spring type2 type2 >>>>>> [ext/date/tests/DateTime_days-spring-type2-type2.phpt] >>>>>> FAIL DateTime::diff() days -- spring type2 type3 >>>>>> [ext/date/tests/DateTime_days-spring-type2-type3.phpt] >>>>>> FAIL DateTime::diff() days -- spring type3 type2 >>>>>> [ext/date/tests/DateTime_days-spring-type3-type2.phpt] >>>>>> FAIL DateTime::diff() days -- spring type3 type3 >>>>>> [ext/date/tests/DateTime_days-spring-type3-type3.phpt] >>>>>> FAIL DateTime::sub() -- dates [ext/date/tests/DateTime_sub-dates.phpt] >>>>>> FAIL DateTime::sub() -- february >>>>>> [ext/date/tests/DateTime_sub-february.phpt] >>>>>> FAIL timezone_location_get: Test that timezone_location_get returns a >>>>>> correct array of information >>>>>> [ext/date/tests/timezone_location_get.phpt] >>>>>> FAIL gmp_gcdext() basic tests [ext/gmp/tests/022.phpt] >>>>>> FAIL Bug #48754 (mysql_close() crash php when no handle specified) >>>>>> [ext/mysql/tests/bug48754.phpt] >>>>>> FAIL Bug #53649 (mysql_query with "load data" unable to save result set) >>>>>> [ext/mysql/tests/bug53649.phpt] >>>>>> FAIL Bug #36745 (LOAD DATA LOCAL INFILE doesn't return correct error >>>>>> message) [ext/mysqli/tests/bug36745.phpt] >>>>>> FAIL Bug #51647 (Certificate file without private key (pk in another >>>>>> file) doesn't work) >>>>>> [ext/mysqli/tests/bug51647.phpt] >>>>>> FAIL Bug #53503 (mysqli::query returns false after successful LOAD DATA >>>>>> query) [ext/mysqli/tests/bug53503.phpt] >>>>>> FAIL Bug #55283 (SSL options set by mysqli_ssl_set ignored for MySQLi >>>>>> persistent connections) >>>>>> [ext/mysqli/tests/bug55283.phpt] >>>>>> FAIL mysqli_change_user() [ext/mysqli/tests/mysqli_change_user.phpt] >>>>>> FAIL Interface of the class mysqli_driver >>>>>> [ext/mysqli/tests/mysqli_class_mysqli_driver_interface.phpt] >>>>>> FAIL mysqli_connect() [ext/mysqli/tests/mysqli_connect.phpt] >>>>>> FAIL mysqli_free_result() [ext/mysqli/tests/mysqli_free_result.phpt] >>>>>> FAIL mysqli_get_client_stats() >>>>>> [ext/mysqli/tests/mysqli_get_client_stats.phpt] >>>>>> FAIL mysqli_pconnect() [ext/mysqli/tests/mysqli_pconnect.phpt] >>>>>> FAIL int mysqli_poll() and kill [ext/mysqli/tests/mysqli_poll_kill.phpt] >>>>>> FAIL mysqli_report() [ext/mysqli/tests/mysqli_report.phpt] >>>>>> FAIL mysqli_report() [ext/mysqli/tests/mysqli_report_wo_ps.phpt] >>>>>> FAIL mysqli_select_db() [ext/mysqli/tests/mysqli_select_db.phpt] >>>>>> FAIL mysqli_stmt_execute() - SP, next result >>>>>> [ext/mysqli/tests/mysqli_stmt_execute_stored_proc_next_result.phpt] >>>>>> FAIL mysqli_stmt_execute() - OUT >>>>>> [ext/mysqli/tests/mysqli_stmt_execute_stored_proc_out.phpt] >>>>>> FAIL Bug #28382 (openssl_x509_parse extensions support) >>>>>> [ext/openssl/tests/bug28382.phpt] >>>>>> FAIL Bug #47828 (segfaults when a UTF-8 conversion fails >>>>>> openssl_x509_parse()) [ext/openssl/tests/bug47828.phpt] >>>>>> FAIL openssl_x509_parse() basic test >>>>>> [ext/openssl/tests/openssl_x509_parse_basic.phpt] >>>>>> FAIL preg_replace() with array of failing regular expressions >>>>>> [ext/pcre/tests/006.phpt] >>>>>> FAIL MySQL PDO->__construct(), options >>>>>> [ext/pdo_mysql/tests/pdo_mysql___construct_options.phpt] >>>>>> >>>>>> FAIL MySQL PDO class interface >>>>>> [ext/pdo_mysql/tests/pdo_mysql_interface.phpt] >>>>>> >>>>>> FAIL a script should not be able to modify session.use_trans_sid >>>>>> [ext/session/tests/014.phpt] >>>>>> >>>>>> FAIL use_trans_sid should not affect SID [ext/session/tests/015.phpt] >>>>>> >>>>>> FAIL rewriter correctly handles attribute names which contain dashes >>>>>> [ext/session/tests/018.phpt] >>>>>> >>>>>> FAIL rewriter uses arg_seperator.output for modifying URLs >>>>>> [ext/session/tests/020.phpt] >>>>>> >>>>>> FAIL rewriter handles form and fieldset tags correctly >>>>>> [ext/session/tests/021.phpt] >>>>>> >>>>>> FAIL Bug #26862 (ob_flush() before output_reset_rewrite_vars() results >>>>>> in data loss) >>>>>> [ext/session/tests/bug26862.phpt] >>>>>> >>>>>> FAIL Bug #31454 (Incorrect adding PHPSESSID to links, which contains >>>>>> \r\n) [ext/session/tests/bug36459.phpt] >>>>>> >>>>>> FAIL Bug #41600 (url rewriter tags doesn't work with namespaced tags) >>>>>> [ext/session/tests/bug41600.phpt] >>>>>> >>>>>> FAIL Test session_id() function : variation >>>>>> [ext/session/tests/session_id_variation2.phpt] >>>>>> >>>>>> FAIL Bug #48601 (xpath() returns FALSE for legitimate query) >>>>>> [ext/simplexml/tests/bug48601.phpt] >>>>>> >>>>>> FAIL Bug #51615 (PHP crash with wrong HTML in SimpleXML) >>>>>> [ext/simplexml/tests/bug51615.phpt] >>>>>> >>>>>> FAIL Bug #54971 (Wrong result when using iterator_to_array with use_keys >>>>>> on true) [ext/spl/tests/bug54971.phpt] >>>>>> FAIL Bug #44394 (Last two bytes missing from output) >>>>>> [ext/standard/tests/general_functions/bug44394.phpt] >>>>>> FAIL Bug #44394 (Last two bytes missing from output) with >>>>>> session.use_trans_id >>>>>> [ext/standard/tests/general_functions/bug44394_2.phpt] >>>>>> FAIL Bug #49936 (crash with ftp stream in >>>>>> php_stream_context_get_option()) >>>>>> [ext/standard/tests/streams/bug49936.phpt] >>>>>> FAIL Bug #26817 (http_build_query() did not handle private& protected >>>>>> object properties) >>>>>> [ext/standard/tests/strings/bug26817.phpt] >>>>>> FAIL http_build_query() function >>>>>> [ext/standard/tests/strings/http_build_query.phpt] >>>>>> FAIL Test function show_source() by calling it with its expected >>>>>> arguments, more test for highlight_file() >>>>>> [ext/standard/tests/strings/show_source_basic.phpt] >>>>>> FAIL Test function show_source() by calling it with its expected >>>>>> arguments and php output, more test for >>>>>> highlight_file() [ext/standard/tests/strings/show_source_variation1.phpt] >>>>>> FAIL Test function show_source() by calling it with its expected >>>>>> arguments and output to variable, more test for >>>>>> highlight_file() [ext/standard/tests/strings/show_source_variation2.phpt] >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> Mit besten Gr��en, Reindl Harald >>>>> the lounge interactive design GmbH >>>>> A-1060 Vienna, Hofm�hlgasse 17 >>>>> CTO / software-development / cms-solutions >>>>> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 >>>>> icq: 154546673, http://www.thelounge.net/ >>>>> >>>>> http://www.thelounge.net/signature.asc.what.htm >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >> >> -- >> >> Mit besten Grüßen, Reindl Harald >> the lounge interactive design GmbH >> A-1060 Vienna, Hofmühlgasse 17 >> CTO / software-development / cms-solutions >> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 >> icq: 154546673, http://www.thelounge.net/ >> >> http://www.thelounge.net/signature.asc.what.htm >> >> > > > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature