Mysql under jailkit - Invalid cross-device link when linking mysqld.sock

[SupuS]

Hi,

I need enable mysql command for chrooted shell accounts on Ubuntu 10.04 server.

I put /usr/bin/mysql to jailkit chrooted applications section under server configuration. mysql command were sucessfully added to chroot but without creating mysql socket. Here is part of /var/log/ispconfig/cron.log:

ln: creating hard link `/var/www/clients/client1/web2/var/run/mysqld/mysqld.sock' => `/var/run/mysqld/mysqld.sock': Invalid cross-device link

As described on this thread the reason should be bad harddisk layout. On server are root, tmp and boot partitions but ubuntu adds tmpfs partition for /var/run.

Here is output of mount:

rootfs on / type rootfs (rw)
none on /sys type sysfs (rw,nosuid,nodev,noexec,relatime)
none on /proc type proc (rw,nosuid,nodev,noexec,relatime)
none on /dev type devtmpfs (rw,relatime,size=4091184k,nr_inodes=1022796,mode=755)
none on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000)
/dev/disk/by-uuid/501c4db5-c8fe-4462-9aa3-e3fd3a19926a on / type ext4 (rw,relatime,errors=remount-ro,barrier=1,data=ordered,jqfmt=vfsv0,usrjquota=aquota.user,grpjquota=aquota.group)
none on /sys/fs/fuse/connections type fusectl (rw,relatime)
none on /sys/kernel/debug type debugfs (rw,relatime)
none on /sys/kernel/security type securityfs (rw,relatime)
none on /dev/shm type tmpfs (rw,nosuid,nodev,relatime)
none on /var/run type tmpfs (rw,nosuid,relatime,mode=755)
none on /var/lock type tmpfs (rw,nosuid,nodev,noexec,relatime)
none on /lib/init/rw type tmpfs (rw,nosuid,relatime,mode=755)
/dev/md3 on /tmp type ext4 (rw,nosuid,noexec,relatime,barrier=1,data=ordered,jqfmt=vfsv0,usrjquota=aquota.user,grpjquota=aquota.group)

Is some solution for creating mysql socket in chrooted environment in ubuntu 10.04?

Any help will appreciated.

SupuS

[till]

Creating a hrd link is not possible from one partition to another. But maybe you can use the mount command to mount /var/run into the jail.

[SupuS]

Originally Posted by till

Creating a hrd link is not possible from one partition to another. But maybe you can use the mount command to mount /var/run into the jail.

Thank you till. It works. I mounted socket by:

mount --bind /var/run/mysqld /var/www/clients/clientX/webX/var/run/mysqld/

this situation should be covered directly by ISPConfig because after reboot setting will lost.

SupuS

[till]

ISPConfig has no daemon or start script which get started at boot time where you could add that. So it might be the best way if you create your own script for that.