From owner-freebsd-questions@FreeBSD.ORG Sat Apr 29 01:11:28 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 3315316A401 for ; Sat, 29 Apr 2006 01:11:28 +0000 (UTC) (envelope-from duane@greenmeadow.ca) Received: from smtpout.eastlink.ca (smtpout.eastlink.ca [24.222.0.30]) by mx1.FreeBSD.org (Postfix) with ESMTP id CA55743D46 for ; Sat, 29 Apr 2006 01:11:27 +0000 (GMT) (envelope-from duane@greenmeadow.ca) Received: from ip02.eastlink.ca ([24.222.10.10]) by mta01.eastlink.ca (Sun Java System Messaging Server 6.2-4.03 (built Sep 22 2005)) with ESMTP id <0IYG00KO6LZ4XHP0@mta01.eastlink.ca> for freebsd-questions@freebsd.org; Fri, 28 Apr 2006 22:11:28 -0300 (ADT) Received: from blk-224-199-230.eastlink.ca (HELO [192.168.0.103]) ([24.224.199.230]) by ip02.eastlink.ca with ESMTP; Fri, 28 Apr 2006 22:11:14 -0300 Date: Fri, 28 Apr 2006 22:10:24 -0300 From: Duane Whitty In-reply-to: <11e8c67c0d0f09b07ea6bc52e9447407@prodigy.net> To: jekillen Message-id: <4452BD00.8000205@greenmeadow.ca> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT X-BrightmailFiltered: true X-Brightmail-Tracker: AAAAAQAAA+k= References: <2b990b51e5f83c3958da8b4e29645f95@prodigy.net> <20060428203449.B6EC.GERARD@seibercom.net> <11e8c67c0d0f09b07ea6bc52e9447407@prodigy.net> User-Agent: Thunderbird 1.5 (X11/20060309) Cc: freebsd-questions@freebsd.org Subject: Re: permissions dilemma X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 29 Apr 2006 01:11:28 -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? >> >> -- >> Gerard Seibert >> gerard@seibercom.net > 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. Hi, As you don't mention it explicitly, did you run "mysql_install_db --user=mysql" ? I know the first time I installed MySQL I neglected to do so. As well, do you also have a mysql user and a mysql group defined? Best Regards, Duane Whitty -- duane@greenmeadow.ca