Below are some commonly occurring issues and their solutions:
- Ensure you can connect to the database with the host, port, database, user name, and password using the database client. See specific database documentation for proper security and connection information, and for the usage of the database client.
- If you try to list the tables and nothing happens, check the FME log file. There may have been an underlying error that didn’t generate a dialog. Usually this means a parameter does not exist or permissions are not sufficient to access the requested resource.
- When using a UNIX operating system, the environment variables MYSQL_HOST, MYSQL_TCP_PORT, USER and MYSQL_PWD can be used to specify the connection parameters.
- If you receive an error similar to “Lost connection to the server during query” or “the server has gone away”, you may have to increase your maximum allowed packet size server variable. This can be done by editing the my .ini file in the server installation folder. The line to edit, or add if not present, is:
max_allowed_packets=8M
The default is 1M, meaning maximum packet size is 1 MB. Safe Software recommends 8MB (8M) or more if you are reading or writing large geometric features or large blob or text values.
- Various other issues may arise depending on the values of the various option files permitted for a database and for specific servers.
- You can also try reading about common problems at http://dev.mysql.com/doc/mysql/en/problems.html and http://mariadb.com/kb/en/mariadb/troubleshooting-connection-issues/.