0.8.2 won't connect to MySQL
OSX Server 10.6.8, mysql-proxy 0.8.2 binary
I'm getting these errors logged:
network-socket.c:401: bind(/var/mysql/mysql.sock) failed: Address already in use (48)
chassis-mainloop.c:267: applying config of plugin proxy failed
mysql-proxy-cli.c:595: Failure from chassis_mainloop. Shutting down.
from this config:
[mysql-proxy]
daemon = true
plugins = proxy
proxy-skip-profiling = true
proxy-address = /var/mysql/mysql.sock
proxy-backend-addresses = x.x.x.x:3306
log-file = /devlogs/mysql-proxy/myproxy.log
or even a simple config like this
[mysql-proxy]
proxy-backend-addresses = 209.80.41.210:3306
log-file = /devlogs/mysql-proxy/myproxy.log
I've setup mysql-proxy a couple times before (earlier versions), and I don't recall a big hoopla. It just worked. Now I'm pulling my hair out.
For now, I'm just trying to get a single box to have an application's mysql connection go through proxy. The app is configured to use 127.0.0.1:4040 for its connection.
I've tinkered with a number of combinations of config setting. With and without daemon, plugins, proxy-address, and others.
I've used proxy-address with the socket, an IP address, and 127.0.0.1. No difference.
If I launch mysql-proxy from command line with no options it seems to work (my app connects to the DB), but as as soon as I define a proxy-backend-addresses I get no connection -- despite config setups identical to my other running installations.
Whether I do any of this by command-line options or cnf file, I get the same non-working results.
Even a simple "mysql-proxy --proxy-backend-addresses = x.x.x.x:3306" on the command line isn't working.
Something about 0.8.2 is different, and I can't figure it out.
Any ideas? Many thanks in advance.
-- gw
Subject
Views
Written By
Posted
0.8.2 won't connect to MySQL
4782
July 29, 2012 07:56PM
2293
July 30, 2012 10:27PM
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.