已解决 linux服务器上禅道数据迁移之后,管理员无法登陆




[root@izwz9ingetk3pqqg204c9hz log]# tail -f php.20180521.log.php
 in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=

15:47:39 ERROR: SQLSTATE[HY000]: General error: 1036 Table 'zt_user' is read onlyThe sql is: UPDATE `zt_user` SET  `fails` = '1', `locked` = '0000-00-00 00:00:00' wHeRe account  = 'admin' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1318, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 776 through function sqlError.
 in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=

15:47:53 ERROR: SQLSTATE[HY000]: General error: 1036 Table 'zt_user' is read onlyThe sql is: UPDATE `zt_user` SET  `fails` = '1', `locked` = '0000-00-00 00:00:00' wHeRe account  = 'admin' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1318, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 776 through function sqlError.
 in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=

15:47:53 ERROR: SQLSTATE[HY000]: General error: 1036 Table 'zt_user' is read onlyThe sql is: UPDATE `zt_user` SET  `fails` = '1', `locked` = '0000-00-00 00:00:00' wHeRe account  = 'admin' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1318, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 776 through function sqlError.
 in /opt/zbox/app/zentao/framework/base/router.class.php on line 1932 when visiting user-login-L3plbnRhby8=
^C
[root@izwz9ingetk3pqqg204c9hz log]# tail -f sql.20180521.log.php
  UPDATE `zt_user` SET  `fails` = '1', `locked` = '0000-00-00 00:00:00' WHERE account  = 'admin'

20180521 15:47:53: user-login-L3plbnRhby8=
  SELECT * FROM `zt_config` WHERE owner IN ('system','') ORDER BY `id`
  SELECT * FROM `zt_lang` ORDER BY `lang`,`id`
  SELECT locked FROM `zt_user` WHERE account  = 'admin'
  SELECT * FROM `zt_user` WHERE account  = 'admin' AND  deleted  = '0'
  SELECT fails FROM `zt_user` WHERE account  = 'admin'
  UPDATE `zt_user` SET  `fails` = '1', `locked` = '0000-00-00 00:00:00' WHERE account  = 'admin'


禅道版本 9.0.stable Linux安装包
操作系统 CentOS
客户端浏览器 Firefox

提问者: 墨舞清风 悬赏:5 日期: 2018-05-21 15:53:34 答案:1 点击:2681

获取技术支持

QQ: 电话:
备注
忘了描述具体问提,问题如下:
由于更换的linux服务器,希望把原服务器的禅道迁移到新的服务器上,按照

17.禅道数据迁移之Linux_to_Linux

说明迁移数据之后,在新服务器上admin登陆无反应,分别输入默认密码和原服务器管理员密码都无法登陆。

设置备注
答案列表
2018/05/21
提示是表只有读权限,可以检查下数据库zentao表,使用数据库管理工具可以正常访问吗?如果还是不行,可以联系官网顶部的商务QQ,邀请加入禅道技术交流群,群里进行提问,方便截图。