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

Edit report at https://bugs.php.net/bug.php?id=70039&edit=1 ID: 70039 User updated by: spam2 at rhsoft dot 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: 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" Previous Comments: ------------------------------------------------------------------------ [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