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 info man mysql-test var
host.frm lib my.cnf share
include libexec mysql sql-bench

root@Sun# ls -la host.frm
-rwxrwxrwx 1 root root 9064 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 root 9064 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=gcdmg-mysql-2@m.gmane.org

Re: Mysql Bug 04/01/11

--90e6ba61374a00c103049fe9a385
Content-Type: text/plain; charset=ISO-8859-1

Hi Thomas,
Did you run the post install script?

http://kae.li/iiikj

Claudio
On Apr 2, 2011 2:20 AM, "Thomas Dineen" wrote:

--90e6ba61374a00c103049fe9a385--

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=gcdmg-mysql-2@m.gmane.org

Re: Mysql Bug 04/01/11

--------------enigB55083CBE96F9BB259E92F41
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable


Am 02.04.2011 02:18, schrieb Thomas Dineen:
>> Gentlemen:
>>=20
>> - Keep in mind that I have approximately 50 hours into this Mysql ser=
ver 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
>>=20
>> - When installed and started with the following command:
>> /usr/local/mysql/bin/mysqld_safe --user=3Dmysql &
>>=20
>> The following error occurs:
>> 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find fi=
le: './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 --data=
dir=3D"$datadir" --user=3Dmysql
ret=3D$?
chown -R mysql:mysql "$datadir"
if [ $ret -ne 0 ] ; then
return $ret
fi
fi

>> 1) Please identify where the missing file can be found,=20
>> keeping in mind that I just installed and have no backup=20
>> (of the current rev.)

they CAN NOT BE FOUND if you have a fresh install and not used "mysql_ins=
tall_db"
and WHERE they are created depends on your configuration as said yesterda=
y

let me guess: you even have not spent any second for your my.cnf?
> [mysqld]
> datadir =3D /where/ever/you/want/your/databases/jesus/christ

on my system typing mysql_ followed with 2 x TAB brings a list of command=
s
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_extensi=
ons mysql_secure_installation
mysql_tzinfo_to_sql mysql_upgrade_replication mysql_zap
mysql_config mysql_find_rows mysql_install_db =
mysql_setpermission
mysql_upgrade mysql_waitpid


--------------enigB55083CBE96F9BB259E92F41
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2W/mIACgkQhmBjz394Ann7uwCeO9iSXHZh/JtcLdHwTyRd rQZ5
ljIAmQEJiEGdZHjG3N14y4bZt6sdbeBG
=j74F
-----END PGP SIGNATURE-----

--------------enigB55083CBE96F9BB259E92F41--

Re: Mysql Bug 04/01/11

--20cf30426cc84dc277049fed95f2
Content-Type: text/plain; charset=ISO-8859-1

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

>
> 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_config mysql_find_rows mysql_install_db
> mysql_setpermission
> mysql_upgrade mysql_waitpid
>
>


--
Claudio

--20cf30426cc84dc277049fed95f2--

Re: Mysql Bug 04/01/11: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

--------------enig567BD777505B8DD593BF935C
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



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 fil=
e: './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=3D1279
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 info man mysql-test var
> host.frm lib 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 mysql=
d, 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 th=
em. 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 /u=
sr/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 nam=
ed mysql, use these commands:

shell> chown -R mysql /usr/local/mysql/var
shell> chgrp -R mysql /usr/local/mysql/var



--------------enig567BD777505B8DD593BF935C
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2XBtsACgkQhmBjz394AnlZVACfcDjoOiLoygQs49DffH8Y xbr7
VoEAoJeHFr9C+J1dcbwNdjfY5NQscCVP
=53/w
-----END PGP SIGNATURE-----

--------------enig567BD777505B8DD593BF935C--

Re: Mysql Bug 04/01/11

--------------enig436A908EBBEB1B1236A9769B
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 02.04.2011 13:11, schrieb Claudio Nanni:
> Reindl Harald,
>=20
> 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 questi=
ons
but not "i do not read docs, say me exactly where the problem is"




--------------enig436A908EBBEB1B1236A9769B
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk2XCGkACgkQhmBjz394Anlw5ACfWFugQpBgYRBfdReHu3OM t8lh
/nwAoJuIskdJYLkedaHTWFcAoQ8k62TE
=mDqS
-----END PGP SIGNATURE-----

--------------enig436A908EBBEB1B1236A9769B--

Got It; Thank You; Re: Mysql Bug 04/01/11

--------------030604060604090500090001
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


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" > > wrote:


--------------030604060604090500090001--