From owner-freebsd-database@FreeBSD.ORG Tue Jun 27 06:53:49 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 CB5C916A405 for ; Tue, 27 Jun 2006 06:53:49 +0000 (UTC) (envelope-from hlddn.freebsd@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by mx1.FreeBSD.org (Postfix) with ESMTP id 78D7743D77 for ; Tue, 27 Jun 2006 06:53:45 +0000 (GMT) (envelope-from hlddn.freebsd@gmail.com) Received: by ug-out-1314.google.com with SMTP id m3so1366595uge for ; Mon, 26 Jun 2006 23:53:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=kxxLVyDvGI1351rE1WCPMcVcKMYOynbBoI1d8eOXtJ20ps4iNDvz8hzZ7n7RRBOSa5YXu7X7qYLphHDIv0qoqBZbI/nsWxM42acZZVzj9d8L69nXHG+Y6knn1U0dB7OTxRULxramq+29rdw73guJJ9hCRckCSnJ7PJ5MkpZPZDk= Received: by 10.78.164.13 with SMTP id m13mr2387021hue; Mon, 26 Jun 2006 23:53:44 -0700 (PDT) Received: by 10.78.40.15 with HTTP; Mon, 26 Jun 2006 23:53:44 -0700 (PDT) Message-ID: Date: Tue, 27 Jun 2006 14:53:44 +0800 From: "starry huang" To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-2022-JP; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: install php5-mysql ports error! 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 Jun 2006 06:53:49 -0000 configure: error: mysql configure failed. Please check config.log for more information. ===> Script "configure" failed unexpectedly. Please report the problem to ale@FreeBSD.org [maintainer] and attach the "/usr/ports/databases/php5-mysql/work/php-5.1.4/ext/mysql/config.log" including the output of the failure of your make command. Also, it might be a good idea to provide an overview of all packages installed on your system (e.g. an `ls /var/db/pkg`). *** Error code 1 ports is fresh，mysql-server-5.0.22，mysql-client-5.0.22 all installed also。 uname -a： FreeBSD www.test.com 6.1-RELEASE-p2 FreeBSD 6.1-RELEASE-p2 #1: Wed Jun 21 02:13:48 CST 2006 root@www.test.com:/usr/obj/usr/src/sys/MYKERNEL i386 From owner-freebsd-database@FreeBSD.ORG Wed Jun 28 06:27:40 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 2CE5516A413 for ; Wed, 28 Jun 2006 06:27:40 +0000 (UTC) (envelope-from hlddn.freebsd@gmail.com) Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.192]) by mx1.FreeBSD.org (Postfix) with ESMTP id F110443D92 for ; Wed, 28 Jun 2006 06:27:33 +0000 (GMT) (envelope-from hlddn.freebsd@gmail.com) Received: by nz-out-0102.google.com with SMTP id 13so1828735nzp for ; Tue, 27 Jun 2006 23:27:33 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=O9ZhAYZUV92v6IdDNTrMf0mv2BcJFRDK+kLmpDiHIsSRiIdv/nPh1ixnyRA1ivcjzwWcyg0mwN5RfFibGCox+IskJLmeKWu+YHAVYrAteXejbw5QZv462RA79RA2J5kNoNSKmY4l/qKWKBSdtTChKzy6b/Qh1fiXLy/GUsmx0gk= Received: by 10.64.204.6 with SMTP id b6mr718258qbg; Tue, 27 Jun 2006 23:27:33 -0700 (PDT) Received: by 10.65.122.2 with HTTP; Tue, 27 Jun 2006 23:27:33 -0700 (PDT) Message-ID: Date: Wed, 28 Jun 2006 14:27:33 +0800 From: "starry huang" 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 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: portupgrade -rfo databases/mysql50-client mysql-client error 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 Jun 2006 06:27:40 -0000 I don't install php5-extensions ports,the error is "/usr/ports/databases/php5-mysql/work/php-5.1.4/ext/mysql/config.log including the output of the failure of your make command.", so then i installed mysql4-client behind deinstll myqsl5-client.and now installed php5-extensions with mysql it's fine.but I try "portupgrade -rfo databases/mysql50-client mysql-client" error also: configure: error: mysql configure failed. Please check config.log for more information. ===> Script "configure" failed unexpectedly. Please report the problem to ale@FreeBSD.org [maintainer] and attach the "/usr/ports/databases/php5-mysql/work/php- 5.1.4/ext/mysql/config.log" including the output of the failure of your make command. Also, it might be a good idea to provide an overview of all packages installed on your system (e.g. an `ls /var/db/pkg`). *** Error code 1 Stop in /usr/ports/databases/php5-mysql. ** Command failed [exit code 1]: /usr/bin/script -qa /tmp/portupgrade19010.2 make ** Fix the problem and try again. ---> Skipping 'lang/php5-extensions' ( php5-extensions-1.0) because a requisite package 'php5-mysql-5.1.4' (databases/php5-mysql) failed (specify -k to force) ** Listing the failed packages (*:skipped / !:failed) ! databases/php5-mysql (php5-mysql-5.1.4 ) (configure error) * lang/php5-extensions (php5-extensions-1.0) ---> Packages processed: 1 done, 1 ignored, 1 skipped and 1 failed my ports if fresh. uname -a FreeBSD www.test.com 6.1-RELEASE-p2 FreeBSD 6.1-RELEASE-p2 #1: Wed Jun 21 02:13:48 CST 2006 root@www.test.com:/usr/obj/usr/src/sys/MYKERNEL i386 From owner-freebsd-database@FreeBSD.ORG Fri Jun 30 12:49:19 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 7665416A415 for ; Fri, 30 Jun 2006 12:49:19 +0000 (UTC) (envelope-from i.am.aleks@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB00B43D48 for ; Fri, 30 Jun 2006 12:49:18 +0000 (GMT) (envelope-from i.am.aleks@gmail.com) Received: by nf-out-0910.google.com with SMTP id c29so277526nfb for ; Fri, 30 Jun 2006 05:49:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Wti2CvkfB3AUUTl8uco7klHUsmaoqOAkDckTjlgdLjr+MptcsBrf35MlkSuVXQN9yR/8WcQDjBkOtpTKqgb92/fioVpy6Fepbxc5QhGOD+5v+iqQHTvWn/oZNEHs0pBcr3JHcKh3th9In3fk2U2HGkogBA+Y+CLahANkJ5jWoVY= Received: by 10.49.72.6 with SMTP id z6mr263661nfk; Fri, 30 Jun 2006 05:49:16 -0700 (PDT) Received: by 10.48.223.10 with HTTP; Fri, 30 Jun 2006 05:49:16 -0700 (PDT) Message-ID: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com> Date: Fri, 30 Jun 2006 15:49:16 +0300 From: Aleks To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: FreeBSD 6.1 & Firebird 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, 30 Jun 2006 12:49:19 -0000 Hello! Yesterday I tried several times to setup a Firebird Server on a freshly installed FreeBSD 6.1 and connect to the example fdb via network, but with no success. Here is a transcript of what I do: Standard installation. Fdisk: Using entire disk (A option). Set bootable (S) the freebsd partition. Finish (Q). Install a standard MBR (no boot manager). Disklabel Editor: Auto defaults (A) used in Disklabel Editor. Finish (Q). Choose Minimal distribution set. Install from FreeBSD 6.1 CD disk1. Congratulations! ... Choose to configure Ethernet fxp0 (Intel EtherExpress Pro/100B). No IPv6. No DHCP. Host: firebird1 Domain: iktiv.com IPv4 Gateway: 172.16.0.254 Name server: 172.16.0.254 IPv4 Address: 172.16.0.250 Netmask: 255.255.255.0 OK. Bring up the fxp0 now. Choose not to function as a gateway. Choose to configure inetd. Choose to enable inetd. Choose not to invoke an editor on /etc/inetd.conf. Choose not to enable SSH login. Choose not to have anonymous FTP access. Choose not to configure as an NFS server. Choose not to configure as an NFS client. Choose not to customize system console settings. CMOS clock is set to UTC. Set time zone to EEST. Choose to exit the install. (Remove CD.) (System boots up and I login as root.) # pkg_add -r firebird-server (Fetches firebird-server and firebird-client.) (No errors.) # echo "gds_db 3050/tcp # InterBase Database Remote Protocol" >> /etc/services # echo "gds_db stream tcp nowait firebird /usr/local/sbin/fb_inet_server /usr/local/sbin/fb_inet_server" >> /etc/inetd.conf # /etc/rc.d/inetd restart Stopping inetd. Starting inetd. # gsec GSEC> display (Shows only SYSDBA, uid=0, gid=0.) GSEC> quit # isql Use CONNECT or CREATE DATABASE to specify database SQL> connect '/usr/local/share/examples/firebird/employee.fdb' user 'SYSDBA' password 'masterkey'; Database: '/usr/local/share/examples/firebird/employee.fdb', User: SYSDBA SQL> quit; # ping localhost (Successful.) # sockstat | grep inetd root inetd 603 5 tcp4 *:3050 *:* # telnet localhost gds_db Trying ::1... telnt: connect to address ::1: Connecion refused Trying 127.0.0.1... Connected to localhost.iktiv.com. Escape charactes is '^]'. ^] telnet> quit Connection closed. # isql Use CONNECT or CREATE DATABASE to specify database SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb' user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE =-902 I/O error for file "/usr/local/share/examples/employee.fdb" -Error while trying to open file -No such file or directory SQL> quit; So that's it. I can't find any useful documentation about how to setup Firebird on FreeBSD 6.1. Can anyone, please, suggest what might be the problem or to show a working setup of FreeBSD 6.1 & Firebird so I could use it via the network? Thank you! Aleks From owner-freebsd-database@FreeBSD.ORG Fri Jun 30 16:47:39 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 A39CA16A403 for ; Fri, 30 Jun 2006 16:47:39 +0000 (UTC) (envelope-from i.am.aleks@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by mx1.FreeBSD.org (Postfix) with ESMTP id D054943D58 for ; Fri, 30 Jun 2006 16:47:38 +0000 (GMT) (envelope-from i.am.aleks@gmail.com) Received: by nf-out-0910.google.com with SMTP id n29so28401nfc for ; Fri, 30 Jun 2006 09:47:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=a3QvNQk6XZF8KttcRnIHnk311PI6bTadoTuLH52pp3mWG6xvHGcDF5hUEitqZzm8sfrlujzc7o99b2f9IaozXOAgsmBH2g43SLOz5MKte0NpHiFoIGAOMR+yWXHJaMC2Xov+JjCZ793yRQJtqmyEuoDKx9t1lwSEUwhkcx4W3PM= Received: by 10.48.43.18 with SMTP id q18mr478105nfq; Fri, 30 Jun 2006 09:47:37 -0700 (PDT) Received: by 10.48.223.10 with HTTP; Fri, 30 Jun 2006 09:47:37 -0700 (PDT) Message-ID: <94678bd60606300947w32ee0071h75ea0eb7257dd2b5@mail.gmail.com> Date: Fri, 30 Jun 2006 19:47:37 +0300 From: Aleks To: freebsd-database@freebsd.org In-Reply-To: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com> Subject: Re: FreeBSD 6.1 & Firebird 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, 30 Jun 2006 16:47:39 -0000 Somethin I missed... # uname -a FreeBSD firebird1.iktiv.com 6.1-RELEASE FreeBSD 6.1-RELEASE #0: Sun May 7 04:32:43 UTC 2006 root@opus.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386 # cat /var/db/firebird/firebird.log firebird1.iktiv.com Fri Jun 30 15:28:44 2006 SERVER/process_packet: connection rejected for root firebird1.iktiv.com Fri Jun 30 15:28:44 2006 SERVER/process_packet: connect reject, server exiting firebird1.iktiv.com Fri Jun 30 15:28:44 2006 SERVER/process_packet: connection rejected for root firebird1.iktiv.com Fri Jun 30 15:28:44 2006 SERVER/process_packet: connect reject, server exiting firebird1.iktiv.com Fri Jun 30 15:28:44 2006 SERVER/process_packet: connection rejected for root firebird1.iktiv.com Fri Jun 30 15:28:44 2006 SERVER/process_packet: connect reject, server exiting ... Aleks From owner-freebsd-database@FreeBSD.ORG Sat Jul 1 03:52:13 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 3909016A506 for ; Sat, 1 Jul 2006 03:52:13 +0000 (UTC) (envelope-from johnckoller@yahoo.com) Received: from smtp108.sbc.mail.mud.yahoo.com (smtp108.sbc.mail.mud.yahoo.com [68.142.198.207]) by mx1.FreeBSD.org (Postfix) with SMTP id A40E243D48 for ; Sat, 1 Jul 2006 03:52:12 +0000 (GMT) (envelope-from johnckoller@yahoo.com) Received: (qmail 10749 invoked from network); 1 Jul 2006 03:52:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:Received:From:To:Subject:Date:User-Agent:References:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id; b=LfRQgvTDEdvmbeNPGZif+E8n2EqBx4hE6y+Lhb5PzdyQ5Sox5IltrSNfOfEW2r1IHZuUEVnGa3Fr8aQnqEbroX7vcxud+ZHA2eap9dTAPYrlDi32EoaDoLp0vOv3pPudDquQbUSgEV6RQqo6BAfeU7urdoMi5ek6wpJDm0YxJZI= ; Received: from unknown (HELO sword.localdomain) (johnckoller@70.246.58.16 with login) by smtp108.sbc.mail.mud.yahoo.com with SMTP; 1 Jul 2006 03:52:12 -0000 Received: by sword.localdomain (Postfix, from userid 1000) id 5E35918FA6; Fri, 30 Jun 2006 22:52:08 -0500 (CDT) From: John Koller To: freebsd-database@freebsd.org Date: Fri, 30 Jun 2006 22:52:07 -0500 User-Agent: KMail/1.9.1 References: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com> In-Reply-To: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200606302252.08021.johnckoller@yahoo.com> Subject: Re: FreeBSD 6.1 & Firebird 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: Sat, 01 Jul 2006 03:52:13 -0000 On Friday 30 June 2006 07:49, Aleks wrote: > Hello! > > Yesterday I tried several times to setup a Firebird Server on a > freshly installed FreeBSD 6.1 and connect to the example fdb via > network, but with no success. [snip] > # isql > Use CONNECT or CREATE DATABASE to specify database > SQL> connect '/usr/local/share/examples/firebird/employee.fdb' user [snip] > SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb' > user 'SYSDBA' password 'masterkey'; > Statement failed, SQLCODE =-902 > > I/O error for file "/usr/local/share/examples/employee.fdb" > -Error while trying to open file > -No such file or directory > SQL> quit; Is the error message from the example listed or from different attempts that you pasted together? What are the permissions for /usr/local/share/examples/firebird/employee.fdb? Can you create a database with create database 'localhost:/var/db/firebird/test.fdb'; ? -- John Koller From owner-freebsd-database@FreeBSD.ORG Sat Jul 1 11:44:29 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 58EEA16A403 for ; Sat, 1 Jul 2006 11:44:29 +0000 (UTC) (envelope-from maikel.lambregts@yahoo.com) Received: from web52205.mail.yahoo.com (web52205.mail.yahoo.com [206.190.48.128]) by mx1.FreeBSD.org (Postfix) with SMTP id D277A43D7B for ; Sat, 1 Jul 2006 11:44:28 +0000 (GMT) (envelope-from maikel.lambregts@yahoo.com) Received: (qmail 51389 invoked by uid 60001); 1 Jul 2006 11:44:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=K1o66PVGK8Ipgqea+FaoR88j3QrCITH+hCD6d+QME5/phwlciCCE6su3Lyu+xv91t6SkFCi3JPUPHhb4DjmWbnEelwKv9tbna/pN5kDVs+BsTCIWK9He0mGh54ghtzX1UJXOVNkOWsAQe0/9gdzftn4abfTt0oo36RL3OOqRfqY= ; Message-ID: <20060701114428.51387.qmail@web52205.mail.yahoo.com> Received: from [84.24.236.21] by web52205.mail.yahoo.com via HTTP; Sat, 01 Jul 2006 04:44:28 PDT Date: Sat, 1 Jul 2006 04:44:28 -0700 (PDT) From: Maikel Lambregts To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: MySQL and FreeBSD 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: Sat, 01 Jul 2006 11:44:29 -0000 Hi, I saw your information on http://lists.freebsd.org/pipermail/freebsd-database/2006-January/000386.html Atm we still have and olf MySQL server with FreeBSD 4.8 and MySQL 4.0 running with Linuxthreads. We now bought a new Dell server (Dual Xeon 2.8, 4GB ram, 15.000 SCSI RAID 1) and I'm wondering what would be the best to install MySQL. I was thinking of FreeBSD 6.1 in combination with MySQL 5.0. I was thinking of using your advice by using native threads instead of Linuxthreads and furthermore I just would copy your build options --> 'WITH_CHARSET=utf8', 'WITH_XCHARSET=all', 'WITH_COLLATION=utf8_general_ci', 'WITH_PROC_SCOPE_PTH=yes', 'BUILD_OPTIMIZED=yes', 'BUILD_STATIC=yes', Is this still the best configuration according to you? Do you have exact copy of my.cnf file for me that you use? Regards, Mike From owner-freebsd-database@FreeBSD.ORG Sat Jul 1 11:59:17 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 18D3416A415 for ; Sat, 1 Jul 2006 11:59:17 +0000 (UTC) (envelope-from i.am.aleks@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.189]) by mx1.FreeBSD.org (Postfix) with ESMTP id B41A443D70 for ; Sat, 1 Jul 2006 11:59:10 +0000 (GMT) (envelope-from i.am.aleks@gmail.com) Received: by nf-out-0910.google.com with SMTP id c29so463490nfb for ; Sat, 01 Jul 2006 04:59:09 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=eSciT5aAULyZytF6T4ZwX9hZyHHxa6QF6Ed4LuzgytAvNGdogho/LT4Mr/y1Ohpyjb2wASLZThC3f+BUnc9nlCarnxbV0bOXcuL1qUDspcGdasWtpYbe0l/APFm9tckj5lw0Wtf+7MGDHo2uGYUjvj8batmeg1lp9V1bMIqCG60= Received: by 10.49.65.8 with SMTP id s8mr954101nfk; Sat, 01 Jul 2006 04:59:09 -0700 (PDT) Received: by 10.48.223.10 with HTTP; Sat, 1 Jul 2006 04:59:09 -0700 (PDT) Message-ID: <94678bd60607010459s2c1b448co463ff5251bb4e1b8@mail.gmail.com> Date: Sat, 1 Jul 2006 14:59:09 +0300 From: Aleks To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: Re: FreeBSD 6.1 & Firebird 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: Sat, 01 Jul 2006 11:59:17 -0000 Hi again. Last night I made some progress finding what I've missed. The usual suspect - file permissions on employee.fdb. I changed the owner to firebird:firebird (fb_inet_server runs as firebird, I think) and chmod 644. So far so good. The next thing is echo "localhost.domain.tld" >> /etc/hosts.equiv. In the docs it is simply localhost, but it appears that a fully qualified domain name is needed. From that were the nice words in firebird.log, I think. The current problem that I seem to have is that I can connect to the employee.fdb via localhost: but wihtout using username and password. # isql SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb' user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE = -902 cannot attach to password database SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb'; Database: 'localhost:/usr/local/share/examples/firebird/employee.fdb' I admit I'm not familiar with the security model of firebird, etc. etc. so I'm going to read about it and find what's the actual problem. Maybe file permissions on security.fdb? It's owned by root and the permissions are somewhat restrictive 640. I can't create 'localhost:/var/db/firebird/test.fdb'; and I think it's because of the file permissions again, right? It's the default setup and /var/db/firebird is owned by root (755). So, back to the manuals and heavy reading/trying :) Thanks! Aleks From owner-freebsd-database@FreeBSD.ORG Sat Jul 1 12:16:27 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 50E2716A403 for ; Sat, 1 Jul 2006 12:16:27 +0000 (UTC) (envelope-from i.am.aleks@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1A26E43D5A for ; Sat, 1 Jul 2006 12:16:25 +0000 (GMT) (envelope-from i.am.aleks@gmail.com) Received: by nf-out-0910.google.com with SMTP id c29so465266nfb for ; Sat, 01 Jul 2006 05:16:25 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XyKl3Q+ZRmnDG7EXqKpVV4us6lFEgyivH4cxAciJybL4V6npmqYl0dhWyzJti7/Ysuxjq9r5gKD7PisIWyfX529IScOa5+xPfZpyhSBSuU8eYujn/NWpJpFOKzXUiMfCneAHqpVzhLcMCV85O2+XsB3bqDuBS+5hM75WiEhWO8M= Received: by 10.48.161.1 with SMTP id j1mr962084nfe; Sat, 01 Jul 2006 05:16:24 -0700 (PDT) Received: by 10.48.223.10 with HTTP; Sat, 1 Jul 2006 05:16:24 -0700 (PDT) Message-ID: <94678bd60607010516l59a9db63hf9e0069d4aab9f75@mail.gmail.com> Date: Sat, 1 Jul 2006 15:16:24 +0300 From: Aleks To: freebsd-database@freebsd.org In-Reply-To: <94678bd60607010459s2c1b448co463ff5251bb4e1b8@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <94678bd60607010459s2c1b448co463ff5251bb4e1b8@mail.gmail.com> Subject: Re: FreeBSD 6.1 & Firebird 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: Sat, 01 Jul 2006 12:16:27 -0000 Ok, so changing the owner of security.fdb to firebird wipes out the "cannot attach to password database"... Aleks From owner-freebsd-database@FreeBSD.ORG Sat Jul 1 13:17:21 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 27F5B16A5A3 for ; Sat, 1 Jul 2006 13:17:21 +0000 (UTC) (envelope-from i.am.aleks@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7D7DA44743 for ; Sat, 1 Jul 2006 12:53:18 +0000 (GMT) (envelope-from i.am.aleks@gmail.com) Received: by nf-out-0910.google.com with SMTP id c29so469125nfb for ; Sat, 01 Jul 2006 05:53:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=FZjdHNx6VA9D76Lr+LlHVg/6uXc+T8ao4lsFfvYR9ayuKzskehYeaMnvdZAVl3gxGz82aU2jKIqvAmyXZdva5NtZonx8cL5S4EP4wsoJgskIU8zYo7DfcNfPxx2LOsa6fHsV/GJv+xfB3iQTKmB/99dtAS53I3VUyMwziwO+Zvg= Received: by 10.49.21.14 with SMTP id y14mr978451nfi; Sat, 01 Jul 2006 05:53:17 -0700 (PDT) Received: by 10.48.223.10 with HTTP; Sat, 1 Jul 2006 05:53:17 -0700 (PDT) Message-ID: <94678bd60607010553h3a50ee22saa3f4b194ff18a3a@mail.gmail.com> Date: Sat, 1 Jul 2006 15:53:17 +0300 From: Aleks To: freebsd-database@freebsd.org In-Reply-To: <94678bd60607010516l59a9db63hf9e0069d4aab9f75@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <94678bd60607010459s2c1b448co463ff5251bb4e1b8@mail.gmail.com> <94678bd60607010516l59a9db63hf9e0069d4aab9f75@mail.gmail.com> Subject: Re: FreeBSD 6.1 & Firebird 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: Sat, 01 Jul 2006 13:17:22 -0000 I think I smoothed the things out: 1. Install FreeBSD 2. Install Firebird 3. Add the lines for Firebird in /etc/services & /etc/inetd.conf 4. Restart inetd. 5. Change owner of /var/db/firebird/security.fdb & /usr/local/share/examples/firebird/employee.fdb to firebird:firebird. 6. Change permissions of employee.fdb to 644. 7. Connect to localhost:/usr/local/share/examples/firebird/employee.fdb with user SYSDBA and password masterkey. I'm happy with leaving the hosts.equiv part. But what do you think about changing the owner of these two fdb files? Aleks From owner-freebsd-database@FreeBSD.ORG Sat Jul 1 13:34:24 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org 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 AC49816A403 for ; Sat, 1 Jul 2006 13:34:24 +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 1A98C44AEC for ; Sat, 1 Jul 2006 13:01:11 +0000 (GMT) (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 208DA19B2; Sat, 1 Jul 2006 15:01:09 +0200 (CEST) Message-ID: <44A67214.5070007@quip.cz> Date: Sat, 01 Jul 2006 15:01:08 +0200 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: cs, cz, en, en-us MIME-Version: 1.0 To: Maikel Lambregts References: <20060701114428.51387.qmail@web52205.mail.yahoo.com> In-Reply-To: <20060701114428.51387.qmail@web52205.mail.yahoo.com> Content-Type: multipart/mixed; boundary="------------020701080103060500040707" Cc: freebsd-database@freebsd.org Subject: Re: MySQL and FreeBSD 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: Sat, 01 Jul 2006 13:34:24 -0000 This is a multi-part message in MIME format. --------------020701080103060500040707 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Maikel Lambregts wrote: > Hi, > I saw your information on http://lists.freebsd.org/pipermail/freebsd-database/2006-January/000386.html > > Atm we still have and olf MySQL server with FreeBSD 4.8 and MySQL 4.0 running with Linuxthreads. We now bought a new Dell server (Dual Xeon 2.8, 4GB ram, 15.000 SCSI RAID 1) and I'm wondering what would be the best to install MySQL. > > I was thinking of FreeBSD 6.1 in combination with MySQL 5.0. I was thinking of using your advice by using native threads instead of Linuxthreads and furthermore I just would copy your build options --> Hi, we are still running MySQL with options from that thread, but now we have MySQL master on separate machine replicated to 2 slaves (those machines with webaplication). MySQL machine is Supermicro 6014H-8 with dual Xeon(TM) CPU 2.80GHz, 2GB of RAM and only one 72GB SCSI HDD Webaplication developers fixed some problems (mainly indexes on tables and reduce number of queries), so now in peaks we have about 500 queries per second with avarage CPU load lower then 0.3. Now we have MySQL 4.1.20-log # mysqladmin status Uptime: 2465465 Threads: 6 Questions: 507158262 Slow queries: 56373 Opens: 1281 Flush tables: 1 Open tables: 1024 Queries per second avg: 205.705 One important note - I do not recommend to enable HyperThreading. With HTT enabled, MySQL is overloaded with "slow queries" several times per day without any logical reason. my.cnf is in attachment, I recommend to do some tuning, because you have 4GB of RAM and probably different target usage, so you can increase some buffers, max number of connection, query cache etc. I do not know, if my configuration is the best, because I have no testing machine with dual CPU to tests and because this configuration runs well, I have no need to test another. If you have new machine and have some time to testing, you can try not to build MySQL as static and try different thread libraries throught /etc/libmap.conf # candidate mapping # [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so If you do so, please let me know of your results. And last - if you are not using features of MySQL 5.0, then stay with MySQL 4.1. With MySQL 5.0 (on machine I wrote in old thread) we have some troubles after upgrades (MySQL bugs with lost triggers etc.), 4.1 seems more "stable" to me. (but it is my personal view) Miroslav Lachman Some useful informations: http://www.mysqlperformanceblog.com/2006/06/15/freebsd-tests/ http://wikitest.freebsd.org/MySQL --------------020701080103060500040707 Content-Type: text/plain; name="my.cnf_2006-07-01.txt" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="my.cnf_2006-07-01.txt" [client] #password = [your_password] port = 3306 socket = /tmp/mysql.sock # *** Application-specific options follow here *** # # The MySQL server # [mysqld] # generic configuration options port = 3306 socket = /tmp/mysql.sock # back_log is the number of connections the operating system can keep back_log = 256 #skip-networking max_connections = 130 #max_connect_errors = 10 table_cache = 1024 max_allowed_packet = 16M binlog_cache_size = 1M max_heap_table_size = 32M sort_buffer_size = 8M join_buffer_size = 6M thread_cache = 8 thread_concurrency = 4 query_cache_size = 64M query_cache_limit = 4M ft_min_word_len = 3 #thread_stack = 192K # Set the default transaction isolation level. Levels available are: # READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE #transaction_isolation = REPEATABLE-READ # 2006-03-16 11:43 changed from REPEATABLE-READ to READ-COMMITTED # in faith of stop slow queries jam transaction_isolation = READ-COMMITTED tmp_table_size = 96M log_bin #log_slave_updates #log #log_warnings log_slow_queries long_query_time = 2 log_long_format #tmpdir = /tmp # *** Replication related settings server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - # the syntax is: # # CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=, # MASTER_USER=, MASTER_PASSWORD= ; # # where you replace , , by quoted strings and # by the master's port number (3306 by default). # # Example: # # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, # MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then # start replication for the first time (even unsuccessfully, for example # if you mistyped the password in master-password and the slave fails to # connect), the slave will create a master.info file, and any later # changes in this file to the variable values below will be ignored and # overridden by the content of the master.info file, unless you shutdown # the slave server, delete master.info and restart the slaver server. # For that reason, you may want to leave the lines below untouched # (commented) and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 - 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted #server-id = 2 # # The replication master for this slave - required #master-host = # # The username the slave will use for authentication when connecting # to the master - required #master-user = # # The password the slave will authenticate with when connecting to # the master - required #master-password = # # The port the master is listening on. # optional - defaults to 3306 #master-port = # Make the slave read-only. Only users with the SUPER privilege and the # replication slave thread will be able to modify data on it. You can # use this to ensure that no applications will accidently modify data on # the slave instead of the master #read_only #*** MyISAM Specific options key_buffer_size = 96M read_buffer_size = 4M read_rnd_buffer_size = 16M bulk_insert_buffer_size = 32M #myisam_sort_buffer_size = 32M myisam_max_sort_file_size = 4G myisam_max_extra_sort_file_size = 4G myisam_repair_threads = 2 # Automatically check and repair not properly closed MyISAM tables. myisam_recover # *** BDB Specific options *** # Use this option if you run a MySQL server with BDB support enabled but # you do not plan to use it. This will save memory and may speed up some # things. skip-bdb # *** INNODB Specific options *** # value. SHOW INNODB STATUS will display the current amount used. innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 512M innodb_data_file_path = ibdata1:512M;ibdata2:64M:autoextend:max:5G innodb_autoextend_increment = 64 #innodb_data_home_dir = /var/data/db/mysql innodb_file_io_threads = 4 #innodb_force_recovery=1 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 #innodb_fast_shutdown innodb_log_buffer_size = 8M innodb_log_file_size = 128M innodb_log_files_in_group = 3 #innodb_log_group_home_dir innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 20 [mysqldump] # Do not buffer the whole result set in memory before writing it to # file. Required for dumping very large tables quick max_allowed_packet = 16M [mysql] no-auto-rehash # Only allow UPDATEs and DELETEs that use keys. #safe-updates [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 6M write_buffer = 6M [mysqlhotcopy] interactive-timeout [mysqld_safe] # Increase the amount of open files allowed per process. Warning: Make # sure you have set the global system limit high enough! The high value # is required for a large number of opened tables #open-files-limit = 8192 --------------020701080103060500040707--