See below. Yes, there are messages in the prod.log file (the directory is "logs"). The last message in particular has this text:
[2018-11-04 23:09:44] php.CRITICAL: Fatal Error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) in /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43 Stack trace: #0 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'domjudge', 'FAOhzxtfbrEVa5I...', Array) #1 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(44): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=loca...', 'domjudge', 'FAOhzxtfbrEVa5I...', Array)
If the "FAOhzxt..." is supposed to be the database password, that is not what is in dbpasswords.secret.
Ideas welcome.
Marc
Jaap Eldering wrote:
I'm currently not the most knowledgable person on the web interface, but are there any errors in the apache logs or in the Symfony logs (under /opt/domjudge/domserver/webapp/var/log/prod.log)
[2018-11-04 23:09:44] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES)" at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103 {"exception":"[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} [] [2018-11-04 23:09:44] request.CRITICAL: Exception thrown when handling an exception (Doctrine\DBAL\Exception\ConnectionException: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103) {"exception":"[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} [] [2018-11-04 23:09:44] php.CRITICAL: Uncaught Exception: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) {"exception":"[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43, Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} [] [2018-11-04 23:09:44] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES)" at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103 {"exception":"[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43, Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} [] [2018-11-04 23:09:44] request.CRITICAL: Exception thrown when handling an exception (Doctrine\DBAL\Exception\ConnectionException: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103) {"exception":"[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} [] [2018-11-04 23:09:44] php.CRITICAL: Uncaught Exception: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) {"exception":"[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43, Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43, Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} [] [2018-11-04 23:09:44] php.CRITICAL: Fatal Error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) in /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43 Stack trace: #0 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'domjudge', 'FAOhzxtfbrEVa5I...', Array) #1 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(44): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=loca...', 'domjudge', 'FAOhzxtfbrEVa5I...', Array) #2 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'domjudge', 'FAOhzxtfbrEVa5I...', Array) #3 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\DBAL\Connection->connect() #4 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doc {"exception":"[object] (Symfony\Component\Debug\Exception\FatalErrorException(code: 0): Error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'domjudge'@'localhost' (using password: YES) in /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43\nStack trace:\n#0 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'domjudge', 'FAOhzxtfbrEVa5I...', Array)\n#1 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(44): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=loca...', 'domjudge', 'FAOhzxtfbrEVa5I...', Array)\n#2 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(360): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'domjudge', 'FAOhzxtfbrEVa5I...', Array)\n#3 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): Doctrine\DBAL\Connection->connect()\n#4 /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doc at /opt/domjudge/domserver/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103)"} []