启动问题- Liferay 7.1.2 GA3 -javax.servlet.ServletException

Question

我在Windows环境下用mysql5.7db启动Liferay7.1.2 GA3 (CE)时遇到了问题。它可以在高超音速模式下正确重启，但与mysql连接时会抛出这些错误。

我试着下载新的tomcat，然后下载并重新创建db..etc。但这不应该是一个问题。因为我尝试手动创建表，所以从Liferay下载Portal DB并执行。还是同样的问题。

    09 08:50:29.894 WARN  [http-nio-8080-exec-1][PortalImpl:6899] javax.servlet.ServletException: A servlet matching the filter (servlet.init.private=false)(servlet.type=friendly-url) is unavailable

javax.servlet.ServletException: A servlet matching the filter (servlet.init.private=false)(servlet.type=friendly-url) is unavailable
    at com.liferay.portal.servlet.ServletAdapter.service(ServletAdapter.java:91)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:119)
    at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:144)

2019-04-09 08:50:30.120 ERROR [http-nio-8080-exec-1][error_jsp:641] User ID null
2019-04-09 08:50:30.121 ERROR [http-nio-8080-exec-1][error_jsp:642] Current URL /
2019-04-09 08:50:30.122 ERROR [http-nio-8080-exec-1][error_jsp:643] Referer null
2019-04-09 08:50:30.123 ERROR [http-nio-8080-exec-1][error_jsp:644] Remote address 127.0.0.1
2019-04-09 08:50:30.123 ERROR [http-nio-8080-exec-1][error_jsp:646] com.liferay.portal.kernel.events.ActionException: java.lang.NullPointerException
com.liferay.portal.kernel.events.ActionException: java.lang.NullPointerException
    at com.liferay.portal.events.ServicePreAction.run(ServicePreAction.java:1083)
    at com.liferay.portal.kernel.events.Action.processLifecycleEvent(Action.java:34)
    at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:86)
    at com.liferay.portal.events.EventsProcessorUtil.process(EventsProcessorUtil.java:60)
    at com.liferay.portal.servlet.MainServlet.processServicePre(MainServlet.java:1169)
    at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:539)

Caused by: java.lang.NullPointerException
    at com.liferay.staging.security.internal.permission.StagingPermissionChecker.hasPermission(StagingPermissionChecker.java:134)
    at com.liferay.portal.service.permission.GroupPermissionImpl._contains(GroupPermissionImpl.java:226)
    at com.liferay.portal.service.permission.GroupPermissionImpl.contains(GroupPermissionImpl.java:103)
    at com.liferay.portal.kernel.service.permission.GroupPermissionUtil.contains(GroupPermissionUtil.java:51)
    at com.liferay.portal.service.permission.LayoutPermissionImpl.containsWithoutViewableGroup(LayoutPermissionImpl.java:277)
    at com.liferay.portal.service.permission.LayoutPermissionImpl.containsWithoutViewableGroup(LayoutPermissionImpl.java:319)
    at com.liferay.portal.service.permission.LayoutPermissionImpl.containsWithViewableGroup(LayoutPermissionImpl.java:333)
    at com.liferay.portal.service.permission.LayoutPermissionImpl._contains(LayoutPermissionImpl.java:595)
During the table creation, i got these warnings :

// WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\assetcategory.frm' (Errcode: 13 - Permission denied): create index IX_2008FACB on AssetCategory (groupId, vocabularyId);_ [Sanitized]


2019-04-15 08:34:20.006 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\dlfileentry.frm' (Errcode: 13 - Permission denied): create index IX_BAF654E5 on DLFileEntry (groupId, fileEntryTypeId);_ [Sanitized]


2019-04-15 08:34:20.100 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\dlfileentry.frm' (Errcode: 13 - Permission denied): create index IX_D20C434D on DLFileEntry (groupId, userId, folderId);_ [Sanitized]


2019-04-15 08:34:21.017 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\expandovalue.frm' (Errcode: 13 - Permission denied): create index IX_B71E92D5 on ExpandoValue (tableId, rowId_);_ [Sanitized]


2019-04-15 08:34:21.252 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\group_.frm' (Errcode: 13 - Permission denied): create unique index IX_AACD15F0 on Group_ (companyId, liveGroupId, groupKey);_ [Sanitized]


2019-04-15 08:34:21.321 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\group_.frm' (Errcode: 13 - Permission denied): create index IX_7B590A7A on Group_ (type_, active_);_ [Sanitized]


2019-04-15 08:34:22.087 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\layoutrevision.frm' (Errcode: 13 - Permission denied): create index IX_421223B1 on LayoutRevision (status);_ [Sanitized]


2019-04-15 08:34:22.853 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\portletpreferences.frm' (Errcode: 13 - Permission denied): create index IX_A3B2A80C on PortletPreferences (ownerType, portletId);_ [Sanitized]


2019-04-15 08:34:23.519 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\resourcepermission.frm' (Errcode: 13 - Permission denied): create index IX_A37A0588 on ResourcePermission (roleId);_ [Sanitized]


2019-04-15 08:34:23.675 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\role_.frm' (Errcode: 13 - Permission denied): create index IX_5EB4E2FB on Role_ (subtype);_ [Sanitized]


2019-04-15 08:34:23.893 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\socialactivity.frm' (Errcode: 13 - Permission denied): create index IX_1F00C374 on SocialActivity (mirrorActivityId, classNameId, classPK);_ [Sanitized]


2019-04-15 08:34:24.419 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\socialrequest.frm' (Errcode: 13 - Permission denied): create index IX_CC86A444 on SocialRequest (userId, classNameId, classPK, type_, status);_ [Sanitized]




2019-04-15 08:34:25.013 WARN  [main][BaseDB:487] Error on rename of '.\lportal\#sql-116c_4.frm' to '.\lportal\usernotificationevent.frm' (Errcode: 13 - Permission denied): create index IX_C4EFBD45 on UserNotificationEvent (userId, deliveryType, actionRequired, archived);_ [Sanitized]

我认为DB issue.So，完全从windows系统中删除mysql服务器并重新安装。和我想的捆绑包问题一样。因此，下载了最新的7.1捆绑包(也尝试了7.2 )。同样的问题。为了确保这不是mysql权限的任何问题，我尝试手动创建、更改表和index....etc...，没有权限问题。

我用同样的DB下载了Liferay6.2，它工作得很好，问题是7.X版本和5.7。

是否有与windows环境或Liferay 7.x的病毒软件相关的问题？救生道论坛相关帖子：https://community.liferay.com/forums/-/message_boards/message/113084018

Answer 1

如果服务器具有修改数据库索引的权限，则将以下行添加到"portal-ext.properties“文件中：

database.indexes.update.on.startup=true

Answer 2

我在安装Liferay 7.2时遇到了同样的错误，在执行以下步骤后，它工作得很好。

使用默认DB (Hypersonic)

• Changed DB details to mysql.

1. Configured jdk to
   1. 启动服务器。

已启动服务器，运行正常。

当我在portal-ext.properties中直接配置DB详细信息时，它不工作。