[rt-users] RT not connecting to database?

[James Moseley]

Please list the Set($Database* entries you have in RT_SiteConfig.pm

Also, have you run 'make testdeps' to see if you are missing any perl
modules?


James Moseley




                                                                           
             John Oliver                                                   
             <joliver at john-oli                                             
             ver.net>                                                   To 
             Sent by:                  rt-users at lists.bestpractical.com    
             rt-users-bounces@                                          cc 
             lists.bestpractic                                             
             al.com                                                Subject 
                                       Re: Re: [rt-users] RT not           
                                       connecting to database?             
             07/25/2007 04:10                                              
             PM                                                            
                                                                           
                                                                           
                                                                           
                                                                           




On Tue, Jul 24, 2007 at 10:20:27AM -0700, John Oliver wrote:
> On Tue, Jul 24, 2007 at 08:13:24AM +0200, Ham MI-ID, Torsten Brumm wrote:
> > Is the server at the same box or on a separated box? How does your
setup looks like?
>
> The database is on a separate host.  It can be accessed with mysqladmin
> from the host running RT, so there isn't a firewall or anything.
>
>
> > -----Original Message-----
> >
> > On Mon, Jul 23, 2007 at 11:13:41PM +0200, Ham MI-ID, Torsten Brumm
wrote:
> > > Does this error happen all the time or after a longer time without
any usage?
> >
> > All the time.
> >
> > > -----Original Message-----
> > > From: rt-users-bounces at lists.bestpractical.com
<rt-users-bounces at lists.bestpractical.com>
> > > To: rt-users at lists.bestpractical.com
<rt-users at lists.bestpractical.com>
> > > Sent: Mon Jul 23 22:25:23 2007
> > > Subject: [rt-users] RT not connecting to database?
> > >
> > > When I hit my RT install in a browser, I get an Internet Server
Error.
> > > The error_log says:
> > >
> > > DBI connect('dbname=rt3;host=10.12.14.149','rt_user',...) failed:
Can't
> > > connect to MySQL server on '10.12.14.149' (13) at
> > > /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
106
> > > Connect Failed Can't connect to MySQL server on '10.12.14.149' (13)
> > >  at /usr/lib/perl5/vendor_perl/5.8.8/RT.pm line 205
> > > [Mon Jul 23 13:20:52 2007] [warn] (104)Connection reset by peer:
> > > mod_fcgid: read data from fastcgi server error.
> > > [Mon Jul 23 13:20:52 2007] [error] [client 192.168.2.231] Premature
end
> > > of script headers: mason_handler.fcgi
> >
> > I can run mason_handler.fcgi from the command line and get results,
> > so... some issue with the Apache configuration?

I'm still having this problem.

I configured Apache to use mod_perl instead of fcgid and I get the same
results.

The databaase is accessible, but RT won't access it.  I'm stumped.
Could this be an issue with perl-DBI?  Or something else?

How can I troubleshoot further?  I'm stuck.


--
***********************************************************************
* John Oliver                             http://www.john-oliver.net/ *
*                                                                     *
***********************************************************************
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com