From owner-freebsd-database Tue Dec 12 15:17:49 2000 From owner-freebsd-database@FreeBSD.ORG Tue Dec 12 15:17:39 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from fwall.in.markiza.sk (fwall.in.markiza.sk [195.168.51.114]) by hub.freebsd.org (Postfix) with ESMTP id A0FE537B400; Tue, 12 Dec 2000 15:17:33 -0800 (PST) Received: from oryon (oryon.in.markiza.sk [192.168.213.3] (may be forged)) by fwall.in.markiza.sk (8.11.1/8.11.1) with SMTP id eBCNHhS62066; Wed, 13 Dec 2000 00:17:45 +0100 (CET) (envelope-from vladislav.konecny@web.markiza.sk) From: "Vladislav Konecny" To: Cc: Subject: Intel STL2 in SC5000, segfaulted mysqld Date: Wed, 13 Dec 2000 00:17:05 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0015_01C0649A.062E1B40" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 In-Reply-To: <200012122231.eBCMVE353411@earth.backplane.com> Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG This is a multi-part message in MIME format. ------=_NextPart_000_0015_01C0649A.062E1B40 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit Hello all, I have big problem with MySQL 3.22.32 running on box with Intel STL2 motherboard with 2xP3/600 and 256MB RAM. This is standardly installed box with latest cvsup (12-12-2000) of stable branch 4.2-STABLE. Kernel is compiled with SMP and APIC_IO (as you can see in attachment). I start the mysql with safe_mysqld run script, and after 5-6 minutes daemon quits with message: Dec 13 00:10:07 db /kernel: pid 237 (mysqld), uid 0: exited on signal 11 (core dumped) ...and restart daemon from the script. Any idea to fix this? Vladislav Konecny technical director ------------------ www.markiza.sk, a.s. =m= 0903/268 523 =@= oryon@web.markiza.sk ------=_NextPart_000_0015_01C0649A.062E1B40 Content-Type: application/octet-stream; name="db" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="db" machine i386=0A= cpu I686_CPU=0A= ident db=0A= maxusers 32=0A= =0A= #makeoptions DEBUG=3D-g #Build kernel with gdb(1) debug symbols=0A= =0A= options MATH_EMULATE #Support for x87 emulation=0A= options INET #InterNETworking=0A= options FFS #Berkeley Fast Filesystem=0A= options FFS_ROOT #FFS usable as root device [keep this!]=0A= options SOFTUPDATES #Enable FFS soft updates support=0A= options MFS #Memory Filesystem=0A= options MD_ROOT #MD is a potential root device=0A= options NFS #Network Filesystem=0A= options MSDOSFS #MSDOS Filesystem=0A= options CD9660 #ISO 9660 Filesystem=0A= options CD9660_ROOT #CD-ROM usable as root, CD9660 required=0A= options PROCFS #Process filesystem=0A= options COMPAT_43 #Compatible with BSD 4.3 [KEEP THIS!]=0A= options SCSI_DELAY=3D10000 #Delay (in ms) before probing SCSI=0A= options USERCONFIG #boot -c editor=0A= options KTRACE #ktrace(1) support=0A= options SYSVSHM #SYSV-style shared memory=0A= options SYSVMSG #SYSV-style message queues=0A= options SYSVSEM #SYSV-style semaphores=0A= options P1003_1B #Posix P1003_1B real-time extensions=0A= options _KPOSIX_PRIORITY_SCHEDULING=0A= options ICMP_BANDLIM #Rate limit bad replies=0A= options KBD_INSTALL_CDEV # install a CDEV entry in /dev=0A= =0A= options SMP # Symmetric MultiProcessor Kernel=0A= options APIC_IO # Symmetric (APIC) I/O=0A= =0A= device isa=0A= device pci=0A= =0A= # Floppy drives=0A= device fdc0 at isa? port IO_FD1 irq 6 drq 2=0A= device fd0 at fdc0 drive 0=0A= =0A= # ATA and ATAPI devices=0A= device ata0 at isa? port IO_WD1 irq 14=0A= device ata1 at isa? port IO_WD2 irq 15=0A= device ata=0A= device atapicd # ATAPI CDROM drives=0A= options ATA_STATIC_ID #Static device numbering=0A= #options ATA_ENABLE_ATAPI_DMA #Enable DMA on ATAPI devices=0A= =0A= # SCSI Controllers=0A= device ahc # AHA2940 and onboard AIC7xxx devices=0A= =0A= # SCSI peripherals=0A= device scbus # SCSI bus (required)=0A= device da # Direct Access (disks)=0A= device pass # Passthrough device (direct SCSI access)=0A= =0A= # atkbdc0 controls both the keyboard and the PS/2 mouse=0A= device atkbdc0 at isa? port IO_KBD=0A= device atkbd0 at atkbdc? irq 1 flags 0x1=0A= device psm0 at atkbdc? irq 12=0A= =0A= device vga0 at isa?=0A= =0A= # syscons is the default console driver, resembling an SCO console=0A= device sc0 at isa? flags 0x100=0A= =0A= # Floating point support - do not disable.=0A= device npx0 at nexus? port IO_NPX irq 13=0A= =0A= device fxp # Intel EtherExpress PRO/100B (82557, 82558)=0A= =0A= # Pseudo devices - the number indicates how many units to allocated.=0A= pseudo-device loop # Network loopback=0A= pseudo-device ether # Ethernet support=0A= pseudo-device tun # Packet tunnel.=0A= pseudo-device pty # Pseudo-ttys (telnet etc)=0A= pseudo-device bpf #Berkeley packet filter=0A= =0A= options IPFIREWALL=0A= options IPFIREWALL_VERBOSE=0A= options TCP_RESTRICT_RST=0A= options ACCEPT_FILTER_DATA=0A= options MAXMEM=3D"(256*1024)"=0A= ------=_NextPart_000_0015_01C0649A.062E1B40-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Dec 12 15:34:23 2000 From owner-freebsd-database@FreeBSD.ORG Tue Dec 12 15:34:18 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mail2.uniserve.com (mail2.uniserve.com [204.244.156.10]) by hub.freebsd.org (Postfix) with ESMTP id 56EF037B400; Tue, 12 Dec 2000 15:34:17 -0800 (PST) Received: from shell.uniserve.ca ([204.244.186.218]) by mail2.uniserve.com with esmtp (Exim 3.13 #1) id 145yvq-000G66-00; Tue, 12 Dec 2000 15:34:02 -0800 Date: Tue, 12 Dec 2000 15:33:58 -0800 (PST) From: Tom X-Sender: tom@shell.uniserve.ca To: Vladislav Konecny Cc: freebsd-stable@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Intel STL2 in SC5000, segfaulted mysqld In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; CHARSET=US-ASCII Content-ID: Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 13 Dec 2000, Vladislav Konecny wrote: > Hello all, > > I have big problem with MySQL 3.22.32 running on box with Intel STL2 > motherboard with 2xP3/600 and 256MB RAM. This is standardly installed box > with latest cvsup (12-12-2000) of stable branch 4.2-STABLE. Kernel is > compiled with SMP and APIC_IO (as you can see in attachment). > I start the mysql with safe_mysqld run script, and after 5-6 minutes daemon > quits with message: > > Dec 13 00:10:07 db /kernel: pid 237 (mysqld), uid 0: exited on signal 11 > (core dumped) > > ...and restart daemon from the script. > > Any idea to fix this? See archives of freebsd-stable for a patch. It was posted about a week ago. It apparently fixes the problem, but apparently introduces a new compatibility problem with older binaries, so it has not be committed yet. Tom Uniserve To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Dec 13 17:12: 0 2000 From owner-freebsd-database@FreeBSD.ORG Wed Dec 13 17:11:57 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from phnxpop5.phnx.uswest.net (phnxpop5.phnx.uswest.net [206.80.192.5]) by hub.freebsd.org (Postfix) with SMTP id 3C02137B404 for ; Wed, 13 Dec 2000 17:11:57 -0800 (PST) Received: (qmail 1669 invoked by uid 0); 14 Dec 2000 01:11:55 -0000 Received: from lnodslppp18.uswest.net.phnx.uswest.net (HELO joaquinhr) (63.226.8.18) by phnxpop5.phnx.uswest.net with SMTP; 14 Dec 2000 01:11:55 -0000 Date: Wed, 13 Dec 2000 18:16:02 -0700 Message-ID: <001701c0656b$6cc798a0$0300000a@joaquinhr> From: "=?iso-8859-1?Q?Joaqu=EDn_Hern=E1ndez_Rico?=" To: freebsd-database@FreeBSD.ORG Cc: "Imdat Solak" References: <20000803161257.26001@mail.bd.intern> <19340821093947.27766@mail.bd.intern> Subject: PHP4 accessing Sybase with freetds MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Well, before I give up and try to Compile PHP from sources, I want to give the fBSD ports and myself one more chance: On a FreeBSD 4.1-Stable box, I tried installing Apache and PHP (3 _and_ 4) with Sybase support from both the CD Packages and the Ports collection. Both of these installation methods use FreeTDS. I have checked and rechecked all the different configuration files and everything seems to be in order, but when I try to connect to our Sybase 7.0 database at work, I get an "invalid marker: 0!!" error message. This happens even when using "sqsh", except that when the connection is attempted by PHP, the error message goes into the /var/log/httpd-errors.log file. Apparently, PHP keeps trying to connect indefinitely, for the log file grows until it fills the space available in the partition where /var is mounted(100 Mb). Has anyone experienced this? I guess my next step will be to get the source code for FreeTDS, PHP and maybe even Apache and compile it. Then if that still does not work, I'll get the now available Sybase FreeBSD distribution... Any information will be greatly appreciated! Thanks in advance, Joaquín Hernández Rico ____________________________________________________________________________ ________ The Computer is mightier than the sword, the pen and, usually, the programmer. joaquinh01@uswest.net ----- Original Message ----- From: "Imdat Solak" To: Cc: Sent: Tuesday, September 26, 2000 9:08 AM Subject: Bug in PHP4 accessing Sybase with freetds > Hello, > > couple of people reported that there is a bug accessing Sybase by > using PHP4.0.1pl1 with freetds on FreeBSD 3.4 with Apache. > > Namely, Apache crashes with a "Segmentation fault" when you do a > DELETE, INSERT or UPDATE in the Sybase DB. > > The crash happens only after successfull DELETE, INSERT or UPDATE > statements, i.e. if there was a DB-error (cannot delete, insert > or update), then Apache doesn't crash. > > I followed the bug and found first a workaround and second a solution, > which works on my site. > > As not everybody is interested in this topic, I put the doc describing > the solution on my site: > > http://www.imdat.de/php/sybase_php_freetds_bug.txt > > I will send this to PHP.NET and to the freetds-guys, too, as the bug > is in both, freetds AND php4 (I also checked PHP4.0.2, it still has > the same bug). > > Hope to have helped > best > imdat > -- > 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 > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Dec 13 23:34:32 2000 From owner-freebsd-database@FreeBSD.ORG Wed Dec 13 23:34:31 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from web10008.mail.yahoo.com (web10008.mail.yahoo.com [216.136.130.44]) by hub.freebsd.org (Postfix) with SMTP id 1F62137B400 for ; Wed, 13 Dec 2000 23:34:31 -0800 (PST) Message-ID: <20001214073431.74630.qmail@web10008.mail.yahoo.com> Received: from [212.19.130.5] by web10008.mail.yahoo.com; Wed, 13 Dec 2000 23:34:31 PST Date: Wed, 13 Dec 2000 23:34:31 -0800 (PST) From: Gleb Shegai Subject: Perl <-> Oracle To: freebsd-database@FreeBSD.ORG MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi ppl! Does anybody know how to make a perl-script running on a FreeBSD-box to communicate with an Oracle database running on a different server (Sun Solaris)? I've tried to install DBI/DBD modules but broke. :( This must be a simple question but I cannot do this! Any help would be really appreciated! Gleb. __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 14 0: 2:16 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 00:02:15 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from iclub.nsu.ru (iclub.nsu.ru [193.124.222.66]) by hub.freebsd.org (Postfix) with ESMTP id 422E737B402 for ; Thu, 14 Dec 2000 00:02:10 -0800 (PST) Received: from localhost (fjoe@localhost) by iclub.nsu.ru (8.11.1/8.11.1) with ESMTP id eBE7tpr29742; Thu, 14 Dec 2000 13:55:51 +0600 (NS) (envelope-from fjoe@iclub.nsu.ru) Date: Thu, 14 Dec 2000 13:55:50 +0600 (NS) From: Max Khon To: Gleb Shegai Cc: freebsd-database@FreeBSD.ORG Subject: Re: Perl <-> Oracle In-Reply-To: <20001214073431.74630.qmail@web10008.mail.yahoo.com> 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 hi, there! On Wed, 13 Dec 2000, Gleb Shegai wrote: > Does anybody know how to make a perl-script running on > a FreeBSD-box to communicate with an Oracle database > running on a different server (Sun Solaris)? I've > tried to install DBI/DBD modules but broke. :( > This must be a simple question but I cannot do this! > Any help would be really appreciated! how you tried to build DBI/DBD? native OCI is available at: ftp://iclub.nsu.ru/pub/FreeBSD/incoming/OCI.freebsd.elf.tar.gz /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 14 2:50:39 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 02:50:37 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from smtp10.xs4all.nl (smtp10.xs4all.nl [194.109.6.54]) by hub.freebsd.org (Postfix) with ESMTP id AB3C037B400 for ; Thu, 14 Dec 2000 02:50:33 -0800 (PST) Received: from webmail1.xs4all.nl (webmail1.xs4all.nl [194.109.127.31]) by smtp10.xs4all.nl (8.11.0/8.11.0) with ESMTP id eBEAnbL29220 for ; Thu, 14 Dec 2000 11:49:37 +0100 (CET) Received: by webmail1.xs4all.nl (8.9.3/8.9.3) id LAA16440; Thu, 14 Dec 2000 11:36:06 +0100 (CET) Date: Thu, 14 Dec 2000 11:36:06 +0100 (CET) Message-Id: <200012141036.LAA16440@webmail1.xs4all.nl> X-Authentication-Warning: webmail1.xs4all.nl: reinoud set sender to reinoud@xs4all.nl using -f From: Reinoud van Leeuwen To: freebsd-database@FreeBSD.ORG References: <20000803161257.26001@mail.bd.intern> <19340821093947.27766@mail.bd.intern> <001701c0656b$6cc798a0$0300000a@joaquinhr> In-Reply-To: <001701c0656b$6cc798a0$0300000a@joaquinhr> MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: IMP/PHP3 Imap webMail Program 2.0.0-xs4all Subject: Re: PHP4 accessing Sybase with freetds Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Quoting =?iso-8859-1?Q?Joaqu=EDn_Hern=E1ndez_Rico?= : > Well, before I give up and try to Compile PHP from sources, I want to > give > the fBSD ports and myself one more chance: > > On a FreeBSD 4.1-Stable box, I tried installing Apache and PHP (3 _and_ 4) > with Sybase support from both the CD Packages and the Ports collection. > Both > of these installation methods use FreeTDS. I have checked and rechecked > all the different configuration files and everything seems to be in order, > but when I try to connect to our Sybase 7.0 database at work, I get an > "invalid marker: 0!!" error message. This happens even when using > "sqsh", When you say Sybase 7.0 yuo probably mean Sybase Anywhere 7.0. I do not nkow abuot the current relases, but it used to be the case that Sybase Anywhere and Sybase Enterprise had different clients. FreeTSD is an implementation of the Open Client, which is meant to connect to Sybase Enterprise. You can test this by trying to connect to the database from another Open CLient. If that works, it might be supported these days. > except that when the connection is attempted by PHP, the error message goes > into the /var/log/httpd-errors.log file. Apparently, PHP keeps trying to > connect indefinitely, for the log file grows until it fills the space > available in the partition where /var is mounted(100 Mb). Has anyone > experienced this? > > I guess my next step will be to get the source code for FreeTDS, PHP and > maybe even Apache and compile it. Then if that still does not work, I'll > get the now available Sybase FreeBSD distribution... I have not succeeded getting the native FreeBSD Sybase libraries to build anything like PHP of SybPerl on a 4.x FreeBSD box. It might have to do with the fact that FreeBSD 3.x emulates Redhat 5.x and FreeBSD 4.x emulates redHat 6.x but I am not sure... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 14 3:55: 4 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 03:54:57 2000 Return-Path: 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 7CC9137B400 for ; Thu, 14 Dec 2000 03:54:55 -0800 (PST) Received: by gg.burdadigital.com (8.9.3/8.9.3) id MAA20181 for freebsd-database@freebsd.org; Thu, 14 Dec 2000 12:57:29 +0100 (CET) Received: (from localhost) by gg.burdadigital.com (MSCAN) id 2/gg.burdadigital.com/smtp-gw/mscan; Thu Dec 14 12:57:29 2000 User-Agent: Microsoft-Entourage/9.0.2509 Date: Thu, 14 Dec 2000 12:54:02 +0100 Subject: Re: PHP4 accessing Sybase with freetds From: Imdat Solak To: Message-ID: In-Reply-To: <200012141036.LAA16440@webmail1.xs4all.nl> Mime-version: 1.0 X-Company: Burda Digital GmbH Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 12/14/00 11:36 AM, "Reinoud van Leeuwen" wrote: >> except that when the connection is attempted by PHP, the error message goes >> into the /var/log/httpd-errors.log file. Apparently, PHP keeps trying to >> connect indefinitely, for the log file grows until it fills the space >> available in the partition where /var is mounted(100 Mb). Has anyone >> experienced this? >> >> I guess my next step will be to get the source code for FreeTDS, PHP and >> maybe even Apache and compile it. Then if that still does not work, I'll >> get the now available Sybase FreeBSD distribution... > > I have not succeeded getting the native FreeBSD Sybase libraries to build > anything like PHP of SybPerl on a 4.x FreeBSD box. It might have to do with > the > fact that FreeBSD 3.x emulates Redhat 5.x and FreeBSD 4.x emulates redHat 6.x > but I am not sure... > The FreeBSD Sybase Libraries don't work, AFAIK, I tried and it didn't work at all. The freetds implementation worked fine for me, there are couple of bugs, but it works, although I am only using it in conjunction with PHP4 and Apache. If you need further info (and how to set it up), please have a look at http://www.imdat.de/php/php4.html and at http://www.imdat.de/php/sybase_php_freetds_bug.txt I don't want to post the doc here as it's kind of long Best Imdat iso@imdat.de To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 14 6:36: 7 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 06:36:03 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from phnxpop2.phnx.uswest.net (phnxpop2.phnx.uswest.net [206.80.192.2]) by hub.freebsd.org (Postfix) with SMTP id 265B137B402 for ; Thu, 14 Dec 2000 06:36:03 -0800 (PST) Received: (qmail 52532 invoked by uid 0); 14 Dec 2000 14:35:59 -0000 Received: from lnodslppp18.uswest.net.phnx.uswest.net (HELO joaquinhr) (63.226.8.18) by phnxpop2.phnx.uswest.net with SMTP; 14 Dec 2000 14:35:59 -0000 Date: Thu, 14 Dec 2000 07:40:11 -0700 Message-ID: <003a01c065db$c3575e60$0300000a@joaquinhr> From: "=?iso-8859-1?Q?Joaqu=EDn_Hern=E1ndez_Rico?=" To: freebsd-database@freebsd.org References: Subject: Re: PHP4 accessing Sybase with freetds MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG > > I have not succeeded getting the native FreeBSD Sybase libraries to build > > anything like PHP of SybPerl on a 4.x FreeBSD box. It might have to do with > > the > > fact that FreeBSD 3.x emulates Redhat 5.x and FreeBSD 4.x emulates redHat 6.x > > but I am not sure... > > The FreeBSD Sybase Libraries don't work, AFAIK, I tried and it didn't work at all. Do you remember what kind of error messages you were getting? > The freetds implementation worked fine for me, there are couple of bugs, but > it works, although I am only using it in conjunction with PHP4 and Apache. > If you need further info (and how to set it up), please have a look at > http://www.imdat.de/php/php4.html and at > http://www.imdat.de/php/sybase_php_freetds_bug.txt Thanks, I had seen your instructions before, very helpful... Reinoud, your assumption is correct, it is Sybase Anywhere 7.0. Previously, I had followed Imdat's instructions as far as the various configuration files. Today I will try starting at the beginning... Unfortunately, our DBA is not the most cooperative individual and he is rather NT-centric... but I know there has to be an ''accessible" way of communicating with SA from fBSD, for the data-gathering part of our system runs on QNX... I with give it another try, and if you are interested, I will post my findings.... Thank you, Joaquin Hernandez-Rico ____________________________________________________________________________ ________ The Computer is mightier than the sword, the pen and, usually, the programmer. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 14 7:24:16 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 07:24:12 2000 Return-Path: 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 D13FB37B400 for ; Thu, 14 Dec 2000 07:24:11 -0800 (PST) Received: (from root@localhost) by gg.burdadigital.com (8.9.3/8.9.3) id QAA21492; Thu, 14 Dec 2000 16:26:16 +0100 (CET) Received: (from localhost) by gg.burdadigital.com (MSCAN) id 2/gg.burdadigital.com/smtp-gw/mscan; Thu Dec 14 16:26:16 2000 User-Agent: Microsoft-Entourage/9.0.2509 Date: Thu, 14 Dec 2000 16:22:22 +0100 Subject: Re: PHP4 accessing Sybase with freetds From: Imdat Solak To: Joaqu=?ISO-8859-1?B?7W4gSGVybuE=?=ndez Rico , Message-ID: Mime-version: 1.0 X-Company: Burda Digital GmbH Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 12/14/00 3:40 PM, "Joaqu=EDn Hern=E1ndez Rico" wrote= : >>> I have not succeeded getting the native FreeBSD Sybase libraries to > build >>> anything like PHP of SybPerl on a 4.x FreeBSD box. It might have to do > with >>> the >>> fact that FreeBSD 3.x emulates Redhat 5.x and FreeBSD 4.x emulates > redHat 6.x >>> but I am not sure... >>=20 >> The FreeBSD Sybase Libraries don't work, AFAIK, I tried and it didn't wo= rk > at all. >=20 > Do you remember what kind of error messages you were getting? Hmmm, not really, something like "Cannot connect" or so, as I try to remember. =20 > Thanks, I had seen your instructions before, very helpful... >=20 > Reinoud, your assumption is correct, it is Sybase Anywhere 7.0. > Previously, I had followed Imdat's instructions as far as the various > configuration files. Today I will try starting at the beginning... >=20 I never tried it with SA, only Adaptive 11.x > Unfortunately, our DBA is not the most cooperative individual and he is > rather NT-centric... but I know there has to be an ''accessible" way of > communicating with SA from fBSD, for the data-gathering part of our syste= m > runs on QNX... >=20 With the freetds implementation, you can also connect to M$ SQL-Server (jus= t a note ;-) > I with give it another try, and if you are interested, I will post my > findings.... >=20 Yes, of course,please do so. Oh wait! I re-read your mail before: You say you get "invalid marker: 0!", right? That's perfectly okay, AFAIK, as freetds does NOT support all TDS markers, which are in the newest TDS (7? 5? Ah egad, I forgot ;-) What you do to get rid of it is the following: Comment out the following line: /src/tds/token.c:134 For me it was: [SOME OTHER CODE] case TDS_COL_INFO_TOKEN: tds_process_col_info(tds); break;=20 case TDS_CMP_ROW_TOKEN: tds_process_compute(tds); break;=20 case TDS_ROW_TOKEN: tds_process_row(tds); break; default: // fprintf(stderr,"Unknown marker: %d!!\n",marker); /* <- THIS LINE */ return 0; } } =20 /*=20 ** tds_process_login_tokens() is called after sending the login packet ** to the server. It returns the success or failure of the login ** dependent on the protocol version. 4.2 sends an ACK token only when ** successful, TDS 5.0 sends it always with a success byte within */ int tds_process_login_tokens(TDSSOCKET *tds) [SOME FOLLOWING CODE] This did not change anything for me, it works fine, except that I don't get this message any more. I figure, that I could just ignore this (well I don'= t really know all the side effects, so therefore, please let me know if you find any side effects). Now, after reading the freetds0.5 README again, I found out following: [--- COPIED OUT OF `README' ---] FreeTDS will run at protocol versions 4.2, 4.6, or 5.0 and thus can access both Sybase and Microsoft SQL-Servers. Note: Microsoft SQL servers do not support TDS versions above 4.2 and need to be configured with the --with-tdsver=3D4.2 flag. Experimental support for TDS 7.0 (the version used by MS SQL Server 7.0) is now included. It works for me but beyond that I can't promise much. That said,TDS 7.0 support can be configured by using the --with-tdsver=3D7.0 when running configure. [--- END COPIED OUT OF `README' ---] Please check if SA uses TDS 7.0, if so, please have a look at supporting TDS7.0 (s. Above). I hope this helps Best Imdat iso@imdat.de /// --=20 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 Dec 14 9:24:30 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 09:24:29 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id BD78C37B6AA for ; Thu, 14 Dec 2000 09:24:27 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 146bQn-0003gi-00; Thu, 14 Dec 2000 08:40:33 -0800 Date: Thu, 14 Dec 2000 08:40:31 -0800 (PST) From: Tom Samplonius To: Reinoud van Leeuwen Cc: freebsd-database@FreeBSD.ORG Subject: Re: PHP4 accessing Sybase with freetds In-Reply-To: <200012141036.LAA16440@webmail1.xs4all.nl> 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 Thu, 14 Dec 2000, Reinoud van Leeuwen wrote: > I have not succeeded getting the native FreeBSD Sybase libraries to build > anything like PHP of SybPerl on a 4.x FreeBSD box. It might have to do with the > fact that FreeBSD 3.x emulates Redhat 5.x and FreeBSD 4.x emulates redHat 6.x > but I am not sure... The FreeBSD Sybase libraries are FreeBSD, not Linux libs, so emulation is not an issue. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 14 11:15:56 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 11:15:54 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from nietzsche.webcaribe.net (unknown [209.88.252.106]) by hub.freebsd.org (Postfix) with ESMTP id 034E137B400 for ; Thu, 14 Dec 2000 11:15:47 -0800 (PST) Received: from localhost (operador@localhost) by nietzsche.webcaribe.net (8.9.3/8.9.3) with ESMTP id OAA00518 for ; Thu, 14 Dec 2000 14:16:34 -0500 (COT) (envelope-from operador@nietzsche.webcaribe.net) Date: Thu, 14 Dec 2000 14:16:34 -0500 (COT) From: Operador del sistema To: freebsd-database@FreeBSD.org Subject: Unable to start mysqld on 3-stable 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 Hi, I installed mysql 3.22.23 from the 3-stable package's and the start script is not able to start the daemon. The script (/usr/local/etc/rc.d/mysql-server.sh) runs suceffully, but the daemon (mysqld) exists inmediatly. any ideas? i'm on FreeBSD -3.5-stable ----- WebCaribe: La presencia Web de la costa caribe Departamento de sistemas Calle 81 # 67 - 36 L2 - Barranquilla - Colombia Tel: 57-5-3789671/3789167 - http://www.webcaribe.net To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Dec 14 15:36: 1 2000 From owner-freebsd-database@FreeBSD.ORG Thu Dec 14 15:35:57 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from phnxpop5.phnx.uswest.net (phnxpop5.phnx.uswest.net [206.80.192.5]) by hub.freebsd.org (Postfix) with SMTP id CA84737B400 for ; Thu, 14 Dec 2000 15:35:56 -0800 (PST) Received: (qmail 44717 invoked by uid 0); 14 Dec 2000 23:35:56 -0000 Received: from lnodslppp18.uswest.net.phnx.uswest.net (HELO joaquinhr) (63.226.8.18) by phnxpop5.phnx.uswest.net with SMTP; 14 Dec 2000 23:35:56 -0000 Date: Thu, 14 Dec 2000 16:40:12 -0700 Message-ID: <002401c06627$33b48480$0300000a@joaquinhr> From: "=?iso-8859-1?Q?Joaqu=EDn_Hern=E1ndez_Rico?=" To: freebsd-database@freebsd.org References: Subject: Re: PHP4 accessing Sybase with freetds MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG ----- Original Message ----- >On 12/14/00 3:40 PM, "Joaquín Hernández Rico" wrote: > >Oh wait! I re-read your mail before: You say you get "invalid marker: 0!", >right? That's perfectly okay, AFAIK, as freetds does NOT support all TDS >markers, which are in the newest TDS (7? 5? Ah egad, I forgot ;-) What you >do to get rid of it is the following: > >Comment out the following line: >/src/tds/token.c:134> >This did not change anything for me, it works fine, except that I don't get >this message any more. I figure, that I could just ignore this (well I don't >really know all the side effects, so therefore, please let me know if you >find any side effects). Now that looks like what I need!!!! >[--- COPIED OUT OF `README' ---] > FreeTDS will run at protocol versions 4.2, 4.6, or 5.0 and thus can >access both Sybase and Microsoft SQL-Servers. Note: Microsoft SQL servers >do not support TDS versions above 4.2 and need to be configured with >the --with-tdsver=4.2 flag. >[--- END COPIED OUT OF `README' ---] >Imdat >iso@imdat.de /// Originally, I was installing FreeTDS from the Ports Collection, so I do not think it was using the "--with-tdsver=" option. Today I got all the source code and already have TDS installed using it. However I got busy doing some other stuff and did not have a chance to compile the PHP module. I'll be out of town for a few days, so I probably won't get around to doing it until toward the end of next week... Maybe after the short vacation I'll be able to see what I've been missing until now... Again, thanks for your support and I'll keep you posted! Joaquin Hernandez-Rico To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Dec 15 9:10:37 2000 From owner-freebsd-database@FreeBSD.ORG Fri Dec 15 09:10:33 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from ann.skypoint.net (ann.skypoint.net [199.86.32.19]) by hub.freebsd.org (Postfix) with ESMTP id 6DA5737B404 for ; Fri, 15 Dec 2000 09:10:33 -0800 (PST) Received: (from uucp@localhost) by ann.skypoint.net (8.9.3/8.9.3) with UUCP id RAA61905; Fri, 15 Dec 2000 17:09:10 GMT Received: from localhost (peiffer@localhost) by Mutley.MN.Org (8.11.0/8.11.0) with ESMTP id eBF1W9500381; Thu, 14 Dec 2000 19:33:01 -0600 (CST) Date: Thu, 14 Dec 2000 19:32:09 -0600 (CST) From: Tim Peiffer To: Gleb Shegai Cc: Subject: Re: Perl <-> Oracle In-Reply-To: <20001214073431.74630.qmail@web10008.mail.yahoo.com> 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 I believe that one must presuppose that your DBI/DBD installation is correct. Then you need to be able to write to the your DBI API. I think that your key will be setting a database handle that the Oracle database instance was set up. Below is a small snippet that uses DBI to log into an Oracle DB with a handle called 'prod'. Your mileage may vary. This is a working DBI implementation pulling from a Solaris box. Tim Peiffer peiffer@mutley.mn.org use DBI; $host = $ENV{'HOST'}; # Set ORACLE_HOME so it doesn't have to come from the environment. $ENV{'ORACLE_HOME'} = '/usr/local/pkg/oracle'; $handle = 'dbi:Oracle:prod'; $dbh = DBI->connect($handle, "joe", "secret") || die "Unable to connect to database: \"$handle\": $DBI::errstr"; # So we don't have to check every DBI call we set RaiseError. # See the DBI docs now if you're not familiar with RaiseError. $dbh->{RaiseError} = 1; $dbh->{AutoCommit} = 0; $time = time; # current time $query = " select MAC,X500ID from dhcpusers where MAC != '000000000000' and EXPIRETIME > $time "; $sth = $dbh->prepare($query); $sth->execute; while(($mac,$x500id) = $sth->fetchrow_array) { # do something with the data $mac =~ s/(..)/$1:/g; $mac =~ s/:$//; printf DHCP "host %s {\n\thardware ethernet %s;\n}\n", $x500id, $mac; } $sth->finish; $dbh->disconnect; To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Dec 16 7:27:29 2000 From owner-freebsd-database@FreeBSD.ORG Sat Dec 16 07:27:27 2000 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from juice.shallow.net (node16229.a2000.nl [24.132.98.41]) by hub.freebsd.org (Postfix) with ESMTP id E302F37B402 for ; Sat, 16 Dec 2000 07:27:22 -0800 (PST) Received: from localhost (joshua@localhost) by juice.shallow.net (8.11.1/8.11.1) with ESMTP id eBGFRJ287133 for ; Sat, 16 Dec 2000 16:27:20 +0100 (CET) (envelope-from joshua@roughtrade.net) Date: Sat, 16 Dec 2000 16:27:19 +0100 (CET) From: Joshua Goodall Sender: joshua@juice.shallow.net To: freebsd-database@freebsd.org Subject: Object-Oriented DB's 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 Does anyone know of an OODB with a freebsd binary release? J -- Joshua Goodall A friend of mine works for a medium-sized telco. He has no phone, because (and I quote) "the lady who provisions phones is on holiday" To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message