Can't start mysql in jail

[Miroslav Lachman]

Sam Wun wrote:
> Hi,
> 
> This seems a common question, but it is a bit different.
> Production OS: FreeBSD 6.2
> Source OS: FreeBSD 7.2
> 
> I created a jailed mysql 5.1 in my source OS FreeBSD 7.2, and then tar
> it up and scp into a production OS FreeBSD 6.2.
> After setup a jail in 6.2 for the jailed mysql, I tried to start up
> mysql server, but it failed with very lilttle error message.
> The error log just said,
> "
> 090525 20:18:26 mysqld_safe Starting mysqld daemon with databases from
> /usr/local/var/db/mysql
> 090525 20:18:26 mysqld_safe mysqld from pid file
> /usr/local/var/db/mysql/wp1.xxx.au.pid ended
> ..
> "
> 
> What is the problem with Freebsd 6.2 running 7.2 jailed files?
> Is there anyone to fix this problem?

It is problem with versions of linked libraries"

on FreeBSD 7.2
~/> ldd /usr/local/libexec/mysqld
/usr/local/libexec/mysqld:
         librt.so.1 => /usr/lib/librt.so.1 (0x800ad0000)
         libz.so.4 => /lib/libz.so.4 (0x800bd5000)
         libwrap.so.5 => /usr/lib/libwrap.so.5 (0x800ce9000)
         libcrypt.so.4 => /lib/libcrypt.so.4 (0x800df2000)
         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x800f0b000)
         libm.so.5 => /lib/libm.so.5 (0x801117000)
         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x801231000)
         libthr.so.3 => /lib/libthr.so.3 (0x80133e000)
         libc.so.7 => /lib/libc.so.7 (0x801454000)


on FreeBSD 6.3
~/> ldd /usr/local/libexec/mysqld
/usr/local/libexec/mysqld:
         libz.so.3 => /lib/libz.so.3 (0x28478000)
         libwrap.so.4 => /usr/lib/libwrap.so.4 (0x28489000)
         libcrypt.so.3 => /lib/libcrypt.so.3 (0x28490000)
         libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x284a8000)
         libm.so.4 => /lib/libm.so.4 (0x28573000)
         libpthread.so.2 => /usr/lib/libthr.so.2 (0x28589000)
         libc.so.6 => /lib/libc.so.6 (0x2859b000)

As you can see, there is different libc.so version, different threading 
library, etc.

So you can't run MySQL daemon build on different major version OS.

Miroslav Lachman