Green SQL Console
Ok, I downloaded the new console release and installed it, was able to login just fine, but the database I added for it to check...it isnt checking.
I think it has something to do with the Listeners.
I have it set up to the following:
Frontend IP: MY MAIN IP (removed for security)
Frontend port: 3305
Backend server name: localhost
Backend IP: 127.0.0.1
Backend port: 3306
It says this in the database section:
Database: MY DATABASE (removed for security)
Listener settings
Name: Default Proxy
Frontend: MY.MAIN.IP:3305
Backend: localhost:3306
Status: Listener is 'OK'
Type: mysql
Change listener settings
Database permissions:
Change database structure: blocked
Create command: blocked
Disclose table stucture: blocked
Drop command: blocked
Other sensitive commands: blocked
Change database settings
GreenSQL










Comments
1. Check if you can connect
1. Check if you can connect to the server:
mysql -h 127.0.0.1 -P 3305 -u root -pand issue "show databases" command
2. Check application log. Run the following command:
tail /var/log/greensql.log