Edit report at https://bugs.php.net/bug.php?id=70039&edit=1
ID: 70039
Updated by: cwei...@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:
Maybe the test script uses $_ENV, which does not get populated by the default
php.ini settings.
Previous Comments:
------------------------------------------------------------------------
[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
