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

Reply via email to