logstash 通过jdbc连接db2数据库

[Glztz]

Pipeline aborted due to error {:exception=>#<Sequel::DatabaseConnectionError: Java::ComIbmDb2JccAm::DisconnectNonTransientConnectionException:
[jcc][t4][2043][11550][3.65.131] ????? java.net.NoRouteToHostException???????ˉ?￡ 50,000 ??????¨ /192.168.1.34
??￥?￥?-???oé?????ˉ??o???2??? ????o?è·ˉ?±? ERRORCODE=-4499, SQLSTATE=08001>,
:backtrace=>["com.ibm.db2.jcc.am.cd.a(com/ibm/db2/jcc/am/cd.java:321)",
"com.ibm.db2.jcc.am.cd.a(com/ibm/db2/jcc/am/cd.java:359)",
"com.ibm.db2.jcc.t4.wb.a(com/ibm/db2/jcc/t4/wb.java:435)",
"com.ibm.db2.jcc.t4.wb.<init>(com/ibm/db2/jcc/t4/wb.java:93)",
"com.ibm.db2.jcc.t4.a.b(com/ibm/db2/jcc/t4/a.java:364)",
"com.ibm.db2.jcc.t4.b.newAgent_(com/ibm/db2/jcc/t4/b.java:2038)",
"com.ibm.db2.jcc.am.Connection.initConnection(com/ibm/db2/jcc/am/Connection.java:747)",
"com.ibm.db2.jcc.am.Connection.<init>(com/ibm/db2/jcc/am/Connection.java:693)",
"com.ibm.db2.jcc.t4.b.<init>(com/ibm/db2/jcc/t4/b.java:333)",
"com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(com/ibm/db2/jcc/DB2SimpleDataSource.java:233)",
"com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(com/ibm/db2/jcc/DB2SimpleDataSource.java:199)",
"com.ibm.db2.jcc.DB2Driver.connect(com/ibm/db2/jcc/DB2Driver.java:475)",
"com.ibm.db2.jcc.DB2Driver.connect(com/ibm/db2/jcc/DB2Driver.java:116)",
"RUBY.connect(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/adapters/jdbc.rb:222)",
"RUBY.make_new(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool.rb:110)",
"RUBY.make_new(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:226)",
"RUBY.available(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:199)",
"RUBY._acquire(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:135)",
"RUBY.acquire(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:149)",
"RUBY.sync(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:280)",
"org.jruby.ext.thread.Mutex.synchronize(org/jruby/ext/thread/Mutex.java:149)",
"RUBY.sync(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:280)",
"RUBY.acquire(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:148)",
"RUBY.hold(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/connection_pool/threaded.rb:106)",
"RUBY.synchronize(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/database/connecting.rb:256)",
"RUBY.test_connection(/opt/logstash/vendor/bundle/jruby/1.9/gems/sequel-4.36.0/lib/sequel/database/connecting.rb:266)",
"RUBY.prepare_jdbc_connection(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin_mixins/jdbc.rb:170)",
"RUBY.register(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167)",
"RUBY.start_inputs(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.4-java/lib/logstash/pipeline.rb:330)",
"org.jruby.RubyArray.each(org/jruby/RubyArray.java:1613)",
"RUBY.start_inputs(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.4-java/lib/logstash/pipeline.rb:329)",
"RUBY.start_workers(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.4-java/lib/logstash/pipeline.rb:180)",
"RUBY.run(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.4-java/lib/logstash/pipeline.rb:136)",
"RUBY.start_pipeline(/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.4-java/lib/logstash/agent.rb:473)"],
:level=>:error}

[Glztz]

[root@localhost bin]# service iptables status Redirecting to /bin/systemctl status iptables.service ● iptables.service - IPv4 firewall with iptables Loaded: loaded (/usr/lib/systemd/system/iptables.service; disabled; vendor preset: disabled) Active: active (exited) since 四 2016-12-01 19:07:23 CST; 3s ago Process: 6855 ExecStop=/usr/libexec/iptables/iptables.init stop (code=exited, status=0/SUCCESS) Process: 6950 ExecStart=/usr/libexec/iptables/iptables.init start (code=exited, status=0/SUCCESS) Main PID: 6950 (code=exited, status=0/SUCCESS) 12月 01 19:07:23 localhost.localdomain systemd[1]: Starting IPv4 firewall with iptables... 12月 01 19:07:23 localhost.localdomain systemd[1]: Started IPv4 firewall with iptables. 网络状态在打开的情况下，能连接上了。具体原因还没弄清楚。