From owner-freebsd-database@FreeBSD.ORG Mon Dec 12 16:53:50 2005 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 4F07116A41F; Mon, 12 Dec 2005 16:53:50 +0000 (GMT) (envelope-from mmulligan@intrusic.com) Received: from mail.intrusic.com (mail.intrusic.com [63.251.138.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id 67CAD43D64; Mon, 12 Dec 2005 16:53:49 +0000 (GMT) (envelope-from mmulligan@intrusic.com) Received: from cha1-mail1.intrusic.com (ipn36372-a58290.cidr.lightship.net [216.204.40.50]) by mail.intrusic.com (Postfix) with ESMTP id 1B202F8E; Mon, 12 Dec 2005 12:23:44 -0500 (EST) Received: from [192.168.100.155] (unicron.cybertron.intrusic.com [192.168.100.155]) by cha1-mail1.intrusic.com (Postfix) with ESMTP id 8F8A8C5630; Mon, 12 Dec 2005 11:54:23 -0500 (EST) Message-ID: <439DABA7.8080801@intrusic.com> Date: Mon, 12 Dec 2005 11:56:07 -0500 From: Michael Mulligan Organization: Intrusic, Inc User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051020) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: girgen@FreeBSD.org Subject: postgresql_user in 010.pgsql.sh 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: Mon, 12 Dec 2005 16:53:50 -0000 The current port hardcodes the postgresql_user as "pgsql" in pgsql.sh.tmpl: postgresql_user=pgsql I want to make the suggestion to make this configurable via /etc/rc.conf - the default would remain "pgsql": postgresql_user=${postgresql_user:-"pgsql"} Thanks for considering this. From owner-freebsd-database@FreeBSD.ORG Mon Dec 12 20:22:20 2005 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 750A816A41F for ; Mon, 12 Dec 2005 20:22:20 +0000 (GMT) (envelope-from mmulligan@intrusic.com) Received: from mail.intrusic.com (mail.intrusic.com [63.251.138.101]) by mx1.FreeBSD.org (Postfix) with ESMTP id F359143D5E for ; Mon, 12 Dec 2005 20:22:14 +0000 (GMT) (envelope-from mmulligan@intrusic.com) Received: from cha1-mail1.intrusic.com (ipn36372-a58290.cidr.lightship.net [216.204.40.50]) by mail.intrusic.com (Postfix) with ESMTP id 19C5FF93; Mon, 12 Dec 2005 15:52:08 -0500 (EST) Received: from [192.168.100.155] (unicron.cybertron.intrusic.com [192.168.100.155]) by cha1-mail1.intrusic.com (Postfix) with ESMTP id CA592C5630; Mon, 12 Dec 2005 15:22:49 -0500 (EST) Message-ID: <439DDC82.6090402@intrusic.com> Date: Mon, 12 Dec 2005 15:24:34 -0500 From: Michael Mulligan Organization: Intrusic, Inc User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051020) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Theodore Campbell References: <200512121709.jBCH9F5K000099@nemo.comscape.net> In-Reply-To: <200512121709.jBCH9F5K000099@nemo.comscape.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org Subject: Re: postgresql_user in 010.pgsql.sh 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: Mon, 12 Dec 2005 20:22:20 -0000 Theodore Campbell wrote: >I assume you're trying to set the postgres super user to something other than >pgsql. It's good to know that the system user and the database super user >are not related in any way. ... > My post was terse, not explaining why I was asking for this. Perhaps I have a weak reason: it is just for convenience with some legacy operational conventions where both the UNIX username and the Postgresql super user were named "postgres". My workaround has been to make the edit locally as indicated in my first email. I thought other folks might find this useful. Thanks for your reply. From owner-freebsd-database@FreeBSD.ORG Fri Dec 16 16:45:53 2005 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 D4F1416A41F for ; Fri, 16 Dec 2005 16:45:53 +0000 (GMT) (envelope-from dystopianrebel@yahoo.com) Received: from web52306.mail.yahoo.com (web52306.mail.yahoo.com [206.190.48.149]) by mx1.FreeBSD.org (Postfix) with SMTP id 279D043D49 for ; Fri, 16 Dec 2005 16:45:53 +0000 (GMT) (envelope-from dystopianrebel@yahoo.com) Received: (qmail 43743 invoked by uid 60001); 16 Dec 2005 16:45:52 -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=gUA7ddoFl3xzu0tv2AFppUxXFRkpWdvycC2Cm3+wv/phAK0E+/BGHBl8O41Kgdte01+1rPU3SNpNGcwpIh28K8OIGSJgyM0JSBaAcLb+AYRDXfe3M5R6aL6rdBXImW4bVcl9ucr8UDiGlvZpvjPKHyoONfhYf5XADi0751tatRc= ; Message-ID: <20051216164552.43741.qmail@web52306.mail.yahoo.com> Received: from [205.210.232.62] by web52306.mail.yahoo.com via HTTP; Fri, 16 Dec 2005 08:45:52 PST Date: Fri, 16 Dec 2005 08:45:52 -0800 (PST) From: dR To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: MySQL fails to start, FreeBSD 6.0 release 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, 16 Dec 2005 16:45:53 -0000 Fresh installation of 6.0. I've tried both mysql3 and mysql41 in the current ports tree. The mysqld daemon starts then aborts. The error log shows that "./mysql/host.frm" can't be found. I've looked at both safe_mysqld and mysqld_safe. They seem to expect the wrong directory structure for FreeBSD. I have the host.frm file, but in /var/db/mysql/mysql/. mysqld is in /usr/local/libexec/ and there is no ./mysql/host.frm there. Is anyone using 6.0 with a recent build of MySQL 3x or 41 from ports? If so, how are you starting the daemon? Anyone else have this problem? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From owner-freebsd-database@FreeBSD.ORG Sat Dec 17 15:22:29 2005 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 1115716A46C for ; Sat, 17 Dec 2005 15:22:29 +0000 (GMT) (envelope-from dystopianrebel@yahoo.com) Received: from web52302.mail.yahoo.com (web52302.mail.yahoo.com [206.190.48.145]) by mx1.FreeBSD.org (Postfix) with SMTP id E2DF943D6B for ; Sat, 17 Dec 2005 15:22:27 +0000 (GMT) (envelope-from dystopianrebel@yahoo.com) Received: (qmail 35516 invoked by uid 60001); 17 Dec 2005 15:22:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=CCN9F9TfNo64aEBkD+BTDkSVkos2nxTatO7Yz/4sF1KtaClhAoqO9WS0te+Ry1r4zh2b0yhR1SnpPtQUtDGR9i5lI7zlt4ouNW/XNYRh4tz3c17cf2xMAwbfbtuTxqBgPmElwSiU9wOHemFWTpWyZGpuu9QzGDUdwh/PZf+I6vA= ; Message-ID: <20051217152227.35514.qmail@web52302.mail.yahoo.com> Received: from [64.26.160.170] by web52302.mail.yahoo.com via HTTP; Sat, 17 Dec 2005 07:22:27 PST Date: Sat, 17 Dec 2005 07:22:27 -0800 (PST) From: dR To: Philipp Boos In-Reply-To: <15792037.20051216175842@solvetec.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cc: freebsd-database@freebsd.org Subject: Re: MySQL fails to start, FreeBSD 6.0 release 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, 17 Dec 2005 15:22:29 -0000 Hello Philipp, > pls be sure to first run the mysql_installdb script > located @ > /usr/local/bin/mysql_install_db and then be sure, > that the directory > for the created mysql db is fully read and writeable > for the > mysql:mysql User, then it should work (this > functions under freeBSD > 5.4 and 6.0 with Mysql 4.1, actual Build) I have done these things. > The Data directory for mysql is /var/db/mysql there > should be after > the mysql_install_db script two subdirectorys (test > and mysql), there Hmm! This means that I have an invalid directory structure: /var/db/mysql/mysql/ I have no idea how this could have happened. Thanks for the reply. I will test this suggestion. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com