Date: Sat, 10 Jan 2004 10:21:45 +0100 From: Holm Tiffe <holm@freibergnet.de> To: Rob <robbyrnes@ozemail.com.au> Cc: freebsd-alpha@freebsd.org Subject: Re: Mysql? Message-ID: <20040110092145.GA118@pegasus.freiberg-net.de> In-Reply-To: <200411011523.232363@cartman> References: <20040109121513.GA57018@pegasus.freiberg-net.de> <200411011523.232363@cartman>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040110092145.GA118>