I am trying to do a new install of rt5 and I am good all the way to now apache. Apache is running, I can get the welcome page …or the It Works page. …actually when I went to check on that I no longer do. I have gotten different error message I have been trying to figure out:
All of my config files point to /rt being the setup which I get a 500 Error for:
Couldn't load RT config file RT_SiteConfig.pm:
Can't locate RT_SiteConfig.pm: /opt/rt5/etc/RT_SiteConfig.pm: Permission denied at /opt/rt5/sbin/../lib/RT/Config.pm line 2395.
RT couldn't load RT config file /opt/rt5/etc/RT_Config.pm as:
user: www-data
group: www-data
The file is owned by user root and group rt.
This usually means that the user/group your webserver is running
as cannot read the file. Be careful not to make the permissions
on this file too liberal, because it contains database passwords.
You may need to put the webserver user in the appropriate group
(rt) or change permissions be able to run succesfully.
Can't locate RT_Config.pm: /opt/rt5/etc/RT_Config.pm: Permission denied at /opt/rt5/sbin/../lib/RT/Config.pm line 2395.
[Tue Jan 09 19:00:50.557131 2024] [fcgid:warn] [pid 1435] (104)Connection reset by peer: [client 192.168.1.90:56658] mod_fcgid: error reading data from FastCGI server
[Tue Jan 09 19:00:50.557172 2024] [core:error] [pid 1435] [client 192.168.1.90:56658] End of script output before headers: rt-server.fcgi
[Tue Jan 09 19:00:50.667181 2024] [authz_core:error] [pid 1428] [client 192.168.1.90:56659] AH01630: client denied by server configuration: /opt/rt5/share/html/favicon.ico, referer: http://192.168.1.244/rt
[Tue Jan 09 19:00:54.345827 2024] [authz_core:error] [pid 1428] [client 192.168.1.90:56659] AH01630: client denied by server configuration: /opt/rt5/share/html/
[Tue Jan 09 19:00:54.426211 2024] [authz_core:error] [pid 1428] [client 192.168.1.90:56659] AH01630: client denied by server configuration: /opt/rt5/share/html/favicon.ico, referer: http://192.168.1.244/
[Tue Jan 09 19:07:23.716388 2024] [mpm_prefork:notice] [pid 1426] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
[Tue Jan 09 19:07:23.771610 2024] [mpm_prefork:notice] [pid 1426] AH00163: Apache/2.4.52 (Ubuntu) mod_fcgid/2.3.9 configured -- resuming normal operations
[Tue Jan 09 19:07:23.771631 2024] [core:notice] [pid 1426] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 09 19:07:28.118698 2024] [authz_core:error] [pid 1525] [client 192.168.1.90:56832] AH01630: client denied by server configuration: /opt/rt5/share/html/
[Tue Jan 09 19:07:28.229881 2024] [authz_core:error] [pid 1525] [client 192.168.1.90:56832] AH01630: client denied by server configuration: /opt/rt5/share/html/favicon.ico, referer: http://192.168.1.244/
[Tue Jan 09 19:07:32.544809 2024] [authz_core:error] [pid 1525] [client 192.168.1.90:56832] AH01630: client denied by server configuration: /opt/rt5/share/html/
[Tue Jan 09 19:07:32.650362 2024] [authz_core:error] [pid 1525] [client 192.168.1.90:56832] AH01630: client denied by server configuration: /opt/rt5/share/html/favicon.ico, referer: http://192.168.1.244/
[Tue Jan 09 19:17:24.987826 2024] [mpm_prefork:notice] [pid 1426] AH00170: caught SIGWINCH, shutting down gracefully
[Tue Jan 09 19:17:25.089225 2024] [mpm_prefork:notice] [pid 1676] AH00163: Apache/2.4.52 (Ubuntu) mod_fcgid/2.3.9 configured -- resuming normal operations
[Tue Jan 09 19:17:25.089390 2024] [core:notice] [pid 1676] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 09 19:17:29.590987 2024] [authz_core:error] [pid 1678] [client 192.168.1.90:57143] AH01630: client denied by server configuration: /opt/rt5/share/html/
[Tue Jan 09 19:17:29.728692 2024] [authz_core:error] [pid 1678] [client 192.168.1.90:57143] AH01630: client denied by server configuration: /opt/rt5/share/html/favicon.ico, referer: http://192.168.1.244/
[Tue Jan 09 19:17:33.101763 2024] [authz_core:error] [pid 1678] [client 192.168.1.90:57143] AH01630: client denied by server configuration: /opt/rt5/share/html/
Couldn't load RT config file RT_SiteConfig.pm:
Can't locate RT_SiteConfig.pm: /opt/rt5/etc/RT_SiteConfig.pm: Permission denied at /opt/rt5/sbin/../lib/RT/Config.pm line 2395.
[1686] [Tue Jan 9 19:17:34 2024] [warning]: DBI connect('dbname=rt5;host=localhost;client_encoding=UTF8','rt_user',...) failed: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "rt_user"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "rt_user" at /usr/local/share/perl/5.34.0/DBIx/SearchBuilder/Handle.pm line 117. (/usr/lib/x86_64-linux-gnu/perl-base/Carp.pm:291)
RT couldn't connect to the database where tickets are stored.
If this is a new installation of RT, you should visit the URL below
to configure RT and initialize your database.
If this is an existing RT installation, this may indicate a database
connectivity problem.
The error RT got back when trying to connect to your database was:
Connect Failed connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "rt_user"
connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user "rt_user"
at /opt/rt5/sbin/../lib/RT.pm line 222.
[1686] [Tue Jan 9 19:17:34 2024] [critical]: Since your configuration exists (/opt/rt5/etc/RT_SiteConfig.pm) but is not writable, I'm refusing to do anything. (/opt/rt5/sbin/../lib/RT.pm:409)
Since your configuration exists (/opt/rt5/etc/RT_SiteConfig.pm) but is not writable, I'm refusing to do anything.
[Tue Jan 09 19:17:34.592305 2024] [fcgid:warn] [pid 1678] (104)Connection reset by peer: [client 192.168.1.90:57143] mod_fcgid: error reading data from FastCGI server
[Tue Jan 09 19:17:34.592345 2024] [core:error] [pid 1678] [client 192.168.1.90:57143] End of script output before headers: rt-server.fcgi
[Tue Jan 09 19:17:34.718030 2024] [authz_core:error] [pid 1680] [client 192.168.1.90:57144] AH01630: client denied by server configuration: /opt/rt5/share/html/favicon.ico, referer: http://192.168.1.244/rt
Now the one thing I do notice is that there is mention of the rt_user account that it is saying is not logging in correctly. There are two places that user is mentioned in the whole setup:
# DatabaseUser is the name of the database account RT uses to read and store
# data. 'rt_user' is the default but you can change it if you like.
# DO NOT use the 'rt_admin' superuser created in the instructions above.
Set($DatabaseUser, 'rt_user');
# DatabasePassword is the password for DatabaseUser.
Set($DatabasePassword, 'EDIT WITH SomePassphraseHere');
and then at the top when setting the authentication method as MD5:
host rt5 rt_user all md5
host rt5 rt_admin all md5
From what I can see there was not a step to even create a user in the DB?!?! Maybe that was done automatically somewhere?
I’m at a loss here. I would really like to use this software and give it a whirl but the documentation seems to be missing or not right. Any ideas?