Mysql?

[Holm Tiffe]

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 at 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 at 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