From owner-freebsd-questions@FreeBSD.ORG Mon Apr 17 06:05:53 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 2780916A400 for ; Mon, 17 Apr 2006 06:05:53 +0000 (UTC) (envelope-from beech@mangohealth.org) Received: from pinnacle.akherb.com (94-37-237-24.gci.net [24.237.37.94]) by mx1.FreeBSD.org (Postfix) with ESMTP id A301E43D48 for ; Mon, 17 Apr 2006 06:05:52 +0000 (GMT) (envelope-from beech@mangohealth.org) Received: by pinnacle.akherb.com (Postfix, from userid 1007) id 30FF15D24; Sun, 16 Apr 2006 22:05:52 -0800 (AKDT) X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on pinnacle.akherb.com X-Spam-Level: X-Spam-Status: No, score=0.0 required=4.0 tests=AWL autolearn=ham version=3.1.1 Received: from [192.168.2.160] (209-124-141-064.ip.arctic.net [209.124.141.64]) by pinnacle.akherb.com (Postfix) with ESMTP id 171665D12; Sun, 16 Apr 2006 22:05:50 -0800 (AKDT) From: Beech Rintoul Organization: Mangohealth To: jekillen Date: Sun, 16 Apr 2006 22:05:30 -0800 User-Agent: KMail/1.9.1 References: <4f6d31171304d84071b572ca97b2ce1b@prodigy.net> <200604161630.07728.beech@mangohealth.org> <47b3de6d99f400e996a8e6cc64c17e5d@prodigy.net> In-Reply-To: <47b3de6d99f400e996a8e6cc64c17e5d@prodigy.net> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2628071.1g5ZlY9ylL"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200604162205.47123.beech@mangohealth.org> Cc: freebsd-questions@freebsd.org Subject: Re: System user creation 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: Mon, 17 Apr 2006 06:05:53 -0000 --nextPart2628071.1g5ZlY9ylL Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Sunday 16 April 2006 20:13, you wrote: > On Apr 16, 2006, at 5:29 PM, Beech Rintoul wrote: > > On Sunday 16 April 2006 16:01, jekillen wrote: > >> Hello folks; > >> I am trying to create a system user for a program to use. > >> I haven't found any specific instructions for doing this in the > >> FreeBSD > >> manual > >> or Absolute FreeBSD. > >> The program exits with an error saying it can't create/write to a pid > >> file. > >> I believe it is the way I used adduser to create it and I don't know > >> what > >> I did wrong. I assigned it the class bin and disabled the password and > >> assigned none as the home dir. > >> To remove mystery it is MySQL I am trying to get running. > >> This is the error file entry: > >> starting server errors: > >> 060417 17:38:49 [ERROR] /usr/local/mysql/libexec/mysqld: Can't > >> create/write to file '/usr/local/mysql/var/AMD64-939..pid' > >> (Errcode: 13) > >> 060417 17:38:49 [ERROR] Can't start server: can't create PID file: > >> Permission denied > >> 060417 17:38:49 mysqld ended > > My concern is 'permission denied' which means there seems to be > something wrong with the mysql user > I created. I have done this on another FreeBSD v6 installation and I > didn't have the same problem. > I don't know what I did differently. Yes I did install mysql my self. I > have had nothing but problems > with ports, ref a concurrent post where I tried to install an network > interface card driver, nvnet and > got a torrent of errors when trying to run make. I went to the FreeBSD > web site and manually fetched the > disfile and place it in the distfile directory. It doesn't mean there > is anything wrong with ports, it just > means I'm not willing to spend the time to get it up to speed on my > system. > Anyhow, I just want to get MySQL running and then I'll deal with any > other problems. But on my other > FreeBSD machine i have had none so far and it has been happily running > for some 6 or 7 weeks > (accept for a power blackout event that I was able to recover from > easily). > Thanks > JK > > > How did you install mysql? That path doesn't look like the default port > > install. Someone correct me if I'm wrong, but shouldn't that be > > in /var/db/mysql? Anyway, user and group should be mysql - check your > > folder > > permissions to make sure mysql can write there. > > > > Beech > > Unfortunately, you've just run into one of the pitfalls of installing stock= =20 programs. I just looked at the port of mysql-server and there are no less=20 than 10 patches (most dealing with configuration) not counting the ones in= =20 mysql-client. Unless you're willing to spend the time dealing with all that= =20 by hand you're better off uninstalling and using the package version of tha= t=20 port. Installing a package is very easy and documented in the handbook. Oth= er=20 than that you need to take a close look at configure in the sources and you= =20 may need to adjust those for your system. In the short term what you have i= s=20 a file permission problem. Find out what user mysql is trying to run as (mo= st=20 likely "mysql"), make sure that user exists and set your file permissions o= n=20 the mysql directory to allow it to write as that user. It's ok to=20 use "adduser" to create the user. Beech =2D-=20 =2D------------------------------------------------------------------------= =2D------------- Beech Rintoul - Sys. Administrator - beech@mangohealth.org /"\ ASCII Ribbon Campaign | Mangohealth \ / - NO HTML/RTF in e-mail | 201 East 9Th Avenue Ste.310 X - NO Word docs in e-mail | Anchorage, AK 99501 / \ - XanGo - http://www.mangohealth.org =2D------------------------------------------------------------------------= =2D------------- --nextPart2628071.1g5ZlY9ylL Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (FreeBSD) iD8DBQBEQzA72TFLCHYGSF0RApwcAJ4vK0wGQQ3759TH1LAw/XgszfdK2QCfZSXf rOX+qVBddXBr1QMu2s0r4nw= =6cCh -----END PGP SIGNATURE----- --nextPart2628071.1g5ZlY9ylL--