[rt-users] cannot log in as root

[Tim Suter]

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?

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
> >
> >  
> >
>