From owner-freebsd-database@FreeBSD.ORG Sun Dec 19 14:46:04 2004 Return-Path: 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 58D0116A4EE for ; Sun, 19 Dec 2004 14:46:04 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.192]) by mx1.FreeBSD.org (Postfix) with ESMTP id C9A3343D39 for ; Sun, 19 Dec 2004 14:46:03 +0000 (GMT) (envelope-from tethys.ocean@gmail.com) Received: by rproxy.gmail.com with SMTP id z35so78973rne for ; Sun, 19 Dec 2004 06:46:03 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=tIpJv0UJ5wlSpzBX3vcCj3Vcft1qiM2TJPO5X31DpqXB6KZsqadNS2QU/cg3LkBrtqoYG2wd3FBOUS5nqI/q2i+LARTBLNobCW2yU4h4ghTD+ncfxkcFm8wORzKPf56Cq5I65KOC6HIqj7jyydS5BjpK6raHQPHWwNnSa0m33+U= Received: by 10.39.2.61 with SMTP id e61mr724506rni; Sun, 19 Dec 2004 06:46:03 -0800 (PST) Received: by 10.38.66.15 with HTTP; Sun, 19 Dec 2004 06:46:03 -0800 (PST) Message-ID: <235b800004121906467e624cb1@mail.gmail.com> Date: Sun, 19 Dec 2004 16:46:03 +0200 From: tethys ocean To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Subject: mysql 5.0 conflict with postfix and courier-imap X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: tethys ocean List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 19 Dec 2004 14:46:04 -0000 Hi, All Are there any bug FreeBSD 5.3 stable and also Mysql 4.0.22 and mysql5.0 tethys From owner-freebsd-database@FreeBSD.ORG Tue Dec 21 18:16:58 2004 Return-Path: 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 1E07516A4CE for ; Tue, 21 Dec 2004 18:16:58 +0000 (GMT) Received: from mail.mcnet.pl (mail.mcnet.pl [217.67.192.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id BBF4E43D3F for ; Tue, 21 Dec 2004 18:16:56 +0000 (GMT) (envelope-from pawel@mcmail.pl) Received: from localhost (localhost [127.0.0.1]) by mail.mcnet.pl (Postfix) with ESMTP id 5CC4532EF2; Tue, 21 Dec 2004 19:16:54 +0100 (CET) Received: from mail.mcnet.pl ([127.0.0.1]) by localhost (orchid [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27139-09; Tue, 21 Dec 2004 19:16:54 +0100 (CET) Received: from localhost (acy153.neoplus.adsl.tpnet.pl [83.25.76.153]) by mail.mcnet.pl (Postfix) with ESMTP id 0DAFC32EB6 for ; Tue, 21 Dec 2004 19:16:54 +0100 (CET) Date: Tue, 21 Dec 2004 19:16:32 +0100 From: PawelG X-Priority: 3 (Normal) Message-ID: <569726426.20041221191632@mcmail.pl> To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by mcnet e-mail virus scanner at mail.mcnet.pl Subject: MySQL 4.1 compilation problem X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: P List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 21 Dec 2004 18:16:58 -0000 Hello, It's FreeBSD 5.3-STABLE box. I'd like to install mysql41-server port and get this error: (root@ttyp2):/usr/ports/databases/mysql41-server# make BUILD_STATIC=yes install ===> mysql-server-4.1.7 depends on executable: gmake - found ===> mysql-server-4.1.7 depends on file: /usr/local/bin/libtool15 - found ===> mysql-server-4.1.7 depends on shared library: mysqlclient.14 - not found ===> Verifying install for mysqlclient.14 in /usr/ports/databases/mysql41-client ===> Returning to build of mysql-server-4.1.7 Error: shared library "mysqlclient.14" does not exist *** Error code 1 /usr/ports are updated. I have no idea why mysqlclient.14 library is missed. mysql41-client is already installed properly: (root@ttyp2):/usr/ports/databases/mysql41-server# pkg_info | grep mysql mysql-client-4.1.7 Multithreaded SQL database (client) Thank you for any ideas and comments. Kind regards, -- Pawel From owner-freebsd-database@FreeBSD.ORG Wed Dec 22 19:12:55 2004 Return-Path: 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 6C8CB16A4CE for ; Wed, 22 Dec 2004 19:12:55 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.200]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7461643D68 for ; Wed, 22 Dec 2004 19:12:54 +0000 (GMT) (envelope-from tethys.ocean@gmail.com) Received: by rproxy.gmail.com with SMTP id y7so621rne for ; Wed, 22 Dec 2004 11:12:47 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=mbzNtuf3+mMP0DcUUVKkoNqTjFbGhjYQkxFMBQY1G1ALtthjA+A56NTvGyDGl0m+LFZpxnGL7oCO0pqr4omaA39IOn/P7UX4IyhGXlr2c0oJZLacV/XF1Ph+yVMib7loYcizw5k03VeZ4qoEDknqT8sxN9L4obg2ZnpggTvx5UE= Received: by 10.38.11.2 with SMTP id 2mr195809rnk; Wed, 22 Dec 2004 11:12:21 -0800 (PST) Received: by 10.38.66.67 with HTTP; Wed, 22 Dec 2004 11:12:21 -0800 (PST) Message-ID: <235b800004122211121f3e0b3e@mail.gmail.com> Date: Wed, 22 Dec 2004 21:12:21 +0200 From: tethys ocean To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Subject: top list X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: tethys ocean List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Dec 2004 19:12:55 -0000 Mysql running on an IBM dopuble cpu server freebsd 5.2.1 RELEASE whenever I said that TOP PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 1313 mysql 132 0 79712K 45832K RUN 0 49.0H 93.31% 93.31% mysqld 333 bind 96 0 11696K 11008K select 1 19:59 0.00% 0.00% named 524 root 123 0 3852K 2612K select 0 8:24 0.00% 0.00% sendmail 58617 www 4 0 13792K 10844K accept 1 5:08 0.00% 0.00% httpd 322 root 96 0 1320K 788K select 0 4:10 0.00% 0.00% syslogd 191 root 8 0 1836K 1328K nanslp 0 3:42 0.00% 0.00% ipmon 1314 root 127 0 1420K 968K select 1 2:19 0.00% 0.00% inetd 32189 root 96 0 11272K 7980K select 1 1:24 0.00% 0.00% httpd 519 mailnull 96 0 1752K 1028K select 0 0:13 0.00% 0.00% mimedefang 570 mailnull -8 0 23196K 22392K piperd 1 0:03 0.00% 0.00% perl 549 root 8 0 1344K 916K nanslp 0 0:03 0.00% 0.00% cron 508 mailnull -8 0 23196K 22392K piperd 1 0:03 0.00% 0.00% perl 466 root 96 0 3508K 1812K select 0 0:01 0.00% 0.00% sshd 57903 www 4 0 13412K 10480K accept 1 0:01 0.00% 0.00% httpd 67624 root 4 0 4232K 3044K connec 0 0:01 0.00% 0.00% sendmail 68261 root 96 0 2320K 1444K select 0 0:01 0.00% 0.00% top 57904 www 4 0 13184K 10200K accept 1 0:01 0.00% 0.00% httpd 57907 www 4 0 12328K 9332K accept 1 0:01 0.00% 0.00% httpd 57902 www 4 0 11452K 8388K accept 1 0:01 0.00% 0.00% httpd 58618 www 4 0 11408K 8400K accept 1 0:01 0.00% 0.00% httpd 57901 www 4 0 11456K 8424K accept 1 0:00 0.00% 0.00% httpd 57924 www 4 0 11480K 8424K accept 1 0:00 0.00% 0.00% httpd 68634 root 96 0 2320K 1436K CPU0 0 0:00 0.00% 0.00% top 527 smmsp 20 0 3604K 2316K pause 1 0:00 0.00% 0.00% sendmail 57905 www 4 0 11596K 8608K accept 1 0:00 0.00% 0.00% httpd 58404 www 4 0 11404K 8328K accept 1 0:00 0.00% 0.00% httpd 739 root 8 0 1348K 912K wait 0 0:00 0.00% 0.00% bash 68231 parker 96 0 6244K 2444K RUN 0 0:00 0.00% 0.00% sshd 506 mailnull 96 0 2300K 1012K select 0 0:00 0.00% 0.00% mimedefang-multiple Mysql consume all cpu its just strange any 12 virtual user that has database webpage What mysql can consume nearly all CPU? From owner-freebsd-database@FreeBSD.ORG Wed Dec 22 19:19:09 2004 Return-Path: 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 DF19416A4CE for ; Wed, 22 Dec 2004 19:19:09 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.199]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6694F43D45 for ; Wed, 22 Dec 2004 19:19:05 +0000 (GMT) (envelope-from tethys.ocean@gmail.com) Received: by rproxy.gmail.com with SMTP id y7so296rne for ; Wed, 22 Dec 2004 11:19:02 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=mbzNtuf3+mMP0DcUUVKkoNqTjFbGhjYQkxFMBQY1G1ALtthjA+A56NTvGyDGl0m+LFZpxnGL7oCO0pqr4omaA39IOn/P7UX4IyhGXlr2c0oJZLacV/XF1Ph+yVMib7loYcizw5k03VeZ4qoEDknqT8sxN9L4obg2ZnpggTvx5UE= Received: by 10.38.11.2 with SMTP id 2mr195809rnk; Wed, 22 Dec 2004 11:12:21 -0800 (PST) Received: by 10.38.66.67 with HTTP; Wed, 22 Dec 2004 11:12:21 -0800 (PST) Message-ID: <235b800004122211121f3e0b3e@mail.gmail.com> Date: Wed, 22 Dec 2004 21:12:21 +0200 From: tethys ocean To: freebsd-database@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Subject: top list X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: tethys ocean List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 Dec 2004 19:19:10 -0000 Mysql running on an IBM dopuble cpu server freebsd 5.2.1 RELEASE whenever I said that TOP PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 1313 mysql 132 0 79712K 45832K RUN 0 49.0H 93.31% 93.31% mysqld 333 bind 96 0 11696K 11008K select 1 19:59 0.00% 0.00% named 524 root 123 0 3852K 2612K select 0 8:24 0.00% 0.00% sendmail 58617 www 4 0 13792K 10844K accept 1 5:08 0.00% 0.00% httpd 322 root 96 0 1320K 788K select 0 4:10 0.00% 0.00% syslogd 191 root 8 0 1836K 1328K nanslp 0 3:42 0.00% 0.00% ipmon 1314 root 127 0 1420K 968K select 1 2:19 0.00% 0.00% inetd 32189 root 96 0 11272K 7980K select 1 1:24 0.00% 0.00% httpd 519 mailnull 96 0 1752K 1028K select 0 0:13 0.00% 0.00% mimedefang 570 mailnull -8 0 23196K 22392K piperd 1 0:03 0.00% 0.00% perl 549 root 8 0 1344K 916K nanslp 0 0:03 0.00% 0.00% cron 508 mailnull -8 0 23196K 22392K piperd 1 0:03 0.00% 0.00% perl 466 root 96 0 3508K 1812K select 0 0:01 0.00% 0.00% sshd 57903 www 4 0 13412K 10480K accept 1 0:01 0.00% 0.00% httpd 67624 root 4 0 4232K 3044K connec 0 0:01 0.00% 0.00% sendmail 68261 root 96 0 2320K 1444K select 0 0:01 0.00% 0.00% top 57904 www 4 0 13184K 10200K accept 1 0:01 0.00% 0.00% httpd 57907 www 4 0 12328K 9332K accept 1 0:01 0.00% 0.00% httpd 57902 www 4 0 11452K 8388K accept 1 0:01 0.00% 0.00% httpd 58618 www 4 0 11408K 8400K accept 1 0:01 0.00% 0.00% httpd 57901 www 4 0 11456K 8424K accept 1 0:00 0.00% 0.00% httpd 57924 www 4 0 11480K 8424K accept 1 0:00 0.00% 0.00% httpd 68634 root 96 0 2320K 1436K CPU0 0 0:00 0.00% 0.00% top 527 smmsp 20 0 3604K 2316K pause 1 0:00 0.00% 0.00% sendmail 57905 www 4 0 11596K 8608K accept 1 0:00 0.00% 0.00% httpd 58404 www 4 0 11404K 8328K accept 1 0:00 0.00% 0.00% httpd 739 root 8 0 1348K 912K wait 0 0:00 0.00% 0.00% bash 68231 parker 96 0 6244K 2444K RUN 0 0:00 0.00% 0.00% sshd 506 mailnull 96 0 2300K 1012K select 0 0:00 0.00% 0.00% mimedefang-multiple Mysql consume all cpu its just strange any 12 virtual user that has database webpage What mysql can consume nearly all CPU? From owner-freebsd-database@FreeBSD.ORG Wed Dec 22 22:14:52 2004 Return-Path: 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 9357216A4CE for ; Wed, 22 Dec 2004 22:14:52 +0000 (GMT) Received: from mail.trippynames.com (mail.trippynames.com [38.113.223.19]) by mx1.FreeBSD.org (Postfix) with ESMTP id 72D4943D46 for ; Wed, 22 Dec 2004 22:14:52 +0000 (GMT) (envelope-from sean@chittenden.org) Received: from localhost (localhost [127.0.0.1]) by mail.trippynames.com (Postfix) with ESMTP id DA459A6F98; Wed, 22 Dec 2004 14:14:28 -0800 (PST) Received: from mail.trippynames.com ([127.0.0.1]) by localhost (rand.nxad.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 82216-03-45; Wed, 22 Dec 2004 14:14:10 -0800 (PST) Received: from [192.168.123.123] (unknown [38.113.223.82]) by mail.trippynames.com (Postfix) with ESMTP id 0BA0AA6E22; Wed, 22 Dec 2004 11:26:10 -0800 (PST) In-Reply-To: <235b800004122211121f3e0b3e@mail.gmail.com> References: <235b800004122211121f3e0b3e@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <6135206E-544F-11D9-AC87-000A95C705DC@chittenden.org> Content-Transfer-Encoding: 7bit From: Sean Chittenden Date: Wed, 22 Dec 2004 11:26:29 -0800 To: tethys ocean X-Mailer: Apple Mail (2.619) cc: freebsd-database@freebsd.org Subject: Re: top list X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 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, 22 Dec 2004 22:14:52 -0000 > Mysql running on an IBM dopuble cpu server freebsd 5.2.1 RELEASE > whenever I said that TOP This is a known issue with MySQL where it eats itself alive. You'll have to kill -9 it and repair your tables. I believe you'll be able to prevent this by running with FreeBSD 5.3 (or a slightly more recent version of pthreads) or recompiling MySQL with linuxthreads. -sc -- Sean Chittenden PostgreSQL++ From owner-freebsd-database@FreeBSD.ORG Thu Dec 23 13:11:38 2004 Return-Path: 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 D6CDF16A4CE for ; Thu, 23 Dec 2004 13:11:38 +0000 (GMT) Received: from www.svzserv.kemerovo.su (www.svzserv.kemerovo.su [213.184.65.80]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1680E43D45 for ; Thu, 23 Dec 2004 13:11:37 +0000 (GMT) (envelope-from eugen@kuzbass.ru) Received: from kuzbass.ru (kost [213.184.65.82])iBNDBWV5047854; Thu, 23 Dec 2004 20:11:33 +0700 (KRAT) (envelope-from eugen@kuzbass.ru) Message-ID: <41CAC3B4.F3378A56@kuzbass.ru> Date: Thu, 23 Dec 2004 20:10:12 +0700 From: Eugene Grosbein Organization: SVZServ X-Mailer: Mozilla 4.8 [en] (Win98; U) X-Accept-Language: ru,en MIME-Version: 1.0 To: database@freebsd.org Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit cc: "Georg-W. Koltermann" Subject: Re: Oracle 10 anyone? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 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, 23 Dec 2004 13:11:39 -0000 > I was trying to bring up Oracle10 on FreeBSD 5.2.1, but I get TNS:lost > contact again when I "connect / as sysdba". > > Ktrace tells me that one of the last things that oracle does before > exit(1), is trying to open /proc/sys/kernel/shmmax. That is apparently > not implemented by linprocfs. > > Did anyone get farther than this? Hi! I've just upgraded working Oracle9i (9.2.0.1.0) upto 9.2.0.6.0 It does nearly the same thing. Did you manage to solve the problem that time? Eugene Grosbein From owner-freebsd-database@FreeBSD.ORG Sat Dec 25 06:09:23 2004 Return-Path: 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 E53AB16A4CE for ; Sat, 25 Dec 2004 06:09:23 +0000 (GMT) Received: from mail4.speakeasy.net (mail4.speakeasy.net [216.254.0.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id A041443D2D for ; Sat, 25 Dec 2004 06:09:23 +0000 (GMT) (envelope-from jemaxwell@jaymax.com) Received: (qmail 19974 invoked from network); 25 Dec 2004 06:09:23 -0000 Received: from dsl093-045-209.sac1.dsl.speakeasy.net (HELO [192.168.2.2]) (jaymax@[66.93.45.209]) (envelope-sender ) by mail4.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 25 Dec 2004 06:09:23 -0000 Message-ID: <41CD04B9.404@jaymax.com> Date: Fri, 24 Dec 2004 22:12:09 -0800 From: "Joseph E. Maxwell" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-database@freebsd.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.1 Subject: Cron jobs setup X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 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, 25 Dec 2004 06:09:24 -0000 I am setting up a cron job to run a shell script at 1 hr interval and to have the output of the script sent to a user. I have this in the cron file inserted by crontab cat /var/cron/tabs/whoser # DO NOT EDIT THIS FILE - edit the master and reinstall. # (cron_reg installed on Fri Dec 24 18:13:01 2004) # (Cron version -- $FreeBSD: src/usr.sbin/cron/crontab/crontab.c,v 1.12.2.4 2001/06/16 03:18:37 peter Exp $) 0 1 * * * /blah/blah/blah/blah/blah/blah/blah/blah/blah/blah/pam2deb.shl MAILTO=user where pam2deb.shl is the shell script, permissions 755 So far w/ little success, the script did not run, much less send a mail, does this syntax have a problem? and cron is running ps -waux | grep cron root 142 0.0 0.1 1024 696 ?? Is 26Jul04 0:49.29 /usr/sbin/cron at least apparently Thanks