安装 RT5 时 Apache 无法启动:数据库访问问题

安装 RT5 时 Apache 无法启动:数据库访问问题

Apache 未启动。

(rt5venv) root@devrt5:/etc/apache2/sites-available# systemctl start apache2
Job for apache2.service failed because the control process exited with error code.
See "systemctl status apache2.service" and "journalctl -xe" for details.

尝试 1:

(rt5venv) root@devrt5:/etc/apache2/sites-available# systemctl status apache2

或者journalctl -xe

Dec 20 17:44:44 devrt5 apachectl[19768]: connectivity problem.
Dec 20 17:44:44 devrt5 apachectl[19768]: The error RT got back when trying to connect to your database
Dec 20 17:44:44 devrt5 apachectl[19768]: Connect Failed Access denied for user 'rt_user'@'localhost'
Dec 20 17:44:44 devrt5 apachectl[19768]:  at /opt/rt5/sbin/../lib/RT.pm line 222.
Dec 20 17:44:44 devrt5 RT[19771]: [19771] DBI 
connect('dbname=rt5;host=localhost','rt_user',...)
Dec 20 17:44:45 devrt5 systemd[1]: apache2.service: Control process exited, code=exited status=1
Dec 20 17:44:45 devrt5 sudo[19765]: pam_unix(sudo:session): session closed for user root
Dec 20 17:44:45 devrt5 systemd[1]: apache2.service: Failed with result 'exit-code'.
Dec 20 17:44:45 devrt5 systemd[1]: Failed to start The Apache HTTP Server.
-- Unit apache2.service has failed.

更多尝试:

(rt5venv) root@devrt5:/tmp/rt-5.0.2# /opt/rt5/sbin/rt-server &
[2] 21336
[1]   Exit 2                  /opt/rt5/sbin/rt-server
(rt5venv) root@devrt5:/tmp/rt-5.0.2# 
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.

当尝试连接数据库时,RT 返回的错误是:

Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)
 at /opt/rt5/sbin/../lib/RT.pm line 222.

我还做了以下事情:

  1. rt5.*授予使用选项rt_user@localhost的所有权限grant
  2. 设置密码以及rt_user数据库的密码rt_siteconfig.pm

我可以使用 MySQLmysql -u root -p并且它运行良好。

如果需要,我很乐意提供有关文件信息的更多详细信息。

相关内容