On 2/20/09, i(Yayan <ya...@broadband.net.id> wrote: > yup betul, > kemungkinan ada setup yang kurang, misal owners dari datadir mysql yg baru > tersebut > > coba periksa/bandingkan: > #ls -al /var/lib/mysl > #ls -al /home/mysql > > periksa juga owners dari directory mysql > #ls -al /home/mysq* >
kalo dari hak akses dan owner kayaknya dah sama persih tuh: r...@ubuntu804:/var/log# ls -al /var/lib/mysql total 20536 drwxr-xr-x 3 mysql mysql 4096 2009-02-20 08:19 . drwxr-xr-x 27 root root 4096 2009-02-20 03:50 .. -rw-r--r-- 1 mysql mysql 0 2009-02-20 01:24 debian-5.0.flag -rw-rw---- 1 mysql mysql 10485760 2009-02-20 08:16 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2009-02-20 08:19 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2009-02-19 23:15 ib_logfile1 drwxr-xr-x 2 mysql mysql 4096 2009-02-20 01:24 mysql -rw------- 1 mysql mysql 7 2009-02-19 23:15 mysql_upgrade_info r...@ubuntu804:/var/log# ls -al /home/data_sql total 20536 drwxr-xr-x 3 mysql mysql 4096 2009-02-20 04:04 . drwxr-xr-x 29 root root 4096 2009-02-20 04:03 .. -rw-r--r-- 1 mysql mysql 0 2009-02-20 01:24 debian-5.0.flag -rw-rw---- 1 mysql mysql 10485760 2009-02-20 03:51 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2009-02-20 03:56 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2009-02-19 23:15 ib_logfile1 drwxr-xr-x 2 mysql mysql 4096 2009-02-20 01:24 mysql -rw------- 1 mysql mysql 7 2009-02-19 23:15 mysql_upgrade_info Tapi kalo di /var/log/messages sih ada pesan ini: Feb 20 08:16:29 ubuntu804 kernel: [15700.488810] audit(1235135789.378:44): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/home/data_sql/ubuntu804.lower-test" pid=19610 profile="/usr/sbin/mysqld" namespace="default" Feb 20 08:16:29 ubuntu804 kernel: [15700.489209] audit(1235135789.378:45): type=1503 operation="inode_create" requested_mask="w::" denied_mask="w::" name="/home/data_sql/ubuntu804.lower-test" pid=19610 profile="/usr/sbin/mysqld" namespace="default" Feb 20 08:16:29 ubuntu804 kernel: [15700.505814] audit(1235135789.398:46): type=1503 operation="inode_permission" requested_mask="rw::" denied_mask="rw::" name="/home/data_sql/ibdata1" pid=19610 profile="/usr/sbin/mysqld" namespace="default" -- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke tanya-jawab-unsubscr...@linux.or.id Arsip dan info milis selengkapnya di http://linux.or.id/milis