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
Hi Marc,
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)
Best, Jaap
On 04/11/2018 23:27, Marc Furon wrote:
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
DOMjudge-devel mailing list DOMjudge-devel@domjudge.org https://www.domjudge.org/mailman/listinfo/domjudge-devel
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)"} []
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)
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:
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)
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.
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