Trouble connection to TDS connection Pooling
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds