From owner-freebsd-questions@FreeBSD.ORG Sat Apr 29 11:21:32 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DC6D216A409 for ; Sat, 29 Apr 2006 11:21:31 +0000 (UTC) (envelope-from gerard@seibercom.net) Received: from smtp5.suscom.net (smtp5.suscom.net [64.78.83.245]) by mx1.FreeBSD.org (Postfix) with ESMTP id 59B2643D45 for ; Sat, 29 Apr 2006 11:21:31 +0000 (GMT) (envelope-from gerard@seibercom.net) Received: from localhost (unknown [127.0.0.1]) by smtp5.suscom.net (Postfix) with ESMTP id 3B0495100FA for ; Sat, 29 Apr 2006 07:21:30 -0400 (EDT) Received: from smtp5.suscom.net ([127.0.0.1]) by localhost (smtp5 [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 08072-01-38 for ; Sat, 29 Apr 2006 07:21:14 -0400 (EDT) Received: from seibercom.net (ip148.217.45.216.suscom.net [216.45.217.148]) by smtp5.suscom.net (Postfix) with SMTP id C62785100F8 for ; Sat, 29 Apr 2006 07:21:14 -0400 (EDT) Received: from [192.168.0.4] ([192.168.0.4]) by seibercom.net (8.13.6/8.13.6) with ESMTP id k3TBLEB0006055 for ; Sat, 29 Apr 2006 07:21:14 -0400 (EDT) (envelope-from gerard@seibercom.net) Date: Sat, 29 Apr 2006 07:21:16 -0400 From: Gerard Seibert To: freebsd-questions@freebsd.org Sender: gerard@seibercom.net Organization: Seibercom In-Reply-To: <11e8c67c0d0f09b07ea6bc52e9447407@prodigy.net> References: <20060428203449.B6EC.GERARD@seibercom.net> <11e8c67c0d0f09b07ea6bc52e9447407@prodigy.net> X-Face: "\j?x](l|]4p?-1Bf@!wN<&p=$.}^k-HgL}cJKbQZ3r#Ar]\%U(#6}'?<3s7%(%(gxJxxcR nSNPNr*/^~StawWU9KDJ-CT0k$f#@t2^K&BS_f|?ZV/.7Q Message-Id: <20060429071507.B595.GERARD@seibercom.net> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Mailer: Becky! ver. 2.25 [en] X-Virus-Scanned: by amavisd-new .250 at suscom.net Subject: Re: permissions dilemma X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: freebsd-questions@freebsd.org List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 29 Apr 2006 11:21:32 -0000 jekillen wrote: > > On Apr 28, 2006, at 5:38 PM, Gerard Seibert wrote: > > > jekillen wrote: > > > >> Hello: > >> I have had a problem with installing MySQL 5.0.18 on a FreeBSD v 6.0 > >> installation > >> where everything seems to compile and install correctly but the server > >> crashes > >> immediately on start up with permission to create/write it's .pid file > >> denied. > >> Then the screen saver daemon refuses to start in X windows with a > >> permission denied > >> error. It originally worked fine. But at some point recently the > >> screen > >> saver quit working. > >> When I went to Gnome preferences and tried to set the screen saver I > >> was > >> informed that the screen saver daemon wasn't running. When I tried to > >> have it > >> start I was presented with the permission denied error and to check > >> the > >> $path > >> variable. > >> I tried installing MySQL twice, each time with the same problem. > >> As I understand it, permissions in Unix are part of the file system > >> format. > >> The only possible link between MySQL and the screen saver daemon, > >> possibly, is the > >> mysql user needed to run mysqld. > >> > >> Could I have a corrupted file system in such a way as to cause > >> permission problems? > >> > >> thanks in advance. > >> JK > > > > Are you starting MySQL with the script in /usr/local/etc/rc.d/ upon > > bootup? > > > Boy that was fast, I just posted this message a moment ago... > No I was just testing it using the mysqld_safe --user=mysql & approach. > It won't work that way. I made the same mistake once myself. You might have introduced another problem however. The files created in '/var/db/mysql' [probable have the wrong permissions set on them. The easiest fix would be to just remove that directory and then start mysql properly. Usually '/usr/local/etc/rc.d/mysql-server start' should do the trick. The directories will be build correctly. At then end of the build of mysql are directions for creating users. You do that after mysql has been started. If you no longer have that information, I can supply you with it. HTH -- Gerard Seibert gerard@seibercom.net "I earn a seven-figure salary. Unfortunately, there's a decimal point involved." Anonymous