Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 16 Apr 2006 22:05:30 -0800
From:      Beech Rintoul <beech@mangohealth.org>
To:        jekillen <jekillen@prodigy.net>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: System user creation
Message-ID:  <200604162205.47123.beech@mangohealth.org>
In-Reply-To: <47b3de6d99f400e996a8e6cc64c17e5d@prodigy.net>
References:  <4f6d31171304d84071b572ca97b2ce1b@prodigy.net> <200604161630.07728.beech@mangohealth.org> <47b3de6d99f400e996a8e6cc64c17e5d@prodigy.net>

next in thread | previous in thread | raw e-mail | index | archive | help
--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.<domain>.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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200604162205.47123.beech>