Percona MySQL 5.5 fails to start
- by keymone
trying to setup new server here but keep getting this in error log:
mysqld_safe Starting mysqld daemon with databases from /data/mysql/myisam
[Warning] Can't create test file /data/mysql/myisam/hostname.lower-test
[Warning] Can't create test file /data/mysql/myisam/hostname.lower-test
[Note] Flashcache bypass: disabled
[Note] Flashcache setup error is : setmntent failed
/usr/sbin/mysqld: File '/var/mysql/bin/bin-log.index' not found (Errcode: 13)
[ERROR] Aborting
[Note] /usr/sbin/mysqld: Shutdown complete
mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
everything under /data/mysql (it's ibdata and myisam folders) is owned my mysql:mysql and has proper permissions
same goes for folders with bin and relay logs under /var/mysql
apparmor is purged from server
any ideas?
PS
it seems like something else apart from apparmor is affecting permissions to access mysql files
after i changed data directory to more default one - /var/lib/mysql and "Can't create test file" error is gone, but "'/var/mysql/bin/bin-log.index' not found (Errcode: 13)" is still there
PPS
so i installed apparmor back and added all folders to mysqld's profile and errors mentioned above are now gone(or mysql doesn't even get to that point now)
what i have now is this: /usr/sbin/mysqld: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
banging my head against the wall.