Bug #70039 [Opn]: MySQL PDO ignores env-vars

Edit report at https://bugs.php.net/bug.php?id=70039&edit=1 ID: 70039 Updated by: mbeccati@php.net Reported by: spam2 at rhsoft dot net Summary: MySQL PDO ignores env-vars Status: Open Type: Bug Package: Testing related PHP Version: 5.5.27 Block user comment: N Private report: N New Comment: Did you have a look at the test config.inc? if (false !== getenv('PDO_MYSQL_TEST_DSN')) { # user set them from their shell $config['ENV']['PDOTEST_DSN'] = getenv('PDO_MYSQL_TEST_DSN'); $config['ENV']['PDOTEST_USER'] = getenv('PDO_MYSQL_TEST_USER'); $config['ENV']['PDOTEST_PASS'] = getenv('PDO_MYSQL_TEST_PASS'); Previous Comments: ------------------------------------------------------------------------ [2015-07-10 11:33:12] spam2 at rhsoft dot net i doubt because in that case other tests would fail too, maybe *that* testscript does something different PASS mysqli bind_result 1 [ext/mysqli/tests/002.phpt] PASS mysqli connect [ext/mysqli/tests/003.phpt] PASS mysqli fetch char/text [ext/mysqli/tests/004.phpt] PASS mysqli fetch char/text long [ext/mysqli/tests/005.phpt] PASS mysqli fetch long values [ext/mysqli/tests/006.phpt] PASS mysqli fetch short values [ext/mysqli/tests/007.phpt] BTW: there are also some tests FAIL for years now on 5.3/5.4/5.5 FAILED TEST SUMMARY --------------------------------------------------------------------- Zend Multibyte and UTF-8 BOM [Zend/tests/multibyte/multibyte_encoding_002.phpt] Zend Multibyte and UTF-16 BOM [Zend/tests/multibyte/multibyte_encoding_003.phpt] #66265: gettext doesn't switch locales within the same script [ext/gettext/tests/bug66267.phpt] IntlCalendar::getDayOfWeekType() basic test [ext/intl/tests/calendar_getDayOfWeekType_basic.phpt] IntlDateFormatter::formatObject(): DateTime tests [ext/intl/tests/dateformat_formatObject_datetime_variant3.phpt] Bug #36745 (LOAD DATA LOCAL INFILE doesn't return correct error message) [ext/mysqli/tests/bug36745.phpt] Bug #42548 PROCEDURE xxx can't return a result set in the given context (works in 5.2.3!!) [ext/mysqli/tests/bug42548.phpt] Bug #44879 (failed to prepare statement) [ext/mysqli/tests/bug44897.phpt] Bug #51647 (Certificate file without private key (pk in another file) doesn't work) [ext/mysqli/tests/bug51647.phpt] Bug #53503 (mysqli::query returns false after successful LOAD DATA query) [ext/mysqli/tests/bug53503.phpt] Bug #55283 (SSL options set by mysqli_ssl_set ignored for MySQLi persistent connections) [ext/mysqli/tests/bug55283.phpt] Interface of the class mysqli_driver [ext/mysqli/tests/mysqli_class_mysqli_driver_interface.phpt] Interface of the class mysqli [ext/mysqli/tests/mysqli_class_mysqli_properties_no_conn.phpt] mysqli_connect() [ext/mysqli/tests/mysqli_connect.phpt] mysqli_fetch_field() - flags/field->flags [ext/mysqli/tests/mysqli_fetch_field_flags.phpt] mysqli_get_client_stats() [ext/mysqli/tests/mysqli_get_client_stats.phpt] mysqli_pconnect() [ext/mysqli/tests/mysqli_pconnect.phpt] mysqli_query() [ext/mysqli/tests/mysqli_query.phpt] mysqli_query() - Stored Procedures [ext/mysqli/tests/mysqli_query_stored_proc.phpt] mysqli_query() - unicode (cyrillic) [ext/mysqli/tests/mysqli_query_unicode.phpt] mysqli_real_query() [ext/mysqli/tests/mysqli_real_query.phpt] mysqli_report() [ext/mysqli/tests/mysqli_report.phpt] mysqli_stmt_execute() - Stored Procedures [ext/mysqli/tests/mysqli_stmt_execute_stored_proc.phpt] Multiple result set with PS [ext/mysqli/tests/mysqli_stmt_multires.phpt] use_trans_sid should not affect SID [ext/session/tests/015.phpt] rewriter correctly handles attribute names which contain dashes [ext/session/tests/018.phpt] rewriter uses arg_separator.output for modifying URLs [ext/session/tests/020.phpt] Bug #26862 (ob_flush() before output_reset_rewrite_vars() results in data loss) [ext/session/tests/bug26862.phpt] Bug #31454 (Incorrect adding PHPSESSID to links, which contains \r\n) [ext/session/tests/bug36459.phpt] Bug #41600 (url rewriter tags doesn't work with namespaced tags) [ext/session/tests/bug41600.phpt] Bug #50308 (session id not appended properly for empty anchor tags) [ext/session/tests/bug50308.phpt] Bug #44394 (Last two bytes missing from output) [ext/standard/tests/general_functions/bug44394.phpt] Bug #44394 (Last two bytes missing from output) with session.use_trans_id [ext/standard/tests/general_functions/bug44394_2.phpt] Bug #38802 (ignore_errors and max_redirects) [ext/standard/tests/http/bug38802.phpt] Bug #48929 (duplicate \r\n sent after last header line) [ext/standard/tests/http/bug48929.phpt] Bug #53198 (From: header cannot be changed with ini_set) [ext/standard/tests/http/bug53198.phpt] Bug #61548 (content-type must appear at the end of headers) [ext/standard/tests/http/bug61548.phpt] Bug #67430 (http:// wrapper doesn't follow 308 redirects) [ext/standard/tests/http/bug67430.phpt] http:// and ignore_errors [ext/standard/tests/http/ignore_errors.phpt] Bug #51800 proc_open on Windows hangs forever, the right way to do it [ext/standard/tests/streams/proc_open_bug51800_right.phpt] Bug #51800 proc_open on Windows hangs forever, the right way to do it with more data [ext/standard/tests/streams/proc_open_bug51800_right2.phpt] Bug #26817 (http_build_query() did not handle private & protected object properties) [ext/standard/tests/strings/bug26817.phpt] http_build_query() function [ext/standard/tests/strings/http_build_query.phpt] Test http_build_query() function: usage variations - first arguments as object [ext/standard/tests/strings/http_build_query_variation1.phpt] Test http_build_query() function: usage variations - first arguments as multidimensional array and second argument present/not present [ext/standard/tests/strings/http_build_query_variation2.phpt] Test http_build_query() function: usage variations - testing four parameter added in PHP 5.4.0 [ext/standard/tests/strings/http_build_query_variation3.phpt] Test setlocale() function : usage variations - Setting all available locales in the platform [ext/standard/tests/strings/setlocale_variation2.phpt] Test function show_source() by calling it with its expected arguments, more test for highlight_file() [ext/standard/tests/strings/show_source_basic.phpt] 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] 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] CLI -a and libedit [sapi/cli/tests/017.phpt] ------------------------------------------------------------------------ [2015-07-10 11:24:06] cweiske@php.net Maybe the test script uses $_ENV, which does not get populated by the default php.ini settings. ------------------------------------------------------------------------ [2015-07-10 11:22:00] spam2 at rhsoft dot net is there a *full* list of mysql/mysqli/pdo related env-vars? i posted my complete env-vars used in the rpm-spec before the tests honestly the vars below should be enough and taken by *anything* which connects to mysql unless a specific override is given MYSQL_TEST_HOST="localhost" MYSQL_TEST_PORT="3306" MYSQL_TEST_USER="php_autotest" MYSQL_TEST_PASSWD="*****" MYSQL_TEST_DB="php_autotest" ------------------------------------------------------------------------ [2015-07-10 11:19:16] mbeccati@php.net Did you try setting PDO_MYSQL_TEST_DSN ? ------------------------------------------------------------------------ [2015-07-10 10:58:58] spam2 at rhsoft dot net Description: ------------ why are with that environment vars a ton of tests still try to connect as root without a password? that's unacceptable for security reasons and frankly there should be in general a test-user with it's own database be the default instead root ____________________________________ export NO_INTERACTION=1 REPORT_EXIT_STATUS=1 MALLOC_CHECK_=2 MYSQL_TEST_HOST="localhost" MYSQL_TEST_PORT="3306" MYSQL_TEST_USER="php_autotest" MYSQL_TEST_PASSWD="*****" MYSQL_TEST_DB="php_autotest" PDO_MYSQL_TEST_HOST="localhost" PDO_MYSQL_TEST_SOCKET="%{_sharedstatedir}/mysql/mysql.sock" PDO_MYSQL_TEST_USER="php_autotest" PDO_MYSQL_TEST_PASS="****" PDO_MYSQL_TEST_DB="php_autotest" PDO_MYSQL_TEST_ENGINE="MyISAM" ____________________________________ SKIP MySQL PDO: PDOStatement->fetchObject() [ext/pdo_mysql/tests/pdo_mysql_stmt_fetchobject.phpt] reason: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) SKIP MySQL: PDOStatement->getColumnMeta() [ext/pdo_mysql/tests/pdo_mysql_stmt_getcolumnmeta.phpt] reason: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) SKIP PDOStatements and multi query [ext/pdo_mysql/tests/pdo_mysql_stmt_multiquery.phpt] reason: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) SKIP MySQL PDOStatement->nextRowSet() [ext/pdo_mysql/tests/pdo_mysql_stmt_nextrowset.phpt] reason: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) SKIP MySQL PDOStatement->rowCount() @ SELECT [ext/pdo_mysql/tests/pdo_mysql_stmt_rowcount.phpt] reason: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=70039&edit=1