From owner-freebsd-database Mon Feb 22 10: 5:59 1999 Delivered-To: freebsd-database@freebsd.org Received: from schizo.cdsnet.net (schizo.cdsnet.net [204.118.244.32]) by hub.freebsd.org (Postfix) with ESMTP id 2904F1131F for ; Mon, 22 Feb 1999 10:05:52 -0800 (PST) (envelope-from mrcpu@internetcds.com) Received: from localhost (mrcpu@localhost) by schizo.cdsnet.net (8.8.8/8.7.3) with SMTP id KAA25344 for ; Mon, 22 Feb 1999 10:00:16 -0800 (PST) Date: Mon, 22 Feb 1999 10:00:16 -0800 (PST) From: Jaye Mathisen X-Sender: mrcpu@schizo.cdsnet.net To: database@freebsd.org Subject: MS SQL server drivers (Perl/DBD, and JDBC) available Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk I sent this to a freebsd list because it met a need that we had with FreeBSD, and was developed with FreeBSD, although it's not FreeBSD-specific. Craig Spannring has developed a perl DBD/DBI driver that talks native TDS to a MS SQL server. It's alpha, but it certainly is meeting our needs at this time. We've only tested it against SQL Server 6.5, and Sybase under Linux (not under emulation yet, can't get that to work, natch). ftp://freetds.internetcds.com, and then you have to root around in there briefly. I've been using it under 3.1-stable with the stock perl, and it works peachy. Not all data types are supported yet, and there's some holes in it, if anybody wants to help us out with filling in some of the blanks, that would be great. (most noticeably, the lack of a TDS specification, so it's been reverse engineered by Craig as much as possible). He has also developed for us a (I believe I use the terminology correctly) type IV JDBC driver for SQL server. Feedback we've received shows it running faster than some commercial JDBC drivers at this time. It's available at the same URL. This driver is significantly more robust, but since I don't speak Java, the perl one has been developed as well. :) We're always interested in feedback on these drivers, and patches and fixes can't hurt either. Thanks for your time. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Feb 25 0:48:17 1999 Delivered-To: freebsd-database@freebsd.org Received: from clefw.ra.rockwell.com (clefw.ra.rockwell.com [192.159.76.15]) by hub.freebsd.org (Postfix) with ESMTP id C51FC14CC8 for ; Thu, 25 Feb 1999 00:48:14 -0800 (PST) (envelope-from mkes@ra.rockwell.com) Received: from raclesmtp01.cle.ra.rockwell.com (raclesmtp01.cle.ra.rockwell.com [130.151.192.220]) by clefw.ra.rockwell.com (8.9.3/8.9.3) with SMTP id DAA15022 for ; Thu, 25 Feb 1999 03:47:54 -0500 (EST) From: mkes@ra.rockwell.com Received: by raclesmtp01.cle.ra.rockwell.com(Lotus SMTP MTA v4.6.1 (569.2 2-6-1998)) id 85256723.003054EF ; Thu, 25 Feb 1999 03:47:54 -0500 X-Lotus-FromDomain: ROCKWELL To: freebsd-database@freebsd.org Message-ID: Date: Thu, 25 Feb 1999 09:56:13 +0100 Subject: problem with MySQL module for python under 3.0 Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Disposition: inline Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi all I have a box with 3.0 release. I have installed MySQL 3.21.33 and python 1.5.1 both from packages. I have downloaded MySQLmodule-1.4 which is a source (just one .c file) for python module allowing to access MySQL database. The README says: --------------- To build a dynamically loadable module without access to the python source tree, use (Trond Eivind Glomsr\xf8d): gcc -shared -I/usr/include/python1.5 -I/usr/local/include/mysql \ MySQLmodule.c -lmysqlclient -L/usr/lib/python1.5/config -lpython1.5 \ -o MySQLmodule.so and move the resulting MySQLmodule.so file into the PYTHONPATH. Again, substitute the proper locations of your include and library files. ---------------- Applied to my situation the command line was: gcc -shared -I/usr/local/include/python1.5 -I/usr/local/include/mysql \ MySQLmodule.c -L/usr/local/lib/mysql -lmysqlclient -L/usr/local/lib/python1.5/config -lpython1.5 \ -o MySQLmodule.so that is how I compiled the module and moved the resulting MySQLmodule.so to appropriate place. When I run python and try to use it the python crashes: ferda:/usr/home/mira> python Python 1.5.1 (#2, Oct 12 1998, 15:11:45) [GCC 2.7.2.1] on freebsd3 Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>> import MySQL Fatal Python error: PyThreadState_Get: no current thread Abort (core dumped) ferda:/usr/home/mira> If I do that under FreeBSD 2.6 release it works. So my guess is there something wrong with the compiler options a.out vs ELF, or .... I found some 3.0 & MySQL related notes saying: ------------------------------------ You have to configure with: --with-named-thread-libs=-lc_r The pthreads library for FreeBSD doesn't contain the sigwait function and there is some bugs in it. To fix this, get the `FreeBSD-3.0-libc_r-1.0.diff' file and apply this in the `/usr/src/lib/libc_r/uthread' directory. Follow after this the instructions that can be found with man pthread about how to recompile the libc_r library. You can test if you have a 'modern' libpthread.a with: > nm /usr/lib/libc_r.a | grep sigwait. If the above doesn't find sigwait you have to use the above patch and recompile libc_r. ---------------------------------- My experience with compiler options, libraries to link with etc. is not good enough to fix this. Can anybody give me a hint what's wrong? Thanks a lot Mira To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Feb 27 4:15: 6 1999 Delivered-To: freebsd-database@freebsd.org Received: from finland.ispro.net.tr (finland.ispro.net.tr [195.174.18.1]) by hub.freebsd.org (Postfix) with ESMTP id CD16914F29 for ; Sat, 27 Feb 1999 04:15:00 -0800 (PST) (envelope-from emiman@ispro.net.tr) Received: from localhost (emiman@localhost) by finland.ispro.net.tr (8.9.2/8.9.1) with ESMTP id OAA40793 for ; Sat, 27 Feb 1999 14:14:38 +0200 (EET) (envelope-from emiman@ispro.net.tr) Date: Sat, 27 Feb 1999 14:14:38 +0200 (EET) From: Ersin Miman X-Sender: emiman@localhost To: freebsd-database@FreeBSD.ORG Subject: ASP? Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk hi.. how can I work with ASP codes under FreeBSD? where can i find some documents about it? thanx Ersin Miman emiman@ispro.net.tr To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message