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
Iâm sure that I never changed this password!
It is not my faultâŠtill Iâm guilty
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
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
Before or after?
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
new version, see first post, the cron job is redirected to /null
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