[freetds] ASA 7 Cannot Connect - Please Help!

Perren Smith perren at uoregon.edu
Fri Apr 23 17:49:35 EDT 2004


Hi All,

I'm trying to get some machines talking and I'm having no luck - here's what
I know:

Server:
ASA 7 - Windows 2000

Client (my webserver):
RedHat 8
FreeTDS 0.62.1 (current as of today)

I can connect using the supplied dbisql.exe application that comes with my
fine Sybase app.  Although I do need to specify the file location for the db
I want to connect to, e.g., c:\foo\moredir\mydb\mydb.db

I see no equivalent way to reference the db file location using FreeTDS.

Also, if I specify a db name I know exists in freetds.conf (let's say mydb)
tsql will hang if I use that db name as the server entry name with no log
ever being written:

[mydb]
	host = myserver.company.com
	port = 2638
	tds version = 5.0
	dump file = /tmp/tdsdump.txt

If I use the server name (not my db name) in freetds.conf then I get what we
see below (log contents at bottom):

[myservername]
	host = myserver.company.com
	port = 2638
	tds version = 5.0
	dump file = /tmp/tdsdump.txt

I am beyond stumped!!  Any pointers would be great - this is "mission
critical" that I talk with this @#$%@#% ASA server outside the scope of the
application that it was written for.

Thanks,

--Perren



Starting log file for FreeTDS 0.62.1
	on 2004-04-23 14:32:00 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
14:32:00.275087 tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
14:32:00.275284 Connecting to xxx.xxx.xxx.xxx port 2638, TDS 5.0.
Sending packet @ 14:32:00.276129
0000 02 00 02 00 00 00 00 00-6f 73 72 6c 77 65 62 00 |........ xxxxxxx.|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 07 65-64 69 74 6f 72 00 00 00 |.......x xxxxx...|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 06 34 5a-42 39 43 46 51 54 53 57 |......xx xxxxxxxx|
0050 50 50 30 00 00 00 00 00-00 00 00 00 00 00 00 00 |xxx..... ........|
0060 00 00 00 00 0d 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 00 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 63 61 74 69 00-00 00 00 00 00 00 00 00 |...cati. ........|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 04 00 0d 34 5a 42 39-43 46 51 54 53 57 50 50 |....xxxx xxxxxxxx|
00e0 30 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |x....... ........|
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 0f 05 00 00 00 54 44-53 2d 4c 69 62 72 61 72 |......TD S-Librar|
01e0 0a 05 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 @ 14:32:00.277624
0000 02 01 00 61 00 00 00 00-00 00 00 00 00 00 0a 00 |...a.... ........|
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-e2 16 00 01 09 00 00 06 |........ ........|
0050 6d 7f ff ff ff fe 02 09-00 00 00 00 0a 68 00 00 |m....... .....h..|
0060 00                     -                        |.|


14:32:00.278021 tds_process_login_tokens()
Received header @ 14:32:00.278714
0000 04 01 00 79 00 00 00 00-                        |...y....|


Received packet @ 14:32:00.278858
0000 ad 22 00 06 05 00 00 00-18 41 64 61 70 74 69 76 |."...... .Adaptiv|
0010 65 20 53 65 72 76 65 72-20 41 6e 79 77 68 65 72 |e Server  Anywher|
0020 65 06 00 00 00 e5 40 00-8f 03 00 00 00 10 05 30 |e..... at . .......0|
0030 38 57 31 30 00 00 00 2b-00 41 53 41 20 45 72 72 |8W10...+ .ASA Err|
0040 6f 72 20 2d 38 33 3a 20-53 70 65 63 69 66 69 65 |or -83:  Specifie|
0050 64 20 64 61 74 61 62 61-73 65 20 6e 6f 74 20 66 |d databa se not f|
0060 6f 75 6e 64 00 00 00 00-fd 02 00 00 00 00 00 00 |ound.... ........|
0070 00                     -                        |.|


14:32:00.279191 looking for login token, got  ad(LOGINACK)
tds_get_string: reading 24 from wire to give 24 to client.
14:32:00.279460 looking for login token, got  e5(EED)
14:32:00.279547 tds_process_default_tokens() marker is e5(EED)
tds_get_string: reading 43 from wire to give 43 to client.
14:32:00.280113 looking for login token, got  fd(DONE)
14:32:00.280205 tds_process_default_tokens() marker is fd(DONE)
14:32:00.280285 tds_process_end: more_results = 0
		was_cancelled = 0
		error = 1
		done_count_valid = 0
14:32:00.280453 tds_process_end() state set to TDS_IDLE
14:32:00.280528 leaving tds_process_login_tokens() returning 0
14:32:00.280997 tds_client_msg: #20014: "Login incorrect.".  Connection
state is now 2.  




More information about the FreeTDS mailing list