'[freetds] Trouble connection to TDS connection Pooling'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    [freetds] Trouble connection to TDS connection Pooling
From:       freetds () mittran ! com
Date:       2012-04-24 13:27:27
Message-ID: 19895c97299731e9953fc379769cf32b () mittran ! com
[Download RAW message or body]

Hello !
I am trying to use Freetds Connection Pool but something is wrong and I 
can not get any result
back from the pool. I have the following configurations:

$cat /usr/local/etc/pool.conf
[global]
         min pool conn = 5
         max pool conn = 10
         max member age = 120

[mypool4]
         user = myuser
         password = myuser
         database = MyDatabase
         server = 1XX.1XX.X.XXX
         port = 6668
         TDS_Version = 4.2

$cat /usr/local/etc/freetds.conf

[hype]
         host            = 127.0.0.1
         port            = 6668
         tds version     =  4.2
And start the Pool server:

$tdspool mypool4 &

And seting up an entry in my .odbc:

[pool2]
Driver          = /usr/local/lib/libtdsodbc.so
Description     = Sybase JDBC Server
Trace           = Yes
ServerName      = hype
Port            = 6668
TDS_Version     = 4.2

When I run the following command:
$ ¨ isql -v pool2 myuser myuser

I never get a response from the Pooling server. I can see that the Pool 
server received the connection:
accepting connection
block size 512
host MyMachin
user myuser
pass myuser
app
srvr hype
vers 4.2
lib
lang us_english
char iso_1
bsiz 512

And the Pooling server established connections with the MS SQL server.
Something is wrong, but I do not know what.
Here is DUMP:

         on 2012-04-24 15:18:34 with debug flags 0xffff.
15:18:34.935340 10213 (iconv.c:197):names for ISO-8859-1: ISO-8859-1
15:18:34.935410 10213 (iconv.c:197):names for UTF-8: UTF-8
15:18:34.935476 10213 (iconv.c:197):names for UCS-2LE: UCS-2LE
15:18:34.935541 10213 (iconv.c:197):names for UCS-2BE: UCS-2BE
15:18:34.935607 10213 (iconv.c:363):iconv to convert client-side data 
to the "ISO-8859-1" character set
15:18:34.935722 10213 (iconv.c:516):tds_iconv_info_init: converting 
"ISO-8859-1"->"UCS-2LE"
15:18:34.935870 10213 (net.c:210):Connecting to 127.0.0.1 port 6668 
(TDS version 4.2)
15:18:34.936441 10213 (net.c:262):connection established
15:18:34.936541 10213 (net.c:303):tds_open_socket() succeeded
15:18:34.936622 10213 (util.c:162):Changed query state from DEAD to 
IDLE
15:18:34.936708 10213 (net.c:779):Sending packet
0000 02 00 02 00 00 00 00 00-53 37 37 30 30 30 34 36 |........ 
SXXXXXXX|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0020 00 00 00 00 00 00 08 61-6d 73 75 73 65 72 00 00 |.......m 
yusere..|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0040 00 00 00 00 00 07 61 6d-73 75 73 65 72 00 00 00 |.......m 
myuse...|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0060 00 00 00 00 07 33 37 38-37 36 00 00 00 00 00 00 |.....378 
76......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0080 00 00 00 05 02 00 06 04-08 01 00 00 00 00 00 02 |........ 
........|
0090 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
00b0 00 00 00 68 79 70 65 00-00 00 00 00 00 00 00 00 |...hype. 
........|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
00d0 00 04 61 6d 73 75 73 65-72 00 00 00 00 00 00 00 |..myuser 
........|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
01d0 00 07 04 02 00 00 00 00-00 00 00 00 00 00 00 00 |........ 
........|
01e0 00 00 00 00 00 00 0c 10-75 73 5f 65 6e 67 6c 69 |........ 
us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... 
........|

15:18:34.937754 10213 (net.c:779):Sending packet
0000 02 01 00 4c 00 00 00 00-00 00 00 00 00 00 0a 00 |...L.... 
........|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 69 73 6f |........ 
.....iso|
0020 5f 31 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |_1...... 
........|
0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........ 
.....512|
0040 00 00 00 03 00 00 00 00-00 00 00 00             |........ ....|

15:18:34.937980 10213 (token.c:312):tds_process_login_tokens()
15:18:34.940017 10213 (net.c:592):Received header
0000 04 01 00 d5 00 00 00 00-                        |...Ă•....|

15:18:34.940129 10213 (net.c:671):Received packet
0000 e3 11 00 01 08 50 44 42-5f 41 46 49 33 06 6d 61 |ĂŁ....XXX 
_XXXX.ma|
0010 73 74 65 72 ab 3b 00 45-16 00 00 02 0a 27 00 43 |ster «;.E 
.....'.C|
0020 68 61 6e 67 65 64 20 64-61 74 61 62 61 73 65 20 |hanged d atabase 
|
0030 63 6f 6e 74 65 78 74 20-74 6f 20 27 50 44 42 5f |context  to 
'XXX_|
0040 41 46 49 33 27 2e 04 4a-44 42 43 05 5a 5a 5a 5a |XXXX'..J 
DBC.ZZZZ|
0050 5a 01 00 e3 0d 00 02 0a-75 73 5f 65 6e 67 6c 69 |Z..ĂŁ.... 
us_engli|
0060 73 68 00 ab 3d 00 47 16-00 00 01 0a 29 00 43 68 |sh. «=.G. 
....).Ch|
0070 61 6e 67 65 64 20 6c 61-6e 67 75 61 67 65 20 73 |anged la nguage 
s|
0080 65 74 74 69 6e 67 20 74-6f 20 27 75 73 5f 65 6e |etting t o 
'us_en|
0090 67 6c 69 73 68 27 2e 04-4a 44 42 43 05 5a 5a 5a |glish'.. 
JDBC.ZZZ|
00a0 5a 5a 01 00 e3 06 00 04-03 35 31 32 00 ad 14 00 |ZZ..ĂŁ... 
.512....|
00b0 01 00 00 00 00 0a 73 71-6c 20 73 65 72 76 65 72 |......sq l 
server|
00c0 01 00 00 01 fd 00 00 02-00 01 00 00 00          |....Ă˝... .....|

15:18:34.940504 10213 (token.c:316):looking for login token, got  
e3(ENVCHANGE)
15:18:34.940572 10213 (token.c:108):tds_process_default_tokens() marker 
is e3(ENVCHANGE)
15:18:34.940662 10213 (token.c:316):looking for login token, got  
ab(INFO)
15:18:34.940727 10213 (token.c:108):tds_process_default_tokens() marker 
is ab(INFO)
15:18:34.940796 10213 (token.c:2451):tds_process_msg() reading message 
from server

Any help for debugging or troubleshooting would be appreciated. I am 
using Perl to try to connect to the pool
so if there is some better solution in Perl for pooling solution please 
let me know.

/Ed

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

[prev in list] [next in list] [prev in thread] [next in thread] 