Home › Forums › General
 Database Security. Database Auditing. Database Caching. Database Masking. Get it now

Listener is 'DOWN'

Posted November 21st, 2008 by andino.alejandro
in

HI, I create a listener, and this is shown down

netstat -anp | grep green

tcp 0 0 127.0.0.1:3305 0.0.0.0:* LISTEN 5342/greensql-fw

No more listener's. I using vmware for this laboratory and greensql-fw_0.9.4
greensql-console_0.4.4

GreenSQL Console
-----------------------------
Listener settings
Name: Listener_Front01
Frontend: 192.168.61.131:3304
Backend: hosting_back01:3306
Status: Listener is 'DOWN'
Type: mysql

Listener settings
Name: Listener_Front02
Frontend: 192.168.61.132:3303
Backend: hosting_backt01:3306
Status: Listener is 'DOWN'
Type: mysql

GreenSQL Logs
-------------------------
[21/Nov/2008 16:01:16] NET_DEBUG Failed to bind server socket
[21/Nov/2008 16:01:16] NET_DEBUG Failed to bind server socket
[21/Nov/2008 16:01:06] NET_DEBUG Failed to bind server socket
[21/Nov/2008 16:01:06] NET_DEBUG Failed to bind server socket
[21/Nov/2008 16:00:56] NET_DEBUG Failed to bind server socket
[21/Nov/2008 16:00:56] NET_DEBUG Failed to bind server socket
[21/Nov/2008 16:00:46] NET_DEBUG Failed to bind server socket
[21/Nov/2008 16:00:46] NET_DEBUG Failed to bind server socket

Any idea ???

Thanks.

‹ FreeBSD-7.0? greensql-console patched ›

Comments

Hello Andiano, First, check

On November 21st, 2008 yuli says:

Hello Andiano,

First, check if 192.168.61.131 and 192.168.61.132 are configured as valid IPs in your virtual box (you see these IPs when you run /sbin/ifconfig).

Second, update greensql-console package. In the version you use, Listener status is not displayed correctly.

You can get latest version from here:
http://www.greensql.net/download

BTW. You gave me an excellent idea to display IP and port number in the bind error. I have just committed fix for this issue.

Thanks,
Yuli

Thanks for you reply Yuli.

On November 25th, 2008 andino.alejandro says:

Thanks for you reply Yuli. The ip address is valid.

I connect to a BackEnd (Mysql - GreenSQL) from my FrontEnd cross mysql-client in port 3306. Mysql-client en port 3305 is reflush conections.
# mysql -u root -p -h backend -P 3306 - OK from FrontEnd
# mysql -u root -p -h backend -P 3305 - DOWN from FrontEnd

I create two listener for this proposite before, Listener_Front01 and Listener_Front02.

My questions is, outside the greensql-console upgrade.

netstat -anp | grep green

Should not show

tcp 0 0 127.0.0.1:3305 0.0.0.0:* LISTEN 5342/greensql-fw -> default de GreenSQL
tcp 0 0 ip-backend:3306 0.0.0.0:* LISTEN 5342/greensql-fw
tcp 0 0 ip-backend:3307 0.0.0.0:* LISTEN 5342/greensql-fw

???

Now, I will make upgrade to my greensql-console.

Thank and sorry for my english.

My recommendations: 1.

On November 26th, 2008 yuli says:

My recommendations:

1. Update greensql-fw to a newer version.
2. Send the result of the following command:
/sbin/ifconfig | grep inet

Yuli

Back to top