Skip to Content

Cannot Read DB Password

Error: Cannot Read DB Password while  Ezeelogin version upgrade

The error below occurred during the Ezeelogin upgrade process because the Ezeelogin database user’s password cannot be read from the Ezeelogin configuration file (/usr/local/etc/ezlogin/ez.conf).

This issue can only be resolved if you have a backup of ez.conf or the latest Ezeelogin full backup.

Below is an example of the default Ezeelogin configuration file. The ez.conf file should include a db_pass parameter to retrieve details from the database.

Steps to resolve the issue:

1. Run below command to retrieve the database user's password. Enter super admin password (user created at the time of installation) when prompted.

root@gateway:~# php /usr/local/ezlogin/eztool.php -show_db_credentials

Enter the Ezeelogin administrator password:


     Unable to connect to database (1045): Access denied for user 'ezlogin_tgqd'@'localhost' (using password: YES)
     DB settings:
     User: ezlogin_tgqd
     Pass: bb{F*]Y@@%vS7Y&Ukr!p/h(qS
     DB: ezlogin_ubnul
     Socket: /var/run/mysqld/mysqld.sock

2. Reset the Ezeelogin database user’s password back to the original password. Replace the username and original database user's password

root@gateway:~# mysql -u root -p

mysql> ALTER USER 'username'@'localhost' IDENTIFIED BY 'original_password';


mysql> exit


mysql> ALTER USER 'ezlogin_tgqd'@'localhost' IDENTIFIED BY 'bb{F*]Y@@%vS7Y&Ukr!p/h(qS';


3. Create a directory and extract the latest backup file to recover the password. If you have a backup of ez.conf, replace it with the original configuration file. Backup the current ez.conf file and replace it with the backed-up ez.conf. Ensure to backup the current ez.conf

root@gateway:~# mkdir ./backup_extract

root@gateway:~# sh /var/ezlogin_backup_****.bin --noexec --target ./backup_extract/

root@gateway:~# cp /usr/local/etc/ezlogin/ez.conf /usr/local/etc/ezlogin/ez.conf.backup

root@gateway:~# cp ./backup_extract/etc/ez.conf /usr/local/etc/ezlogin/ez.conf


root@gateway:~# cp /usr/local/etc/ezlogin/ez.conf /usr/local/etc/ezlogin/ez.conf.backup

root@gateway:~# cp ./ez.conf_old_backup /usr/local/etc/ezlogin/ez.conf

4. Download Ezeelogin package according to the PHP version you are running and run upgrade script.

root@gateway:~# wget

Run the command below, replacing binary package with the correct name to upgrade to either the same version or the latest version.

root@gateway:~# sh ezlogin_7.xx.xx_phpxx.bin  -- -update -skipbackup

If you encounter below mentioned error during the upgrade, you need to grant access to the database user.

To retrieve the database credentials run the below command and enter the super admin password (user created at the time of installation).

root@gateway:~#  php /usr/local/ezlogin/eztool.php -show_db_credentials


     User: ezlogin_tgqd
     Pass: bb{F*]Y@@%vS7Y&Ukr!p/h(qS

Execute the following commands to grant access to the database user.

mysql> ALTER USER 'db_username'@'localhost' IDENTIFIED BY 'db_user_password';


mysql> ALTER USER 'ezlogin_tgqd'@'localhost' IDENTIFIED BY 'bb{F*]Y@@%vS7Y&Ukr!p/h(qS';

After the successful grant run the upgrade command again.

5. After successful upgrading, login to the Ezeelogin GUI, add some test servers and users, and also login to ezsh and SSH to some random servers to confirm that everything is working fine.


Related Articles