Can"t read dir of "." (errno: 13)

Can"t read dir of "." (errno: 13)

am 19.01.2011 06:44:40 von Adarsh Sharma

Dear all,

I am facing the issue mentioned below while issuing show databases command.


root@s7-dt-bse:~# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.41-3ubuntu12.8 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> show databases ;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
mysql> show databases;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
mysql>

My Mysql data dir is /hdd2-1/myisam_data/*

Mysql is the owner and group of myisam_data folder.

Can I know why it occurs and how to debug it.


Thanks & Regards

Adarsh Sharma

--
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: Can"t read dir of "." (errno: 13)

am 19.01.2011 08:06:54 von Adarsh Sharma

Hi , After some research I want a useful link that describes my problem.

Here is the link :

http://bugs.mysql.com/bug.php?id=15851

I don't think that this is a permission problem as I cross-check it.

But I am not able to remove it.




Thanks & Regards

Adarsh Sharma





Adarsh Sharma wrote:
> Dear all,
>
> I am facing the issue mentioned below while issuing show databases
> command.
>
>
> root@s7-dt-bse:~# mysql -uroot -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 5
> Server version: 5.1.41-3ubuntu12.8 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql> show databases ;
> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> mysql> show databases;
> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> mysql>
>
> My Mysql data dir is /hdd2-1/myisam_data/*
>
> Mysql is the owner and group of myisam_data folder.
>
> Can I know why it occurs and how to debug it.
>
>
> Thanks & Regards
>
> Adarsh Sharma
>


--
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: Can"t read dir of "." (errno: 13)

am 19.01.2011 08:57:36 von tibyke

> mysql> show databases ;
> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> mysql> show databases;
> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> mysql>

$ perror 13
OS error code 13: Permission denied

t

--
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: Can"t read dir of "." (errno: 13)

am 19.01.2011 09:25:27 von Yogesh Kore

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

Check owner of the MySQL data directory.

2011/1/19 Pint=E9r Tibor

> > mysql> show databases ;
> > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> > mysql> show databases;
> > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
> > mysql>
>
> $ perror 13
> OS error code 13: Permission denied
>
> t
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dyogeshkore@gmail.=
com
>
>

--20cf3054a7a568770f049a2ec24e--

RE: Can"t read dir of "." (errno: 13)

am 19.01.2011 14:47:47 von Jerry Schwartz

>-----Original Message-----
>From: Adarsh Sharma [mailto:adarsh.sharma@orkash.com]
>Sent: Wednesday, January 19, 2011 12:45 AM
>To: mysql@lists.mysql.com
>Subject: Can't read dir of '.' (errno: 13)
>
>Dear all,
>
>I am facing the issue mentioned below while issuing show databases command.
>
>
>root@s7-dt-bse:~# mysql -uroot -p
>Enter password:
>Welcome to the MySQL monitor. Commands end with ; or \g.
>Your MySQL connection id is 5
>Server version: 5.1.41-3ubuntu12.8 (Ubuntu)
>
>Type 'help;' or '\h' for help. Type '\c' to clear the current input
>statement.
>
>mysql> show databases ;
>ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
>mysql> show databases;
>ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
>mysql>
>
>My Mysql data dir is /hdd2-1/myisam_data/*
>
>Mysql is the owner and group of myisam_data folder.
>
>Can I know why it occurs and how to debug it.
>
[JS] I have a related question: how can MySQL authenticate a user if file
system permissions won't let it read any databases?

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com



>
>Thanks & Regards
>
>Adarsh Sharma
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jerry@gii.co.jp





--
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: Can"t read dir of "." (errno: 13)

am 19.01.2011 16:42:47 von Joerg Bruehe

Hi!


Jerry Schwartz wrote:
>> -[[...]]
>>
> [JS] I have a related question: how can MySQL authenticate a user if fi=
le=20
> system permissions won't let it read any databases?

To me, your question sounds like you forgot the difference between
server and client:

- The MySQL server processes always run as the same operating system
user (typically: "mysql"), and basic setup must ensure they have
access rights to all files storing the database contents.

- The client processes run on any machine (local or remote) as any user,
and that OS user may be totally unrelated to the database user that
will be authenticated.

Just assume some application (with privilege checks!) accessed via the
web: The web server (Apache, ...) executing the PHP (or other) code is
running with some OS user ID which is the same for all application
(database) users, and there is no need to define those application users
on the machine running the server processes of Apache or MySQL.


HTH,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Can"t read dir of "." (errno: 13)

am 19.01.2011 20:34:43 von Jerry Schwartz

>-----Original Message-----
>From: Joerg Bruehe [mailto:joerg.bruehe@oracle.com]
>Sent: Wednesday, January 19, 2011 10:43 AM
>To: mysql@lists.mysql.com
>Cc: Jerry Schwartz
>Subject: Re: Can't read dir of '.' (errno: 13)
>
>Hi!
>
>
>Jerry Schwartz wrote:
>>> -[[...]]
>>>
>> [JS] I have a related question: how can MySQL authenticate a user if file
>> system permissions won't let it read any databases?
>
>To me, your question sounds like you forgot the difference between
>server and client:
>
[JS] I don't think so, but perhaps I misunderstood the source of the error
message.

mysql> show databases ;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)

Are you saying that the mysql CLI needs to read some directory ('.', in this
case) in order to send mysqld a simple query like SHOW DATABASES? I would hope
it doesn't need a temporary file for that.

Who is issuing the errno 13, the client or the daemon?


Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com




>- The MySQL server processes always run as the same operating system
> user (typically: "mysql"), and basic setup must ensure they have
> access rights to all files storing the database contents.
>
>- The client processes run on any machine (local or remote) as any user,
> and that OS user may be totally unrelated to the database user that
> will be authenticated.
>
>Just assume some application (with privilege checks!) accessed via the
>web: The web server (Apache, ...) executing the PHP (or other) code is
>running with some OS user ID which is the same for all application
>(database) users, and there is no need to define those application users
>on the machine running the server processes of Apache or MySQL.
>
>
>HTH,
>Jörg
>
>--
>Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
>ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
>Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
>Amtsgericht Muenchen: HRA 95603





--
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: Can"t read dir of "." (errno: 13)

am 19.01.2011 20:56:13 von Joerg Bruehe

Hi !


Jerry Schwartz wrote:
>> -----Original Message-----
>> From: Joerg Bruehe [mailto:joerg.bruehe@oracle.com]
>> Sent: Wednesday, January 19, 2011 10:43 AM
>> To: mysql@lists.mysql.com
>> Cc: Jerry Schwartz
>> Subject: Re: Can't read dir of '.' (errno: 13)
>>
>> Hi!
>>
>>
>> Jerry Schwartz wrote:
>>>> -[[...]]
>>>>
>>> [JS] I have a related question: how can MySQL authenticate a user if =
file
>>> system permissions won't let it read any databases?
>> To me, your question sounds like you forgot the difference between
>> server and client:
>>
> [JS] I don't think so, but perhaps I misunderstood the source of the er=
ror=20
> message.
>=20
> mysql> show databases ;
> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
>=20
> Are you saying that the mysql CLI needs to read some directory ('.', in=
this=20
> case) in order to send mysqld a simple query like SHOW DATABASES? I wou=
ld hope=20
> it doesn't need a temporary file for that.

No, I didn't say that.

You say that "the mysql CLI ... send(s) mysqld a simple query ...", and
that is correct: the client ("mysql") sends the command "show databases"
to the server ("mysqld").
To process this, the server has to check the file(s) and directory(ies)
used to store the database contents, and one of those actions is to read
the current directory.

>=20
> Who is issuing the errno 13, the client or the daemon?

AIUI, it is the server, encountering a permission problem.
So the server encounters a problem, and it reports this back to the
client who will then output the message.


Your question that triggered my original reply was:
how can MySQL authenticate a user if file system permissions
won't let it read any databases?

My original reply tried to make it obvious that the user (who is to be
authenticated) is just a database concept, so this (maybe non-existing)
user's (possibly missing) permissions in the operating system to read
any OS object (file, directory) do not matter at all when the MySQL
server does the authentication.
It is the server (process) that needs the permissions to read (and
write) database directories and files.

Of course, if these permissions are missing, then the server cannot
operate (and so also cannot authenticate a user), but that is a question
of server setup and not of database user privileges.


HTH,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Can"t read dir of "." (errno: 13)

am 19.01.2011 22:11:07 von Jerry Schwartz

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com

>-----Original Message-----
>From: Joerg Bruehe [mailto:joerg.bruehe@oracle.com]
>Sent: Wednesday, January 19, 2011 2:56 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Can't read dir of '.' (errno: 13)
>
>Hi !
>
>
>Jerry Schwartz wrote:
>>> -----Original Message-----
>>> From: Joerg Bruehe [mailto:joerg.bruehe@oracle.com]
>>> Sent: Wednesday, January 19, 2011 10:43 AM
>>> To: mysql@lists.mysql.com
>>> Cc: Jerry Schwartz
>>> Subject: Re: Can't read dir of '.' (errno: 13)
>>>
>>> Hi!
>>>
>>>
>>> Jerry Schwartz wrote:
>>>>> -[[...]]
>>>>>
>>>> [JS] I have a related question: how can MySQL authenticate a user if file
>>>> system permissions won't let it read any databases?
>>> To me, your question sounds like you forgot the difference between
>>> server and client:
>>>
>> [JS] I don't think so, but perhaps I misunderstood the source of the error
>> message.
>>
>> mysql> show databases ;
>> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
>>
>> Are you saying that the mysql CLI needs to read some directory ('.', in
>> this
>> case) in order to send mysqld a simple query like SHOW DATABASES? I would
>hope
>> it doesn't need a temporary file for that.
>
>No, I didn't say that.
>
>You say that "the mysql CLI ... send(s) mysqld a simple query ...", and
>that is correct: the client ("mysql") sends the command "show databases"
>to the server ("mysqld").
>To process this, the server has to check the file(s) and directory(ies)
>used to store the database contents, and one of those actions is to read
>the current directory.
>
>>
>> Who is issuing the errno 13, the client or the daemon?
>
>AIUI, it is the server, encountering a permission problem.
>So the server encounters a problem, and it reports this back to the
>client who will then output the message.
>
>
>Your question that triggered my original reply was:
> how can MySQL authenticate a user if file system permissions
> won't let it read any databases?
>
>My original reply tried to make it obvious that the user (who is to be
>authenticated) is just a database concept, so this (maybe non-existing)
>user's (possibly missing) permissions in the operating system to read
>any OS object (file, directory) do not matter at all when the MySQL
>server does the authentication.
>It is the server (process) that needs the permissions to read (and
>write) database directories and files.
>
>Of course, if these permissions are missing, then the server cannot
>operate (and so also cannot authenticate a user), but that is a question
>of server setup and not of database user privileges.
>
[JS] Sorry, that still doesn't make sense to em. To authenticate the user,
mysqld needs to read the mysql database. That is also where the databases are
listed (in `mysql`.`db`). If the daemon can read `mysql`.`user`, why can't it
read `mysql`.`db`? It's a MyISAM database, so everything is in the same file.

What am I missing? Does SHOW DATABASES do something other than pull the
database names out of `mysql`.`db`?

>
>HTH,
>Jörg
>
>--
>Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
>ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
>Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
>Amtsgericht Muenchen: HRA 95603





--
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: Can"t read dir of "." (errno: 13)

am 19.01.2011 22:58:29 von Reindl Harald

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

One simple querstion:

did you try "chown -R mysql:mysql /your/whole/data/dir"
if not do this and after that the problem is gone
or not - if it's gone all is ok, if not let us look
for other ideas

And yes it is possible tha mysql can authenticate the
user when bad permissions came after caching some
information and if your query nneeds access to non cached
data you have a problem

Am 19.01.2011 20:56, schrieb Joerg Bruehe:
> Hi !
>=20
>=20
> Jerry Schwartz wrote:
>>> -----Original Message-----
>>> From: Joerg Bruehe [mailto:joerg.bruehe@oracle.com]
>>> Sent: Wednesday, January 19, 2011 10:43 AM
>>> To: mysql@lists.mysql.com
>>> Cc: Jerry Schwartz
>>> Subject: Re: Can't read dir of '.' (errno: 13)
>>>
>>> Hi!
>>>
>>>
>>> Jerry Schwartz wrote:
>>>>> -[[...]]
>>>>>
>>>> [JS] I have a related question: how can MySQL authenticate a user if=
file
>>>> system permissions won't let it read any databases?
>>> To me, your question sounds like you forgot the difference between
>>> server and client:
>>>
>> [JS] I don't think so, but perhaps I misunderstood the source of the e=
rror=20
>> message.
>>
>> mysql> show databases ;
>> ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
>>
>> Are you saying that the mysql CLI needs to read some directory ('.', i=
n this=20
>> case) in order to send mysqld a simple query like SHOW DATABASES? I wo=
uld hope=20
>> it doesn't need a temporary file for that.
>=20
> No, I didn't say that.
>=20
> You say that "the mysql CLI ... send(s) mysqld a simple query ...", and=

> that is correct: the client ("mysql") sends the command "show databases=
"
> to the server ("mysqld").
> To process this, the server has to check the file(s) and directory(ies)=

> used to store the database contents, and one of those actions is to rea=
d
> the current directory.
>=20
>>
>> Who is issuing the errno 13, the client or the daemon?
>=20
> AIUI, it is the server, encountering a permission problem.
> So the server encounters a problem, and it reports this back to the
> client who will then output the message.
>=20
>=20
> Your question that triggered my original reply was:
> how can MySQL authenticate a user if file system permissions
> won't let it read any databases?
>=20
> My original reply tried to make it obvious that the user (who is to be
> authenticated) is just a database concept, so this (maybe non-existing)=

> user's (possibly missing) permissions in the operating system to read
> any OS object (file, directory) do not matter at all when the MySQL
> server does the authentication.
> It is the server (process) that needs the permissions to read (and
> write) database directories and files.
>=20
> Of course, if these permissions are missing, then the server cannot
> operate (and so also cannot authenticate a user), but that is a questio=
n
> of server setup and not of database user privileges.
>=20
>=20
> HTH,
> Jörg
>=20

--=20

Mit besten Grüßen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofmühlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/


--------------enigD55F4E67322F32424CAC0765
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/

iEYEARECAAYFAk03XoUACgkQhmBjz394AnmzNgCgimI69VPJiALYAza0Ibm9 0W7F
FfcAn2ZUP+uT9L5CxND6pfQCHVkH+wN6
=I9Kb
-----END PGP SIGNATURE-----

--------------enigD55F4E67322F32424CAC0765--

Re: Can"t read dir of "." (errno: 13)

am 20.01.2011 12:53:32 von Joerg Bruehe

Hi!


Jerry Schwartz wrote:
> [[...]]
>=20
>> [[...]]
>>
> [JS] Sorry, that still doesn't make sense to em. To authenticate the us=
er,=20
> mysqld needs to read the mysql database. That is also where the databas=
es are=20
> listed (in `mysql`.`db`). If the daemon can read `mysql`.`user`, why ca=
n't it=20
> read `mysql`.`db`? It's a MyISAM database, so everything is in the same=
file.

Now I understand how your question was meant - sorry to explain a
completely different issue first.

About reading files: MyISAM is stored file-per-table, so the table
"mysql.user" is stored in the three files "mysql/user.{frm,MYD,MYI}";
table "mysql.db" is stored in other files which might have got different
permissions. (This would be a handling error, obviously.)

>=20
> What am I missing? Does SHOW DATABASES do something other than pull the=
=20
> database names out of `mysql`.`db`?

AIUI, there are operations for which the server wants to read the
directory, and "show databases" seems to be one of them.
For examples, see these bug reports:
http://bugs.mysql.com/bug.php?id=3D22615
http://bugs.mysql.com/bug.php?id=3D42676
http://bugs.mysql.com/bug.php?id=3D51399
Sorry - I would tell you more details, if I knew them for sure.

Now, consider a case like this:
drwx--x--x user-A group-B .
-rw-rw-rw- user-A group-B file

In this case, "file" would be readable (and even writable) for everybody
knowing the name, but a "ls ." would fail for everybody but "user-A":
There is no "read" permission on the directory for anybody but the owner.=



Regards,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Can"t read dir of "." (errno: 13)

am 20.01.2011 16:22:41 von Jerry Schwartz

>-----Original Message-----
>From: Joerg Bruehe [mailto:joerg.bruehe@oracle.com]
>Sent: Thursday, January 20, 2011 6:54 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Can't read dir of '.' (errno: 13)
>
>Hi!
>
>
>Jerry Schwartz wrote:
>> [[...]]
>>
>>> [[...]]
>>>
>> [JS] Sorry, that still doesn't make sense to em. To authenticate the user,
>> mysqld needs to read the mysql database. That is also where the databases
>> are
>> listed (in `mysql`.`db`). If the daemon can read `mysql`.`user`, why can't
>> it
>> read `mysql`.`db`? It's a MyISAM database, so everything is in the same
>> file.
>
>Now I understand how your question was meant - sorry to explain a
>completely different issue first.
>
[JS] No problem. To me, knowledge is never useless.

>About reading files: MyISAM is stored file-per-table, so the table
>"mysql.user" is stored in the three files "mysql/user.{frm,MYD,MYI}";
>table "mysql.db" is stored in other files which might have got different
>permissions. (This would be a handling error, obviously.)
>
[JS] Stranger things have happened. I could tell tales that would turn your
hair white (mine already is).
>>
>> What am I missing? Does SHOW DATABASES do something other than pull the
>> database names out of `mysql`.`db`?
>
>AIUI, there are operations for which the server wants to read the
>directory, and "show databases" seems to be one of them.
>For examples, see these bug reports:
> http://bugs.mysql.com/bug.php?id=22615
> http://bugs.mysql.com/bug.php?id=42676
> http://bugs.mysql.com/bug.php?id=51399
>Sorry - I would tell you more details, if I knew them for sure.
>
[JS] It never occurred to me that SHOW DATABASE would scan the file directory.
Johan De Meersman came up with the same explanation.

>Now, consider a case like this:
> drwx--x--x user-A group-B .
> -rw-rw-rw- user-A group-B file
>
>In this case, "file" would be readable (and even writable) for everybody
>knowing the name, but a "ls ." would fail for everybody but "user-A":
>There is no "read" permission on the directory for anybody but the owner.
>
[JS] Got it.
>
>Regards,
>Jörg
>
>--
>Joerg Bruehe, MySQL Build Team, joerg.bruehe@oracle.com
>ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
>Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
>Amtsgericht Muenchen: HRA 95603





--
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