[rt-users] cannot log in as root

[Ruslan U. Zakirov]

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.

> 
> Tim
> 
> 
> On 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  
>>>>>>
>>>>>>_______________________________________________
>>>>>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>>
>>>>>>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>>>>>>  
>>>>>>
>>>>>>       
>>>>>>
>>>>>
>>>>>_______________________________________________
>>>>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>
>>>>>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
>>>>   
>>>>
>>>
>>>_______________________________________________
>>>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>
>>>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>>>
>>> 
>>>
>>
>