September 9th, 2003, 21:46
I'm running into some complications here... I'm hoping somebody can help me out.. i've made a chroot area for mysqld and it will run if i run it as root but not as mysql,

here's some output

bash-2.05b# chroot /chroot/mysql/ /usr/local/libexec/mysqld --user=root
/usr/local/libexec/mysqld: ready for connections
bash-2.05b# chroot /chroot/mysql/ /usr/local/bin/safe_mysqld
Starting mysqld daemon with databases from /var/db/mysql
030910 04:49:45 mysqld ended

it dies right away...

here's what the error log says

030910 04:49:45 mysqld started
030910 4:49:45 Can't start server : Bind on unix socket: Permission denied
030910 4:49:45 Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
030910 4:49:45 Aborting

030910 4:49:45 /usr/local/libexec/mysqld: Shutdown Complete

030910 04:49:45 mysqld ended

there is nothing in the chroot /tmp and it has 1777 permissions.. all the permissions in the chroot are correct...

so i decided to try using chrootuid and here's what happens

nothing gets outputted to the screen but this shows up in messages

Sep 10 00:54:27 XXXXXX /usr/local/sbin/chrootuid[69381]: chrootuid: dir(/chroot/mysql) user(mysql) command(/usr/local/libexec/mysqld)
Sep 10 00:54:27 XXXXXX /usr/local/sbin/chrootuid[69381]: /usr/local/libexec/mysqld: Permission denied

permissions are correct..

September 9th, 2003, 23:41
dont be shy... i know your just fighting to help me on this one...

September 10th, 2003, 20:20
got it... was a group permission thing..

/me slaps himself w/ a stale trout