I am setting up 6.0.2 in preparation for Southern California's contest next weekend. We run on Fedora, in this case Fedora 28.
I installed DOMjudge to /opt/domjudge, configured MariaDB, and copied the Apache configuration file to /etc/httpd/conf.d.
I can connect to localhost/domjudge and I see the default scoreboard.
However, when I click "Login", I get a blank screen! As far as I can tell everything is there.
Does anyone have any ideas about what might be going on?
Marc
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:
[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)"} []
Jaap Eldering wrote:
OK, I think I have it figured out. One should not run
dj_setup_database genpass
and re-generate the database password. It looks like that doesn't update the password everywhere. I ran "make install-domserver" again, which pushed the older password back. I re-created the database. Everything seems to be working now, at least so far.
Marc
On 05/11/2018 01:01, Marc Furon wrote:
Ah, yes. That command actually never reinstalled the new passwords, only creates new files etc/dbpasswords.secret and etc/restapi.secret. But with our (currently partial) migration to Symfony, passwords are used from two different places: etc/dbpasswords.secret and webapp/app/config/parameters.yml, and the way that these are synchronized during installation is a bit fragile, which should be improved.
Best, Jaap
-
Jaap Eldering -
Marc Furon