Hello everyone from elastic
I have difficulties in java security to connect to the MSSQLServer database
I have already edited the plugin-security.policy [1] and performed the installation [2], but the error [3] occurs when uploading elasticsearch.
I tested the java code a [4] and java code b [5] but the same error occurs [3].
Best regards,
Alder Pinheiro Ramos
- File plugin-security.policy
grant {
permission java.security.AllPermission;
};
- Instalation
PS C:\Alder\ELK\elasticsearch-7.8.1\bin> .\elasticsearch-plugin.bat install file:///C:/Alder/ELK/plugin_elastic/ner-amazoninf-plugin-0.0.2-SNAPSHOT.zip
-> Installing file:///C:/Alder/ELK/plugin_elastic/ner-amazoninf-plugin-0.0.2-SNAPSHOT.zip
-> Downloading file:///C:/Alder/ELK/plugin_elastic/ner-amazoninf-plugin-0.0.2-SNAPSHOT.zip
[=================================================] 100%
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@ WARNING: plugin requires additional permissions @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
* java.security.AllPermission <all permissions> <all actions>
See http://docs.oracle.com/javase/8/docs/technotes/guides/security/permissions.html
for descriptions of what these permissions allow and the associated risks.
Continue with installation? [y/N]y
-> Installed ner-amazoninf-plugin
- Error log
[2021-04-01T09:08:50,303][ERROR][b.a.p.n.NerAmazoninfService] [node1] Erro ao obter conexao
java.security.AccessControlException: access denied ("java.net.SocketPermission" "192.168.1.15:1433" "connect,resolve")
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:472) ~[?:?]
at java.security.AccessController.checkPermission(AccessController.java:1036) ~[?:?]
at java.lang.SecurityManager.checkPermission(SecurityManager.java:408) ~[?:?]
at java.lang.SecurityManager.checkConnect(SecurityManager.java:910) ~[?:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnectionSecurityManager.checkConnect(SQLServerConnection.java:6398) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.ServerPortPlaceHolder.doSecurityCheck(FailOverInfo.java:152) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.ServerPortPlaceHolder.<init>(FailOverInfo.java:135) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.primaryPermissionCheck(SQLServerConnection.java:2410) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2126) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1993) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1164) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:760) ~[mssql-jdbc-7.4.1.jre8.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]
at java.sql.DriverManager.getConnection(DriverManager.java:228) ~[java.sql:?]
at br.amazoninf.plugin.nlp.ConnectionFactory.getConnection(ConnectionFactory.java:46) [ner-amazoninf-plugin-0.0.2-SNAPSHOT.jar:0.0.2-SNAPSHOT]
at br.amazoninf.plugin.nlp.ModelDao.getResumo(ModelDao.java:52) [ner-amazoninf-plugin-0.0.2-SNAPSHOT.jar:0.0.2-SNAPSHOT]
at br.amazoninf.plugin.nlp.NerAmazoninfService.getListNF(NerAmazoninfService.java:132) [ner-amazoninf-plugin-0.0.2-SNAPSHOT.jar:0.0.2-SNAPSHOT]
at br.amazoninf.plugin.nlp.NerAmazoninfService.<init>(NerAmazoninfService.java:74) [ner-amazoninf-plugin-0.0.2-SNAPSHOT.jar:0.0.2-SNAPSHOT]
at br.amazoninf.plugin.nlp.NerAmazoninfPlugin.getProcessors(NerAmazoninfPlugin.java:16) [ner-amazoninf-plugin-0.0.2-SNAPSHOT.jar:0.0.2-SNAPSHOT]
at org.elasticsearch.ingest.IngestService.processorFactories(IngestService.java:117) [elasticsearch-7.8.1.jar:7.8.1]
at org.elasticsearch.ingest.IngestService.<init>(IngestService.java:99) [elasticsearch-7.8.1.jar:7.8.1]
- Java code a
SecurityManager sm = System.getSecurityManager();
if (sm != null) {
// unprivileged code such as scripts do not have SpecialPermission
sm.checkPermission(new SpecialPermission());
}
AccessController.doPrivileged(new PrivilegedAction<Connection>() {
@Override
public Connection run() {
try {
DriverManager.registerDriver(new SQLServerDriver());
conn = DriverManager.getConnection("jdbc:sqlserver://192.168.1.15;databaseName=Aizon2", "sa",
"@aizon@1234?");
} catch (Exception e) {
logger.error("Erro ao obter conexao", e);
}
return conn;
}
});
- Java code b
try {
DriverManager.registerDriver(new SQLServerDriver());
conn = DriverManager.getConnection("jdbc:sqlserver://192.168.1.15;databaseName=Aizon2", "sa",
"@aizon@1234?");
} catch (Exception e) {
logger.error("Erro ao obter conexao", e);
}