[MYSQL] Probleme permissions

Le
Thierry
Bonjour,
J'ai un soucis avec mysql/freebsd 6.2 :


-bash-2.05b$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> show databases;
+--+
| Database |
+--+
| information_schema |
| avions |
| copper |
| egroupdb |
| mysql |
| test |
+--+
6 rows in set (0.10 sec)

mysql> use egroudb;
ERROR 1049 (42000): Unknown database 'egroudb'
mysql> use egroupdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)


J'ai verifie les permissions, elles me sembles bonnes:

bash-2.05b# cd /var/db/
drwx 7 mysql mysql 9216 Jan 3 19:49 mysql
bash-2.05b# cd mysql
drwx 2 mysql mysql 11264 Jan 2 20:20 egroupdb

Les tables sont toutes: -rw-rw- 1 mysql mysql

Merci pour votre aide.
Vidéos High-Tech et Jeu Vidéo
Téléchargements
Vos réponses
Gagnez chaque mois un abonnement Premium avec GNT : Inscrivez-vous !
Trier par : date / pertinence
Thierry
Le #21884691
Thierry a écrit :
Bonjour,
J'ai un soucis avec mysql/freebsd 6.2 :


-bash-2.05b$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.0.51-log FreeBSD port: mysql-server-5.0.51

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| avions |
| copper |
| egroupdb |
| mysql |
| test |
+--------------------+
6 rows in set (0.10 sec)

mysql> use egroudb;
ERROR 1049 (42000): Unknown database 'egroudb'
mysql> use egroupdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './egroupdb/' (errno: 24)


J'ai verifie les permissions, elles me sembles bonnes:

bash-2.05b# cd /var/db/
drwx------ 7 mysql mysql 9216 Jan 3 19:49 mysql
bash-2.05b# cd mysql
drwx------ 2 mysql mysql 11264 Jan 2 20:20 egroupdb

Les tables sont toutes: -rw-rw---- 1 mysql mysql

Merci pour votre aide.






Je viens aussi de trouver ces logs:

080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_mimetypes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_prefixes.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_quota.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_quota.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_shares.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_shares.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)
080103 19:50:39 [ERROR] /usr/local/libexec/mysqld: Can't open file:
'./egroupdb/phpgw_vfs2_versioning.frm' (errno: 24)


Et pourtant: -rw-rw---- 1 mysql mysql 8788 Jan 2 20:20
phpgw_vfs2_mimetypes.frm ... meme chose pour les autres ....
Publicité
Poster une réponse
Anonyme