Skip to Content.
Sympa Menu

freetds - Re: Seg Faults talking to MS SQL 6.5

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Mark T. Johns" <xmtj AT rims.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Seg Faults talking to MS SQL 6.5
  • Date: Mon, 06 Mar 2000 16:17:07 -0600


Thank You very much! That did the trick.

BTW, that is one of the strangest work-arounds. How did you discover it?

Thanks, again,

-Mark

Francis Smit wrote:
>
> Oh I get that too, I'm going to MSSQL 7.0,
> same thing the work around is, to put a select
> in the sql, any old one will do, just so it returns
> a data set, one row or no rows are fine.
> i.e..
>
> $sql = "insert or such like\n";
> $sql .= "silly select I know will be quick\n";
>
> that should work fine, it does for me.
>
> Mark Johns wrote:
>
> > 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
> >
> > ---
> > You are currently subscribed to freetds as: francis AT oztel.com
> > To unsubscribe, forward this message to $subst('Email.Unsub')
>
> --
>
> Grisly . oo
> `oO
> Francis Smit
>
> Knowledge By Design/OzTel
> Suite 201, 683 George st
> Sydney 2000 NSW
>
> mailto:francis AT kbd.com.au
>
> Tel: +61 2 9212 1399
> Fax: +61 2 9212 5727
> ___________________________________
> m$: How can we stuff you up today?
>
> ---
> You are currently subscribed to freetds as: xmtj AT rims.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--
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