FreeTDS Development Group

[Shaun Craig <s.craig AT andronics.com>]

----------  Forwarded Message  ----------

Subject: connection pooling problems
Date: Thursday 28 October 2004 13:05
From: Shaun Craig <s.craig AT andronics.com>
To: "James K. Lowden" <jklowden AT schemamania.org>

hi, thanks for the previous reply to my message, think im having problems
before i can even point my clients at the connection pool server! i tried the
code below and attached the file dump for you to take a look at, pool is
empty, i cant seem to figure out the problem from the forum lists.

$ script pool.log
$ export TDSVER=4.2
$ tdspool mypool &
$ export TDSDUMP=dump
$ tsql ...

> your big query here
> go

[reply]

> exit

i can only get as far as tsql -S mypool -U sa - P [whateverpasswordis] then
get the following error message

accepting connection
waiting for a connect
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server
[1]+  Segmentation fault      tdspool mypool

i tried just connected straight to the MS SQL server and that works ok, i am
pretty sure i've set up freetds.conf and pool.conf correctly but i will show
you anyways just in case!

freetds.conf
globals not touched

[mypool]
        host = 127.0.0.1
        port = 5000
        tds version = 4.2
        dump file = /usr/local/etc/pool.log

[dbserver]
        host = [ip address] in here
        port = 1433
        tds version = 4.2
        dump file = /usr/local/etc/pool.log

pool.conf
globals not touched

[mypool]
        user = sa
        password = [whateverpasswordis]
        database = Leocate
        server = dbserver
        port = 5000
        dump file = /usr/local/etc/pool.log

thanks for your time and patience, you must get alot of stupid people like
myself bugging you steay!

rgd, Shaun

-------------------------------------------------------


Starting log file for FreeTDS 0.62.4
        on 2004-10-28 12:59:08 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "UTF-8" character set
12:59:08.421004 tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
12:59:08.421607 Connecting to 127.0.0.1 port 5000, TDS 4.2.
Sending packet @ 12:59:08.423551
0000 02 00 02 00 00 00 00 00-73 76 72 2d 73 75 73 65 |........ svr-suse|
0010 2d 31 38 00 00 00 00 00-00 00 00 00 00 00 00 00 |-18..... ........|
0020 00 00 00 00 00 00 0b 73-61 00 00 00 00 00 00 00 |.......s a.......|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 02 72 75-6c 65 72 00 00 00 00 00 |......ru ler.....|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 05 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 03 01 06 0a-09 01 00 00 00 00 02 00 |........ ........|
0090 00 00 00 00 54 53 51 4c-00 00 00 00 00 00 00 00 |....TSQL ........|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 04 6d 79 70 6f 6f-6c 00 00 00 00 00 00 00 |...mypoo l.......|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 06 72 75 6c 65 72 00-00 00 00 00 00 00 00 00 |..ruler. ........|
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 05 04 02 00 00 54 44-53 2d 4c 69 62 72 61 72 |......TD S-Librar|
01e0 0a 00 00 00 00 00 0d 11-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...... ........|


Sending packet @ 12:59:08.427692
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 75 74 66 |........ .....utf|
0020 38 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |8....... ........|
0030 00 00 00 00 00 00 00 00-00 00 00 04 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00-00 00 00 00             |........ ....|


12:59:08.428526 tds_process_login_tokens()
12:59:08.430071 goodread: errno=104, "Connection reset by peer"
12:59:08.431948 tds_client_msg: #20004: "Read from SQL server failed.".  
Connection state is now 0.  
12:59:08.432607 looking for login token, got  0()
12:59:08.433023 tds_process_default_tokens() marker is 0()
12:59:08.433338 leaving tds_process_default_tokens() connection dead
12:59:08.434687 tds_client_msg: #20014: "Login incorrect.".  Connection state 
is now 4.  
Received
 header @ 12:59:08.425527
0000 02 00 02 00 00 00 00 00-                        |........|


Received packet @ 12:59:08.425935
0000 73 76 72 2d 73 75 73 65-2d 31 38 00 00 00 00 00 |svr-suse -18.....|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 0b 73 |........ .......s|
0020 61 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |a....... ........|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 02 72 75 |........ ......ru|
0040 6c 65 72 00 00 00 00 00-00 00 00 00 00 00 00 00 |ler..... ........|
0050 00 00 00 00 00 00 00 00-00 00 00 00 05 33 37 38 |........ .....378|
0060 37 36 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |76...... ........|
0070 00 00 00 00 00 00 00 00-00 00 00 05 03 01 06 0a |........ ........|
0080 09 01 00 00 00 00 02 00-00 00 00 00 54 53 51 4c |........ ....TSQL|
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 04 6d 79 70 6f 6f |........ ...mypoo|
00b0 6c 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |l....... ........|
00c0 00 00 00 00 00 00 00 00-00 06 72 75 6c 65 72 00 |........ ..ruler.|
00d0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
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 05 04 02 00 00 54 44 |........ ......TD|
01d0 53 2d 4c 69 62 72 61 72-0a 00 00 00 00 00 0d 11 |S-Librar ........|
01e0 75 73 5f 65 6e 67 6c 69-73 68 00 00 00 00 00 00 |us_engli sh......|
01f0 00 00 00 00 00 00 00 00-                        |........|