search

nethesis / dev

Nethesis issue tracker
http://www.nethesis.it
4 stars 1 forks source link

nethserver-phonebook-mysql: MySQL `pbookuser` user's password is not keep updated #6054

Closed Amygos closed 3 years ago

Amygos commented 3 years ago

After this PR nethesis/nethserver-phonebook-mysql#34, if the PhonebookDBPasswd password is changed, the password of the MySQL user pbookuser is no more update.

Steps to reproduce

Expected behavior The relative user password is updated with the new password

# mysql -u pbookuser -p$(cat /var/lib/nethserver/secrets/PhonebookDBPasswd)
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1768
Server version: 5.5.68-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> Bye

Actual behavior The password is not updated

# mysql -u pbookuser -p$(cat /var/lib/nethserver/secrets/PhonebookDBPasswd)
ERROR 1045 (28000): Access denied for user 'pbookuser'@'localhost' (using password: YES)

Components

nethbot commented 3 years ago

in 7.9.2009/nethesis-testing:

Amygos commented 3 years ago

Test case 1

Test case 2

nethbot commented 3 years ago

in 7.9.2009/nethesis-testing:

nethbot commented 3 years ago

in 7.9.2009/nethesis-updates: