PartKeepr fails to connect to database.

43 views
Skip to first unread message

Matteo Parenti

unread,
Jun 3, 2022, 10:56:07 AM6/3/22
to PartKeepr Users
As per the object, during setup the Test connectivity function fails. The SQL database is available on all PCs on the networks, and works normally on the host. logs report he following:
request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "No route found for "GET /app/logs/ignore.json" (from "http://192.168.1.191/setup/")" at /var/www/html/partkeepr/app/cache/prod/classes.php line 2138 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): No route found for \"GET /app/logs/ignore.json\" (from \"http://192.168.1.191/setup/\") at /var/www/html/partkeepr/app/cache/prod/classes.php:2138, Symfony\\Component\\Routing\\Exception\\ResourceNotFoundException(code: 0):  at /var/www/html/partkeepr/app/cache/prod/appProdProjectContainerUrlMatcher.php:3087)"} []
request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occured in driver: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'" at /var/www/html/partkeepr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' at /var/www/html/partkeepr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDOException(code: 1698): SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' at /var/www/html/partkeepr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1698): SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' at /var/www/html/partkeepr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} []

Acceptable Name

unread,
Sep 14, 2022, 10:53:30 PM9/14/22
to PartKeepr Users
The only IP that works for connections is "localhost" A.K.A 127.0.0.1 so you have to configure the database:

create database partkeepr character set utf8;
grant usage on *.* to admin @ localhost identified by 'admin';
grant all privileges on partkeepr.* to admin @ localhost;
FLUSH PRIVILEGES;

I had to put spaces around the @ sign to get past the filters so the @ should not have any spaces around it.

Acceptable Name

unread,
Sep 14, 2022, 11:02:13 PM9/14/22
to PartKeepr Users
I should have read you message in more detail.

The "No route found for GET" part is discussed here:
The "Access denied for user 'root'@'localhost" is discussed in a number of places, Google for:
access denied for user 'root'@'localhost' symfony

But if I had to guess you are trying to log on to the Web UI (web browser) as root not admin.
Reply all
Reply to author
Forward
0 new messages