Re: haproxy can't bind to mysql port

2015-07-25 Thread Tim Dunphy
By run I meant you have to start it as root user which you are doing anyway. Can you run: # nc -l -p 80 as root just to confirm you can bind to port 80? If I stop haproxy and run that command this is what I get: [root@ha1:~] #nc -l -p 80 POST

Re: haproxy can't bind to mysql port

2015-07-25 Thread Igor Cicimov
By run I meant you have to start it as root user which you are doing anyway. Can you run: # nc -l -p 80 as root just to confirm you can bind to port 80? On 25/07/2015 2:10 PM, Igor Cicimov ig...@encompasscorporation.com wrote: You need to run haproxy as root to bind to ports lower than 1024

Re: haproxy can't bind to mysql port

2015-07-25 Thread Gmail
Also, lsof output shows PID = 11653 and the user/owner/launcher of the process = haproxy. cheers, ; Yuan On 07/26/2015 12:13 AM, Gmail wrote: I am uncertain about syntax but the diff is appname of sorts for the port 80 listener. Someone may comment with more details ; Earlier = *listen

Re: haproxy can't bind to mysql port

2015-07-25 Thread Tim Dunphy
You need to run haproxy as root to bind to ports lower than 1024 I tried running haproxy as root/root: [root@ha1:/etc/haproxy] #egrep user|group haproxy.cfg| grep -v option user root group root Then restarted the service. No difference! [root@ha1:/etc/haproxy] #systemctl restart

Re: haproxy can't bind to mysql port

2015-07-25 Thread Tim Dunphy
Yuan, maybe something here http://lnxmon.com/haproxy/ Thanks, ; Yuan I modified a config from your blog that you showed me and came up with this: global log 127.0.0.1 local0 notice maxconn 2000 user haproxy group haproxy defaults log global modehttp

Re: haproxy can't bind to mysql port

2015-07-25 Thread Gmail
I am uncertain about syntax but the diff is appname of sorts for the port 80 listener. Someone may comment with more details ; Earlier = *listen 0.0.0.0:80 [ no app name string ] Now= listen jokefire 0.0.0.0:80 [ app name == jokefire and also no astrisk visible ] Maybe

Re: haproxy can't bind to mysql port

2015-07-24 Thread Tim Dunphy
Hi there Igor, How did you do that? By putting the haproxy's security group or the haproxy's ip to the mysql group inbound rule? Sorry but which non local IP is that? I put the external IP of the haproxy server into the security group on the mysql server. In this case the external IP

Re: haproxy can't bind to mysql port

2015-07-24 Thread Nenad Merdanovic
Hello Tim, On Fri, Jul 24, 2015 at 1:46 PM, Tim Dunphy bluethu...@gmail.com mailto:bluethu...@gmail.com wrote: listen mysql-cluster bind 127.0.0.1:3306 http://127.0.0.1:3306 mode tcp option mysql-check user haproxy_check

Re: haproxy can't bind to mysql port

2015-07-24 Thread Tim Dunphy
Hello Nenad, Jul 24 03:44:18 ha1 haproxy-systemd-wrapper[25034]: [ALERT] 204/034418 (25035) : *Starting proxy mysql-cluster: cannot bind s...:3306]* Nothing listening on the port I'm trying to bind to: 3306 [root@ha1:~] #ss -lpt | fgrep 3306 [root@ha1:~] #lsof -i :3306

Re: haproxy can't bind to mysql port

2015-07-24 Thread Gmail
Nice. Do you use selinux in prod. regards, ; Yuan On 07/25/2015 09:17 AM, Tim Dunphy wrote: Bingo!!! The problem was with SELinux. Not sure what took me so long to think of it...!!! So set the mysql listener back to port 3306. Turned off SELinux with setenforce 0. Then it started right up!!!

Re: haproxy can't bind to mysql port

2015-07-24 Thread Tim Dunphy
Hi Yuan, Nice. Do you use selinux in prod. regards, ; Yuan Yep! Actually I use it every chance I get. Prod/stage/dev and my own hobby environments. And right now actually what I was discussing was a hobby environment. And actually if I could bother you guys one more time, I do have one more

Re: haproxy can't bind to mysql port

2015-07-24 Thread Igor Cicimov
You need to run haproxy as root to bind to ports lower than 1024 On 25/07/2015 1:36 PM, Tim Dunphy bluethu...@gmail.com wrote: Hi Yuan, Nice. Do you use selinux in prod. regards, ; Yuan Yep! Actually I use it every chance I get. Prod/stage/dev and my own hobby environments. And right

Re: haproxy can't bind to mysql port

2015-07-24 Thread Gmail
maybe something here http://lnxmon.com/haproxy/ Thanks, ; Yuan On 07/25/2015 12:10 PM, Igor Cicimov wrote: You need to run haproxy as root to bind to ports lower than 1024 On 25/07/2015 1:36 PM, Tim Dunphy bluethu...@gmail.com wrote: Hi Yuan, Nice. Do you use selinux in prod. regards, ;

Re: haproxy can't bind to mysql port

2015-07-24 Thread Tim Dunphy
Bingo!!! The problem was with SELinux. Not sure what took me so long to think of it...!!! So set the mysql listener back to port 3306. Turned off SELinux with setenforce 0. Then it started right up!!! And port 3306 was listening. Then I consulted with audit2why and saw the following: type=AVC

Re: haproxy can't bind to mysql port

2015-07-23 Thread Igor Cicimov
On Fri, Jul 24, 2015 at 1:46 PM, Tim Dunphy bluethu...@gmail.com wrote: Hi all, I'm attempting to setup mysql load balancing using HA/Proxy. Seemed pretty straight forward at first. I'm using Amazon ec2 for all nodes. First I made sure that the haproxy nodes could contact the mysql boxes