一、开源版本点击登录报错信息如下:
15:44:33 ERROR: SQLSTATE[HY000] [2002] Connection refused in framework/base/router.class.php on line 2173, last called by framework/base/router.class.php on line 2124 through function connectByPDO.
in framework/base/router.class.php on line 2224 when visiting
二、linux后台提示报错
三、mysql_error.log 报错信息如下
2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-locks' is error-prone and can break in the future. Please use the full name 'innodb-locks-unsafe-for-binlog' instead.
2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-cmp' is error-prone and can break in the future. Please use the full name 'innodb-cmp-per-index-enabled' instead.
2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-cmp-per-index' is error-prone and can break in the future. Please use the full name 'innodb-cmp-per-index-enabled' instead.
2020-03-25 18:19:12 0 [Note] Plugin 'InnoDB' is disabled.
2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-sys-tables' is error-prone and can break in the future. Please use the full name 'innodb-sys-tablestats' instead.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-buffer-page' is error-prone and can break in the future. Please use the full name 'innodb-buffer-page-lru' instead.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2020-03-25 18:19:12 0 [Note] Using unique option prefix 'innodb-sys-foreign' is error-prone and can break in the future. Please use the full name 'innodb-sys-foreign-cols' instead.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_TRX' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_METRICS' is disabled.
2020-03-25 18:19:12 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2020-03-25 18:19:12 0 [Warning] /opt/zbox/run/mysql/mysqld: unknown variable 'loose-innodb-ft-inserted=0'
2020-03-25 18:19:12 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-03-25 18:19:12 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
2020-03-25 18:19:12 0 [Note] Reading of all Master_info entries succeded
2020-03-25 18:19:12 0 [Note] Added new Master_info '' to hash table
2020-03-25 18:19:12 0 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '10.3.13-MariaDB' socket: '/opt/zbox/tmp/mysql/mysql.sock' port: 3307 Source distribution
2020-03-25 18:23:19 16 [ERROR] mysqld: Table './zentao/zt_im_message' is marked as crashed and should be repaired
2020-03-25 18:23:19 16 [Warning] Checking table: './zentao/zt_im_message'
2020-03-25 18:23:19 16 [ERROR] mysqld: Table './zentao/zt_im_messagestatus' is marked as crashed and should be repaired
2020-03-25 18:23:19 16 [Warning] Checking table: './zentao/zt_im_messagestatus'
2020-03-25 18:26:50 21 [ERROR] mysqld: Table './zentao/zt_doccontent' is marked as crashed and should be repaired
2020-03-25 18:26:50 21 [Warning] Checking table: './zentao/zt_doccontent'
获取技术支持
目前点击登录按钮报错是由于mysql服务没有正常启动。目前报错日志中的最新日期是3月25日,请确认一下服务器的时间是否正确,以及是否有今天4月7日的报错日志。
目前3月25日的报错日志显示,数据库中的zt_im_message,zt_im_messagestatus,zt_doccontent这3张表被损坏,需要修复一下。可以使用浏览器访问这个网址:禅道服务器IP:apache端口/zentao/checktable.php,按页面提示修复数据库表试一下。
如果服务器有日期更新的报错日志,或者访问网页修复表后仍然无法成功启动数据库,可以添加页面上方QQ,邀请进群,方便进一步排查问题。