Skip to Content.
Sympa Menu

freetds - [freetds] Trouble connection to TDS connection Pooling

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: freetds AT mittran.com
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Trouble connection to TDS connection Pooling
  • Date: Tue, 24 Apr 2012 08:27:27 -0500



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] Trouble connection to TDS connection Pooling, freetds, 04/24/2012

Archive powered by MHonArc 2.6.24.

Top of Page