Edit report at https://bugs.php.net/bug.php?id=70039&edit=1
ID: 70039
Updated by: mbecc...@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] cwei...@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] mbecc...@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
--
PHP Quality Assurance Mailing List <http://www.php.net/>
To unsubscribe, visit: http://www.php.net/unsub.php
