From owner-freebsd-questions@FreeBSD.ORG Fri Aug 4 22:28:58 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 1BA7D16A4DF for ; Fri, 4 Aug 2006 22:28:58 +0000 (UTC) (envelope-from gerard@seibercom.net) Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.193]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4758F43D6E for ; Fri, 4 Aug 2006 22:28:57 +0000 (GMT) (envelope-from gerard@seibercom.net) Received: by nz-out-0102.google.com with SMTP id 13so104415nzn for ; Fri, 04 Aug 2006 15:28:56 -0700 (PDT) Received: by 10.65.211.16 with SMTP id n16mr6111185qbq; Fri, 04 Aug 2006 15:28:56 -0700 (PDT) Received: from seibercom.net ( [67.189.184.224]) by mx.gmail.com with ESMTP id e15sm709271qba.2006.08.04.15.28.56; Fri, 04 Aug 2006 15:28:56 -0700 (PDT) Received: from seibercom.net (localhost [127.0.0.1]) by seibercom.net (Postfix) with ESMTP id DD81ABFE0; Fri, 4 Aug 2006 18:28:53 -0400 (EDT) Received: from localhost (localhost [[UNIX: localhost]]) by seibercom.net (8.13.6/8.13.6/Submit) id k74MSq2w017326; Fri, 4 Aug 2006 18:28:52 -0400 (EDT) (envelope-from gerard@seibercom.net) From: Gerard Seibert Organization: Seibercom.net To: freebsd-questions@freebsd.org Date: Fri, 4 Aug 2006 18:28:49 -0400 User-Agent: KMail/1.9.3 References: <20060804212719.02CBB9B6A17@mxo6.broadbandsupport.net> In-Reply-To: <20060804212719.02CBB9B6A17@mxo6.broadbandsupport.net> X-Face: "\j?x](l|]4p?-1Bf@!wN<&p=$.}^k-HgL}cJKbQZ3r#Ar]\%U(#6}'?<3s7%(%(=?utf-8?q?gxJxxc=0A=09RnSNPNr*/=5E=7EStawWU9KDJ-CT0k=24f=23?=@t2^K&BS_f|?ZV/.7Q MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart3474190.jxaLzQqWVE"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200608041828.51976.gerard@seibercom.net> Cc: Ron Clark Subject: Re: (no subject) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: gerard@seibercom.net List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 04 Aug 2006 22:28:58 -0000 --nextPart3474190.jxaLzQqWVE Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Friday 04 August 2006 17:27, Ron Clark wrote: > OK, I have rebuilt the box again and this time installed Mysql Server > 4.1 from the packages. No errors during the install. > > When I try and start mysql, I get the following error: > test2# /usr/local/bin/mysqld_safe & > [1] 781 > test2# Starting mysqld daemon with databases from /var/db/mysql > STOPPING server from pid file /var/db/mysql/test2.pid > 060804 09:48:33 mysqld ended > > > [1] Done /usr/local/bin/mysqld_safe > > > > If I cat the .err file it writes, this is what it says: > > 060804 09:48:33 mysqld started > 060804 9:48:33 InnoDB: Operating system error number 13 in a file > operation. > InnoDB: The error means mysqld does not have the access rights to > InnoDB: the directory. > InnoDB: File name ./ibdata1 > InnoDB: File operation call: 'create'. > InnoDB: Cannot continue operation. > 060804 09:48:33 mysqld ended > > How do I fix this and get Mysql Server to start? > > Thanks in advance, > Ron OK, I once had the same problem. I am assuming that you attempted to start = and=20 configure MySQL manually after installing it. First of all, make sure you=20 have : mysql_enable=3D"YES" in your /etc/rc.conf file. Now navigate to the /var/db directory. Either rename or delete the mysql=20 directory. You have nothing in it since you did not get MySQL running. Now= =20 either reboot or navigate to /usr/local/etc/rc.d and as root type: ./mysql-server start It is possible yours is named different, so substiture the correct file nam= e.=20 That should create the directory with the proper permissions, etc. Now you= =20 can procede to configure MySQL for your users, etc. =2D-=20 Gerard Seibert gerard@seibercom.net A person forgives only when they are in the wrong. --nextPart3474190.jxaLzQqWVE Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.4 (FreeBSD) iD8DBQBE08ojs3R1WQUU6lgRAv6OAKCyqg7SGvl+xcmaK1uvE68sQUzlgwCg5Rc1 mqkH/Ltt2/KAtmWZTQm8suA= =7Pwp -----END PGP SIGNATURE----- --nextPart3474190.jxaLzQqWVE--