Page History

Problem

How to extend the user password when expired.User unable to login to Domibus Admin console, and getting error - "Password Expired"

To extend the password of the admin user for 3 months, for example, use the following command (MYSQL and ORACLE):

UPDATE TB_USER SET `PASSWORD_CHANGE_DATE` = DATE_ADD(`PASSWORD_CHANGE_DATE`, INTERVAL 3 MONTH);

COMMIT;

To check the expiry date of all the users

Select PASSWORD_CHANGE_DATE, USER_NAME from TB_USER;

In general:

FOR ORACLE

update TB_USER set PASSWORD_CHANGE_DATE=sysdate+90;

in days, here 90 days.

COMMIT

FOR MYSQL

update TB_USER set PASSWORD_CHANGE_DATE=sysdate()+3000;

in seconds for a couple of hours

COMMIT