jailing MySQL error

[Miroslav Lachman]

dsc fbsd.other wrote:

[...]

> My steps:
>
> 1.     Ezjail-admin onestart j009_mysql2
>
> 2.     Ezjail-admin console j009_mysql2
>
> 3.     Cd /usr/ports/database/mysql55-server&&  make install clean
>
> 4.     cp /usr/local/share/mysql/my-innodb-heavy-4G.cnf
> /usr/local/etc/my.cnf (modified socket file path to
> /var/db/mysql/mysql.sock, in both client and server lines)
>
> 5.     chown -R mysql:mysql ... for ... /tmp /var/tmp /var/db/mysql
>
> 6.     mysql_enable="YES" in jail rc.conf
>
> 7.     /usr/local/etc/rc.d/mysql-server start
>
> 8.     ...and NOTHING ... mysql-server scripts starts
> /usr/local/bin/mysql_install_db (creates mysql and test folders in
> /var/db/mysql ... but nothing else ... it's just running)

I am running mysql in a couple of jails without any additional tweaks.

I don't know why you are using chown on /tmp /var/tmp and /var/db/mysql. 
Did you created /var/db/mysql manualy?

Can you just try clean install without any tweaks without modifying 
my.cnf and just start it by:

mysql_enable="YES" in jail rc.conf

and

/usr/local/etc/rc.d/mysql-server start

MySQL daemon should run in jail with standard configuration.

Miroslav Lachman