Jump server user password expired

Gateway SSH User password expired 


If you are getting the below message when logging into the GUI, then it's time for you to reset the password for the ssh gateway user and go ahead with the  login. This is a security feature as it is recommended to change the password after a preset duration of time.

However, if you are unable to reset the password or is unable to login to the GUI, do continue reading on how to disable this from the database.

password expired

 

The duration ( in days) after which a password should expired is set under " User password Lifetime" 

user-password-expired

 

If for some reason, the user is unable to login, then you can disable the  "User Password Lifetime" from the database as follows. The value of 90, means that the users password would expire after 90 days and the user would be forced to change the password.

 MariaDB [ezlogin_avmzfj]>  update nfo_settings set value=1 where id=86;

+----+------------+-------+---------------------+
| id | name       | value | mtime               |
+----+------------+-------+---------------------+
| 86 | pwexp_days | 90     | 2020-11-29 21:51:32 |
+----+------------+-------+---------------------+
 
MariaDB [ezlogin_avmzfj]> select * from nfo_settings where id=86;

+----+------------+-------+---------------------+

| id | name       | value | mtime               |

+----+------------+-------+---------------------+

| 86 | pwexp_days | 0     | 2020-12-18 14:19:01 |

+----+------------+-------+---------------------+

1 row in set (0.001 sec) 



Method 2) Modify the gateway user timestamp in the database so that user password does not expire and is still valid.

  • Get the current timestamp from db and update the gateway users time stamp field so that the user password expiry time is reset.
     

    [root@jump-server ~]# date +%s

    1608282636

    MariaDB [ezlogin_avmzfj]> update nfo_users set  lpwc_ts = 1608282636  where id=1;;

    Query OK, 1 row affected (0.001 sec)

    Rows matched: 1  Changed: 1  Warnings: 0

 

0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    ERROR for site owner: Invalid domain for site key
    Viewed 6450 times since Thu, Jun 28, 2018
    LDAP verification failed. Connection to {hostname} closed.
    Viewed 1272 times since Fri, May 18, 2018
    How do i disable google 2 factor authentication or other 2factor mechanisms in the GUI?
    Viewed 6140 times since Wed, Jun 14, 2017
    Google Recaptcha shutdown issue
    Viewed 1156 times since Tue, Jul 3, 2018
    Error opening terminal: xterm-256color.
    Viewed 1287 times since Wed, Jul 31, 2019
    fatal: no matching mac found: unable to ssh due to strict cipher set for pci dss compliance on remote box
    Viewed 6124 times since Fri, Sep 1, 2017
    Error: Wrong passphrase or corrupted key
    Viewed 170 times since Mon, Nov 9, 2020
    Error: User modify failed. Cannot modify user on other node: Authentication by SSH key failed!
    Viewed 1197 times since Thu, Mar 7, 2019
    License cache outdated but its not time yet
    Viewed 2229 times since Wed, Jun 14, 2017
    Can’t connect to local MySQL server through socket ’3306 ’ in ezsh.log
    Viewed 2381 times since Thu, Jun 15, 2017