From owner-freebsd-questions@FreeBSD.ORG Sat Apr 29 20:45:34 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 3330E16A403 for ; Sat, 29 Apr 2006 20:45:34 +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 C319543D45 for ; Sat, 29 Apr 2006 20:45:33 +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 <0IYI000674AXH8C0@mta01.eastlink.ca> for freebsd-questions@freebsd.org; Sat, 29 Apr 2006 17:44:57 -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; Sat, 29 Apr 2006 17:45:30 -0300 Date: Sat, 29 Apr 2006 17:44:41 -0300 From: Duane Whitty In-reply-to: To: jekillen Message-id: <4453D039.302@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> <4452BD00.8000205@greenmeadow.ca> 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 20:45:34 -0000 jekillen wrote: > > On Apr 28, 2006, at 6:10 PM, Duane Whitty 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? >>>> >>>> -- >>>> 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" ? > yes....well come to think of it I only ran mysql_install_db without > the --user part > I believe. I'll redo it an see what happens. > thanks >> 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? > yes, but I'm confused, why would the mysql user need a shell and login > password. > No password means that any one could log into the system as the mysql > user > but how would mysqld switch to the mysql user if it has a password. > I did this on another machine running the same version of FreeBSD and > was successful. > So far MySQL runs fine on it. I don't recall exactly what I did > differently. > Would this have a bearing on the screen saver daemon? Or is that > another issue? >> >> Best Regards, >> >> Duane Whitty >> -- >> duane@greenmeadow.ca MySQL user does not need and should not have a login shell. the entry in the password and group file should be set-up automatically for you when you install MySQL. The method I used to install MySQL was to use the ports system via portupgrade. Then run mysql_install_db --user=mysql This sets a lot of things up for you. As I believe another poster has mentioned you will want to delete everything under /var/db/mysql/ Also do a chown mysql:mysql /var/db/mysql Read the chapters in the MySQL manual regarding post-install tasks under UNIX and securing the initial MySQL accounts. Hope this helps, Duane Whitty -- duane@greenmeadow.ca