How do I change the password management option for all remote servers ?
How do I change the Ezeelogin password management option to "automatic" for all remote servers?
Refer Password management in Ezeelogin to get more ideas about different password management options in Ezeelogin.
Take a backup of the Ezeelogin database by the following command.
[email protected]:~# mysqldump db_name > db.sql
Find the database prefix from /usr/local/etc/ezlogin/ez.conf in Ezeelogin gateway server
[email protected]:~# cat /usr/local/etc/ezlogin/ez.conf
system_folder /var/www/ezlogin/
force_https yes
uri_path /
db_host localhost
db_port /var/run/mysqld/mysqld.sock
db_name ezlogin_por
db_user ezlogin_cxy
db_pass ymhbtPaY)VzD2g]84
db_prefix casmbn_
cookie_encryption_key D8$Frp5fF_FF
cookie_name rlbup
cookie_path /
www_folder /var/www/html/ezlogin/
admin_user ezadmin
mysql_encrypt no
1. Run the following query to change the password management option to "automatic"
Replace the " prefix_" with the value given in the /usr/local/ezlogin/ez.conf of your Ezeelogin jumpserver.
[email protected]:~# php /usr/local/ezlogin/ez_queryrunner.php "update prefix_servers set keep_password='N'"
2. For changing password management to "automatic" for a specific server group follow the below steps:-
Replace ezlogin_xyz with your Ezeelogin database name.
MariaDB [(none)]> select * from prefix_servergroups\G
*************************** 1. row ***************************
id: 1
name: linux_server
description:
created: 2021-06-22 20:37:46
mtime: 2021-06-23 02:07:46
*************************** 2. row ***************************
id: 2
name: development_server
description:
created: 2021-06-24 01:00:30
mtime: 2021-06-24 06:30:30
2 rows in set (0.000 sec)
[email protected] :~# php /usr/local/ezlogin/ez_queryrunner.php "update prefix_servers set keep_password='N' where servergroup_id=1"