RecoverRootPassword - Revision history

Kurth at 22:24, 26 June 2023

2023-06-26T22:24:52Z

← Older revision		Revision as of 18:24, 26 June 2023
Line 15:		Line 15:
	-MRT -MRT::User \		-MRT -MRT::User \
	-e'RT::LoadConfig(); RT::Init(); my $u = RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'		-e'RT::LoadConfig(); RT::Init(); my $u = RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'

			The above also works for rt5, just adjust the include path to your rt installation (typically /opt/rt5).

	== Use another known password ==		== Use another known password ==

Shawn: Improve formatting

2017-03-01T18:19:14Z

Improve formatting

← Older revision		Revision as of 14:19, 1 March 2017
Line 5:		Line 5:
	The original (default) '''RT root user''' password is "password", not the password you set in RT_SiteConfig.pm (which is your DBMS root user password), nor the password of your '''Unix''' root user.		The original (default) '''RT root user''' password is "password", not the password you set in RT_SiteConfig.pm (which is your DBMS root user password), nor the password of your '''Unix''' root user.

	If you over-write or ~~corrupt~~ the root password, there are a few ways to recover it.		If you over-write, corrupt, or lose the root password, there are a few ways to recover it.

	== Easiest way ==		== Easiest way ==
Line 12:		Line 12:

	A:		A:
			perl -I/opt/rt4/local/lib -I/opt/rt4/lib \
	perl -I/opt/rt4/local/lib -I/opt/rt4/lib \
	-MRT -MRT::User \		-MRT -MRT::User \
	-e'RT::LoadConfig();RT::Init(); my $u = RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'		-e'RT::LoadConfig(); RT::Init(); my $u = RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'

	== Use another known password ==		== Use another known password ==
Line 26:		Line 25:

	Use base64 encoded MD5 of the word 'password'. This should work with all recent RT versions. Before you set the password you must switch to the RT Database.		Use base64 encoded MD5 of the word 'password'. This should work with all recent RT versions. Before you set the password you must switch to the RT Database.

	mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';		mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';

	~~<p style="margin-top:0.4em;margin-bottom:0.5em;">~~For RT4 use the default enry (root/password):~~</p>~~		For RT4 use the default enry (root/password):
			mysql> UPDATE Users SET Password='!bcrypt!10!xijhhtbzipG6.EsQwgic7.D1mUs2tC0yN4iNjOWS9Za8gAtKTzTlW' WHERE Name='root';

	~~mysql> UPDATE Users SET Password='!bcrypt!10!xijhhtbzipG6.EsQwgic7.D1mUs2tC0yN4iNjOWS9Za8gAtKTzTlW' WHERE Name='root';~~
	Or...		Or...

	mysql> UPDATE Users SET Password=md5('password') WHERE Name='root';		mysql> UPDATE Users SET Password=md5('password') WHERE Name='root';

	Or very old crypt variant.		Or very old crypt variant.

	mysql> UPDATE Users SET Password=ENCRYPT('password','SA') WHERE Name='root';		mysql> UPDATE Users SET Password=ENCRYPT('password','SA') WHERE Name='root';

Admin: 7 revisions imported

2016-04-06T20:35:27Z

7 revisions imported

New page

The topic of recovering root password comes up frequently in the [[MailingLists]].

Here are some answers.

The original (default) '''RT root user''' password is "password", not the password you set in RT_SiteConfig.pm (which is your DBMS root user password), nor the password of your '''Unix''' root user.

If you over-write or corrupt the root password, there are a few ways to recover it.

== Easiest way ==

Q: I lost the root password how can I reset it?

A:

perl -I/opt/rt4/local/lib -I/opt/rt4/lib \
-MRT -MRT::User \
-e'RT::LoadConfig();RT::Init(); my $u = RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'

== Use another known password ==

Use SQL to copy the known password from some other user into the root password.

== Generate a new password ==

=== SQL ===

Use base64 encoded MD5 of the word 'password'. This should work with all recent RT versions. Before you set the password you must switch to the RT Database.

mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';

<p style="margin-top:0.4em;margin-bottom:0.5em;">For RT4 use the default enry (root/password):</p>

mysql> UPDATE Users SET Password='!bcrypt!10!xijhhtbzipG6.EsQwgic7.D1mUs2tC0yN4iNjOWS9Za8gAtKTzTlW' WHERE Name='root';
Or...

mysql> UPDATE Users SET Password=md5('password') WHERE Name='root';

Or very old crypt variant.

mysql> UPDATE Users SET Password=ENCRYPT('password','SA') WHERE Name='root';

== Enable root user ==

Q: Passwort is reset, but i still can not log in. My log says:

Disabled user root tried to log in

A: You have to (re-)enable the root user:

Find out the id of root (usually it's 12):
mysql> SELECT * FROM Users WHERE Name='root';
Check if root is disabled:
mysql> SELECT * FROM Principals WHERE id=12;
Enable root:
mysql> UPDATE Principals SET Disabled=0 WHERE id=12;

== See also ==

[[PasswordsInDB]]

93.231.151.40: /* SQL */

2014-02-10T14:30:50Z

SQL

← Older revision		Revision as of 10:30, 10 February 2014
Line 29:		Line 29:
	mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';		mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';

			<p style="margin-top:0.4em;margin-bottom:0.5em;">For RT4 use the default enry (root/password):</p>

			mysql> UPDATE Users SET Password='!bcrypt!10!xijhhtbzipG6.EsQwgic7.D1mUs2tC0yN4iNjOWS9Za8gAtKTzTlW' WHERE Name='root';
	Or...		Or...

195.254.241.94: Added: Enable root user

2012-05-31T07:08:27Z

Added: Enable root user

@@ Line 16: / Line 16: @@
       -MRT -MRT::User \
       -e'RT::LoadConfig();RT::Init(); my $u = RT::User-&gt;new($RT::SystemUser); $u-&gt;Load("root"); $u-&gt;SetPassword("secret")'
 == Use another known password ==
@@ Line 39: / Line 36: @@
   mysql&gt; UPDATE Users SET Password=ENCRYPT('password','SA') WHERE Name='root';
 == See also ==
 [[PasswordsInDB]]

80.152.160.53: /* Generate a new password */

2011-01-28T11:58:27Z

Generate a new password

← Older revision		Revision as of 07:58, 28 January 2011
Line 28:		Line 28:
	=== SQL ===		=== SQL ===

	Use base64 encoded MD5 of the word 'password'. This should work with all recent RT versions. Before you set the password you must ~~change~~ to the RT Database.		Use base64 encoded MD5 of the word 'password'. This should work with all recent RT versions. Before you set the password you must switch to the RT Database.


	mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';		mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';

80.152.160.53: /* SQL */

2011-01-28T11:57:47Z

SQL

New page