配置自定义字典为jdbc方式，启动elasticsearch后报错

[liangxuegang01]

在插件目录下添加了mysql-connector-java-8.0.23.jar，打开了plugin-security.policy的权限，重新启动elasticsearch后报错如下：

Likely root cause: java.security.AccessControlException: access denied ("java.security.SecurityPermission" "putProviderProperty.MySQLScramShaSasl") at java.base/java.security.AccessControlContext.checkPermission(AccessControlContext.java:472) at java.base/java.security.AccessController.checkPermission(AccessController.java:1036) at java.base/java.lang.SecurityManager.checkPermission(SecurityManager.java:408) at java.base/java.lang.SecurityManager.checkSecurityAccess(SecurityManager.java:1521) at java.base/java.security.Provider.check(Provider.java:852) at java.base/java.security.Provider.putService(Provider.java:1363) at com.mysql.cj.sasl.ScramShaSaslProvider.lambda$new$0(ScramShaSaslProvider.java:78) at java.base/java.security.AccessController.doPrivileged(AccessController.java:312) at com.mysql.cj.sasl.ScramShaSaslProvider.(ScramShaSaslProvider.java:77) at com.mysql.cj.protocol.a.authentication.AuthenticationLdapSaslClientPlugin.(AuthenticationLdapSaslClientPlugin.java:73) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.loadAuthenticationPlugins(NativeAuthenticationProvider.java:246) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:387) at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:174) at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1350) at com.mysql.cj.NativeSession.connect(NativeSession.java:157) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:453) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) at org.ansj.dic.impl.Jdbc2Stream.toStream(Jdbc2Stream.java:64) at org.ansj.dic.PathToStream.stream(PathToStream.java:24) at org.ansj.library.DicLibrary.init(DicLibrary.java:198) at org.ansj.library.DicLibrary.get(DicLibrary.java:142) at org.ansj.library.DicLibrary.get(DicLibrary.java:135) at org.ansj.elasticsearch.index.config.AnsjElasticConfigurator.lambda$initDic$2(AnsjElasticConfigurator.java:135) at java.base/java.security.AccessController.doPrivileged(AccessController.java:312) at org.ansj.elasticsearch.index.config.AnsjElasticConfigurator.initDic(AnsjElasticConfigurator.java:134) <<>>

请帮忙看看如何解决，谢谢

[shi-yuan]

看错误提示，是需要在plugin-security.policy授权 permission java.security.SecurityPermission "putProviderProperty.MySQLScramShaSasl"

[liangxuegang01]

配置成功，非常感谢

[liangxuegang01]

现在发现一个问题 调用/_ansj/flush/dic?key=dic_d3方法后，报错 Init dic library error :org.ansj.exception.LibraryException: err to load by jdbc 请帮忙看看什么原因 mysql驱动已经添加了

[liangxuegang01]

已经解决了，权限少了分号，谢谢

[liangxuegang01]

已经解决了，权限少了分号，谢谢