FreeTDS Development Group

["Ben Vaughn" <bvaughn AT BlackbirdTech.com>]

James, 

        I must not have been clear -- The TDSDUMP file you are looking
at was generated by TDS from a PHP session.  In this case, appname is an
optional argument of the sybase_connect() function in PHP.  It should be
noted that appname and servername are different fields (if you look at
the hex.)  There appears to be no function within FreeTDS.conf to
specify the application name, or the server name (short of the resource
name.)  

Cheers, 
Ben 

------ 
Ben Vaughn 
Security Analyst 
Blackbird Technologies 
703-796-1438 W / 703-582-4551 C 
bvaughn AT blackbirdtech.com 
------ 
  

-----Original Message----- 
From: James K. Lowden [mailto:jklowden AT schemamania.org] 
Sent: Wednesday, July 16, 2003 07:18 
To: FreeTDS Development Group 
Subject: Re: [freetds] Sybase Incompatibilities? 


On Wed, 16 Jul 2003 18:37:19 -0400, "Ben Vaughn" 
<bvaughn AT BlackbirdTech.com> wrote: 
> Interesting...What does this line of the TDSDUMP file specify?  That's

> where I can see TDS submitting that info to the server. 

Indeed you do.  FreeTDS sent "appnameappnamea" in the app_name field of 
the login packet (see doc/tds.html for explication).  My breakdown of
your 
packet follows.  What I don't understand is, where FreeTDS decides to 
populate the app_name field with your servername as found in
freetds.conf. 
  

--jkl 

Header 
0000 02 00 02 00 00 00 00 00- 

   8   CHAR[30]    host_name 
     6d 61 6e 61 67 65 2e 70 |........ manage.p| 
0010 69 63 6b 65 74 2d 66 65-6e 63 65 2e 6f 72 67 00 |icket-fe nce.org.|

0020 00 00 00 00 00 00 

  38   INT8        host_name_length 
     17 
     
  39   CHAR[30]    user_name 
     69-64 73 6d 64 63 00 00 00 |.......u nameu...| 
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0040 00 00 00 00 00 

  69   INT8        user_name_length 
     06 
     
  70   CHAR[30]    password 
     43 31-73 43 30 43 31 73 43 30 |......pw pwpwpwpw| 
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0060 00 00 00 00 

 100   INT8        password_length 
     0a 
     
 101   CHAR[30]    host_process 
     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 

 131   INT8        host_process_length 
     05 
     
 132   ?           magic1[6]          /* mystery stuff */ 
     03 01 06 0a-09 01 
     
 138   INT8        bulk_copy 
     00 
     
 139   ?           magic2[9]          /* mystery stuff */ 
     00 00 00 00 00 |........ ........| 
0090 00 00 00 00 

 148   CHAR[30]    app_name 
     73 71 6c 63-6f 72 65 64 62 73 65 72 |....appn ameappna| 
00a0 76 65 72 00 00 00 00 00-00 00 00 00 00 00 00 00 |mea..... ........|

00b0 00 00 

 178   INT8        app_name_length 
     0f 
     
 179   CHAR[30]    server_name 
     69 64 73 6d 64-63 00 00 00 00 00 00 00 |...uname u.......| 
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

00d0 00 

 209   INT8        server_name_length 
     06 
     
_______________________________________________ 
FreeTDS mailing list 
FreeTDS AT lists.ibiblio.org 
http://lists.ibiblio.org/mailman/listinfo/freetds