How to reset the Teaming (Liferay) administrator's password if locked out.

  • 7000137
  • 18-Apr-2008
  • 27-Apr-2012


Novell Teaming 1.0
Novell Teaming 1.0 Support Pack 1
Novell Teaming 1.0 Support Pack 2
Novell SUSE Linux Enterprise Server 10
Novell SUSE Linux Enterprise Server 10 Support Pack 1
Novell Teaming is installed correctly.
Novell Teaming is working on both HTTP and HTTPS ports.


To reset the administrator's password is lost or changed unknowingly.
Administrator cannot login to Teaming.
Administrator's password was lost and needs to be changed.
Administrator's password was unknowingly changed.


Corrective Actions:
To reset the administrator's password edits must be made directly to the Teaming/Liferay database. How the database is edited depends on which database system was used for Teaming/Liferay. This maybe MySQL 5, SQL server for Windows (2000 or 2005), or Oracle (9 or 10). The most common configuration for Novell Teaming is to user MySQL so for the purposes of this TID the example will use MySQL.
Using the GUI MySQL tools for this process is easier and can be downloaded from:
GUI MySQL Query Browser method:
  1. Start the MySQL Query Browser

    If a basic installation has been used, it may be necessary to launch the Query Browser on the same server where the MySQL database server software is running.

  2. Enter the Hostname, Port (usually 3306), username (a user who has all rights access, usually root), and the user's password.

    A basic installation for teaming has you use the user of root with a password of root.

  3. On the right hand side in the Schemata pane click on the “lportal” database

  4. Now expand the “lportal” database

  5. Scroll down to the “User_” table

  6. Double click on the “User_” table

    This will populate the panel across the top of the query browser with the command:

    SELECT * FROM lportal.User_ U LIMIT 0,1000

  7. Click on the Execute button

    A list of Liferay users will be listed including the admin user (usually userid 2)

  8. Highlight the admin user and click on the Start Editing button at the bottom of the browser

  9. Click on the password field for the admin user and enter your new password

  10. Click on the passwordEncrypted field for the admin user and change to value to 0 (zero)

  11. Click on the Apply Changes button at the bottom of the query browser

  12. Exit the query browser

  13. Load a internet browser and change to the Teaming URL

  14. Login as admin with the new password

  15. Using the Enterprise Admin portlet, change the admin's password to re-encrypt the password.

Additional Information

The administrator's password for Teaming is actually the administrator's password for the Liferay portal installed with Teaming. The administrator and the administrator's password are stored in the database used for Teaming/Liferay. This maybe Sequel, MySQL, or Oracle. Within that database system an lportal database is created and the Liferay userid's and passwords are stored there under a table named User_.
NOTE:  This TID does not apply to Teaming 2.x as Liferay has been removed from Teaming and therefore the lportal database is no longer used.