From owner-freebsd-alpha@FreeBSD.ORG Sat Jan 10 01:22:05 2004 Return-Path: Delivered-To: freebsd-alpha@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EFC0616A4CE for ; Sat, 10 Jan 2004 01:22:04 -0800 (PST) Received: from pegasus.freiberg-net.de (pegasus.freibergnet.de [80.243.43.9]) by mx1.FreeBSD.org (Postfix) with ESMTP id E2FB943D58 for ; Sat, 10 Jan 2004 01:21:47 -0800 (PST) (envelope-from holm@pegasus.freiberg-net.de) Received: from pegasus.freiberg-net.de (localhost.freiberg-net.de [127.0.0.1]) i0A9Lk6T000443; Sat, 10 Jan 2004 10:21:46 +0100 (CET) (envelope-from holm@pegasus.freiberg-net.de) Received: (from holm@localhost) by pegasus.freiberg-net.de (8.12.10/8.12.10/Submit) id i0A9Lj9N000441; Sat, 10 Jan 2004 10:21:45 +0100 (CET) (envelope-from holm) Date: Sat, 10 Jan 2004 10:21:45 +0100 From: Holm Tiffe To: Rob Message-ID: <20040110092145.GA118@pegasus.freiberg-net.de> References: <20040109121513.GA57018@pegasus.freiberg-net.de> <200411011523.232363@cartman> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200411011523.232363@cartman> User-Agent: Mutt/1.4.1i Organization: FreibergNet Internet Services Priority: normal X-Phone: +49-3731-781279 X-Fax: +49-3731-781377 X-PGP-fingerprint: 86 EC A5 63 B5 28 78 13 8B FC E9 09 04 6E 86 FC cc: freebsd-alpha@freebsd.org Subject: Re: Mysql? X-BeenThere: freebsd-alpha@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: holm@freibergnet.de List-Id: Porting FreeBSD to the Alpha List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 10 Jan 2004 09:22:05 -0000 Rob wrote: > On Fri, 9 Jan 2004 13:15:13 +0100, Holm Tiffe wrote: > > Hi, > > > > > > has anyone got mysql to work properly on alpha? > > > > > > I've tried mysql-4.0.16 from the ports, 4.0.17, 4.1xx and I've got > > alsways the same error if I try to connect to the mysqld over tcp: > > > > # /usr/local/bin/mysqladmin -u root -h install password 'lolo' > > /usr/local/bin/mysqladmin: connect to server at 'install' failed > > error: 'Lost connection to MySQL server during query' > > > > > > the mysqld logs in this moment: > > > > > > pid 65409 (mysqld): unaligned access: va=0x11fff70c pc=0x160389bd4 > > ra=0x160389bc0 op=stq > > > > > > ll is fine if I connect the daemon over the unix domain socket: > > > > > > # /usr/local/bin/mysqladmin -u root -p password 'lolo' Enter > > password: (xxxx) # > > > > I do'nt think, that this is a FreeBSD issue, it looks like a mysql > > bug on 64bit Machines.... > > > > BTW: PostgreSQL works as expected, but I need mysql. > > I don't get any unaligned accesses on my Miata, are you building mysql with > any fancy optimisations? > > loop@erwin ~ % /usr/local/bin/mysqladmin -u root -h localhost -p 'status' > Enter password: > Uptime: 927362 Threads: 1 Questions: 40716 Slow queries: 0 Opens: 107 > Flush tables: 1 Open tables: 49 Queries per second avg: 0.044 > > loop@erwin ~ % pkg_info | grep mysql > mysql-client-4.0.17 Multithreaded SQL database (client) > mysql-server-4.0.17 Multithreaded SQL database (server) > > cheers, > Rob > I think this worky on my miata too: # /usr/local/bin/mysqladmin -u root -h localhost -p 'status' Enter password: Uptime: 87195 Threads: 1 Questions: 14 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.000 The Problem is occuring here, when I use the real hostname for the connections I'm unable to set the passwd for the empty root account. #/usr/local/bin/mysqladmin -u root -h install 'status' /usr/local/bin/mysqladmin: connect to server at 'install' failed error: 'Lost connection to MySQL server during query' 'install' is the hostname of the machine. (DNS entry used to install several machines, I'm changing the hostname later) In the /var/log/messages you can read this after the try: Jan 10 10:16:42 install mysqld[69662]: warning: can't get client address: Bad file descriptor and on stdout of mysqld the message about the unaligned access. There are no fancy optimisations used. Greetings, Holm -- L&P::Kommunikation GbR Holm Tiffe * Administration, Development FreibergNet.de Internet Systems phone +49 3731 41930 Bereich Server & Technik fax +49 3731 4196026 D-09599 Freiberg * Nonnengasse 31a http://www.freibergnet.de