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 <[email protected]>
> To: RT Users <[email protected]>
> 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
> [email protected]
> [cid:[email protected]]
>
>
> ________________________________
> 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.
>
[email protected]
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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
