Green SQL Console

in

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

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 -p

and issue "show databases" command

2. Check application log. Run the following command:

tail /var/log/greensql.log

Back to top