Linux Admin Zone

./start is not working

./start
………………………………………………….. sandbox server not started yet

Hi, I’ve created replication server (make_replication_sandbox command). I have a question for you. How can I connect to master/slave server using remote application (for example SQLyoq)? Thanks.

Hi, Yes, I’ve installed 1 master and 2 slave servers.
my.sandbox.cnf for master look like this:
[client]
user = msandbox
password = msandbox
port = 24758
socket = /tmp/mysql_sandbox24758.sock

[mysqld]
user = root
port = 24758
socket = /tmp/mysql_sandbox24758.sock
————————
for slave1 I have:

[mysql]
prompt=’slave1 [\h] {\u} (\d) > ‘
#

[client]
user = msandbox
password = msandbox
port = 24759
socket = /tmp/mysql_sandbox24759.sock

[mysqld]
user = root
port = 24759
socket = /tmp/mysql_sandbox24759.sock

———————–

ports are open

So, I’m trying to connect to master server from the command line:

[root@localhost rsandbox_5_1_43]# mysql -h localhost -u msandbox -P 24758 -p
Enter password: (here ‘msandbox’)
ERROR 1045 (28000): Access denied for user ‘msandbox’@'localhost’ (using password: YES)

But this works fine:
[root@localhost /]# cd /root/sandboxes/rsandbox_5_1_43
[root@localhost rsandbox_5_1_43]# ./m
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.43-log MySQL Community Server (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

master [localhost] {msandbox} ((none)) >
—————-

So, I don’t now how can I connect to master using host, pass, user and port…

BTW, I can connect to my 1st mysql server (5.0.77) using ‘mysql -h localhost -u root -p’ command

Thanks for help!

next problem…
I’ve installed phpmyadmin (http://blog.linuxing.org/2009/11/how-to-use-phpmyadmin-for-multiple-mysql-servers-running-on-same-server-machine/). My config.inc.php looks like this:
$cfg['blowfish_secret'] = ‘test’; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;
/* Server parameters */
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = ‘mysql’;

/*
* Servers 2 configuration, running on port 24758
*/

$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;
/* Server parameters */
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['port'] = ‘24758′;
$cfg['Servers'][$i]['socket'] = ‘/tmp/mysql_sandbox24758.sock’;
$cfg['Servers'][$i]['connect_type'] = ’socket’;
$cfg['Servers'][$i]['compress'] = false;

/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = ‘pma’;
// $cfg['Servers'][$i]['controlpass'] = ‘pmapass’;
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’;
// $cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;
// $cfg['Servers'][$i]['relation'] = ‘pma_relation’;
// $cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;
// $cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;
// $cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;
// $cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;
// $cfg['Servers'][$i]['history'] = ‘pma_history’;
// $cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = ”;
$cfg['SaveDir'] = ”;
—————————-
I’m able to connect to 1st server via phpmyadmin, but if I trying to connect to localhost:24758 (user: msandbox, pass: msandbox) I have ‘#2002 – The server is not responding (or local MySQL server’s socket is not correctly configured).’ error.

I’m connecting as ‘msandbox’ using ./m (look at last line)
—————–
[root@localhost rsandbox_5_1_43]# ./m
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.43-log MySQL Community Server (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

master [localhost] {msandbox} ((none)) >
—————-
I’ve checked this also using SHOW PROCESSLIST
I’ve checked ‘user’ table in mysql db. There is user msandbox for localhost

./m:
#!/bin/sh
/root/sandboxes/rsandbox_5_1_43/master/use “$@”

./use:
export LD_LIBRARY_PATH=/root/5.1.43/lib:/root/5.1.43/lib/mysql:$LD_LIBRARY_PATH
export DYLD_LIBRARY_PATH=/root/5.1.43/lib:/root/5.1.43/lib/mysql:$DYLD_LIBRARY_PATH
SBDIR=”/root/sandboxes/rsandbox_5_1_43/master”
BASEDIR=/root/5.1.43
MYSQL=”$BASEDIR/bin/mysql”
export MYSQL_HISTFILE=”$SBDIR/.mysql_history”
PIDFILE=”$SBDIR/data/mysql_sandbox3307.pid”
if [ -f $PIDFILE ]
then
$MYSQL –defaults-file=$SBDIR/my.sandbox.cnf $MYCLIENT_OPTIONS “$@”
#else
# echo “PID file $PIDFILE not found ”
fi

———————–
I’m not able to give you URL to my phpmyadmin, because my pc with centos is behind NAT. I’ve tried use port forwarding, but it dosn’t work (i don’t know why…)

And here is msandbox.log:
root/5.1.43/bin/mysqld, Version: 5.1.43-log (MySQL Community Server (GPL)). started with:
Tcp port: 3307 Unix socket: /tmp/mysql_sandbox3307.sock
Time Id Command Argument
100204 12:21:28 1 Connect msandbox@localhost on
1 Query select @@version_comment limit 1
1 Query select USER()
100204 12:29:02 1 Quit
——————-

These entries has been genereted ONLY when I’m connecting via ./m script.
When I’m using:
mysql -u msandbox -P 3307 -h localhost -p
server dosen’t write any data into this logfile…
:/

still the same:

[root@localhost rsandbox_5_1_43]# mysql -u msandbox -P 3307 -h localhost -p –defaults-file=/root/sandboxes/rsandbox_5_1_43/master/my.sandbox.cnf
Enter password:
ERROR 1045 (28000): Access denied for user ‘msandbox’@'localhost’ (using password: YES)

I haven’t ideas…

–defaults-file=file_name

Use only the given option file. file_name is the full path name to the file. If the file does not exist or is otherwise inaccessible, the program will exit with an error.

I’ve checked this option with not correct path or file name and I haven’t received an error.

I haven’t received an arro because of lines before defaults-file option…
Now I have error “mysql: unknown variable ‘defaults-file=/root/sandboxes/rsandbox_5_1_43/master/my.sandbox.cnf’”
but this can by fixed by setting the –default-file option at the beginning of the mysql command. And now…:
[root@localhost rsandbox_5_1_43]# mysql –defaults-file=/root/sandboxes/rsandbox_5_1_43/master/my.sandbox.cnf -u msandbox -P 3307 -h localhost -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.43-log MySQL Community Server (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

master [localhost] {msandbox} ((none)) >

—–

But I have still problem with connect to master server using standard command:

[root@localhost rsandbox_5_1_43]# mysql -u msandbox -P 3307 -p
Enter password:
ERROR 1045 (28000): Access denied for user ‘msandbox’@'localhost’ (using password: YES)
——————-

BTW, Jagbir, thanks for help and tips! You are great!

Tomorrow I’ll uninstall mysql server and sandbox and I’ll try install only sandbox (replication) on my OS. I’ll write to you about result.

Hi again!
I have installed only sandbox already, but mysqld doesn’t exist…
So I’ve got maybe simply question for you. Do I have to install mysql-server before sandbox installation?