From owner-freebsd-database@FreeBSD.ORG Tue Feb 27 01:51:20 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id EC66C16A400 for ; Tue, 27 Feb 2007 01:51:20 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: from web34501.mail.mud.yahoo.com (web34501.mail.mud.yahoo.com [66.163.178.167]) by mx1.freebsd.org (Postfix) with SMTP id 98F9113C491 for ; Tue, 27 Feb 2007 01:51:20 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: (qmail 24378 invoked by uid 60001); 27 Feb 2007 01:24:39 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=FaszgCgEkK848KGy12niLt0usWAk3vPF3L2csvVCsZc0jzhRsUmptnHSpN36x9r951xoCrX43bPB9YSH+OI4mfV0i4TIf9kG1rgR9BzQXA8rd2dED1gY2+SniGC2XVHO6W7KlUHFncqqxVBSR/++DJJTUY59C/EcJAvWayjL2JQ= ; Message-ID: <20070227012439.24376.qmail@web34501.mail.mud.yahoo.com> X-YMail-OSG: jA8Ua6AVM1k79mkau6RcGvaD6Rw4DK4teWOCOmJdZgNjYAUsq6AcJv6KVSPkYYE9co0CvH.mljxt6e6QIYus1SvGTjOTiia_DuL2mTfpEgsilFn1jNtFqpmSXam.gl8c0Uxpu7LWWRh7sw-- Received: from [67.112.21.27] by web34501.mail.mud.yahoo.com via HTTP; Mon, 26 Feb 2007 17:24:39 PST Date: Mon, 26 Feb 2007 17:24:39 -0800 (PST) From: Nicole Harrington To: FreeBSD-DataBase MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: How can you tell what options have been used for a pkg_add install of Mysql VS ports X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Feb 2007 01:51:21 -0000 Hello If you install Mysql (say mysql5-server) via pkg-add - how can you tell what options it was compiled with? I guess this applies to any pkg that is installed, vs a port that has many opions for compilation. Also, any port or general compilation or runtime option suggestions for Mysql5? Thanks! Nicole The Large Print Giveth And The Small Print Taketh Away -- Anon From owner-freebsd-database@FreeBSD.ORG Tue Feb 27 02:27:30 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id DF89B16A401 for ; Tue, 27 Feb 2007 02:27:30 +0000 (UTC) (envelope-from zoticaicpassion@gmail.com) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.224]) by mx1.freebsd.org (Postfix) with ESMTP id 9D71A13C48D for ; Tue, 27 Feb 2007 02:27:30 +0000 (UTC) (envelope-from zoticaicpassion@gmail.com) Received: by nz-out-0506.google.com with SMTP id r28so582368nza for ; Mon, 26 Feb 2007 18:27:23 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole:in-reply-to:message-id; b=IrEld+00Hsct3Rr9D3xwoEwsY/yC7WDPBMm2UU/Geg4xNPR+PWPPjLTMXX2WLDJ9CaiyayXEkzZvASR+HXpjglqu4ySC6choo9L6yEB9zyI1XzvCvFU6a2AqZC89puRbIT/unaMd6Dk7BQ6x7vZ3jfOocWqHfj3XRibALYPZZCE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole:in-reply-to:message-id; b=aNjv/Nd+b10/KCWOaBhZB5sdZmM7PgwhELXMTWEwHizLvZo+lh14l0ekU9z8yg1HI2rqnK6BY9OGGjMYvpCXpf3iPvJJ8ommGHxjKPlGl3vfnO3XD08rWds+oGCBiV72Dw/4jsQ4XkWYmbwkO0L6ip+pGEN8YCH8DvQiCSLDJx8= Received: by 10.65.153.10 with SMTP id f10mr9536078qbo.1172541504441; Mon, 26 Feb 2007 17:58:24 -0800 (PST) Received: from nullp0inter ( [203.87.184.6]) by mx.google.com with ESMTP id 38sm3567397nzk.2007.02.26.17.58.19; Mon, 26 Feb 2007 17:58:23 -0800 (PST) From: "zoticaic" To: "'Nicole Harrington'" , "'FreeBSD-DataBase'" Date: Tue, 27 Feb 2007 09:58:12 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcdaEczIRFA7mTNpREWgnt0FYObeRQAAOKmw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 In-Reply-To: <20070227012439.24376.qmail@web34501.mail.mud.yahoo.com> Message-ID: <45e3903f.4b069264.4e93.ffffce88@mx.google.com> Cc: Subject: RE: How can you tell what options have been used for a pkg_add installof Mysql VS ports X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Feb 2007 02:27:31 -0000 ldd `which mysqld` HTH -- > My Seeding Blog | http://bytes.nullp0inter.com > Hire me as Freelancer | http://www.getafreelancer.com/affiliates/shockx/ > -----Original Message----- > From: owner-freebsd-database@freebsd.org [mailto:owner-freebsd- > database@freebsd.org] On Behalf Of Nicole Harrington > Sent: Tuesday, February 27, 2007 9:25 AM > To: FreeBSD-DataBase > Subject: How can you tell what options have been used for a pkg_add installof > Mysql VS ports > > Hello > If you install Mysql (say mysql5-server) via pkg-add > - how can you tell what options it was compiled with? > > I guess this applies to any pkg that is installed, vs > a port that has many opions for compilation. > > Also, any port or general compilation or runtime > option suggestions for Mysql5? > > > > Thanks! > > Nicole > > > The Large Print Giveth And The Small Print Taketh Away > -- Anon > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" From owner-freebsd-database@FreeBSD.ORG Tue Feb 27 05:15:28 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id A2EB816A400 for ; Tue, 27 Feb 2007 05:15:28 +0000 (UTC) (envelope-from smithi@nimnet.asn.au) Received: from gaia.nimnet.asn.au (nimbin.lnk.telstra.net [139.130.45.143]) by mx1.freebsd.org (Postfix) with ESMTP id 5ED7D13C461 for ; Tue, 27 Feb 2007 05:15:27 +0000 (UTC) (envelope-from smithi@nimnet.asn.au) Received: from localhost (smithi@localhost) by gaia.nimnet.asn.au (8.8.8/8.8.8R1.5) with SMTP id PAA26774; Tue, 27 Feb 2007 15:58:38 +1100 (EST) (envelope-from smithi@nimnet.asn.au) Date: Tue, 27 Feb 2007 15:58:37 +1100 (EST) From: Ian Smith To: Nicole Harrington In-Reply-To: <20070227012439.24376.qmail@web34501.mail.mud.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Cc: FreeBSD-DataBase Subject: Re: How can you tell what options have been used for a pkg_add install of Mysql VS ports X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Feb 2007 05:15:28 -0000 On Mon, 26 Feb 2007, Nicole Harrington wrote: > If you install Mysql (say mysql5-server) via pkg-add > - how can you tell what options it was compiled with? > > I guess this applies to any pkg that is installed, vs > a port that has many opions for compilation. IIRC from what Kris Kennaway said, and my own experience pkg_add'ing PHP5 only to discover the standard build didn't include mod_php5 (duh), packages are built with default options, just as you'll see selected if you run 'make config' in the equivalent port's directory in /usr/ports. > Also, any port or general compilation or runtime > option suggestions for Mysql5? Sorry, can't help with that; I tend to use packages myself (slow cpu but reasonable net connection), and haven't checked MySQL's default options. Cheers, Ian From owner-freebsd-database@FreeBSD.ORG Tue Feb 27 20:16:50 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id EFA2A16A400 for ; Tue, 27 Feb 2007 20:16:50 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: from web34508.mail.mud.yahoo.com (web34508.mail.mud.yahoo.com [66.163.178.174]) by mx1.freebsd.org (Postfix) with SMTP id 9F5ED13C4B3 for ; Tue, 27 Feb 2007 20:16:50 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: (qmail 1871 invoked by uid 60001); 27 Feb 2007 20:16:50 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=QReZQcqcwKlqZ3z7fy6gULKl0rzonmVnQb9/AAcrBDvQ6cwRGdpU6kNyYp/STy+3UrFh/RndiiMSD5dvIXIYE+wxjOcc3fAMQEVbrEwTGQL0BXA3khTWnN47Mn9jq+GFX2w5fJIFD3wk0QMFIg8eFQ9lavNzA9UCnLl34B5bvLA=; X-YMail-OSG: 2p8FPMIVM1lC11eRnMZR8SJP2S0A_.rL.qMme1m9FDIv5r.G8ZTgmIhUdnp7LCpbyrFMSFFTRqmWPFXKIBBt1t1xMWiy8.CZeWj0QtKBLUoIKhzLcrj8rgw6slbre0UTOV52Oz_.Mtr3GUM- Received: from [67.112.21.27] by web34508.mail.mud.yahoo.com via HTTP; Tue, 27 Feb 2007 12:16:49 PST Date: Tue, 27 Feb 2007 12:16:49 -0800 (PST) From: Nicole Harrington To: FreeBSD-DataBase , freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <4279.612.qm@web34508.mail.mud.yahoo.com> Cc: Subject: Getting errors while trying to use new Mysql 50 port and pkg X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 27 Feb 2007 20:16:51 -0000 Hello, I have 2 database servers running as slaves from a Master database. One (db2) is running FreeBSD 6.2-PRERELEASE from October. The other, (db3) on a new build of FreeBSD 6.2-STABLE. Both are AMD64. Db2 is running mysql 5.0.24a and has been working fine. Db3 however, running mysql 5.0.33 keeps giving an error 127 after awhile, for a couple of our tables. The tables all check as ok. 070227 11:24:48 [ERROR] Got error 127 when reading table './user_info' We had this problem before with the ports built version on db2, but when we switched to the pkg build it went away. Now none of the build options seem to work and sadly I do not have the old copy of mysql 5.024a to try on this server. (forgot to use -K) I have tried the Ports build with and without various optimizations, the Pkg build and a downloaded binary from mysql. (5.0.27) All produced the errors within an hour of running. perror shows this to mean: MySQL error code 127: Record-file is crashed. When the error is reported, the query that caused it responds with an error, but all other queries work. Running a repair on the tables shows everything ok. Any suggestions greatly appreciated! Thanks! Nicole -- Free The Bound Periodicals! From owner-freebsd-database@FreeBSD.ORG Wed Feb 28 08:55:08 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 7FB5716A402 for ; Wed, 28 Feb 2007 08:55:08 +0000 (UTC) (envelope-from gpaharenko@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by mx1.freebsd.org (Postfix) with ESMTP id 161FD13C491 for ; Wed, 28 Feb 2007 08:55:07 +0000 (UTC) (envelope-from gpaharenko@gmail.com) Received: by nf-out-0910.google.com with SMTP id k27so466212nfc for ; Wed, 28 Feb 2007 00:55:07 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:from; b=J/wYCT80Za/8pIEXM4TCCqIpUuoeqYyGq5c/tTjAtqkZ/t58lyJFgV2t9EK5TbWvLm2LTV2VJTRRrHOuGImOCHhnqybx7pEXDQJRTSSzG3m/LERKADS74rV12zr3xUO37kFCxRlcqpNeMGn3oymbIzLHhQ6A9wy+hE42B3PYUKw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:from; b=q3bfjBpgWcAsOgCMzeaeSVzXVS50Eehybt8f5i9b37s0uC0M2pFqrgHDYr1IJkwYq5pRfgNCqQRv5VDT6H94peeDzHvyXgNQVDQGA78fCWVcUAXUSZxiRq68U9al3KW4INfT4CzzK7QMMy6dFWuKoCI1PPHR2EdOojChvgkTFzM= Received: by 10.49.55.13 with SMTP id h13mr3150999nfk.1172652906979; Wed, 28 Feb 2007 00:55:06 -0800 (PST) Received: from ?192.168.1.7? ( [212.9.255.254]) by mx.google.com with ESMTP id g8sm1209508muf.2007.02.28.00.55.05; Wed, 28 Feb 2007 00:55:06 -0800 (PST) Message-ID: <45E5436A.2040207@mail.ru> Date: Wed, 28 Feb 2007 10:55:06 +0200 User-Agent: Thunderbird 1.5.0.8 (X11/20061107) MIME-Version: 1.0 To: Nicole Harrington References: <4279.612.qm@web34508.mail.mud.yahoo.com> In-Reply-To: <4279.612.qm@web34508.mail.mud.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit From: Gleb Paharenko Cc: FreeBSD-DataBase Subject: Re: Getting errors while trying to use new Mysql 50 port and pkg X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Feb 2007 08:55:08 -0000 Hello. You could try find out which statement causes the problem. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/reproducible-test-case.html Please, provide the output of 'SHOW VARIABLES' and 'SHOW STATUS' statements. There's another good point to start: http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html Regards. Nicole Harrington пишет: > Hello, > I have 2 database servers running as slaves from a > Master database. One (db2) is running FreeBSD > 6.2-PRERELEASE from October. The other, (db3) on a new > build of FreeBSD 6.2-STABLE. Both are AMD64. > > Db2 is running mysql 5.0.24a and has been working > fine. > Db3 however, running mysql 5.0.33 keeps giving an > error 127 after awhile, for a couple of our tables. > The tables all check as ok. > > 070227 11:24:48 [ERROR] Got error 127 when reading > table './user_info' > > We had this problem before with the ports built > version on db2, but when we switched to the pkg build > it went away. Now none of the build options seem to > work and sadly I do not have the old copy of mysql > 5.024a to try on this server. (forgot to use -K) > > I have tried the Ports build with and without various > optimizations, the Pkg build and a downloaded binary > from mysql. (5.0.27) All produced the errors within an > hour of running. > > perror shows this to mean: > MySQL error code 127: Record-file is crashed. > > When the error is reported, the query that caused it > responds with an error, but all other queries work. > Running a repair on the tables shows everything ok. > > > Any suggestions greatly appreciated! > > > Thanks! > > Nicole > > -- > Free The Bound Periodicals! > > > > > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" > -- Gleb Paharenko gleban@mail.ru From owner-freebsd-database@FreeBSD.ORG Wed Feb 28 19:14:04 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id D9C9A16A407 for ; Wed, 28 Feb 2007 19:14:04 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: from web34509.mail.mud.yahoo.com (web34509.mail.mud.yahoo.com [66.163.178.175]) by mx1.freebsd.org (Postfix) with SMTP id A204A13C4A3 for ; Wed, 28 Feb 2007 19:14:04 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: (qmail 57983 invoked by uid 60001); 28 Feb 2007 19:14:04 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=hv6Eh0n3vY1/dqYSQneC0y7NdmnNiSUpETI+sbthHjzryOKjAZICEUeeFbG1urjTN1tNpzlHgUcRZPtGExbhb14bdLpaUJh3V94TypXi6h+2yhUQLb5FWh9rwqPcK6QVtfBxLtHTCyMh+nY1BqJ/HCiIB6nIRrEkTEV8+OcYwMA= ; Message-ID: <20070228191404.57981.qmail@web34509.mail.mud.yahoo.com> X-YMail-OSG: oF8_tXoVM1n20uX_0uUznvyPrtryZIbEEmneeQ.Y Received: from [67.112.21.27] by web34509.mail.mud.yahoo.com via HTTP; Wed, 28 Feb 2007 11:14:03 PST Date: Wed, 28 Feb 2007 11:14:03 -0800 (PST) From: Nicole Harrington To: FreeBSD-DataBase In-Reply-To: <45E5436A.2040207@mail.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cc: Gleb Paharenko Subject: Re: Getting errors while trying to use new Mysql 50 port and pkg X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Feb 2007 19:14:04 -0000 --- Gleb Paharenko wrote: > Hello. > > You could try find out which statement causes the > problem. > Have a look here: > http://dev.mysql.com/doc/refman/5.0/en/reproducible-test-case.html > > Please, provide the output of 'SHOW VARIABLES' and > 'SHOW STATUS' statements. > There's another good point to start: > http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html > Hi, Thanks for the suggestions. Just to follow up. Copying the 5.0.24a mysql (c+s) program from our older db server stopped the 127 errors. So, it seems it must be either a bug in mysql, or an extra sensitivity to something in our tables, introduced someplace between 5.0.24a and 5.0.27. Or, even perhaps around that time, since it is interesting that it seems 5.0.24a only worked when compiled non static and/or un-optimized compile (pkg vs port w/options) Nicole > Regards. > > Nicole Harrington пишет: > > Hello, > > I have 2 database servers running as slaves from > a > > Master database. One (db2) is running FreeBSD > > 6.2-PRERELEASE from October. The other, (db3) on a > new > > build of FreeBSD 6.2-STABLE. Both are AMD64. > > > > Db2 is running mysql 5.0.24a and has been working > > fine. > > Db3 however, running mysql 5.0.33 keeps giving an > > error 127 after awhile, for a couple of our > tables. > > The tables all check as ok. > > > > 070227 11:24:48 [ERROR] Got error 127 when > reading > > table './user_info' > > > > We had this problem before with the ports built > > version on db2, but when we switched to the pkg > build > > it went away. Now none of the build options seem > to > > work and sadly I do not have the old copy of mysql > > 5.024a to try on this server. (forgot to use -K) > > > > I have tried the Ports build with and without > various > > optimizations, the Pkg build and a downloaded > binary > > from mysql. (5.0.27) All produced the errors > within an > > hour of running. > > > > perror shows this to mean: > > MySQL error code 127: Record-file is crashed. > > > > When the error is reported, the query that caused > it > > responds with an error, but all other queries > work. > > Running a repair on the tables shows everything > ok. > > > > > > Any suggestions greatly appreciated! > > > > > > Thanks! > > > > Nicole > > > > -- > > Free The Bound Periodicals! > > > > > -- > Gleb Paharenko > gleban@mail.ru > > From owner-freebsd-database@FreeBSD.ORG Thu Mar 1 15:52:39 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 996CC16A402 for ; Thu, 1 Mar 2007 15:52:39 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.249]) by mx1.freebsd.org (Postfix) with ESMTP id 5F0B213C474 for ; Thu, 1 Mar 2007 15:52:39 +0000 (UTC) (envelope-from dan.cojocar@gmail.com) Received: by an-out-0708.google.com with SMTP id c24so397512ana for ; Thu, 01 Mar 2007 07:52:38 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=dektGHo1ehHxWWsbkohkdY2+gSuFxIHmLmgbGODKAQM0z5YS5FkNr16SDs2eWJbncGUZAJWksFQpXTi/3hnBxF6XKUhcpHBtYA3C7hkQTuhLm9FfE0bVdLsnpUauHyF/hbLNW7qETjZprujtViwbTXVvbQKXw0K3/8FxhFrd8x8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=RpFKtThh1dpCQASj/Vvpui/UMoc8JD2S8bfrjX6uf2OgHFQI0pi6Uh6whovbsmeNO5x0pvwb4hjUsiu+JSD/BXEP5HU28iFtdo0APNoPmH4wzADWLPGRWZGoZPir8xPM3PaKEOG72RHMkiWLI6plBrixydZJ0IQuSAk33si1MzQ= Received: by 10.100.120.5 with SMTP id s5mr654083anc.1172762798895; Thu, 01 Mar 2007 07:26:38 -0800 (PST) Received: by 10.100.137.1 with HTTP; Thu, 1 Mar 2007 07:26:38 -0800 (PST) Message-ID: Date: Thu, 1 Mar 2007 17:26:38 +0200 From: "Dan Cojocar" To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: oracle php5-oci8 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 Mar 2007 15:52:39 -0000 Hello all, Can somebody that has an working php5-oci8 setup share his configuration? I have installed oracle XE, instantclient, native oracle8 client and php5-oci8 client extension, all were installed without errors, but when I run a script to connect to oracle it consumes a lot of cpu and nothing is happening. I used truss on: php -r '$conn = oci_connect("hr", "hr", "//localhost/XE");' and it's stuck on the following lines. close(3) = 0 (0x0) sigprocmask(SIG_SETMASK,SIGSEGV|SIGSYS|SIGPIPE|SIGALRM|SIGURG|SIGTSTP|SIGCHLD|SIGTTOU|SIGWINCH|SIGUSR2,0x0) = 0 (0x0) sigprocmask(SIG_SETMASK,0x0,SIGSEGV|SIGSYS|SIGPIPE|SIGALRM|SIGURG|SIGTSTP|SIGCHLD|SIGTTOU|SIGWINCH|SIGUSR2) = 0 (0x0) If someone would like the whole truss output I can provide it. I would appreciate any help to debug this issue. Thank you, Dan From owner-freebsd-database@FreeBSD.ORG Fri Mar 2 14:02:40 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id E146516A401 for ; Fri, 2 Mar 2007 14:02:39 +0000 (UTC) (envelope-from x_element108@btinternet.com) Received: from smtp809.mail.ukl.yahoo.com (smtp809.mail.ukl.yahoo.com [217.12.12.199]) by mx1.freebsd.org (Postfix) with SMTP id 4803F13C4B3 for ; Fri, 2 Mar 2007 14:02:38 +0000 (UTC) (envelope-from x_element108@btinternet.com) Received: (qmail 10613 invoked from network); 2 Mar 2007 14:02:38 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=btinternet.com; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:X-Enigmail-Version:Content-Type:Content-Transfer-Encoding; b=RX7f2Db+sb80eEl7WUnxI+B2IDPxsM8iMEsxLcnZO8WS0iipYegKUCfTb51UZonoP5qQp9VtsDI49CcfrUHOOGvGwWnkjonHOo+lXPoccwt5dKr+jSAZdUgta1TJeynBXHHlp1F0ds/jaTUeyhqtpV7lvWJbJhUzYWo42I4q8ZU= ; Received: from unknown (HELO ?192.168.1.67?) (x_element108@btinternet.com@86.133.112.228 with plain) by smtp809.mail.ukl.yahoo.com with SMTP; 2 Mar 2007 14:02:37 -0000 X-YMail-OSG: CglkGk0VM1l0k6ce6Fay49kysYOb5UtNkyFkz6SzTpTOZN4pT1qNAB05MP5b0dsz.3DDGJUoM7UtxQ2tRbKVeSZFOzmF3SG3JczW0sAcqYXXpnZbvdY- Message-ID: <45E82E41.2060007@btinternet.com> Date: Fri, 02 Mar 2007 14:01:37 +0000 From: "Rajen Jani (BT Yahoo! Broadband)" User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: Miroslav Lachman <000.fbsd@quip.cz>, freebsd-database@freebsd.org X-Enigmail-Version: 0.92.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: Subject: ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm' (using, password: YES) X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 Mar 2007 14:02:40 -0000 Hello people, Thanks for helping me out last time. I am still having the above problem. I did the following prior: shell>> mysql mysql> GRANT ALL PRIVILEGES ON zabbix TO .* 'zabbix'@'ritm' IDENTIFIED BY 'password'; mysql> quit bye shell>> mysql -h ritm -u zabbix -p password: ******** ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm.axigral' (using,password: YES) If I do it without password then it goes through ok. Any suggestions appreciated. If I go through the mysql documentation on the website they have nothing on FreeBSD. Regards, Rajen From owner-freebsd-database@FreeBSD.ORG Fri Mar 2 14:35:51 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 87A7E16A406 for ; Fri, 2 Mar 2007 14:35:51 +0000 (UTC) (envelope-from reinoud.v@n.leeuwen.net) Received: from spoetnik.xs4all.nl (spoetnik.xs4all.nl [213.84.24.58]) by mx1.freebsd.org (Postfix) with ESMTP id 4B2CD13C47E for ; Fri, 2 Mar 2007 14:35:51 +0000 (UTC) (envelope-from reinoud.v@n.leeuwen.net) Received: by spoetnik.xs4all.nl (Postfix, from userid 1000) id 533301CC86; Fri, 2 Mar 2007 15:08:28 +0100 (CET) Date: Fri, 2 Mar 2007 15:08:28 +0100 From: Reinoud van Leeuwen To: freebsd-database@freebsd.org Message-ID: <20070302140828.GJ72343@spoetnik.xs4all.nl> Mail-Followup-To: freebsd-database@freebsd.org References: <45E82E41.2060007@btinternet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45E82E41.2060007@btinternet.com> X-message-flag: Warning! The sender of this mail thinks you should use a more secure email client. User-Agent: Mutt/1.5.13 (2006-08-11) Subject: Re: ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm' (using, password: YES) X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 Mar 2007 14:35:51 -0000 On Fri, Mar 02, 2007 at 02:01:37PM +0000, Rajen Jani (BT Yahoo! Broadband) wrote: > Hello people, > > Thanks for helping me out last time. I am still having > the above problem. I did the following prior: > > shell>> mysql > > mysql> GRANT ALL PRIVILEGES ON zabbix TO .* 'zabbix'@'ritm' IDENTIFIED > BY 'password'; did you do a 'flush privileges'? (took me a day to find out as well....) -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________ From owner-freebsd-database@FreeBSD.ORG Fri Mar 2 15:26:54 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id B389516A403 for ; Fri, 2 Mar 2007 15:26:54 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from home.quip.cz (grimm.quip.cz [213.220.192.218]) by mx1.freebsd.org (Postfix) with ESMTP id 7521A13C4B4 for ; Fri, 2 Mar 2007 15:26:54 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from [192.168.1.2] (qwork.quip.test [192.168.1.2]) by home.quip.cz (Postfix) with ESMTP id 7EC2162F8; Fri, 2 Mar 2007 16:26:52 +0100 (CET) Message-ID: <45E8423C.506@quip.cz> Date: Fri, 02 Mar 2007 16:26:52 +0100 From: Miroslav Lachman <000.fbsd@quip.cz> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.12) Gecko/20050915 X-Accept-Language: cz, cs, en, en-us MIME-Version: 1.0 To: "Rajen Jani (BT Yahoo! Broadband)" References: <45E82E41.2060007@btinternet.com> In-Reply-To: <45E82E41.2060007@btinternet.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org Subject: Re: ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm' (using, password: YES) X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 Mar 2007 15:26:54 -0000 Rajen Jani (BT Yahoo! Broadband) wrote: > Hello people, > > Thanks for helping me out last time. I am still having > the above problem. I did the following prior: > > shell>> mysql > > mysql> GRANT ALL PRIVILEGES ON zabbix TO .* 'zabbix'@'ritm' IDENTIFIED > BY 'password'; You have wrong syntax of GRANT command. Right is: mysql> GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@ritm IDENTIFIED BY 'password'; where first "zabbix" is database name and asterisk wildcard means "all tables in this database", second "zabbix" is username and "ritm" is hostname (FQDN or IP adrress) of the machine from which the user zabbix will connect from. If database server and zabbix user is on the same machine, it should be localhost. Miroslav Lachman From owner-freebsd-database@FreeBSD.ORG Fri Mar 2 15:30:36 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 1824416A402 for ; Fri, 2 Mar 2007 15:30:36 +0000 (UTC) (envelope-from idiotbg@gmail.com) Received: from smtp.studnetz.uni-leipzig.de (smtp.studnetz.uni-leipzig.de [139.18.143.252]) by mx1.freebsd.org (Postfix) with ESMTP id C8B5B13C441 for ; Fri, 2 Mar 2007 15:30:35 +0000 (UTC) (envelope-from idiotbg@gmail.com) Received: from localhost (localhost [127.0.0.1]) by smtp.studnetz.uni-leipzig.de (Postfix) with ESMTP id 6DCA9209 for ; Fri, 2 Mar 2007 16:06:24 +0100 (CET) X-Virus-Scanned: by amavisd-new at studnetz-ul Received: from smtp.studnetz.uni-leipzig.de ([127.0.0.1]) by localhost (smtp.studnetz.uni-leipzig.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ksh5Xl0oGxJI for ; Fri, 2 Mar 2007 16:06:24 +0100 (CET) Received: from a144026.studnetz.uni-leipzig.de (a144026.studnetz.uni-leipzig.de [139.18.144.26]) by smtp.studnetz.uni-leipzig.de (Postfix) with ESMTP id 4CE19208 for ; Fri, 2 Mar 2007 16:06:24 +0100 (CET) From: Momchil Ivanov To: freebsd-database@freebsd.org Date: Fri, 2 Mar 2007 16:06:00 +0100 User-Agent: KMail/1.9.4 References: <45E82E41.2060007@btinternet.com> In-Reply-To: <45E82E41.2060007@btinternet.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart5243410.TIj1Q1TkRZ"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200703021606.04901.idiotbg@gmail.com> Subject: Re: ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm' (using, password: YES) X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: idiotbg@gmail.com List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 Mar 2007 15:30:36 -0000 --nextPart5243410.TIj1Q1TkRZ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =D0=9D=D0=B0 2.3.2007 15:01 Rajen Jani (BT Yahoo! Broadband) =D0=BF=D0=B8= =D1=88=D0=B5: > Hello people, > > Thanks for helping me out last time. I am still having > the above problem. I did the following prior: > > shell>> mysql > > mysql> GRANT ALL PRIVILEGES ON zabbix TO .* 'zabbix'@'ritm' IDENTIFIED > BY 'password'; Try using: GRANT ALL ON zabbix.* TO 'zabbix'@'ritm' IDENTIFIED BY 'password'; I think your '.*' after TO makes it wrong =2D-=20 This correspondence is strictly confidential. Any screening, filtering and/or production for the purpose of public or otherwise disclosure is forbidden without written permission by the author signed above. If you are not the intended recipient, please immediately notify the sender and permanently delete any copies PGP KeyID: 0x3118168B Keyserver: pgp.mit.edu Key fingerprint BB50 2983 0714 36DC D02E 158A E03D 56DA 3118 168B --nextPart5243410.TIj1Q1TkRZ Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (FreeBSD) iD8DBQBF6D1c4D1W2jEYFosRAlAiAJ9Upo3FYhYnEn5ZpB2cCQgfWmrNHgCfT+I/ c34fIlvk1isBoKnPEQoMTOk= =nNio -----END PGP SIGNATURE----- --nextPart5243410.TIj1Q1TkRZ-- From owner-freebsd-database@FreeBSD.ORG Fri Mar 2 17:14:30 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id E10DF16A404 for ; Fri, 2 Mar 2007 17:14:30 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by mx1.freebsd.org (Postfix) with ESMTP id C857B13C461 for ; Fri, 2 Mar 2007 17:14:30 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HNB2j-0006Z2-Q5 for freebsd-database@freebsd.org; Fri, 02 Mar 2007 08:55:41 -0800 Message-ID: <9273118.post@talk.nabble.com> Date: Fri, 2 Mar 2007 08:55:41 -0800 (PST) From: drewshen To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: drewsheneman@gmail.com Subject: mysql.sock X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 Mar 2007 17:14:31 -0000 I installed mysql through ports on freebsd 6.1. i started the daemon, and mysql starts. however when i try "mysql" i get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' i looked this up on the mysql page and did find much help. first i tried shell> chmod +t /tmp to protect tmp. that didnt solve it, so i tried to point my sock file to another directory in /etc/my.cnf. i got the same error message, even with the new directory. does anyone know where my problem lies? thanks! -- View this message in context: http://www.nabble.com/mysql.sock-tf3334648.html#a9273118 Sent from the freebsd-database mailing list archive at Nabble.com.