On 01/08/2012 09:02, Alex Peshkoff wrote:
On 07/31/12 20:06, JLM wrote:
Sooner of all wireshark does not recognize an attempt to talk using new
protocol, FB13. That extensions are silently ignored by old servers, but
may drive packet dumper crazy. In hex form packets look OK for me.
Moreover, they are accepted by server. BTW, what version is installed?
2.5 or older?
It is the 2.5 version server wich is installed.
During cross-build you've got native fbclient and some utilities in
gen/Native. Can you try to connet to server with that isql and see what
happens? Txt dump from wireshark, sent to me, will be very useful.
It doesn't run :
SQL> connect /home/menlog/compilation/employee.fdb password masterkey
user SYSDBA;
Statement failed, SQLSTATE = HY000
unsupported on-disk structure for file
/home/menlog/compilation/employee.fdb; found 12.1, support 11.2
And though, it's the employee database from my 3.0 firebird compilation.
Txt dump from wireshark is attached.
Jean-Louis Meuriot
No. Time Source Destination Protocol Length
Info Source Port
Destination port
1 0.000000 127.0.0.1 127.0.0.1 TCP 74
nimcontroller > gds-db [SYN] Seq=0 Win=32792 Len=0 MSS=16396 SACK_PERM=1
TSval=435240 TSecr=0 WS=16 nimcontroller gds-db
Frame 1: 74 bytes on wire (592 bits), 74 bytes captured (592 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 0, Len: 0
No. Time Source Destination Protocol Length
Info Source Port
Destination port
2 0.000013 127.0.0.1 127.0.0.1 TCP 74
gds-db > nimcontroller [SYN, ACK] Seq=0 Ack=1 Win=32768 Len=0 MSS=16396
SACK_PERM=1 TSval=435240 TSecr=435240 WS=16 gds-db nimcontroller
Frame 2: 74 bytes on wire (592 bits), 74 bytes captured (592 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: gds-db (3050), Dst Port: nimcontroller
(48000), Seq: 0, Ack: 1, Len: 0
No. Time Source Destination Protocol Length
Info Source Port
Destination port
3 0.000024 127.0.0.1 127.0.0.1 TCP 66
nimcontroller > gds-db [ACK] Seq=1 Ack=1 Win=32800 Len=0 TSval=435240
TSecr=435240 nimcontroller gds-db
Frame 3: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 1, Ack: 1, Len: 0
No. Time Source Destination Protocol Length
Info Source Port
Destination port
4 0.000080 127.0.0.1 127.0.0.1 GDS DB 242
Connect: /home/menlog/compilation/employee.fdb[Malformed Packet] nimcontroller
gds-db
Frame 4: 242 bytes on wire (1936 bits), 242 bytes captured (1936 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 1, Ack: 1, Len: 176
Firebird SQL Database Remote Protocol
[Malformed Packet: FB/IB GDS DB]
No. Time Source Destination Protocol Length
Info Source Port
Destination port
5 0.000103 127.0.0.1 127.0.0.1 TCP 66
gds-db > nimcontroller [ACK] Seq=1 Ack=177 Win=32768 Len=0 TSval=435240
TSecr=435240 gds-db nimcontroller
Frame 5: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: gds-db (3050), Dst Port: nimcontroller
(48000), Seq: 1, Ack: 177, Len: 0
No. Time Source Destination Protocol Length
Info Source Port
Destination port
6 0.000172 127.0.0.1 127.0.0.1 GDS DB 82
Accept gds-db
nimcontroller
Frame 6: 82 bytes on wire (656 bits), 82 bytes captured (656 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: gds-db (3050), Dst Port: nimcontroller
(48000), Seq: 1, Ack: 177, Len: 16
Firebird SQL Database Remote Protocol
No. Time Source Destination Protocol Length
Info Source Port
Destination port
7 0.000182 127.0.0.1 127.0.0.1 TCP 66
nimcontroller > gds-db [ACK] Seq=177 Ack=17 Win=32784 Len=0 TSval=435240
TSecr=435240 nimcontroller gds-db
Frame 7: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 177, Ack: 17, Len: 0
No. Time Source Destination Protocol Length
Info Source Port
Destination port
8 0.000247 127.0.0.1 127.0.0.1 GDS DB 274
Attach: /home/menlog/compilation/employee.fdb nimcontroller
gds-db
Frame 8: 274 bytes on wire (2192 bits), 274 bytes captured (2192 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 177, Ack: 17, Len: 208
Firebird SQL Database Remote Protocol
No. Time Source Destination Protocol Length
Info Source Port
Destination port
9 0.027367 127.0.0.1 127.0.0.1 GDS DB 178
Response gds-db
nimcontroller
Frame 9: 178 bytes on wire (1424 bits), 178 bytes captured (1424 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: gds-db (3050), Dst Port: nimcontroller
(48000), Seq: 17, Ack: 385, Len: 112
Firebird SQL Database Remote Protocol
No. Time Source Destination Protocol Length
Info Source Port
Destination port
10 0.027471 127.0.0.1 127.0.0.1 TCP 70
nimcontroller > gds-db [PSH, ACK] Seq=385 Ack=129 Win=32768 Len=4 TSval=435247
TSecr=435246 nimcontroller gds-db
Frame 10: 70 bytes on wire (560 bits), 70 bytes captured (560 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 385, Ack: 129, Len: 4
Data (4 bytes)
0000 00 00 00 06 ....
No. Time Source Destination Protocol Length
Info Source Port
Destination port
11 0.027494 127.0.0.1 127.0.0.1 TCP 66
nimcontroller > gds-db [FIN, ACK] Seq=389 Ack=129 Win=32768 Len=0 TSval=435247
TSecr=435246 nimcontroller gds-db
Frame 11: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 389, Ack: 129, Len: 0
No. Time Source Destination Protocol Length
Info Source Port
Destination port
12 0.027577 127.0.0.1 127.0.0.1 TCP 66
gds-db > nimcontroller [FIN, ACK] Seq=129 Ack=390 Win=32768 Len=0 TSval=435247
TSecr=435247 gds-db nimcontroller
Frame 12: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: gds-db (3050), Dst Port: nimcontroller
(48000), Seq: 129, Ack: 390, Len: 0
No. Time Source Destination Protocol Length
Info Source Port
Destination port
13 0.027584 127.0.0.1 127.0.0.1 TCP 66
nimcontroller > gds-db [ACK] Seq=390 Ack=130 Win=32768 Len=0 TSval=435247
TSecr=435247 nimcontroller gds-db
Frame 13: 66 bytes on wire (528 bits), 66 bytes captured (528 bits)
Ethernet II, Src: 00:00:00_00:00:00 (00:00:00:00:00:00), Dst: 00:00:00_00:00:00
(00:00:00:00:00:00)
Internet Protocol Version 4, Src: 127.0.0.1 (127.0.0.1), Dst: 127.0.0.1
(127.0.0.1)
Transmission Control Protocol, Src Port: nimcontroller (48000), Dst Port:
gds-db (3050), Seq: 390, Ack: 130, Len: 0
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
