X5登录页面，输入用户名密码，提示登录用户不在注册用户...

凯歌

X5登录页面，输入用户名密码，
当输入正确的密码，页面提示“ 登录用户不在注册用户列表中!”
输入错误的密码：页面提示：“登录名或密码错误”
这个用户以前一直在用的，昨天license到期了，重申申请了license，再一顿折腾启动了x5服务后，用户就报错了。

凯歌

2021-12-21 17:24:20
exec KSQL: select r,par,p.* from SA_OPRole par optional join SA_OPPermission p on p.sPermissionRoleID=par and par.sValidState = 1 and p.sValidState=1 join SA_OPRole r on par=r.sParentRole AND
r IN ('00CE50B7490B4AFE83D50E3BF503B280')  --> sql:SELECT  r.sID, par.sID, p.sID AS p, p.sPermissionRoleID AS sPermissionRoleID, p.SPROCESS AS sProcess, p.SACTIVITYFNAME AS sActivityFName, p.SACTIVITY AS sActivity, p.SACTIONSNAMES A
S sActionsNames, p.SACTIONS AS sActions, p.SSEMANTICDP AS sSemanticDP, p.SPERMISSIONKIND AS sPermissionKind, p.SDESCRIPTION AS sDescription, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.VERSION AS version FROM SA_OPRole par LEFT JOIN SA_OPPermission p ON  (p.sPermissionRoleID = par.sID) AND (par.SVALIDSTATE = ?) AND (p.SVALIDSTATE = ?)  JOIN (SA_OPRole r LEFT JOIN SA_OPParentRole SA_OPParentRole__1 ON r.sID = SA_OPParentRole__1.sRoleID  ) ON  (par.sID = SA_OPParentRole__1.sParentRoleID) AND ( r.sID IN (?) )  --> binds:[1, 1, 00CE50B7490B4AFE83D50E3BF503B280]
2021-12-21 17:24:20
exec KSQL: select r,par,p.* from SA_OPRole par optional join SA_OPPermission p on p.sPermissionRoleID=par and par.sValidState = 1 and p.sValidState=1 join SA_OPRole r on par=r.sParentRole AND
r IN ('00CE50B7490B4AFE83D50E3BF503B280')  --> sql:SELECT  r.sID, par.sID, p.sID AS p, p.sPermissionRoleID AS sPermissionRoleID, p.SPROCESS AS sProcess, p.SACTIVITYFNAME AS sActivityFName, p.SACTIVITY AS sActivity, p.SACTIONSNAMES A
S sActionsNames, p.SACTIONS AS sActions, p.SSEMANTICDP AS sSemanticDP, p.SPERMISSIONKIND AS sPermissionKind, p.SDESCRIPTION AS sDescription, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.VERSION AS version FROM SA_OPRole par LEFT JOIN SA_OPPermission p ON  (p.sPermissionRoleID = par.sID) AND (par.SVALIDSTATE = ?) AND (p.SVALIDSTATE = ?)  JOIN (SA_OPRole r LEFT JOIN SA_OPParentRole SA_OPParentRole__1 ON r.sID = SA_OPParentRole__1.sRoleID  ) ON  (par.sID = SA_OPParentRole__1.sParentRoleID) AND ( r.sID IN (?) )  --> binds:[1, 1, 00CE50B7490B4AFE83D50E3BF503B280]
2021-12-21 17:24:20 sql 执行时间：7ms
2021-12-21 17:24:20 sql 执行时间：7ms
2021-12-21 17:24:20 KSQL 执行时间：11ms
2021-12-21 17:24:20 KSQL 执行时间：11ms
2021-12-21 17:24:20  exec KSQL: select m.*,mt.sCode from SA_OPManagement m optional join SA_OPManageType mt on m.sManageTypeID=mt where '/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm'
like concat(m.sOrgFID, '%') --> sql:SELECT  m.sID AS m, m.SORGID AS sOrgID, m.SORGFID AS sOrgFID, m.SORGNAME AS sOrgName, m.SORGFNAME AS sOrgFName, m.SMANAGEORGID AS sManageOrgID, m.SMANAGEORGNAME AS sManageOrgName, m.
SMANAGEORGFID AS sManageOrgFID, m.SMANAGEORGFNAME AS sManageOrgFName, m.SMANAGETYPEID AS sManageTypeID, m.SCREATORFID AS sCreatorFID, m.SCREATORFNAME AS sCreatorFName, m.SCREATETIME AS sCreateTime, m.VERSION AS version, mt.SCODE AS sCode FROM SA_OPManagement m LEFT JOIN SA_OPManageType mt ON m.SMANAGETYPEID = mt.sID  WHERE ? LIKE m.SORGFID + ? --> binds:[/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm, %]
--> dataModel|M|/system/data
--> fnModelnull
2021-12-21 17:24:20  exec KSQL: select m.*,mt.sCode from SA_OPManagement m optional join SA_OPManageType mt on m.sManageTypeID=mt where '/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm'
like concat(m.sOrgFID, '%') --> sql:SELECT  m.sID AS m, m.SORGID AS sOrgID, m.SORGFID AS sOrgFID, m.SORGNAME AS sOrgName, m.SORGFNAME AS sOrgFName, m.SMANAGEORGID AS sManageOrgID, m.SMANAGEORGNAME AS sManageOrgName, m.
SMANAGEORGFID AS sManageOrgFID, m.SMANAGEORGFNAME AS sManageOrgFName, m.SMANAGETYPEID AS sManageTypeID, m.SCREATORFID AS sCreatorFID, m.SCREATORFNAME AS sCreatorFName, m.SCREATETIME AS sCreateTime, m.VERSION AS version, mt.SCODE AS sCode FROM SA_OPManagement m LEFT JOIN SA_OPManageType mt ON m.SMANAGETYPEID = mt.sID  WHERE ? LIKE m.SORGFID + ? --> binds:[/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm, %]
--> dataModel|M|/system/data
--> fnModelnull
2021-12-21 17:24:20
exec KSQL: select m.*,mt.sCode from SA_OPManagement m optional join SA_OPManageType mt on m.sManageTypeID=mt where '/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm' like concat(m.sOrgFI
D, '%')  --> sql:SELECT  m.sID AS m, m.SORGID AS sOrgID, m.SORGFID AS sOrgFID, m.SORGNAME AS sOrgName, m.SORGFNAME AS sOrgFName, m.SMANAGEORGID AS sManageOrgID, m.SMANAGEORGNAME AS sManageOrgName, m
.SMANAGEORGFID AS sManageOrgFID, m.SMANAGEORGFNAME AS sManageOrgFName, m.SMANAGETYPEID AS sManageTypeID, m.SCREATORFID AS sCreatorFID, m.SCREATORFNAME AS sCreatorFName, m.SCREATETIME AS sCreateTime, m.VERSION AS version, mt.SCODE AS sCode FROM SA_OPManagement m LEFT JOIN SA_OPManageType mt ON m.SMANAGETYPEID = mt.sID  WHERE ? LIKE m.SORGFID + ? --> binds:[/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm, %]
2021-12-21 17:24:20
exec KSQL: select m.*,mt.sCode from SA_OPManagement m optional join SA_OPManageType mt on m.sManageTypeID=mt where '/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm' like concat(m.sOrgFI
D, '%')  --> sql:SELECT  m.sID AS m, m.SORGID AS sOrgID, m.SORGFID AS sOrgFID, m.SORGNAME AS sOrgName, m.SORGFNAME AS sOrgFName, m.SMANAGEORGID AS sManageOrgID, m.SMANAGEORGNAME AS sManageOrgName, m
.SMANAGEORGFID AS sManageOrgFID, m.SMANAGEORGFNAME AS sManageOrgFName, m.SMANAGETYPEID AS sManageTypeID, m.SCREATORFID AS sCreatorFID, m.SCREATORFNAME AS sCreatorFName, m.SCREATETIME AS sCreateTime, m.VERSION AS version, mt.SCODE AS sCode FROM SA_OPManagement m LEFT JOIN SA_OPManageType mt ON m.SMANAGETYPEID = mt.sID  WHERE ? LIKE m.SORGFID + ? --> binds:[/ORG01.ogn/E5BA649CE13A4446B69CC58DF5EFBD60@ORG01.psm, %]
2021-12-21 17:24:20 sql 执行时间：1ms
2021-12-21 17:24:20 sql 执行时间：1ms
2021-12-21 17:24:20 KSQL 执行时间：5ms
2021-12-21 17:24:20 KSQL 执行时间：5ms
2021-12-21 17:24:20 JUSTEP153011, 登录用户不在注册用户列表中!

凯歌

2021-12-21 17:24:20 action:<?xml version="1.0" encoding="UTF-8"?>
<action xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:justep="http://www.justep.com/x5#" xmlnsxf="http://www.orbeon.com/oxf/processors" xmlns:p="http://www.orbeon.com/oxf/pi
peline" xmlns:xslt="http://www.orbeon.com/oxf/processors" xmlns:xbiz="http://www.justep.com/xbiz#" name="loginAction" process="/SA/OPM/system/systemProcess" activity="mainActivity"><parameters>
<parameter name="name"><simple type="http://www.w3.org/2001/XMLSchema#string">110</simple></parameter>
<parameter name="loginDate"><simple type="http://www.w3.org/2001/XMLSchema#date">2021-12-21</simple></parameter>
<parameter name="options"><xbiz:map><item key="DeviceType"><simple type="http://www.w3.org/2001/XMLSchema#string">计算机</simple></item><item key="OperatingSystem"><simple type="http://www.w3
.org/2001/XMLSchema#string">WINDOWS_7</simple></item></xbiz:map></parameter><parameter name="pwd"><simple type="http://www.w3.org/2001/XMLSchema#string">E10ADC3949BA59ABBE56E057F20F883E</simple></parameter>
<parameter name="lang"><simple type="http://www.w3.org/2001/XMLSchema#string">zh_CN</simple></parameter>
<parameter name="ip"><simple type="http://www.w3.org/2001/XMLSchema#string">10.253.42.222</simple></parameter>
</parameters>
</action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: 编码: JUSTEP153011; 提示: 登录用户不在注册用户列表中!
        at com.justep.x.bs.utils.LoaderUtils.a(Unknown Source)
        at com.justep.x.bs.utils.LoaderUtils.regist(Unknown Source)
        at com.justep.system.opm.OrgUtils.login(Native Method)
        at com.justep.system.opm.OrgUtils.login1(Unknown Source)
        at OPMProcedure.login(OPMProcedure.java:111)
        at OPMProcedure.login(OPMProcedure.java:96)
        ... 26 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        ... 31 more
Caused by: com.justep.exception.LicenseException: 编码: JUSTEP153011; 提示: 登录用户不在注册用户列表中!
        at com.justep.exception.LicenseException.create(Unknown Source)
        at com.justep.util.Utils.throwSystemException(Unknown Source)
        at com.justep.utils.Utils.destroy(Native Method)
        at com.justep.utils.Utils.regist(Unknown Source)
        ... 35 more
[root@APP0ATCprc01 conf]#

凯歌

服务器关于x5的任何配置都没有修改过，只是输入了新的license就变这样了
另外 请教，如何正确的启动license_server?

jishuang

http://bbs.wex5.com/forum.php?mod=viewthread&tid=36070

tomcat的conf/context.xml中system的数据源必须和License Server中sys数据源一致

license-server中的数据源名字必须是sys

凯歌

tomcat数据源是在server.xml里面吧？

凯歌

非常感谢，因为我们库名变了，所以刚才修改了license_server后就可以登录了。再次感谢。请结帖