API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 1st, 2020
114
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 55.11 KB | None | 0 0
raw download clone embed print report
  1. # tail -f nohup.out
  2. 2020-04-01 12:33:58,013 main DEBUG null null initializing configuration XmlConfiguration[location=rsrc:log4j2.xml]
  3. 2020-04-01 12:33:58,117 main DEBUG Installed 1 script engine
  4. 2020-04-01 12:33:59,392 main DEBUG Oracle Nashorn version: 1.8.0_212, language: ECMAScript, threading: Not Thread Safe, compile: true, names: [nashorn, Nashorn, js, JS, JavaScript, javascript, ECMAScript, ecmascript], factory class: jdk.nashorn.api.scripting.NashornScriptEngineFactory
  5. 2020-04-01 12:33:59,393 main DEBUG PluginManager 'Core' found 117 plugins
  6. 2020-04-01 12:33:59,393 main DEBUG PluginManager 'Level' found 0 plugins
  7. 2020-04-01 12:33:59,398 main DEBUG PluginManager 'Lookup' found 13 plugins
  8. 2020-04-01 12:33:59,400 main DEBUG Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout].
  9. 2020-04-01 12:33:59,413 main DEBUG PluginManager 'TypeConverter' found 26 plugins
  10. 2020-04-01 12:33:59,429 main DEBUG PatternLayout$Builder(pattern="%d{yyyy-MM-dd HH:mm:ss,SSS} %-5level className[%C] methodName[%M] message[%msg] %ex{full}%n", PatternSelector=null, Configuration(rsrc:log4j2.xml), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
  11. 2020-04-01 12:33:59,430 main DEBUG PluginManager 'Converter' found 44 plugins
  12. 2020-04-01 12:33:59,449 main DEBUG Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.ConsoleAppender].
  13. 2020-04-01 12:33:59,460 main DEBUG ConsoleAppender$Builder(target="SYSTEM_OUT", follow="null", direct="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{yyyy-MM-dd HH:mm:ss,SSS} %-5level className[%C] methodName[%M] message[%msg] %ex{full}%n), name="Console", Configuration(rsrc:log4j2.xml), Filter=null)
  14. 2020-04-01 12:33:59,566 main DEBUG Starting OutputStreamManager SYSTEM_OUT.false.false
  15. 2020-04-01 12:33:59,567 main DEBUG Building Plugin[name=layout, class=org.apache.logging.log4j.core.layout.PatternLayout].
  16. 2020-04-01 12:33:59,568 main DEBUG PatternLayout$Builder(pattern="%d{yyyy-MM-dd HH:mm:ss,SSS} %-5level %logger{36} [%t] className[%C] methodName[%M] message[%msg] %ex{full}%n", PatternSelector=null, Configuration(rsrc:log4j2.xml), Replace=null, charset="null", alwaysWriteExceptions="null", disableAnsi="null", noConsoleNoAnsi="null", header="null", footer="null")
  17. 2020-04-01 12:33:59,570 main DEBUG Building Plugin[name=appender, class=org.apache.logging.log4j.core.appender.FileAppender].
  18. 2020-04-01 12:33:59,574 main DEBUG FileAppender$Builder(fileName="/opt/psm/log/daemon.log", append="null", locking="null", advertise="null", advertiseUri="null", createOnDemand="null", filePermissions="null", fileOwner="null", fileGroup="null", bufferedIo="null", bufferSize="null", immediateFlush="null", ignoreExceptions="null", PatternLayout(%d{yyyy-MM-dd HH:mm:ss,SSS} %-5level %logger{36} [%t] className[%C] methodName[%M] message[%msg] %ex{full}%n), name="File", Configuration(rsrc:log4j2.xml), Filter=null)
  19. 2020-04-01 12:33:59,576 main DEBUG Starting FileManager /opt/psm/log/daemon.log
  20. 2020-04-01 12:33:59,577 main DEBUG Building Plugin[name=appenders, class=org.apache.logging.log4j.core.config.AppendersPlugin].
  21. 2020-04-01 12:33:59,579 main DEBUG createAppenders(={Console, File})
  22. 2020-04-01 12:33:59,579 main DEBUG Building Plugin[name=AppenderRef, class=org.apache.logging.log4j.core.config.AppenderRef].
  23. 2020-04-01 12:33:59,584 main DEBUG createAppenderRef(ref="Console", level="null", Filter=null)
  24. 2020-04-01 12:33:59,585 main DEBUG Building Plugin[name=AppenderRef, class=org.apache.logging.log4j.core.config.AppenderRef].
  25. 2020-04-01 12:33:59,586 main DEBUG createAppenderRef(ref="File", level="null", Filter=null)
  26. 2020-04-01 12:33:59,586 main DEBUG Building Plugin[name=root, class=org.apache.logging.log4j.core.config.LoggerConfig$RootLogger].
  27. 2020-04-01 12:33:59,587 main DEBUG createLogger(additivity="null", level="DEBUG", includeLocation="null", ={Console, File}, ={}, Configuration(rsrc:log4j2.xml), Filter=null)
  28. 2020-04-01 12:33:59,590 main DEBUG Building Plugin[name=loggers, class=org.apache.logging.log4j.core.config.LoggersPlugin].
  29. 2020-04-01 12:33:59,591 main DEBUG createLoggers(={root})
  30. 2020-04-01 12:33:59,593 main DEBUG Configuration XmlConfiguration[location=rsrc:log4j2.xml] initialized
  31. 2020-04-01 12:33:59,593 main DEBUG Starting configuration XmlConfiguration[location=rsrc:log4j2.xml]
  32. 2020-04-01 12:33:59,593 main DEBUG Started configuration XmlConfiguration[location=rsrc:log4j2.xml] OK.
  33. 2020-04-01 12:33:59,594 main DEBUG Shutting down OutputStreamManager SYSTEM_OUT.false.false-1
  34. 2020-04-01 12:33:59,595 main DEBUG Shut down OutputStreamManager SYSTEM_OUT.false.false-1, all resources released: true
  35. 2020-04-01 12:33:59,595 main DEBUG Appender DefaultConsole-1 stopped with status true
  36. 2020-04-01 12:33:59,596 main DEBUG Stopped org.apache.logging.log4j.core.config.DefaultConfiguration@4c6e276e OK
  37. 2020-04-01 12:33:59,647 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a81197d
  38. 2020-04-01 12:33:59,650 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a81197d,component=StatusLogger
  39. 2020-04-01 12:33:59,652 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a81197d,component=ContextSelector
  40. 2020-04-01 12:33:59,654 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a81197d,component=Loggers,name=
  41. 2020-04-01 12:33:59,655 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a81197d,component=Appenders,name=Console
  42. 2020-04-01 12:33:59,656 main DEBUG Registering MBean org.apache.logging.log4j2:type=7a81197d,component=Appenders,name=File
  43. 2020-04-01 12:33:59,658 main DEBUG org.apache.logging.log4j.core.util.SystemClock does not support precise timestamps.
  44. 2020-04-01 12:33:59,658 main DEBUG Reconfiguration complete for context[name=7a81197d] at URI rsrc:log4j2.xml (org.apache.logging.log4j.core.LoggerContext@5c6a5192) with optional ClassLoader: null
  45. 2020-04-01 12:33:59,659 main DEBUG Shutdown hook enabled. Registering a new one.
  46. 2020-04-01 12:33:59,660 main DEBUG LoggerContext[name=7a81197d, org.apache.logging.log4j.core.LoggerContext@5c6a5192] started OK.
  47. 2020-04-01 12:33:59,666 INFO className[com.holedge.security.perimeterservice.PerimeterService] methodName[main] message[Starting Perimeter Service Manager.]
  48. 2020-04-01 12:33:59,672 DEBUG className[com.holedge.security.perimeterservice.PerimeterService] methodName[main] message[Cleanup at start set to false]
  49. 2020-04-01 12:33:59,810 DEBUG className[org.springframework.context.support.AbstractApplicationContext] methodName[prepareRefresh] message[Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@9b47400]
  50. 2020-04-01 12:34:00,216 DEBUG className[org.springframework.beans.factory.xml.XmlBeanDefinitionReader] methodName[doLoadBeanDefinitions] message[Loaded 3 bean definitions from class path resource [beans.xml]]
  51. 2020-04-01 12:34:00,253 DEBUG className[org.springframework.beans.factory.support.DefaultSingletonBeanRegistry] methodName[getSingleton] message[Creating shared instance of singleton bean 'dataSource']
  52. 2020-04-01 12:34:00,568 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[setDriverClassName] message[Loaded JDBC driver: org.mariadb.jdbc.Driver]
  53. 2020-04-01 12:34:00,570 DEBUG className[org.springframework.beans.factory.support.DefaultSingletonBeanRegistry] methodName[getSingleton] message[Creating shared instance of singleton bean 'jobManager']
  54. 2020-04-01 12:34:00,596 DEBUG className[org.springframework.beans.factory.support.DefaultSingletonBeanRegistry] methodName[getSingleton] message[Creating shared instance of singleton bean 'dispatcher']
  55. 2020-04-01 12:34:00,611 INFO className[com.holedge.security.perimeterservice.PerimeterService] methodName[main] message[Starting manager thread]
  56. 2020-04-01 12:34:00,612 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[JobManager initialized.]
  57. 2020-04-01 12:34:00,613 DEBUG className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Start job manager cycle.]
  58. 2020-04-01 12:34:00,614 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Looking for latecomers jobs.]
  59. 2020-04-01 12:34:00,663 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[query] message[Executing SQL query [SELECT id, owner, group_id, deleted, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, LOCALTIME_TO_UTC(timeframe_from) AS timeframe_from, LOCALTIME_TO_UTC(timeframe_to) AS timeframe_to, scan_start, scan_end, discovery_count, host_alive, assessment_count FROM scans WHERE deleted = 0 AND scan_end IS NULL AND not_after IS NOT NULL AND not_after < CURRENT_TIME]]
  60. 2020-04-01 12:34:00,668 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  61. 2020-04-01 12:34:00,669 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  62. 2020-04-01 12:34:00,762 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  63. 2020-04-01 12:34:00,763 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Found 0 latecomers jobs.]
  64. 2020-04-01 12:34:00,764 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Scheduling scan jobs.]
  65. 2020-04-01 12:34:00,764 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing SQL statement [INSERT INTO scans (owner, group_id, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, timeframe_from, timeframe_to ) SELECT owner, id, stages, queue, max_frequency, parents + 1, perimeter, ports, protocols, start_after, not_after, timeframe_from, timeframe_to FROM scans WHERE deleted = 0 AND queue = 0 AND scan_end IS NOT NULL AND CURRENT_TIMESTAMP >= DATE_ADD(scan_start, INTERVAL GREATEST(1, COALESCE(max_frequency, 30)) DAY) AND id IN (SELECT MAX(id) FROM scans GROUP BY group_id)]]
  66. 2020-04-01 12:34:00,765 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  67. 2020-04-01 12:34:00,765 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  68. 2020-04-01 12:34:00,772 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  69. 2020-04-01 12:34:00,773 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[query] message[Executing SQL query [SELECT id, owner, group_id, deleted, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, LOCALTIME_TO_UTC(timeframe_from) AS timeframe_from, LOCALTIME_TO_UTC(timeframe_to) AS timeframe_to, scan_start, scan_end, discovery_count, host_alive, assessment_count FROM scans WHERE deleted = 0 AND scan_start IS NULL AND CURRENT_TIMESTAMP > start_after AND perimeter_size = 0]]
  70. 2020-04-01 12:34:00,773 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  71. 2020-04-01 12:34:00,773 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  72. 2020-04-01 12:34:00,789 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  73. 2020-04-01 12:34:00,790 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Found 4 scans to start]
  74. 2020-04-01 12:34:00,791 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  75. 2020-04-01 12:34:00,793 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  76. 2020-04-01 12:34:00,794 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  77. 2020-04-01 12:34:00,794 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  78. 2020-04-01 12:34:00,807 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  79. 2020-04-01 12:34:00,807 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  80. 2020-04-01 12:34:00,812 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  81. 2020-04-01 12:34:00,812 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  82. 2020-04-01 12:34:00,812 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  83. 2020-04-01 12:34:00,813 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  84. 2020-04-01 12:34:00,817 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  85. 2020-04-01 12:34:00,817 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  86. 2020-04-01 12:34:00,819 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  87. 2020-04-01 12:34:00,819 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  88. 2020-04-01 12:34:00,819 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  89. 2020-04-01 12:34:00,819 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  90. 2020-04-01 12:34:00,824 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  91. 2020-04-01 12:34:00,824 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  92. 2020-04-01 12:34:00,825 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  93. 2020-04-01 12:34:00,825 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  94. 2020-04-01 12:34:00,825 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  95. 2020-04-01 12:34:00,826 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  96. 2020-04-01 12:34:00,830 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  97. 2020-04-01 12:34:00,830 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  98. 2020-04-01 12:34:00,832 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  99. 2020-04-01 12:34:00,834 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  100. 2020-04-01 12:34:00,834 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  101. 2020-04-01 12:34:00,834 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  102. 2020-04-01 12:34:00,843 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  103. 2020-04-01 12:34:00,844 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  104. 2020-04-01 12:34:00,844 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  105. 2020-04-01 12:34:00,844 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  106. 2020-04-01 12:34:00,845 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  107. 2020-04-01 12:34:00,849 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  108. 2020-04-01 12:34:00,850 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  109. 2020-04-01 12:34:00,850 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  110. 2020-04-01 12:34:00,851 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  111. 2020-04-01 12:34:00,851 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  112. 2020-04-01 12:34:00,856 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  113. 2020-04-01 12:34:00,856 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  114. 2020-04-01 12:34:00,857 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  115. 2020-04-01 12:34:00,857 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  116. 2020-04-01 12:34:00,857 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  117. 2020-04-01 12:34:00,862 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  118. 2020-04-01 12:34:00,863 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  119. 2020-04-01 12:34:00,863 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET scan_end = NOW() WHERE scan_end IS NULL AND perimeter_size > 0 AND perimeter_size = discovery_count AND (stages = ? OR host_alive = assessment_count)]]
  120. 2020-04-01 12:34:00,863 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  121. 2020-04-01 12:34:00,864 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  122. 2020-04-01 12:34:00,869 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  123. 2020-04-01 12:34:00,870 DEBUG className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[End cycle - Going to sleep.]
  124. 2020-04-01 12:34:05,612 INFO className[com.holedge.security.perimeterservice.PerimeterService] methodName[main] message[Starting dispatcher thread]
  125. 2020-04-01 12:34:05,615 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[query] message[Executing SQL query [SELECT id, owner, name, handler, active, settings, instance FROM probes WHERE active = true]]
  126. 2020-04-01 12:34:05,616 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  127. 2020-04-01 12:34:05,616 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  128. 2020-04-01 12:34:05,630 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  129. 2020-04-01 12:34:05,631 INFO className[com.holedge.security.perimeterservice.DispatcherService] methodName[run] message[DB contains 2 probes.]
  130. 2020-04-01 12:34:15,871 DEBUG className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Start job manager cycle.]
  131. 2020-04-01 12:34:15,871 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Looking for latecomers jobs.]
  132. 2020-04-01 12:34:15,871 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[query] message[Executing SQL query [SELECT id, owner, group_id, deleted, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, LOCALTIME_TO_UTC(timeframe_from) AS timeframe_from, LOCALTIME_TO_UTC(timeframe_to) AS timeframe_to, scan_start, scan_end, discovery_count, host_alive, assessment_count FROM scans WHERE deleted = 0 AND scan_end IS NULL AND not_after IS NOT NULL AND not_after < CURRENT_TIME]]
  133. 2020-04-01 12:34:15,872 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  134. 2020-04-01 12:34:15,872 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  135. 2020-04-01 12:34:15,879 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  136. 2020-04-01 12:34:15,880 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Found 0 latecomers jobs.]
  137. 2020-04-01 12:34:15,880 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Scheduling scan jobs.]
  138. 2020-04-01 12:34:15,880 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing SQL statement [INSERT INTO scans (owner, group_id, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, timeframe_from, timeframe_to ) SELECT owner, id, stages, queue, max_frequency, parents + 1, perimeter, ports, protocols, start_after, not_after, timeframe_from, timeframe_to FROM scans WHERE deleted = 0 AND queue = 0 AND scan_end IS NOT NULL AND CURRENT_TIMESTAMP >= DATE_ADD(scan_start, INTERVAL GREATEST(1, COALESCE(max_frequency, 30)) DAY) AND id IN (SELECT MAX(id) FROM scans GROUP BY group_id)]]
  139. 2020-04-01 12:34:15,881 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  140. 2020-04-01 12:34:15,881 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  141. 2020-04-01 12:34:15,887 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  142. 2020-04-01 12:34:15,888 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[query] message[Executing SQL query [SELECT id, owner, group_id, deleted, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, LOCALTIME_TO_UTC(timeframe_from) AS timeframe_from, LOCALTIME_TO_UTC(timeframe_to) AS timeframe_to, scan_start, scan_end, discovery_count, host_alive, assessment_count FROM scans WHERE deleted = 0 AND scan_start IS NULL AND CURRENT_TIMESTAMP > start_after AND perimeter_size = 0]]
  143. 2020-04-01 12:34:15,888 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  144. 2020-04-01 12:34:15,889 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  145. 2020-04-01 12:34:15,896 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  146. 2020-04-01 12:34:15,897 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Found 4 scans to start]
  147. 2020-04-01 12:34:15,897 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  148. 2020-04-01 12:34:15,898 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  149. 2020-04-01 12:34:15,898 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  150. 2020-04-01 12:34:15,898 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  151. 2020-04-01 12:34:15,902 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  152. 2020-04-01 12:34:15,903 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  153. 2020-04-01 12:34:15,903 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  154. 2020-04-01 12:34:15,903 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  155. 2020-04-01 12:34:15,904 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  156. 2020-04-01 12:34:15,904 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  157. 2020-04-01 12:34:15,908 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  158. 2020-04-01 12:34:15,908 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  159. 2020-04-01 12:34:15,909 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  160. 2020-04-01 12:34:15,909 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  161. 2020-04-01 12:34:15,909 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  162. 2020-04-01 12:34:15,909 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  163. 2020-04-01 12:34:15,913 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  164. 2020-04-01 12:34:15,913 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  165. 2020-04-01 12:34:15,914 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  166. 2020-04-01 12:34:15,914 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  167. 2020-04-01 12:34:15,914 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  168. 2020-04-01 12:34:15,915 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  169. 2020-04-01 12:34:15,918 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  170. 2020-04-01 12:34:15,919 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  171. 2020-04-01 12:34:15,919 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  172. 2020-04-01 12:34:15,920 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  173. 2020-04-01 12:34:15,920 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  174. 2020-04-01 12:34:15,920 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  175. 2020-04-01 12:34:15,925 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  176. 2020-04-01 12:34:15,925 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  177. 2020-04-01 12:34:15,926 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  178. 2020-04-01 12:34:15,926 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  179. 2020-04-01 12:34:15,926 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  180. 2020-04-01 12:34:15,931 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  181. 2020-04-01 12:34:15,931 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  182. 2020-04-01 12:34:15,932 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  183. 2020-04-01 12:34:15,932 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  184. 2020-04-01 12:34:15,932 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  185. 2020-04-01 12:34:15,937 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  186. 2020-04-01 12:34:15,937 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  187. 2020-04-01 12:34:15,938 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  188. 2020-04-01 12:34:15,938 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  189. 2020-04-01 12:34:15,938 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  190. 2020-04-01 12:34:15,943 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  191. 2020-04-01 12:34:15,943 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  192. 2020-04-01 12:34:15,943 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET scan_end = NOW() WHERE scan_end IS NULL AND perimeter_size > 0 AND perimeter_size = discovery_count AND (stages = ? OR host_alive = assessment_count)]]
  193. 2020-04-01 12:34:15,944 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  194. 2020-04-01 12:34:15,944 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  195. 2020-04-01 12:34:15,950 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  196. 2020-04-01 12:34:15,950 DEBUG className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[End cycle - Going to sleep.]
  197. 2020-04-01 12:34:30,951 DEBUG className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Start job manager cycle.]
  198. 2020-04-01 12:34:30,951 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Looking for latecomers jobs.]
  199. 2020-04-01 12:34:30,951 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[query] message[Executing SQL query [SELECT id, owner, group_id, deleted, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, LOCALTIME_TO_UTC(timeframe_from) AS timeframe_from, LOCALTIME_TO_UTC(timeframe_to) AS timeframe_to, scan_start, scan_end, discovery_count, host_alive, assessment_count FROM scans WHERE deleted = 0 AND scan_end IS NULL AND not_after IS NOT NULL AND not_after < CURRENT_TIME]]
  200. 2020-04-01 12:34:30,951 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  201. 2020-04-01 12:34:30,952 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  202. 2020-04-01 12:34:30,959 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  203. 2020-04-01 12:34:30,960 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Found 0 latecomers jobs.]
  204. 2020-04-01 12:34:30,960 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Scheduling scan jobs.]
  205. 2020-04-01 12:34:30,961 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing SQL statement [INSERT INTO scans (owner, group_id, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, timeframe_from, timeframe_to ) SELECT owner, id, stages, queue, max_frequency, parents + 1, perimeter, ports, protocols, start_after, not_after, timeframe_from, timeframe_to FROM scans WHERE deleted = 0 AND queue = 0 AND scan_end IS NOT NULL AND CURRENT_TIMESTAMP >= DATE_ADD(scan_start, INTERVAL GREATEST(1, COALESCE(max_frequency, 30)) DAY) AND id IN (SELECT MAX(id) FROM scans GROUP BY group_id)]]
  206. 2020-04-01 12:34:30,961 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  207. 2020-04-01 12:34:30,961 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  208. 2020-04-01 12:34:30,967 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  209. 2020-04-01 12:34:30,968 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[query] message[Executing SQL query [SELECT id, owner, group_id, deleted, stages, queue, max_frequency, parents, perimeter, ports, protocols, start_after, not_after, LOCALTIME_TO_UTC(timeframe_from) AS timeframe_from, LOCALTIME_TO_UTC(timeframe_to) AS timeframe_to, scan_start, scan_end, discovery_count, host_alive, assessment_count FROM scans WHERE deleted = 0 AND scan_start IS NULL AND CURRENT_TIMESTAMP > start_after AND perimeter_size = 0]]
  210. 2020-04-01 12:34:30,968 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  211. 2020-04-01 12:34:30,968 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  212. 2020-04-01 12:34:30,976 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  213. 2020-04-01 12:34:30,977 INFO className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[Found 4 scans to start]
  214. 2020-04-01 12:34:30,977 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  215. 2020-04-01 12:34:30,977 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  216. 2020-04-01 12:34:30,977 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  217. 2020-04-01 12:34:30,977 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  218. 2020-04-01 12:34:30,981 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  219. 2020-04-01 12:34:30,981 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  220. 2020-04-01 12:34:30,982 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  221. 2020-04-01 12:34:30,982 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  222. 2020-04-01 12:34:30,982 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  223. 2020-04-01 12:34:30,982 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  224. 2020-04-01 12:34:30,986 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  225. 2020-04-01 12:34:30,986 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  226. 2020-04-01 12:34:30,987 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  227. 2020-04-01 12:34:30,987 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  228. 2020-04-01 12:34:30,987 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  229. 2020-04-01 12:34:30,987 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  230. 2020-04-01 12:34:30,991 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  231. 2020-04-01 12:34:30,991 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  232. 2020-04-01 12:34:30,992 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[batchUpdate] message[Executing SQL batch update [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  233. 2020-04-01 12:34:30,992 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [INSERT INTO dispatchers (owner, scan_id, queue, last_stage, target, ip, ports, protocols, timeframe_from, timeframe_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, UTC_TO_LOCALTIME(?), UTC_TO_LOCALTIME(?))]]
  234. 2020-04-01 12:34:30,992 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  235. 2020-04-01 12:34:30,993 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  236. 2020-04-01 12:34:30,996 DEBUG className[org.springframework.jdbc.support.JdbcUtils] methodName[supportsBatchUpdates] message[JDBC driver supports batch updates]
  237. 2020-04-01 12:34:30,997 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  238. 2020-04-01 12:34:30,997 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  239. 2020-04-01 12:34:30,998 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  240. 2020-04-01 12:34:30,998 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  241. 2020-04-01 12:34:30,998 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  242. 2020-04-01 12:34:31,004 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  243. 2020-04-01 12:34:31,005 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  244. 2020-04-01 12:34:31,005 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  245. 2020-04-01 12:34:31,005 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  246. 2020-04-01 12:34:31,005 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  247. 2020-04-01 12:34:31,010 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  248. 2020-04-01 12:34:31,011 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  249. 2020-04-01 12:34:31,011 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  250. 2020-04-01 12:34:31,011 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  251. 2020-04-01 12:34:31,012 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  252. 2020-04-01 12:34:31,016 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  253. 2020-04-01 12:34:31,017 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  254. 2020-04-01 12:34:31,017 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET perimeter_size = ? WHERE id = ?]]
  255. 2020-04-01 12:34:31,018 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  256. 2020-04-01 12:34:31,018 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  257. 2020-04-01 12:34:31,022 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  258. 2020-04-01 12:34:31,023 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
  259. 2020-04-01 12:34:31,023 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[execute] message[Executing prepared SQL statement [UPDATE scans SET scan_end = NOW() WHERE scan_end IS NULL AND perimeter_size > 0 AND perimeter_size = discovery_count AND (stages = ? OR host_alive = assessment_count)]]
  260. 2020-04-01 12:34:31,023 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doGetConnection] message[Fetching JDBC Connection from DataSource]
  261. 2020-04-01 12:34:31,024 DEBUG className[org.springframework.jdbc.datasource.DriverManagerDataSource] methodName[getConnectionFromDriver] message[Creating new JDBC DriverManager Connection to [jdbc:mariadb://backend01-mysql:3306/perimeter_service?useServerPrepStmts=false&rewriteBatchedStatements=true]]
  262. 2020-04-01 12:34:31,029 DEBUG className[org.springframework.jdbc.datasource.DataSourceUtils] methodName[doReleaseConnection] message[Returning JDBC Connection to DataSource]
  263. 2020-04-01 12:34:31,030 DEBUG className[com.holedge.security.perimeterservice.JobManager] methodName[run] message[End cycle - Going to sleep.]
  264. 2020-04-01 12:34:41,883 DEBUG className[org.springframework.jdbc.core.JdbcTemplate] methodName[update] message[Executing prepared SQL update]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!