From owner-freebsd-questions Sat Jun 8 12:30:32 2002 Delivered-To: freebsd-questions@freebsd.org Received: from infinity.aesredfish.net (ns1.aesredfish.net [65.168.0.12]) by hub.freebsd.org (Postfix) with ESMTP id DCCFC37B400 for ; Sat, 8 Jun 2002 12:30:27 -0700 (PDT) Received: from potentialtech.com (mhope-dhcp-65-168-1-181.dashfast.com [65.168.1.181]) by infinity.aesredfish.net (8.11.6/8.11.0) with ESMTP id g58JUPU21852; Sat, 8 Jun 2002 15:30:25 -0400 Message-ID: <3D025CB4.4010005@potentialtech.com> Date: Sat, 08 Jun 2002 15:36:20 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.0rc1) Gecko/20020502 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Justin P. Michel" Cc: freebsd-questions@freebsd.org Subject: Re: MySQL Server References: <01ea01c20f21$d05edb10$7f0ea8c0@sol> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Justin P. Michel wrote: > However, I'm having a hell of a time trying to get MySQL Server installed. > I have all the "prerequisite" packages installed, and I'm using the pkg_add > command with the following results: > > --- > >>pkg_add > > ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4-stable/mysql-server- > 3.23.49.tgz > > Fetching... Done. > > Sorry, the host '192' cound not be looked up. > Please configure the 'hostname' command to return a correct hostname. > If you want to solve this at a later stage, restart this script with > the --force option > pkg_add: command '/usr/local/bin/mysql_install_db' failed > mysql:*:88: > You alread have a group "myswl", so I will use it. > mysql:*:88:88:0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin > You already have a user "mysql", so I will use it. > pw: WARNING: home '/var/db/mysql' does not exist > Changed home directory of "mysql" to "/var/db/mysql" > chown: /var/db/mysql: No such file or directory > pkg_add: install script returned error status > --- > > I've read various pages on MySQL, but nothing seems to address this error. > Can someone please direct me to a help page/site that can be of use, or > perhaps just tell me what I can do? This problem is fairly common with MySQL installations. The solution is to actually READ the error messages: > Sorry, the host '192' cound not be looked up. > Please configure the 'hostname' command to return a correct hostname. If you enter the command "hostname" what do you get? You need to make sure that the resolver library can resolve that. The easiest way to solve this problem is: 1. Set up a hostname in /etc/rc.conf 2. Enter the hostname in /etc/hosts so the resolver can resolve it 3. Reboot (or use the "hostname" command to manually set the hostname) 4. Install MySQL -- Bill Moran Potential Technology http://www.potentialtech.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message