Dotaz: Apache - PHP - Firebird

[zigi]

Dobry den,

z php skriptu se pripojuji ke trem firebird databazim. Do tedka vse fungovalo a z niceho nic se k databazim nemohu pripojit. Pokus o pripojeni k libovolne databazi skonci hlaskou: Warning: ibase_connect() [function.ibase-connect]: Error reading data from the connection. Po restartovani celeho serveru se urcitou dobu darilo pripojit pouze k prvnim dvema databazim (nezalezelo na poradi, treti v poradi se nepripojila). V log souborech apache nikde nic i po zvyseni LogLevel na emerg. Pokud skript pustim pomoci php interpretu, tak vse probehne v poradku. Pokud skript pustim z jineho apache serveru, tak se taky pripoji. Zkousel jsem hledat ruzne limity (otevrene soubory, deskriptory, sockety) a vse se zda v poradku. Dle tcpdumpu se mi zda, ze je necim komunikace jakoby rusena, dochazi k resetovani spojeni (dump jen pro jedno pripojeni):

23:38:18.990855 IP 127.0.0.1.33891 > 127.0.0.1.3050: S 930437629:930437629(0) win 32792 <mss 16396,sackOK,timestamp 9282674 0,nop,wscale 7>
23:38:18.990875 IP 127.0.0.1.3050 > 127.0.0.1.33891: S 930722811:930722811(0) ack 930437630 win 32768 <mss 16396,sackOK,timestamp 9282674 9282674,nop,wscale 7>
23:38:18.990887 IP 127.0.0.1.33891 > 127.0.0.1.3050: . ack 1 win 257 <nop,nop,timestamp 9282674 9282674>
23:38:18.991028 IP 127.0.0.1.33891 > 127.0.0.1.3050: P 1:137(136) ack 1 win 257 <nop,nop,timestamp 9282674 9282674>
23:38:18.991037 IP 127.0.0.1.3050 > 127.0.0.1.33891: . ack 137 win 265 <nop,nop,timestamp 9282674 9282674>
23:38:18.991131 IP 127.0.0.1.3050 > 127.0.0.1.33891: P 1:17(16) ack 137 win 265 <nop,nop,timestamp 9282674 9282674>
23:38:18.991155 IP 127.0.0.1.33891 > 127.0.0.1.3050: . ack 17 win 257 <nop,nop,timestamp 9282674 9282674>
23:38:18.991179 IP 127.0.0.1.33891 > 127.0.0.1.3050: P 137:229(92) ack 17 win 257 <nop,nop,timestamp 9282674 9282674>
23:38:18.991215 IP 127.0.0.1.33891 > 127.0.0.1.3050: FP 229:233(4) ack 17 win 257 <nop,nop,timestamp 9282674 9282674>
23:38:19.028504 IP 127.0.0.1.3050 > 127.0.0.1.33891: . ack 234 win 265 <nop,nop,timestamp 9282683 9282674>
23:38:19.078189 IP 127.0.0.1.3050 > 127.0.0.1.33891: P 17:49(32) ack 234 win 265 <nop,nop,timestamp 9282695 9282674>
23:38:19.078217 IP 127.0.0.1.33891 > 127.0.0.1.3050: R 930437863:930437863(0) win 0

Takto vypada uspesny pokus o pripojeni z druheho serveru (dump jen pro jedno pripojeni):

23:46:47.188459 IP 10.1.1.254.37132 > 10.1.1.10.3050: S 2646843562:2646843562(0) win 5840 <mss 1460,sackOK,timestamp 574062801 0,nop,wscale 7>
23:46:47.188491 IP 10.1.1.10.3050 > 10.1.1.254.37132: S 310462089:310462089(0) ack 2646843563 win 5792 <mss 1460,sackOK,timestamp 9409723 574062801,nop,wscale 7>
23:46:47.188767 IP 10.1.1.254.37132 > 10.1.1.10.3050: . ack 1 win 46 <nop,nop,timestamp 574062801 9409723>
23:46:47.188786 IP 10.1.1.254.37132 > 10.1.1.10.3050: P 1:157(156) ack 1 win 46 <nop,nop,timestamp 574062801 9409723>
23:46:47.188796 IP 10.1.1.10.3050 > 10.1.1.254.37132: . ack 157 win 54 <nop,nop,timestamp 9409723 574062801>
23:46:47.188874 IP 10.1.1.10.3050 > 10.1.1.254.37132: P 1:17(16) ack 157 win 54 <nop,nop,timestamp 9409723 574062801>
23:46:47.189063 IP 10.1.1.254.37132 > 10.1.1.10.3050: . ack 17 win 46 <nop,nop,timestamp 574062801 9409723>
23:46:47.189070 IP 10.1.1.254.37132 > 10.1.1.10.3050: P 157:249(92) ack 17 win 46 <nop,nop,timestamp 574062801 9409723>
23:46:47.192427 IP 10.1.1.10.3050 > 10.1.1.254.37132: P 17:49(32) ack 249 win 54 <nop,nop,timestamp 9409724 574062801>
23:46:47.193008 IP 10.1.1.254.37132 > 10.1.1.10.3050: P 249:257(8) ack 49 win 46 <nop,nop,timestamp 574062802 9409724>
23:46:47.193445 IP 10.1.1.10.3050 > 10.1.1.254.37132: P 49:81(32) ack 257 win 54 <nop,nop,timestamp 9409724 574062802>
23:46:47.193730 IP 10.1.1.254.37132 > 10.1.1.10.3050: P 257:261(4) ack 81 win 46 <nop,nop,timestamp 574062802 9409724>
23:46:47.193744 IP 10.1.1.254.37132 > 10.1.1.10.3050: F 261:261(0) ack 81 win 46 <nop,nop,timestamp 574062802 9409724>
23:46:47.193815 IP 10.1.1.10.3050 > 10.1.1.254.37132: F 81:81(0) ack 262 win 54 <nop,nop,timestamp 9409724 574062802>
23:46:47.194067 IP 10.1.1.254.37132 > 10.1.1.10.3050: . ack 82 win 46 <nop,nop,timestamp 574062802 9409724>

Prosim nejakou dobrou dusi o nasmerovani spravnym smerem, kde hledat, diky.

Odpovědi

[zigi]

Co me tak trochu zarazi, ze se tak drasticky zmensi velikost tcp okenka..

1. dump:

win 32792 -> win 257
win 32768 -> win 265

2. dump:

win 5840 -> win 46
win 5792 -> win 54