From owner-freebsd-questions Wed Aug 18 16:21:15 1999 Delivered-To: freebsd-questions@freebsd.org Received: from janikt.pp.saunalahti.fi (janikt.pp.saunalahti.fi [195.74.24.137]) by hub.freebsd.org (Postfix) with ESMTP id 32A5114E3C for ; Wed, 18 Aug 1999 16:21:08 -0700 (PDT) (envelope-from jani@janikt.pp.saunalahti.fi) Received: (from jani@localhost) by janikt.pp.saunalahti.fi (8.9.3/8.9.3) id CAA07424; Thu, 19 Aug 1999 02:10:20 +0300 From: Jani Tolonen MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Date: Thu, 19 Aug 1999 02:10:19 +0300 (EEST) To: Dick Griffin Cc: mysql@lists.mysql.com, freebsd-questions@freebsd.org Subject: ??? StreamServer Port: ... errno 48 In-Reply-To: References: X-Mailer: VM 6.43 under 20.4 "Emerald" XEmacs Lucid Message-ID: <14267.15418.564707.279016@janikt.pp.saunalahti.fi> Reply-To: jani@tcx.se Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Dick Griffin writes: > folks, > > I'm still struggling, and decided a re-boot was in order, and upon reboot > recievd the following message as my FreeBSD3.2 system attemped to starts > the mysqld, > > mysqlFATAL: StreamServerPort: bind() failed errno = 48 > > It asked me if I has a'another postmaster already running on that port' > > I used a default insallation from the FreeBSD packages, and am not sure > how that, or what that means. > > Thanks for being patient with me, > > Dick Griffin > At Home > Hello Dick, Seems as if you have some other program listening on the same TCP/IP port that MySQL server is trying to use. Please try changing the default values. (Defaults are: TCP/IP port = 3306, UNIX_SOCKET = /tmp/mysql.sock) Just in case change both and start mysqld for example like: mysqld --port=3307 --socket=/tmp/mysql.sock2 (and the other options if needed) Then try connection using 'mysql --port=3307 --socket=/tmp/mysql.sock2' See mysqld --help. You can find more information from the manual. Regards, - Jani -- +-------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen | | /*/ /*/ /*/ \*\_ |*| |*||*| jani@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +-------------------------------------------------------------+ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message