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: [EMAIL PROTECTED] [mailto:users- : [EMAIL PROTECTED] On Behalf Of Sdävtaker : Sent: Friday, August 10, 2007 00:12 : To: users@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 :