Nethserver-glpi needs testers

Something wrong with the access of the user root@localhost.

does it is a VM that you have played a bit ???

You have an Issue on your server…if you do

mysql

you should log to the mysql server, please test

I have already tried:

fun…did you try to change the mysql root password ?

Isn’t VM.
I think I did something when I have installed osTicket.
I will try to reset the root password …

the root password is

cat /var/lib/nethserver/secrets/mysql

should be also

[root@NS7DEV2 ~]# cat /root/.my.cnf

1 Like

I’m sure that I never changed this password!

It is not my fault…till I’m guilty :stuck_out_tongue:

1 Like

I did the following when I have installed osTicket and I changed the root password for sql but isn’t the password that I found now!

Is this the correct way, isn’t?

Reset MariaDB (MySQL) root password:

a. # systemctl stop mysqld
b. # mysqld_safe --skip-grant-tables &
c. # mysql -u root
d. > use mysql;
e. > update user SET PASSWORD=PASSWORD(“your_new_password”) WHERE USER=‘root’;
f. > flush privileges;
g. > exit
h. # reboot
(should be “systemctl start mysqld” but after a few seconds, the “mysqld (MySQL database)” service goes to “Stopped”; the reboot was the only way that I knew, to move forward).

Secure MariaDB (MySQL) installation:

a. # mysql_secure_installation

Change the root password? [Y/n] n
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y

well if you changed the root mysql password, you surely did a mess…

this is what you need to do for creating a mysql db…it is easy

http://wiki.nethserver.org/doku.php?id=howto:useful_commands#mysql

better to ask to others how to reset the password @giacomo @davidep

1 Like

Copy your new password inside /var/lib/nethserver/secretes/mysql then execute:

/etc/e-smith/events/actions/system-adjust

Pray that everything will be automatically fixed :smiley:

2 Likes

Before or after?:smiley:
Thank you! I will try!

IT WORKS!

@stephdl: The emails are still there. This time without

“A link to the Mysql server could not be established. Please check your configuration.
Le serveur Mysql est inaccessible. Vérifiez votre configuration”

in body.

yes we should redirect the email to /dev/null

1 Like

new version, see first post, the cron job is redirected to /null

1 Like

NO MORE EMAILS!

Thank you Stephane!

If I understood it well it’s and OCS inventory alternative, right? What are the differences? Did anyone get an idea of it?

no, they can work together, if you load a plugin in OCS -> https://www.ocsinventory-ng.org/en/#glpi-functionalities-en

released

1 Like