Trouble on setting up mysql-proxy-0.7.2-linux-rhel5-x86-32bit

[Cesar Ryan Mindana]

can anyone help me on this?


[root@mysqlproxyserver ]# mysql -h 127.0.0.1 -P 1337 -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.99-agent-admin

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

mysql> select * from proxy_connections;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: *** NONE ***

ERROR 1105 (07000): need a resultset + proxy.PROXY_SEND_RESULT
mysql>

===================

i started the proxy with

#!/bin/bash
MASTERDB=192.168.15.128

ROOT_DIR=/root/mysql-proxy-0.7.2-linux-rhel5-x86-32bit
$ROOT_DIR/sbin/mysql-proxy \
--daemon \
--admin-address=:1337 \
--proxy-backend-addresses=$MASTERDB:3306


MySQL IP = 192.168.15.129
DB = 192.168.15.128

Thanks
Ryan



Edited 1 time(s). Last edit at 10/15/2009 02:51AM by Cesar Ryan Mindana.