From owner-freebsd-database Mon Jul 15 8:54: 2 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4F41337B400 for ; Mon, 15 Jul 2002 08:54:01 -0700 (PDT) Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [213.84.24.58]) by mx1.FreeBSD.org (Postfix) with ESMTP id E2E6D43E3B for ; Mon, 15 Jul 2002 08:54:00 -0700 (PDT) (envelope-from reinoud@spoetnik.xs4all.nl) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id 26DB63E82; Mon, 15 Jul 2002 17:53:48 +0200 (CEST) Date: Mon, 15 Jul 2002 17:53:47 +0200 From: Reinoud van Leeuwen To: freebsd-database@FreeBSD.ORG Subject: sqsh (with FreeTDS) Message-ID: <20020715175347.X93816@spoetnik.xs4all.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i X-message-flag: Stop using Microsoft Outlook immediately Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hi, I am trying to connect to a Microsoft SQL server using sqsh and FreeTDS. Both the port version of sqsh (1.7) and the latest on sqsh.org coredump right after asking for a password. When looking in a ktrace it seems to go wrong wight after it has read the /etc/services (why does it need that?). Anyone got a succes on this? (or know another way to get results of a query on a Microsoft SQL server on a FreeBSD box?) TIA, Reinoud -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Jul 15 12:21:12 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2CF2937B400 for ; Mon, 15 Jul 2002 12:21:09 -0700 (PDT) Received: from mail.k12us.com (mail.k12us.com [65.112.222.15]) by mx1.FreeBSD.org (Postfix) with SMTP id 62BF243E6A for ; Mon, 15 Jul 2002 12:21:08 -0700 (PDT) (envelope-from cweimann@k12hq.com) Received: (qmail 59442 invoked by uid 1001); 15 Jul 2002 19:21:01 -0000 Date: Mon, 15 Jul 2002 15:21:01 -0400 From: Christopher Weimann To: Reinoud van Leeuwen Cc: freebsd-database@FreeBSD.ORG Subject: Re: sqsh (with FreeTDS) Message-ID: <20020715152101.B15062@mail.k12us.com> References: <20020715175347.X93816@spoetnik.xs4all.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20020715175347.X93816@spoetnik.xs4all.nl>; from reinoud.v@n.leeuwen.net on Mon, Jul 15, 2002 at 05:53:47PM +0200 X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG What do you have in /usr/local/etc/freetds/interfaces? On Mon, Jul 15, 2002 at 05:53:47PM +0200, Reinoud van Leeuwen wrote: > > Hi, > > I am trying to connect to a Microsoft SQL server using sqsh and FreeTDS. > Both the port version of sqsh (1.7) and the latest on sqsh.org coredump > right after asking for a password. When looking in a ktrace it seems to go > wrong wight after it has read the /etc/services (why does it need that?). > > Anyone got a succes on this? (or know another way to get results of a > query on a Microsoft SQL server on a FreeBSD box?) > > TIA, > Reinoud > > -- > __________________________________________________ > "Nothing is as subjective as reality" > Reinoud van Leeuwen reinoud.v@n.leeuwen.net > http://www.xs4all.nl/~reinoud > __________________________________________________ > > 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 Tue Jul 16 2:21:28 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 30B6137B400 for ; Tue, 16 Jul 2002 02:21:27 -0700 (PDT) Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [213.84.24.58]) by mx1.FreeBSD.org (Postfix) with ESMTP id AA08A43E31 for ; Tue, 16 Jul 2002 02:21:26 -0700 (PDT) (envelope-from reinoud@spoetnik.xs4all.nl) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id 0F09F3E83; Tue, 16 Jul 2002 11:21:14 +0200 (CEST) Date: Tue, 16 Jul 2002 11:21:14 +0200 From: Reinoud van Leeuwen To: Christopher Weimann Cc: freebsd-database@FreeBSD.ORG Subject: Re: sqsh (with FreeTDS) Message-ID: <20020716112114.Z93816@spoetnik.xs4all.nl> References: <20020715175347.X93816@spoetnik.xs4all.nl> <20020715152101.B15062@mail.k12us.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20020715152101.B15062@mail.k12us.com>; from cweimann@k12hq.com on Mon, Jul 15, 2002 at 03:21:01PM -0400 X-message-flag: Stop using Microsoft Outlook immediately Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Mon, Jul 15, 2002 at 03:21:01PM -0400, Christopher Weimann wrote: > > On Mon, Jul 15, 2002 at 05:53:47PM +0200, Reinoud van Leeuwen wrote: > > > > Hi, > > > > I am trying to connect to a Microsoft SQL server using sqsh and FreeTDS. > > Both the port version of sqsh (1.7) and the latest on sqsh.org coredump > > right after asking for a password. When looking in a ktrace it seems to go > > wrong wight after it has read the /etc/services (why does it need that?). > > > > Anyone got a succes on this? (or know another way to get results of a > > query on a Microsoft SQL server on a FreeBSD box?) > > What do you have in /usr/local/etc/freetds/interfaces? nothing, the interface definition is in /usr/local/etc/freetds.conf. (this file is read twice, when I look through ktrace output, and after the file is read, the MS SQL server is resolved in DNS). It goes wrong right after readning /etc/services (world readable, coredump even when I run sqsh as root) -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Jul 16 8:18: 3 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 884A337B400 for ; Tue, 16 Jul 2002 08:18:01 -0700 (PDT) Received: from mail.k12us.com (mail.k12us.com [65.112.222.15]) by mx1.FreeBSD.org (Postfix) with SMTP id AC06D43E31 for ; Tue, 16 Jul 2002 08:18:00 -0700 (PDT) (envelope-from cweimann@k12hq.com) Received: (qmail 60619 invoked by uid 1001); 16 Jul 2002 15:17:54 -0000 Date: Tue, 16 Jul 2002 11:17:54 -0400 From: Christopher Weimann To: Reinoud van Leeuwen Cc: freebsd-database@FreeBSD.ORG Subject: Re: sqsh (with FreeTDS) Message-ID: <20020716111754.A55365@mail.k12us.com> References: <20020715175347.X93816@spoetnik.xs4all.nl> <20020715152101.B15062@mail.k12us.com> <20020716112114.Z93816@spoetnik.xs4all.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20020716112114.Z93816@spoetnik.xs4all.nl>; from reinoud.v@n.leeuwen.net on Tue, Jul 16, 2002 at 11:21:14AM +0200 X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Tue, Jul 16, 2002 at 11:21:14AM +0200, Reinoud van Leeuwen wrote: > > > > What do you have in /usr/local/etc/freetds/interfaces? > > nothing, the interface definition is in /usr/local/etc/freetds.conf. (this > file is read twice, when I look through ktrace output, and after the file > is read, the MS SQL server is resolved in DNS). It goes wrong right after > readning /etc/services (world readable, coredump even when I run sqsh as > root) > Ah, you are using a newer FreeTDS than I am. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Jul 16 8:27:41 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7743337B401 for ; Tue, 16 Jul 2002 08:27:39 -0700 (PDT) Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [213.84.24.58]) by mx1.FreeBSD.org (Postfix) with ESMTP id EBB9543E6E for ; Tue, 16 Jul 2002 08:27:38 -0700 (PDT) (envelope-from reinoud@spoetnik.xs4all.nl) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id E2AC53E82; Tue, 16 Jul 2002 17:27:35 +0200 (CEST) Date: Tue, 16 Jul 2002 17:27:35 +0200 From: Reinoud van Leeuwen To: freebsd-database@FreeBSD.ORG Subject: Re: sqsh (with FreeTDS) Message-ID: <20020716172735.A14558@spoetnik.xs4all.nl> Mail-Followup-To: freebsd-database@FreeBSD.ORG References: <20020715175347.X93816@spoetnik.xs4all.nl> <20020715152101.B15062@mail.k12us.com> <20020716112114.Z93816@spoetnik.xs4all.nl> <20020716111754.A55365@mail.k12us.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20020716111754.A55365@mail.k12us.com>; from cweimann@k12hq.com on Tue, Jul 16, 2002 at 11:17:54AM -0400 X-message-flag: Warning! The sender of this mail thinks you should use a more secure email client. Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Tue, Jul 16, 2002 at 11:17:54AM -0400, Christopher Weimann wrote: > On Tue, Jul 16, 2002 at 11:21:14AM +0200, Reinoud van Leeuwen wrote: > > > > > > What do you have in /usr/local/etc/freetds/interfaces? > > > > nothing, the interface definition is in /usr/local/etc/freetds.conf. (this > > file is read twice, when I look through ktrace output, and after the file > > is read, the MS SQL server is resolved in DNS). It goes wrong right after > > readning /etc/services (world readable, coredump even when I run sqsh as > > root) > > > > Ah, you are using a newer FreeTDS than I am. Yes: 0.53 from a recent cvsupped port tree... Anyone else using this version? (if found another problem with new versions on http://docs.freebsd.org/cgi/getmsg.cgi?fetch=1768605+0+archive/2002/freebsd-ports/20020421.freebsd-ports ) -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jul 17 5:51:46 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DD0F537B400 for ; Wed, 17 Jul 2002 05:51:44 -0700 (PDT) Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [213.84.24.58]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5FB1843E58 for ; Wed, 17 Jul 2002 05:51:44 -0700 (PDT) (envelope-from reinoud@spoetnik.xs4all.nl) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id 52A7B3E82; Wed, 17 Jul 2002 14:51:41 +0200 (CEST) Date: Wed, 17 Jul 2002 14:51:40 +0200 From: Reinoud van Leeuwen To: freebsd-database@FreeBSD.ORG Subject: Re: sqsh (with FreeTDS) Message-ID: <20020717145140.B14558@spoetnik.xs4all.nl> Mail-Followup-To: freebsd-database@FreeBSD.ORG References: <20020715175347.X93816@spoetnik.xs4all.nl> <20020715152101.B15062@mail.k12us.com> <20020716112114.Z93816@spoetnik.xs4all.nl> <20020716111754.A55365@mail.k12us.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <20020716111754.A55365@mail.k12us.com>; from cweimann@k12hq.com on Tue, Jul 16, 2002 at 11:17:54AM -0400 X-message-flag: Warning! The sender of this mail thinks you should use a more secure email client. Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Tue, Jul 16, 2002 at 11:17:54AM -0400, Christopher Weimann wrote: > On Tue, Jul 16, 2002 at 11:21:14AM +0200, Reinoud van Leeuwen wrote: > > > > > > What do you have in /usr/local/etc/freetds/interfaces? > > > > nothing, the interface definition is in /usr/local/etc/freetds.conf. (this > > file is read twice, when I look through ktrace output, and after the file > > is read, the MS SQL server is resolved in DNS). It goes wrong right after > > readning /etc/services (world readable, coredump even when I run sqsh as > > root) > > > > Ah, you are using a newer FreeTDS than I am. "solved"! FreeTDS 0.51 works (with sqsh 2.1). I don't know why but it works for me. -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message