Cannot log in as root

I have an existing fresh installation of RT3.2.3. I wanted to use the
LDAP overlay but was told to change it to Apache’s ldap authorization,
the authzldap module. After attempting to do that, I couldn’t get
logged in. So, I thought I would go and “switch everything back” to the
way it was. In doing this, I found that after I got things “back”, I
couldn’t log in as root with the password I changed before I started
messing with the authzldap module.

I followed the bestpractical FAQ to reset the root password back to the
default password for the root account, however, that didn’t work. This
was a MySQL command.

I restarted MySQL and apache.

Still nothing.

Anyone know what I should check now?

Tim

BTW, I don’t have anything that I care about saving as this is a clean
test install and have just been poking around seeing what I can do with
it (obviously, I can break it!).
So, if there is something that I have to do like create a new DB or
whatever, no prob.

TimOn Fri, 2005-06-03 at 10:00 -0500, Tim Suter wrote:

I have an existing fresh installation of RT3.2.3. I wanted to use the
LDAP overlay but was told to change it to Apache’s ldap authorization,
the authzldap module. After attempting to do that, I couldn’t get
logged in. So, I thought I would go and “switch everything back” to the
way it was. In doing this, I found that after I got things “back”, I
couldn’t log in as root with the password I changed before I started
messing with the authzldap module.

I followed the bestpractical FAQ to reset the root password back to the
default password for the root account, however, that didn’t work. This
was a MySQL command.

I restarted MySQL and apache.

Still nothing.

Anyone know what I should check now?

Tim


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Tim Suter wrote:

BTW, I don’t have anything that I care about saving as this is a clean
test install and have just been poking around seeing what I can do with
it (obviously, I can break it!).
So, if there is something that I have to do like create a new DB or
whatever, no prob.

Tim

I have an existing fresh installation of RT3.2.3. I wanted to use the
LDAP overlay but was told to change it to Apache’s ldap authorization,
the authzldap module. After attempting to do that, I couldn’t get
logged in. So, I thought I would go and “switch everything back” to the
way it was. In doing this, I found that after I got things “back”, I
couldn’t log in as root with the password I changed before I started
messing with the authzldap module.

I followed the bestpractical FAQ to reset the root password back to the
default password for the root account, however, that didn’t work. This
was a MySQL command.

I restarted MySQL and apache.

Still nothing.

Anyone know what I should check now?

Tim


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Can you bring up mysql as that user outside of RT? (Be sure to use the
username and password from your RT_SiteConfig.pm) Does show databases
show the database for rt?

Vicki

Is there a way to reinitialize this installation so that I can get root
access to the web interface back? Does it need to be that dramatic?
FastCGI gives me the following error_log:

[Fri Jun 03 13:36:30 2005] [error] [client x.x.x.x] FastCGI: server
“/opt/rt3/bin/mason_handler.fcgi” stderr: [Fri Jun 3 18:36:30 2005]
[error]: FAILED LOGIN for admin from x.x.x.x
(/opt/rt3/share/html/autohandler:197), referer:
http://testhelp.x.x/index.html

I think it has to lie within FastCGI. Anyone care to input?

Accessing the database rt3 as rt_user and with rt_pass works fine.

It’s just the web interface I can’t get access to as root.

TimOn Fri, 2005-06-03 at 10:23 -0500, Vicki Stanfield wrote:

Tim Suter wrote:

BTW, I don’t have anything that I care about saving as this is a clean
test install and have just been poking around seeing what I can do with
it (obviously, I can break it!).
So, if there is something that I have to do like create a new DB or
whatever, no prob.

Tim
On Fri, 2005-06-03 at 10:00 -0500, Tim Suter wrote:

I have an existing fresh installation of RT3.2.3. I wanted to use the
LDAP overlay but was told to change it to Apache’s ldap authorization,
the authzldap module. After attempting to do that, I couldn’t get
logged in. So, I thought I would go and “switch everything back” to the
way it was. In doing this, I found that after I got things “back”, I
couldn’t log in as root with the password I changed before I started
messing with the authzldap module.

I followed the bestpractical FAQ to reset the root password back to the
default password for the root account, however, that didn’t work. This
was a MySQL command.

I restarted MySQL and apache.

Still nothing.

Anyone know what I should check now?

Tim


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Can you bring up mysql as that user outside of RT? (Be sure to use the
username and password from your RT_SiteConfig.pm) Does show databases
show the database for rt?

Vicki

If you don’t have valuable data in DB you can reinit DB. goto dir where
RT sources are, and run

make dropdb
make initdb
This will reset data.

Tim Suter wrote:

Thanks Ruslan. I didn’t try that. I did this:
cd /opt
rm -rf rt3 (I know. It was excessive, but hey, it was a Friday night
and it was late and I was in a mood.)
Then I removed the database.
ran make install and make initialize-database from the source
directory.

All was well again. However, for future reference, what could have
caused this thing to go poof like it did?

TimOn Sat, 2005-06-04 at 02:53 +0400, Ruslan U. Zakirov wrote:

If you don’t have valuable data in DB you can reinit DB. goto dir where
RT sources are, and run

make dropdb
make initdb
This will reset data.

Tim Suter wrote:

Is there a way to reinitialize this installation so that I can get root
access to the web interface back? Does it need to be that dramatic?
FastCGI gives me the following error_log:

[Fri Jun 03 13:36:30 2005] [error] [client x.x.x.x] FastCGI: server
“/opt/rt3/bin/mason_handler.fcgi” stderr: [Fri Jun 3 18:36:30 2005]
[error]: FAILED LOGIN for admin from x.x.x.x
(/opt/rt3/share/html/autohandler:197), referer:
http://testhelp.x.x/index.html

I think it has to lie within FastCGI. Anyone care to input?

Accessing the database rt3 as rt_user and with rt_pass works fine.

It’s just the web interface I can’t get access to as root.

Tim

On Fri, 2005-06-03 at 10:23 -0500, Vicki Stanfield wrote:

Tim Suter wrote:

BTW, I don’t have anything that I care about saving as this is a clean
test install and have just been poking around seeing what I can do with
it (obviously, I can break it!).
So, if there is something that I have to do like create a new DB or
whatever, no prob.

Tim
On Fri, 2005-06-03 at 10:00 -0500, Tim Suter wrote:

I have an existing fresh installation of RT3.2.3. I wanted to use the
LDAP overlay but was told to change it to Apache’s ldap authorization,
the authzldap module. After attempting to do that, I couldn’t get
logged in. So, I thought I would go and “switch everything back” to the
way it was. In doing this, I found that after I got things “back”, I
couldn’t log in as root with the password I changed before I started
messing with the authzldap module.

I followed the bestpractical FAQ to reset the root password back to the
default password for the root account, however, that didn’t work. This
was a MySQL command.

I restarted MySQL and apache.

Still nothing.

Anyone know what I should check now?

Tim


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Can you bring up mysql as that user outside of RT? (Be sure to use the
username and password from your RT_SiteConfig.pm) Does show databases
show the database for rt?

Vicki


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Tim Suter wrote:

Thanks Ruslan. I didn’t try that. I did this:
cd /opt
rm -rf rt3 (I know. It was excessive, but hey, it was a Friday night
and it was late and I was in a mood.)
Then I removed the database.
ran make install and make initialize-database from the source
directory.

All was well again. However, for future reference, what could have
caused this thing to go poof like it did?
I don’t know, I didn’t have a chance to work with external users DB.