New user using RPM |

Database Security. Database Auditing. Database Caching. Database Masking. Get it now

New user using RPM

Posted October 28th, 2008 by DougWare

General

Hello,

I'm not new to MySQL, but I seem to have hit a snag.

I've installed greensql using the RPM (on CentOS5) and successfully configured it so that the localhost can connect. However, I believe greensql is only binding to the localhost address, my other web servers can't connect anymore.

ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql.MYDOMAIN.com' (111)

Is there a setting to have it to bind to all addresses?

Thanks

Comments

I have similar problem.

On October 29th, 2008 gom3s says:

I have similar problem. (Debian user)
In my case mysql bind-address is an external one (not 127.0.0.1) and there is no way to connect to greensql from localhost. the error message appears :
RROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

OK. after clearing option

On October 29th, 2008 gom3s says:

OK. after clearing option bind-address in /etc/mysql/my.cnf it works just fine!! ;)

In order to configure

On October 29th, 2008 yuli says:

In order to configure GreenSQL to listen on all local IP addresses (not only 127.0.0.1) you simple need to change default listener settings.

GreenSQL Change Frontend IP Adreess

You just need to specify 0.0.0.0 as a Frontent IP address instead of 127.0.0.1 and save your changes.

I've installed the RPM and

On October 29th, 2008 DougWare says:

I've installed the RPM and the GUI isn't available to me.

I have two files to edit, /etc/greensql/greensql.conf and nano /etc/greensql/mysql.conf.

I believe I just need to know what the configuration directive is in greensql.conf that Frontend IP sets.

Thanks

There is not way to

On October 29th, 2008 yuli says:

There is not way to configure frontend ip using configuration files. You will have to install greensql-console package and do it from their.

Here you can find more info how to do it here:
http://www.greensql.net/howto
http://www.howtoforge.com/preventing-mysql-injection-attacks-with-greensql-on-debian-etch

GreenSQL