PartKeepr fails to connect to database.

[Matteo Parenti]

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]

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]

I should have read you message in more detail.

The "No route found for GET" part is discussed here:

https://stackoverflow.com/questions/8302270/symfony-2-no-route-found-for-get

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.