Skip to Content.
Sympa Menu

freetds - Seg Faults talking to MS SQL 6.5

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Mark Johns" <xmtj AT rims.com>
  • To: freetds
  • Subject: Seg Faults talking to MS SQL 6.5
  • Date: Mon, 6 Mar 2000 16:1:22


Here is the scoop:

We are experiencing problems with PHP, Apache, freeTDS, RH6.1, and MSSQL
6.5(NT4). We are able to connect, make SELECT queries, etc. Everything works
great. The problem happens when we execute an INSERT, or an UPDATE query. The
database on the remote system is updated correctly. However, the script
segfaults, and never returns. This happens when using normal connects or
persistent. I have attached a small script which exhibits this behaviour, and
the TDSDUMP output.

Please let me know what other information you may need.

=========== script =================
<html>
<body>
<?
# The following line contains the SQL server hostname, the username, and
# the password for connecting to the database.

$db2 = mssql_connect("cfs_back","daf","987654321")
or die("Unable to connect to MS SQL server");


# The next line says which database to use.

mssql_select_db("dupcsm",$db2)
or die("Unable to select database");

$result = mssql_query("Update Customer set Address_Line3='jjjjjjj' where
Customer_Id='80110'",$db2);

?>
<p>test<p>
</html>
</body>
========== end script ===============
========== dump log =================
Sending packet @ 2000-03-06 14:19:20
0000 02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
0020 00 00 00 00 00 00 00 64 61 66 00 00 00 00 00 00 |.......daf......|
0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
0040 00 00 00 00 00 03 39 38 37 36 35 34 33 32 31 00 |......987654321.|
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 |.....37876......|
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 50 48 50 20 33 2e 30 00 00 00 00 00 |....PHP 3.0.....|
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00b0 00 00 07 63 66 73 5f 62 61 63 6b 00 00 00 00 00 |...cfs_back.....|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00d0 00 08 39 38 37 36 35 34 33 32 31 00 00 00 00 00 |..987654321.....|
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 44 42 2d 4c 69 62 72 61 72 79 |......DB-Library|
01e0 0a 00 00 00 00 00 0d 11 00 00 00 00 00 00 00 00 |................|
01f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|


Sending packet @ 2000-03-06 14:19:20
0000 02 01 00 4c 00 00 00 00 00 00 00 00 00 00 00 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 |............|


2000-03-06 14:19:20 inside tds_process_login_tokens()
2000-03-06 14:19:20 inside tds_process_default_tokens() marker is e3
2000-03-06 14:19:20 inside tds_process_default_tokens() marker is ab
2000-03-06 14:19:20 inside tds_process_default_tokens() marker is e3
2000-03-06 14:19:20 inside tds_process_default_tokens() marker is fd
2000-03-06 14:19:20 leaving tds_process_login_tokens() returning 1
Sending packet @ 2000-03-06 14:19:20
0000 01 01 00 12 00 00 00 00 75 73 65 20 64 75 70 63 |........use dupc|
0010 73 6d |sm|


2000-03-06 14:19:20 processing result tokens. marker is e3
2000-03-06 14:19:20 inside tds_process_default_tokens() marker is e3
2000-03-06 14:19:20 processing result tokens. marker is ab
2000-03-06 14:19:20 processing result tokens. marker is fd
Sending packet @ 2000-03-06 14:19:20
0000 01 01 00 4d 00 00 00 00 55 70 64 61 74 65 20 43 |...M....Update C|
0010 75 73 74 6f 6d 65 72 20 73 65 74 20 41 64 64 72 |ustomer set Addr|
0020 65 73 73 5f 4c 69 6e 65 33 3d 27 6a 6a 6a 6a 6a |ess_Line3='jjjjj|
0030 6a 6a 27 20 77 68 65 72 65 20 43 75 73 74 6f 6d |jj' where Custom|
0040 65 72 5f 49 64 3d 27 38 30 31 31 30 27 |er_Id='80110'|


2000-03-06 1
============== end log ======================
(NOTE: The last line is precisely where the log stopped. it reads '2000-03-06
1')

Thanks You so much, for you assistance.

-Mark

--
Boycott Amazon.com: http://perl.oreilly.com/cgi-bin/amazon_patent.comments.pl
--
Mark T. Johns, Webmaster, RIMS - http://www.rims.com/
email: xmtj AT rims.com - BBS: http://rimsweb.rims.com/ubb/
voice: (630) 428-5389




Archive powered by MHonArc 2.6.24.

Top of Page