Troubles with mysql-server installation

[Adrian Michael Nida]

Sdav,

This is just a thought.  I noticed that /usr/pkg/libexec/mysqld is looking
for ./mysql/host.frm.  However, it's located in /var/mysql/host.frm.  I'm
wondering if you were to move that file (or link it) to
/usr/pkg/libexec/mysqld/mysql/host.frm would it work better.

Good luck,

Adrian

: -----Original Message-----
: From: users-errors at crater.dragonflybsd.org [mailto:users-
: errors at crater.dragonflybsd.org] On Behalf Of Sdävtaker
: Sent: Friday, August 10, 2007 00:12
: To: users at crater.dragonflybsd.org
: Subject: Troubles with mysql-server installation
: 
: Hey downloaded and installed the mysql-server-5.0.41.tgz
: I could succecssfully make the client work (i can connect to another
: mysql server in different machine, running different OS).
: But i cant start up the Mysql Server in my DFBSD :-/
: I could successfully run the intall_db script.
: I cant change user root password or start the server.
: 
: I found this error.
: # mysql.server start
: Starting MySQL..kill: 1557: No such process
:   ERROR!
: 
: In log says:
: 
: 070309 22:03:10  Starting mysqld daemon with databases from /var/mysql
: 070309 22:03:10  mysqld started
: 070809 22:03:11  InnoDB: Database was not shut down normally!
: InnoDB: Starting crash recovery.
: InnoDB: Reading tablespace information from the .ibd files...
: InnoDB: Restoring possible half-written data pages from the doublewrite
: InnoDB: buffer...
: 070809 22:03:12  InnoDB: Starting log scan based on checkpoint at
: InnoDB: log sequence number 0 36808.
: InnoDB: Doing recovery: scanned up to log sequence number 0 43655
: 070809 22:03:12  InnoDB: Starting an apply batch of log records to the
: database...
: InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
: 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
: 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
: 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
: 91 92 93 94 95 96 97 98 99
: InnoDB: Apply batch completed
: 070809 22:03:12  InnoDB: Started; log sequence number 0 43655
: 070809 22:03:12 [ERROR] /usr/pkg/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 070809 22:03:12 [ERROR] /usr/pkg/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 070809 22:03:12 [ERROR] Fatal error: Can't open and lock privilege
: tables: Can't find file: './mysql/host.frm' (errno: 13)
: 070309 22:03:12  STOPPING server from pid file
: /var/mysql/unhost.com.ar.pid
: 070309 22:03:12  mysqld ended
: 
: After that i look for the missed file:
: #find / -name host.frm
: /var/mysql/mysql/host.frm
: 
: Im using almost the original my.cnf that comes with the pkg, its
: mysql-small.cnf with only change in the ports (hardcoded 3306) and DBD
: is disabled.
: 
: Any idea, im sure im misslooking something.
: Thanks for any help, im still pretty newbie.
: Sdav
: