Tips and FAQ

MySQL - Database connection

If you are having trouble connecting to your database, check your config file to make sure the port and bind-address have been set.

Example Config:

/etc/mysql/my.cnf
port = 3306
bind-address           = 127.0.0.1 localhost
#bind-address           = 159.203.5.166 external

In this example, the localhost bind-address is not commented out so it will be used as the db.host value in the POST /instance configuration. The port is set to 3306. In this case when you authenticate an element instance, use 127.0.0.1:3306 as the value for db.host.

If you want to expose the external bind-address, then comment out the localhost bind-address.

If you want to expose both sources (localhost and external), then comment out both addresses.

Supported SQL Commands for MySQL and MSSQL

For MySQL and MSSQL database elements, only DML operations are supported and default its auto COMMIT and there is no option of ROLLBACK.

DDL and DCL are not supported.