Environment
Products:
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
Configuration:
Novell Teaming is installed correctly.
Novell Teaming is working on both HTTP and HTTPS ports.
Situation
Purpose:
To reset the administrator's password is lost or changed unknowingly.
Symptoms:
Administrator cannot login to Teaming.
Administrator's password was lost and needs to be changed.
Administrator's password was unknowingly changed.
Resolution
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:
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.
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.
On the right hand side in the Schemata pane click on the “lportal” database
Now expand the “lportal” database
Scroll down to the “User_” table
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
Click on the Execute button
A list of Liferay users will be listed including the admin user (usually userid 2)
Highlight the admin user and click on the Start Editing button at the bottom of the browser
Click on the password field for the admin user and enter your new password
Click on the passwordEncrypted field for the admin user and change to value to 0 (zero)
Click on the Apply Changes button at the bottom of the query browser
Exit the query browser
Load a internet browser and change to the Teaming URL
Login as admin with the new password
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.