jr0w3 / glpi_install_script Goto Github PK

Hello friend!

While installing I get the following error:
Database connection failed with message "(1045) Access denied for user 'glpi_user'@'localhost' (using password: YES)".

I was able to solve it by change the line 169 from the glpi-install.sh script file:

From:
mysql -e "GRANT ALL PRIVILEGES ON glpi.* TO 'glpi_user'@'localhost'"

To:
mysql -e "GRANT ALL PRIVILEGES ON glpi.* TO 'glpi_user'@'localhost' identified by '$SQLGLPIPWD'"

Hope it might help someone else, and thank you so much for creating this script

I found out that the command proposed by the installer not works

With this in the other all works correctly
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql

Reference

Tested on Ubuntu 22.04 LTS and Debian 11.

Fresh install OS.

Script run as root.

ERROR :

Configuring MariaDB...
ERROR 1356 (HY000) at line 1: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
glpi-install.sh: line 176: dpkg-reconfigure: command not found

IP address acces via browser:
"Error: An error has occurred, but the trace of this error could not recorded because of a problem accessing the log file."