Bind IP problem with GreenSQL
As I already described before that one of our site that I maintained is using GreenSQL.
We have split the Webserver and Database server.
By default, GreenSQL is using 127.0.0.1 to bind. So that it will have 127.0.0.1:3305 to connect
My problem is, it’s imposibble to use 127.0.0.1 because we have split the database server.
We have to install greensql-console
wget http://www.greensql.net/public/releases/greensql-console.0.4.4.tar.gz
tar zxvf greensql-console.0.4.4.tar.gz
After we extract the package, we should get a folder called greensql-console. Just copy that folder to your website root directory
cp -ra greensql-console /var/www
Then edit config.php and put the correct information of GreenSQL database. Then make folder templates_c word writeable (it’s the place to write cache)
chmod 777 templates_c
Then you can login to http://yourwebsite.com/greesql-console/
Login with the default username / password ( admin / pwd )
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.
You just need to specify 0.0.0.0 as a Frontent IP address instead of 127.0.0.1 and save your changes.