Installation fails with MySQL 4.1

[Stéphane Combaudon]

Hi,

Trying to install a MySQL 4.1 sandbox with MySQL Sandbox 3.0.28, I hit the following error:

stephane@wheezy:~$ make_sandbox mysql-standard-4.1.22-pc-linux-gnu-i686-glibc23.tar.gz
Use of uninitialized value $ENV{"SANDBOX_BINARY"} in concatenation (.) or string at /usr/local/bin/make_sandbox line 125.
unpacking /home/stephane/mysql-standard-4.1.22-pc-linux-gnu-i686-glibc23.tar.gz
Executing low_level_make_sandbox --basedir=/home/stephane/4.1.22 \
 --sandbox_directory=msb_4_1_22 \
 --install_version=4.1 \
 --sandbox_port=4122 \
 --no_ver_after_name
>>/tmp
    The MySQL Sandbox, version 3.0.28
    (C) 2006-2013 Giuseppe Maxia
installing with the following parameters:
[...]
do you agree? ([Y],n) Y
can't find a value for '_MORE_OPTIONS_'

If I comment out lines 714 to 717 in low_level_make_sandbox, the installation process runs fine.

Thanks for your help!
Stephane

[Giuseppe Maxia (giuseppe-maxia)]

Hi,
Thanks for reporting this bug.
I need some information to verify the bug:

1) Where can I get mysql-4.1 binaries?

2) Which version of Linux were you using?

3) from the output that you report, I think that there could be a problem in the installation of MySQL Sandbox itself.

Can you repeat the command as follows?

mkdir -p $HOME/opt/mysql
export SBDEBUG=3
make_sandbox mysql-standard-4.1.22-pc-linux-gnu-i686-glibc23.tar.gz

[Stéphane Combaudon (stephane-combaudon)]

Giuseppe,

1) I downloaded the 4.1 binaries from this page:
http://download.softagency.net/MySQL/Downloads/MySQL-4.1/

2) uname -a
Linux wheezy 3.2.0-4-686-pae #1 SMP Debian 3.2.35-2 i686 GNU/Linux

3) Here is the output of the make_sandbox command:
stephane@wheezy:~$ make_sandbox mysql-standard-4.1.22-pc-linux-gnu-i686-glibc23.tar.gz
unpacking /home/stephane/mysql-standard-4.1.22-pc-linux-gnu-i686-glibc23.tar.gz
Executing low_level_make_sandbox --basedir=/home/stephane/4.1.22 \
 --sandbox_directory=msb_4_1_22 \
 --install_version=4.1 \
 --sandbox_port=4122 \
 --no_ver_after_name
>>/tmp
    The MySQL Sandbox, version 3.0.28
    (C) 2006-2013 Giuseppe Maxia
installing with the following parameters:
[...]
do you agree? ([Y],n) Y
reading MANIFEST files
(0) clear.sh
(0) my.sandbox.cnf
(0) start.sh
(0) status.sh
(0) msb.sh
(0) restart.sh
(0) stop.sh
(0) send_kill.sh
(0) load_grants.sh
(0) use.sh
(0) proxy_start.sh
(0) my.sh
(0) change_paths.sh
(0) change_ports.sh
(0) USING
(0) grants.mysql
(1) sandbox_action.pl
creating /home/stephane/sandboxes/msb_4_1_22
copying sandbox_action.pl into /home/stephane/sandboxes
can't find a value for '_MORE_OPTIONS_'

[Giuseppe Maxia (giuseppe-maxia)]

Thanks for the update.
I was able to reproduce the error and find where the problems is.
I will commit a fix as soon as I run all the tests.
In the meantime, a quick workaround is by changing a single line in make_sandbox

=== modified file 'bin/make_sandbox'
--- bin/make_sandbox 2012-05-15 08:09:21 +0000
+++ bin/make_sandbox 2013-01-24 14:04:24 +0000
@@ -298,7 +298,7 @@
                 "--no_ver_after_name",
                 @ARGV
             );
- if ($major >=5) {
+ if ($major >=4) {
         push(@install_options, qq(--my_clause=log-error=msandbox.err));
     }
     unless (grep {$_ eq '--no_show'} @install_options) {

[Stéphane Combaudon (stephane-combaudon)]

Thanks!!

[Giuseppe Maxia (giuseppe-maxia)]

Fixed in release 3.0.29