dariofg wrote:
>
> Hello,
>
> I'm trying to run mysql in a chroot jail, but the server
> errors out. I've modified safe_mysqld so it would call
> MySQL with the following command:
>
> nice --5 nohup /usr/local/mysql/libexec/mysqld --
> basedir=/ --datadir=/var --user=mysql --pid-
> file=/var/hayek.pid --skip-locking --
> chroot=/usr/local/mysql --
> language=/usr/local/mysql/share/mysql/portuguese
> >> /usr/local/mysql/var/hayek.err 2>&1
>
> When I run safe_mysqld, the mysql daemon dies with the
> following error (log file):
>
> 010606 9:57:58 /usr/local/mysql/libexec/mysqld:
> Table 'mysql.host' doesn't exist
>
> How's that possible if the table's set up just fine? I
> tried copying the mysql datafile dir to the real /var
> directory and it still can't find the 'host' table.
>
> Has anyone got mysql running with the chroot option?
> There really should be a tutorial for this!
>
> Thanks in advance,
> Dario Gomes
>
Dario:
I've dealt with jails and question the wisdom of using them.
There are better ways to do this, and, your application will suffer tremendous
portability issues which will probably make it useless for most people.
If you're the only one using it, proceed.
If you hope to make money with it, good luck.
Quick answer: your environment is hosed.
There shouldn't be a tutorial on running mysql in a jail because it shouldn't be
done. Protect the whole box, not just one application.
Regards,
Van
--
=========================================================================
Linux rocks!!! http://www.dedserius.com
=========================================================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
