Install PartKeepr on Ubuntu 20.10

281 views
Skip to first unread message

James Khor

unread,
Jun 18, 2021, 12:38:00 PM6/18/21
to PartKeepr Users
Hi All,


Just when i am executing PartKeepr Setup part A, I received "An Exception was thrown while handling: Internal Server Error" when i browsed to the server ip address with 8079.

How do i know what internal server error is?

Thanks.


Daniel Calcoen

unread,
Jun 18, 2021, 1:14:50 PM6/18/21
to PartKeepr Users
you can look the log files
they are located as explained here

James Khor

unread,
Jun 18, 2021, 8:12:17 PM6/18/21
to PartKeepr Users
Hi All,

I encountered the following errors in partkeepr.log.
[2021-06-18 09:33:18] 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/PartKeepr-1.4.0/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/PartKeepr-1.4.0/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/PartKeepr-1.4.0/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/PartKeepr-1.4.0/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)"} []

Kindly advice how do i fix this error.
And also, do i need to create the database as shown below before i execute the steps in PartKeepr Setup part A? Thanks.

Manually create the database

You can find some description of the database creation commands here MySQL Create Database.

Use following set of command to create the database

> mysql -u root -p

Enter password:

mysql> CREATE DATABASE te_mpe_ep CHARACTER SET UTF8;

mysql> CREATE USER daniel@localhost IDENTIFIED WITH mysql_native_password BY 'daniel';

mysql> GRANT USAGE ON *.* TO daniel@localhost;

mysql> GRANT ALL PRIVILEGES ON te_mpe_ep.* TO daniel@localhost;

mysql> quit

Note: for the dump of the database (11 - Backup Import Export MySQL tables) may be you need to add the global PROCESS privilege to the user running the command

mysql>GRANT PROCESS ON *.* TO daniel@localhost;

you can use the following to verify that the database and the user were created

mysql> SHOW DATABASES;

mysql> SELECT User FROM mysql.user;

mysql> quit


if needed you can restart the MySQL service

>service mysql restart

you can use the following that MySQL is running ok

>service mysql status


to explicitly change an already existent user to use mysql_native_password you can use these commands

mysql> ALTER USER 'daniel'@'localhost' IDENTIFIED WITH mysql_native_password BY 'daniel';

mysql> FLUSH PRIVILEGES;


with the database created and running ok ...

Daniel Calcoen

unread,
Jun 19, 2021, 7:49:00 AM6/19/21
to PartKeepr Users
Dear James

a) yes, you could create the database before, but shouldn't be necessary.

b) seems that your MySQL is not running properly
try to check its state with

>systemctl status mysql.service

you can try to re-start with
>systemctl restart mysql.service

c) is this an installation from scratch (a clean pristine system) or do have a previous installation of partkeepr from before ? or a previous installation of MySQL?

Regards
Daniel
Reply all
Reply to author
Forward
0 new messages