Skip to Content.
Sympa Menu

freetds - RE: [freetds] php/ASA connectivity troubleshooting

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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





Archive powered by MHonArc 2.6.24.

Top of Page