Search code examples
mysqlliferayliferay-6hsqldb

get admin credentials from liferay while using hsql database

I need to recover admin username / password or at lest email address of the admin of liferay. We have one instance running on HSQL database( I know not remanded). I need to get admin access of this server. How can I get Username from hsql.

I took the data folder from running server and copy in local server. Given database connection string in portal-ext.properties file. and restart the server. Users from previous server does not gets imported in my local database.

Is there any mechanism from which I can able to import user from hsql to mysql or read hsql database by any mechanism.

Thanks in advance.

Solution

  • You can access to HSQL with a database explorer like SQUIRRELL SQL and HSQL jdbc driver.

    More info => HSQLInspect

    Then you can edit users table to change admin password to something like "qUqP5cyxm6YcTAhz05Hph5gvu9M=" (this corresponds to test word). More info => Lost admin password.