From owner-freebsd-database Wed Aug 2 1:59:16 2000 Delivered-To: freebsd-database@freebsd.org Received: from white.imgsrc.co.jp (ns.imgsrc.co.jp [210.226.20.2]) by hub.freebsd.org (Postfix) with ESMTP id E38A737C075 for ; Wed, 2 Aug 2000 01:59:11 -0700 (PDT) (envelope-from hanai@FreeBSD.org) Received: from black.imgsrc.co.jp (black.imgsrc.co.jp [210.226.20.130]) by white.imgsrc.co.jp (8.11.0/8.11.0) with ESMTP id e728x6s68329; Wed, 2 Aug 2000 17:59:06 +0900 (JST) Received: from darkmatter.imgsrc.co.jp (darkmatter.imgsrc.co.jp [210.226.20.149]) by black.imgsrc.co.jp (8.9.3/3.7Wpl2-SPOOL) with ESMTP id RAA53575; Wed, 2 Aug 2000 17:59:06 +0900 (JST) Received: from darkmatter.imgsrc.co.jp (localhost [127.0.0.1]) by darkmatter.imgsrc.co.jp (Postfix) with ESMTP id 8ED45A0C1; Wed, 2 Aug 2000 17:59:07 +0900 (JST) Date: Wed, 02 Aug 2000 17:59:07 +0900 Message-ID: <82u2d4f38k.wl@darkmatter.imgsrc.co.jp> From: Hiroyuki Hanai To: john@brann.org Cc: reinoud@xs4all.nl, freebsd-database@FreeBSD.org Subject: Re: Sybase (freebsd client) segfaults with 4.1-RC In-Reply-To: In your message of "28 Jul 2000 13:53:02 GMT" <20000728093031.A1813@freebie.brann.org> References: <20000727160727.A47289@freebie.brann.org> <3980d5af.323171@smtp.xs4all.nl> <20000728093031.A1813@freebie.brann.org> User-Agent: Wanderlust/1.1.1 (Purple Rain) SEMI/1.13.7 (Awazu) FLIM/1.13.2 (Kasanui) Emacs/20.6 (i386--freebsd) MULE/4.0 (HANANOEN) Organization: IMG SRC, Inc. MIME-Version: 1.0 (generated by SEMI 1.13.7 - "Awazu") Content-Type: text/plain; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi guys, > > >Unfortunately, all the programs segfault in the ct_connect call, either > > >coded directly in the ctlib examples, or in the generated code in the > > >esqlc cases. > > > > > >$>uname -r > > >4.1-RC > > > > > >Any ideas? > > > > No. I was already planning to look into 4.1 (RELEASE) asap. I will > > get back to you once I have a result... > > Oh well. Thanks anyway. > > FYI I am able to create this problem with both the static and shared versions > of the Sybase libraries. I also experienced the same problem with DBD-Sybase. I've investigated around and gotten the following results; The problem always occurs when we use any program which is linked with the FreeBSD native version of open client library on FreeBSD 4-stable or 5-current. However, this problem occurs only when a server and a client is on the same host. A client on FreeBSD 4-stable or 5-current can connect to the ASE server on any different host such as 3.4-RELEASE, 4-stable, 5-current and even Linux or Solaris with no error. On FreeBSD 3.4-RELEASE, there is no problem. It's very funny. I've being debugging using gdb and devlib, which is included in sybase-ocsd-10_0_4-FreeBSD-6_i386.tgz, but I've not be able to get any useful information so far. The problem may be in FreeBSD not the Sybase library? In summary, we should run a client on the different host from that a server is running on if we want to use FreeBSD 4 or 5. Does anyone has any other experiences or knowledge about this problem? Hiro Hanai To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Aug 2 2: 9:39 2000 Delivered-To: freebsd-database@freebsd.org Received: from ns.uninet.ee (ns.uninet.ee [194.204.0.1]) by hub.freebsd.org (Postfix) with ESMTP id 1E41937B85C; Wed, 2 Aug 2000 02:09:33 -0700 (PDT) (envelope-from taavi@uninet.ee) Received: by ns.uninet.ee (Postfix, from userid 1001) id 5A12E25826; Wed, 2 Aug 2000 11:09:30 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by ns.uninet.ee (Postfix) with SMTP id 4A92A14A1E; Wed, 2 Aug 2000 11:09:30 +0200 (EET) Date: Wed, 2 Aug 2000 11:09:30 +0200 (EET) From: Taavi Talvik To: Hiroyuki Hanai Cc: john@brann.org, reinoud@xs4all.nl, freebsd-database@FreeBSD.org Subject: Re: Sybase (freebsd client) segfaults with 4.1-RC In-Reply-To: <82u2d4f38k.wl@darkmatter.imgsrc.co.jp> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 2 Aug 2000, Hiroyuki Hanai wrote: > The problem always occurs when we use any program which > is linked with the FreeBSD native version of open client library on > FreeBSD 4-stable or 5-current. However, this problem occurs only when > a server and a client is on the same host. > > A client on FreeBSD 4-stable or 5-current can connect to the ASE > server on any different host such as 3.4-RELEASE, 4-stable, 5-current > and even Linux or Solaris with no error. > > On FreeBSD 3.4-RELEASE, there is no problem. Maybe playing with malloc options helps? ln -s 'Z' /etc/malloc.conf best regards, taavi ----------------------------------------------------------- Taavi Talvik | Internet: taavi@uninet.ee Unineti Andmeside AS | phone: +372 6405150 Ravala pst. 10 | fax: +372 6405151 Tallinn 10143, Estonia | To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Aug 2 6:46:25 2000 Delivered-To: freebsd-database@freebsd.org Received: from doorman.brann.org (remote-brann-gw.nyc.dsl.access.net [166.84.145.254]) by hub.freebsd.org (Postfix) with ESMTP id A5F7637BAF4; Wed, 2 Aug 2000 06:46:13 -0700 (PDT) (envelope-from john@brann.org) Received: from freebie.brann.org (freebie.brann.org [10.0.0.2]) by doorman.brann.org (8.9.2/8.8.5) with ESMTP id JAA10734; Wed, 2 Aug 2000 09:46:11 -0400 (EDT) Received: (from john@localhost) by freebie.brann.org (8.9.3/8.9.3) id JAA30095; Wed, 2 Aug 2000 09:46:11 -0400 (EDT) (envelope-from john) Date: Wed, 2 Aug 2000 09:46:10 -0400 From: John Brann To: Hiroyuki Hanai Cc: john@brann.org, reinoud@xs4all.nl, freebsd-database@FreeBSD.org Subject: Re: Sybase (freebsd client) segfaults with 4.1-RC Message-ID: <20000802094610.A30026@freebie.brann.org> References: <20000727160727.A47289@freebie.brann.org> <3980d5af.323171@smtp.xs4all.nl> <20000728093031.A1813@freebie.brann.org> <82u2d4f38k.wl@darkmatter.imgsrc.co.jp> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0i In-Reply-To: <82u2d4f38k.wl@darkmatter.imgsrc.co.jp>; from hanai@FreeBSD.org on Wed, Aug 02, 2000 at 05:59:07PM +0900 Organization: Not while I'm at home X-Operating-System: FreeBSD 4.1-STABLE Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, Aug 02, 2000 at 05:59:07PM +0900, Hiroyuki Hanai wrote: > Hi guys, > [...SNIP...] > > I also experienced the same problem with DBD-Sybase. > I've investigated around and gotten the following results; > > The problem always occurs when we use any program which > is linked with the FreeBSD native version of open client library on > FreeBSD 4-stable or 5-current. However, this problem occurs only when > a server and a client is on the same host. > > A client on FreeBSD 4-stable or 5-current can connect to the ASE > server on any different host such as 3.4-RELEASE, 4-stable, 5-current > and even Linux or Solaris with no error. > > On FreeBSD 3.4-RELEASE, there is no problem. > > It's very funny. > > I've being debugging using gdb and devlib, which is included in > sybase-ocsd-10_0_4-FreeBSD-6_i386.tgz, but I've not be able to get any > useful information so far. > The problem may be in FreeBSD not the Sybase library? > > In summary, we should run a client on the different host from that a > server is running on if we want to use FreeBSD 4 or 5. > > Does anyone has any other experiences or knowledge about this problem? > > Hiro Hanai This is very valuable information. It seems likely to me that the only difference between contacting a local or remote server is the use of LOCAL domain sockets instead of INTERNET domain. I'va grovelled over one of the failing programs in gdb and came up with the following: (gdb) whe #0 0x28106796 in Com__Netkey () from /scratch/sybase/lib/libsybtcl.so #1 0x2810c33d in netg_connect_callback () from /scratch/sybase/lib/libsybtcl.so #2 0x2810c2ce in net_connect () from /scratch/sybase/lib/libsybtcl.so #3 0x2807d7bf in np__conn_doconnect () from /scratch/sybase/lib/libct.so #4 0x280e42e5 in com__async_runstack () from /scratch/sybase/lib/libcomn.so #5 0x280e41e4 in com__async_poll_state () from /scratch/sybase/lib/libcomn.so #6 0x280e402a in com__async_do_poll () from /scratch/sybase/lib/libcomn.so #7 0x280e3acb in com_async_poll () from /scratch/sybase/lib/libcomn.so #8 0x28093f06 in ct__api_connect_async () from /scratch/sybase/lib/libct.so #9 0x280941d0 in ct_connect () from /scratch/sybase/lib/libct.so #10 0x804b320 in main () at example1.cp:60 #11 0x8048fa1 in _start () (gdb) stepi 0x2810679b in Com__Netkey () from /scratch/sybase/lib/libsybtcl.so (gdb) whe #0 0x2810679b in Com__Netkey () from /scratch/sybase/lib/libsybtcl.so #1 0x80 in ?? () #2 0x2810c2ce in net_connect () from /scratch/sybase/lib/libsybtcl.so #3 0x2807d7bf in np__conn_doconnect () from /scratch/sybase/lib/libct.so #4 0x280e42e5 in com__async_runstack () from /scratch/sybase/lib/libcomn.so #5 0x280e41e4 in com__async_poll_state () from /scratch/sybase/lib/libcomn.so #6 0x280e402a in com__async_do_poll () from /scratch/sybase/lib/libcomn.so #7 0x280e3acb in com_async_poll () from /scratch/sybase/lib/libcomn.so #8 0x28093f06 in ct__api_connect_async () from /scratch/sybase/lib/libct.so #9 0x280941d0 in ct_connect () from /scratch/sybase/lib/libct.so #10 0x804b320 in main () at example1.cp:60 #11 0x8048fa1 in _start () So that last instruction trashes the stack. Once Com__Netkey returns, the program segfaults. I'll try the server on a separate box, and see if that helps. John -- Unreal City, Under the brown fog of a winter dawn, finger john@doorman.brann.org for pgp public key To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Aug 2 6:49:12 2000 Delivered-To: freebsd-database@freebsd.org Received: from doorman.brann.org (remote-brann-gw.nyc.dsl.access.net [166.84.145.254]) by hub.freebsd.org (Postfix) with ESMTP id 7246A37B9AD; Wed, 2 Aug 2000 06:49:09 -0700 (PDT) (envelope-from john@brann.org) Received: from freebie.brann.org (freebie.brann.org [10.0.0.2]) by doorman.brann.org (8.9.2/8.8.5) with ESMTP id JAA10746; Wed, 2 Aug 2000 09:49:07 -0400 (EDT) Received: (from john@localhost) by freebie.brann.org (8.9.3/8.9.3) id JAA30125; Wed, 2 Aug 2000 09:49:07 -0400 (EDT) (envelope-from john) Date: Wed, 2 Aug 2000 09:49:07 -0400 From: John Brann To: XuYifeng Cc: Hiroyuki Hanai , john@brann.org, reinoud@xs4all.nl, freebsd-database@FreeBSD.ORG Subject: Re: Sybase (freebsd client) segfaults with 4.1-RC Message-ID: <20000802094907.B30026@freebie.brann.org> References: <20000727160727.A47289@freebie.brann.org><3980d5af.323171@smtp.xs4all.nl><20000728093031.A1813@freebie.brann.org> <82u2d4f38k.wl@darkmatter.imgsrc.co.jp> <004a01bffc64$7f3ebb50$1701a8c0@xu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0i In-Reply-To: <004a01bffc64$7f3ebb50$1701a8c0@xu>; from xuyf@stocke.com on Wed, Aug 02, 2000 at 05:31:15PM +0800 Organization: Not while I'm at home X-Operating-System: FreeBSD 4.1-STABLE Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, Aug 02, 2000 at 05:31:15PM +0800, XuYifeng wrote: > > did Sybase really test their client SDK on FBSD-STABLE 4.0? I doubt. > I can not build PHP4 with Sybase-CT, now I am still using > FreeTDS 0.5, it's solid. > > XuYifeng > I guess not. I tried to build sqsh - which uses freeTDS. I got errors like 'can't bind socket' - I didn't pursue it. I need the Sybase client libraries - I have some embedded SQL programs I want to build. John -- Unreal City, Under the brown fog of a winter dawn, finger john@doorman.brann.org for pgp public key To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Aug 3 9:10:38 2000 Delivered-To: freebsd-database@freebsd.org Received: from gg.burdadigital.com (mail.incubate.de [212.14.77.2]) by hub.freebsd.org (Postfix) with ESMTP id D04A237B51D for ; Thu, 3 Aug 2000 09:10:33 -0700 (PDT) (envelope-from iso@burdadigital.com) Received: by gg.burdadigital.com (8.9.3/8.9.3) id SAA01987 for freebsd-database@freebsd.org; Thu, 3 Aug 2000 18:12:25 +0200 (CEST) Received: (from localhost) by gg.burdadigital.com (MSCAN) id 2/gg.burdadigital.com/smtp-gw/mscan; Thu Aug 3 18:12:25 2000 From: Imdat Solak To: Subject: How to compile PHP4 with SYBASE Support and a DSO Apapche Module under FreeBSD3.4 Date: Thu, 3 Aug 2000 18:12:57 +0200 Message-Id: <20000803161257.26001@mail.bd.intern> X-Mailer: CTM PowerMail 3.0.4 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hello, after having tried a lot with Sybase DB- and CT-Libraries for FreeBSD, I managed to compile PHP4 with Sybase-Support for FreeBSD3.4 with freetds. It doesn't work with Sybase Native Libraries. If you are interested, I posted a doc here: http://www.imdat.de/php/ php4.html (english) and here: http://www.imdat.de/php/how_to_sybase.txt (in German) best imdat / iso@imdat.de OR iso@burdadigital.com -- Imdat Solak Burda Digital GmbH * Arabellastr. 23 * 81925 Munich * Germany iso@burdadigital.com * +49-89-9250-2714 * -2190 (fax) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Aug 3 11:41:39 2000 Delivered-To: freebsd-database@freebsd.org Received: from out3.mx.nwbl.wi.voyager.net (out3.mx.nwbl.wi.voyager.net [169.207.3.79]) by hub.freebsd.org (Postfix) with ESMTP id BA8B237B5B5 for ; Thu, 3 Aug 2000 11:41:32 -0700 (PDT) (envelope-from doug@polands.org) Received: from judah (d33.as1.appl.wi.voyager.net [169.207.126.161]) by out3.mx.nwbl.wi.voyager.net (8.9.3/8.9.3) with SMTP id NAA19479; Thu, 3 Aug 2000 13:41:26 -0500 From: "Doug Poland" To: "Imdat Solak" Cc: Subject: RE: How to compile PHP4 with SYBASE Support and a DSO Apapche Module under FreeBSD3.4 Date: Thu, 3 Aug 2000 13:41:26 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 In-Reply-To: <20000803161257.26001@mail.bd.intern> Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG > > after having tried a lot with Sybase DB- and CT-Libraries for FreeBSD, I > managed to compile PHP4 with Sybase-Support for FreeBSD3.4 with freetds. > It doesn't work with Sybase Native Libraries. > > If you are interested, I posted a doc here: http://www.imdat.de/php/ > php4.html (english) and here: http://www.imdat.de/php/how_to_sybase.txt > (in German) > > best > imdat / iso@imdat.de OR iso@burdadigital.com > > -- > Imdat Solak > Burda Digital GmbH * Arabellastr. 23 * 81925 Munich * Germany > iso@burdadigital.com * +49-89-9250-2714 * -2190 (fax) > Do you have Sybase, Apache, and php4 all running on the same FreeBSD 3.4 box? Regards, Doug To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Aug 3 19:20: 9 2000 Delivered-To: freebsd-database@freebsd.org Received: from gg.burdadigital.com (mail.incubate.de [212.14.77.2]) by hub.freebsd.org (Postfix) with ESMTP id 233AB37B99D for ; Thu, 3 Aug 2000 19:20:04 -0700 (PDT) (envelope-from iso@burdadigital.com) Received: by gg.burdadigital.com (8.9.3/8.9.3) id EAA04085; Fri, 4 Aug 2000 04:21:55 +0200 (CEST) Received: (from localhost) by gg.burdadigital.com (MSCAN) id 2/gg.burdadigital.com/smtp-gw/mscan; Fri Aug 4 04:21:55 2000 From: Imdat Solak To: Doug Poland , Subject: RE: How to compile PHP4 with SYBASE Support and a DSO Apapche Module under FreeBSD3.4 Date: Fri, 4 Aug 2000 04:22:30 +0200 Message-Id: <20000804022230.15017@mail.bd.intern> In-Reply-To: References: X-Mailer: CTM PowerMail 3.0.4 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Yes, actually both variants: Sybase running on the same box AND Sybase running on another box, I didn't try out yet to connect to a SQL-Server, but this also should work. I didn't try out other FreeBSD-Versions, yet, either. -- Imdat Solak Burda Digital GmbH * Arabellastr. 23 * 81925 Munich * Germany iso@burdadigital.com * +49-89-9250-2714 * -2190 (fax) On Thu, Aug 3, 2000, Doug Poland wrote: >> >> after having tried a lot with Sybase DB- and CT-Libraries for FreeBSD, I >> managed to compile PHP4 with Sybase-Support for FreeBSD3.4 with freetds. >> It doesn't work with Sybase Native Libraries. >> >> If you are interested, I posted a doc here: http://www.imdat.de/php/ >> php4.html (english) and here: http://www.imdat.de/php/how_to_sybase.txt >> (in German) >> >> best >> imdat / iso@imdat.de OR iso@burdadigital.com >> >> -- >> Imdat Solak >> Burda Digital GmbH * Arabellastr. 23 * 81925 Munich * Germany >> iso@burdadigital.com * +49-89-9250-2714 * -2190 (fax) >> > >Do you have Sybase, Apache, and php4 all running on the >same FreeBSD 3.4 box? > >Regards, >Doug > > >To Unsubscribe: send mail to majordomo@FreeBSD.org >with "unsubscribe freebsd-database" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Aug 4 1:46:48 2000 Delivered-To: freebsd-database@freebsd.org Received: from gg.burdadigital.com (mail.incubate.de [212.14.77.2]) by hub.freebsd.org (Postfix) with ESMTP id B73C737BA4E for ; Fri, 4 Aug 2000 01:46:44 -0700 (PDT) (envelope-from iso@burdadigital.com) Received: by gg.burdadigital.com (8.9.3/8.9.3) id KAA05057 for freebsd-database@FreeBSD.ORG; Fri, 4 Aug 2000 10:48:40 +0200 (CEST) Received: (from localhost) by gg.burdadigital.com (MSCAN) id 2/gg.burdadigital.com/smtp-gw/mscan; Fri Aug 4 10:48:39 2000 From: Imdat Solak To: Subject: Corrections on how to configure PHP4 with Sybase on FreeBSd Date: Fri, 4 Aug 2000 10:49:16 +0200 Message-Id: <20000804084916.12695@mail.bd.intern> X-Mailer: CTM PowerMail 3.0.4 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hello, I am sorry to have caused some inconvenience, but while still trying to figure out the obscure situation in httpd.conf in my yesterdays posting, I came to some new conclusions: CORRECTIONS AS OF 2000 08 04 I made a mistake while configuring my Apache. I still have the above mentioned i n my httpd.conf but also do the following: Before I start apache, I set the ENV-Variable SYBASE to the value "/usr/local/freetds/", yes, with the slash at the end. Sorry for any inconveniences.
Imdat, 2000-08-04 My page is already updated for this. -- Imdat Solak Burda Digital GmbH * Arabellastr. 23 * 81925 Munich * Germany iso@burdadigital.com * +49-89-9250-2714 * -2190 (fax) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message