Здравейте колеги
Имам голям проблем с mysql-a в chroot
опитвам по следния начин:
yum --installroot=/chroot/lamp/ -c /chroot/yum.repos.d/fedora.repo install mysql-server
като предварително съм подготвил /dev/null, репозиторите и иницианизиранто на rpm базата данни
инсталира се, тук няма проблем
Първоначално се опитвам така:
chroot /chroot/lamp/ /etc/init.d/mysqld start
Казва ми че нама потребител mysql (въпреки че с очите си го виждам в /chroot/lam/etc/passwd i group)
влизам вътре в "затвора" (chroot /chroot/lamp; и добавм на ръка въпросния потребител)
След това пробвам отново:
chroot /chroot/lamp/ /etc/init.d/mysqld start
и вече се приближаваме към същината на проблема:
cat /chroot/lamp/var/log/mysqld.log
100325 04:53:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100325 4:53:44 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100325 4:53:44 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100325 4:53:44 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100325 04:53:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
изрично проверявам за правата на дирекирите които се съмнявам
и резултата е :
find /chroot/lamp/ -user mysql -ls
114320 4 drwxr-xr-x 2 mysql mysql 4096 Feb 21 07:00 /chroot/lamp/var/run/mysqld
100586 4 drwxrwx--- 2 mysql mysql 4096 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql
114411 12 -rwxrwx--- 1 mysql mysql 9510 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/host.frm
114338 16 -rwxrwx--- 1 mysql mysql 16384 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_keyword.MYI
114360 4 -rwxrwx--- 1 mysql mysql 3072 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_category.MYI
114373 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/func.MYI
114372 20 -rwxrwx--- 1 mysql mysql 18432 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_relation.MYI
114390 4 -rwxrwx--- 1 mysql mysql 35 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/general_log.CSM
114375 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/slow_log.CSV
114227 88 -rwxrwx--- 1 mysql mysql 88650 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_keyword.MYD
114410 24 -rwxrwx--- 1 mysql mysql 21497 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_category.MYD
114358 12 -rwxrwx--- 1 mysql mysql 8875 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/procs_priv.frm
114402 12 -rwxrwx--- 1 mysql mysql 10223 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/event.frm
114363 12 -rwxrwx--- 1 mysql mysql 8665 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/func.frm
114393 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_name.MYD
114354 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_transition.MYD
114337 12 -rwxrwx--- 1 mysql mysql 10466 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/user.frm
114342 12 -rwxrwx--- 1 mysql mysql 8955 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/tables_priv.frm
114351 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone.MYI
114403 12 -rwxrwx--- 1 mysql mysql 8776 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/general_log.frm
114409 12 -rwxrwx--- 1 mysql mysql 8770 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_topic.frm
114367 4 -rwxrwx--- 1 mysql mysql 332 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/user.MYD
114357 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:42 /chroot/lamp/var/lib/mysql/mysql/plugin.MYI
114374 20 -rwxrwx--- 1 mysql mysql 20480 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_topic.MYI
114346 12 -rwxrwx--- 1 mysql mysql 8778 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/ndb_binlog_index.frm
114394 4 -rwxrwx--- 1 mysql mysql 4096 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/columns_priv.MYI
114348 4 -rwxrwx--- 1 mysql mysql 2048 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/proc.MYI
114359 12 -rwxrwx--- 1 mysql mysql 8624 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_leap_second.frm
114407 12 -rwxrwx--- 1 mysql mysql 8630 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_relation.frm
114340 12 -rwxrwx--- 1 mysql mysql 8686 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_transition.frm
114350 412 -rwxrwx--- 1 mysql mysql 419156 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_topic.MYD
114365 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_transition_type.MYI
114400 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone.MYD
114321 4 -rwxrwx--- 1 mysql mysql 2048 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/user.MYI
114362 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/proc.MYD
114392 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/servers.MYD
114401 4 -rwxrwx--- 1 mysql mysql 880 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/db.MYD
114404 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_leap_second.MYD
114344 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_transition.MYI
114361 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/host.MYD
114399 12 -rwxrwx--- 1 mysql mysql 8606 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_name.frm
110523 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/func.MYD
114408 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/event.MYD
114330 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/columns_priv.MYD
114356 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/tables_priv.MYD
114406 4 -rwxrwx--- 1 mysql mysql 35 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/slow_log.CSM
114345 12 -rwxrwx--- 1 mysql mysql 8700 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_category.frm
114347 12 -rwxrwx--- 1 mysql mysql 8636 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone.frm
114352 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_leap_second.MYI
114343 12 -rwxrwx--- 1 mysql mysql 8910 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_relation.MYD
114368 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/ndb_binlog_index.MYD
114364 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/general_log.CSV
114397 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:42 /chroot/lamp/var/lib/mysql/mysql/plugin.MYD
114378 4 -rwxrwx--- 1 mysql mysql 2048 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/host.MYI
114349 4 -rwxrwx--- 1 mysql mysql 4096 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/tables_priv.MYI
114339 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/servers.MYI
114412 12 -rwxrwx--- 1 mysql mysql 8820 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/columns_priv.frm
114371 12 -rwxrwx--- 1 mysql mysql 8612 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/help_keyword.frm
114355 8 -rwxrwx--- 1 mysql mysql 5120 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/db.MYI
114391 12 -rwxrwx--- 1 mysql mysql 9582 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/db.frm
114396 12 -rwxrwx--- 1 mysql mysql 8586 Mar 25 10:42 /chroot/lamp/var/lib/mysql/mysql/plugin.frm
114370 4 -rwxrwx--- 1 mysql mysql 2048 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/event.MYI
114376 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/ndb_binlog_index.MYI
114395 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_transition_type.MYD
114405 0 -rwxrwx--- 1 mysql mysql 0 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/procs_priv.MYD
114398 4 -rwxrwx--- 1 mysql mysql 1024 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_name.MYI
114369 12 -rwxrwx--- 1 mysql mysql 9996 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/proc.frm
114366 12 -rwxrwx--- 1 mysql mysql 8976 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/slow_log.frm
114341 4 -rwxrwx--- 1 mysql mysql 4096 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/procs_priv.MYI
114377 12 -rwxrwx--- 1 mysql mysql 8748 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/time_zone_transition_type.frm
114353 12 -rwxrwx--- 1 mysql mysql 8838 Mar 25 10:24 /chroot/lamp/var/lib/mysql/mysql/servers.frm
114415 4 -rw-r----- 1 mysql mysql 1024 Mar 25 10:42 /chroot/lamp/var/lib/mysql/plugin.MYI
100763 4 drwxrwx--- 2 mysql mysql 4096 Mar 25 10:15 /chroot/lamp/var/lib/mysql/test
114334 10240 -rwxrwx--- 1 mysql mysql 10485760 Mar 25 10:24 /chroot/lamp/var/lib/mysql/ibdata1
114414 0 -rw-r----- 1 mysql mysql 0 Mar 25 10:42 /chroot/lamp/var/lib/mysql/plugin.MYD
114335 5120 -rwxrwx--- 1 mysql mysql 5242880 Mar 25 10:24 /chroot/lamp/var/lib/mysql/ib_logfile0
114413 12 -rw-r----- 1 mysql mysql 8586 Mar 25 10:42 /chroot/lamp/var/lib/mysql/plugin.frm
114336 5120 -rwxrwx--- 1 mysql mysql 5242880 Mar 25 10:24 /chroot/lamp/var/lib/mysql/ib_logfile1
Аз както и вие виждате въпросния файл plugin.frm със съответните права:
114396 12 -rwxrwx--- 1 mysql mysql 8586 Mar 25 10:42 /chroot/lamp/var/lib/mysql/mysql/plugin.frm
като прикрепен файл съм и прикачил и изхода от
strace chroot /chroot/lamp/ /etc/init.d/mysqld start 2> /strace.mysql.log
Помагайте Моля ...