MySQL Sandbox

my_print_default giving error on line 1

Asked by junaid

Hi Sir,
Before this line was giving error of the 'data' directory, i was created 'data' directory manually and then later it start giving the '/home/user/5.1.26/bin/my_print_defaults: 1: Syntax error: "(" unexpected'. Can you look the following trace.
./make_sandbox /home/user/mysql-5.1.26-rc-percona.tar.gz --force

/mysql_sandbox_2.0.12$ ./make_sandbox /home/user/mysql-5.1.26-rc-percona.tar.gz --force
unpacking /home/user/mysql-5.1.26-rc-percona.tar.gz
Executing ./low_level_make_sandbox --basedir=/home/user/5.1.26 \
        --sandbox_directory=msb_5_1_26 \
        --install_version=5.1 \
        --sandbox_port=5126 \
        --no_ver_after_name \
        --force \
        --my_clause=log-error=msandbox.err
    The MySQL Sandbox, version 2.0.12 16-Oct-2008
    (C) 2006,2007,2008 Giuseppe Maxia, Sun Microsystems, Database Group
installing with the following parameters:
upper_directory = /home/user/sandboxes
sandbox_directory = msb_5_1_26
sandbox_port = 5126
datadir_from = script
install_version = 5.1
basedir = /home/user/5.1.26
my_file =
operating_system_user = user
db_user = msandbox
db_password = msandbox
my_clause = log-error=msandbox.err
prompt_prefix = mysql
prompt_body = [\h] {\u} (\d) > '
force = 1
no_ver_after_name = 1
verbose = 0
load_grants = 1
no_load_grants = 0
do you agree? ([Y],n) y
/home/user/5.1.26/bin/my_print_defaults: 1: Syntax error: "(" unexpected
error while creating grant tables
Neither host 'ubuntu810server' nor 'localhost' could be looked up with
/home/user/5.1.26/bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option

Thanks
Junaid.

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Sandbox Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Giuseppe Maxia (giuseppe-maxia) said : 		#1

I can't reproduce the error you are complaining about in either Ubuntu or RedHat ES, both times using the official MySQL binary for 5.1.26. (see an example run below)
If you are using a custom compiled tarball, it is possible that it may be missing some components.
Please try with an officially produced tarball, and see if it works correctly.
Another possibility is that you are using a binary that is not the right one for the platform you are using. Check that the binaries have been compiled for the architecture used in your operating system (a common error is using a 64 bit binary on a 32 bit operating system and the other way around).

Cheers

Giuseppe

=== SAMPLE RUN ===
~/install/mysql_sandbox_2.0.12/make_sandbox /home/gmax/downloads/mysql-5.1.26-rc-linux-i686-glibc23.tar.gz
unpacking /home/gmax/downloads/mysql-5.1.26-rc-linux-i686-glibc23.tar.gz
Executing ./low_level_make_sandbox --basedir=/home/gmax/downloads/5.1.26 \
 --sandbox_directory=msb_5_1_26 \
 --install_version=5.1 \
 --sandbox_port=5126 \
 --no_ver_after_name \
 --my_clause=log-error=msandbox.err
    The MySQL Sandbox, version 2.0.12 16-Oct-2008
    (C) 2006,2007,2008 Giuseppe Maxia, Sun Microsystems, Database Group
installing with the following parameters:
upper_directory = /home/gmax/sandboxes
sandbox_directory = msb_5_1_26
sandbox_port = 5126
datadir_from = script
install_version = 5.1
basedir = /home/gmax/downloads/5.1.26
my_file =
operating_system_user = gmax
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
do you agree? ([Y],n)
loading grants
... sandbox server started
installation options saved to current_options.conf.
To repeat this installation with the same options,
use /home/gmax/install/mysql_sandbox_2.0.12/low_level_make_sandbox --conf_file=current_options.conf
----------------------------------------
Your sandbox server was installed in /home/gmax/sandboxes/msb_5_1_26

Revision history for this message
junaid (muhammadjunaidmalik) said : 		#2

Thanks very much sir.

Mysql 5.1.30 download from mysql.com solved my problem as you said.Before i was trying to install mysql version from http://www.percona.com/docs/wiki/release:start but these version seems to be only for 64bit machines, i'm using 32bit vmware image of ubuntu server & centos 5.2.

Sir, is there any way to get binary details like for which version it is built for 32/64bit?

Thanks & Regards
Junaid.

Revision history for this message
Giuseppe Maxia (giuseppe-maxia) said : 		#3

Builds provided by Percona are beyond my reach. Please ask your question to Percona directly.

Can you help with this problem?

Provide an answer of your own, or ask junaid for more information if necessary.

To post a message you must log in.