Re: Mysql Bug 04/01/11
Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com wrote:
Re: Mysql Bug 04/01/11
Hi, On 2-4-2011 2:18, Thomas Dineen wrote: Can't find file: './mysql/host.frm' (errno: 13) http://tinyurl.com/3sc3ydx -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql Bug 04/01/11
Am 02.04.2011 02:18, schrieb Thomas Dineen: Gentlemen: - Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! what have you done the whole time? have you tried RTFM? we are not here to guide a blind one trough a basic setup because at the end you have something running and understodd nothing! sounds like you never before had used mysql and missing all the basics from the first chapters in the well written documentation - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz - When installed and started with the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) you should read the manuals or use a operating system with packages which are idiot-proof, fedora does this for you: if [ ! -d $datadir/mysql ] ; then # First, make sure $datadir is there with correct permissions if [ ! -e $datadir -a ! -h $datadir ] then mkdir -p $datadir || exit 1 fi chown mysql:mysql $datadir chmod 0755 $datadir [ -x /sbin/restorecon ] /sbin/restorecon $datadir # Now create the database action $Initializing MySQL database: /usr/bin/mysql_install_db --datadir=$datadir --user=mysql ret=$? chown -R mysql:mysql $datadir if [ $ret -ne 0 ] ; then return $ret fi fi 1) Please identify where the missing file can be found, keeping in mind that I just installed and have no backup (of the current rev.) they CAN NOT BE FOUND if you have a fresh install and not used mysql_install_db and WHERE they are created depends on your configuration as said yesterday let me guess: you even have not spent any second for your my.cnf? [mysqld] datadir = /where/ever/you/want/your/databases/jesus/christ on my system typing mysql_ followed with 2 x TAB brings a list of commands since you think you must not use a environments package-system why in the world do you not look in your bin-folder at /usr/local/mysql/ and read some docs to understand that the mysql-database is the userdb [root@srv-rhsoft:~]$ mysql_ mysql_client_test mysql_convert_table_format mysql_fix_extensions mysql_secure_installation mysql_tzinfo_to_sql mysql_upgrade_replication mysql_zap mysql_configmysql_find_rows mysql_install_db mysql_setpermission mysql_upgrade mysql_waitpid signature.asc Description: OpenPGP digital signature
Re: Mysql Bug 04/01/11
Reindl Harald, I would appreciate if you could please lower your tones. and keep this list as professional as it has always been, this is not a nerds forum. There is always someone that knows more than you but he's not shouting at you everytime you say something wrong. If you think that a question is not worth answering just dont answer, while if you answer do it in a useful way, so that all the community can only improve from it, do you find this useful? *Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) *Solution*: RTFM Next time breathe 10 times deep, and reply! This is just my opinion. Sincerely, Claudio 2011/4/2 Reindl Harald h.rei...@thelounge.net Am 02.04.2011 02:18, schrieb Thomas Dineen: Gentlemen: - Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! what have you done the whole time? have you tried RTFM? we are not here to guide a blind one trough a basic setup because at the end you have something running and understodd nothing! sounds like you never before had used mysql and missing all the basics from the first chapters in the well written documentation - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz - When installed and started with the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) you should read the manuals or use a operating system with packages which are idiot-proof, fedora does this for you: if [ ! -d $datadir/mysql ] ; then # First, make sure $datadir is there with correct permissions if [ ! -e $datadir -a ! -h $datadir ] then mkdir -p $datadir || exit 1 fi chown mysql:mysql $datadir chmod 0755 $datadir [ -x /sbin/restorecon ] /sbin/restorecon $datadir # Now create the database action $Initializing MySQL database: /usr/bin/mysql_install_db --datadir=$datadir --user=mysql ret=$? chown -R mysql:mysql $datadir if [ $ret -ne 0 ] ; then return $ret fi fi 1) Please identify where the missing file can be found, keeping in mind that I just installed and have no backup (of the current rev.) they CAN NOT BE FOUND if you have a fresh install and not used mysql_install_db and WHERE they are created depends on your configuration as said yesterday let me guess: you even have not spent any second for your my.cnf? [mysqld] datadir = /where/ever/you/want/your/databases/jesus/christ on my system typing mysql_ followed with 2 x TAB brings a list of commands since you think you must not use a environments package-system why in the world do you not look in your bin-folder at /usr/local/mysql/ and read some docs to understand that the mysql-database is the userdb [root@srv-rhsoft:~]$ mysql_ mysql_client_test mysql_convert_table_format mysql_fix_extensionsmysql_secure_installation mysql_tzinfo_to_sql mysql_upgrade_replication mysql_zap mysql_configmysql_find_rows mysql_install_db mysql_setpermission mysql_upgrade mysql_waitpid -- Claudio
Re: Mysql Bug 04/01/11: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
Am 02.04.2011 02:18, schrieb Thomas Dineen: The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) BTW: you know google? Can't find file: './mysql/host.frm' (errno: 13) http://bugs.mysql.com/bug.php?id=1279 so this is a permissions-problem i guess there is a data-dir in the tar.gz you installed as root and you did not change its permissions Keep in mind that I have tried several dozen experiments over many late hours with a version host.frm from a older version of mysql with NO success! I have tried putting it in every possible location. Using 777 file permissions. you should not blind copy files without any idea what you are doing root@Sun# pwd /usr/local/mysql root@Sun# ls bin infoman mysql-test var host.frmlib my.cnf share include libexec mysql sql-bench delete the host.from from here and everywhere you placed it and please open your eyes if you too lazy read documentations you see the folder var? _ RTFM (google: mysql /usr/local default datadir): http://dev.mysql.com/doc/refman/5.0/en/starting-server.html If you get Errcode 13 (which means Permission denied) when starting mysqld, this means that the privileges of the data directory or its contents do not permit server access. In this case, you change the permissions for the involved files and directories so that the server has the right to use them. You can also start the server as root, but this raises security issues and should be avoided. On Unix, change location into the data directory and check the ownership of the data directory and its contents to make sure the server has access. For example, if the data directory is /usr/local/mysql/var, use this command: shell ls -la /usr/local/mysql/var If the data directory or its files or subdirectories are not owned by the login account that you use for running the server, change their ownership to that account. If the account is named mysql, use these commands: shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql/var signature.asc Description: OpenPGP digital signature
Re: Mysql Bug 04/01/11
Am 02.04.2011 13:11, schrieb Claudio Nanni: Reindl Harald, I would appreciate if you could please lower your tones. and keep this list as professional as it has always been, this is not a nerds forum. *Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) *Solution*: RTFM Next time breathe 10 times deep, and reply! WTF? Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! and not look ONE TIME in the basic-manual in this 50 hours is the wrong way, everytime, everywhere and with every software peopole spent many hours to writing documentation! this is the start BEFORE mailing-list: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html yes, is something unclear after that there is a starting-point for questions but not i do not read docs, say me exactly where the problem is signature.asc Description: OpenPGP digital signature
Got It; Thank You; Re: Mysql Bug 04/01/11
Got It; Thank You, Thank You, Thank You On 4/1/2011 11:28 PM, Claudio Nanni wrote: Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com mailto:tdin...@ix.netcom.com wrote:
Mysql Bug 04/01/11
Gentlemen: - Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz - When installed and started with the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 1) Please identify where the missing file can be found, keeping in mind that I just installed and have no backup (of the current rev.). 2) If we are installing in /usr/local/mysql where exactly dose this file belong, (exact path please). 3) What exactly do the file ownersiip and permissions have to be? Keep in mind that I have tried several dozen experiments over many late hours with a version host.frm from a older version of mysql with NO success! I have tried putting it in every possible location. Using 777 file permissions. A snapshot of my system: root@Sun# pwd /usr/local/mysql root@Sun# ls bin infoman mysql-test var host.frmlib my.cnf share include libexec mysql sql-bench root@Sun# ls -la host.frm -rwxrwxrwx 1 root root9064 Apr 1 16:39 host.frm root@Sun# ls -la mysql total 22 drwxrwxrwx 2 root root 512 Apr 1 16:34 . drwxr-xr-x 13 bin bin 512 Apr 1 16:39 .. -rwxrwxrwx 1 root root9064 Apr 1 16:34 host.frm - The entire transcript is shown below: 10401 16:39:27 mysqld started 110401 16:39:27 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:39:27 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 110401 16:39:27 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... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 110401 16:39:27 InnoDB: Starting an apply batch of log records to the database ... InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 5 1 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 110401 16:39:27 InnoDB: Started; log sequence number 0 43655 110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:39:27 [ERROR] Fatal error: Can't open and lock privilege tables: Can' t find file: './mysql/host.frm' (errno: 13) 110401 16:39:27 mysqld ended 110401 16:42:30 mysqld started 110401 16:42:30 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:42:30 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 110401 16:42:30 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... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 110401 16:42:30 InnoDB: Starting an apply batch of log records to the database ... InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 5 1 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 110401 16:42:30 InnoDB: Started; log sequence number 0 43655 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:42:30 [ERROR] Fatal error: Can't open and lock privilege tables: Can' t find file: './mysql/host.frm' (errno: 13) 110401 16:42:30 mysqld ended root@Sun# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org