点击启动后提示mysqlzt...端口:3307...失败已解决悬赏5积分

提问者马冲答案数1 阅读数1976 发表时间2020-03-20 10:22:53

[Fri Mar 20 09:50:15.526658 2020] [ssl:warn] [pid 13904:tid 724] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 09:50:15.914844 2020] [mpm_winnt:notice] [pid 13904:tid 724] AH00455: Apache/2.4.25 (Win64) OpenSSL/1.0.2k configured -- resuming normal operations
[Fri Mar 20 09:50:15.914844 2020] [mpm_winnt:notice] [pid 13904:tid 724] AH00456: Server built: Dec 16 2016 23:05:57
[Fri Mar 20 09:50:15.914844 2020] [core:notice] [pid 13904:tid 724] AH00094: Command line: 'D:\\xampp\\apache\\bin\\httpd.exe -d D:/xampp/apache'
[Fri Mar 20 09:50:15.973688 2020] [mpm_winnt:notice] [pid 13904:tid 724] AH00418: Parent: Created child process 23760
[Fri Mar 20 09:50:16.836251 2020] [ssl:warn] [pid 23760:tid 600] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 09:50:16.862212 2020] [mpm_winnt:notice] [pid 23760:tid 600] AH00354: Child: Starting 150 worker threads.
[Fri Mar 20 09:50:48.183971 2020] [mpm_winnt:notice] [pid 13904:tid 724] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Fri Mar 20 09:50:50.185456 2020] [mpm_winnt:notice] [pid 23760:tid 600] AH00364: Child: All worker threads have exited.
[Fri Mar 20 09:50:50.248870 2020] [mpm_winnt:notice] [pid 13904:tid 724] AH00430: Parent: Child process 23760 exited successfully.
[Fri Mar 20 09:51:05.191831 2020] [ssl:warn] [pid 7148:tid 636] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 09:51:05.216765 2020] [mpm_winnt:notice] [pid 7148:tid 636] AH00455: Apache/2.4.25 (Win64) OpenSSL/1.0.2k configured -- resuming normal operations
[Fri Mar 20 09:51:05.216765 2020] [mpm_winnt:notice] [pid 7148:tid 636] AH00456: Server built: Dec 16 2016 23:05:57
[Fri Mar 20 09:51:05.216765 2020] [core:notice] [pid 7148:tid 636] AH00094: Command line: 'D:\\xampp\\apache\\bin\\httpd.exe -d D:/xampp/apache'
[Fri Mar 20 09:51:05.276764 2020] [mpm_winnt:notice] [pid 7148:tid 636] AH00418: Parent: Created child process 19512
[Fri Mar 20 09:51:06.119993 2020] [ssl:warn] [pid 19512:tid 616] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 09:51:06.145954 2020] [mpm_winnt:notice] [pid 19512:tid 616] AH00354: Child: Starting 150 worker threads.
[Fri Mar 20 09:58:35.023308 2020] [mpm_winnt:notice] [pid 7148:tid 636] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Fri Mar 20 09:58:37.025149 2020] [mpm_winnt:notice] [pid 19512:tid 616] AH00364: Child: All worker threads have exited.
[Fri Mar 20 09:58:37.099452 2020] [mpm_winnt:notice] [pid 7148:tid 636] AH00430: Parent: Child process 19512 exited successfully.
[Fri Mar 20 09:58:44.295216 2020] [ssl:warn] [pid 19708:tid 696] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 09:58:44.322144 2020] [mpm_winnt:notice] [pid 19708:tid 696] AH00455: Apache/2.4.25 (Win64) OpenSSL/1.0.2k configured -- resuming normal operations
[Fri Mar 20 09:58:44.322144 2020] [mpm_winnt:notice] [pid 19708:tid 696] AH00456: Server built: Dec 16 2016 23:05:57
[Fri Mar 20 09:58:44.322144 2020] [core:notice] [pid 19708:tid 696] AH00094: Command line: 'D:\\xampp\\apache\\bin\\httpd.exe -d D:/xampp/apache'
[Fri Mar 20 09:58:44.372010 2020] [mpm_winnt:notice] [pid 19708:tid 696] AH00418: Parent: Created child process 13564
[Fri Mar 20 09:58:45.338325 2020] [ssl:warn] [pid 13564:tid 600] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 09:58:45.363286 2020] [mpm_winnt:notice] [pid 13564:tid 600] AH00354: Child: Starting 150 worker threads.
[Fri Mar 20 10:10:44.780603 2020] [mpm_winnt:notice] [pid 19708:tid 696] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Fri Mar 20 10:10:46.782265 2020] [mpm_winnt:notice] [pid 13564:tid 600] AH00364: Child: All worker threads have exited.
[Fri Mar 20 10:10:46.850781 2020] [mpm_winnt:notice] [pid 19708:tid 696] AH00430: Parent: Child process 13564 exited successfully.
[Fri Mar 20 10:11:16.449988 2020] [ssl:warn] [pid 21828:tid 696] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 10:11:16.474951 2020] [mpm_winnt:notice] [pid 21828:tid 696] AH00455: Apache/2.4.25 (Win64) OpenSSL/1.0.2k configured -- resuming normal operations
[Fri Mar 20 10:11:16.474951 2020] [mpm_winnt:notice] [pid 21828:tid 696] AH00456: Server built: Dec 16 2016 23:05:57
[Fri Mar 20 10:11:16.474951 2020] [core:notice] [pid 21828:tid 696] AH00094: Command line: 'D:\\xampp\\apache\\bin\\httpd.exe -d D:/xampp/apache'
[Fri Mar 20 10:11:16.526929 2020] [mpm_winnt:notice] [pid 21828:tid 696] AH00418: Parent: Created child process 1436
[Fri Mar 20 10:11:17.372580 2020] [ssl:warn] [pid 1436:tid 600] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 10:11:17.397514 2020] [mpm_winnt:notice] [pid 1436:tid 600] AH00354: Child: Starting 150 worker threads.
[Fri Mar 20 10:14:15.739933 2020] [mpm_winnt:notice] [pid 21828:tid 696] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Fri Mar 20 10:14:17.743070 2020] [mpm_winnt:notice] [pid 1436:tid 600] AH00364: Child: All worker threads have exited.
[Fri Mar 20 10:14:17.814870 2020] [mpm_winnt:notice] [pid 21828:tid 696] AH00430: Parent: Child process 1436 exited successfully.
[Fri Mar 20 10:14:24.993971 2020] [ssl:warn] [pid 19780:tid 696] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 10:14:25.018933 2020] [mpm_winnt:notice] [pid 19780:tid 696] AH00455: Apache/2.4.25 (Win64) OpenSSL/1.0.2k configured -- resuming normal operations
[Fri Mar 20 10:14:25.018933 2020] [mpm_winnt:notice] [pid 19780:tid 696] AH00456: Server built: Dec 16 2016 23:05:57
[Fri Mar 20 10:14:25.018933 2020] [core:notice] [pid 19780:tid 696] AH00094: Command line: 'D:\\xampp\\apache\\bin\\httpd.exe -d D:/xampp/apache'
[Fri Mar 20 10:14:25.064782 2020] [mpm_winnt:notice] [pid 19780:tid 696] AH00418: Parent: Created child process 21596
[Fri Mar 20 10:14:25.907985 2020] [ssl:warn] [pid 21596:tid 600] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 10:14:25.932921 2020] [mpm_winnt:notice] [pid 21596:tid 600] AH00354: Child: Starting 150 worker threads.
[Fri Mar 20 10:16:12.517258 2020] [mpm_winnt:notice] [pid 19780:tid 696] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Fri Mar 20 10:16:14.519310 2020] [mpm_winnt:notice] [pid 21596:tid 600] AH00364: Child: All worker threads have exited.
[Fri Mar 20 10:16:14.583139 2020] [mpm_winnt:notice] [pid 19780:tid 696] AH00430: Parent: Child process 21596 exited successfully.
[Fri Mar 20 10:16:21.949847 2020] [ssl:warn] [pid 19844:tid 696] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 10:16:21.982761 2020] [mpm_winnt:notice] [pid 19844:tid 696] AH00455: Apache/2.4.25 (Win64) OpenSSL/1.0.2k configured -- resuming normal operations
[Fri Mar 20 10:16:21.982761 2020] [mpm_winnt:notice] [pid 19844:tid 696] AH00456: Server built: Dec 16 2016 23:05:57
[Fri Mar 20 10:16:21.982761 2020] [core:notice] [pid 19844:tid 696] AH00094: Command line: 'D:\\xampp\\apache\\bin\\httpd.exe -d D:/xampp/apache'
[Fri Mar 20 10:16:22.030883 2020] [mpm_winnt:notice] [pid 19844:tid 696] AH00418: Parent: Created child process 13064
[Fri Mar 20 10:16:22.957406 2020] [ssl:warn] [pid 13064:tid 600] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Mar 20 10:16:22.990348 2020] [mpm_winnt:notice] [pid 13064:tid 600] AH00354: Child: Starting 150 worker threads.

禅道版本：12.1

安装包类型：Windows安装包

操作系统：Windows 8.1

客户端浏览器：IE10

答案列表

石洋洋 2020-03-20 16:07:37

右键以管理员身份运行 xampp/start.exe 点击左上角“服务-配置端口”，把mysql端口改成“3308”，并且把“自动切换端口”前面打上对号，保存后点击 “停止禅道”，然后点击“启动禅道”看一下结果。

3条回复

🥓

马冲 2020/03/20

还是不行，启动聊天服务提示：No backend server available in the configuration file.

🥓

马冲 2020/03/20

查看mysqllog：2020-03-20 20:20:19 5960 [Note] Plugin 'InnoDB' is disabled.
2020-03-20 20:20:19 5960 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\plugin.frm'
2020-03-20 20:20:19 5960 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-03-20 20:20:19 5960 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:20:19 5960 [ERROR] Can't open and lock privilege tables: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:20:19 5960 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-20 20:20:19 5960 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\user.frm'
2020-03-20 20:20:19 5960 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: '.\mysql\user.frm'
2020-03-20 20:20:25 1036 [Note] Plugin 'InnoDB' is disabled.
2020-03-20 20:20:25 1036 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\plugin.frm'
2020-03-20 20:20:25 1036 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-03-20 20:20:25 1036 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:20:25 1036 [ERROR] Can't open and lock privilege tables: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:20:25 1036 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-20 20:20:25 1036 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\user.frm'
2020-03-20 20:20:25 1036 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: '.\mysql\user.frm'
2020-03-20 20:27:43 11376 [Note] Plugin 'InnoDB' is disabled.
2020-03-20 20:27:43 11376 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\plugin.frm'
2020-03-20 20:27:43 11376 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-03-20 20:27:43 11376 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:27:43 11376 [ERROR] Can't open and lock privilege tables: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:27:43 11376 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-20 20:27:43 11376 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\user.frm'
2020-03-20 20:27:43 11376 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: '.\mysql\user.frm'
2020-03-20 20:27:51 15276 [Note] Plugin 'InnoDB' is disabled.
2020-03-20 20:27:51 15276 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\plugin.frm'
2020-03-20 20:27:51 15276 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-03-20 20:27:51 15276 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:27:51 15276 [ERROR] Can't open and lock privilege tables: Incorrect information in file: '.\mysql\servers.frm'
2020-03-20 20:27:51 15276 [Note] Server socket created on IP: '127.0.0.1'.
2020-03-20 20:27:51 15276 [ERROR] mysqld.exe: Incorrect information in file: '.\mysql\user.frm'
2020-03-20 20:27:51 15276 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: '.\mysql\user.frm'

石洋洋 2020/03/23

1、如果是第一次安装，可以右键以管理员身份运行 xampp/start.exe 点击左上角服务-卸载服务然后退出删除，然后重新解压一个xampp启动服务试一下。如果是之前可以正常启动过可以加一下本网页最上方的qq或者电话，邀请入群后一起确认一下mysql数据库中的表是否完整。
2、No backend server available in the configuration file. 这个报错是因为没有配置xxd服务配置文件导致的，可以网页访问禅道后台-客户端下载配置文件然后覆盖 xampp/xxd/config/xxd.conf 然后再启动聊天服务看一下结果。

联系我们