안녕하세요
최근에 업무상 mysql 이전 작업을 하고 있는데, 이전에 RHEL4에서 운영되던 data 입니다.
사용되던 mysql version은 5.1.34이고, 이 data를 가지고 ubuntu로 넘어와서 apt-get으로 설치를 했더니
최신 version인 5.1.37로 깔리게 됬네요.
mysql의 기존 암호와 동일하게 setting하고, service mysql stop으로 daemon 내리고 나서
/var/lib/mysql에 기존 RHEL4에서 사용하던 data 쪽으로 Soft link를 건 상태입니다.
service mysql start를 하니 아래와 같은 system log가 나오네요…
가능하시다면 도움 좀 부탁드립니다.
May 1 13:49:04 XXXX kernel: [102599.547329] type=1503 audit(1272689344.918:259): operation="open" pid=22400 parent=22399 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:04 XXXX kernel: [102599.581896] type=1503 audit(1272689344.954:260): operation="open" pid=22415 parent=22414 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:05 XXXX mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
May 1 13:49:05 XXXX kernel: [102599.733955] type=1503 audit(1272689345.106:261): operation="open" pid=22529 parent=22421 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:05 XXXX mysqld: 100501 13:49:05 [Warning] Can’t create test file /var/lib/mysql/XXXX.lower-test
May 1 13:49:05 XXXX mysqld: 100501 13:49:05 [Warning] Can’t create test file /var/lib/mysql/XXXX.lower-test
May 1 13:49:05 XXXX kernel: [102599.739499] type=1503 audit(1272689345.110:262): operation="mknod" pid=22529 parent=22421 profile="/usr/sbin/mysqld" requested_mask="w::" denied_mask="w::" fsuid=0 ouid=0 name="/APP/WEB/mysql-5.1.34-linux-i686-glibc23/data/XXXX.lower-test"
May 1 13:49:05 XXXX kernel: [102599.739593] type=1503 audit(1272689345.110:263): operation="mknod" pid=22529 parent=22421 profile="/usr/sbin/mysqld" requested_mask="w::" denied_mask="w::" fsuid=0 ouid=0 name="/APP/WEB/mysql-5.1.34-linux-i686-glibc23/data/XXXX.lower-test"
May 1 13:49:05 XXXX mysqld: 100501 13:49:05 [Note] Plugin ‘FEDERATED’ is disabled.
May 1 13:49:05 XXXX mysqld: #007/usr/sbin/mysqld: Can’t find file: ‘./mysql/plugin.frm’ (errno: 13)
May 1 13:49:05 XXXX mysqld: 100501 13:49:05 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
May 1 13:49:05 XXXX mysqld: 100501 13:49:05 InnoDB: Operating system error number 13 in a file operation.
May 1 13:49:05 XXXX mysqld: InnoDB: The error means mysqld does not have the access rights to
May 1 13:49:05 XXXX mysqld: InnoDB: the directory.
May 1 13:49:05 XXXX mysqld: InnoDB: File name ./ibdata1
May 1 13:49:05 XXXX mysqld: InnoDB: File operation call: ‘create’.
May 1 13:49:05 XXXX mysqld: InnoDB: Cannot continue operation.
May 1 13:49:05 XXXX mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
May 1 13:49:05 XXXX kernel: [102600.608911] type=1503 audit(1272689345.981:264): operation="open" pid=22541 parent=22540 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:07 XXXX kernel: [102601.633772] type=1503 audit(1272689347.005:265): operation="open" pid=22551 parent=22550 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:08 XXXX kernel: [102602.658697] type=1503 audit(1272689348.030:266): operation="open" pid=22561 parent=22560 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:09 XXXX kernel: [102603.683534] type=1503 audit(1272689349.054:267): operation="open" pid=22571 parent=22570 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:10 XXXX kernel: [102604.708257] type=1503 audit(1272689350.081:268): operation="open" pid=22581 parent=22580 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:11 XXXX kernel: [102605.733540] type=1503 audit(1272689351.105:269): operation="open" pid=22591 parent=22590 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:12 XXXX kernel: [102606.758402] type=1503 audit(1272689352.129:270): operation="open" pid=22601 parent=22600 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:13 XXXX kernel: [102607.783150] type=1503 audit(1272689353.153:271): operation="open" pid=22611 parent=22610 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:14 XXXX kernel: [102608.807926] type=1503 audit(1272689354.177:272): operation="open" pid=22621 parent=22620 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:15 XXXX kernel: [102609.832673] type=1503 audit(1272689355.205:273): operation="open" pid=22631 parent=22630 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:16 XXXX kernel: [102610.857512] type=1503 audit(1272689356.229:274): operation="open" pid=22641 parent=22640 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:17 XXXX kernel: [102611.882327] type=1503 audit(1272689357.253:275): operation="open" pid=22651 parent=22650 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:18 XXXX kernel: [102612.907074] type=1503 audit(1272689358.277:276): operation="open" pid=22661 parent=22660 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:19 XXXX kernel: [102613.931858] type=1503 audit(1272689359.301:277): operation="open" pid=22671 parent=22670 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:19 XXXX kernel: [102613.954073] type=1503 audit(1272689359.325:278): operation="open" pid=22680 parent=22679 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
May 1 13:49:19 XXXX /etc/init.d/mysql[22687]: 0 processes alive and ‘/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping’ resulted in
May 1 13:49:19 XXXX /etc/init.d/mysql[22687]: #007/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
May 1 13:49:19 XXXX /etc/init.d/mysql[22687]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
May 1 13:49:19 XXXX /etc/init.d/mysql[22687]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!
May 1 13:49:19 XXXX /etc/init.d/mysql[22687]: