freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] php/ASA connectivity troubleshooting

From: "owen gottschalk" <owen AT barkingdogstudios.com>
To: <freetds AT lists.ibiblio.org>
Subject: RE: [freetds] php/ASA connectivity troubleshooting
Date: Wed, 22 Jan 2003 16:49:59 -0500

hello,

> > I am trying to use freetds to connect from a web server
> > running PHP to a
> You are correct, if I correctly understand "ASA" to be Sybase
> SQL Anywhere.

This is correct.

> You need TDS version 5.0, port 2638. You should at least be
> able to connect to the port with telnet. If you haven't

We are able to connect to the port with telnet.

> I wonder, what does your documentation say about, "ASA Error
> -75: Request to start/stop database denied"? That doesn't
> sound like a protocol problem....

I agree that it doesn't sound like a protocol problem, however the admin
of the server I am trying to connect to insists that everything on his
end is correct. Having no experience with Sybase databases, and no
access to any other sybase database, I am forced to take his word for
it.

> If you can telnet to the port but can't connect with tsql,
> and are sure it's not a permissions problem, please post a
> TDSDUMP log of the session (taking care to erase the
> passwords). If the server is responding abnormally, it
> should show up there.

Below is the TDSDUMP. Nothing looks abnormal, but if anyone has any
insight it would be greatly appreciated.

Thanks,

og

2003-01-16 16:26:43 Connecting addr XXX.XXX.XXX.XXX port 2638
Sending packet @ 2003-01-16 16:26:43
0000 02 00 02 00 00 00 00 00 6d 79 68 6f 73 74 00 00 |........m
yhost..|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |.........
.......|
0020 00 00 00 00 00 00 XX XX XX XX XX XX XX XX XX XX |.......XX
XXXXXXX|
0030 XX XX XX XX XX XX XX XX 00 00 00 00 00 00 00 00 |XXXXXXXX.
.......|
0040 00 00 00 00 00 XX XX XX XX XX XX XX XX XX XX 00 |......XXX
XXXXXX.|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |.........
.......|
0060 00 00 00 00 09 33 37 38 37 36 00 00 00 00 00 00 |.....3787
6......|
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 XX XX XX XX XX XX XX XX XX XX XX XX XX XX |...XXXXXX
XXXXXXX|
00c0 XX XX XX XX XX XX XX XX XX XX XX 00 00 00 00 00 |XXXXXXXXX
XX.....|
00d0 00 XX XX XX XX XX XX XX XX XX XX 00 00 00 00 00 |..XXXXXXX
XX.....|
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 09 04 02 00 00 54 44 53 2d 4c 69 62 72 61 72 |......TDS
-Librar|
01e0 0a 00 00 00 00 00 0d 11 75 73 5f 65 6e 67 6c 69 |........u
s_engli|
01f0 73 68 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |sh.......
.......|

Sending packet @ 2003-01-16 16:26:43
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 |......... ...|

2003-01-16 16:26:43 inside tds_process_login_tokens()
Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 ad |.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 0a 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 22 00 |".|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 06 |.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 0c 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 04 02 00 00 |....|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 18 |.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 20 00 00 00 00 |... ....|

Received packet @ 2003-01-16 16:26:43
0000 41 64 61 70 74 69 76 65 20 53 65 72 76 65 72 20 |Adaptive
Server |
0010 41 6e 79 77 68 65 72 65 |Anywhere|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 0c 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 07 00 00 00 |....|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 aa |.|

2003-01-16 16:26:43 inside tds_process_default_tokens() marker is aa
Received header @ 2003-01-16 16:26:43
0000 04 00 00 0a 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 40 00 |@.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 0c 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 74 17 00 00 |t...|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 00 |.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 0e |.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 0a 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 34 00 |4.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 3c 00 00 00 00 |...<....|

Received packet @ 2003-01-16 16:26:43
0000 41 53 41 20 45 72 72 6f 72 20 2d 37 35 3a 20 52 |ASA Error
-75: R|
0010 65 71 75 65 73 74 20 74 6f 20 73 74 61 72 74 2f |equest to
start/|
0020 73 74 6f 70 20 64 61 74 61 62 61 73 65 20 64 65 |stop data base
de|
0030 6e 69 65 64 |nied|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 00 |.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 00 |.|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 0a 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 00 00 |..|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 09 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 fd |.|

2003-01-16 16:26:43 inside tds_process_default_tokens() marker is fd
Received header @ 2003-01-16 16:26:43
0000 04 00 00 0a 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 02 00 |..|

Received header @ 2003-01-16 16:26:43
0000 04 00 00 0a 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 00 00 |..|

Received header @ 2003-01-16 16:26:43
0000 04 01 00 0c 00 00 00 00 |........|

Received packet @ 2003-01-16 16:26:43
0000 00 00 00 00 |....|

2003-01-16 16:26:43 leaving tds_process_login_tokens() returning 0

[freetds] php/ASA connectivity troubleshooting, owen gottschalk, 01/16/2003
- <Possible follow-up(s)>
- RE: [freetds] php/ASA connectivity troubleshooting, Lowden, James K, 01/16/2003
  - RE: [freetds] php/ASA connectivity troubleshooting, owen gottschalk, 01/22/2003
    - RE: [freetds] php/ASA connectivity troubleshooting, Brian Bruns, 01/22/2003