Mysql proxy startproblem

Asked by speckie

I have a problem with started mysql proxy

2011-06-06 11:11:52: (message) mysql-proxy 0.8.0 started
2011-06-06 11:11:52: (critical) chassis-limits.c:81: could not raise RLIMIT_NOFILE to 8192, Invalid argument (22). Current limit still 1024.
2011-06-06 11:11:52: (critical) network-socket.c:397: bind(192.168.10.52:3306) failed: Address already in use (98)
2011-06-06 11:11:52: (critical) chassis.c:947: Failure from chassis_mainloop. Shutting down.
2011-06-06 11:11:52: (message) Initiating shutdown, requested from chassis.c:949
2011-06-06 11:11:52: (message) shutting down normally, exit code is: 1
2011-06-06 11:11:52: (message) chassis.c:210: [angel] PID=11845 exited normally with exit-code = 1 (it used 1 kBytes max)
2011-06-06 11:11:52: (message) Initiating shutdown, requested from chassis.c:350
2011-06-06 11:11:52: (message) shutting down normally, exit code is: 1

i dont know why he sad that

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Proxy Edit question
Assignee:
No assignee Edit question
Solved by:
Leith
Solved:
Last query:
Last reply:
Revision history for this message
Best Leith (mleith) said :
#1

It appears you already have something listening on port 3306 (perhaps the MySQL instance)?

2011-06-06 11:11:52: (critical) network-socket.c:397: bind(192.168.10.52:3306) failed: Address already in use (98)

Try setting the proxy port to something different, or switching the MySQL port first before starting proxy?

Revision history for this message
speckie (specie) said :
#2

yes that was the problem. I thought I had identified mysql.

Revision history for this message
speckie (specie) said :
#3

Thanks Leith, that solved my question.