[rt-users] Almost there... Some progress... maybe...

[Ben Weston]

Several people have sent me emails directly have have been quite 
helpful.  I appolgize if I haven't replied personally.

The advice I've gotten has certainly made some progress....  Though I'm 
still looking at the same page as a result.  Please bare with me while I 
paste in cfg's and error messages.

---
httpd.conf
# Begin RT Host
<VirtualHost 192.168.51.48:80>
   ServerName 192.168.51.48
   ServerAdmin ben at NOSPAM.com
   DocumentRoot /opt/rt3/share/html

   PerlRequire /opt/rt3/bin/webmux.pl

   <Directory /opt/rt34/share/html>
       Order allow,deny
       Allow from all
       SetHandler perl-script
       PerlResponseHandler RT::Mason
   </Directory>
</VirtualHost>

RT_Siteconfig: (NOTE: server is currently setup only for internal use, 
no DNS A or CNAME)
Set($rtname , "rt.computerhelpme.com");
Set($Organization , "computerhelpme.com");
Set($DatabaseType , 'mysql');
Set($DatabaseHost   , '');
Set($DatabaseRTHost , '');
Set($DatabasePort , '');
Set($DatabaseUser , 'rt');
Set($DatabasePassword , 'nottelling');
Set($DatabaseName , 'rt3');
---
Here's what I had/have/have done:
 From /var/log/httpd/error_log earlier today:
DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access 
denied for user 'rt_user'@'localhost' (using password: YES) at 
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 108
[Tue Aug 29 10:05:59 2006] [error] [client 192.168.51.72] Connect Failed 
Access denied for user 'rt_user'@'localhost' (using password: YES)\n at 
/opt/rt3/lib/RT.pm line 176\n

Reset my password for the rt user, and made sure all the RT config 
settings were sane (a couple of them were originally incorrect), I'm no 
longer getting those errors...

 From /var/log/httpd/error_log, now:
[Tue Aug 29 13:01:54 2006] [notice] suEXEC mechanism enabled (wrapper: 
/usr/sbin/suexec)
[Tue Aug 29 13:01:57 2006] [notice] Digest: generating secret for digest 
authentication ...
[Tue Aug 29 13:01:57 2006] [notice] Digest: done
[Tue Aug 29 13:01:57 2006] [notice] FastCGI: process manager initialized 
(pid 13358)
[Tue Aug 29 13:01:57 2006] [notice] mod_python: Creating 4 session 
mutexes based on 256 max processes and 0 max threads.
[Tue Aug 29 13:01:57 2006] [notice] Apache/2 configured -- resuming 
normal operations

Everything looks Ok to me here (please correct me if I'm wrong).

I went and made sure that the rt user for mysql had full access to the 
rt3 database.


Not sure if there is anything else that would be helpful in 
troubleshooting this...  I'm thinking it's a DBase permission issue, but 
I'm no longer gettig any errors regarding that...  Suggestions?   Other 
logfiles I should be looking at?


Thanks again,
Ben