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