Re: Can't find file: './mysql/host.frm'
Allen Wayne Best wrote: hello; I am having a spot of trouble getting to MySQL to start. Here is the message: 050407 22:43:49 mysqld started 050407 22:43:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) I looked at the /var/log/messages file and found this: Apr 6 05:18:17 cenozoic mysqld: Stopping MySQL: succeeded Apr 6 05:18:19 cenozoic kernel: audit(1112789899.123:0): avc: denied { read } for pid=8826 exe=/usr/libexec/mysqld name=host.frm dev=sda2 ino=605700 scontext=system_u:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file Apr 6 05:18:29 cenozoic mysqld: Starting MySQL: failed try setenforce 0 in shell and restart mysql. -- Mikael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't find file: './mysql/host.frm'
mikael thank you very kindly; that did the trick. On Saturday 09 April 2005 16:49, Mikael Fridh pronounced: Allen Wayne Best wrote: hello; I am having a spot of trouble getting to MySQL to start. Here is the message: 050407 22:43:49 mysqld started 050407 22:43:49 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) I looked at the /var/log/messages file and found this: Apr 6 05:18:17 cenozoic mysqld: Stopping MySQL: succeeded Apr 6 05:18:19 cenozoic kernel: audit(1112789899.123:0): avc: denied { read } for pid=8826 exe=/usr/libexec/mysqld name=host.frm dev=sda2 ino=605700 scontext=system_u:system_r:mysqld_t tcontext=root:object_r:var_lib_t tclass=file Apr 6 05:18:29 cenozoic mysqld: Starting MySQL: failed try setenforce 0 in shell and restart mysql. -- Mikael -- regards, allen wayne best, esq your friendly neighborhood rambler owner my rambler will go from 0 to 105 Current date: 16:25:18::98:2005 More than any time in history, mankind now faces a crossroads. One path leads to despair and utter hopelessness, the other to total extinction. Let us pray that we have the wisdom to choose correctly. -- Woody Allen, Side Effects -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't find file: './mysql/host.frm' (errno: 13)
# [EMAIL PROTECTED] / 2003-06-23 16:16:50 -0400: I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ... but now I get this error in the log file and I am unable to still start the MySQL Server. 030623 15:59:05 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) run perror 13 -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't find file: './mysql/host.frm' (errno: 13)
Pushpinder Singh Garcha [EMAIL PROTECTED] wrote: I am installing MySQL on my Mac OS Jaguar system. I was having some trouble with the starting up my MySQL Server. I kpt getting mysqld ended error and my logs showed that file user.MYI was corrupted. So I decided to uninstall MySQl and re-install it. I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ... but now I get this error in the log file and I am unable to still start the MySQL Server. -- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Can't find file: './mysql/host.frm'
On Wednesday 11 December 2002 22:41, SLefevre at i-m-i-international dot com wrote: OK, I'm making progess on my MySQL problem. The log file says this: 021211 15:32:05 mysqld started 021211 15:32:05 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021211 15:32:05 mysqld ended I've run the mysql_install_db script when I first installed mysql. I ran it again just today. I copied the directory from /var/lib/mysql to /usr/libexec/mysql (mysqld is in /usr/libexec), yet it says it still can't find the host.frm. [root@server test]# less /usr/libexec/mysql/ total 116 drwxr-xr-x3 root root 4096 Dec 11 15:30 ./ drwxr-xr-x7 root root 4096 Dec 11 15:28 ../ ... -rw-r-1 root root 8958 Dec 11 15:29 host.frm So now host.frm is in three places, but I get the same error. [root@server libexec]# locate host.frm /usr/libexec/mysql/host.frm /var/lib/mysql/mysql/host.frm /var/lib/mysql/host.frm Where the heck does it think it should be? It should be located in the directory of database 'mysql'. MySQL can't find the file because it doesn't have permissions on it. $ perror 13 Error code 13: Permission denied -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find file ./mysql/host.frm
chown -R mysql /var/lib/mysql [EMAIL PROTECTED] wrote: Description: When starting safe_mysqld mysqld shutsdown immediately with no error message. However looking at /var/lib/mysql/matrix.err gives the following error messages:- mysqld started /usr/libexec/mysqld: can't find file: './mysql/host.frm' errno: 13 mysqld ended /var/lib/mysql/mysql/host.frm exists, and I've tried linking it to various places, with no success. How-To-Repeat: Not sure, system is zipslack 8.0, with binary packages of apache, mysql, and mod_php installed from the zipslack site. Fix: Don't know Submitter-Id: submitter ID Originator: Richard Kirkcaldy [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Can't find ./mysql/host.frm Severity: critical Priority: high Category: mysql Class:support Release: mysql-3.23.39 (Source distribution) Environment: 486, zipslack 8.0 System: Linux matrix 2.2.19 #115 Thu Jun 21 14:07:22 PDT 2001 i486 unknown Architecture: i486 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 25 17:18 /lib/libc.so.6 - libc- 2.2.3.so -rwxr-xr-x1 root root 1159296 Jun 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 178 May 25 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with- unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql -- with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with- libwrap --without-bench i386-slackware-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find file: './mysql/host.frm' (errno: 13)
Neglected to mention the host.frm file _does_ exist. @ ls -al /usr/local/pkg/mysql/var/mysql/ total 134 drwx-- 2 root other512 Jun 1 07:53 . drwxr-xr-x 4 mysqlmysql512 Jun 4 09:17 .. -rw-rw 1 root other 0 Jun 1 07:53 columns_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 columns_priv.MYI -rw-rw 1 root other 8778 Jun 1 07:53 columns_priv.frm -rw-rw 1 root other302 Jun 1 07:53 db.MYD -rw-rw 1 root other 3072 Jun 1 07:53 db.MYI -rw-rw 1 root other 8982 Jun 1 07:53 db.frm -rw-rw 1 root other 0 Jun 1 07:53 func.MYD -rw-rw 1 root other 1024 Jun 1 07:53 func.MYI -rw-rw 1 root other 8641 Jun 1 07:53 func.frm -rw-rw 1 root other 0 Jun 1 07:53 host.MYD -rw-rw 1 root other 1024 Jun 1 07:53 host.MYI -rw-rw 1 root other 8958 Jun 1 07:53 host.frm -rw-rw 1 root other 0 Jun 1 07:53 tables_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 tables_priv.MYI -rw-rw 1 root other 8877 Jun 1 07:53 tables_priv.frm -rw-rw 1 root other428 Jun 1 07:53 user.MYD -rw-rw 1 root other 2048 Jun 1 07:53 user.MYI -rw-rw 1 root other 9148 Jun 1 07:53 user.frm On Mon, 4 Jun 2001, Mike Broxterman wrote: Downloaded, compiled, installed, ran mysql_install_db. However, when I try to start using safe_mysqld I get the Can't find file error. root@qsv-cmxdb1:...pkg/mysql bin/safe_mysqld Starting mysqld daemon with databases from /usr/local/pkg/mysql/var 010604 08:44:28 mysqld ended root@qsv-cmxdb1:...pkg/mysql tail var/qsv-cmxdb1.err 010604 08:44:28 mysqld started 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010604 8:44:28 /usr/local/pkg/mysql/libexec/mysqld: Normal shutdown 010604 08:44:28 mysqld ended mysqld Ver 3.23.38 for sun-solaris2.6 on sparc basedir: /usr/local/pkg/mysql/ datadir: /usr/local/pkg/mysql/var/ tmpdir: /var/tmp/ language:/usr/local/pkg/mysql/share/mysql/english/ pid file:/usr/local/pkg/mysql/var/qsv-cmxdb1.pid binary log: replication.log binary log index: TCP port:3306 Unix socket: /tmp/mysql.sock Options used to build mysql; sh CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/pkg/mysql --without-bench --without-debug --with-mysqld-user=mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find file: './mysql/host.frm' (errno: 13)
Mike Broxterman wrote: Neglected to mention the host.frm file _does_ exist. @ ls -al /usr/local/pkg/mysql/var/mysql/ total 134 drwx-- 2 root other512 Jun 1 07:53 . drwxr-xr-x 4 mysqlmysql512 Jun 4 09:17 .. -rw-rw 1 root other 0 Jun 1 07:53 columns_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 columns_priv.MYI -rw-rw 1 root other 8778 Jun 1 07:53 columns_priv.frm -rw-rw 1 root other302 Jun 1 07:53 db.MYD -rw-rw 1 root other 3072 Jun 1 07:53 db.MYI -rw-rw 1 root other 8982 Jun 1 07:53 db.frm -rw-rw 1 root other 0 Jun 1 07:53 func.MYD -rw-rw 1 root other 1024 Jun 1 07:53 func.MYI -rw-rw 1 root other 8641 Jun 1 07:53 func.frm -rw-rw 1 root other 0 Jun 1 07:53 host.MYD -rw-rw 1 root other 1024 Jun 1 07:53 host.MYI -rw-rw 1 root other 8958 Jun 1 07:53 host.frm -rw-rw 1 root other 0 Jun 1 07:53 tables_priv.MYD -rw-rw 1 root other 1024 Jun 1 07:53 tables_priv.MYI -rw-rw 1 root other 8877 Jun 1 07:53 tables_priv.frm -rw-rw 1 root other428 Jun 1 07:53 user.MYD -rw-rw 1 root other 2048 Jun 1 07:53 user.MYI -rw-rw 1 root other 9148 Jun 1 07:53 user.frm Mike: Any possibility you could have root do a chown mysql.mysql /usr/local/pkg/mysql/var/mysql/ -R? Then rerun the install_db. Looks like your package missed a step: chown. Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php