installation fails with mysql version 5.0.36

[Joe]

I run the following command as a normal user:
make_sandbox 5.0.36

Results:
Executing low_level_make_sandbox --basedir=/opt/mysql/5.0.36 \
        --sandbox_directory=msb_5_0_36 \
        --install_version=5.0 \
        --sandbox_port=5036 \
        --no_ver_after_name \
        --my_clause=log-error=msandbox.err
    The MySQL Sandbox, version 3.0.04
    (C) 2006,2007,2008,2009 Giuseppe Maxia
installing with the following parameters:
upper_directory = $SANDBOX_HOME
sandbox_directory = msb_5_0_36
sandbox_port = 5036
check_port = 0
no_check_port = 0
datadir_from = script
install_version = 5.0
basedir = /opt/mysql/5.0.36
my_file =
operating_system_user = $NORMAL_USER
db_user = msandbox
db_password = msandbox
my_clause = log-error=msandbox.err
prompt_prefix = mysql
prompt_body = [\h] {\u} (\d) > '
force = 0
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
no_show = 0
do you agree? ([Y],n) Y
loading grants
................... sandbox server not started yet
Your sandbox server was installed in $SANDBOX_HOME/msb_5_0_36

I then run:
SBDEBUG=1 ./start

Results:
................... sandbox server not started yet

Output in start.log:
Starting mysqld daemon with databases from $SANDBOX_HOME/msb_5_0_36/data
/opt/mysql/5.0.36/bin/mysqld_safe: line 380: msandbox.err: Permission denied
/opt/mysql/5.0.36/bin/mysqld_safe: line 388: msandbox.err: Permission denied
STOPPING server from pid file $SANDBOX_HOME/msb_5_0_36/data/mysql_sandbox5036.pid
tee: msandbox.err: Permission denied
090626 07:23:35 mysqld ended
tee: msandbox.err: Permission denied

This looks like it might be because of the default value for my_clause. I can edit the my.sandbox.cnf file and change the log-error to
$SANDBOX_HOME/msb_5_0_36/data/msandbox.err. I then run load_grants and I can start up the server.

Of course $SANDBOX_HOME is the actuall path to the sandbox dir.

I also get the same result with running:
make_sandbox 5.0.67

OS: CentOS 5.2

[Giuseppe Maxia (giuseppe-maxia)]

This also seems a permission problem, like the previous one you have reported.
Please remove this sandbox, create it again, and, after the failure you are reporting, show the output of the following commands:
ls -l -d $SANDBOX_HOME
ls -l -d $SANDBOX_HOME/msb_5_0_36/*/
ls -l $SANDBOX_HOME/msb_5_0_36/data
umask

[Joe (joegrasse)]

I thought that it was because it was trying to create the at /msandbox.err because of the way 5.0.36 startup script handles log-error.

Here is the output that you requested

make_sandbox 5.0.36
Executing low_level_make_sandbox --basedir=/opt/mysql/5.0.36 \
        --sandbox_directory=msb_5_0_36 \
        --install_version=5.0 \
        --sandbox_port=5036 \
        --no_ver_after_name \
        --my_clause=log-error=msandbox.err
    The MySQL Sandbox, version 3.0.04
    (C) 2006,2007,2008,2009 Giuseppe Maxia
installing with the following parameters:
upper_directory = $SANDBOX_HOME
sandbox_directory = msb_5_0_36
sandbox_port = 5036
check_port = 0
no_check_port = 0
datadir_from = script
install_version = 5.0
basedir = /opt/mysql/5.0.36
my_file =
operating_system_user = joe
db_user = msandbox
db_password = msandbox
my_clause = log-error=msandbox.err
prompt_prefix = mysql
prompt_body = [\h] {\u} (\d) > '
force = 0
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
no_show = 0
do you agree? ([Y],n) Y
loading grants
................... sandbox server not started yet
Your sandbox server was installed in $SANDBOX_HOME/msb_5_0_36

ls -l -d $SANDBOX_HOME
drwxrwxrwx 5 joe group 4096 Jun 26 08:42 $SANDBOX_HOME

ls -l -d $SANDBOX_HOME/msb_5_0_36/*/
drwx------ 4 joe group 4096 Jun 26 08:42 $SANDBOX_HOME/msb_5_0_36/data/

ls -l $SANDBOX_HOME/msb_5_0_36/data
total 16
drwx------ 2 joe group 4096 Jun 26 08:42 mysql
drwx------ 2 joe group 4096 Jun 26 08:42 test

After the initial start I did also try to start it with the following permissions:
ls -l -d $SANDBOX_HOME/msb_5_0_36/*/
drwxrwxrwx 4 joe group 4096 Jun 26 08:42 $SANDBOX_HOME/msb_5_0_36/data/

I still got the same result.