Friday, October 15, 2010

Manually recover Liferay admin password

I forgot liferay admin password for a brand new production configuration. That is not big deal if the server has accessible SMTP but in my case the hosting provider hadn't enabled it so I knew my only option was to touch the database directly.

Password string "test" after encryption becomes 'qUqP5cyxm6YcTAhz05Hph5gvu9M=' so the below statement will take care of reseting the password to test (Of course in production you must never have the original user so change that by the real admin email in your system)
SET password_='qUqP5cyxm6YcTAhz05Hph5gvu9M=' 
WHERE emailAddress='';

No comments: