MySQL Forums
Forum List  »  Router & Proxy

mysql-proxy can't release connects(fixed)
Posted by: vox huang
Date: September 12, 2007 04:06AM

I run mysql-proxy like that,
LUA_PATH="/usr/local/tools/mysql-proxy/trunk/lib/?.lua" mysql-proxy --proxy-backend-addresses=192.168.0.9:3306 --proxy-read-only-backend-addresses=192.168.0.13:3306 --proxy-lua-script=/usr/local/tools/mysql-proxy/trunk/lib/rw-splitting.lua --daemon

and I use this command to test,
mysql -h192.168.0.9 -P4040 --database=test -e 'select * from test'

after I test 5 times successfully,mysql warn that "ERROR 1130 (00000): Host '192.168.0.9' is not allowed to connect to this MySQL server'

then I use "show processlist" to list the connects,there are 4 connects from mysql-proxy.



Edited 1 time(s). Last edit at 09/12/2007 08:47PM by vox huang.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql-proxy can't release connects(fixed)
3343
September 12, 2007 04:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.