上周服务器断电，今天重启lampp后Apache、mysql、proftpd正常，但是访问禅道登录页是空白页。已解决悬赏5积分

提问者stallone 答案数2 阅读数23501 发表时间2014-12-01 11:16:44

1.上周服务器断电，今天重启lampp后Apache、mysql、proftpd正常，但是访问禅道登录页是空白页。

2.查看/opt/lampp/htdocs/zentaopms/tmp/log php.20141201.log.php 日志如下：

===========================================================

[Mon Dec 01 10:17:06.005210 2014] [ssl:warn] [pid 2958] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:17:06.012685 2014] [ssl:warn] [pid 2958] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:17:06.012852 2014] [suexec:notice] [pid 2958] AH01232: suEXEC mechanism enabled (wrapper: /opt/lampp/bin/suexec)
[Mon Dec 01 10:17:06.076340 2014] [auth_digest:notice] [pid 2959] AH01757: generating secret for digest authentication ...
[Mon Dec 01 10:17:07.001678 2014] [ssl:warn] [pid 2959] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:17:07.001725 2014] [ssl:warn] [pid 2959] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:17:07.001901 2014] [lbmethod_heartbeat:notice] [pid 2959] AH02282: No slotmem from mod_heartmonitor
[Mon Dec 01 10:17:07.165933 2014] [mpm_prefork:notice] [pid 2959] AH00163: Apache/2.4.10 (Unix) OpenSSL/1.0.1j PHP/5.6.3 mod_perl/2.0.8-dev Perl/v5.16.3 configured -- resuming normal operations
[Mon Dec 01 10:17:07.165992 2014] [core:notice] [pid 2959] AH00094: Command line: '/opt/lampp/bin/httpd -E /opt/lampp/logs/error_log -D SSL -D PHP'
cat: /opt/lampp/var/mysql/localhost.localdomain.pid: 权限不够
cat: /opt/lampp/var/mysql/localhost.localdomain.pid: 权限不够
[Mon Dec 01 10:20:40.868200 2014] [mpm_prefork:notice] [pid 2959] AH00169: caught SIGTERM, shutting down
[Mon Dec 01 10:20:44.001856 2014] [ssl:warn] [pid 3477] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:20:44.001988 2014] [ssl:warn] [pid 3477] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:20:44.002270 2014] [suexec:notice] [pid 3477] AH01232: suEXEC mechanism enabled (wrapper: /opt/lampp/bin/suexec)
[Mon Dec 01 10:20:44.061945 2014] [auth_digest:notice] [pid 3478] AH01757: generating secret for digest authentication ...
[Mon Dec 01 10:20:45.001759 2014] [ssl:warn] [pid 3478] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:20:45.001806 2014] [ssl:warn] [pid 3478] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:20:45.001978 2014] [lbmethod_heartbeat:notice] [pid 3478] AH02282: No slotmem from mod_heartmonitor
[Mon Dec 01 10:20:45.014979 2014] [mpm_prefork:notice] [pid 3478] AH00163: Apache/2.4.10 (Unix) OpenSSL/1.0.1j PHP/5.6.3 mod_perl/2.0.8-dev Perl/v5.16.3 configured -- resuming normal operations
[Mon Dec 01 10:20:45.015011 2014] [core:notice] [pid 3478] AH00094: Command line: '/opt/lampp/bin/httpd -E /opt/lampp/logs/error_log -D SSL -D PHP'
[Mon Dec 01 10:23:09.499285 2014] [mpm_prefork:notice] [pid 3478] AH00169: caught SIGTERM, shutting down
[Mon Dec 01 10:23:12.001158 2014] [ssl:warn] [pid 3996] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:23:12.001288 2014] [ssl:warn] [pid 3996] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:23:12.001565 2014] [suexec:notice] [pid 3996] AH01232: suEXEC mechanism enabled (wrapper: /opt/lampp/bin/suexec)
[Mon Dec 01 10:23:12.060926 2014] [auth_digest:notice] [pid 3997] AH01757: generating secret for digest authentication ...
[Mon Dec 01 10:23:13.001771 2014] [ssl:warn] [pid 3997] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:23:13.001818 2014] [ssl:warn] [pid 3997] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:23:13.001993 2014] [lbmethod_heartbeat:notice] [pid 3997] AH02282: No slotmem from mod_heartmonitor
[Mon Dec 01 10:23:13.015482 2014] [mpm_prefork:notice] [pid 3997] AH00163: Apache/2.4.10 (Unix) OpenSSL/1.0.1j PHP/5.6.3 mod_perl/2.0.8-dev Perl/v5.16.3 configured -- resuming normal operations
[Mon Dec 01 10:23:13.015518 2014] [core:notice] [pid 3997] AH00094: Command line: '/opt/lampp/bin/httpd -E /opt/lampp/logs/error_log -D SSL -D PHP'
[Mon Dec 01 10:24:31.447328 2014] [mpm_prefork:notice] [pid 3997] AH00169: caught SIGTERM, shutting down
[Mon Dec 01 10:24:34.001284 2014] [ssl:warn] [pid 4476] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:24:34.001413 2014] [ssl:warn] [pid 4476] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:24:34.001689 2014] [suexec:notice] [pid 4476] AH01232: suEXEC mechanism enabled (wrapper: /opt/lampp/bin/suexec)
[Mon Dec 01 10:24:34.060759 2014] [auth_digest:notice] [pid 4477] AH01757: generating secret for digest authentication ...
[Mon Dec 01 10:24:35.002196 2014] [ssl:warn] [pid 4477] AH01906: www.example.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon Dec 01 10:24:35.002273 2014] [ssl:warn] [pid 4477] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Dec 01 10:24:35.002573 2014] [lbmethod_heartbeat:notice] [pid 4477] AH02282: No slotmem from mod_heartmonitor
[Mon Dec 01 10:24:35.016790 2014] [mpm_prefork:notice] [pid 4477] AH00163: Apache/2.4.10 (Unix) OpenSSL/1.0.1j PHP/5.6.3 mod_perl/2.0.8-dev Perl/v5.16.3 configured -- resuming normal operations
[Mon Dec 01 10:24:35.016824 2014] [core:notice] [pid 4477] AH00094: Command line: '/opt/lampp/bin/httpd -E /opt/lampp/logs/error_log -D SSL -D PHP'

===========================================================

3.又去查看 /opt/lampp/logs error_log 日志如下：

===========================================================

die();
?>

03:18:00 ERROR: SQLSTATE[HY000] [2002] 拒绝连接 in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1545, last called by /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1507 through function connectByPDO.
in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1589 when visiting

03:18:04 ERROR: SQLSTATE[HY000] [2002] 拒绝连接 in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1545, last called by /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1507 through function connectByPDO.
in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1589 when visiting

03:18:05 ERROR: SQLSTATE[HY000] [2002] 拒绝连接 in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1545, last called by /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1507 through function connectByPDO.
in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1589 when visiting

03:18:08 ERROR: SQLSTATE[HY000] [2002] 拒绝连接 in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1545, last called by /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1507 through function connectByPDO.
in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1589 when visiting

03:18:10 ERROR: SQLSTATE[HY000] [2002] 拒绝连接 in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1545, last called by /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1507 through function connectByPDO.
in /opt/lampp/htdocs/zentaopms/framework/router.class.php on line 1589 when visiting

===========================================================

禅道版本：6.3.stable

安装包类型：Linux安装包

操作系统：CentOS

客户端浏览器：IE8

答案列表

🍟

王春生 2014-12-01 11:18:06

03:18:00 ERROR: SQLSTATE[HY000] [2002] 拒绝连接

检查mysql的服务是否正常。我怀疑机器上有其他的mysql进程在运行。

7条回复

😸

stallone 2014/12/01

服务器只装了一个mysql，lampp自带的mysql。

😸

stallone 2014/12/01

而且访问phpmyadmin也正常

😸

stallone 2014/12/01

[root@localhost lampp]# ps -ef|grep mysqld
root 6196 1 0 14:04 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 6345 6196 1 14:05 pts/0 00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 6358 2910 0 14:05 pts/0 00:00:00 grep mysqld

😸

stallone 2014/12/01

上面的是我查看mysql进场打印出来的

🍟

王春生 2014/12/01

/opt/lampp这个是一个一键安装包，它链接的是/opt/lampp下面的mysql。而你现在机器上运行的是/usr/bin下面的。

😸

stallone 2014/12/01

@wwccss 刚刚把/usr/bin下的mysql进程kill掉，然后用./lampp startmysql启动/opt/lampp下的mysql。然后访问禅道登录页，还是空白页面啊

😸

stallone 2014/12/01

[root@localhost lampp]# ps -ef|grep mysqld
root 6971 1 0 14:52 pts/0 00:00:00 /bin/sh /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-file=/opt/lampp/var/mysql/localhost.localdomain.pid
mysql 7345 6971 0 14:52 pts/0 00:00:00 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --plugin-dir=/opt/lampp/lib/mysql/plugin/ --user=mysql --log-error=/opt/lampp/var/mysql/localhost.localdomain.err --pid-file=/opt/lampp/var/mysql/localhost.localdomain.pid --socket=/opt/lampp/var/mysql/mysql.sock --port=3306
root 7381 2910 0 14:54 pts/0 00:00:00 grep mysqld

🎂

张文丰 2014-12-05 11:58:57

学习了。

联系我们