Mysql

mysql - MySQL module

Synopsis
module mysql { hostname "localhost"; username "gridlabd"; password ""; schema "gridlabd"; port 3306; socketname "/tmp/mysql.sock"; clientflags COMPRESS|FOUND_ROWS|IGNORE_SIGPIPE|INTERACTIVE|LOCAL_FILES|MULTI_RESULTS|MULTI_STATEMENTS|NO_SCHEMA|ODBC|SSL|REMEMBER_OPTIONS; }

Description
The mysql module implements the principal tape module classes recorder, player, and collector in a property-compatible manner. For details on the functionality of these classes, see the tape module. The main difference between the tape implementation and the mysql implementation is that these classes can refer to a database connection if there is more than one connection in the GLM file.

hostname
The default server to use for a connection. See database hostname for details.

username
The default username to use for a connection. See database username for details.

password
The default password to use for a connection. See database password for details.

schema
The default schema to use for a connection. See database schema for details.

port
The default port to use for a connection. See database port for details.

socketname
The default socket name to use for a connection. See database socketname for details.

clientflags
The default client flags to use for a connection. See database clientflags for details.

Classes

 * database : Implements a connection to a MySQL server. There must be at least one defined in a model in order to use the recorder, player, or collector objects.
 * recorder : Implements a property recorder using the specified (or last) database connection.
 * player : Implements a property player using the specified (or last) database connection.
 * collector : Implements a property aggregate collector using the specified (or last) database connection.

Prerequisites
If you are using your local host as the MySQL server, you must install MySQL Server. After you have set up the server, you should create the user gridlabd and grant that user permission to create databases if you intend to use the default connection parameters.


 * Windows Systems
 * You must include the MySQL client library in the PATH environment variable.


 * Linux/MacOSX Systems:
 * You must include the MySQL client library in the (DY)LD_LIBRARY_PATH environment variable.

Although it is not required, use of the MySQL Workbench is highly recommended to facilitate managing and reviewing the results from GridLAB-D's mysql module.

Bugs
On Windows 7 it is a common problem that GridLAB-D cannot find libmysql.dll when the module mysql directive is parsed in a GLM file, regardless of the PATH environment variable. The only solution seems to be to include the MySQL Connector library folder in GLPATH or to copy the file libmysql.dll to the GridLAB-D library folder.

Version
The mysql module was introduced in.