Trouble Network connection to database throw Firewall (NAT translation) from console

[Maxim Nikolaev]

MacOS client  -  console orientdb 2.2. 

my db have 777 rights and listens 0.0.0.0:2424 address

First test :

telnet from command line success connecting  to orientdb, when I input text it call exception :

com.orientechnologies.common.io.OIOException?Impossible to read a chunk of length:2003134055 max allowed chunk length:16777216 see NETWORK_BINARY_MAX_CONTENT_LENGTH settings q??sr,com.orientechnologies.common.io.OIOException?O????"Hxr7com.orientechnologies.common.exception.OSystemException??_Eh<??xr1com.orientechnologies.common.exception.OException5?9?v?O0xrjava.lang.RuntimeException?_G

4??xrjava.lang.Exception??>;?xrjava.lang.Throwable??5'9w??LcausetLjava/lang/ThrodetailMessagetLjava/lang/String;[

stackTracet[Ljava/lang/StackTraceElement;LsuppressedExceptionstLjava/util/List;xppt?Impossible to read a chunk of length:2003134055 max allowed chunk length:16777216 see NETWORK_BINARY_MAX_CONTENT_LENGTH settings ur[Ljava.lang.StackTraceElement;F*<<?"9xpsrava.lang.StackTraceElementa Ś&6݅I

lineNumberLdeclaringClassq~fileNameq~L

methodNameq~xp?tEcom.orientechnologies.orient.enterprise.channel.binary.OChannelBinarytOChannelBinary.javat readBytessq~?tRcom.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinarytNetworkProtocolBinary.javatonBeforeOperationalRequestsq~bq~q~tsessionRequestsq~?q~q~texecutesq~Mt/com.orientechnologies.common.thread.OSoftThreadtOSoftThread.javatrunsr&java.util.Collections$UnmodifiableList?%1??Llistq~ xr,java.util.Collections$UnmodifiableCollectionB??^?LctLjava/util/Collection;xpsrjava.util.ArrayListx????a?Isizexpwxq~$xConnection closed by foreign host.

but it confirms that packet reach orientdb host successfully.

Second test:

Iptables registred incoming packets too. Connection from client to server established successfully on port 2424

Oct  6 13:48:18 kernel: [79208.138517] Detecting incoming packets: IN=ens160 OUT= MAC=* SRC=* DST=LEN=64 TOS=0x00 PREC=0x00 TTL=54 ID=25429 PROTO=TCP SPT=5432 DPT=2424 WINDOW=65535 RES=0x00 SYN URGP=0

Oct  6 13:48:18 kernel: [79208.142288] Detecting incoming packets: IN=ens160 OUT= MAC= SRC= DST= LEN=52 TOS=0x00 PREC=0x00 TTL=54 ID=18031 PROTO=TCP SPT=5432 DPT=2424 WINDOW=4104 RES=0x00 ACK URGP=0

Oct  6 13:48:18 kernel: [79208.146636] Detecting incoming packets: IN=ens160 OUT= MAC= SRC= DST= LEN=52 TOS=0x00 PREC=0x00 TTL=54 ID=3105 PROTO=TCP SPT=5432 DPT=2424 WINDOW=4103 RES=0x00 ACK URGP=0

Oct  6 13:48:18 kernel: [79208.147123] Detecting incoming packets: IN=ens160 OUT= MAC= SRC= DST= LEN=153 TOS=0x00 PREC=0x00 TTL=54 ID=10286 PROTO=TCP SPT=5432 DPT=2424 WINDOW=4103 RES=0x00 ACK PSH URGP=0

Iptables register packets from my client. But orientdb not response to client. 

OrientDB have event in log :

OrientDB Server is active v2.2.24 (build d3309b6660d38e14390344a1fa98a43ade2e2073). [OServer]Error executing requestcom.orientechnologies.common.io.OIOException: Impossible to read a chunk of length:175181066 max allowed chunk length:16777216 see NETWORK_BINARY_MAX_CONTENT_LENGTH settings at com.orientechnologies.orient.enterprise.channel.binary.OChannelBinary.readBytes(OChannelBinary.java:160) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.onBeforeOperationalRequest(ONetworkProtocolBinary.java:473) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.sessionRequest(ONetworkProtocolBinary.java:354) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.execute(ONetworkProtocolBinary.java:207) at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:77)Error executing requestcom.orientechnologies.common.io.OIOException: Impossible to read a chunk of length:175181066 max allowed chunk length:16777216 see NETWORK_BINARY_MAX_CONTENT_LENGTH settings at com.orientechnologies.orient.enterprise.channel.binary.OChannelBinary.readBytes(OChannelBinary.java:160) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.onBeforeOperationalRequest(ONetworkProtocolBinary.java:473) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.sessionRequest(ONetworkProtocolBinary.java:354) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.execute(ONetworkProtocolBinary.java:207) at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:77)Error executing requestcom.orientechnologies.common.io.OIOException: Impossible to read a chunk of length:22085969 max allowed chunk length:16777216 see NETWORK_BINARY_MAX_CONTENT_LENGTH settings at com.orientechnologies.orient.enterprise.channel.binary.OChannelBinary.readBytes(OChannelBinary.java:160) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.onBeforeOperationalRequest(ONetworkProtocolBinary.java:473) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.sessionRequest(ONetworkProtocolBinary.java:354) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.execute(ONetworkProtocolBinary.java:207) at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:77)Error executing requestcom.orientechnologies.common.io.OIOException: Impossible to read a chunk of length:218784115 max allowed chunk length:16777216 see NETWORK_BINARY_MAX_CONTENT_LENGTH settings at com.orientechnologies.orient.enterprise.channel.binary.OChannelBinary.readBytes(OChannelBinary.java:160) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.onBeforeOperationalRequest(ONetworkProtocolBinary.java:473) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.sessionRequest(ONetworkProtocolBinary.java:354) at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.execute(ONetworkProtocolBinary.java:207) at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:77)

Yesterday I connected through console on Ubuntu (not MacOS) netbook .Connection was established successfully.

May be problem in Java networking (version sockets protocols) ? Or in Security orientdb or filesystem ?

[Maxim Nikolaev]

I set up the logging on level

On Client Side log:

com.orientechnologies.orient.core.exception.OStorageException: Cannot create a connection to remote server address(es): myipclient:2424]

DB name="newdb"

On Server SIDE log: 

0-07 07:58:30:738 FINE Connection closed [ONetworkProtocolHttpDb] Oct 7 08:04:13 newdbvm kernel: [144963.601745] Detecting incoming packets: IN=ens160 OUT= MAC= SRC= DST= LEN=60 TOS=0x00 PREC=0x00 TTL=55 ID=10788 DF $ Oct 7 08:04:13 newdbvm kernel: [144963.606995] Detecting incoming packets: IN=ens160 OUT= MAC= SRC= DST= LEN=52 TOS=0x00 PREC=0x00 TTL=55 ID=10789 DF $ Oct 7 08:04:13 newdbvm kernel: [144963.615198] Detecting incoming packets: IN=ens160 OUT= MAC= SRC= DST= LEN=52 TOS=0x00 PREC=0x00 TTL=55 ID=10790 DF $ Oct 7 08:04:13 newdbvm kernel: [144963.636348] Detecting incoming packets: IN=ens160 OUT= MAC= SRC= DST= LEN=153 TOS=0x00 PREC=0x00 TTL=55 ID=10791 DF$ Oct 7 08:04:13 newdbvm server.sh[21327]: 2017-10-07 07:59:44:244 CONFI Profiler has stopped recording metrics [OEnterpriseProfiler] Oct 7 08:04:13 newdbvm server.sh[21327]: 2017-10-07 08:04:13:852 CONFI Remote client connected from: OClientConnection [id=53, source=/myip, since=1507352653850] [OClientConnectionManager] Oct 7 08:04:13 newdbvm server.sh[21327]: 2017-10-07 08:04:13:852 FINE Request id:-2 type:3 [ONetworkProtocolBinary] Oct 7 08:04:13 newdbvm server.sh[21327]: 2017-10-07 08:04:13:856 FINE {db=} Read record #5:0 v.4 size=171 bytes (thread=89 tx=false) [OEnterpriseLocalPaginatedStorage] Oct 7 08:04:13 newdbvm server.sh[21327]: 2017-10-07 08:04:13:856 FINE {db=} Read record #4:0 v.2 size=69 bytes (thread=89 tx=false) [OEnterpriseLocalPaginatedStorage]

On server Side client read two records..but connection failed((