From owner-freebsd-questions@FreeBSD.ORG Sat Apr 29 21:07:33 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 D7F3B16A415 for ; Sat, 29 Apr 2006 21:07:33 +0000 (UTC) (envelope-from gerard@seibercom.net) Received: from smtp1.suscom.net (smtp1.suscom.net [64.78.119.247]) by mx1.FreeBSD.org (Postfix) with ESMTP id D02AD43D5E for ; Sat, 29 Apr 2006 21:07:26 +0000 (GMT) (envelope-from gerard@seibercom.net) Received: from localhost (smtp1 [127.0.0.1]) by smtp1.suscom.net (Postfix) with ESMTP id 143C81D0009; Sat, 29 Apr 2006 17:09:37 -0400 (EDT) Received: from smtp1.suscom.net ([127.0.0.1]) by localhost (smtp1 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12153-08; Sat, 29 Apr 2006 17:09:36 -0400 (EDT) Received: from seibercom.net (ip148.217.45.216.suscom.net [216.45.217.148]) by smtp1.suscom.net (Postfix) with SMTP id 2C1071D0005; Sat, 29 Apr 2006 17:09:36 -0400 (EDT) Received: from [192.168.0.4] ([192.168.0.4]) by seibercom.net (8.13.6/8.13.6) with ESMTP id k3TL7Ovj005801; Sat, 29 Apr 2006 17:07:24 -0400 (EDT) (envelope-from gerard@seibercom.net) Date: Sat, 29 Apr 2006 17:07:27 -0400 From: Gerard Seibert To: jekillen , freebsd-questions@freebsd.org Sender: gerard@seibercom.net Organization: Seibercom In-Reply-To: References: <20060429071507.B595.GERARD@seibercom.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: <20060429165907.1D15.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 at suscom.net Cc: 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 21:07:33 -0000 jekillen wrote: > > On Apr 29, 2006, at 4:21 AM, Gerard Seibert wrote: > > > 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. > > Sorry, yes it does work that way. I've done this on another > machine running the same version of FreeBSD and the instruction > specifically specify to start the daemon this way to test the install. > (I installed from source on both machines using the same source > tarball). > Every time I start this machine I start MySQL manually this way. > (Since this is a production server, it is up continuously and > it doesn't have Xwindows installed) > > 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. > This is a possibility, I'll check it out. > > > > 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. > not according to the instruction in the INSTALL-SOURCE. > > If you no longer have that > > information, I can supply you with it. > I'm confused as to the class of user to assign mysql to. > It shouldn't be a user that anyone can login as, nor have > it's own home dir or login shell should it? adduser asks > and expects answers to all these questions. I don't recall > what I did on the machine that is running mysql. I guess > I could look at the password file on that machine to get > some idea. > Since the machine that won't start MySQL also has > XWindows intalled, the kdm login prompt list mysql > as a user that can log into a windowing session. > That shouldn't be necessary at all. That is why I > think the issue with the screen saver daemon > is connected to this. Just out of curiosity, are you installing MySQL from the ports system? I am just wondering because I have never had to take any extraneous steps to get MySQL up and running. After installing from ports, I would just run the script in /usr/local/etc/rc.d and things would work fine. Obviously, I had to place the mysql_enable="YES" notation in /etc/rc.conf prior to starting MySQL. After that I would just create the passwords, etc. I guess there are more than one way to skin a cat. -- Gerard Seibert gerard@seibercom.net The difference between sex and death is that with death you can do it alone and no one is going to make fun of you. Woody Allen