RE: jailing MYSQL error [SOLVED]

Hello,

SOLVED ! But the problem was in another place.

Host world and kernel were build with src r215329 (patched with
head-v28-v2.patch from Martin Matuska), but ezjail buildworld was made using
more recent sources with no patch (in fact I was trying to apply the same
patch to more recent sources, but it doesn't work ... but that's another
issue).
Mysql seems to have problems in this case (kernel and world based on
different versions of src). But other stuff work just fine.

So, first I've made a jail (standard steps from the handbook) using the same
src r215329 (patched for zfs v28). Mysql works fine under this jail.

After this step, I've updated the ezjail basejail (ezjail-admin update -i).
Now, Mysql works just fine under ezjail too.

Thanks for your time and help.

Regards,
Lulu

-----Original Message-----
From: J. Hellenthal [mailto:jhellenthal_at_gmail.com] On Behalf Of J.
Hellenthal
Sent: Monday, January 03, 2011 12:24 AM
To: dsc fbsd.current
Cc: freebsd-current_at_freebsd.org
Subject: Re: jailing MYSQL error

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hello,

Just to be sure as the long detailed information that you laid before can
lead to confusion, lets take this one step at a time.

Assuming all your bases are covered and it sinks down to a permissions issue
try this:

chown root:wheel /path/to/jail/tmp /path/to/jail/var/tmp chmod 1777
/path/to/jail/tmp /path/to/jail/var/tmp rm -rf /path/to/jail/var/db/mysql

- -Login to the jail here-
make sure that rc.conf* only contains mysql_enable="YES"
service mysql-server start

ls -ld /var/db/mysql should convey mode 700 or drwx------ and uid/88
gid/88 mysql/mysql



At this point your mysql server should be running and fully working.

Another thing to make sure you eliminate just in case... would be any my.cnf
files in /etc or /usr/local/etc


Good luck

- -- 

Regards,

 jhell,v
 JJH48-ARIN
-----BEGIN PGP SIGNATURE-----

iQEcBAEBAgAGBQJNIPrkAAoJEJBXh4mJ2FR+fLEH/0N91782PKGna/DZNoRF4hWJ
8tTh9bPFaHGjRu2ITC08gFJBLaAK8hE5oh9Tg5k6eysyzjE1EEHXUAJaL6B8Rg+N
w5m66OGtvunX8JQqwu8d6ulDLk4EHex7Aaf0G2wfpW2OBDP4oCbeXxaakDJp+dzB
GGf4a4ezODgQsr8Hxva71bgesfQ6a1BEirf/pwGcaQs9y1lCgoRK6M+iKDKqruLM
Vyp4oNCHX52GTKa/cpx2VveZG/F21RabYtCVrBhU3Xq0EbDeDkiP2JjZt0xNPJVA
dnCfCtTRECeruqlFHekH7MayF7uZ5nZIjJ3SEA6xHTCyt3PVC7oxr1NCmaETWJQ=
=HFv4
-----END PGP SIGNATURE-----