[rt-users] Problems with RT 3.8.2 - Apache

[Eric Chatham]

On Monday, May 18, 2009 15:55, Nimbius Wrote:

> doublecheck the configuration of your database to make sure the rt_user
> and rt_pass actually exist and permit login...looks like thats where its
> failing

rt_user is the user, and rt_pass is the password.  I'm still having a problem. :/

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE user SET Password=PASSWORD('rt_pass') WHERE user='rt_user';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye

> make sure mysqld is running too.

chkconfig mysqld on


On Mon, 18 May 2009, Eric Chatham wrote:

> Date: Mon, 18 May 2009 15:27:31 -0400
> From: Eric Chatham <echatham at broadvox.net>
> To: RT Users <RT-Users at lists.bestpractical.com>
> Subject: [rt-users] Problems with RT 3.8.2 - Apache
>
> Hello,
>
> I completely started over with a fresh installation of RT using the latest version 3.8.2.  Following the README file that is packed with the new installation, I'm stuck at the Apache configuration.  I added the lines for Apache 2.x.x:
>
>
> <VirtualHost your.ip.address>
>
>    ServerName your.rt.server.hostname
>
>
>
>    DocumentRoot /opt/rt3/share/html
>
>    AddDefaultCharset UTF-8
>
>
>
>    # optional apache logs for RT
>
>    # ErrorLog /opt/rt3/var/log/apache2.error
>
>    # TransferLog /opt/rt3/var/log/apache2.access
>
>
>
>    PerlRequire "/opt/rt3/bin/webmux.pl"
>
>
>
>    <Location /NoAuth/images>
>
>        SetHandler default
>
>    </Location>
>
>    <Location />
>
>        SetHandler perl-script
>
>        PerlResponseHandler RT::Mason
>
>    </Location>
>
> </VirtualHost>
>
> Here is my rt3.conf file settings:
>
> Alias /rt3 "/usr/share/rt3/html"
>
> # PerlRequire /usr/sbin/webmux.pl
>
> <Directory "/usr/share/rt3/html">
>  AllowOverride All
>  Options ExecCGI FollowSymLinks
>
>  RewriteEngine On
>  RedirectMatch permanent (.*)/$ $1/index.html
>  AddDefaultCharset UTF-8
>  SetHandler perl-script
>  PerlHandler RT::Mason
> </Directory>
> <VirtualHost 172.16.5.163>
>        ServerName clehbrtsrv01.broadvox.local
>
>        DocumentRoot /opt/rt3/share/html
>        AddDefaultCharset UTF-8
>
>        # optional apache logs for RT
>        # ErrorLog /opt/rt3/var/log/apache.error
>        # TransferLog /opt/rt3/var/log/apache.error
>
>        PerlModule Apache::DBI
>        PerlRequire /opt/rt3/bin/webmux.pl
>        <Location /NoAuth/images>
>                SetHandler default
>        </Location>
>        <Location />
>                SetHandler perl-script
>                PerlHandler RT::Mason
>        </Location>
> </VirtualHost>
>
> When I restart Apache and MySql, I tried accessing the page http://clehbrtsrv01.broadvox.local/ (no /rt3).  I get an "Internal Server Error" due to a misconfiguration.  Here is my error_log file for Apache:
>
>
> [Mon May 18 15:12:12 2009] [notice] caught SIGTERM, shutting down
> [Mon May 18 15:16:16 2009] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
> [Mon May 18 15:16:19 2009] [notice] Digest: generating secret for digest authentication ...
> [Mon May 18 15:16:19 2009] [notice] Digest: done
> [Mon May 18 15:16:21 2009] [notice] Apache/2.2.3 (CentOS) configured -- resuming normal operations
> 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 106
> [Mon May 18 15:17:11 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n
> 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 106
> [Mon May 18 15:17:14 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n
> 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 106
> [Mon May 18 15:17:15 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n
> 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 106
> [Mon May 18 15:17:16 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n
> 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 106
> [Mon May 18 15:17:16 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n
> 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 106
> [Mon May 18 15:18:15 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n
>
> Eric Chatham
> MIS Department
> Phone: (216) 373-4683
> Fax: (216) 373-4669
> echatham at broadvox.net
> [cid:image001.gif at 01C9D7CC.691A95E0]
>
>
> ________________________________
> CONFIDENTIAL. This e-mail and any attached files are confidential and should be destroyed and/or returned if you are not the intended and proper recipient.
>

nimbius at sdf.lonestar.org
SDF Public Access UNIX System - http://sdf.lonestar.org

CONFIDENTIAL.  This e-mail and any attached files are confidential and should be destroyed and/or returned if you are not the intended and proper recipient.